View: Aged Documents

RotoID: AP0125
Table: APAGED
Protocol: Flat
DLL:APAGED

Keys: 1

Title Fields

Primary Key AGESEQRECORDNOIDVENDIDINVCADJNORECTYPECNTSEQ

Fields: 54

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 
IDVEND 3 String*12 Vendor 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*18 Check Number E A  Mask: %-18D
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 
SWPYSTTS 14 Integer Payment Status E A  List:3 entries
0 = Normal
1 = On Hold
2 = Forced
IDMEMOXREF 15 String*22 Reference Document No. E A 
AMTINVCTC 16 BCD*10.3 Invoice Amount (Source) E A 
AMTINVCHC 17 BCD*10.3 Invoice Amount (Functional) E A 
AMTPAIDTC 18 BCD*10.3 Amount Paid (Source) E A 
AMTPAIDHC 19 BCD*10.3 Amount Paid (Functional) E A 
AMTDUE1TC 20 BCD*10.3 Current Amount Due (Source) E A 
AMTDUE1HC 21 BCD*10.3 Current Amount Due (Functional) E A 
AMTDUE2TC 22 BCD*10.3 Period 1 Amount Due (Source) E A 
AMTDUE2HC 23 BCD*10.3 Period 1 Amount Due (Functional) E A 
AMTDUE3TC 24 BCD*10.3 Period 2 Amount Due (Source) E A 
AMTDUE3HC 25 BCD*10.3 Period 2 Amount Due (Functional) E A 
AMTDUE4TC 26 BCD*10.3 Period 3 Amount Due (Source) E A 
AMTDUE4HC 27 BCD*10.3 Period 3 Amount Due (Functional) E A 
AMTDUE5TC 28 BCD*10.3 Period 4 Amount Due (Source) E A 
AMTDUE5HC 29 BCD*10.3 Period 4 Amount Due (Functional) E A 
AMTDUE6TC 30 BCD*10.3 Period 5 Amount Due (Source) E A 
AMTDUE6HC 31 BCD*10.3 Period 5 Amount Due (Functional) E A 
AMTDUE7TC 32 BCD*10.3 Period 6 Amount Due (Source) E A 
AMTDUE7HC 33 BCD*10.3 Period 6 Amount Due (Functional) E A 
AMTDUE8TC 34 BCD*10.3 Period 7 Amount Due (Source) E A 
AMTDUE8HC 35 BCD*10.3 Period 7 Amount Due (Functional) E A 
AMTDUE9TC 36 BCD*10.3 Period 9 Amount Due (Source) E A 
AMTDUE9HC 37 BCD*10.3 Period 9 Amount Due (Functional) E A 
TOTBKWDTC 38 BCD*10.3 Total Backward Aging (Source) E A 
TOTBKWDHC 39 BCD*10.3 Total Backward Aging (Functional) E A 
TOTFWDTC 40 BCD*10.3 Total Forward Aging (Source) E A 
TOTFWDHC 41 BCD*10.3 Total Forward Aging (Functional) E A 
AMTBALDUET 42 BCD*10.3 Vendor Balance Due (Source) E A 
AMTBALDUEH 43 BCD*10.3 Vendor Balance Due (Functional) E A 
DOCTYPE 44 Integer Document Type E A 
SWNONRCVBL 45 Integer Misc. Payment Flag E A 
RTGDATEDUE 46 Date Date Retainage Due E A 
SORTVALUE1 47 String*60 Sort Field Value 1 E A 
SORTVALUE2 48 String*60 Sort Field Value 2 E A 
SORTVALUE3 49 String*60 Sort Field Value 3 E A 
SORTVALUE4 50 String*60 Sort Field Value 4 E A 
SORTTYPE1 51 Integer Sort Field Type 1 E A 
SORTTYPE2 52 Integer Sort Field Type 2 E A 
SORTTYPE3 53 Integer Sort Field Type 3 E A 
SORTTYPE4 54 Integer Sort Field Type 4 E A