Table: Banks

Table: BKACCT
View: BK0001
Record Length: 1504

Flags: A R 

Keys: 1

Title Flags Fields
Bank Code BANK

Fields: 107

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: (%-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
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 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
BCACCT Binary*32 Banking Cloud Account
BCCONNECT Boolean Banking Cloud Connected List:2 entries
0 = No
1 = Yes
BCLSTIDX Long Banking Cloud Last Index

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).