# Table: Applied Receipts/Adjustments

Table: ARTCP
View: AR0044
Record length: 412
Flags: A R

## Keys: 3

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

## Fields: 40

Field | Type | Title | Presentation
--- | --- | --- | ---
CODEPAYM | String*2 | Batch Type | Mask: %-2N
CNTBTCH | BCD*5.0 | Batch Number |
CNTITEM | BCD*4.0 | Entry Number |
CNTLINE | BCD*3.0 | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
IDCUST | String*12 | Customer Number | Mask: %-12C
IDINVC | String*22 | Document Number | Mask: %-22C
CNTPAYM | BCD*3.0 | Payment Number |
TRXTYPE | Integer | Transaction Type | List: 5 entries
2 | = | Unapplied Cash - Posted
51 | = | Receipt - Posted
57 | = | Prepayment - Posted
81 | = | Adjustment - Posted
80 | = | Write-Off - Posted
PYMTRESL | String*2 | Payment Resolution |
AMTPAYM | BCD*10.3 | Cust. Receipt Amount |
AMTERNDISC | BCD*10.3 | Cust. Discount Amount Taken |
CNTLASTSEQ | BCD*3.0 | Next Adj. Seq. No. |
AMTADJTOT | BCD*10.3 | Cust. Adjustment Total |
CNTADJ | BCD*5.0 | Adjustment Number |
TEXTADJ | String*60 | Description |
GLREF | String*60 | Reference |
IDPPD | String*22 | Generated PP/UC No. |
IDDOCMTCH | String*22 | PP Matching Doc. No. |
CDAPPLYTO | Integer | PP Matching Doc. Type | List: 4 entries
1 | = | (None)
2 | = | Document Number
3 | = | PO Number
4 | = | Order Number
AMTDBADJTC | BCD*10.3 | Total Cust. Debit Amount |
AMTCRADJTC | BCD*10.3 | Total Cust. Credit Amount |
DOCTYPE | Integer | Document Type |
SWJOB | Integer | Job Related | List: 2 entries
0 | = | No
1 | = | Yes
AMTPAYMTOT | BCD*10.3 | Job Total Payment Amount |
AMTDISCTOT | BCD*10.3 | Job Total Discount Amount |
APPLYMETH | Integer | Job Apply Method | List: 2 entries
0 | = | Prorate by Amount
1 | = | Top Down
RTGTOTDBTC | BCD*10.3 | Rtg. Debit Amt. - Cust. Curr |
RTGTOTCRTC | BCD*10.3 | Rtg. Credit Amt. - Cust. Curr |
RTGAMT | BCD*10.3 | Retainage Amount |
RTGDATEDUE | Date | Retainage Due Date |
RTGTERMS | String*6 | Retainage Terms Code | Mask: %-6N
SWRTGRATE | Integer | Retainage Exchange Rate | List: 2 entries
0 | = | Use Original Document Exchange Rate
1 | = | Use Current Exchange Rate
AMTPAYMHC | BCD*10.3 | Func. Receipt Amount |
AMTDISCHC | BCD*10.3 | Func. Total Discount Amount |
AMTADJHC | BCD*10.3 | Func. Total Adjustment Amount |
RTGAMTHC | BCD*10.3 | Func. Retainage Amount |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.