# View: Age Documents

RotoID: AR0055
Protocol: Superview
DLL: ARAGE

## Compositions: 0

## Keys: 0

## Fields: 100

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
CMNDCODE | 1 | Integer | Command Code | E A | List: 5 entries
1 | = | Setup
51 | = | Generate Sorted Work File
52 | = | Generate Unsorted Work File
61 | = | Single Age Calculation
71 | = | Bucket Total Calculation
CUSTID | 2 | String*12 | Customer Number | E A | Mask: %-12C
BUSDATE | 3 | Date | Posting Date | E A |
INVOICEID | 4 | String*22 | Document Number | E A | Mask: %-22C
RMITID | 5 | String*24 | Check/Receipt No. | E A | Mask: %-24C
TRXTYPETXT | 6 | Integer | Document Type | E A |
TRXTYPEID | 7 | Integer | Transaction Type | E A |
OBLAMTDUET | 8 | BCD*10.3 | Amount Due (Source) | E A |
OBLAMTDUEH | 9 | BCD*10.3 | Amount Due (Functional) | E A |
INVCBEGNDT | 10 | Date | Starting Invoice Date | E A |
DUEDATE | 11 | Date | Due Date | E A |
RUNDATE | 12 | Date | Age as-of Date | E A |
CUTOFFDATE | 13 | Date | Cutoff Date | E A |
AGEINVDTSW | 14 | Integer | Age by | E A | List: 2 entries
0 | = | Due Date
1 | = | Document Date
INCLPAIDSW | 15 | Integer | Age Fully Paid Documents | E A | List: 2 entries
0 | = | Excluded
1 | = | Included
ZEROBALSW | 16 | Integer | Include Zero Balances | E A | List: 2 entries
0 | = | Excluded
1 | = | Included
PASTDUESW | 17 | Integer | Report Type | E A | List: 2 entries
0 | = | Aged Trial Balance
1 | = | Overdue Receivable
AGEPERIOD1 | 18 | BCD*3.0 | Current | E A |
AGEPERIOD2 | 19 | BCD*3.0 | First Period | E A |
AGEPERIOD3 | 20 | BCD*3.0 | Second Period | E A |
AGEPERIOD4 | 21 | BCD*3.0 | Third Period | E A |
AGEPERIOD5 | 22 | BCD*3.0 | Fourth Period | E A |
AGEPERIOD6 | 23 | BCD*3.0 | First Forward Period | E A |
AGEPERIOD7 | 24 | BCD*3.0 | Second Forward Period | E A |
AGEPERIOD8 | 25 | BCD*3.0 | Third Forward Period | E A |
AGEPERIOD9 | 26 | BCD*3.0 | Fourth Forward Period | E A |
SWCUSTCRLM | 27 | Integer | Include Over Credit Limit | E A | List: 2 entries
0 | = | All Customers
1 | = | Only
IDFROM1 | 28 | String*60 | Range 1 From | E A |
IDTO1 | 29 | String*60 | Range 1 To | E A |
INDEX1 | 30 | Integer | Range 1 Type | E A |
IDFROM2 | 31 | String*60 | Range 2 From | E A |
IDTO2 | 32 | String*60 | Range 2 To | E A |
INDEX2 | 33 | Integer | Range 2 Type | E A |
IDFROM3 | 34 | String*60 | Range 3 From | E A |
IDTO3 | 35 | String*60 | Range 3 To | E A |
INDEX3 | 36 | Integer | Range 3 Type | E A |
IDFROM4 | 37 | String*60 | Range 4 From | E A |
IDTO4 | 38 | String*60 | Range 4 To | E A |
INDEX4 | 39 | Integer | Range 4 Type | E A |
DAYSOUTFRM | 40 | BCD*3.0 | Number of Days Outstanding From | E A |
DAYSOUTTO | 41 | BCD*3.0 | Number of Days Outstanding To | E A |
AMTDUE1TC | 42 | BCD*10.3 | Current Amount Due (Source) | E A |
AMTDUE1HC | 43 | BCD*10.3 | Current Amount Due (Functional) | E A |
DATEDUE1 | 44 | Date | Current Date | E A |
AMTDUE2TC | 45 | BCD*10.3 | Period 1 Amount Due (Source) | E A |
AMTDUE2HC | 46 | BCD*10.3 | Period 1 Amount Due (Functional) | E A |
DATEDUE2 | 47 | Date | Period 1 Date | E A |
AMTDUE3TC | 48 | BCD*10.3 | Period 2 Amount Due (Source) | E A |
AMTDUE3HC | 49 | BCD*10.3 | Period 2 Amount Due (Functional) | E A |
DATEDUE3 | 50 | Date | Period 2 Date | E A |
AMTDUE4TC | 51 | BCD*10.3 | Period 3 Amount Due (Source) | E A |
AMTDUE4HC | 52 | BCD*10.3 | Period 3 Amount Due (Functional) | E A |
DATEDUE4 | 53 | Date | Period 3 Date | E A |
AMTDUE5TC | 54 | BCD*10.3 | Period 4 Amount Due (Source) | E A |
AMTDUE5HC | 55 | BCD*10.3 | Period 4 Amount Due (Functional) | E A |
DATEDUE5 | 56 | Date | Period 4 Date | E A |
AMTDUE6TC | 57 | BCD*10.3 | Period 5 Amount Due (Source) | E A |
AMTDUE6HC | 58 | BCD*10.3 | Period 5 Amount Due (Functional) | E A |
DATEDUE6 | 59 | Date | Period 5 Date | E A |
AMTDUE7TC | 60 | BCD*10.3 | Period 6 Amount Due (Source) | E A |
AMTDUE7HC | 61 | BCD*10.3 | Period 6 Amount Due (Functional) | E A |
DATEDUE7 | 62 | Date | Period 6 Date | E A |
AMTDUE8TC | 63 | BCD*10.3 | Period 7 Amount Due (Source) | E A |
AMTDUE8HC | 64 | BCD*10.3 | Period 7 Amount Due (Functional) | E A |
DATEDUE8 | 65 | Date | Period 7 Date | E A |
AMTDUE9TC | 66 | BCD*10.3 | Period 8 Amount Due (Source) | E A |
AMTDUE9HC | 67 | BCD*10.3 | Period 8 Amount Due (Functional) | E A |
DATEDUE9 | 68 | Date | Period 8 Date | E A |
CNTPERDDUE | 69 | BCD*3.0 | Period Open Item Schedule Due | E A |
TOTBKWDTC | 70 | BCD*10.3 | Total Backward Aging (Source) | E A |
TOTBKWDHC | 71 | BCD*10.3 | Total Backward Aging (Functional) | E A |
TOTFWDTC | 72 | BCD*10.3 | Total Forward Aging (Source) | E A |
TOTFWDHC | 73 | BCD*10.3 | Total Forward Aging (Functional) | E A |
SWOPTMETER | 74 | Integer | Display Meter | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWMATCHING | 75 | Integer | Include Applied Details | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWACCTTYPE | 76 | Integer | Customer Account Type | E A |
SWCUTOFFBY | 77 | Integer | Cutoff By | E A | List: 3 entries
0 | = | Doc. Date
1 | = | Posting Date
2 | = | Year/Period
CUTOFFYEAR | 78 | String*4 | Year | E A | Mask: %04D
CUTOFFPERD | 79 | String*2 | Period | E A | Mask: %02D
FIELDNAME1 | 80 | String*19 | Field Name 1 | E A |
FIELDNAME2 | 81 | String*19 | Field Name 2 | E A |
FIELDNAME3 | 82 | String*19 | Field Name 3 | E A |
FIELDNAME4 | 83 | String*19 | Field Name 4 | E A |
SWPREPAYMT | 84 | Integer | Include Prepayment | E A | List: 2 entries
0 | = | No
1 | = | Yes
AGESEQ | 85 | Long | Aging Sequence Number | E A |
SORTINDEX1 | 86 | Integer | Sort Field Index 1 | E A |
SORTINDEX2 | 87 | Integer | Sort Field Index 2 | E A |
SORTINDEX3 | 88 | Integer | Sort Field Index 3 | E A |
SORTINDEX4 | 89 | Integer | Sort Field Index 4 | E A |
SORTNAME1 | 90 | String*19 | Sort Field Name 1 | E A |
SORTNAME2 | 91 | String*19 | Sort Field Name 2 | E A |
SORTNAME3 | 92 | String*19 | Sort Field Name 3 | E A |
SORTNAME4 | 93 | String*19 | Sort Field Name 4 | E A |
SWINVOICE | 94 | Integer | Include Invoice | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWDEBIT | 95 | Integer | Include Debit Note | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWCREDIT | 96 | Integer | Include Credit Note | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWINTEREST | 97 | Integer | Include Interest | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWUNAPCASH | 98 | Integer | Include Unapplied Cash | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWRECEIPT | 99 | Integer | Include Receipt | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWREFUND | 100 | Integer | Include Refund | E A | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2008-May-01

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