# Table: Bank Entry Posting Journal

Table: BKJENT
View: BK0017
Record length: 577
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Posting Sequence/Bank Code |  | PSTSEQ, BANK, UNIQUE

## Fields: 31

Field | Type | Title | Presentation
--- | --- | --- | ---
PSTSEQ | BCD*5.0 | Posting Sequence |
BANK | String*8 | Bank Code | Mask: %-8N
UNIQUE | Long | Entry Uniquifier |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
DATE | Date | Entry Date |
TYPE | String*6 | Transaction Type | Mask: %-6N
REFERENCE | String*60 | Reference |
COMMENT | String*60 | Comment |
AMOUNT | BCD*10.3 | Amount |
SRCEAMT | BCD*10.3 | Source Amount |
RATETYPE | String*2 | Exchange Rate Type | Mask: %-2N
SRCECURN | String*3 | Payment Currency | Mask: %-3N
RATEDATE | Date | Exchange Rate Date |
RATE | BCD*8.7 | Exchange Rate |
RATESPREAD | BCD*8.7 | Rate Spread |
RATEOP | Integer | Rate Operation | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
SRCEAMTCR | BCD*10.3 | Source Credit Amount |
SRCEAMTDR | BCD*10.3 | Source Debit Amount |
AMTCR | BCD*10.3 | Credit Amount |
AMTDR | BCD*10.3 | Debit Amount |
ENTRYAMT | BCD*10.3 | Statement Amount |
IDACCT | String*45 | G/L Account | Mask: %-45C
IDACCTOVR | Boolean | Account Number Override |
ENTRYTYPE | Integer | Entry Type | List: 4 entries
0 | = | User-entered
10 | = | Unmatched OFX
19 | = | Unmatched OFX correction
20 | = | Unmatched OFX error
RECYEAR | String*4 | Reconciliation Fiscal Year | Mask: %04D
RECPERIOD | Integer | Reconciliation Fiscal Period | List: 14 entries
0 | = |
1 | = | 1
2 | = | 2
3 | = | 3
4 | = | 4
5 | = | 5
6 | = | 6
7 | = | 7
8 | = | 8
9 | = | 9
10 | = | 10
11 | = | 11
12 | = | 12
13 | = | 13
RECONCILED | Boolean | Reconciled |
BIGCOMMENT | String*250 | Comments |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.