Table: Aged Documents

Table: APAGED
View: AP0125
Record Length: 674

Flags: A R 

Keys: 1

Title Flags Fields

Primary Key AGESEQRECORDNOIDVENDIDINVCADJNORECTYPECNTSEQ

Fields: 58

Field Type Title Presentation

AGESEQ Long Aging Sequence Number
RECORDNO Long Record Number
IDVEND String*12 Vendor Number Mask: %-12C
IDINVC String*22 Document Number Mask: %-22C
ADJNO Long Adjustment Sequence Number
RECTYPE Integer Record Type List:3 entries
0 = Document
1 = Applied Detail
2 = Retainage Document
CNTSEQ Long Detail Sequence Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
IDRMIT String*18 Check Number Mask: %-18D
TRXTYPETXT Integer Document Type
TRXTYPEID Integer Transaction Type
DATEINVC Date Document Date
DATEBUS Date Posting Date
DATEDUE Date Due Date
SWPYSTTS Integer Payment Status List:3 entries
0 = Normal
1 = On Hold
2 = Forced
IDMEMOXREF String*22 Reference Document No.
AMTINVCTC BCD*10.3 Invoice Amount (Source)
AMTINVCHC BCD*10.3 Invoice Amount (Functional)
AMTPAIDTC BCD*10.3 Amount Paid (Source)
AMTPAIDHC BCD*10.3 Amount Paid (Functional)
AMTDUE1TC BCD*10.3 Current Amount Due (Source)
AMTDUE1HC BCD*10.3 Current Amount Due (Functional)
AMTDUE2TC BCD*10.3 Period 1 Amount Due (Source)
AMTDUE2HC BCD*10.3 Period 1 Amount Due (Functional)
AMTDUE3TC BCD*10.3 Period 2 Amount Due (Source)
AMTDUE3HC BCD*10.3 Period 2 Amount Due (Functional)
AMTDUE4TC BCD*10.3 Period 3 Amount Due (Source)
AMTDUE4HC BCD*10.3 Period 3 Amount Due (Functional)
AMTDUE5TC BCD*10.3 Period 4 Amount Due (Source)
AMTDUE5HC BCD*10.3 Period 4 Amount Due (Functional)
AMTDUE6TC BCD*10.3 Period 5 Amount Due (Source)
AMTDUE6HC BCD*10.3 Period 5 Amount Due (Functional)
AMTDUE7TC BCD*10.3 Period 6 Amount Due (Source)
AMTDUE7HC BCD*10.3 Period 6 Amount Due (Functional)
AMTDUE8TC BCD*10.3 Period 7 Amount Due (Source)
AMTDUE8HC BCD*10.3 Period 7 Amount Due (Functional)
AMTDUE9TC BCD*10.3 Period 9 Amount Due (Source)
AMTDUE9HC BCD*10.3 Period 9 Amount Due (Functional)
TOTBKWDTC BCD*10.3 Total Backward Aging (Source)
TOTBKWDHC BCD*10.3 Total Backward Aging (Functional)
TOTFWDTC BCD*10.3 Total Forward Aging (Source)
TOTFWDHC BCD*10.3 Total Forward Aging (Functional)
AMTBALDUET BCD*10.3 Vendor Balance Due (Source)
AMTBALDUEH BCD*10.3 Vendor Balance Due (Functional)
DOCTYPE Integer Document Type
SWNONRCVBL Integer Misc. Payment Flag
RTGDATEDUE Date Date Retainage Due
SORTVALUE1 String*60 Sort Field Value 1
SORTVALUE2 String*60 Sort Field Value 2
SORTVALUE3 String*60 Sort Field Value 3
SORTVALUE4 String*60 Sort Field Value 4
SORTTYPE1 Integer Sort Field Type 1
SORTTYPE2 Integer Sort Field Type 2
SORTTYPE3 Integer Sort Field Type 3
SORTTYPE4 Integer Sort Field Type 4