# View: Banks

RotoID: BK0001
Table: BKACCT
Protocol: Header
DLL: BKACCT

## Compositions: 11

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0002 | BKCUR | Bank Currencies | BKCUR
BK0004 | BKCHK | Bank Checks | BKCHK
BK0420 | BKDEPH | Bank Deposits | BKDEPH
BK0006 | BKNSF | Returned Customer Checks | BKNSF
BK0007 | BKENT | Bank Entries | BKENT
BK0008 | BKFORM | Check Stocks | BKFORM
BK0003 | BKTT | Bank Transaction Types | BKTT
GL0001 | GLAMF | Accounts | GLAMF
CS0003 | CSCCD | Currency Codes | CSCCD
BK0870 | BKUNMAT | OFX Transactions | BKUNMAT
BK0400 | BKDEPD | Bank Deposit Details | BKDEPD

## Keys: 1

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

## Fields: 141

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 Account | E A | Mask: %-45C
IDACCTERR | 24 | String*45 | Write-Off 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 | A | Mask: %04D
RECFP | 28 | Integer | Fiscal Period | 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 | A C |
RECBKENT | 39 | BCD*10.3 | Bank Entries | E A C |
RECBKERR | 40 | BCD*10.3 | Write-Offs | A C |
RECEXGAIN | 41 | BCD*10.3 | Exchange Gain | A C |
RECEXLOSS | 42 | BCD*10.3 | Exchange Loss | 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 | E A C |
RECFCCHK | 46 | BCD*10.3 | Checks To Fiscal Period | E A C |
RECFCDEPIT | 47 | BCD*10.3 | Deposits In Transit To Fisc.Per. | E A C |
RECFCCHKOS | 48 | BCD*10.3 | Checks Outstanding To Fisc.Per. | E A C |
RECRECALC | 49 | Boolean | Calculate Fiscal Period Data | E 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 | E 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 Period | A C |
RECFCERR | 55 | BCD*10.3 | Bank Error To Fiscal Period | A C |
RECFCENTRE | 56 | BCD*10.3 | Reconciled Entries To Fiscal Period | E A C |
IDACCTCCC | 57 | String*45 | Credit Card Charges Account | E A | Mask: %-45C
CCCSPREAD | 58 | BCD*10.3 | Credit Card Charge Spread | E A |
EXSPREAD | 59 | BCD*10.3 | Exchange Rate Difference Spread | E A |
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 Slip Number | E A C |
DEPSERIAL | 76 | Long | Next Deposit Uniquifier | E A C |
RECAVAIL | 77 | BCD*10.3 | Current Balance | A C |
RECBOOKBAL | 78 | BCD*10.3 | Book Balance | A C |
CURRTYPE | 79 | Integer | Bank Statement Type | A C | List: 4 entries
0 | = | Invalid
1 | = | Single
2 | = | Multiple
3 | = | Foreign
RECTWO | 80 | BCD*10.3 | Total Write Offs | A C |
RECTCCC | 81 | BCD*10.3 | Total Credit Card Charges | A C |
RECPWO | 82 | BCD*10.3 | Fiscal Period Write Off | A C |
RECPCCC | 83 | BCD*10.3 | Fiscal Period Credit Card Charges | A C |
RECWTWOSUM | 84 | BCD*10.3 | Sum of Withdrawal Total Write Offs | A C |
RECDTWOSUM | 85 | BCD*10.3 | Sum of Deposit Total Write Offs | A C |
RECWPWOSUM | 86 | BCD*10.3 | Sum of Withdrawal Fiscal Write Offs | A C |
RECDPWOSUM | 87 | BCD*10.3 | Sum of Deposit Fiscal Write Offs | A C |
CURFUNC | 88 | String*3 | Functional Currency | A |
RECWTREM | 89 | BCD*10.3 | Total Remaining OutStanding | A C |
RECWPREM | 90 | BCD*10.3 | Fiscal Remaining OutStanding | A C |
RECDTREM | 91 | BCD*10.3 | Total Remaining In Transit | A C |
RECDPREM | 92 | BCD*10.3 | Fiscal Remaining In Transit | A C |
RECWRCLR | 93 | BCD*10.3 | Fiscal Withdrawal Cleared To Current | A C |
RECDRCLR | 94 | BCD*10.3 | Fiscal Deposit Cleared To Current | A C |
TXGRPDESC | 95 | String*60 | Tax Group Description | E A |
TXAUTDESC1 | 96 | String*60 | Tax Authorization Description 1 | E A |
TXAUTDESC2 | 97 | String*60 | Tax Authorization Description 2 | E A |
TXAUTDESC3 | 98 | String*60 | Tax Authorization Description 3 | E A |
TXAUTDESC4 | 99 | String*60 | Tax Authorization Description 4 | E A |
TXAUTDESC5 | 100 | String*60 | Tax Authorization Description 5 | E A |
TXCLSDESC1 | 101 | String*60 | Vendor Tax Class Description 1 | E A |
TXCLSDESC2 | 102 | String*60 | Vendor Tax Class Description 2 | E A |
TXCLSDESC3 | 103 | String*60 | Vendor Tax Class Description 3 | E A |
TXCLSDESC4 | 104 | String*60 | Vendor Tax Class Description 4 | E A |
TXCLSDESC5 | 105 | String*60 | Vendor Tax Class Description 5 | E A |
RECWTERR | 150 | BCD*10.3 | Total Withdrawal Bank Errors | E A C |
RECWTWO | 151 | BCD*10.3 | Total Withdrawal Write Offs | E A C |
RECWTGAIN | 152 | BCD*10.3 | Total Withdrawal Exchange Gain | E A C |
RECWTLOSS | 153 | BCD*10.3 | Total Withdrawal Exchange Loss | E A C |
RECWTCCC | 154 | BCD*10.3 | Total Withdrawal Credit Card Charges | E A C |
RECWTCLR | 155 | BCD*10.3 | Total Withdrawal Cleared | E A C |
RECWTFUNAM | 156 | BCD*10.3 | Withdrawal Total | E A C |
RECWPERR | 157 | BCD*10.3 | Fiscal Withdrawal Bank Errors | E A C |
RECWPWO | 158 | BCD*10.3 | Fiscal Withdrawal Write Offs | E A C |
RECWPGAIN | 159 | BCD*10.3 | Fiscal Withdrawal Exchange Gain | E A C |
RECWPLOSS | 160 | BCD*10.3 | Fiscal Withdrawal Exchange Loss | E A C |
RECWPCCC | 161 | BCD*10.3 | Fiscal Withdrawal Credit Card Charges | E A C |
RECWPCLR | 162 | BCD*10.3 | Fiscal Withdrawal Cleared | E A C |
RECWPFUNAM | 163 | BCD*10.3 | Fiscal Withdrawal Total | E A C |
RECDTERR | 164 | BCD*10.3 | Total Deposit Bank Errors | E A C |
RECDTWO | 165 | BCD*10.3 | Total Deposit Write Offs | E A C |
RECDTGAIN | 166 | BCD*10.3 | Total Deposit Exchange Gain | E A C |
RECDTLOSS | 167 | BCD*10.3 | Total Deposit Exchange Loss | E A C |
RECDTCCC | 168 | BCD*10.3 | Total Deposit Credit Card Charges | E A C |
RECDTCLR | 169 | BCD*10.3 | Total Deposit Cleared | E A C |
RECDTFUNAM | 170 | BCD*10.3 | Deposit Total | E A C |
RECDPERR | 171 | BCD*10.3 | Fiscal Deposit Bank Errors | E A C |
RECDPWO | 172 | BCD*10.3 | Fiscal Deposit Write Offs | E A C |
RECDPGAIN | 173 | BCD*10.3 | Fiscal Deposit Exchange Gain | E A C |
RECDPLOSS | 174 | BCD*10.3 | Fiscal Deposit Exchange Loss | E A C |
RECDPCCC | 175 | BCD*10.3 | Fiscal Deposit Credit Card Charges | E A C |
RECDPCLR | 176 | BCD*10.3 | Fiscal Deposit Cleared | E A C |
RECDPFUNAM | 177 | BCD*10.3 | Fiscal Deposit Total | E A C |
RECWFCLR | 178 | BCD*10.3 | Fiscal Withdrawal Cleared To Future | E A C |
RECDFCLR | 179 | BCD*10.3 | Fiscal Deposit Cleared To Future | E A C |
FUNWTAMT | 180 | BCD*10.3 | Withdrawal Functional Total | E A C |
FUNWPAMT | 181 | BCD*10.3 | Fiscal Withdrawal Functional Total | E A C |
FUNDTAMT | 182 | BCD*10.3 | Deposit Functional Total | E A C |
FUNDPAMT | 183 | BCD*10.3 | Fiscal Deposit Functional Total | E A C |
CODETXGRP | 184 | String*12 | Tax Group Code | E A | Mask: %-12N
TAXAUTH1 | 185 | String*12 | Tax Authorization 1 | A |
TAXAUTH2 | 186 | String*12 | Tax Authorization 2 | A |
TAXAUTH3 | 187 | String*12 | Tax Authorization 3 | A |
TAXAUTH4 | 188 | String*12 | Tax Authorization 4 | A |
TAXAUTH5 | 189 | String*12 | Tax Authorization 5 | A |
TXVCLSS1 | 190 | Integer | Vendor Tax Class 1 | E A |
TXVCLSS2 | 191 | Integer | Vendor Tax Class 2 | E A |
TXVCLSS3 | 192 | Integer | Vendor Tax Class 3 | E A |
TXVCLSS4 | 193 | Integer | Vendor Tax Class 4 | E A |
TXVCLSS5 | 194 | Integer | Vendor Tax Class 5 | E A |
AGEPURGE | 195 | Integer | Days Before Eligible for Clearing | E A |
POSTDATE | 196 | Date | Reconciliation Posting Date | E A X |
LSTPOSTDAT | 197 | Date | Last Reconciliation Posting Date | E A X |
LSTSTMTBAL | 198 | BCD*10.3 | Last Available Statement Balance | E A |

This page was generated on 2008-May-01

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