# Table: Document Payments

Table: AROBP
View: AR0038
Record length: 256
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: 37

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: 13 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
CNTSEQNCE | BCD*3.0 | Sequence No. |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
DEPSTNBR | BCD*5.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: 29 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
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 | Long | Deposit Serial Number |
DEPLINE | Long | Deposit Line Number |

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.