# View: Bank Entries Header

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

## Compositions: 7

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
BK0240 | BKCCTYP | Credit Card Types | BKCCTYP

## 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: 55

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 | Long | 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
CCTYPE | 31 | String*12 | Credit Card Type | A X | Mask: %-12N
CCNUMBER | 32 | Binary*32 | Credit Card Number | A X |
CCNAME | 33 | String*60 | Cardholder Name | A X |
CCAUTHCODE | 34 | String*20 | Authorization Code | E A X |
CCEXP | 35 | Date | Expiry Date | A X |
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 |
CCTYPED | 60 | String*60 | Credit Card Type Description | E A C |
XCCNUMBER | 61 | String*32 | Decrypted Credit Card Number | E A | Mask: %-32D
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 2009-Nov-19

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