Table: Receipts/Adjustments

Table: ARTCR
View: AR0042
Record Length: 1184

Flags: A R 

Keys: 4

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

Fields: 131

Field Type Title Presentation
CODEPYMTYP String*2 Batch Type Mask: %-2N
CNTBTCH BCD*5.0 Batch Number
CNTITEM BCD*4.0 Entry Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
IDRMIT String*24 Check/Receipt No. Mask: %-24C
IDCUST String*12 Customer Number Mask: %-12C
DATERMIT Date Receipt Date/Adjustment Date
TEXTRMIT String*60 Entry Description
TXTRMITREF String*60 Entry Reference
AMTRMIT BCD*10.3 Bank Receipt Amount
AMTRMITTC BCD*10.3 Cust. Receipt Amount
RATEEXCHTC BCD*8.7 Cust. Exchange Rate
SWRATETC Integer Cust. Rate Overridden List:2 entries
0 = No
1 = Yes
CNTPAYMETR BCD*3.0 Number of Documents Applied to
AMTPAYMTC BCD*10.3 Total Cust. Amount Applied
AMTDISCTC BCD*10.3 Total Cust. Discount Amount
CODEPAYM String*12 Payment Code Mask: %-12N
CODECURN String*3 Customer Currency Code Mask: %-3N
RATETYPEHC String*2 Bank Rate Type Mask: %-2N
RATEEXCHHC BCD*8.7 Bank Exchange Rate
SWRATEHC Integer Bank Rate Overridden List:2 entries
0 = No
1 = Yes
RMITTYPE Integer Receipt Trans. Type List:7 entries
1 = Receipt
2 = Prepayment
3 = Unapplied Cash
4 = Apply Document
5 = Misc. Receipt
6 = Write-Off
7 = Adjustment
DOCTYPE Integer Document Type 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 String*22 Matching Document Number Mask: %-22C
CNTLSTLINE BCD*3.0 Last Line Number
FISCYR String*4 Fiscal Year Mask: %04D
FISCPER String*2 Fiscal Period Mask: %02D
TEXTPAYOR String*60 Payer
DATERATETC Date Cust. Rate Date
RATETYPETC String*2 Cust. Rate Type Mask: %-2N
AMTADJENT BCD*10.3 Cust. Adjustment Amount
DATERATEHC Date Bank Rate Date
PAYMTYPE Integer Payment Type List:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
5 = SPS Credit Card
4 = Other
REMUNAPLTC BCD*10.3 Cust. Unapplied Amount
REMUNAPL BCD*10.3 Bank Unapplied Amount
AMTRMITHC BCD*10.3 Func. Receipt Amount
DOCNBR String*22 Document Number Mask: %-22C
AMTADJHC BCD*10.3 Func. Adjustment Amount
OPERBANK Integer Bank Rate Operator List:2 entries
1 = Multiply
2 = Divide
OPERCUST Integer Customer Rate Operator List:2 entries
1 = Multiply
2 = Divide
AMTDISCHC BCD*10.3 Total Func. Discount Amount
AMTDBADJHC BCD*10.3 Total Func. Debit Amount
AMTCRADJHC BCD*10.3 Total Func. Credit Amount
AMTDBADJTC BCD*10.3 Total Cust. Debit Amount
AMTCRADJTC BCD*10.3 Total Cust. Credit Amount
SWJOB Integer Job Related List:2 entries
0 = No
1 = Yes
APPLYMETH Integer Job Apply Method List:2 entries
0 = Prorate by Amount
1 = Top Down
ERRBATCH Long Error Batch
ERRENTRY Long Error Entry
VALUES Long Optional Fields
SRCEAPPL String*2 Source Application Mask: %-2A
IDBANK String*8 Bank Code Mask: %-8N
CODECURNBC String*3 Bank Currency Code Mask: %-3N
DRILLAPP String*2 Drill Down Application Source Mask: %-2A
DRILLTYPE Integer Drill Down Type
DRILLDWNLK BCD*10.0 Drill Down Link Number
SWPRINTED Integer Receipt Printed List:2 entries
0 = No
1 = Yes
SWTXAMTCTL Integer Calculate Tax List:2 entries
0 = No
1 = Yes
CODETAXGRP String*12 Tax Group Mask: %-12N
TAXVERSION Long Tax State Version
CODETAX1 String*12 Tax Authority 1 Mask: %-12N
CODETAX2 String*12 Tax Authority 2 Mask: %-12N
CODETAX3 String*12 Tax Authority 3 Mask: %-12N
CODETAX4 String*12 Tax Authority 4 Mask: %-12N
CODETAX5 String*12 Tax Authority 5 Mask: %-12N
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
TXBSE1TC BCD*10.3 Tax Base 1
TXBSE2TC BCD*10.3 Tax Base 2
TXBSE3TC BCD*10.3 Tax Base 3
TXBSE4TC BCD*10.3 Tax Base 4
TXBSE5TC BCD*10.3 Tax Base 5
TXAMT1TC BCD*10.3 Tax Amount 1
TXAMT2TC BCD*10.3 Tax Amount 2
TXAMT3TC BCD*10.3 Tax Amount 3
TXAMT4TC BCD*10.3 Tax Amount 4
TXAMT5TC BCD*10.3 Tax Amount 5
TXTOTTC BCD*10.3 Tax Total
AMTNETTC BCD*10.3 Dist. Amount Net of Taxes
DEPSEQ ??? Deposit Serial Number
DEPLINE Long Deposit Line Number
CODECURNRC String*3 Tax Reporting Currency Code Mask: %-3N
SWTXCTLRC Integer Tax Reporting Calculate Method List:2 entries
0 = No
1 = Yes
RATERC BCD*8.7 Tax Reporting Exchange Rate
RATETYPERC String*2 Tax Reporting Rate Type Mask: %-2N
RATEDATERC Date Tax Reporting Rate Date
RATEOPRC Integer Tax Reporting Rate Operator List:2 entries
1 = Multiply
2 = Divide
SWRATERC Integer Tax Reporting Rate Override List:2 entries
0 = No
1 = Yes
TXAMT1RC BCD*10.3 Tax Reporting Amount 1
TXAMT2RC BCD*10.3 Tax Reporting Amount 2
TXAMT3RC BCD*10.3 Tax Reporting Amount 3
TXAMT4RC BCD*10.3 Tax Reporting Amount 4
TXAMT5RC BCD*10.3 Tax Reporting Amount 5
TXTOTRC BCD*10.3 Tax Reporting Total
CNTACC Long Number of Advance Credit Claims
AMTACCTC BCD*10.3 Total Advance Credit Claim
AMTACCHC BCD*10.3 Func. Total Advance Credit Claim
AMTPAYMHC BCD*10.3 Func. Total Cust. Amount Applied
REMUNAPLHC BCD*10.3 Func Cust. Unapplied Amount
TXBSE1HC BCD*10.3 Func. Tax Base 1
TXBSE2HC BCD*10.3 Func. Tax Base 2
TXBSE3HC BCD*10.3 Func. Tax Base 3
TXBSE4HC BCD*10.3 Func. Tax Base 4
TXBSE5HC BCD*10.3 Func. Tax Base 5
TXAMT1HC BCD*10.3 Func. Tax Amount 1
TXAMT2HC BCD*10.3 Func. Tax Amount 2
TXAMT3HC BCD*10.3 Func. Tax Amount 3
TXAMT4HC BCD*10.3 Func. Tax Amount 4
TXAMT5HC BCD*10.3 Func. Tax Amount 5
TXTOTHC BCD*10.3 Func. Tax Total
AMTNETHC BCD*10.3 Func. Dist. Amount Net of Taxes
ARVERSION String*3 A/R Version Created In
ENTEREDBY String*8 Entered By
DATEBUS Date Posting Date
IDACCTSET String*6 Account Set Mask: %-6N
CCPREVID String*36 Previous C.C. Transaction Number
CCPREVSTTS Integer Previous C.C. Process Status 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 String*36 Current C.C. Transaction Number
CCTRANSTTS Integer Current C.C. Process Status 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 String*12 Processing Code Mask: %-12N
AMTWHT1TC BCD*10.3 Estimated Tax Withheld Amount 1
AMTWHT2TC BCD*10.3 Estimated Tax Withheld Amount 2
AMTWHT3TC BCD*10.3 Estimated Tax Withheld Amount 3
AMTWHT4TC BCD*10.3 Estimated Tax Withheld Amount 4
AMTWHT5TC BCD*10.3 Estimated Tax Withheld Amount 5

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