View: Selection Criteria Header

RotoID: AP0035
Table: APSLH
Protocol: Header
DLL:APSLH

Compositions: 2

RotoID Tables Title DLL
AP0036 APSLD Selection Criteria Details APSLD
AP0411 APSLHO Selection Criteria Opt. Fields APSLHO

Keys: 1

Title Fields
Selection Criteria Header Key IDSELECT

Fields: 50

Field Index Type Title Attributes Presentation
IDSELECT 1 String*6 Selection Criteria E A K R  Mask: %-6N
DATELASMNT 2 Date Date Last Maintained E A C 
SWDOCSPROC 3 Integer Documents to Process E A  List:2 entries
0 = Process all documents
1 = Process forced documents only
SWSELLBY 4 Integer Select Documents by E A  List:3 entries
0 = Due Date
1 = Discount Date
2 = Due Date or Discount Date
DATEDUE 5 Date Date Due E A 
DTEDISCFRM 6 Date From Discount Date E A 
IDGRPFROM 7 String*6 From Group Code E A  Mask: %-6N
IDGRPTHRU 8 String*6 Thru Group Code E A  Mask: %-6N
IDVENDFROM 9 String*12 From Vendor Number E A  Mask: %-12C
IDVENDTHRU 10 String*12 Thru Vendor Number E A  Mask: %-12C
ACCTSETFR 11 String*6 From Account Set E A  Mask: %-6N
ACCTSETTHR 12 String*6 Thru Account Set E A  Mask: %-6N
SWVENDEXCL 13 Integer Exclude Vendor E A  List:2 entries
0 = No
1 = Yes
IDBANKASGN 14 String*8 Reserved E 
CODECURNTC 15 String*3 Vendor Currency Code E A  Mask: %-3N
IDBANKPAYM 16 String*8 Payment Bank Code E A  Mask: %-8N
CODECURNPY 17 String*3 Bank Currency Code E A  Mask: %-3N
AMTBNKLIMT 19 BCD*10.3 Reserved E 
AMTMINCHK 20 BCD*10.3 Minimum Payment Amount E A 
AMTMAXCHK 21 BCD*10.3 Maximum Payment Amount E A 
SWBANKMTCH 22 Integer Bank Match E A  List:2 entries
0 = Vendors with any bank code
1 = Vendors with payment bank code only
DATECHECK 23 Date Payment Date E A 
DATEINACT 24 Date Inactive Date E A 
SWACTV 25 Integer Status E A  List:2 entries
0 = Inactive
1 = Active
CODERATETC 26 String*2 Vendor Rate Type E A  Mask: %-2N
CODERATEBC 27 String*2 Bank Rate Type E A  Mask: %-2N
EXCHRATETC 28 BCD*8.7 Vendor Exchange Rate E A 
EXCHRATEBC 29 BCD*8.7 Bank Exchange Rate E A 
RATEDATETC 30 Date Vendor Rate Date E A 
RATEDATEBC 31 Date Bank Rate Date E A 
CSVFILE 32 String*100 CSV Filename E A 
TEXTDESC 33 String*60 Description E A 
DTEDISCTHR 34 Date Thru Discount Date E A 
DTEBATCH 35 Date Batch Date E A 
RATEOPTC 36 Integer Vendor Rate Operator E A 
RATEOPBC 37 Integer Bank Rate Operator E A 
SWRATETC 38 Integer Vendor Rate Overridden E A 
SWRATEBC 39 Integer Bank Rate Overridden E A 
APPLYMETH 40 Integer Job Apply Method E A  List:2 entries
0 = Prorate by Amount
1 = Top Down
IDSELECTED 41 String*6 Generated Selection Criteria E A  Mask: %-6N
VALUES 42 Long Optional Fields E A C 
PROCESSCMD 43 Integer Process Command Code E A C  List:1 entries
0 = Insert Optional Fields
PMCODEFROM 44 String*12 From Payment Code E A  Mask: %-12N
PMCODETHRU 45 String*12 Thru Payment Code E A  Mask: %-12N
OPTFIELD 46 String*12 Optional Field E A  Mask: %-12N
TYPE 47 Integer Type E A C  List:7 entries
1 = Text
100 = Amount
6 = Number
8 = Integer
9 = Yes/No
3 = Date
4 = Time
LENGTH 48 Integer Length E A C 
DECIMALS 49 Integer Decimals E A C 
VALUEFROM 50 String*60 From Optional Field Value E A 
VALUETHRU 51 String*60 Thru Optional Field Value E A 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).