View: Bank Entries Header

RotoID: BK0450
Table: BKENTH
Protocol: Header, Key auto generate
DLL:BKENTH

Compositions: 6

RotoID Tables Title DLL
BK0460 BKENTD Bank Entries BKENTD
BK0001 BKACCT Banks BKACCT
BK0845 BKTRANH Bank Transaction Header BKTRANH
BK0840 BKTRAND Bank Transaction Details BKTRAND
CS0004 CSCRT Rate Types CSCRT
BK0002 BKCUR Bank Currencies BKCUR

Keys: 5

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

Fields: 48

Field Index Type Title Attributes Presentation
SEQUENCENO 1 Long Sequence Number E A K R 
ENTRYNBR 2 String*22 Bank Entry Number E A  Mask: %-22C
BANK 3 String*8 Bank Code E A X  Mask: %-8N
TRANSDATE 4 Date Date Created E A X 
TRANSTYPE 5 Integer Bank Entry Type E A X  List:2 entries
1 = Withdrawals
2 = Deposits
REFERENCE 6 String*60 Entry Description E A 
COMMENT 7 String*60 Comment(Reserved) E A 
TOTSRCEAMT 8 BCD*10.3 Entry Total Without Tax E A C 
TOTFUNCAMT 9 BCD*10.3 Func. Entry Total Without Tax E A C 
TOTSRCEGRO 10 BCD*10.3 Entry Total E A C 
TOTFUNCGRO 11 BCD*10.3 Func. Entry Total E A C 
RATETYPE 12 String*2 Exchange Rate Type E A X  Mask: %-2N
SRCECURN 13 String*3 Bank Entry Currency E A X  Mask: %-3N
RATEDATE 14 Date Exchange Rate Date E A X 
RATE 15 BCD*8.7 Exchange Rate E A X 
RATESPREAD 16 BCD*8.7 Rate Spread E A X 
RATEOP 17 Integer Rate Operation E A X  List:3 entries
1 = Multiply
2 = Divide
0 = Not Specified
POSTDATE 18 Date Bank Entry Date E A X 
POSTYEAR 19 String*4 Bank Entry Year A X  Mask: %04D
POSTPERIOD 20 Integer Bank Entry Period A P X 
COMPLETED 21 Integer Completed Status E A X  List:2 entries
0 = Not Completed
10 = Completed
BIGCOMMENT 22 String*250 Comments E A 
STATUS 23 Integer Status A C  List:4 entries
0 = Not posted
1 = Posted
2 = Reversed
3 = Cleared
RECDATE 24 Date Reconcilation Date E A X 
RECYEAR 25 String*4 Reconcilation Year E A X  Mask: %04D
RECPERIOD 26 Integer Reconcilation Period E A P X 
LINES 27 Long Number of Lines E A C 
SERIAL 28 ??? Bank Entry Serial Number E A X 
RUNID 29 Long Run Id A X 
TYPE 30 Integer Payment Type E A X  List:4 entries
1 = Check
5 = Credit Card
6 = Cash
7 = Other
OFXTID 36 String*50 OFX Transaction ID E A X 
ENTRYTYPE 37 Integer Entry Type E A P  List:4 entries
0 = User-entered
10 = Unmatched OFX
19 = Unmatched OFX correction
20 = Unmatched OFX error
DSETCODE 38 String*6 Distribution Set E A X  Mask: %-6N
PSTSEQ 39 BCD*5.0 Posting Sequence E A 
BANKD 50 String*60 Bank Name A 
BKACCT 51 String*22 Bank Account A 
BKSTMTCUR 52 String*3 Bank Statement Currency A 
DSETCODED 53 String*60 Distribution Set Desc A 
TOTSTMTAMT 54 BCD*10.3 Total Statement Amount A 
RECPENT 55 BCD*10.3 Fiscal Entry Amount A 
RECPENTREC 56 BCD*10.3 Reconciled Entry Amount A 
DEFENTNUM 57 String*22 Default New Document Number A 
PROCESSCMD 58 Integer Process Command E A C  List:1 entries
0 = Create Distribution
AGERECLD 59 Integer Aging Recon. days A C 
RETENTNO 62 Integer Keep Input Entry No. E A C 
SRCECURND 63 String*60 Bank Entry Currency Desc. A 
DEFBANK 64 String*8 Default Bank Code A C 
VDEFBANK 65 Boolean Error in Auto Bank A C 

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