Table: Selection Criteria Header

Table: APSLH
View: AP0035
Record length: 547
Flags: A R 

Keys: 1

Title  Flags  Fields

Selection Criteria Header Key  IDSELECT

Fields: 53

Field  Type  Title  Presentation 

IDSELECT  String*6  Selection Criteria  Mask: %-6N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DATELASMNT  Date  Date Last Maintained   
SWDOCSPROC  Integer  Documents to Process  List: 2 entries
0=Process all documents
1=Process forced documents only
SWSELLBY  Integer  Select Documents by  List: 3 entries
0=Due Date
1=Discount Date
2=Due Date or Discount Date
DATEDUE  Date  Date Due   
DTEDISCFRM  Date  From Discount Date   
IDGRPFROM  String*6  From Group Code  Mask: %-6N
IDGRPTHRU  String*6  Thru Group Code  Mask: %-6N
IDVENDFROM  String*12  From Vendor Number  Mask: %-12C
IDVENDTHRU  String*12  Thru Vendor Number  Mask: %-12C
ACCTSETFR  String*6  From Account Set  Mask: %-6N
ACCTSETTHR  String*6  Thru Account Set  Mask: %-6N
SWVENDEXCL  Integer  Exclude Vendor  List: 2 entries
0=No
1=Yes
IDBANKASGN  String*8  Reserved   
CODECURNTC  String*3  Vendor Currency Code  Mask: %-3N
IDBANKPAYM  String*8  Payment Bank Code  Mask: %-8N
CODECURNPY  String*3  Bank Currency Code  Mask: %-3N
AMTBNKLIMT  BCD*10.3  Reserved   
AMTMINCHK  BCD*10.3  Minimum Payment Amount   
AMTMAXCHK  BCD*10.3  Maximum Payment Amount   
SWBANKMTCH  Integer  Bank Match  List: 2 entries
0=Vendors with any bank code
1=Vendors with payment bank code only
DATECHECK  Date  Payment Date   
DATEINACT  Date  Inactive Date   
SWACTV  Integer  Status  List: 2 entries
0=Inactive
1=Active
CODERATETC  String*2  Vendor Rate Type  Mask: %-2N
CODERATEBC  String*2  Bank Rate Type  Mask: %-2N
EXCHRATETC  BCD*8.7  Vendor Exchange Rate   
EXCHRATEBC  BCD*8.7  Bank Exchange Rate   
RATEDATETC  Date  Vendor Rate Date   
RATEDATEBC  Date  Bank Rate Date   
CSVFILE  String*100  CSV Filename   
TEXTDESC  String*60  Description   
DTEDISCTHR  Date  Thru Discount Date   
DTEBATCH  Date  Batch Date   
RATEOPTC  Integer  Vendor Rate Operator   
RATEOPBC  Integer  Bank Rate Operator   
SWRATETC  Integer  Vendor Rate Overridden   
SWRATEBC  Integer  Bank Rate Overridden   
APPLYMETH  Integer  Job Apply Method  List: 2 entries
0=Prorate by Amount
1=Top Down
IDSELECTED  String*6  Generated Selection Criteria  Mask: %-6N
VALUES  Long  Optional Fields   
PMCODEFROM  String*12  From Payment Code  Mask: %-12N
PMCODETHRU  String*12  Thru Payment Code  Mask: %-12N
OPTFIELD  String*12  Optional Field  Mask: %-12N
TYPE  Integer  Type  List: 7 entries
1=Text
100=Amount
6=Number
8=Integer
9=Yes/No
3=Date
4=Time
LENGTH  Integer  Length   
DECIMALS  Integer  Decimals   
VALUEFROM  String*60  From Optional Field Value   
VALUETHRU  String*60  Thru Optional Field Value   

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.