ERP 2.50:Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting.coa/C ElementValue
C_ElementValue
The individual valid values for the Element. The values must conform to the format defined. If the Element is an Account Type then the Account Classification (Asset, Liability etc) and posting controls are also defined
- Name:FinancialMgmtElementValue
- Classname:ElementValue
This table contains the following columns:
Name | Nullable | Data Type | Description |
C_ElementValue_ID | N | VARCHAR2(32) | A identification code for an account type. |
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 |
Value | N | NVARCHAR2(40) | A fast method for finding a particular record. |
Name | N | NVARCHAR2(255) | 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. |
AccountType | N | VARCHAR2(60) | Indicates the type of account |
AccountSign | N | VARCHAR2(60) | Indicates the Natural Sign of the Account as a Debit or Credit |
IsDocControlled | Y | CHAR(1) | Control account - If an account is controlled by a document, you cannot post manually to it |
C_Element_ID | N | VARCHAR2(32) | A unique identifier for an account type. |
IsSummary | N | CHAR(1) | A means of grouping fields in order to view or hide additional information. |
ValidFrom | Y | DATE | A parameter stating the starting time of a specified request. |
ValidTo | Y | DATE | A parameter stating the ending time of a specified request. |
PostActual | Y | CHAR(1) | Actual Values can be posted |
PostBudget | Y | CHAR(1) | Budget values can be posted |
PostEncumbrance | Y | CHAR(1) | Post commitments to this account |
PostStatistical | Y | CHAR(1) | Post statistical quantities to this account? |
IsBankAccount | Y | CHAR(1) | A monetary account of funds held in a recognized banking institution. |
C_BankAccount_ID | Y | VARCHAR2(32) | A monetary account of funds held in a recognized banking institution. |
IsForeignCurrency | Y | CHAR(1) | Balances in foreign currency accounts are held in the nominated currency |
C_Currency_ID | Y | VARCHAR2(32) | An accepted medium of monetary exchange that may vary across countries. |
ShowElement | Y | CHAR(1) | Show element |
ShowValueCond | N | VARCHAR2(60) | Show Value Condition |
ElementLevel | N | VARCHAR2(60) | Element Level |
Isalwaysshown | N | CHAR(1) | A node flagged as "Title Node", will always be displayed in the report, even if the balance is 0, and the "Show only accounts with value" is flagged. |
Other Info
Check constraints
These are the check constraints for this table:
- C_ELEMENTVALUE_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- C_ELEMENTVALUE_ISALWAYSSHW_CHK: ISALWAYSSHOWN IN ('Y', 'N')
- C_ELEMENTVALUE_ISBANKACCOU_CHK: ISBANKACCOUNT IN ('Y', 'N')
- C_ELEMENTVALUE_ISDOCCONTRO_CHK: ISDOCCONTROLLED IN ('Y', 'N')
- C_ELEMENTVALUE_ISFOREIGNCU_CHK: ISFOREIGNCURRENCY IN ('Y', 'N')
- C_ELEMENTVALUE_POSTACTUAL_CHK: POSTACTUAL IN ('Y', 'N')
- C_ELEMENTVALUE_POSTBUDGET_CHK: POSTBUDGET IN ('Y', 'N')
- C_ELEMENTVALUE_POSTENCUMBR_CHK: POSTENCUMBRANCE IN ('Y', 'N')
- C_ELEMENTVALUE_POSTSTATIST_CHK: POSTSTATISTICAL 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):
Non Unique
- C_ELEMENTVALUE_NAME
Unique
- C_ELEMENTVALUE_KEY
- C_ELEMENTVALUE_VALUE
Columns
Account Element
Account Elements can be natural accounts or user defined values.
- Physical column name: C_ElementValue_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)
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)
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
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
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Search Key
A search key allows for a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number originating from a document sequence defined in the "Document Sequence" window. The sequence naming convention follows a rule "DocumentNo_TableName", where TableName is the actual name of the database table (e.g. C_Order).
Usually, company's internal identifiers for various records (products, customers, etc) are stored here.
- Physical column name: Value
- Property Name: searchKey
- Reference: String
- This column is part of the table's identifier
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: String
Account Type
Valid account types are A - Asset, E - Expense, L - Liability, O- Owner Equity, R -Revenue and M- Memo. The account type is used to determine what taxes, if any are applicable, validating payables and receivables for business partners. Note: Memo account amounts are ignored when checking for balancing
- Physical column name: AccountType
- Property Name: accountType
- Reference: List
- Default value: E
List values: C_ElementValue AccountType
The allowed values for this list are:
- A (Asset): Asset (Balance Sheet) Account
- E (Expense): Expense (P&L) Account
- L (Liability): Liability (Balance Sheet) Account
- M (Memo): Memo (Non Balance Sheet nor P&L) Account
- O (Owner's Equity): Owner's Equity (Balance Sheet) Account
- R (Revenue): Revenue (P&L) Account
Account Sign
Indicates if the expected balance for this account should be a Debit or a Credit.
- Physical column name: AccountSign
- Property Name: accountSign
- Reference: List
- Default value: N
List values: C_ElementValue Account Sign
The allowed values for this list are:
- C (Credit): Credit Balance Account
- D (Debit): Debit Balance Account
- N (Natural): Natural sign of the Account Type
Document Controlled
Control account - If an account is controlled by a document, you cannot post manually to it
- Physical column name: IsDocControlled
- Property Name: documentControlled
- Reference: YesNo
Accounting Element
- Physical column name: C_Element_ID
- Property Name: accountingElement
- Reference: TableDir
- This column is a child for a buisiness object (is Parent)
Foreign key column to C_Element table, (column: C_Element_ID)
Summary Level
A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values.
- Physical column name: IsSummary
- Property Name: summaryLevel
- Reference: YesNo
Valid from Date
The Valid From date indicates the first day of a date range
- Physical column name: ValidFrom
- Property Name: validFromDate
- Reference: Date
Valid to Date
The Valid To date indicates the last day of a date range
- Physical column name: ValidTo
- Property Name: validToDate
- Reference: Date
Post Actual
The Post Actual indicates if actual values can be posted to this element value.
- Physical column name: PostActual
- Property Name: postActual
- Reference: YesNo
- Default value: Y
Post Budget
The Post Budget indicates if budget values can be posted to this element value.
- Physical column name: PostBudget
- Property Name: postBudget
- Reference: YesNo
- Default value: Y
Post Encumbrance
Post commitments to this account
- Physical column name: PostEncumbrance
- Property Name: postEncumbrance
- Reference: YesNo
- Default value: Y
Post Statistical
Post statistical quantities to this account?
- Physical column name: PostStatistical
- Property Name: postStatistical
- Reference: YesNo
- Default value: Y
Is Bank Account
The Bank Account checkbox indicates if this is account is the bank account.
- Physical column name: IsBankAccount
- Property Name: isBankAccount
- Reference: YesNo
Bank Account
- Physical column name: C_BankAccount_ID
- Property Name: bankAccount
- Reference: TableDir
Foreign key column to C_BankAccount table, (column: C_BankAccount_ID)
Foreign Currency Account
Balances in foreign currency accounts are held in the nominated currency and translated to functional currency
- Physical column name: IsForeignCurrency
- Property Name: foreignCurrencyAccount
- Reference: YesNo
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
Foreign key column to C_Currency table, (column: C_Currency_ID)
Element Shown
Displays this element.
- Physical column name: ShowElement
- Property Name: elementShown
- Reference: YesNo
- Default value: Y
Show Value Condition
Condition to show value. when algebraic it is always displayed, when positive it is shown only if the amount is positive and when negative it is shown only if the amount is negative.
- Physical column name: ShowValueCond
- Property Name: showValueCondition
- Reference: List
- Default value: A
List values: C_ElementValue show value conditions
The allowed values for this list are:
- A (Algebraic)
- N (Negative ONLY)
- P (Positive ONLY)
Element Level
Indicates the level of the account (heading, account, breakdown or subaccount).
- Physical column name: ElementLevel
- Property Name: elementLevel
- Reference: List
- Default value: C
List values: C_ElementValue level
The allowed values for this list are:
- C (Account)
- D (Breakdown)
- E (Heading)
- S (Subaccount)
Title Node
A node flagged as "Title Node", will always be displayed in the report, even if the balance is 0, and the "Show only accounts with value" is flagged.
- Physical column name: Isalwaysshown
- Property Name: titleNode
- Reference: YesNo
- Default value: N
Related tables
Tables that link this table:
- DataImportBudgetLine.Account Element
- DataImportElementValue.Account Element
- DataImportElementValue.Parent Account
- DataImportGLJournal.Account
- FinancialMgmtAccountingCombination.Account
- FinancialMgmtAccountingFact.Account
- FinancialMgmtAccountingRptElement.Account
- FinancialMgmtAcctRptNode.Account Element
- FinancialMgmtAcctSchemaElement.Account Element
- FinancialMgmtBudgetLine.Account Element
- FinancialMgmtElementValueOperand.Account
- FinancialMgmtElementValueOperand.Account Element
- FinancialMgmtElementValueTrl.Account Element