# Table: Banks

Table: BKACCT
View: BK0001
Record length: 999
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Bank Code |  | BANK

## Fields: 60

Field | Type | Title | Presentation
--- | --- | --- | ---
BANK | String*8 | Bank Code | Mask: %-8N
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
NAME | String*60 | Description |
ADDR1 | String*60 | Address Line 1 |
ADDR2 | String*60 | Address Line 2 |
ADDR3 | String*60 | Address Line 3 |
ADDR4 | String*60 | Address Line 4 |
CITY | String*30 | City |
STATE | String*30 | State/Province |
COUNTRY | String*30 | Country |
POSTAL | String*20 | Zip/Postal Code |
CONTACT | String*60 | Contact |
LOCTYPE | String*6 |  |
LOCATION | String*30 |  |
PHONE | String*30 | Phone Number | Mask: (%-3C) %-3C-%-24C
FAX | String*30 | Fax Number | Mask: (%-3C) %-3C-%-24C
TRANSIT | String*12 | Transit Number | Mask: %-12D
MULTICUR | Boolean | Multicurrency | List: 2 entries
0 | = | No
1 | = | Yes
CURNSTMT | String*3 | Statement Currency | Mask: %-3N
INACTIVE | Boolean | Status | List: 2 entries
0 | = | Active
1 | = | Inactive
INACTDATE | Date | Inactive Date |
BKACCT | String*22 | Bank Account Number |
RECNSFTYPE | String*6 |  |
IDACCT | String*45 | Bank G/L Account | Mask: %-45C
IDACCTERR | String*45 | Clearing Errors G/L Account | Mask: %-45C
ERRSPREAD | BCD*10.3 | Error Spread |
LSTMNTND | Date | Last Maintained |
RECFY | String*4 | Fiscal Year | Mask: %4D
RECFP | Integer | Fiscal Period | List: 12 entries
1 | = | 1
2 | = | 2
3 | = | 3
4 | = | 4
5 | = | 5
6 | = | 6
7 | = | 7
8 | = | 8
9 | = | 9
10 | = | 10
11 | = | 11
12 | = | 12
RECLSTFY | String*4 | Last Reconciliation Year |
RECLSTFP | Integer | Last Reconciliation Period |
RECLSTDATE | Date | Last Reconciliation Date |
RECLSTBAL | BCD*10.3 | Last Closing Statement Balance |
RECDATE | Date | Reconciliation Date |
RECSTMTDAT | Date | Statement Date |
RECSTMTBAL | BCD*10.3 | Statement Balance |
RECINTRANS | BCD*10.3 | Deposits in Transit |
RECOUTSTND | BCD*10.3 | Checks Outstanding |
RECBKERRPN | BCD*10.3 | Bank Errors |
RECBKENT | BCD*10.3 | Bank Entries |
RECBKERR | BCD*10.3 | Write-Offs |
RECEXGAIN | BCD*10.3 | Exchange Gain |
RECEXLOSS | BCD*10.3 | Exchange Loss |
RECDEPOSIT | BCD*10.3 | Total Deposits |
RECCHECK | BCD*10.3 | Total Checks |
RECFCDEP | BCD*10.3 | Deposits To Fiscal Period |
RECFCCHK | BCD*10.3 | Checks To Fiscal Period |
RECFCDEPIT | BCD*10.3 | Deposits In Transit To Fisc.Per. |
RECFCCHKOS | BCD*10.3 | Checks Outstanding To Fisc.Per. |
RECRECALC | Boolean | Calculate Fiscal Period Data | List: 2 entries
0 | = | Fiscal balances are up to date.
1 | = | Fiscal balances need to be recalculated.
RECLSMDATE | Date | Last Statement Date |
RECFCBKENT | BCD*10.3 | Bank Entries To Fiscal Period |
RECFCGAIN | BCD*10.3 | Exchange Gain To Fiscal Period |
RECFCLOSS | BCD*10.3 | Exchange Loss To Fiscal Period |
RECFCERRPN | BCD*10.3 | Bank Error Pending To Fiscal Per |
RECFCERR | BCD*10.3 | Bank Error To Fiscal Period |
RECFCENTRE | BCD*10.3 | Reconciled Entries To Fiscal Per |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.