ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.payment/FIN Financial Account
FIN_Financial_Account
- Name:FIN_Financial_Account
- Classname:FIN_Financial_Account
This table contains the following columns:
Name | Nullable | Data Type | Description
|
Fin_Financial_Account_ID | No | VARCHAR (32) | Financial account used to deposit / withdrawal money such as bank accounts or petty cash |
Accountno | Yes | NVARCHAR (120) | Text that will identify this bank account |
Account_Digitcontrol | Yes | NVARCHAR (1) | |
Isactive | Yes | 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. |
Codebank | Yes | NVARCHAR (4) | First four numbers of the bank account number which identifies the bank uniquely. |
BankFormat | Yes | VARCHAR (60) | Bank Account Format used for generating the Displayed Account Number |
Bank_Digitcontrol | Yes | NVARCHAR (1) | Tenth number of the bank account. |
Codebranch | Yes | NVARCHAR (4) | Second group of four numbers of the bank account which identifies the branch uniquely. |
C_Bpartner_ID | Yes | VARCHAR (32) | A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these. |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
C_Country_ID | Yes | VARCHAR (32) | The Country defines a Country. Each Country must be defined before it can be used in any document. |
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. |
Description | Yes | NVARCHAR (255) | A description is limited to 255 characters. |
EM_APRM_ImportBankFile | Yes | CHAR (1) | |
EM_APRM_MatchTransactions | Yes | CHAR (1) | |
EM_APRM_MatchTrans_Force | Yes | CHAR (1) | |
EM_APRM_Reconcile | Yes | CHAR (1) | |
EM_Aprm_AddMultiplePayments | Yes | CHAR (1) | User can select multiple payments at the same time. The system will create a separate transaction per selected payment |
EM_Aprm_Addtransactionpd | Yes | CHAR (1) | Add transaction process definition |
EM_Aprm_Findtransactionspd | Yes | CHAR (1) | |
EM_Aprm_Funds_Trans | Yes | CHAR (1) | Transfer funds between Financial Accounts |
EM_Aprm_Glitem_Diff | Yes | VARCHAR (32) | GL Item Difference |
EM_Aprm_Isfundstrans_Enabled | No | CHAR (1) | Funds Transfer Enabled flag is used to show/hide funds transfer button process and to show/hide Financial Accounts in Funds Transfer Process |
GenericAccountNo | Yes | NVARCHAR (100) | 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. |
INE_Number | Yes | NVARCHAR (9) | Number provided by the bank to configurate remittances. |
InitialBalance | No | DECIMAL | 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. |
C_Location_ID | Yes | VARCHAR (32) | The Location / Address field defines the location of an entity. |
FIN_Matching_Algorithm_ID | Yes | VARCHAR (32) | Identifies the algorithm used to match the imported bank statement lines |
Name | No | NVARCHAR (60) | 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. |
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. |
Routingno | Yes | NVARCHAR (20) | The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions. |
Swiftcode | Yes | NVARCHAR (20) | The SWIFT Code is an identifier of a Bank |
Type | No | VARCHAR (60) | The Type indicates the type of validation that will occur. This can be SQL, Java Script or Java Language. |
Typewriteoff | Yes | VARCHAR (60) | It allows to define different type of write-off limit for a financial account. This field is displayed when write-off limit preference value is set to "Y". |
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. |
Writeofflimit | Yes | DECIMAL | Value for the Write-off limit in a payment. When type selected is Amount, the value holds the amount on financial account currency. This field is displayed when write-off limit preference value is set to "Y". |
Columns
Account
- Physical column name: Fin_Financial_Account_ID
- Property Name: id
- Reference: ID
Account No.
- Physical column name: Accountno
- Property Name: accountNo
- Reference: String
Account_Digitcontrol
- Physical column name: Account_Digitcontrol
- Property Name: accountDigitcontrol
- Reference: String
Active
- Physical column name: Isactive
- Property Name: active
- Reference: YesNo
- Default value: Y
Bank Code
- Physical column name: Codebank
- Property Name: bankCode
- Reference: String
Bank Format
- Physical column name: BankFormat
- Property Name: bankFormat
- Reference: List
It has a validation "BankFormat Spanish Country", with the following code
((UPPER(Value)<>'SPANISH' AND @C_Country_ID@<>'106') OR @C_Country_ID@='106')
List values: Bank Account Format
The allowed values for this list are:
- GENERIC (Use Generic Account No.)
- IBAN (Use IBAN)
- SWIFT (Use SWIFT + Generic Account No.)
- SPANISH (Use Spanish)
Bank_Digitcontrol
- Physical column name: Bank_Digitcontrol
- Property Name: bankDigitcontrol
- Reference: String
Branch Code
- Physical column name: Codebranch
- Property Name: branchCode
- Reference: String
Business Partner
- Physical column name: C_Bpartner_ID
- Property Name: businessPartner
- Reference: OBUISEL_Selector Reference
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
It has a validation "AD_Client Security validation", with the following code
AD_Client.AD_Client_ID in (@#User_Client@)
Country
- Physical column name: C_Country_ID
- Property Name: country
- Reference: TableDir
Foreign key column to C_Country table, (column: C_Country_ID)
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
- This column is part of the table's identifier
Foreign key column to C_Currency table, (column: C_Currency_ID)
Current Balance
- Physical column name: Currentbalance
- Property Name: currentBalance
- Reference: Amount
- Default value: 0
Default
- Physical column name: Isdefault
- Property Name: default
- Reference: YesNo
- Default value: N
Description
- Physical column name: Description
- Property Name: description
- Reference: Text
EM_APRM_ImportBankFile
- Physical column name: EM_APRM_ImportBankFile
- Property Name: aPRMImportBankFile
- Reference: Button
EM_APRM_MatchTransactions
- Physical column name: EM_APRM_MatchTransactions
- Property Name: aPRMMatchTransactions
- Reference: Button
EM_APRM_MatchTransactions_Force
- Physical column name: EM_APRM_MatchTrans_Force
- Property Name: aPRMMatchTransactionsForce
- Reference: Button
EM_APRM_Reconcile
- Physical column name: EM_APRM_Reconcile
- Property Name: aPRMReconcile
- Reference: Button
EM_Aprm_AddMultiplePayments
- Physical column name: EM_Aprm_AddMultiplePayments
- Property Name: aprmAddMultiplePayments
- Reference: Button
- Default value: N
EM_Aprm_Addtransactionpd
- Physical column name: EM_Aprm_Addtransactionpd
- Property Name: aprmAddtransactionpd
- Reference: Button
EM_Aprm_Findtransactionspd
- Physical column name: EM_Aprm_Findtransactionspd
- Property Name: aprmFindtransactionspd
- Reference: Button
EM_Aprm_Funds_Trans
- Physical column name: EM_Aprm_Funds_Trans
- Property Name: aprmFundsTrans
- Reference: Button
EM_Aprm_Glitem_Diff
- Physical column name: EM_Aprm_Glitem_Diff
- Property Name: aprmGlitemDiff
- Reference: OBUISEL_Selector Reference
Foreign key column to C_Glitem table, (column: C_Glitem_ID)
EM_Aprm_Isfundstrans_Enabled
- Physical column name: EM_Aprm_Isfundstrans_Enabled
- Property Name: aprmIsfundstransEnabled
- Reference: YesNo
- Default value: Y
Generic Account No.
- Physical column name: GenericAccountNo
- Property Name: genericAccountNo
- Reference: String
IBAN
- Physical column name: Iban
- Property Name: iBAN
- Reference: String
INE No.
- Physical column name: INE_Number
- Property Name: iNENo
- Reference: String
InitialBalance
- Physical column name: InitialBalance
- Property Name: initialBalance
- Reference: Amount
- Default value: 0
Location / Address
- Physical column name: C_Location_ID
- Property Name: locationAddress
- Reference: Search
Foreign key column to C_Location table, (column: C_Location_ID)
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)
Name
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
It has a validation "AD_Org is transactions allowed", with the following code
EXISTS (SELECT 1 FROM ad_orgtype WHERE ad_orgtype.ad_orgtype_id=ad_org.ad_orgtype_id AND IsTransactionsAllowed='Y') and IsReady='Y'
Partial Account No.
- Physical column name: Codeaccount
- Property Name: partialAccountNo
- Reference: String
Routing No
- Physical column name: Routingno
- Property Name: routingNo
- Reference: String
Swift code
- Physical column name: Swiftcode
- Property Name: swiftCode
- Reference: String
Type
- Physical column name: Type
- Property Name: type
- Reference: List
- Default value: B
List values: Financial account type
The allowed values for this list are:
- C (Cash)
- B (Bank)
Typewriteoff
- Physical column name: Typewriteoff
- Property Name: typewriteoff
- Reference: List
List values: Write off type
The allowed values for this list are:
- A (Amount)
- P (Percentage)
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)
Writeofflimit
- Physical column name: Writeofflimit
- Property Name: writeofflimit
- Reference: Amount
Other Info
Indices
These are the indices for this table (for each index there is a list of all the columns included within it):
- EM_APRM_GLITEM_FKI Not Unique. Columns:
- EM_APRM_GLITEM_DIFF
Check Constraints
These are the check constraints for this table:
- FIN_FINACC_DEFAULT_CHECK: ISDEFAULT IN ('Y', 'N')
- FIN_FINACC_SHOWGENERIC_CHK: UPPER(BANKFORMAT) = UPPER('GENERIC') AND GENERICACCOUNTNO IS NOT NULL OR UPPER(BANKFORMAT) <> UPPER('GENERIC')
- FIN_FINACC_SHOWIBAN_CHK: UPPER(BANKFORMAT) = UPPER('IBAN') AND IBAN IS NOT NULL OR UPPER(BANKFORMAT) <> UPPER('IBAN')
- FIN_FINACC_SHOWSWIFT_CHK: UPPER(BANKFORMAT) = UPPER('SWIFT') AND SWIFTCODE IS NOT NULL AND GENERICACCOUNTNO IS NOT NULL OR UPPER(BANKFORMAT) <> UPPER('SWIFT')
- FIN_FINACC_SPANISH_CHK: UPPER(BANKFORMAT) = UPPER('SPANISH') AND CODEBANK IS NOT NULL AND CODEBRANCH IS NOT NULL AND BANK_DIGITCONTROL IS NOT NULL AND ACCOUNT_DIGITCONTROL IS NOT NULL AND CODEACCOUNT IS NOT NULL OR UPPER(BANKFORMAT) <> UPPER('SPANISH')
- EM_APRM_FIN_FINACC_ISFUNDS_CHK: EM_APRM_ISFUNDSTRANS_ENABLED IN ('Y', 'N')