Table: Bank Entries Header

Table: BKENTH
View: BK0450
Record length: 735
Flags: A R 

Keys: 5

Title  Flags  Fields

Bank Entry by Sequence  SEQUENCENO
Bank Entry by Entry No.  ENTRYNBR
Bank Entry by Bank, Entry No.  D M  BANK, ENTRYNBR
Bank Reconciliation Fiscal Entry  D M  ENTRYNBR, POSTYEAR, POSTPERIOD
Bank Entry by Bank, Serial No.  D M  BANK, SERIAL

Fields: 43

Field  Type  Title  Presentation 

SEQUENCENO  Long  Sequence Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
ENTRYNBR  String*22  Bank Entry Number  Mask: %-22C
BANK  String*8  Bank Code  Mask: %-8N
TRANSDATE  Date  Date Created   
TRANSTYPE  Integer  Bank Entry Type  List: 2 entries
1=Withdrawals
2=Deposits
REFERENCE  String*60  Entry Description   
COMMENT  String*60  Comment(Reserved)   
TOTSRCEAMT  BCD*10.3  Entry Total Without Tax   
TOTFUNCAMT  BCD*10.3  Func. Entry Total Without Tax   
TOTSRCEGRO  BCD*10.3  Entry Total   
TOTFUNCGRO  BCD*10.3  Func. Entry Total   
RATETYPE  String*2  Exchange Rate Type  Mask: %-2N
SRCECURN  String*3  Bank Entry Currency  Mask: %-3N
RATEDATE  Date  Exchange Rate Date   
RATE  BCD*8.7  Exchange Rate   
RATESPREAD  BCD*8.7  Rate Spread   
RATEOP  Integer  Rate Operation  List: 3 entries
1=Multiply
2=Divide
0=Not Specified
POSTDATE  Date  Bank Entry Date   
POSTYEAR  String*4  Bank Entry Year  Mask: %04D
POSTPERIOD  Integer  Bank Entry Period   
COMPLETED  Integer  Completed Status  List: 2 entries
0=Not Completed
10=Completed
BIGCOMMENT  String*250  Comments   
STATUS  Integer  Status  List: 4 entries
0=Not posted
1=Posted
2=Reversed
3=Cleared
RECDATE  Date  Reconcilation Date   
RECYEAR  String*4  Reconcilation Year  Mask: %04D
RECPERIOD  Integer  Reconcilation Period   
LINES  Long  Number of Lines   
SERIAL  Long  Bank Entry Serial Number   
RUNID  Long  Run Id   
TYPE  Integer  Payment Type  List: 4 entries
1=Check
5=Credit Card
6=Cash
7=Other
CCTYPE  String*12  Credit Card Type  Mask: %-12N
CCNUMBER  Binary*32  Credit Card Number   
CCNAME  String*60  Cardholder Name   
CCAUTHCODE  String*20  Authorization Code   
CCEXP  Date  Expiry Date   
OFXTID  String*50  OFX Transaction ID   
ENTRYTYPE  Integer  Entry Type  List: 4 entries
0=User-entered
10=Unmatched OFX
19=Unmatched OFX correction
20=Unmatched OFX error
DSETCODE  String*6  Distribution Set  Mask: %-6N
PSTSEQ  BCD*5.0  Posting Sequence   

This page was generated on 2009-Nov-19

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