# Table: Bank Entries Journal Header

Table: BKJENTH
View: BK0665
Record length: 1033
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Bank Entry by Posting Sequence |  | PSTSEQ, SEQUENCENO

## Fields: 57

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 | Long | Bank Entry Serial Number |
RUNID | Long | Run Id |
TYPE | Integer | Payment Type |
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 |
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 |
CCTYPED | String*60 | Credit Card Type Description |
XCCNUMBER | String*32 | Decrypted Credit Card Number | Mask: %-32D
RETENTNO | Integer | Keep Input Entry No. |

This page was generated on 2009-Nov-19

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