View source | Discuss this page | Page history | Printable version   

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.bank/C BankAccount Acct

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.bank


Contents

C_BankAccount_Acct

This table contains the following columns:

Name Nullable Data Type Description


C_AcctSchema_ID No VARCHAR (32) The book containing all financial transactions recorded for the legal entity.
IsActive No CHAR (1) There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:

(1) The system requires the record for auditing purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

C_BankAccount_ID No VARCHAR (32) The Bank Account identifies an account at this Bank.
B_Asset_Acct No VARCHAR (32) The Bank Asset Account identifies the account to be used for booking changes to the balance in this bank account
B_Expense_Acct No VARCHAR (32) The Bank Expense Account identifies the account to be used for recording charges or fees incurred from this Bank.
B_InTransit_Acct No VARCHAR (32) The Bank in Transit Account identifies the account to be used for funds which are in transit.
B_InterestExp_Acct Yes VARCHAR (32) The Bank Interest Expense Account identifies the account to be used for recording interest expenses.
B_InterestRev_Acct Yes VARCHAR (32) The Bank Interest Revenue Account identifies the account to be used for recording interest revenue from this Bank.
B_RevaluationGain_Acct No VARCHAR (32) The Bank Revaluation Gain Account identifies the account to be used for recording gains that are recognized when converting currencies.
B_RevaluationLoss_Acct No VARCHAR (32) The Bank Revaluation Loss Account identifies the account to be used for recording losses that are recognized when converting currencies.
B_SettlementGain_Acct Yes VARCHAR (32) The Bank Settlement Gain account identifies the account to be used when recording a currency gain when the settlement and receipt currency are not the same.
B_SettlementLoss_Acct Yes VARCHAR (32) The Bank Settlement loss account identifies the account to be used when recording a currency loss when the settlement and receipt currency are not the same.
B_Unidentified_Acct Yes VARCHAR (32) The Bank Unidentified Receipts Account identifies the account to be used when recording receipts that can not be reconciled at the present time.
C_BankAccount_Acct_ID No VARCHAR (32)
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
AD_Org_ID No VARCHAR (32) An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
B_PaymentSelect_Acct Yes VARCHAR (32) AP Payment Selection Clearing Account
B_UnallocatedCash_Acct Yes VARCHAR (32) Receipts not allocated to Invoices
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.

Columns

Accounting Schema

Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)

top


Active



top


Bank Account

Foreign key column to C_BankAccount table, (column: C_BankAccount_ID)

top


Bank Asset


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Expense


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank In Transit


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Interest Expense


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Interest Revenue


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Revaluation Gain


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Revaluation Loss


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Settlement Gain


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Settlement Loss


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Unidentified Receipts


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


C_BankAccount_Acct_ID



top


Client


Foreign key column to AD_Client table, (column: AD_Client_ID)

top


Created By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Creation Date



top


Organization


Foreign key column to AD_Org table, (column: AD_Org_ID)

top


Payment Selection


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Unallocated Cash


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Updated



top


Updated By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Other Info

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.common.bank

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.common.bank/C_BankAccount_Acct"

This page has been accessed 3,857 times. This page was last modified on 7 September 2020, at 01:56. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.