# Table: Receipts/Adjustments

Table: ARTCR
View: AR0042
Record length: 1171
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: 126

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: 5 entries
0 | = | (None)
1 | = | Cash
2 | = | Check
3 | = | 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
CCTYPE | String*12 | Credit Card Type | Mask: %-12N
CCNUMBER | Binary*32 | Credit Card Number |
CCNAME | String*60 | Credit Card Name |
CCEXP | Date | Expiry Date (mm/yy) |
CCAUTHCODE | String*20 | Authorization Code |
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 | Long | 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

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.