# View: Document Detail Payments

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

## Compositions: 0

## 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: 31

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: 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
TRXTYPE | 8 | Integer | Transaction Type | E A | 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
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 | Long | 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

This page was generated on 2009-Nov-19

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