Table: Retainage Open Documents

Table: APRTG
View: AP0311
Record Length: 164

Flags: A R 

Keys: 1

Title Flags Fields

Sequence Number/Vendor Number/Do RTGSEQIDVENDIDINVC

Fields: 19

Field Type Title Presentation

RTGSEQ Long Sequence Number
IDVEND String*12 Vendor Number Mask: %-12C
IDINVC String*22 Document Number Mask: %-22C
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
RTGDATEDUE Date Date Retainage Due
DATEINVC Date Invoice Date
TXTTRXTYPE Integer Document Type List:6 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
10 = Prepayment
11 = Payment
AMTDUE1 BCD*10.3 Current Amount Due
AMTDUE2 BCD*10.3 Period 1 Amount Due
AMTDUE3 BCD*10.3 Period 2 Amount Due
AMTDUE4 BCD*10.3 Period 3 Amount Due
AMTDUE5 BCD*10.3 Period 4 Amount Due
TOTAMTBKWD BCD*10.3 Total Backward Aging
TOTAMTFWD BCD*10.3 Total Forward Aging
RTGAMTTC BCD*10.3 Amount Retained - Vend. Curr.
RTGAMTHC BCD*10.3 Amount Retained - Func. Curr.