# View: Receipts/Adjustments

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

## Compositions: 5

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

## Keys: 4

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

## Fields: 124

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 | 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 | List: 5 entries
0 | = | (None)
1 | = | Cash
2 | = | Check
3 | = | 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: 4 entries
0 | = | Insert Optional Fields
1 | = | Calculate Taxes
2 | = | Distribute Taxes
3 | = | Derive Tax Reporting Exchange Rate
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
CCTYPE | 60 | String*12 | Credit Card Type | E A | Mask: %-12N
CCNUMBER | 61 | Binary*32 | Credit Card Number | E A C X |
CCNAME | 62 | String*60 | Credit Card Name | E A |
CCEXP | 63 | Date | Expiry Date (mm/yy) | E A |
CCAUTHCODE | 64 | String*20 | Authorization Code | E A |
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 | Long | 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 |
XCCNUMBER | 109 | String*32 | Credit Card Number | E A | Mask: %-32D
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 |
DATEBUS | 129 | Date | Posting Date | E A |
IDACCTSET | 130 | String*6 | Account Set | E A | Mask: %-6N

This page was generated on 2008-May-01

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