View: Document Detail Payments

RotoID: AR0088
Table: AROBLJP
Protocol: Flat
DLL:AROBLJP

Keys: 3

Title Fields
Cust. No./Doc. No./Line No./Seq. IDCUST, IDINVC, CNTLINE, CNTSEQENCE
Bank, Customer, Check/Receipt No IDBANK, IDCUSTRMIT, IDRMIT, DATERMIT
Customer, Payment CUID, Document IDCUST, PYMCUID, IDINVC, CNTLINE

Fields: 32

Field Index Type Title Attributes Presentation
IDCUST 1 String*12 Customer 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: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 8 Integer Transaction Type E A  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 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 
AMTPAYMHC 13 BCD*10.3 Func. Receipt Amount E A 
AMTPAYMTC 14 BCD*10.3 Cust. Receipt Amount E A 
TXTOTRTHC 15 BCD*10.3 Func. Retainage Tax Invoiced E A 
TXTOTRTTC 16 BCD*10.3 Cust. Retainage Tax Invoiced E A 
CODECURN 17 String*3 Currency Code E A  Mask: %-3N
IDRATETYPE 18 String*2 Rate Type E A  Mask: %-2N
RATEEXCHHC 19 BCD*8.7 Exchange Rate E A 
RATEDATE 20 Date Rate Date E A 
RATEOP 21 Integer Rate Operator E A 
IDBANK 22 String*8 Bank Code E A  Mask: %-8N
IDCUSTRMIT 23 String*12 Remitting Customer Number E A  Mask: %-12C
IDRMIT 24 String*24 Check/Receipt No. E A  Mask: %-24C
DEPSEQ 25 ??? Deposit Serial Number E A 
DEPLINE 26 Long Deposit Line Number E A 
DATERMIT 27 Date Receipt Date E A 
PYMCUID 28 Long Payment CUID E A 
IDMEMOXREF 29 String*22 Reference Document Number E A 
FISCYR 30 String*4 Fiscal Year E A  Mask: %04D
FISCPER 31 String*2 Fiscal Period E A  Mask: %02D
CODETAX 32 String*12 Tax Authority E A 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).