ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.bank/C BankAccount
C_BankAccount
- Name:C_BankAccount
- Classname:BankAccount
This table contains the following columns:
Name | Nullable | Data Type | Description
|
AccountNo | Yes | NVARCHAR (20) | The Account Number indicates the Number assigned to this account |
BankAccountType | No | VARCHAR (60) | The Bank Account Type field indicates the type of account (savings, checking etc) this account is defined as. |
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_Bank_ID | No | VARCHAR (32) | The Bank is a unique identifier of a Bank for this Organization or for a Business Partner with whom this Organization transacts. |
C_BankAccount_ID | No | VARCHAR (32) | The Bank Account identifies an account at this Bank. |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
Digitcontrol | Yes | NVARCHAR (1) | Tenth number of the bank account. |
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. |
CreditLimit | No | DECIMAL | The Credit Limit field indicates the credit limit for this account. |
C_Currency_ID | No | VARCHAR (32) | Indicates the currency to be used when processing this document. |
CurrentBalance | No | DECIMAL | The Current Balance field indicates the current balance in this account. |
IsDefault | No | CHAR (1) | The Default Checkbox indicates if this record will be used as a default value. |
DisplayedAccount | Yes | NVARCHAR (50) | Text that will identify this bank account |
GenericAccount | Yes | NVARCHAR (50) | Bank account number in a generic format. |
Iban | Yes | NVARCHAR (34) | Code that identifies uniquely one bank account, no matter the country it belongs to. It consists of a ISO 3166-1 alpha-2 country code, followed by two check digits, and up to thirty alphanumeric characters for the domestic bank account number, called the BBAN (Basic Bank Account Number). It is up to each country's national banking community to decide on the length of the BBAN for accounts in that country, but its length must be fixed for any given country. |
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. |
Codeaccount | Yes | NVARCHAR (10) | Last ten numbers of the bank account. |
ShowGeneric | Yes | CHAR (1) | Use the Generic Account Number for generating the Displayed Account Number |
ShowIBAN | Yes | CHAR (1) | Use IBAN for generating the Displayed Account Number |
ShowSpanish | Yes | CHAR (1) | Use Spanish Format |
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
Account No.
- Physical column name: AccountNo
- Property Name: accountNo
- Reference: String
Account Type
- Physical column name: BankAccountType
- Property Name: accountType
- Reference: List
List values: C_Bank Account Type
The allowed values for this list are:
- C (Checking)
- S (Savings)
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Bank
- Physical column name: C_Bank_ID
- Property Name: bank
- Reference: TableDir
- This column is part of the table's identifier
- This column is a child for a business object (is Parent)
Foreign key column to C_Bank table, (column: C_Bank_ID)
Bank Account
- Physical column name: C_BankAccount_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
Control Digit
- Physical column name: Digitcontrol
- Property Name: controlDigit
- Reference: String
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Credit Limit
- Physical column name: CreditLimit
- Property Name: creditLimit
- Reference: Number
- Default value: 0
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
Foreign key column to C_Currency table, (column: C_Currency_ID)
Current Balance
- Physical column name: CurrentBalance
- Property Name: currentBalance
- Reference: Number
- Default value: 0
Default
- Physical column name: IsDefault
- Property Name: default
- Reference: YesNo
- Default value: N
Displayed Account
- Physical column name: DisplayedAccount
- Property Name: displayedAccount
- Reference: String
- This column is part of the table's identifier
Generic Account
- Physical column name: GenericAccount
- Property Name: genericAccount
- Reference: String
IBAN
- Physical column name: Iban
- Property Name: iBAN
- Reference: String
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Partial Account No.
- Physical column name: Codeaccount
- Property Name: partialAccountNo
- Reference: String
Show Generic
- Physical column name: ShowGeneric
- Property Name: showGeneric
- Reference: YesNo
Show IBAN
- Physical column name: ShowIBAN
- Property Name: showIBAN
- Reference: YesNo
Show Spanish
- Physical column name: ShowSpanish
- Property Name: showSpanish
- Reference: YesNo
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Other Info
Indices
These are the indices for this table (for each index there is a list of all the columns included within it):
- C_BANKACCT_BANK Not Unique. Columns:
- C_BANK_ID
Check Constraints
These are the check constraints for this table:
- C_BANKACC_SHOWGENERIC_CHECK: GENERICACCOUNT IS NOT NULL OR SHOWGENERIC = 'N'
- C_BANKACC_SHOWIBAN_CHECK: IBAN IS NOT NULL OR SHOWIBAN = 'N'
- C_BANKACC_SHOWONE_CHECK: SHOWSPANISH = 'Y' AND SHOWGENERIC = 'N' AND SHOWIBAN = 'N' OR SHOWSPANISH = 'N' AND SHOWGENERIC = 'Y' AND SHOWIBAN = 'N' OR SHOWSPANISH = 'N' AND SHOWGENERIC = 'N' AND SHOWIBAN = 'Y'
- C_BANKACC_SHOWSPANISH_CHECK: DIGITCONTROL IS NOT NULL AND CODEACCOUNT IS NOT NULL AND LENGTH(DIGITCONTROL) = 1 AND LENGTH(CODEACCOUNT) = 10 OR DIGITCONTROL IS NULL AND CODEACCOUNT IS NULL AND SHOWSPANISH = 'N'
- C_BANKACCOUNT_ACCOUNTNO_CHECK: GENERICACCOUNT IS NOT NULL OR IBAN IS NOT NULL OR CODEACCOUNT IS NOT NULL AND DIGITCONTROL IS NOT NULL
- C_BANKACCOUNT_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
![]() | Back to org.openbravo.model.common.bank |