ERP/2.50/Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting/FIN Financial Account Acct
FIN_Financial_Account_Acct
Accounting configuration of financial account
- Name:FIN_Financial_Account_Acct
- Classname:FIN_FinancialAccountAccounting
This table contains the following columns:
Name | Nullable | Data Type | Description |
FIN_Financial_Account_Acct_ID | N | VARCHAR2(32) | Financial Account Accounts |
FIN_Financial_Account_ID | N | VARCHAR2(32) | Financial account used to deposit / withdrawal money such as bank accounts or petty cash |
C_Acctschema_ID | N | VARCHAR2(32) | The structure used in accounting including costing methods, currencies, and the calendar. |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
Isactive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
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 |
FIN_Receivepayment_Acct | Y | VARCHAR2(32) | Receive Payment Account used by financial account |
FIN_Makepayment_Acct | Y | VARCHAR2(32) | Make Payment Account used by financial account |
FIN_Deposit_Acct | Y | VARCHAR2(32) | Deposit Account used by the financial account |
FIN_Withdrawal_Acct | Y | VARCHAR2(32) | Withdrawal Account used by the financial account |
FIN_Debit_Acct | Y | VARCHAR2(32) | Debit Account used by the financial account |
FIN_Credit_Acct | Y | VARCHAR2(32) | Credit Account used by the financial account |
FIN_Bankfee_Acct | Y | VARCHAR2(32) | Account used for posting Bank Fees |
FIN_Bankrevaluationgain_Acct | Y | VARCHAR2(32) | Account used for posting currency revaluation gains |
FIN_Bankrevaluationloss_Acct | Y | VARCHAR2(32) | Account used for posting currency revaluation losses |
FIN_Out_Intransit_Acct | Y | VARCHAR2(32) | Account used for in transit status of outgoing payments |
FIN_Out_Clear_Acct | Y | VARCHAR2(32) | Account used for status cleared of outgoing payments |
FIN_In_Intransit_Acct | Y | VARCHAR2(32) | Account used for in transit status of incoming payments |
FIN_In_Clear_Acct | Y | VARCHAR2(32) | Account used for payment IN when clearing |
FIN_Asset_Acct | Y | VARCHAR2(32) | Bank Asset Account used for bank statement accounting |
FIN_Transitory_Acct | Y | VARCHAR2(32) | Bank Transitory Account used for bank statement accounting |
EnableBankStatement | N | CHAR(1) | Enable Bank Statement Accounting |
Other Info
Check constraints
These are the check constraints for this table:
- FIN_FINACC_ACCT_BSCONFIG_CHECK: (((ENABLEBANKSTATEMENT = 'Y') AND (FIN_TRANSITORY_ACCT IS NOT NULL)) AND (FIN_ASSET_ACCT IS NOT NULL)) OR (ENABLEBANKSTATEMENT <> 'Y')
- FIN_FINACC_ACCT_ENABLEBS_CHECK: ENABLEBANKSTATEMENT IN ('Y', 'N')
- FIN_FINACC_ACCT_ISACTIVE_CHECK: ISACTIVE 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_FINACC_ACCT_ACCTSCHEMA_UN
- FIN_FINANCIAL_ACCOUNT_ACCT_KEY
Columns
FIN_Financial_Account_Acct_ID
Financial Account Accounts
- Physical column name: FIN_Financial_Account_Acct_ID
- Property Name: id
- Reference: ID
Account
- Physical column name: FIN_Financial_Account_ID
- Property Name: account
- Reference: Search
- This column is part of the table's identifier
- This column is a child for a buisiness object (is Parent)
Foreign key column to FIN_Financial_Account table, (column: Fin_Financial_Account_ID)
Accounting Schema
- Physical column name: C_Acctschema_ID
- Property Name: accountingSchema
- Reference: TableDir
- This column is part of the table's identifier
- This column is a child for a buisiness object (is Parent)
Foreign key column to C_Acctschema table, (column: C_AcctSchema_ID)
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: Search
- 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: Search
- 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'
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
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)
Receive Payment Account
- Physical column name: FIN_Receivepayment_Acct
- Property Name: receivePaymentAccount
- Reference: Search
Foreign key column to FIN_Receivepayment_A table, (column: null)
Make Payment Account
- Physical column name: FIN_Makepayment_Acct
- Property Name: makePaymentAccount
- Reference: Search
Foreign key column to FIN_Makepayment_A table, (column: null)
Deposit Account
- Physical column name: FIN_Deposit_Acct
- Property Name: depositAccount
- Reference: Search
Foreign key column to FIN_Deposit_A table, (column: null)
Withdrawal Account
- Physical column name: FIN_Withdrawal_Acct
- Property Name: withdrawalAccount
- Reference: Search
Foreign key column to FIN_Withdrawal_A table, (column: null)
Debit Account
- Physical column name: FIN_Debit_Acct
- Property Name: debitAccount
- Reference: Search
Foreign key column to FIN_Debit_A table, (column: null)
Credit Account
- Physical column name: FIN_Credit_Acct
- Property Name: creditAccount
- Reference: Search
Foreign key column to FIN_Credit_A table, (column: null)
FIN_Bankfee_Acct
- Physical column name: FIN_Bankfee_Acct
- Property Name: fINBankfeeAcct
- Reference: Search
Foreign key column to FIN_Bankfee_A table, (column: null)
FIN_Bankrevaluationgain_Acct
- Physical column name: FIN_Bankrevaluationgain_Acct
- Property Name: fINBankrevaluationgainAcct
- Reference: Search
Foreign key column to FIN_Bankrevaluationgain_A table, (column: null)
FIN_Bankrevaluationloss_Acct
- Physical column name: FIN_Bankrevaluationloss_Acct
- Property Name: fINBankrevaluationlossAcct
- Reference: Search
Foreign key column to FIN_Bankrevaluationloss_A table, (column: null)
In Transit Payment Account
Account used for in transit status of outgoing payments
- Physical column name: FIN_Out_Intransit_Acct
- Property Name: fINOutIntransitAcct
- Reference: Search
Foreign key column to FIN_Out_Intransit_A table, (column: null)
Cleared Payment Account
Account used for status cleared of outgoing payments
- Physical column name: FIN_Out_Clear_Acct
- Property Name: clearedPaymentAccountOUT
- Reference: Search
Foreign key column to FIN_Out_Clear_A table, (column: null)
In Transit Payment Account
Account used for in transit status of incoming payments
- Physical column name: FIN_In_Intransit_Acct
- Property Name: inTransitPaymentAccountIN
- Reference: Search
Foreign key column to FIN_In_Intransit_A table, (column: null)
Cleared Payment Account
Account used for payment IN when clearing
- Physical column name: FIN_In_Clear_Acct
- Property Name: clearedPaymentAccount
- Reference: Search
Foreign key column to FIN_In_Clear_A table, (column: null)
FIN_Asset_Acct
- Physical column name: FIN_Asset_Acct
- Property Name: fINAssetAcct
- Reference: Search
Foreign key column to FIN_Asset_A table, (column: null)
FIN_Transitory_Acct
- Physical column name: FIN_Transitory_Acct
- Property Name: fINTransitoryAcct
- Reference: Search
Foreign key column to FIN_Transitory_A table, (column: null)
Callout: SE_FinancialAccount_BSAccounts
This element is linked to a callout.
Displays a warning message to prevent users configuring the accounts in a wrong way.
It is implemented by org.openbravo.erpCommon.ad_callouts.SE_FinancialAccount_BSAccounts Java class.
Enablebankstatement
This flag enables accounting for Bank Statements. Some accounts will be required for proper configuration
- Physical column name: EnableBankStatement
- Property Name: enablebankstatement
- Reference: YesNo
- Default value: N