Table: Document Detail Payments

Table: APOBLJP
View: AP0171
Record Length: 259

Flags: A R 

Keys: 2

Title Flags Fields

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

Fields: 36

Field Type Title Presentation

IDVEND String*12 Vendor Number Mask: %-12C
IDINVC String*22 Document Number Mask: %-22C
CNTLINE BCD*3.0 Line Number
CNTSEQENCE Long Sequence Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
TRANSNBR Long Transaction Number
DATEBUS Date Posting Date
TRANSTYPE Integer Document Type 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 Integer Transaction Type 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 String*2 Batch Type Mask: %-2N
CNTBTCH BCD*5.0 Batch Number
CNTITEM BCD*4.0 Entry Number
DATEBTCH Date Batch Date
QTYINVC BCD*10.5 Quantity
AMTPAYMHC BCD*10.3 Func. Payment Amount
AMTPAYMTC BCD*10.3 Vend. Payment Amount
TXTOTRTHC BCD*10.3 Func. Retainage Tax Invoiced
TXTOTRTTC BCD*10.3 Vend. Retainage Tax Invoiced
CODECURN String*3 Currency Code Mask: %-3N
IDRATETYPE String*2 Rate Type Mask: %-2N
RATEEXCHHC BCD*8.7 Exchange Rate
RATEDATE Date Rate Date
RATEOP Integer Rate Operator
IDMEMOXREF String*22 Reference Document Number Mask: %-22C
IDBANK String*8 Bank Code Mask: %-8N
IDRMIT String*18 Check/Receipt Number Mask: %-18D
DATERMIT Date Payment Date
LONGSERIAL ??? Serial Number
FISCYR String*4 Fiscal Year Mask: %04D
FISCPER String*2 Fiscal Period Mask: %02D
CODE1099 String*6 1099/CPRS Code
AMT1099 BCD*10.3 1099/CPRS Amount
CODETAX String*12 Tax Authority