Table: Posted Receipts

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

Keys: 6

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

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   
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 2008-May-01

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