# View: Aged Documents

RotoID: AR0125
Table: ARAGED
Protocol: Flat
DLL: ARAGED

## Compositions: 0

## Keys: 1

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

## Fields: 51

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
ADJNO | 5 | Long | Adjustment Sequence Number | E A K R |
RECTYPE | 6 | Integer | Record Type | E A K R | List: 3 entries
0 | = | Document
1 | = | Applied Detail
2 | = | Retainage Document
CNTSEQ | 7 | Long | Detail Sequence Number | E A K R |
IDRMIT | 8 | String*24 | Check/Receipt Number | E A | Mask: %-24C
TRXTYPETXT | 9 | Integer | Document Type | E A |
TRXTYPEID | 10 | Integer | Transaction Type | E A |
DATEINVC | 11 | Date | Document Date | E A |
DATEBUS | 12 | Date | Posting Date | E A |
DATEDUE | 13 | Date | Due Date | E A |
IDMEMOXREF | 14 | String*22 | Reference Document No. | E A |
AMTINVCTC | 15 | BCD*10.3 | Invoice Amount (Source) | E A |
AMTINVCHC | 16 | BCD*10.3 | Invoice Amount (Functional) | E A |
AMTDUE1TC | 17 | BCD*10.3 | Current Amount Due (Source) | E A |
AMTDUE1HC | 18 | BCD*10.3 | Current Amount Due (Functional) | E A |
AMTDUE2TC | 19 | BCD*10.3 | Period 1 Amount Due (Source) | E A |
AMTDUE2HC | 20 | BCD*10.3 | Period 1 Amount Due (Functional) | E A |
AMTDUE3TC | 21 | BCD*10.3 | Period 2 Amount Due (Source) | E A |
AMTDUE3HC | 22 | BCD*10.3 | Period 2 Amount Due (Functional) | E A |
AMTDUE4TC | 23 | BCD*10.3 | Period 3 Amount Due (Source) | E A |
AMTDUE4HC | 24 | BCD*10.3 | Period 3 Amount Due (Functional) | E A |
AMTDUE5TC | 25 | BCD*10.3 | Period 4 Amount Due (Source) | E A |
AMTDUE5HC | 26 | BCD*10.3 | Period 4 Amount Due (Functional) | E A |
AMTDUE6TC | 27 | BCD*10.3 | Period 5 Amount Due (Source) | E A |
AMTDUE6HC | 28 | BCD*10.3 | Period 5 Amount Due (Functional) | E A |
AMTDUE7TC | 29 | BCD*10.3 | Period 6 Amount Due (Source) | E A |
AMTDUE7HC | 30 | BCD*10.3 | Period 6 Amount Due (Functional) | E A |
AMTDUE8TC | 31 | BCD*10.3 | Period 7 Amount Due (Source) | E A |
AMTDUE8HC | 32 | BCD*10.3 | Period 7 Amount Due (Functional) | E A |
AMTDUE9TC | 33 | BCD*10.3 | Period 9 Amount Due (Source) | E A |
AMTDUE9HC | 34 | BCD*10.3 | Period 9 Amount Due (Functional) | E A |
TOTBKWDTC | 35 | BCD*10.3 | Total Backward Aging (Source) | E A |
TOTBKWDHC | 36 | BCD*10.3 | Total Backward Aging (Functional) | E A |
TOTFWDTC | 37 | BCD*10.3 | Total Forward Aging (Source) | E A |
TOTFWDHC | 38 | BCD*10.3 | Total Forward Aging (Functional) | E A |
AMTBALDUET | 39 | BCD*10.3 | Customer Balance Due (Source) | E A |
AMTBALDUEH | 40 | BCD*10.3 | Customer Balance Due (Functional) | E A |
DOCTYPE | 41 | Integer | Document Type | E A |
SWNONRCVBL | 42 | Integer | Misc. Receipt Flag | E A |
RTGDATEDUE | 43 | Date | Date Retainage Due | E A |
SORTVALUE1 | 44 | String*60 | Sort Field Value 1 | E A |
SORTVALUE2 | 45 | String*60 | Sort Field Value 2 | E A |
SORTVALUE3 | 46 | String*60 | Sort Field Value 3 | E A |
SORTVALUE4 | 47 | String*60 | Sort Field Value 4 | E A |
SORTTYPE1 | 48 | Integer | Sort Field Type 1 | E A |
SORTTYPE2 | 49 | Integer | Sort Field Type 2 | E A |
SORTTYPE3 | 50 | Integer | Sort Field Type 3 | E A |
SORTTYPE4 | 51 | Integer | Sort Field Type 4 | E A |

This page was generated on 2009-Nov-19

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