View: Applied Receipts/Adjustments

RotoID: AR0044
Table: ARTCP
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:ARTCP

Compositions: 3

RotoID Tables 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: 87

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:5 entries
1 = (None)
2 = Document Number
3 = PO Number
4 = Order Number
9 = Shipment 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 = Debit Note - Advance Credit Claim
31 = Credit Note - Item Issued
32 = Credit Note - Summary Entered
34 = Credit Note - Summary Issued
35 = Credit Note - Item Entered
40 = Interest Charge
50 = Prepayment - Posted
51 = Receipt - Posted
73 = Refund - Posted
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 C 
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 C 
CODECURN 55 String*3 Customer Currency Code E A C  Mask: %-3N
AMTWHD1TC 56 BCD*10.3 Cust. Tax Withheld Amount 1 E A 
AMTWHD2TC 57 BCD*10.3 Cust. Tax Withheld Amount 2 E A 
AMTWHD3TC 58 BCD*10.3 Cust. Tax Withheld Amount 3 E A 
AMTWHD4TC 59 BCD*10.3 Cust. Tax Withheld Amount 4 E A 
AMTWHD5TC 60 BCD*10.3 Cust. Tax Withheld Amount 5 E A 
AMTWHD1HC 61 BCD*10.3 Func. Tax Withheld Amount 1 E A C 
AMTWHD2HC 62 BCD*10.3 Func. Tax Withheld Amount 2 E A C 
AMTWHD3HC 63 BCD*10.3 Func. Tax Withheld Amount 3 E A C 
AMTWHD4HC 64 BCD*10.3 Func. Tax Withheld Amount 4 E A C 
AMTWHD5HC 65 BCD*10.3 Func. Tax Withheld Amount 5 E A C 
AMTWHD1DT 66 BCD*10.3 Job Total Tax Withheld Amt 1 E A C 
AMTWHD2DT 67 BCD*10.3 Job Total Tax Withheld Amt 2 E A C 
AMTWHD3DT 68 BCD*10.3 Job Total Tax Withheld Amt 3 E A C 
AMTWHD4DT 69 BCD*10.3 Job Total Tax Withheld Amt 4 E A C 
AMTWHD5DT 70 BCD*10.3 Job Total Tax Withheld Amt 5 E A C 
CODETAX1 71 String*12 Document Tax Authority 1 E A C 
CODETAX2 72 String*12 Document Tax Authority 2 E A C 
CODETAX3 73 String*12 Document Tax Authority 3 E A C 
CODETAX4 74 String*12 Document Tax Authority 4 E A C 
CODETAX5 75 String*12 Document Tax Authority 5 E A C 
TXAU1DESC 76 String*60 Tax Auth 1 Description E A C 
TXAU2DESC 77 String*60 Tax Auth 2 Description E A C 
TXAU3DESC 78 String*60 Tax Auth 3 Description E A C 
TXAU4DESC 79 String*60 Tax Auth 4 Description E A C 
TXAU5DESC 80 String*60 Tax Auth 5 Description E A C 
PNDWHD1TOT 81 BCD*10.3 Pending Tax Withheld Amount 1 E A C 
PNDWHD2TOT 82 BCD*10.3 Pending Tax Withheld Amount 2 E A C 
PNDWHD3TOT 83 BCD*10.3 Pending Tax Withheld Amount 3 E A C 
PNDWHD4TOT 84 BCD*10.3 Pending Tax Withheld Amount 4 E A C 
PNDWHD5TOT 85 BCD*10.3 Pending Tax Withheld Amount 5 E A C 
PNDWHDTOT 86 BCD*10.3 Pending Tax Withheld Total E A C 
AMTWHDTOT 87 BCD*10.3 Tax Withheld Amount Total E A C 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).