View: Aged Documents

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

Keys: 1

Title Fields

Primary Key AGESEQRECORDNOIDCUSTIDINVCADJNORECTYPECNTSEQ

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