View: Bank Entries Journal Header

RotoID: BK0665
Table: BKJENTH
Protocol: Header
DLL:BKJENTH

Compositions: 2

RotoID Tables Title DLL
BK0020 BKJCTL Bank Posting Journal Control BKJCTL
BK0660 BKJENTD Bank Entries Journal Detail BKJENTD

Keys: 1

Title Fields
Bank Entry by Posting Sequence PSTSEQ, SEQUENCENO

Fields: 46

Field Index Type Title Attributes Presentation
PSTSEQ 1 BCD*5.0 Posting Sequence E A K R 
SEQUENCENO 2 Long Sequence Number E A K R 
ENTRYNBR 3 String*22 Bank Entry Number E A  Mask: %-22C
BANK 4 String*8 Bank Code E A  Mask: %-8N
TRANSDATE 5 Date Date Created E A 
TRANSTYPE 6 Integer Bank Entry Type E A 
REFERENCE 7 String*60 Entry Description E A 
COMMENT 8 String*60 Comment(Reserved) E A 
TOTSRCEAMT 9 BCD*10.3 Total Source Amount E A 
TOTFUNCAMT 10 BCD*10.3 Total Functional Amount E A 
TOTSRCEGRO 11 BCD*10.3 Total Gross Source Amt E A 
TOTFUNCGRO 12 BCD*10.3 Total Gross Functional Amt E A 
RATETYPE 13 String*2 Exchange Rate Type E A 
SRCECURN 14 String*3 Bank Entry Currency E A 
RATEDATE 15 Date Exchange Rate Date E A 
RATE 16 BCD*8.7 Exchange Rate E A 
RATESPREAD 17 BCD*8.7 Rate Spread E A 
RATEOP 18 Integer Rate Operation E A 
POSTDATE 19 Date Bank Entry Date E A 
POSTYEAR 20 String*4 Bank Entry Year E A 
POSTPERIOD 21 Integer Bank Entry Period E A 
COMPLETED 22 Integer Completed Status E A 
BIGCOMMENT 23 String*250 Comments E A 
STATUS 24 Integer Status E A 
RECDATE 25 Date Reconcilation Date E A 
RECYEAR 26 String*4 Reconcilation Year E A  Mask: %04D
RECPERIOD 27 Integer Reconcilation Period E A 
LINES 28 Long Number of Lines E A 
SERIAL 29 ??? Bank Entry Serial Number E A 
RUNID 30 Long Run Id E A 
TYPE 31 Integer Payment Type E A 
OFXTID 37 String*50 OFX Transaction ID E A 
ENTRYTYPE 38 Integer Entry Type E A 
DSETCODE 39 String*6 Distribution Set E A  Mask: %-6N
BANKD 40 String*60 Bank Name E A 
BKACCT 41 String*22 Bank Account E A 
BKSTMTCUR 42 String*3 Bank Statement Currency E A 
DSETCODED 43 String*60 Distribution Set Desc E A 
TOTSTMTAMT 44 BCD*10.3 Total Statement Amount E A 
TRANSCUR 45 String*3 Bank Entry Currency E A 
RECPENT 46 BCD*10.3 Fiscal Entry Amount E A 
RECPENTREC 47 BCD*10.3 Reconciled Entry Amount E A 
DEFENTNUM 48 String*22 Default New Document Number E A 
PROCESSCMD 49 Integer Process Command E A 
AGERECLD 50 Integer Aging Recon. days E A 
RETENTNO 53 Integer Keep Input Entry No. E A 

This page was generated on 2023-Aug-31

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