# Table: Banks

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

## Keys: 1

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

## Fields: 104

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 |
PHONE | String*30 | Phone Number | Mask: %-30c
FAX | String*30 | Fax Number | Mask: %-30c
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 |
IDACCT | String*45 | Bank Account | Mask: %-45C
IDACCTERR | String*45 | Write-Off Account | Mask: %-45C
ERRSPREAD | BCD*10.3 | Error Spread |
LSTMNTND | Date | Last Maintained |
RECFY | String*4 | Fiscal Year | Mask: %04D
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 |
RECBKENT | BCD*10.3 | Total Not Posted Bank Entries |
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 | Difference of Bank Entries To Fiscal Period |
RECFCENTRE | BCD*10.3 | Total Not Posted Bank Entries To Fiscal Period |
IDACCTCCC | String*45 | Credit Card Charges Account | Mask: %-45C
CCCSPREAD | BCD*10.3 | Credit Card Charge Spread |
EXSPREAD | BCD*10.3 | Exchange Rate Difference Spread |
RECWTERR | BCD*10.3 | Total Withdrawal Bank Errors |
RECWTWO | BCD*10.3 | Total Withdrawal Write Offs |
RECWTGAIN | BCD*10.3 | Total Withdrawal Exchange Gain |
RECWTLOSS | BCD*10.3 | Total Withdrawal Exchange Loss |
RECWTCCC | BCD*10.3 | Total Withdrawal Credit Card Charges |
RECWTCLR | BCD*10.3 | Total Withdrawal Cleared |
RECWTFUNAM | BCD*10.3 | Withdrawal Total |
RECWPERR | BCD*10.3 | Fiscal Withdrawal Bank Errors |
RECWPWO | BCD*10.3 | Fiscal Withdrawal Write Offs |
RECWPGAIN | BCD*10.3 | Fiscal Withdrawal Exchange Gain |
RECWPLOSS | BCD*10.3 | Fiscal Withdrawal Exchange Loss |
RECWPCCC | BCD*10.3 | Fiscal Withdrawal Credit Card Charges |
RECWPCLR | BCD*10.3 | Fiscal Withdrawal Cleared |
RECWPFUNAM | BCD*10.3 | Fiscal Withdrawal Total |
RECDTERR | BCD*10.3 | Total Deposit Bank Errors |
RECDTWO | BCD*10.3 | Total Deposit Write Offs |
RECDTGAIN | BCD*10.3 | Total Deposit Exchange Gain |
RECDTLOSS | BCD*10.3 | Total Deposit Exchange Loss |
RECDTCCC | BCD*10.3 | Total Deposit Credit Card Charges |
RECDTCLR | BCD*10.3 | Total Deposit Cleared |
RECDTFUNAM | BCD*10.3 | Deposit Total |
RECDPERR | BCD*10.3 | Fiscal Deposit Bank Errors |
RECDPWO | BCD*10.3 | Fiscal Deposit Write Offs |
RECDPGAIN | BCD*10.3 | Fiscal Deposit Exchange Gain |
RECDPLOSS | BCD*10.3 | Fiscal Deposit Exchange Loss |
RECDPCCC | BCD*10.3 | Fiscal Deposit Credit Card Charges |
RECDPCLR | BCD*10.3 | Fiscal Deposit Cleared |
RECDPFUNAM | BCD*10.3 | Fiscal Deposit Total |
RECWFCLR | BCD*10.3 | Fiscal Withdrawal Cleared To Future |
RECDFCLR | BCD*10.3 | Fiscal Deposit Cleared To Future |
FUNWTAMT | BCD*10.3 | Withdrawal Functional Total |
FUNWPAMT | BCD*10.3 | Fiscal Withdrawal Functional Total |
FUNDTAMT | BCD*10.3 | Deposit Functional Total |
FUNDPAMT | BCD*10.3 | Fiscal Deposit Functional Total |
CODETXGRP | String*12 | Tax Group Code | Mask: %-12N
TAXAUTH1 | String*12 | Tax Authorization 1 |
TAXAUTH2 | String*12 | Tax Authorization 2 |
TAXAUTH3 | String*12 | Tax Authorization 3 |
TAXAUTH4 | String*12 | Tax Authorization 4 |
TAXAUTH5 | String*12 | Tax Authorization 5 |
TXVCLSS1 | Integer | Vendor Tax Class 1 |
TXVCLSS2 | Integer | Vendor Tax Class 2 |
TXVCLSS3 | Integer | Vendor Tax Class 3 |
TXVCLSS4 | Integer | Vendor Tax Class 4 |
TXVCLSS5 | Integer | Vendor Tax Class 5 |
AGEPURGE | Integer | Days Before Eligible for Clearing |
POSTDATE | Date | Reconciliation Date |
LSTPOSTDAT | Date | Last Reconciliation Date |
LSTSTMTBAL | BCD*10.3 | Last Available Statement Balance |
RECCOMMENT | String*60 | Default Reconciliation Description |
RECWEXDIFF | BCD*10.3 | Withdrawals Cleared with Exch. Rate Diff. |
RECDEXDIFF | BCD*10.3 | Deposit Cleared with Exchange Rate Diff |

This page was generated on 2009-Nov-19

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