# View: Age Documents

RotoID: AP0043
Table:
DLL: APAGE

## Compositions: 0

## Keys: 0

## Fields: 82

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
CMNDCODE | 1 | Integer | Command Code | E A | List: 3 entries
1 | = | Setup
51 | = | Generate Work File
61 | = | Single Age Calculation
IDVEND | 2 | String*12 | Vendor Number | E A | Mask: %-12C
BUSDATE | 3 | Date | Business Date | E A |
INVOICEID | 4 | String*22 | Document Number | E A | Mask: %-22C
IDRMIT | 5 | String*12 | Check Number | E A | Mask: %-12D
TRXTYPETXT | 6 | Integer | Transaction Type | E A |
TRXTYPEID | 7 | Integer | Transaction Description | E A |
OBLAMTDUE | 8 | BCD*10.3 | Amount Due | E A |
INVCBEGNDT | 9 | Date | Starting Invoice Date | E A |
DUEDATE | 10 | Date | Due Date | E A |
RUNDATE | 11 | Date | Age as-of Date | E A |
CUTOFFDATE | 12 | Date | Cutoff Date | E A |
AGEINVDTSW | 13 | Integer | Due Date / Invoice Date | E A | List: 2 entries
0 | = | Due Date
1 | = | Document Date
INCLOBLHLD | 14 | Integer | Include Payments On Hold | E A | List: 2 entries
0 | = | No
1 | = | Yes
ZEROBALSW | 15 | Integer | Include Zero Balances | E A | List: 2 entries
0 | = | No
1 | = | Yes
PASTDUESW | 16 | Integer | ATB / Overdue Rec. Report | E A | List: 3 entries
0 | = | Aged Payables
1 | = | Overdue Payables
2 | = | Aged Cash Requirements
AGEPERIOD1 | 17 | BCD*3.0 | Current | E A |
AGEPERIOD2 | 18 | BCD*3.0 | First Period | E A |
AGEPERIOD3 | 19 | BCD*3.0 | Second Period | E A |
AGEPERIOD4 | 20 | BCD*3.0 | Third Period | E A |
AGEPERIOD5 | 21 | BCD*3.0 | Fourth Period | E A |
AGEPERIOD6 | 22 | BCD*3.0 | First Forward Period | E A |
AGEPERIOD7 | 23 | BCD*3.0 | Second Forward Period | E A |
AGEPERIOD8 | 24 | BCD*3.0 | Third Forward Period | E A |
AGEPERIOD9 | 25 | BCD*3.0 | Fourth Forward Period | E A |
SWCUSTCRLM | 26 | Integer | Include Over Credit Limit | E A | List: 2 entries
0 | = | No
1 | = | Yes
IDFROM1 | 27 | String*60 | Range 1 From | E A |
IDTO1 | 28 | String*60 | Range 1 To | E A |
INDEX1 | 29 | Integer | Range 1 Index Value | E A |
IDFROM2 | 30 | String*60 | Range 2 From | E A |
IDTO2 | 31 | String*60 | Range 2 To | E A |
INDEX2 | 32 | Integer | Range 2 Index Value | E A |
IDFROM3 | 33 | String*60 | Range 3 From | E A |
IDTO3 | 34 | String*60 | Range 3 To | E A |
INDEX3 | 35 | Integer | Range 3 Index Value | E A |
IDFROM4 | 36 | String*60 | Range 4 From | E A |
IDTO4 | 37 | String*60 | Range 4 To | E A |
INDEX4 | 38 | Integer | Range 4 Index Value | E A |
AMTDUE1TC | 39 | BCD*10.3 | Current Amount Due (Source) | E A |
AMTDUE1HC | 40 | BCD*10.3 | Current Amount Due (Functional) | E A |
DATEDUE1 | 41 | Date | Current Date | E A |
AMTDUE2TC | 42 | BCD*10.3 | Period 1 Amount Due (Source) | E A |
AMTDUE2HC | 43 | BCD*10.3 | Period 1 Amount Due (Functional) | E A |
DATEDUE2 | 44 | Date | Period 1 Date | E A |
AMTDUE3TC | 45 | BCD*10.3 | Period 2 Amount Due (Source) | E A |
AMTDUE3HC | 46 | BCD*10.3 | Period 2 Amount Due (Functional) | E A |
DATEDUE3 | 47 | Date | Period 2 Date | E A |
AMTDUE4TC | 48 | BCD*10.3 | Period 3 Amount Due (Source) | E A |
AMTDUE4HC | 49 | BCD*10.3 | Period 3 Amount Due (Functional) | E A |
DATEDUE4 | 50 | Date | Period 3 Date | E A |
AMTDUE5TC | 51 | BCD*10.3 | Period 4 Amount Due (Source) | E A |
AMTDUE5HC | 52 | BCD*10.3 | Period 4 Amount Due (Functional) | E A |
DATEDUE5 | 53 | Date | Period 4 Date | E A |
AMTDUE6TC | 54 | BCD*10.3 | Period 5 Amount Due (Source) | E A |
AMTDUE6HC | 55 | BCD*10.3 | Period 5 Amount Due (Functional) | E A |
DATEDUE6 | 56 | Date | Period 5 Date | E A |
AMTDUE7TC | 57 | BCD*10.3 | Period 6 Amount Due (Source) | E A |
AMTDUE7HC | 58 | BCD*10.3 | Period 6 Amount Due (Functional) | E A |
DATEDUE7 | 59 | Date | Period 6 Date | E A |
AMTDUE8TC | 60 | BCD*10.3 | Period 7 Amount Due (Source) | E A |
AMTDUE8HC | 61 | BCD*10.3 | Period 7 Amount Due (Functional) | E A |
DATEDUE8 | 62 | Date | Period 7 Date | E A |
AMTDUE9TC | 63 | BCD*10.3 | Period 8 Amount Due (Source) | E A |
AMTDUE9HC | 64 | BCD*10.3 | Period 8 Amount Due (Functional) | E A |
DATEDUE9 | 65 | Date | Period 8 Date | E A |
CNTPERDDUE | 66 | BCD*3.0 | Period Open Item Schedule Due | E A |
TOTBKWDTC | 67 | BCD*10.3 | Total Backward Aging (Source) | E A |
TOTBKWDHC | 68 | BCD*10.3 | Total Backward Aging (Functional | E A |
TOTFWDTC | 69 | BCD*10.3 | Total Forward Aging (Source) | E A |
TOTFWDHC | 70 | BCD*10.3 | Total Forward Aging (Functional) | E A |
SWOPTMETER | 71 | Integer | Display Meter | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWMATCHING | 72 | Integer | Include Applied Details | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAKEAVDISC | 73 | Integer | Take all Available Discounts | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWCUTOFFBY | 74 | Integer | Cutoff by | E A | List: 2 entries
0 | = | Doc. Date
1 | = | Year/Period
CUTOFFYEAR | 75 | String*4 | Year | E A | Mask: %04D
CUTOFFPERD | 76 | String*2 | Period | E A | Mask: %02D
FIELDNAME1 | 77 | String*19 | Field Name 1 | E A |
FIELDNAME2 | 78 | String*19 | Field Name 2 | E A |
FIELDNAME3 | 79 | String*19 | Field Name 3 | E A |
FIELDNAME4 | 80 | String*19 | Field Name 4 | E A |
SWPREPAYMT | 81 | Integer | Include Prepayments | E A | List: 2 entries
0 | = | No
1 | = | Yes
AGESEQ | 82 | Long | Aging Sequence Number | E A |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.