# View: Aged Documents

RotoID: AR0125
Table: ARAGED
DLL: ARAGED

## Compositions: 0

## Keys: 1

Title | Fields
--- | ---
Primary Key | AGESEQ, RECORDNO, IDCUST, IDINVC, RECTYPE, CNTSEQ

## Fields: 39

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
AGESEQ | 1 | Long | Aging Sequence Number | E A K R |
RECORDNO | 2 | Long | Record Number | E A K R |
IDCUST | 3 | String*12 | Customer Number | E A K R | Mask: %-12C
IDINVC | 4 | String*22 | Document Number | E A K R | Mask: %-22C
RECTYPE | 5 | Integer | Record Type | E A K R | List: 2 entries
0 | = | Document
1 | = | Applied Detail
CNTSEQ | 6 | Long | Detail Sequence Number | E A K R |
IDRMIT | 7 | String*24 | Check/Receipt Number | E A | Mask: %-24C
TRXTYPETXT | 8 | Integer | Document Type | E A |
TRXTYPEID | 9 | Integer | Transaction Type | E A |
DATEINVC | 10 | Date | Document Date | E A |
DATEBUS | 11 | Date | Business Date | E A |
DATEDUE | 12 | Date | Due Date | E A |
IDMEMOXREF | 13 | String*22 | Reference Document No. | E A |
AMTINVCTC | 14 | BCD*10.3 | Invoice Amount (Source) | E A |
AMTINVCHC | 15 | BCD*10.3 | Invoice Amount (Functional) | E A |
AMTDUE1TC | 16 | BCD*10.3 | Current Amount Due (Source) | E A |
AMTDUE1HC | 17 | BCD*10.3 | Current Amount Due (Functional) | E A |
AMTDUE2TC | 18 | BCD*10.3 | Period 1 Amount Due (Source) | E A |
AMTDUE2HC | 19 | BCD*10.3 | Period 1 Amount Due (Functional) | E A |
AMTDUE3TC | 20 | BCD*10.3 | Period 2 Amount Due (Source) | E A |
AMTDUE3HC | 21 | BCD*10.3 | Period 2 Amount Due (Functional) | E A |
AMTDUE4TC | 22 | BCD*10.3 | Period 3 Amount Due (Source) | E A |
AMTDUE4HC | 23 | BCD*10.3 | Period 3 Amount Due (Functional) | E A |
AMTDUE5TC | 24 | BCD*10.3 | Period 4 Amount Due (Source) | E A |
AMTDUE5HC | 25 | BCD*10.3 | Period 4 Amount Due (Functional) | E A |
AMTDUE6TC | 26 | BCD*10.3 | Period 5 Amount Due (Source) | E A |
AMTDUE6HC | 27 | BCD*10.3 | Period 5 Amount Due (Functional) | E A |
AMTDUE7TC | 28 | BCD*10.3 | Period 6 Amount Due (Source) | E A |
AMTDUE7HC | 29 | BCD*10.3 | Period 6 Amount Due (Functional) | E A |
AMTDUE8TC | 30 | BCD*10.3 | Period 7 Amount Due (Source) | E A |
AMTDUE8HC | 31 | BCD*10.3 | Period 7 Amount Due (Functional) | E A |
AMTDUE9TC | 32 | BCD*10.3 | Period 9 Amount Due (Source) | E A |
AMTDUE9HC | 33 | BCD*10.3 | Period 9 Amount Due (Functional) | E A |
TOTBKWDTC | 34 | BCD*10.3 | Total Backward Aging (Source) | E A |
TOTBKWDHC | 35 | BCD*10.3 | Total Backward Aging (Functional | E A |
TOTFWDTC | 36 | BCD*10.3 | Total Forward Aging (Source) | E A |
TOTFWDHC | 37 | BCD*10.3 | Total Forward Aging (Functional) | E A |
AMTBALDUET | 38 | BCD*10.3 | Customer Balance Due (Source) | E A |
AMTBALDUEH | 39 | BCD*10.3 | Customer Balance Due (Functional | E A |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.