View: Receipts/Adjustments

RotoID: AR0042
Table: ARTCR
Protocol: Header, Key auto generate
DLL:ARTCR

Compositions: 6

RotoID Tables Title DLL
AR0041 ARBTA Receipt and Adjustment Batches ARBTA
AR0043 ARTCN Miscellaneous Receipts ARTCN
AR0044 ARTCP Applied Receipts/Adjustments ARTCP
AR0406 ARTCRO Receipt/Adjustment Optional Fields ARTCRO
AR0170 ARTCC Advance Credits ARTCC
AR0085 ARTCT Receipt Tax Withholdings ARTCT

Keys: 4

Title Fields
Receipt Entry Number CODEPYMTYP, CNTBTCH, CNTITEM
Customer Number CODEPYMTYP, IDCUST
Check/Receipt No. CODEPYMTYP, IDRMIT
Document Number CODEPYMTYP, DOCNBR

Fields: 141

Field Index Type Title Attributes Presentation
CODEPYMTYP 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 
IDRMIT 4 String*24 Check/Receipt No. E A  Mask: %-24C
IDCUST 5 String*12 Customer Number E A  Mask: %-12C
DATERMIT 6 Date Receipt Date/Adjustment Date E A 
TEXTRMIT 7 String*60 Entry Description E A 
TXTRMITREF 8 String*60 Entry Reference E A 
AMTRMIT 9 BCD*10.3 Bank Receipt Amount E A 
AMTRMITTC 10 BCD*10.3 Cust. Receipt Amount E A C 
RATEEXCHTC 11 BCD*8.7 Cust. Exchange Rate E A 
SWRATETC 12 Integer Cust. Rate Overridden E A  List:2 entries
0 = No
1 = Yes
CNTPAYMETR 13 BCD*3.0 Number of Documents Applied to E A C 
AMTPAYMTC 14 BCD*10.3 Total Cust. Amount Applied E A C 
AMTDISCTC 15 BCD*10.3 Total Cust. Discount Amount E A C 
CODEPAYM 16 String*12 Payment Code E A  Mask: %-12N
CODECURN 17 String*3 Customer Currency Code E A C  Mask: %-3N
RATETYPEHC 18 String*2 Bank Rate Type E A  Mask: %-2N
RATEEXCHHC 19 BCD*8.7 Bank Exchange Rate E A 
SWRATEHC 20 Integer Bank Rate Overridden E A  List:2 entries
0 = No
1 = Yes
RMITTYPE 21 Integer Receipt Trans. Type E A P  List:7 entries
1 = Receipt
2 = Prepayment
3 = Unapplied Cash
4 = Apply Document
5 = Misc. Receipt
6 = Write-Off
7 = Adjustment
DOCTYPE 22 Integer Document Type E A P  List:8 entries
1 = (None)
2 = Document Number
3 = PO Number
4 = Order Number
5 = Prepayment
6 = Unapplied Cash
7 = Credit Note
8 = Receipt
IDINVCMTCH 25 String*22 Matching Document Number E A  Mask: %-22C
CNTLSTLINE 30 BCD*3.0 Last Line Number E A C 
FISCYR 31 String*4 Fiscal Year A C  Mask: %04D
FISCPER 32 String*2 Fiscal Period A C  Mask: %02D
TEXTPAYOR 33 String*60 Payer E A 
DATERATETC 34 Date Cust. Rate Date E A 
RATETYPETC 35 String*2 Cust. Rate Type E A  Mask: %-2N
AMTADJENT 36 BCD*10.3 Cust. Adjustment Amount E A C 
DATERATEHC 37 Date Bank Rate Date E A 
PAYMTYPE 38 Integer Payment Type E A C P  List:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
5 = SPS Credit Card
4 = Other
REMUNAPLTC 39 BCD*10.3 Cust. Unapplied Amount E A C 
REMUNAPL 40 BCD*10.3 Bank Unapplied Amount E A C 
AMTRMITHC 41 BCD*10.3 Func. Receipt Amount E A C 
DOCNBR 42 String*22 Document Number E A  Mask: %-22C
AMTADJHC 43 BCD*10.3 Func. Adjustment Amount E A C 
OPERBANK 44 Integer Bank Rate Operator E A C  List:2 entries
1 = Multiply
2 = Divide
OPERCUST 45 Integer Customer Rate Operator E A C  List:2 entries
1 = Multiply
2 = Divide
AMTDISCHC 46 BCD*10.3 Total Func. Discount Amount E A C 
AMTDBADJHC 47 BCD*10.3 Total Func. Debit Amount E A C 
AMTCRADJHC 48 BCD*10.3 Total Func. Credit Amount E A C 
AMTDBADJTC 49 BCD*10.3 Total Cust. Debit Amount E A C 
AMTCRADJTC 50 BCD*10.3 Total Cust. Credit Amount E A C 
SWJOB 51 Integer Job Related E A  List:2 entries
0 = No
1 = Yes
APPLYMETH 52 Integer Job Apply Method E A  List:2 entries
0 = Prorate by Amount
1 = Top Down
ERRBATCH 53 Long Error Batch E A C 
ERRENTRY 54 Long Error Entry E A C 
VALUES 55 Long Optional Fields E A C 
PROCESSCMD 56 Integer Process Command Code E A C  List:7 entries
0 = Insert Optional Fields
1 = Calculate Taxes
2 = Distribute Taxes
3 = Derive Tax Reporting Exchange Rate
4 = Quick Charge
41 = Quick Charge (CNA2/1)
42 = Quick Charge (CNA2/2)
SRCEAPPL 57 String*2 Source Application E A  Mask: %-2A
IDBANK 58 String*8 Bank Code E A  Mask: %-8N
CODECURNBC 59 String*3 Bank Currency Code E A  Mask: %-3N
DRILLAPP 65 String*2 Drill Down Application Source E A  Mask: %-2A
DRILLTYPE 66 Integer Drill Down Type E A 
DRILLDWNLK 67 BCD*10.0 Drill Down Link Number E A 
SWPRINTED 68 Integer Receipt Printed E A  List:2 entries
0 = No
1 = Yes
SWTXAMTCTL 69 Integer Calculate Tax E A  List:2 entries
0 = No
1 = Yes
CODETAXGRP 70 String*12 Tax Group E A  Mask: %-12N
TAXVERSION 71 Long Tax State Version E A C 
CODETAX1 72 String*12 Tax Authority 1 E A C  Mask: %-12N
CODETAX2 73 String*12 Tax Authority 2 E A C  Mask: %-12N
CODETAX3 74 String*12 Tax Authority 3 E A C  Mask: %-12N
CODETAX4 75 String*12 Tax Authority 4 E A C  Mask: %-12N
CODETAX5 76 String*12 Tax Authority 5 E A C  Mask: %-12N
TAXCLASS1 77 Integer Tax Class 1 E A 
TAXCLASS2 78 Integer Tax Class 2 E A 
TAXCLASS3 79 Integer Tax Class 3 E A 
TAXCLASS4 80 Integer Tax Class 4 E A 
TAXCLASS5 81 Integer Tax Class 5 E A 
TXBSE1TC 82 BCD*10.3 Tax Base 1 E A 
TXBSE2TC 83 BCD*10.3 Tax Base 2 E A 
TXBSE3TC 84 BCD*10.3 Tax Base 3 E A 
TXBSE4TC 85 BCD*10.3 Tax Base 4 E A 
TXBSE5TC 86 BCD*10.3 Tax Base 5 E A 
TXAMT1TC 87 BCD*10.3 Tax Amount 1 E A 
TXAMT2TC 88 BCD*10.3 Tax Amount 2 E A 
TXAMT3TC 89 BCD*10.3 Tax Amount 3 E A 
TXAMT4TC 90 BCD*10.3 Tax Amount 4 E A 
TXAMT5TC 91 BCD*10.3 Tax Amount 5 E A 
TXTOTTC 92 BCD*10.3 Tax Total E A C 
AMTNETTC 93 BCD*10.3 Dist. Amount Net of Taxes E A C 
DEPSEQ 94 ??? Deposit Serial Number E A C 
DEPLINE 95 Long Deposit Line Number E A C 
CODECURNRC 96 String*3 Tax Reporting Currency Code E A  Mask: %-3N
SWTXCTLRC 97 Integer Tax Reporting Calculate Method E A  List:2 entries
0 = No
1 = Yes
RATERC 98 BCD*8.7 Tax Reporting Exchange Rate E A 
RATETYPERC 99 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEDATERC 100 Date Tax Reporting Rate Date E A 
RATEOPRC 101 Integer Tax Reporting Rate Operator E A C  List:2 entries
1 = Multiply
2 = Divide
SWRATERC 102 Integer Tax Reporting Rate Override E A C  List:2 entries
0 = No
1 = Yes
TXAMT1RC 103 BCD*10.3 Tax Reporting Amount 1 E A 
TXAMT2RC 104 BCD*10.3 Tax Reporting Amount 2 E A 
TXAMT3RC 105 BCD*10.3 Tax Reporting Amount 3 E A 
TXAMT4RC 106 BCD*10.3 Tax Reporting Amount 4 E A 
TXAMT5RC 107 BCD*10.3 Tax Reporting Amount 5 E A 
TXTOTRC 108 BCD*10.3 Tax Reporting Total E A C 
CNTACC 110 Long Number of Advance Credit Claims E A C 
AMTACCTC 111 BCD*10.3 Total Advance Credit Claim E A C 
AMTACCHC 112 BCD*10.3 Func. Total Advance Credit Claim E A C 
AMTPAYMHC 113 BCD*10.3 Func. Total Cust. Amount Applied E A C 
REMUNAPLHC 114 BCD*10.3 Func Cust. Unapplied Amount E A C 
TXBSE1HC 115 BCD*10.3 Func. Tax Base 1 E A C 
TXBSE2HC 116 BCD*10.3 Func. Tax Base 2 E A C 
TXBSE3HC 117 BCD*10.3 Func. Tax Base 3 E A C 
TXBSE4HC 118 BCD*10.3 Func. Tax Base 4 E A C 
TXBSE5HC 119 BCD*10.3 Func. Tax Base 5 E A C 
TXAMT1HC 120 BCD*10.3 Func. Tax Amount 1 E A C 
TXAMT2HC 121 BCD*10.3 Func. Tax Amount 2 E A C 
TXAMT3HC 122 BCD*10.3 Func. Tax Amount 3 E A C 
TXAMT4HC 123 BCD*10.3 Func. Tax Amount 4 E A C 
TXAMT5HC 124 BCD*10.3 Func. Tax Amount 5 E A C 
TXTOTHC 125 BCD*10.3 Func. Tax Total E A C 
AMTNETHC 126 BCD*10.3 Func. Dist. Amount Net of Taxes E A C 
ARVERSION 127 String*3 A/R Version Created In E A C 
ENTEREDBY 128 String*8 Entered By E A C 
DATEBUS 129 Date Posting Date E A 
IDACCTSET 130 String*6 Account Set E A  Mask: %-6N
CCPREVID 131 String*36 Previous C.C. Transaction Number E A 
CCPREVSTTS 132 Integer Previous C.C. Process Status E A  List:5 entries
0 = SPS Transaction Not Started
1 = SPS Sales Transaction Pending
2 = SPS Sales Transaction Completed
7 = SPS Void Transaction Pending
8 = SPS Void Transaction Completed
CCTRANID 133 String*36 Current C.C. Transaction Number E A 
CCTRANSTTS 134 Integer Current C.C. Process Status E A  List:5 entries
0 = SPS Transaction Not Started
1 = SPS Sales Transaction Pending
2 = SPS Sales Transaction Completed
7 = SPS Void Transaction Pending
8 = SPS Void Transaction Completed
PROCESSCOD 135 String*12 Processing Code E A  Mask: %-12N
TRANSID 136 String*36 Transaction ID E A 
XMLSTRING 137 String*20000 XML String E A 
RESPIND 138 String*1 Response Indicator E A 
RESPCD 139 String*6 Response Code E A 
RESPMSG 140 String*32 Response Message E A 
AUTHCODE 141 String*6 Authorization Code E A 
AVSRESULT 142 String*1 AVSResult E A 
CVVRESULT 143 String*1 CVVResult E A 
TRANSDATE 144 String*22 Transaction Date E A 
VANREF 145 String*16 VANReference E A 
LAST4 146 String*16 Last 4 E A 
PMTDESC 147 String*30 Payment Description E A 
PMTTYPEID 148 String*1 Payment Type ID E A 
AMTWHT1TC 149 BCD*10.3 Estimated Tax Withheld Amount 1 E A 
AMTWHT2TC 150 BCD*10.3 Estimated Tax Withheld Amount 2 E A 
AMTWHT3TC 151 BCD*10.3 Estimated Tax Withheld Amount 3 E A 
AMTWHT4TC 152 BCD*10.3 Estimated Tax Withheld Amount 4 E A 
AMTWHT5TC 153 BCD*10.3 Estimated Tax Withheld Amount 5 E A 

This page was generated on 2023-Aug-31

© 2023 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).