View: Document Payments

RotoID: AR0038
Table: AROBP
Protocol: Flat
DLL:AROBP

Keys: 7

Title Fields
Payment Audit Key IDCUST, IDINVC, CNTPAYMNBR, IDRMIT, DATEBUS, TRANSTYPE, CNTSEQNCE
Bank Code IDBANK, CNTBTCH, CNTITEM, IDCUST, IDINVC, CNTPAYMNBR
Document IDINVC, CNTPAYMNBR
Customer, Reference Doc. No. IDCUST, IDMEMOXREF
Bank, Customer, Check/Receipt No IDBANK, IDCUSTRMIT, IDRMIT, DATERMIT
Customer, Document, Posting Date IDCUST, IDINVC, CNTPAYMNBR, DATEBUS
Customer, Payment CUID, Document IDCUST, PYMCUID, IDINVC, CNTPAYMNBR

Fields: 34

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
CNTPAYMNBR 3 BCD*3.0 Payment Number E A K R 
IDRMIT 4 String*24 Check/Receipt No. E A K R  Mask: %-24C
DATEBUS 5 Date Posting Date E A K R 
TRANSTYPE 6 Integer Document Type E A K R  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
CNTSEQNCE 7 BCD*3.0 Sequence No. E A K R 
DEPSTNBR 8 BCD*8.0 Deposit Number E A 
CNTBTCH 9 BCD*5.0 Batch Number E A 
DATEBTCH 10 Date Batch Date E A 
AMTPAYMHC 11 BCD*10.3 Func. Receipt Amount E A 
AMTPAYMTC 12 BCD*10.3 Cust. Receipt Amount E A 
CODECURN 13 String*3 Currency Code E A  Mask: %-3N
IDRATETYPE 14 String*2 Rate Type E A  Mask: %-2N
RATEEXCHHC 15 BCD*8.7 Exchange Rate E A 
SWOVRDRATE 16 Integer Rate Overridden E A  List:2 entries
0 = No
1 = Yes
IDBANK 17 String*8 Bank Code E A  Mask: %-8N
TRXTYPE 18 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
IDMEMOXREF 19 String*22 Reference Document No. E A 
SWINVCDEL 20 Integer Delete Invoice Switch E 
DATELSTSTM 21 Date Last Statement Date E A 
IDPREPAID 22 String*22 Prepay. Apply-to Doc. No. E 
IDCUSTRMIT 23 String*12 Remitting Customer No. E A  Mask: %-12C
DATERMIT 24 Date Receipt Date E A 
CNTITEM 25 BCD*4.0 Entry Number E A 
FISCYR 26 String*4 Fiscal Year E A  Mask: %04D
FISCPER 27 String*2 Fiscal Period E A  Mask: %02D
RATEDATE 28 Date Rate Date E A 
RATEOP 29 Integer Rate Operator E A 
STMTSEQ 31 Long Statement Run No. E A 
PYMCUID 32 Long Payment CUID E A 
DEPSEQ 33 ??? Deposit Serial Number E A 
DEPLINE 34 Long Deposit Line Number E A 
CODETAX 35 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).