Table: Document Payments

Table: AROBP
View: AR0038
Record Length: 275

Flags: A R 

Keys: 7

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

Fields: 38

Field Type Title Presentation
IDCUST String*12 Customer Number Mask: %-12C
IDINVC String*22 Document Number Mask: %-22C
CNTPAYMNBR BCD*3.0 Payment Number
IDRMIT String*24 Check/Receipt No. Mask: %-24C
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
CNTSEQNCE BCD*3.0 Sequence No.
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
DEPSTNBR BCD*8.0 Deposit Number
CNTBTCH BCD*5.0 Batch Number
DATEBTCH Date Batch Date
AMTPAYMHC BCD*10.3 Func. Receipt Amount
AMTPAYMTC BCD*10.3 Cust. Receipt Amount
CODECURN String*3 Currency Code Mask: %-3N
IDRATETYPE String*2 Rate Type Mask: %-2N
RATEEXCHHC BCD*8.7 Exchange Rate
SWOVRDRATE Integer Rate Overridden List:2 entries
0 = No
1 = Yes
IDBANK String*8 Bank Code Mask: %-8N
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
IDMEMOXREF String*22 Reference Document No.
SWINVCDEL Integer Delete Invoice Switch
DATELSTSTM Date Last Statement Date
IDPREPAID String*22 Prepay. Apply-to Doc. No.
IDCUSTRMIT String*12 Remitting Customer No. Mask: %-12C
DATERMIT Date Receipt Date
CNTITEM BCD*4.0 Entry Number
FISCYR String*4 Fiscal Year Mask: %04D
FISCPER String*2 Fiscal Period Mask: %02D
RATEDATE Date Rate Date
RATEOP Integer Rate Operator
STMTSEQ Long Statement Run No.
PYMCUID Long Payment CUID
DEPSEQ ??? Deposit Serial Number
DEPLINE Long Deposit Line Number
CODETAX String*12 Tax Authority

This page was generated on 2021-Nov-24

© 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).