Table: Bank Entries Journal Header

Table: BKJENTH
View: BK0665
Record Length: 816

Flags: A R 

Keys: 1

Title Flags Fields

Bank Entry by Posting Sequence PSTSEQSEQUENCENO

Fields: 50

Field Type Title Presentation

PSTSEQ BCD*5.0 Posting Sequence
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
REFERENCE String*60 Entry Description
COMMENT String*60 Comment(Reserved)
TOTSRCEAMT BCD*10.3 Total Source Amount
TOTFUNCAMT BCD*10.3 Total Functional Amount
TOTSRCEGRO BCD*10.3 Total Gross Source Amt
TOTFUNCGRO BCD*10.3 Total Gross Functional Amt
RATETYPE String*2 Exchange Rate Type
SRCECURN String*3 Bank Entry Currency
RATEDATE Date Exchange Rate Date
RATE BCD*8.7 Exchange Rate
RATESPREAD BCD*8.7 Rate Spread
RATEOP Integer Rate Operation
POSTDATE Date Bank Entry Date
POSTYEAR String*4 Bank Entry Year
POSTPERIOD Integer Bank Entry Period
COMPLETED Integer Completed Status
BIGCOMMENT String*250 Comments
STATUS Integer Status
RECDATE Date Reconcilation Date
RECYEAR String*4 Reconcilation Year Mask: %04D
RECPERIOD Integer Reconcilation Period
LINES Long Number of Lines
SERIAL ??? Bank Entry Serial Number
RUNID Long Run Id
TYPE Integer Payment Type
OFXTID String*50 OFX Transaction ID
ENTRYTYPE Integer Entry Type
DSETCODE String*6 Distribution Set Mask: %-6N
BANKD String*60 Bank Name
BKACCT String*22 Bank Account
BKSTMTCUR String*3 Bank Statement Currency
DSETCODED String*60 Distribution Set Desc
TOTSTMTAMT BCD*10.3 Total Statement Amount
TRANSCUR String*3 Bank Entry Currency
RECPENT BCD*10.3 Fiscal Entry Amount
RECPENTREC BCD*10.3 Reconciled Entry Amount
DEFENTNUM String*22 Default New Document Number
PROCESSCMD Integer Process Command
AGERECLD Integer Aging Recon. days
RETENTNO Integer Keep Input Entry No.