View: Retainage Open Documents

RotoID: AP0311
Table: APRTG
Protocol: Flat
DLL:APRTG

Keys: 1

Title Fields

Sequence Number/Vendor Number/Do RTGSEQIDVENDIDINVC

Fields: 15

Field Index Type Title Attributes Presentation

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