Table: Applied Receipts/Adjustments

Table: ARTCP
View: AR0044
Record Length: 562

Flags: A R 

Keys: 3

Title Flags Fields

Receipt Applied Seq. Number CODEPAYMCNTBTCHCNTITEMCNTLINE
Customer, Doc. and Payment No. D M  IDCUSTIDINVCCNTPAYM
Batch/Entry/Doc. No./Pmt. No. M  CODEPAYMCNTBTCHCNTITEMIDINVCCNTPAYM

Fields: 55

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:5 entries
1 = (None)
2 = Document Number
3 = PO Number
4 = Order Number
9 = Shipment 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
AMTWHD1TC BCD*10.3 Cust. Tax Withheld Amount 1
AMTWHD2TC BCD*10.3 Cust. Tax Withheld Amount 2
AMTWHD3TC BCD*10.3 Cust. Tax Withheld Amount 3
AMTWHD4TC BCD*10.3 Cust. Tax Withheld Amount 4
AMTWHD5TC BCD*10.3 Cust. Tax Withheld Amount 5
AMTWHD1HC BCD*10.3 Func. Tax Withheld Amount 1
AMTWHD2HC BCD*10.3 Func. Tax Withheld Amount 2
AMTWHD3HC BCD*10.3 Func. Tax Withheld Amount 3
AMTWHD4HC BCD*10.3 Func. Tax Withheld Amount 4
AMTWHD5HC BCD*10.3 Func. Tax Withheld Amount 5
AMTWHD1DT BCD*10.3 Job Total Tax Withheld Amt 1
AMTWHD2DT BCD*10.3 Job Total Tax Withheld Amt 2
AMTWHD3DT BCD*10.3 Job Total Tax Withheld Amt 3
AMTWHD4DT BCD*10.3 Job Total Tax Withheld Amt 4
AMTWHD5DT BCD*10.3 Job Total Tax Withheld Amt 5