Table: Document Detail Payments

Table: AROBLJP
View: AR0088
Record Length: 259

Flags: A R 

Keys: 3

Title Flags Fields

Cust. No./Doc. No./Line No./Seq. IDCUSTIDINVCCNTLINECNTSEQENCE
Bank, Customer, Check/Receipt No D M  IDBANKIDCUSTRMITIDRMITDATERMIT
Customer, Payment CUID, Document D M  IDCUSTPYMCUIDIDINVCCNTLINE

Fields: 36

Field Type Title Presentation

IDCUST String*12 Customer 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:14 entries
5 = Unapplied Cash
6 = Debit Note Applied To
7 = Applied Debit Note
8 = Credit Note Applied To
9 = Applied Credit Note
10 = Prepayment
11 = Receipt
12 = Discount
14 = Adjustment
16 = Exchange Gain/Loss
17 = Rounding
19 = Refund
18 = Retainage
20 = Tax Withheld
TRXTYPE Integer Transaction Type List:31 entries
3 = Unapplied Cash - Applied
4 = Unapplied Cash - Reversed
41 = Debit Note Applied To
42 = Applied Debit Note
43 = Credit Note Applied To
44 = Applied Credit Note
51 = Receipt - Posted
52 = Receipt - Applied
53 = Receipt - Reversed
58 = Prepayment - Applied
59 = Prepayment - Reversed
61 = Discount - Posted
63 = Discount - Reversed
65 = Exchange Gain/Loss - Posted
67 = Exchange Gain/Loss - Reversed
91 = Rounding - Posted
93 = Rounding - Reversed
69 = Unrealized Exchange Gain/Loss
80 = Write-Off - Posted
81 = Adjustment - Posted
83 = Adjustment - Reversed
73 = Refund - Posted
75 = Refund - Reversed
100 = Retainage - Invoiced
101 = Retainage - Adjusted
102 = Retainage - Revalued
103 = Retainage - Exchange Gain/Loss
104 = Retainage - Rounding
85 = Receipt - 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
AMTPAYMHC BCD*10.3 Func. Receipt Amount
AMTPAYMTC BCD*10.3 Cust. Receipt Amount
TXTOTRTHC BCD*10.3 Func. Retainage Tax Invoiced
TXTOTRTTC BCD*10.3 Cust. 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
IDBANK String*8 Bank Code Mask: %-8N
IDCUSTRMIT String*12 Remitting Customer Number Mask: %-12C
IDRMIT String*24 Check/Receipt No. Mask: %-24C
DEPSEQ ??? Deposit Serial Number
DEPLINE Long Deposit Line Number
DATERMIT Date Receipt Date
PYMCUID Long Payment CUID
IDMEMOXREF String*22 Reference Document Number
FISCYR String*4 Fiscal Year Mask: %04D
FISCPER String*2 Fiscal Period Mask: %02D
CODETAX String*12 Tax Authority