View: Posted Receipts

RotoID: AR0040
Table: ARRRH
Protocol: Flat
DLL:ARRRH

Keys: 7

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
Invoice No. IDINVCMTCH

Fields: 103

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 ??? 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*8.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  List:2 entries
0 = No
1 = Yes
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 P  List:5 entries
1 = Cash
2 = Check
3 = Credit Card
5 = SPS 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 
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 
CNTACC 94 Long Number of Advance Credit Claims E A C 
AMTACCTC 95 BCD*10.3 Total Advance Credit Claim E A C 
AMTACCHC 96 BCD*10.3 Func. Total Advance Credit Claim E A C 
DATEBUS 97 Date Posting Date E A 
CCTRANID 98 String*36 Credit Card Transaction Number E A 
PROCESSCOD 99 String*12 Processing Code E A 
LAST4 100 String*16 Card Number E A 
CARDTYPE 101 Integer Card Type E A  List:7 entries
0 =
3 = American Express
4 = Visa
5 = MasterCard
6 = Discover
7 = JCB
68 = Debit Card
AMTWHT1TC 102 BCD*10.3 Tax Withheld 1 E A 
AMTWHT2TC 103 BCD*10.3 Tax Withheld 2 E A 
AMTWHT3TC 104 BCD*10.3 Tax Withheld 3 E A 
AMTWHT4TC 105 BCD*10.3 Tax Withheld 4 E A 
AMTWHT5TC 106 BCD*10.3 Tax Withheld 5 E A 
CUSTCURN 107 String*3 Customer Currency E A 

This page was generated on 2022-Aug-18

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