Table: Retainage Open Documents

Table: ARRTG
View: AR0311
Record Length: 164

Flags: A R 

Keys: 1

Title Flags Fields

Sequence Number/Customer Number/ RTGSEQIDCUSTIDINVC

Fields: 19

Field Type Title Presentation

RTGSEQ Long Sequence Number
IDCUST String*12 Customer 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 Document Date
TRXTYPETXT Integer Document Type List:7 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
5 = Unapplied Cash
10 = Prepayment
11 = Receipt
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 - Cust. Curr.
RTGAMTHC BCD*10.3 Amount Retained - Func. Curr.