ERP/2.50/Developers Guide/Database Model/org.openbravo.model.financialmgmt.payment/FIN Financial Account
FIN_Financial_Account
- Name:FIN_Financial_Account
- Classname:FIN_FinancialAccount
This table contains the following columns:
Name | Nullable | Data Type | Description |
Fin_Financial_Account_ID | N | VARCHAR2(32) | Financial account used to deposit / withdrawal money such as bank accounts or petty cash |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
Created | N | DATE | The date that this record is completed. |
Createdby | N | VARCHAR2(32) | User who created this records |
Updated | N | DATE | x not implemented |
Updatedby | N | VARCHAR2(32) | User who updated this records |
Isactive | Y | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
C_Currency_ID | N | VARCHAR2(32) | An accepted medium of monetary exchange that may vary across countries. |
Name | N | NVARCHAR2(60) | A non-unique identifier for a record/document often used as a search tool. |
Description | Y | NVARCHAR2(255) | A space to write additional related information. |
Type | N | VARCHAR2(60) | A distinct item characteristic used for processes and sometimes grouped within a category. |
C_Bpartner_ID | Y | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
C_Location_ID | Y | VARCHAR2(32) | A specific place or residence. |
Routingno | Y | NVARCHAR2(20) | Bank Routing Number |
Swiftcode | Y | NVARCHAR2(20) | Swift Code (Society of Worldwide Interbank Financial Telecommunications) |
Codebank | Y | NVARCHAR2(4) | Code of the bank |
Codebranch | Y | NVARCHAR2(4) | Code of the branch |
Bank_Digitcontrol | Y | NVARCHAR2(1) | null |
INE_Number | Y | NVARCHAR2(9) | INE Number. |
Account_Digitcontrol | Y | NVARCHAR2(1) | null |
Codeaccount | Y | NVARCHAR2(10) | Code of the account |
Accountno | Y | NVARCHAR2(20) | Account Number |
Currentbalance | N | NUMBER | Current Balance |
InitialBalance | N | NUMBER | Initial balance of the financial account. Amount of the account at the time of registering the financial account. |
Creditlimit | N | NUMBER | Amount of Credit allowed |
Iban | Y | NVARCHAR2(34) | International standard for identifying bank accounts across national borders |
Isdefault | N | CHAR(1) | A value that is shown whenever a record is created. |
FIN_Matching_Algorithm_ID | Y | VARCHAR2(32) | Identifies the algorithm used to match the imported bank statement lines |
Other Info
Check constraints
These are the check constraints for this table:
- FIN_FINACC_DEFAULT_CHECK: ISDEFAULT IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Unique
- FIN_FINANCIAL_ACCOUNT_KEY
Columns
Account
Financial account used to deposit / withdrawal money such as bank accounts or petty cash
- Physical column name: Fin_Financial_Account_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:
AD_Client.AD_Client_ID IN (@#User_Client@)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_ORG_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Validation Rule AD_Org Trx Security validation: null. With the following code:
AD_Org.AD_Org_ID<> '0' AND AD_Org.IsReady='Y'
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Created By
- Physical column name: Createdby
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was 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)
Active
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.
- Physical column name: Isactive
- Property Name: active
- Reference: YesNo
- Default value: Y
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
- This column is part of the table's identifier
Foreign key column to C_Currency table, (column: C_Currency_ID)
Name
A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: Text
Type
The Type indicates the type of validation that will occur. This can be SQL, Java Script or Java Language.
- Physical column name: Type
- Property Name: type
- Reference: List
- Default value: B
List values: Financial account type
The allowed values for this list are:
- B (Bank)
- C (Cash)
Business Partner
- Physical column name: C_Bpartner_ID
- Property Name: businessPartner
- Reference: Search
Foreign key column to C_Bpartner table, (column: C_BPartner_ID)
Location / Address
Address/Location of the the Financial Account within the Enterprise.
- Physical column name: C_Location_ID
- Property Name: locationAddress
- Reference: Search
Foreign key column to C_Location table, (column: C_Location_ID)
Routing No
The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions.
- Physical column name: Routingno
- Property Name: routingNo
- Reference: String
Swift code
The SWIFT code is an identifier of a Bank
- Physical column name: Swiftcode
- Property Name: swiftCode
- Reference: String
Bank Code
First four numbers of the bank account number which identifies the bank uniquely.
- Physical column name: Codebank
- Property Name: bankCode
- Reference: String
Branch Code
Second group of four numbers of the bank account which identifies the branch uniquely.
- Physical column name: Codebranch
- Property Name: branchCode
- Reference: String
Bank_Digitcontrol
Tenth number of the bank account.
- Physical column name: Bank_Digitcontrol
- Property Name: bankDigitcontrol
- Reference: String
INE No.
Number provided by the bank to configurate remittances.
- Physical column name: INE_Number
- Property Name: iNENo
- Reference: String
Account_Digitcontrol
- Physical column name: Account_Digitcontrol
- Property Name: accountDigitcontrol
- Reference: String
Partial Account No.
Last ten numbers of the bank account.
- Physical column name: Codeaccount
- Property Name: partialAccountNo
- Reference: String
Account No.
The Account Number indicates the Number assigned to this account
- Physical column name: Accountno
- Property Name: accountNo
- Reference: String
Current Balance
The Current Balance field indicates the current balance in this account.
- Physical column name: Currentbalance
- Property Name: currentBalance
- Reference: Amount
- Default value: 0
InitialBalance
Amount of the account at the time of registering the financial account. This amount is used to initialize financial account and will be used as last reconciliation amount for first reconciliation in OB for the given financial account.
- Physical column name: InitialBalance
- Property Name: initialBalance
- Reference: Amount
- Default value: 0
Credit Limit
The Credit Limit field indicates the credit limit for this account.
- Physical column name: Creditlimit
- Property Name: creditLimit
- Reference: Number
- Default value: 0
IBAN
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.
- Physical column name: Iban
- Property Name: iBAN
- Reference: String
Default
The Default Checkbox indicates if this record will be used as a default value.
- Physical column name: Isdefault
- Property Name: default
- Reference: YesNo
- Default value: N
Matching Algorithm
- Physical column name: FIN_Matching_Algorithm_ID
- Property Name: matchingAlgorithm
- Reference: TableDir
Foreign key column to FIN_Matching_Algorithm table, (column: FIN_Matching_Algorithm_ID)
Related tables
Tables that link this table:
- BusinessPartner.Account
- BusinessPartner.PO Financial Account
- FIN_Finacc_Transaction.Account
- FIN_Payment.Account
- FIN_Payment_Proposal.Account
- FinancialMgmtFinAccPaymentMethod.Account