# View: Applied Receipts/Adjustments

RotoID: AR0044
Table: ARTCP
DLL: ARTCP

## Compositions: 3

RotoID | Table | Title | DLL
--- | --- | --- | ---
AR0042 | ARTCR | Receipts/Adjustments | ARTCR
AR0045 | ARTCU | Adjustment G/L Distributions | ARTCU
AR0061 | ARPOOP | Create Open Document List | ARPOOP

## Keys: 3

Title | Fields
--- | ---
Receipt Applied Seq. Number | CODEPAYM, CNTBTCH, CNTITEM, CNTLINE
Customer, Doc. and Payment No. | IDCUST, IDINVC, CNTPAYM
Batch/Entry/Doc. No./Pmt. No. | CODEPAYM, CNTBTCH, CNTITEM, IDINVC, CNTPAYM

## Fields: 54

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
CODEPAYM | 1 | String*2 | Batch Type | E A K R | Mask: %-2N
CNTBTCH | 2 | BCD*5.0 | Batch Number | E A K R |
CNTITEM | 3 | BCD*4.0 | Entry Number | E A K R |
CNTLINE | 4 | BCD*3.0 | Line Number | E A K R |
IDCUST | 5 | String*12 | Customer Number | E A | Mask: %-12C
IDINVC | 6 | String*22 | Document Number | E A | Mask: %-22C
CNTPAYM | 7 | BCD*3.0 | Payment Number | E A |
TRXTYPE | 8 | Integer | Transaction Type | E A | List: 5 entries
2 | = | Unapplied Cash - Posted
51 | = | Receipt - Posted
57 | = | Prepayment - Posted
81 | = | Adjustment - Posted
80 | = | Write-Off - Posted
PYMTRESL | 9 | String*2 | Payment Resolution | E A |
AMTPAYM | 10 | BCD*10.3 | Cust. Receipt Amount | E A |
AMTERNDISC | 11 | BCD*10.3 | Cust. Discount Amount Taken | E A |
CNTLASTSEQ | 12 | BCD*3.0 | Next Adj. Seq. No. | E A C |
AMTADJTOT | 13 | BCD*10.3 | Cust. Adjustment Total | E A C |
CNTADJ | 14 | BCD*5.0 | Adjustment Number | E A C |
TEXTADJ | 15 | String*60 | Description | E A |
GLREF | 16 | String*60 | Reference | E A |
IDPPD | 17 | String*22 | Generated PP/UC No. | E A C |
IDDOCMTCH | 18 | String*22 | PP Matching Doc. No. | E A |
CDAPPLYTO | 19 | Integer | PP Matching Doc. Type | E A | List: 4 entries
1 | = | (None)
2 | = | Document Number
3 | = | PO Number
4 | = | Order Number
OBSPAYMAMT | 20 | BCD*10.3 | Document Amount Due | E A C |
OBSDISCAMT | 21 | BCD*10.3 | Discount Amount Available | E A C |
OBSNETBAL | 22 | BCD*10.3 | Document Net Balance | E A C |
PNDPAYTOT | 23 | BCD*10.3 | Pending Receipt Amount | E A C |
PNDDSCTOT | 24 | BCD*10.3 | Pending Discount Amount | E A C |
PNDADJTOT | 25 | BCD*10.3 | Pending Adjustment Amount | E A C |
AMTDBADJTC | 26 | BCD*10.3 | Total Cust. Debit Amount | E A C |
AMTCRADJTC | 27 | BCD*10.3 | Total Cust. Credit Amount | E A C |
DOCTYPE | 28 | Integer | Document Type | E A |
SWJOB | 29 | Integer | Job Related | E A C | List: 2 entries
0 | = | No
1 | = | Yes
AMTPAYMTOT | 30 | BCD*10.3 | Job Total Payment Amount | E A C |
AMTDISCTOT | 31 | BCD*10.3 | Job Total Discount Amount | E A C |
APPLYMETH | 32 | Integer | Job Apply Method | E A | List: 2 entries
0 | = | Prorate by Amount
1 | = | Top Down
RTGTOTDBTC | 33 | BCD*10.3 | Rtg. Debit Amt. - Cust. Curr | E A C |
RTGTOTCRTC | 34 | BCD*10.3 | Rtg. Credit Amt. - Cust. Curr | E A C |
RTGAMT | 35 | BCD*10.3 | Retainage Amount | E A |
RTGDATEDUE | 36 | Date | Retainage Due Date | E A |
RTGTERMS | 37 | String*6 | Retainage Terms Code | E A | Mask: %-6N
SWRTGRATE | 38 | Integer | Retainage Exchange Rate | E A | List: 2 entries
0 | = | Use Original Document Exchange Rate
1 | = | Use Current Exchange Rate
PROCESSCMD | 39 | Integer | Process Command | E A C | List: 2 entries
0 | = | Clear
1 | = | Allocate
UNAPLPAYM | 40 | BCD*10.3 | Unapplied Job Payment Amount | E A C |
UNAPLDISC | 41 | BCD*10.3 | Unapplied Job Discount Amount | E A C |
TRXTYPEID | 42 | Integer | Transaction Type | E A C | List: 19 entries
1 | = | Unapplied Cash - Posted
11 | = | Invoice - Item Issued
12 | = | Invoice - Summary Entered
13 | = | Invoice - Recurring Charge
14 | = | Invoice - Summary Issued
15 | = | Invoice - Item Entered
21 | = | Debit Note - Item Issued
22 | = | Debit Note - Summary Entered
24 | = | Debit Note - Summary Issued
25 | = | Debit Note - Item Entered
26 | = | Credit Note - Item Issued
31 | = | Credit Note - Summary Entered
32 | = | Credit Note - Summary Issued
34 | = | Credit Note - Item Entered
35 | = | Interest Charge
40 | = | Prepayment - Posted
50 | = | Receipt - Posted
51 | = | Refund - Posted
73 | = |
RMITTYPE | 43 | Integer | Receipt Trans. Type | E A C | List: 7 entries
1 | = | Receipt
2 | = | Prepayment
3 | = | Unapplied Cash
4 | = | Apply Document
5 | = | Misc. Receipt
6 | = | Write-Off
7 | = | Adjustment
SWRTG | 44 | Integer | Has Retainage | E A C | List: 2 entries
0 | = | No
1 | = | Yes
RTGBAL | 45 | BCD*10.3 | Retainage Balance | E A C |
RTGAPPLYTO | 46 | String*22 | Original Doc. No. | E A C | Mask: %-22C
AMTADJNET | 47 | BCD*10.3 | Receivables Adjustment Total | E A C |
EXCHRATEHC | 48 | BCD*8.7 | Original Exchange Rate | E A C |
DATEINVC | 49 | Date | Document Date | E A |
AMTPAYMHC | 50 | BCD*10.3 | Func. Receipt Amount | E A C |
AMTDISCHC | 51 | BCD*10.3 | Func. Total Discount Amount | E A C |
AMTADJHC | 52 | BCD*10.3 | Func. Total Adjustment Amount | E A C |
RTGAMTHC | 53 | BCD*10.3 | Func. Retainage Amount | E A C |
ARVERSION | 54 | String*3 | Document Version Created In | E A |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.