Share via

Bank Account Table

  • Article

Specifies up any number of bank accounts, both deposit accounts and loans. You can use these features to keep track of all your bank accounts at one bank or several banks.

You can register payments on a bank account. After you have posted a payment or other credit entry on a bank account, you can use the check printing facility to create a check based on the entry.

The bank accounts can be denominated in your local currency (LCY) or a foreign currency.

Each Bank Account has its own card containing different kinds of information. On the bank account card, you enter information specific to the individual bank account. This information can be changed. Entries posted in other parts of the program that affect the bank account, for example cash deposits to the bank account posted in the general journal, will be reflected on the bank account's card.

The card has three FastTabs. The General FastTab contains all the general information about the bank account: number, name, address, contact person etc. The Communication FastTab contains phone and fax numbers, e-mail and home page addresses. The Posting FastTab contains all the posting information.

You can change the contents of the fields on the General FastTab as needed. If you change the account number, you must confirm a message. The change can take time because the program checks for all the entries containing the old account number and replaces them with the new number. The fields on the Posting FastTab can be changed, except the Currency Code code field, which can only be changed if there are no open ledger entries.

Information on the bank account is also shown in the Bank Account List window, but the contents of the field cannot be changed here.

List of Fields in the Table

Field Location
Credit Limit Field, Bank Account Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
CAB Field, Bank Account Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
ABI Field, Bank Account Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Credit Limit for Discount Field, Bank Account Table Spain Local Functionality
CCC Bank Branch No. Field, Bank Account Table Spain Local Functionality
National Issuer No. Field, Bank Account Table France Local Functionality
Dealing Type Filter Field, Bank Account Table Spain Local Functionality
CCC Bank Account No. Field, Bank Account Table Spain Local Functionality
Category Filter Field, Bank Account Table Spain Local Functionality
VAT Registration No. Field, Bank Account Table Spain Local Functionality
E-Pay Export File Path Field, Bank Account Table Spain Local Functionality
Posted Pay. Bills Amt. (LCY) Field, Bank Account Table Spain Local Functionality
Posted Receiv Bills Amt. (LCY) Field, Bank Account Table Spain Local Functionality
Date of Last Post. Bill Gr. Field, Bank Account Table Spain Local Functionality
Posted Pay. Inv. Rmg. Amt. Field, Bank Account Table Spain Local Functionality
Agency Code Field, Bank Account Table France Local Functionality
RIB Key Field, Bank Account Table France Local Functionality
CCC Control Digits Field, Bank Account Table Spain Local Functionality
Last E-Pay Export File Name Field, Bank Account Table Spain Local Functionality
Closed Receiv Bills Amt. (LCY) Field, Bank Account Table Spain Local Functionality
RIB Checked Field, Bank Account Table France Local Functionality
Closed Pay. Bills Amt. Field, Bank Account Table Spain Local Functionality
Posted Pay. Bills Rmg. Amt. Field, Bank Account Table Spain Local Functionality
Status Filter Field, Bank Account Table Spain Local Functionality
Customer Ratings Code Field, Bank Account Table Spain Local Functionality
Posted Receiv. Bills Rmg. Amt. Field, Bank Account Table Spain Local Functionality
Closed Receiv. Bills Amt. Field, Bank Account Table Spain Local Functionality
Delay for Notices Field, Bank Account Table Spain Local Functionality
Closed Pay. Documents Amt. Field, Bank Account Table Spain Local Functionality
Posted R.Bills Rmg. Amt. (LCY) Field, Bank Account Table Spain Local Functionality
Posted P.Bills Rmg. Amt. (LCY) Field, Bank Account Table Spain Local Functionality
BBAN Field, Bank Account Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Closed Pay. Invoices Amt. Field, Bank Account Table Spain Local Functionality
Posted Pay. Documents Amt. Field, Bank Account Table Spain Local Functionality
Honored/Rejtd. at Date Filter Field, Bank Account Table Spain Local Functionality
Posted Pay. Bills Amt. Field, Bank Account Table Spain Local Functionality
Posted Receiv. Bills Amt. Field, Bank Account Table Spain Local Functionality
Operation Fees Code Field, Bank Account Table Spain Local Functionality
CCC Bank No. Field, Bank Account Table Spain Local Functionality
Last Remittance Advice No. Field, Bank Account Table Spain Local Functionality
Posted Pay. Invoices Amt. Field, Bank Account Table Spain Local Functionality
Clos. Receivable Inv. Amt. Field, Bank Account Table Spain Local Functionality
Las E-Pay File Creation No. Field, Bank Account Table Spain Local Functionality
Closed Pay. Bills Amt. (LCY) Field, Bank Account Table Spain Local Functionality
Last Bill Gr. No. Field, Bank Account Table Spain Local Functionality
Due Date Filter Field, Bank Account Table Spain Local Functionality
Post. Receivable Inv. Amt. Field, Bank Account Table Spain Local Functionality
CCC No. Field, Bank Account Table Spain Local Functionality
Stale Cheque Stipulated Period Field, Bank Account Table India Local Functionality
Interbank Clearing Code Field, Bank Account Table Belgium Local Functionality
IBAN Field, Bank Account Table Finland Local Functionality
Protocol No. Field, Bank Account Table Belgium Local Functionality
Bank Account No. Field, Bank Account Table Finland Local Functionality
SWIFT Code Field, Bank Account Table Finland Local Functionality
Version Code Field, Bank Account Table Belgium Local Functionality
Acc. Hold. Country/Region Code Field, Bank Account Table Netherlands Local Functionality
Account Holder City Field, Bank Account Table Netherlands Local Functionality
Account Holder Name Field, Bank Account Table Netherlands Local Functionality
Proposal Field, Bank Account Table Netherlands Local Functionality
Account Holder Post Code Field, Bank Account Table Netherlands Local Functionality
Account Holder Address Field, Bank Account Table Netherlands Local Functionality
Payment History Field, Bank Account Table Netherlands Local Functionality
County Field, Bank Account Table General Ledger
IBAN Field, Bank Account Table General Ledger
Comment Field, Bank Account Table General Ledger
Statistics Group Field, Bank Account Table General Ledger
CAB Field, Bank Account Table Italy Local Functionality
Amount Field, Bank Account Table General Ledger
Contact Field, Bank Account Table General Ledger
No. Series Field, Bank Account Table General Ledger
Balance (LCY) Field, Bank Account Table General Ledger
ABI Field, Bank Account Table Italy Local Functionality
Last Date Modified Field, Bank Account Table General Ledger
Last Statement No. Field, Bank Account Table General Ledger
National Issuer No. Field, Bank Account Table France Local Functionality
Chain Name Field, Bank Account Table General Ledger
Name 2 Field, Bank Account Table General Ledger
Min. Balance Field, Bank Account Table General Ledger
Acc. Hold. Country/Region Code Field, Bank Account Table Netherlands Local Functionality
Account Holder City Field, Bank Account Table Netherlands Local Functionality
Account Holder Name Field, Bank Account Table Netherlands Local Functionality
Proposal Field, Bank Account Table Netherlands Local Functionality
BBAN Field, Bank Account Table Italy Local Functionality
Account Holder Post Code Field, Bank Account Table Netherlands Local Functionality
Address 2 Field, Bank Account Table General Ledger
Check Report Name Field, Bank Account Table General Ledger
Telex Answer Back Field, Bank Account Table General Ledger
Global Dimension 2 Code Field, Bank Account Table General Ledger
Name Field, Bank Account Table General Ledger
Account Holder Address Field, Bank Account Table Netherlands Local Functionality
Payment History Field, Bank Account Table Netherlands Local Functionality
Credit Amount (LCY) Field, Bank Account Table General Ledger
Debit Amount Field, Bank Account Table General Ledger
Home Page Field, Bank Account Table General Ledger
Balance Last Statement Field, Bank Account Table General Ledger
City Field, Bank Account Table General Ledger
Address Field, Bank Account Table General Ledger
Telex No. Field, Bank Account Table General Ledger
Search Name Field, Bank Account Table General Ledger
Credit Amount Field, Bank Account Table General Ledger
Net Change (LCY) Field, Bank Account Table General Ledger
Date Filter Field, Bank Account Table General Ledger
Stale Cheque Stipulated Period Field, Bank Account Table India Local Functionality
Net Change Field, Bank Account Table General Ledger
Post Code Field, Bank Account Table General Ledger
No. Field, Bank Account Table General Ledger
Check Report ID Field, Bank Account Table General Ledger
Phone No. Field, Bank Account Table General Ledger
Picture Field, Bank Account Table General Ledger
Blocked Field, Bank Account Table General Ledger
Fax No. Field, Bank Account Table General Ledger
Bank Account No. Field, Bank Account Table General Ledger
E-Mail Field, Bank Account Table General Ledger
Transit No. Field, Bank Account Table General Ledger
Balance Field, Bank Account Table General Ledger
Debit Amount (LCY) Field, Bank Account Table General Ledger
Last Check No. Field, Bank Account Table General Ledger
Bank Branch No. Field, Bank Account Table General Ledger
Global Dimension 1 Code Field, Bank Account Table General Ledger
Bank Communication Field, Bank Account Table United States Local Functionality
Client Name Field, Bank Account Table United States Local Functionality
Check Date Separator Field, Bank Account Table United States Local Functionality
Last ACH File ID Modifier Field, Bank Account Table United States Local Functionality
Last E-Pay File Creation No. Field, Bank Account Table United States Local Functionality
EFT Security No. Field, Bank Account Table New Zealand Local Functionality
Check Date Format Field, Bank Account Table United States Local Functionality
E-Pay Trans. Program Command Field, Bank Account Table United States Local Functionality
Last Remittance Advice No. Field, Bank Account Table United States Local Functionality
Last E-Pay Export File Name Field, Bank Account Table United States Local Functionality
E-Pay Trans. Program Path Field, Bank Account Table United States Local Functionality
Input Qualifier Field, Bank Account Table United States Local Functionality
Client No. Field, Bank Account Table United States Local Functionality
E-Pay Export File Path Field, Bank Account Table United States Local Functionality
EFT Security Name Field, Bank Account Table New Zealand Local Functionality
Export Format Field, Bank Account Table United States Local Functionality
EFT BSB No. Field, Bank Account Table New Zealand Local Functionality
EFT Balancing Record Required Field, Bank Account Table New Zealand Local Functionality
EFT Bank Code Field, Bank Account Table New Zealand Local Functionality
Country/Region Code Field, Bank Account Table General Ledger
County Field, Bank Account Table General Ledger
IBAN Field, Bank Account Table General Ledger
Comment Field, Bank Account Table General Ledger
Currency Code Field, Bank Account Table General Ledger
Statistics Group Field, Bank Account Table General Ledger
Amount Field, Bank Account Table General Ledger
Balance at Date Field, Bank Account Table General Ledger
Contact Field, Bank Account Table General Ledger
No. Series Field, Bank Account Table General Ledger
Balance (LCY) Field, Bank Account Table General Ledger
Last Date Modified Field, Bank Account Table General Ledger
Last Statement No. Field, Bank Account Table General Ledger
Territory Code Field, Bank Account Table General Ledger
SWIFT Code Field, Bank Account Table General Ledger
Chain Name Field, Bank Account Table General Ledger
Name 2 Field, Bank Account Table General Ledger
Min. Balance Field, Bank Account Table General Ledger
Address 2 Field, Bank Account Table General Ledger
Check Report Name Field, Bank Account Table General Ledger
Telex Answer Back Field, Bank Account Table General Ledger
Global Dimension 2 Code Field, Bank Account Table General Ledger
Name Field, Bank Account Table General Ledger
Credit Amount (LCY) Field, Bank Account Table General Ledger
Debit Amount Field, Bank Account Table General Ledger
Home Page Field, Bank Account Table General Ledger
Balance Last Statement Field, Bank Account Table General Ledger
City Field, Bank Account Table General Ledger
Address Field, Bank Account Table General Ledger
Telex No. Field, Bank Account Table General Ledger
Search Name Field, Bank Account Table General Ledger
Credit Amount Field, Bank Account Table General Ledger
Net Change (LCY) Field, Bank Account Table General Ledger
Global Dimension 1 Filter Field, Bank Account Table General Ledger
Date Filter Field, Bank Account Table General Ledger
Net Change Field, Bank Account Table General Ledger
Our Contact Code Field, Bank Account Table General Ledger
Post Code Field, Bank Account Table General Ledger
No. Field, Bank Account Table General Ledger
Bank Acc. Posting Group Field, Bank Account Table General Ledger
Check Report ID Field, Bank Account Table General Ledger
Phone No. Field, Bank Account Table General Ledger
Balance at Date (LCY) Field, Bank Account Table General Ledger
Picture Field, Bank Account Table General Ledger
Blocked Field, Bank Account Table General Ledger
Language Code Field, Bank Account Table General Ledger
Fax No. Field, Bank Account Table General Ledger
Bank Account No. Field, Bank Account Table General Ledger
E-Mail Field, Bank Account Table General Ledger
Transit No. Field, Bank Account Table General Ledger
Balance Field, Bank Account Table General Ledger
Global Dimension 2 Filter Field, Bank Account Table General Ledger
Debit Amount (LCY) Field, Bank Account Table General Ledger
Last Check No. Field, Bank Account Table General Ledger
Bank Branch No. Field, Bank Account Table General Ledger
Global Dimension 1 Code Field, Bank Account Table General Ledger
Stale Cheque Stipulated Period Field, Bank Account Table India Local Functionality
Country/Region Code Field, Bank Account Table General Ledger
County Field, Bank Account Table General Ledger
IBAN Field, Bank Account Table General Ledger
Comment Field, Bank Account Table General Ledger
Currency Code Field, Bank Account Table General Ledger
Statistics Group Field, Bank Account Table General Ledger
Amount Field, Bank Account Table General Ledger
Balance at Date Field, Bank Account Table General Ledger
Contact Field, Bank Account Table General Ledger
No. Series Field, Bank Account Table General Ledger
Balance (LCY) Field, Bank Account Table General Ledger
Last Date Modified Field, Bank Account Table General Ledger
Last Statement No. Field, Bank Account Table General Ledger
Territory Code Field, Bank Account Table General Ledger
SWIFT Code Field, Bank Account Table General Ledger
Chain Name Field, Bank Account Table General Ledger
Name 2 Field, Bank Account Table General Ledger
Min. Balance Field, Bank Account Table General Ledger
Address 2 Field, Bank Account Table General Ledger
Check Report Name Field, Bank Account Table General Ledger
Telex Answer Back Field, Bank Account Table General Ledger
Global Dimension 2 Code Field, Bank Account Table General Ledger
Name Field, Bank Account Table General Ledger
Credit Amount (LCY) Field, Bank Account Table General Ledger
Debit Amount Field, Bank Account Table General Ledger
Home Page Field, Bank Account Table General Ledger
Balance Last Statement Field, Bank Account Table General Ledger
City Field, Bank Account Table General Ledger
Address Field, Bank Account Table General Ledger
Telex No. Field, Bank Account Table General Ledger
Search Name Field, Bank Account Table General Ledger
Credit Amount Field, Bank Account Table General Ledger
Net Change (LCY) Field, Bank Account Table General Ledger
Global Dimension 1 Filter Field, Bank Account Table General Ledger
Date Filter Field, Bank Account Table General Ledger
Net Change Field, Bank Account Table General Ledger
Our Contact Code Field, Bank Account Table General Ledger
Post Code Field, Bank Account Table General Ledger
No. Field, Bank Account Table General Ledger
Bank Acc. Posting Group Field, Bank Account Table General Ledger
Check Report ID Field, Bank Account Table General Ledger
Phone No. Field, Bank Account Table General Ledger
Balance at Date (LCY) Field, Bank Account Table General Ledger
Picture Field, Bank Account Table General Ledger
Blocked Field, Bank Account Table General Ledger
Language Code Field, Bank Account Table General Ledger
Fax No. Field, Bank Account Table General Ledger
Bank Account No. Field, Bank Account Table General Ledger
E-Mail Field, Bank Account Table General Ledger
Transit No. Field, Bank Account Table General Ledger
Balance Field, Bank Account Table General Ledger
Global Dimension 2 Filter Field, Bank Account Table General Ledger
Debit Amount (LCY) Field, Bank Account Table General Ledger
Last Check No. Field, Bank Account Table General Ledger
Bank Branch No. Field, Bank Account Table General Ledger
Global Dimension 1 Code Field, Bank Account Table General Ledger
National Issuer No. Field, Bank Account Table France Local Functionality
Acc. Hold. Country/Region Code Field, Bank Account Table Netherlands Local Functionality
Account Holder City Field, Bank Account Table Netherlands Local Functionality
Account Holder Name Field, Bank Account Table Netherlands Local Functionality
Proposal Field, Bank Account Table Netherlands Local Functionality
Account Holder Post Code Field, Bank Account Table Netherlands Local Functionality
Account Holder Address Field, Bank Account Table Netherlands Local Functionality
CAB Field, Bank Account Table Italy Local Functionality
ABI Field, Bank Account Table Italy Local Functionality
Payment History Field, Bank Account Table Netherlands Local Functionality
BBAN Field, Bank Account Table Italy Local Functionality
Country/Region Code Field, Bank Account Table General Ledger
Currency Code Field, Bank Account Table General Ledger
Balance at Date Field, Bank Account Table General Ledger
Territory Code Field, Bank Account Table General Ledger
SWIFT Code Field, Bank Account Table General Ledger
Global Dimension 1 Filter Field, Bank Account Table General Ledger
Our Contact Code Field, Bank Account Table General Ledger
Bank Acc. Posting Group Field, Bank Account Table General Ledger
Balance at Date (LCY) Field, Bank Account Table General Ledger
Language Code Field, Bank Account Table General Ledger
Global Dimension 2 Filter Field, Bank Account Table General Ledger
Country/Region Code Field, Bank Account Table General Ledger
County Field, Bank Account Table General Ledger
IBAN Field, Bank Account Table General Ledger
Comment Field, Bank Account Table General Ledger
Currency Code Field, Bank Account Table General Ledger
Statistics Group Field, Bank Account Table General Ledger
Amount Field, Bank Account Table General Ledger
Balance at Date Field, Bank Account Table General Ledger
Contact Field, Bank Account Table General Ledger
No. Series Field, Bank Account Table General Ledger
Balance (LCY) Field, Bank Account Table General Ledger
Last Date Modified Field, Bank Account Table General Ledger
Last Statement No. Field, Bank Account Table General Ledger
Territory Code Field, Bank Account Table General Ledger
SWIFT Code Field, Bank Account Table General Ledger
Chain Name Field, Bank Account Table General Ledger
Name 2 Field, Bank Account Table General Ledger
Min. Balance Field, Bank Account Table General Ledger
Address 2 Field, Bank Account Table General Ledger
Check Report Name Field, Bank Account Table General Ledger
Telex Answer Back Field, Bank Account Table General Ledger
Global Dimension 2 Code Field, Bank Account Table General Ledger
Name Field, Bank Account Table General Ledger
Credit Amount (LCY) Field, Bank Account Table General Ledger
Debit Amount Field, Bank Account Table General Ledger
Home Page Field, Bank Account Table General Ledger
Balance Last Statement Field, Bank Account Table General Ledger
City Field, Bank Account Table General Ledger
Address Field, Bank Account Table General Ledger
Telex No. Field, Bank Account Table General Ledger
Search Name Field, Bank Account Table General Ledger
Credit Amount Field, Bank Account Table General Ledger
Net Change (LCY) Field, Bank Account Table General Ledger
Global Dimension 1 Filter Field, Bank Account Table General Ledger
Date Filter Field, Bank Account Table General Ledger
Net Change Field, Bank Account Table General Ledger
Our Contact Code Field, Bank Account Table General Ledger
Post Code Field, Bank Account Table General Ledger
No. Field, Bank Account Table General Ledger
Bank Acc. Posting Group Field, Bank Account Table General Ledger
Check Report ID Field, Bank Account Table General Ledger
Phone No. Field, Bank Account Table General Ledger
Balance at Date (LCY) Field, Bank Account Table General Ledger
Picture Field, Bank Account Table General Ledger
Blocked Field, Bank Account Table General Ledger
Language Code Field, Bank Account Table General Ledger
Fax No. Field, Bank Account Table General Ledger
Bank Account No. Field, Bank Account Table General Ledger
E-Mail Field, Bank Account Table General Ledger
Transit No. Field, Bank Account Table General Ledger
Balance Field, Bank Account Table General Ledger
Global Dimension 2 Filter Field, Bank Account Table General Ledger
Debit Amount (LCY) Field, Bank Account Table General Ledger
Last Check No. Field, Bank Account Table General Ledger
Bank Branch No. Field, Bank Account Table General Ledger
Global Dimension 1 Code Field, Bank Account Table General Ledger
National Issuer No. Field, Bank Account Table France Local Functionality
Acc. Hold. Country/Region Code Field, Bank Account Table Netherlands Local Functionality
Account Holder City Field, Bank Account Table Netherlands Local Functionality
Account Holder Name Field, Bank Account Table Netherlands Local Functionality
Proposal Field, Bank Account Table Netherlands Local Functionality
Account Holder Post Code Field, Bank Account Table Netherlands Local Functionality
CAB Field, Bank Account Table Italy Local Functionality
Account Holder Address Field, Bank Account Table Netherlands Local Functionality
ABI Field, Bank Account Table Italy Local Functionality
Payment History Field, Bank Account Table Netherlands Local Functionality
BBAN Field, Bank Account Table Italy Local Functionality

See Also

Reference

Currency Code
Bank Account List
Bank Account Card
Bank Account Balance
Bank Account Statistics