# View: Selection Criteria Header

RotoID: AP0035
Table: APSLH
DLL: APSLH

## Compositions: 2

RotoID | Table | 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 Check Amount | E A |
AMTMAXCHK | 21 | BCD*10.3 | Maximum Check 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 | Check 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 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.