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.