# Table: Posted Receipts

Table: ARRRH
View: AR0040
Record length: 967
Flags: A R

## Keys: 7

Title | Flags | Fields
--- | --- | ---
Bank, Cust. and Check/Rec. No. |  | IDBANK, IDCUST, IDRMIT, DEPSEQ, DEPLINE, DATERMIT
Cust. and Check/Ref. No. | D M | IDCUST, IDRMIT
Bank, Batch and Entry No. | D M | IDBANK, CNTBTCH, CNTITEM
Cust., Check/Ref., Batch Date | D M | IDCUST, IDRMIT, DATEBTCH
Bank, Dep. Serial, Dep. Line | D M | IDBANK, DEPSEQ, DEPLINE
Cust.,Check Date,Check/Rec. No. | D M | IDCUST, DATERMIT, IDRMIT
Invoice No. | D M | IDINVCMTCH

## Fields: 101

Field | Type | Title | Presentation
--- | --- | --- | ---
IDBANK | String*8 | Bank Code | Mask: %-8N
IDCUST | String*12 | Customer Number | Mask: %-12C
IDRMIT | String*24 | Check/Receipt No. | Mask: %-24C
DEPSEQ | Long | Deposit Serial Number |
DEPLINE | Long | Deposit Line Number |
DATERMIT | Date | Receipt Date |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
DEPSTNBR | BCD*5.0 | Deposit Number |
DATEBTCH | Date | Batch Date |
AMTRMITTC | BCD*10.3 | Cust. Receipt Amount |
AMTPAYM | BCD*10.3 | Bank Receipt Amount |
AMTDISC | BCD*10.3 | Cust. Discount Amount |
PAYMCODE | String*12 | Payment Code | Mask: %-12N
CODECURN | String*3 | Currency Code | Mask: %-3N
IDRATETYPE | String*2 | Bank Rate Type | Mask: %-2N
RATEEXCHHC | BCD*8.7 | Bank Exchange Rate |
SWOVRDRATE | Integer | Bank Rate Override | List: 2 entries
0 | = | No
1 | = | Yes
TEXTRETRN | String*60 | Reason for Return |
DATELSTMTN | Date | Date Last Maintained |
DATELSTSTM | Date | Last Statement Date |
AMTROUNDER | BCD*10.3 | Amount of Rounding Error |
DATERATE | Date | Bank to Func. Rate Date |
FISCYR | String*4 | Fiscal Year | Mask: %04D
FISCPER | String*2 | Fiscal Period | Mask: %02D
NAMERMIT | String*60 | Payer |
CNTBTCH | BCD*5.0 | Batch Number |
CNTITEM | BCD*4.0 | Entry Number |
SWCHKCLRD | Integer | Check Cleared | List: 3 entries
0 | = | Outstanding
1 | = | Cleared
2 | = | Returned
AMTRMITHC | BCD*10.3 | Func. Receipt Amount |
AMTADJ | BCD*10.3 | Cust. Adjustment Amount |
DATECLRD | Date | Date Cleared |
DATERVRSD | Date | Date Returned |
TRXTYPETXT | Integer | Document Type | List: 3 entries
5 | = | Unapplied Cash
10 | = | Prepayment
11 | = | Receipt
IDINVC | String*22 | Document No. |
RATEOP | Integer | Rate Operator |
PAYMTYPE | Integer | Payment Type | List: 4 entries
1 | = | Cash
2 | = | Check
3 | = | Credit Card
4 | = | Other
DRILLAPP | String*2 | Drill Down Application Source | Mask: %-2A
DRILLTYPE | Integer | Drill Down Type |
DRILLDWNLK | BCD*10.0 | Drill Down Link Number |
CCTYPE | String*12 | Credit Card Type | Mask: %-12N
CCNUMBER | Binary*32 | Credit Card Number |
CCNAME | String*60 | Credit Card Name |
CCAUTHCODE | String*20 | Authorization Code |
SWNONRCVBL | Integer | Misc. Receipt Flag |
SWJOB | Integer | Job Related | List: 2 entries
0 | = | No
1 | = | Yes
IDINVCMTCH | String*22 | Invoice Number |
SWTXAMTCTL | Integer | Calculate Tax | List: 2 entries
0 | = | No
1 | = | Yes
CODETAXGRP | String*12 | Tax Group | Mask: %-12N
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 |
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 |
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 |
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 |
CNTACC | Long | Number of Advance Credit Claims |
AMTACCTC | BCD*10.3 | Total Advance Credit Claim |
AMTACCHC | BCD*10.3 | Func. Total Advance Credit Claim |
DATEBUS | Date | Posting Date |

This page was generated on 2009-Nov-19

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