# View: Banks

RotoID: BK0001
Tables: BKACCT
DLL: BKACCT

## Compositions: 9

RotoID | Title | Tables | DLL
--- | --- | --- | ---
BK0002 | Bank Currencies | BKCUR | BKCUR
BK0004 | Bank Checks | BKCHK | BKCHK
BK0005 | Bank Deposits | BKDEP | BKDEP
BK0006 | Bank Checks Returned | BKNSF | BKNSF
BK0007 | Bank Entries | BKENT | BKENT
BK0008 | Check Stocks | BKFORM | BKFORM
BK0003 | Bank Transaction Types | BKTT | BKTT
GL0001 | Accounts | GLAMF | GLAMF
CS0003 | Currency Codes | CSCCD | CSCCD

## Keys: 1

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

## Fields: 62

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
BANK | 1 | String*8 | Bank Code | E A K R | Mask: %-8N
NAME | 2 | String*60 | Description | E A |
ADDR1 | 3 | String*60 | Address Line 1 | E A |
ADDR2 | 4 | String*60 | Address Line 2 | E A |
ADDR3 | 5 | String*60 | Address Line 3 | E A |
ADDR4 | 6 | String*60 | Address Line 4 | E A |
CITY | 7 | String*30 | City | E A |
STATE | 8 | String*30 | State/Province | E A |
COUNTRY | 9 | String*30 | Country | E A |
POSTAL | 10 | String*20 | Zip/Postal Code | E A |
CONTACT | 11 | String*60 | Contact | E A |
PHONE | 14 | String*30 | Phone Number | E A P | Mask: (%-3C) %-3C-%-24C
FAX | 15 | String*30 | Fax Number | E A P | Mask: (%-3C) %-3C-%-24C
TRANSIT | 16 | String*12 | Transit Number | E A | Mask: %-12D
MULTICUR | 17 | Boolean | Multicurrency | E A X | List: 2 entries
0 | = | No
1 | = | Yes
CURNSTMT | 18 | String*3 | Statement Currency | A X | Mask: %-3N
INACTIVE | 19 | Boolean | Status | E A | List: 2 entries
0 | = | Active
1 | = | Inactive
INACTDATE | 20 | Date | Inactive Date | A C |
BKACCT | 21 | String*22 | Bank Account Number | E A |
IDACCT | 23 | String*45 | Bank G/L Account | E A | Mask: %-45C
IDACCTERR | 24 | String*45 | Clearing Errors G/L Account | E A | Mask: %-45C
ERRSPREAD | 25 | BCD*10.3 | Error Spread | E A |
LSTMNTND | 26 | Date | Last Maintained | A C |
RECFY | 27 | String*4 | Fiscal Year | E A | Mask: %4D
RECFP | 28 | Integer | Fiscal Period | E A P | 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 | 29 | String*4 | Last Reconciliation Year | E A C |
RECLSTFP | 30 | Integer | Last Reconciliation Period | E A C |
RECLSTDATE | 31 | Date | Last Reconciliation Date | E A |
RECLSTBAL | 32 | BCD*10.3 | Last Closing Statement Balance | E A |
RECDATE | 33 | Date | Reconciliation Date | E A |
RECSTMTDAT | 34 | Date | Statement Date | E A |
RECSTMTBAL | 35 | BCD*10.3 | Statement Balance | E A |
RECINTRANS | 36 | BCD*10.3 | Deposits in Transit | E A C |
RECOUTSTND | 37 | BCD*10.3 | Checks Outstanding | E A C |
RECBKERRPN | 38 | BCD*10.3 | Bank Errors | E A C |
RECBKENT | 39 | BCD*10.3 | Bank Entries | E A C |
RECBKERR | 40 | BCD*10.3 | Write-Offs | E A C |
RECEXGAIN | 41 | BCD*10.3 | Exchange Gain | E A C |
RECEXLOSS | 42 | BCD*10.3 | Exchange Loss | E A C |
RECDEPOSIT | 43 | BCD*10.3 | Total Deposits | E A C |
RECCHECK | 44 | BCD*10.3 | Total Checks | E A C |
RECFCDEP | 45 | BCD*10.3 | Deposits To Fiscal Period | A C |
RECFCCHK | 46 | BCD*10.3 | Checks To Fiscal Period | A C |
RECFCDEPIT | 47 | BCD*10.3 | Deposits In Transit To Fisc.Per. | A C |
RECFCCHKOS | 48 | BCD*10.3 | Checks Outstanding To Fisc.Per. | A C |
RECRECALC | 49 | Boolean | Calculate Fiscal Period Data | A C | List: 2 entries
0 | = | Fiscal balances are up to date.
1 | = | Fiscal balances need to be recalculated.
RECLSMDATE | 50 | Date | Last Statement Date | E A |
RECFCBKENT | 51 | BCD*10.3 | Bank Entries To Fiscal Period | A C |
RECFCGAIN | 52 | BCD*10.3 | Exchange Gain To Fiscal Period | A C |
RECFCLOSS | 53 | BCD*10.3 | Exchange Loss To Fiscal Period | A C |
RECFCERRPN | 54 | BCD*10.3 | Bank Error Pending To Fiscal Per | A C |
RECFCERR | 55 | BCD*10.3 | Bank Error To Fiscal Period | A C |
RECFCENTRE | 56 | BCD*10.3 | Reconciled Entries To Fiscal Per | A C |
ADJBOOKBAL | 70 | BCD*10.3 | Adjusted Book Balance | A C |
ADJSTMTBAL | 71 | BCD*10.3 | Adjusted Statement Balance | A C |
BALANCES | 72 | Boolean | Bank Reconciliation Balanced | A C |
ADJBALDIFF | 73 | BCD*10.3 | Out Of Balance By | A C |
CHKSERIAL | 74 | Long | Next Check Serial Number | E A C |
NXTDEPOSIT | 75 | BCD*5.0 | Next Deposit Number | E A C |
DEPSERIAL | 76 | Long | Next Deposit Serial Number | E A C |
RECAVAIL | 77 | BCD*10.3 | Current Balance | A C |
RECBOOKBAL | 78 | BCD*10.3 | Book Balance | A C |

This page was generated on 2004-Oct-28

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