Bank Account Ledger Entry Table

  • Article

Specifies a bank account ledger entry, which you can see from the Bank Account card by choosing Bank Acc. Ledger Entries, when you post a transaction that involves a bank account.

Bank account entries can be created by posting from general journals; sales credit memos; purchase orders, invoices or credit memos; or posting of cash receipts, payments to vendors and refunds to customers and from vendors; or by running batch jobs.

You cannot change the contents of the fields in the Bank Account Ledger Entry table because the entry has been posted.

List of Fields in the Table

Field Location
Stale Cheque Field, Bank Account Ledger Entry Table India Local Functionality
Transaction No. Field, Bank Account Ledger Entry Table Spain Local Functionality
Cheque Date Field, Bank Account Ledger Entry Table India Local Functionality
Bill No. Field, Bank Account Ledger Entry Table Spain Local Functionality
Stale Cheque Expiry Date Field, Bank Account Ledger Entry Table India Local Functionality
Cheque Stale Date Field, Bank Account Ledger Entry Table India Local Functionality
Cheque No. Field, Bank Account Ledger Entry Table India Local Functionality
Location Code Field, Bank Account Ledger Entry Table India Local Functionality
Journal Template Name Field, Bank Account Ledger Entry Table Belgium Local Functionality
Closed by Entry No. Field, Bank Account Ledger Entry Table General Ledger
Remaining Amount Field, Bank Account Ledger Entry Table General Ledger
Document Date Field, Bank Account Ledger Entry Table General Ledger
Entry No. Field, Bank Account Ledger Entry Table General Ledger
Posting Date Field, Bank Account Ledger Entry Table General Ledger
Global Dimension 1 Code Field, Bank Account Ledger Entry Table General Ledger
Credit Amount Field, Bank Account Ledger Entry Table General Ledger
Reversed Field, Bank Account Ledger Entry Table General Ledger
Debit Amount Field, Bank Account Ledger Entry Table General Ledger
Bank Acc. Posting Group Field, Bank Account Ledger Entry Table General Ledger
Reversed Entry No. Field, Bank Account Ledger Entry Table General Ledger
Bal. Account Type Field, Bank Account Ledger Entry Table General Ledger
Transaction No. Field, Bank Account Ledger Entry Table Spain Local Functionality
Amount (LCY) Field, Bank Account Ledger Entry Table General Ledger
Stale Cheque Field, Bank Account Ledger Entry Table India Local Functionality
Positive Field, Bank Account Ledger Entry Table General Ledger
Cheque Date Field, Bank Account Ledger Entry Table India Local Functionality
Stale Cheque Expiry Date Field, Bank Account Ledger Entry Table India Local Functionality
Cheque Stale Date Field, Bank Account Ledger Entry Table India Local Functionality
Transaction No. Field, Bank Account Ledger Entry Table General Ledger
Statement No. Field, Bank Account Ledger Entry Table General Ledger
External Document No. Field, Bank Account Ledger Entry Table General Ledger
Global Dimension 2 Code Field, Bank Account Ledger Entry Table General Ledger
Source Code Field, Bank Account Ledger Entry Table General Ledger
Statement Status Field, Bank Account Ledger Entry Table General Ledger
Journal Batch Name Field, Bank Account Ledger Entry Table General Ledger
Reason Code Field, Bank Account Ledger Entry Table General Ledger
Description Field, Bank Account Ledger Entry Table General Ledger
Our Contact Code Field, Bank Account Ledger Entry Table General Ledger
Closed at Date Field, Bank Account Ledger Entry Table General Ledger
Bank Account No. Field, Bank Account Ledger Entry Table General Ledger
Cheque No. Field, Bank Account Ledger Entry Table India Local Functionality
Open Field, Bank Account Ledger Entry Table General Ledger
Debit Amount (LCY) Field, Bank Account Ledger Entry Table General Ledger
User ID Field, Bank Account Ledger Entry Table General Ledger
Bal. Account No. Field, Bank Account Ledger Entry Table General Ledger
Currency Code Field, Bank Account Ledger Entry Table General Ledger
Amount Field, Bank Account Ledger Entry Table General Ledger
Credit Amount (LCY) Field, Bank Account Ledger Entry Table General Ledger
Statement Line No. Field, Bank Account Ledger Entry Table General Ledger
Document Type Field, Bank Account Ledger Entry Table General Ledger
Reversed by Entry No. Field, Bank Account Ledger Entry Table General Ledger
Document No. Field, Bank Account Ledger Entry Table General Ledger
Post Dated Check No. Field, Bank Account Ledger Entry Table New Zealand Local Functionality
Closed by Entry No. Field, Bank Account Ledger Entry Table General Ledger
Remaining Amount Field, Bank Account Ledger Entry Table General Ledger
Document Date Field, Bank Account Ledger Entry Table General Ledger
Entry No. Field, Bank Account Ledger Entry Table General Ledger
Posting Date Field, Bank Account Ledger Entry Table General Ledger
Global Dimension 1 Code Field, Bank Account Ledger Entry Table General Ledger
Credit Amount Field, Bank Account Ledger Entry Table General Ledger
Reversed Field, Bank Account Ledger Entry Table General Ledger
Debit Amount Field, Bank Account Ledger Entry Table General Ledger
Bank Acc. Posting Group Field, Bank Account Ledger Entry Table General Ledger
Reversed Entry No. Field, Bank Account Ledger Entry Table General Ledger
Bal. Account Type Field, Bank Account Ledger Entry Table General Ledger
Amount (LCY) Field, Bank Account Ledger Entry Table General Ledger
Positive Field, Bank Account Ledger Entry Table General Ledger
Transaction No. Field, Bank Account Ledger Entry Table General Ledger
Statement No. Field, Bank Account Ledger Entry Table General Ledger
External Document No. Field, Bank Account Ledger Entry Table General Ledger
Global Dimension 2 Code Field, Bank Account Ledger Entry Table General Ledger
Source Code Field, Bank Account Ledger Entry Table General Ledger
Statement Status Field, Bank Account Ledger Entry Table General Ledger
Journal Batch Name Field, Bank Account Ledger Entry Table General Ledger
Reason Code Field, Bank Account Ledger Entry Table General Ledger
Description Field, Bank Account Ledger Entry Table General Ledger
Our Contact Code Field, Bank Account Ledger Entry Table General Ledger
Closed at Date Field, Bank Account Ledger Entry Table General Ledger
Bank Account No. Field, Bank Account Ledger Entry Table General Ledger
Open Field, Bank Account Ledger Entry Table General Ledger
Debit Amount (LCY) Field, Bank Account Ledger Entry Table General Ledger
User ID Field, Bank Account Ledger Entry Table General Ledger
Bal. Account No. Field, Bank Account Ledger Entry Table General Ledger
Currency Code Field, Bank Account Ledger Entry Table General Ledger
Amount Field, Bank Account Ledger Entry Table General Ledger
Credit Amount (LCY) Field, Bank Account Ledger Entry Table General Ledger
Statement Line No. Field, Bank Account Ledger Entry Table General Ledger
Document Type Field, Bank Account Ledger Entry Table General Ledger
Dimension Set ID Field, Bank Account Ledger Entry Table General Ledger
Reversed by Entry No. Field, Bank Account Ledger Entry Table General Ledger
Document No. Field, Bank Account Ledger Entry Table General Ledger
Stale Cheque Field, Bank Account Ledger Entry Table India Local Functionality
Cheque Date Field, Bank Account Ledger Entry Table India Local Functionality
Stale Cheque Expiry Date Field, Bank Account Ledger Entry Table India Local Functionality
Cheque Stale Date Field, Bank Account Ledger Entry Table India Local Functionality
Cheque No. Field, Bank Account Ledger Entry Table India Local Functionality
Closed by Entry No. Field, Bank Account Ledger Entry Table General Ledger
Remaining Amount Field, Bank Account Ledger Entry Table General Ledger
Transaction No. Field, Bank Account Ledger Entry Table Spain Local Functionality
Document Date Field, Bank Account Ledger Entry Table General Ledger
Entry No. Field, Bank Account Ledger Entry Table General Ledger
Posting Date Field, Bank Account Ledger Entry Table General Ledger
Global Dimension 1 Code Field, Bank Account Ledger Entry Table General Ledger
Credit Amount Field, Bank Account Ledger Entry Table General Ledger
Reversed Field, Bank Account Ledger Entry Table General Ledger
Debit Amount Field, Bank Account Ledger Entry Table General Ledger
Bank Acc. Posting Group Field, Bank Account Ledger Entry Table General Ledger
Reversed Entry No. Field, Bank Account Ledger Entry Table General Ledger
Bal. Account Type Field, Bank Account Ledger Entry Table General Ledger
Amount (LCY) Field, Bank Account Ledger Entry Table General Ledger
Positive Field, Bank Account Ledger Entry Table General Ledger
Transaction No. Field, Bank Account Ledger Entry Table General Ledger
Statement No. Field, Bank Account Ledger Entry Table General Ledger
External Document No. Field, Bank Account Ledger Entry Table General Ledger
Global Dimension 2 Code Field, Bank Account Ledger Entry Table General Ledger
Source Code Field, Bank Account Ledger Entry Table General Ledger
Statement Status Field, Bank Account Ledger Entry Table General Ledger
Journal Batch Name Field, Bank Account Ledger Entry Table General Ledger
Reason Code Field, Bank Account Ledger Entry Table General Ledger
Description Field, Bank Account Ledger Entry Table General Ledger
Our Contact Code Field, Bank Account Ledger Entry Table General Ledger
Closed at Date Field, Bank Account Ledger Entry Table General Ledger
Bank Account No. Field, Bank Account Ledger Entry Table General Ledger
Open Field, Bank Account Ledger Entry Table General Ledger
Debit Amount (LCY) Field, Bank Account Ledger Entry Table General Ledger
User ID Field, Bank Account Ledger Entry Table General Ledger
Bal. Account No. Field, Bank Account Ledger Entry Table General Ledger
Currency Code Field, Bank Account Ledger Entry Table General Ledger
Amount Field, Bank Account Ledger Entry Table General Ledger
Credit Amount (LCY) Field, Bank Account Ledger Entry Table General Ledger
Statement Line No. Field, Bank Account Ledger Entry Table General Ledger
Document Type Field, Bank Account Ledger Entry Table General Ledger
Dimension Set ID Field, Bank Account Ledger Entry Table General Ledger
Reversed by Entry No. Field, Bank Account Ledger Entry Table General Ledger
Document No. Field, Bank Account Ledger Entry Table General Ledger
Dimension Set ID Field, Bank Account Ledger Entry Table General Ledger
Closed by Entry No. Field, Bank Account Ledger Entry Table General Ledger
Remaining Amount Field, Bank Account Ledger Entry Table General Ledger
Document Date Field, Bank Account Ledger Entry Table General Ledger
Entry No. Field, Bank Account Ledger Entry Table General Ledger
Posting Date Field, Bank Account Ledger Entry Table General Ledger
Global Dimension 1 Code Field, Bank Account Ledger Entry Table General Ledger
Credit Amount Field, Bank Account Ledger Entry Table General Ledger
Reversed Field, Bank Account Ledger Entry Table General Ledger
Debit Amount Field, Bank Account Ledger Entry Table General Ledger
Bank Acc. Posting Group Field, Bank Account Ledger Entry Table General Ledger
Reversed Entry No. Field, Bank Account Ledger Entry Table General Ledger
Bal. Account Type Field, Bank Account Ledger Entry Table General Ledger
Amount (LCY) Field, Bank Account Ledger Entry Table General Ledger
Positive Field, Bank Account Ledger Entry Table General Ledger
Transaction No. Field, Bank Account Ledger Entry Table General Ledger
Statement No. Field, Bank Account Ledger Entry Table General Ledger
External Document No. Field, Bank Account Ledger Entry Table General Ledger
Global Dimension 2 Code Field, Bank Account Ledger Entry Table General Ledger
Source Code Field, Bank Account Ledger Entry Table General Ledger
Statement Status Field, Bank Account Ledger Entry Table General Ledger
Journal Batch Name Field, Bank Account Ledger Entry Table General Ledger
Reason Code Field, Bank Account Ledger Entry Table General Ledger
Description Field, Bank Account Ledger Entry Table General Ledger
Our Contact Code Field, Bank Account Ledger Entry Table General Ledger
Closed at Date Field, Bank Account Ledger Entry Table General Ledger
Bank Account No. Field, Bank Account Ledger Entry Table General Ledger
Open Field, Bank Account Ledger Entry Table General Ledger
Debit Amount (LCY) Field, Bank Account Ledger Entry Table General Ledger
User ID Field, Bank Account Ledger Entry Table General Ledger
Bal. Account No. Field, Bank Account Ledger Entry Table General Ledger
Currency Code Field, Bank Account Ledger Entry Table General Ledger
Amount Field, Bank Account Ledger Entry Table General Ledger
Credit Amount (LCY) Field, Bank Account Ledger Entry Table General Ledger
Statement Line No. Field, Bank Account Ledger Entry Table General Ledger
Document Type Field, Bank Account Ledger Entry Table General Ledger
Dimension Set ID Field, Bank Account Ledger Entry Table General Ledger
Reversed by Entry No. Field, Bank Account Ledger Entry Table General Ledger
Document No. Field, Bank Account Ledger Entry Table General Ledger
Transaction No. Field, Bank Account Ledger Entry Table Spain Local Functionality

See Also

Reference

Bank Account Ledger Entries
Apply Bank Acc. Ledger Entries