View: Document Detail Payments

RotoID: AP0171
Table: APOBLJP
Protocol: Flat
DLL:APOBLJP

Keys: 2

Title Fields

Vend. No./Doc. No./Line No./Seq. IDVENDIDINVCCNTLINECNTSEQENCE
Vendor, Document, Payment Number IDBANKIDVENDIDRMITLONGSERIALDATERMIT

Fields: 32

Field Index Type Title Attributes Presentation

IDVEND 1 String*12 Vendor Number E A K R  Mask: %-12C
IDINVC 2 String*22 Document Number E A K R  Mask: %-22C
CNTLINE 3 BCD*3.0 Line Number E A K R 
CNTSEQENCE 4 Long Sequence Number E A K R 
TRANSNBR 5 Long Transaction Number E A 
DATEBUS 6 Date Posting Date E A 
TRANSTYPE 7 Integer Document Type E A  List:12 entries
6 = Debit Note Applied To
7 = Applied Debit Note
8 = Credit Note Applied To
9 = Applied Credit Note
10 = Prepayment
11 = Payment
12 = Discount
14 = Adjustment
16 = Exchange Gain/Loss
17 = Rounding
18 = Retainage
19 = Tax Withheld
TRXTYPE 8 Integer Transaction Type E A  List:26 entries
41 = Debit Note Applied To
42 = Applied Debit Note
43 = Credit Note Applied To
44 = Applied Credit Note
58 = Prepayment - Applied
59 = Prepayment - Reversed
51 = Payment - Posted
52 = Payment - Applied
53 = Payment - Reversed
61 = Discount - Posted
63 = Discount - Reversed
81 = Adjustment - Posted
83 = Adjustment - Reversed
65 = Exchange Gain/Loss - Posted
67 = Exchange Gain/Loss - Reversed
69 = Unrealized Exchange Gain/Loss
91 = Rounding - Posted
93 = Rounding - Reversed
100 = Retainage - Invoiced
101 = Retainage - Adjusted
102 = Retainage - Revalued
103 = Retainage - Exchange Gain/Loss
104 = Retainage - Rounding
94 = Payment - Invoice Reversed
105 = Tax Withheld - Posted
106 = Tax Withheld - Reversed
TYPEBTCH 9 String*2 Batch Type E A  Mask: %-2N
CNTBTCH 10 BCD*5.0 Batch Number E A 
CNTITEM 11 BCD*4.0 Entry Number E A 
DATEBTCH 12 Date Batch Date E A 
QTYINVC 13 BCD*10.5 Quantity E A 
AMTPAYMHC 14 BCD*10.3 Func. Payment Amount E A 
AMTPAYMTC 15 BCD*10.3 Vend. Payment Amount E A 
TXTOTRTHC 16 BCD*10.3 Func. Retainage Tax Invoiced E A 
TXTOTRTTC 17 BCD*10.3 Vend. Retainage Tax Invoiced E A 
CODECURN 18 String*3 Currency Code E A  Mask: %-3N
IDRATETYPE 19 String*2 Rate Type E A  Mask: %-2N
RATEEXCHHC 20 BCD*8.7 Exchange Rate E A 
RATEDATE 21 Date Rate Date E A 
RATEOP 22 Integer Rate Operator E A 
IDMEMOXREF 23 String*22 Reference Document Number E A  Mask: %-22C
IDBANK 24 String*8 Bank Code E A  Mask: %-8N
IDRMIT 25 String*18 Check/Receipt Number E A  Mask: %-18D
DATERMIT 26 Date Payment Date E A 
LONGSERIAL 27 ??? Serial Number E A 
FISCYR 28 String*4 Fiscal Year E A  Mask: %04D
FISCPER 29 String*2 Fiscal Period E A  Mask: %02D
CODE1099 30 String*6 1099/CPRS Code E A 
AMT1099 31 BCD*10.3 1099/CPRS Amount E A 
CODETAX 32 String*12 Tax Authority E A