View source | Discuss this page | Page history | Printable version   

ERP/2.50/Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting.coa/C ElementValue

Contents

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

This table contains the following columns:

Name Nullable Data Type Description
C_ElementValue_ID NVARCHAR2(32)A identification code for an account type.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
UpdatedBy NVARCHAR2(32)User who updated this records
Value NNVARCHAR2(40)A fast method for finding a particular record.
Name NNVARCHAR2(255)A non-unique identifier for a record/document often used as a search tool.
Description YNVARCHAR2(255)A space to write additional related information.
AccountType NVARCHAR2(60)Indicates the type of account
AccountSign NVARCHAR2(60)Indicates the Natural Sign of the Account as a Debit or Credit
IsDocControlled YCHAR(1)Control account - If an account is controlled by a document, you cannot post manually to it
C_Element_ID NVARCHAR2(32)A unique identifier for an account type.
IsSummary NCHAR(1)A means of grouping fields in order to view or hide additional information.
ValidFrom YDATEA parameter stating the starting time of a specified request.
ValidTo YDATEA parameter stating the ending time of a specified request.
PostActual YCHAR(1)Actual Values can be posted
PostBudget YCHAR(1)Budget values can be posted
PostEncumbrance YCHAR(1)Post commitments to this account
PostStatistical YCHAR(1)Post statistical quantities to this account?
IsBankAccount YCHAR(1)A monetary account of funds held in a recognized banking institution.
C_BankAccount_ID YVARCHAR2(32)A monetary account of funds held in a recognized banking institution.
IsForeignCurrency YCHAR(1)Balances in foreign currency accounts are held in the nominated currency
C_Currency_ID YVARCHAR2(32)An accepted medium of monetary exchange that may vary across countries.
ShowElement YCHAR(1)Show element
ShowValueCond NVARCHAR2(60)Show Value Condition
ElementLevel NVARCHAR2(60)Element Level
Isalwaysshown NCHAR(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:

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Non Unique

Unique

top

Columns

Account Element

Account Elements can be natural accounts or user defined values.

top

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

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.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

Foreign key column to AD_User table, (column: AD_User_ID)

top

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.

top

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.

top

Description

A description is limited to 255 characters.

top

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

List values: C_ElementValue AccountType

The allowed values for this list are:

top

Account Sign

Indicates if the expected balance for this account should be a Debit or a Credit.

List values: C_ElementValue Account Sign

The allowed values for this list are:

top

Document Controlled

Control account - If an account is controlled by a document, you cannot post manually to it

top

Accounting Element

Foreign key column to C_Element table, (column: C_Element_ID)

top

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.

top

Valid from Date

The Valid From date indicates the first day of a date range

top

Valid to Date

The Valid To date indicates the last day of a date range

top

Post Actual

The Post Actual indicates if actual values can be posted to this element value.

top

Post Budget

The Post Budget indicates if budget values can be posted to this element value.

top

Post Encumbrance

Post commitments to this account

top

Post Statistical

Post statistical quantities to this account?

top

Is Bank Account

The Bank Account checkbox indicates if this is account is the bank account.

top

Bank Account

Foreign key column to C_BankAccount table, (column: C_BankAccount_ID)

top

Foreign Currency Account

Balances in foreign currency accounts are held in the nominated currency and translated to functional currency

top

Currency

Foreign key column to C_Currency table, (column: C_Currency_ID)

top

Element Shown

Displays this element.

top

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.

List values: C_ElementValue show value conditions

The allowed values for this list are:

top

Element Level

Indicates the level of the account (heading, account, breakdown or subaccount).

List values: C_ElementValue level

The allowed values for this list are:

top

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.

top

Related tables

Tables that link this table:

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Database_Model/org.openbravo.model.financialmgmt.accounting.coa/C_ElementValue"

This page has been accessed 5,921 times. This page was last modified on 2 July 2011, at 20:53. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.