Table: Posted Receipts

Table: ARRRH
View: AR0040
Record Length: 948

Flags: A R 

Keys: 7

Title Flags Fields

Bank, Cust. and Check/Rec. No. IDBANKIDCUSTIDRMITDEPSEQDEPLINEDATERMIT
Cust. and Check/Ref. No. D M  IDCUSTIDRMIT
Bank, Batch and Entry No. D M  IDBANKCNTBTCHCNTITEM
Cust., Check/Ref., Batch Date D M  IDCUSTIDRMITDATEBTCH
Bank, Dep. Serial, Dep. Line D M  IDBANKDEPSEQDEPLINE
Cust.,Check Date,Check/Rec. No. D M  IDCUSTDATERMITIDRMIT
Invoice No. D M  IDINVCMTCH

Fields: 104

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 ??? Deposit Serial Number
DEPLINE Long Deposit Line Number
DATERMIT Date Receipt Date
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
DEPSTNBR BCD*8.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:5 entries
1 = Cash
2 = Check
3 = Credit Card
5 = SPS 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
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
CCTRANID String*36 Credit Card Transaction Number
PROCESSCOD String*12 Processing Code
AMTWHT1TC BCD*10.3 Tax Withheld 1
AMTWHT2TC BCD*10.3 Tax Withheld 2
AMTWHT3TC BCD*10.3 Tax Withheld 3
AMTWHT4TC BCD*10.3 Tax Withheld 4
AMTWHT5TC BCD*10.3 Tax Withheld 5