# View: Posted Receipts

RotoID: AR0040
Table: ARRRH
DLL: ARRRH

## Compositions: 0

## Keys: 6

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

## Fields: 93

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
IDBANK | 1 | String*8 | Bank Code | E A K R | Mask: %-8N
IDCUST | 2 | String*12 | Customer Number | E A K R | Mask: %-12C
IDRMIT | 3 | String*24 | Check/Receipt No. | E A K R | Mask: %-24C
DEPSEQ | 28 | Long | Deposit Serial Number | E A K R |
DEPLINE | 38 | Long | Deposit Line Number | E A K R |
DATERMIT | 4 | Date | Receipt Date | E A K R |
DEPSTNBR | 5 | BCD*5.0 | Deposit Number | E A |
DATEBTCH | 6 | Date | Batch Date | E A |
AMTRMITTC | 7 | BCD*10.3 | Cust. Receipt Amount | E A |
AMTPAYM | 8 | BCD*10.3 | Bank Receipt Amount | E A |
AMTDISC | 9 | BCD*10.3 | Cust. Discount Amount | E A |
PAYMCODE | 10 | String*12 | Payment Code | E A | Mask: %-12N
CODECURN | 11 | String*3 | Currency Code | E A | Mask: %-3N
IDRATETYPE | 12 | String*2 | Bank Rate Type | E A | Mask: %-2N
RATEEXCHHC | 13 | BCD*8.7 | Bank Exchange Rate | E A |
SWOVRDRATE | 14 | Integer | Bank Rate Override | E A |
TEXTRETRN | 15 | String*60 | Reason for Return | E A |
DATELSTMTN | 16 | Date | Date Last Maintained | E A |
DATELSTSTM | 17 | Date | Last Statement Date | E A |
AMTROUNDER | 18 | BCD*10.3 | Amount of Rounding Error | E A |
DATERATE | 19 | Date | Bank to Func. Rate Date | E A |
FISCYR | 20 | String*4 | Fiscal Year | E A | Mask: %04D
FISCPER | 21 | String*2 | Fiscal Period | E A | Mask: %02D
NAMERMIT | 22 | String*60 | Payer | E A |
CNTBTCH | 23 | BCD*5.0 | Batch Number | E A |
CNTITEM | 24 | BCD*4.0 | Entry Number | E A |
SWCHKCLRD | 25 | Integer | Check Cleared | E A | List: 3 entries
0 | = | Outstanding
1 | = | Cleared
2 | = | Returned
AMTRMITHC | 26 | BCD*10.3 | Func. Receipt Amount | E A |
AMTADJ | 27 | BCD*10.3 | Cust. Adjustment Amount | E A |
DATECLRD | 29 | Date | Date Cleared | E A |
DATERVRSD | 30 | Date | Date Returned | E A |
TRXTYPETXT | 31 | Integer | Document Type | E A | List: 3 entries
5 | = | Unapplied Cash
10 | = | Prepayment
11 | = | Receipt
IDINVC | 32 | String*22 | Document No. | E A |
RATEOP | 33 | Integer | Rate Operator | E A |
PAYMTYPE | 34 | Integer | Payment Type | E A | List: 4 entries
1 | = | Cash
2 | = | Check
3 | = | Credit Card
4 | = | Other
DRILLAPP | 35 | String*2 | Drill Down Application Source | E A | Mask: %-2A
DRILLTYPE | 36 | Integer | Drill Down Type | E A |
DRILLDWNLK | 37 | BCD*10.0 | Drill Down Link Number | E A |
CCTYPE | 39 | String*12 | Credit Card Type | E A | Mask: %-12N
CCNUMBER | 40 | Binary*32 | Credit Card Number | E A |
CCNAME | 41 | String*60 | Credit Card Name | E A |
CCAUTHCODE | 42 | String*20 | Authorization Code | E A |
SWNONRCVBL | 43 | Integer | Misc. Receipt Flag | E A |
SWJOB | 44 | Integer | Job Related | E A | List: 2 entries
0 | = | No
1 | = | Yes
IDINVCMTCH | 45 | String*22 | Invoice Number | E A |
SWTXAMTCTL | 46 | Integer | Calculate Tax | E A | List: 2 entries
0 | = | No
1 | = | Yes
CODETAXGRP | 47 | String*12 | Tax Group | E A | Mask: %-12N
CODETAX1 | 48 | String*12 | Tax Authority 1 | E A | Mask: %-12N
CODETAX2 | 49 | String*12 | Tax Authority 2 | E A | Mask: %-12N
CODETAX3 | 50 | String*12 | Tax Authority 3 | E A | Mask: %-12N
CODETAX4 | 51 | String*12 | Tax Authority 4 | E A | Mask: %-12N
CODETAX5 | 52 | String*12 | Tax Authority 5 | E A | Mask: %-12N
TAXCLASS1 | 53 | Integer | Tax Class 1 | E A |
TAXCLASS2 | 54 | Integer | Tax Class 2 | E A |
TAXCLASS3 | 55 | Integer | Tax Class 3 | E A |
TAXCLASS4 | 56 | Integer | Tax Class 4 | E A |
TAXCLASS5 | 57 | Integer | Tax Class 5 | E A |
TXBSE1TC | 58 | BCD*10.3 | Tax Base 1 | E A |
TXBSE2TC | 59 | BCD*10.3 | Tax Base 2 | E A |
TXBSE3TC | 60 | BCD*10.3 | Tax Base 3 | E A |
TXBSE4TC | 61 | BCD*10.3 | Tax Base 4 | E A |
TXBSE5TC | 62 | BCD*10.3 | Tax Base 5 | E A |
TXAMT1TC | 63 | BCD*10.3 | Tax Amount 1 | E A |
TXAMT2TC | 64 | BCD*10.3 | Tax Amount 2 | E A |
TXAMT3TC | 65 | BCD*10.3 | Tax Amount 3 | E A |
TXAMT4TC | 66 | BCD*10.3 | Tax Amount 4 | E A |
TXAMT5TC | 67 | BCD*10.3 | Tax Amount 5 | E A |
TXTOTTC | 68 | BCD*10.3 | Tax Total | E A |
AMTNETTC | 69 | BCD*10.3 | Dist. Amount Net of Taxes | E A |
CODECURNRC | 70 | String*3 | Tax Reporting Currency Code | E A | Mask: %-3N
SWTXCTLRC | 71 | Integer | Tax Reporting Calculate Method | E A | List: 2 entries
0 | = | No
1 | = | Yes
RATERC | 72 | BCD*8.7 | Tax Reporting Exchange Rate | E A |
RATETYPERC | 73 | String*2 | Tax Reporting Rate Type | E A | Mask: %-2N
RATEDATERC | 74 | Date | Tax Reporting Rate Date | E A |
RATEOPRC | 75 | Integer | Tax Reporting Rate Operator | E A |
TXAMT1RC | 76 | BCD*10.3 | Tax Reporting Amount 1 | E A |
TXAMT2RC | 77 | BCD*10.3 | Tax Reporting Amount 2 | E A |
TXAMT3RC | 78 | BCD*10.3 | Tax Reporting Amount 3 | E A |
TXAMT4RC | 79 | BCD*10.3 | Tax Reporting Amount 4 | E A |
TXAMT5RC | 80 | BCD*10.3 | Tax Reporting Amount 5 | E A |
TXTOTRC | 81 | BCD*10.3 | Tax Reporting Total | E A |
TXBSE1HC | 82 | BCD*10.3 | Func. Tax Base 1 | E A |
TXBSE2HC | 83 | BCD*10.3 | Func. Tax Base 2 | E A |
TXBSE3HC | 84 | BCD*10.3 | Func. Tax Base 3 | E A |
TXBSE4HC | 85 | BCD*10.3 | Func. Tax Base 4 | E A |
TXBSE5HC | 86 | BCD*10.3 | Func. Tax Base 5 | E A |
TXAMT1HC | 87 | BCD*10.3 | Func. Tax Amount 1 | E A |
TXAMT2HC | 88 | BCD*10.3 | Func. Tax Amount 2 | E A |
TXAMT3HC | 89 | BCD*10.3 | Func. Tax Amount 3 | E A |
TXAMT4HC | 90 | BCD*10.3 | Func. Tax Amount 4 | E A |
TXAMT5HC | 91 | BCD*10.3 | Func. Tax Amount 5 | E A |
TXTOTHC | 92 | BCD*10.3 | Func. Tax Total | E A |
AMTNETHC | 93 | BCD*10.3 | Func. Dist. Amount Net of Taxes | E A |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.