ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting.coa/C Element
C_Element
- Name:C_Element
- Classname:FinancialMgmtElement
This table contains the following columns:
Name | Nullable | Data Type | Description
|
C_Element_ID | No | VARCHAR (32) | The Account Tree uniquely identifies the Account Tree, also known as Chart of Accounts, linked to the Accounting Schema. |
IsActive | No | 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. |
Add1Tree_ID | Yes | VARCHAR (32) | The Additional Tree is used to define alternate roll ups which can be used in reporting. For example, you may have a Business Partner Tree which rolls up based on geographic location and an additional tree which rolls up based on industry. |
Add2Tree_ID | Yes | VARCHAR (32) | The Additional Tree is used to define alternate roll ups which can be used in reporting. For example, you may have a Business Partner Tree which rolls up based on geographic location and an additional tree which rolls up based on industry. |
IsBalancing | Yes | CHAR (1) | The Balancing checkbox indicates the this element must balance in each journal transaction. For example, if cost centers have been defined as an element which is balance then the debits and credits for each unique cost center must net to 0.00. This is commonly used to define parts of an organization which report as their own entity. Balancing is not an option for the Account element. |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
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. |
Description | Yes | NVARCHAR (255) | A description is limited to 255 characters. |
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. |
IsNaturalAccount | Yes | CHAR (1) | The natural account is often based on (industry specific) chart of accounts |
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. |
AD_Tree_ID | No | VARCHAR (32) | The Tree field identifies a unique Tree in the system. Trees define roll ups or summary levels of information. They are used in reports for defining report points and summarization levels. |
ElementType | No | VARCHAR (60) | The Element Type indicates if this element is the Account element or is a User Defined element. |
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. |
VFormat | Yes | NVARCHAR (40) | Value Format is the format the value will be displayed with. |
Columns
Accounting Element
- Physical column name: C_Element_ID
- Property Name: id
- Reference: ID
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Additional Tree (1)
- Physical column name: Add1Tree_ID
- Property Name: additionalTree1
- Reference: Table
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
It has a validation "AD_Tree Element Value", with the following code
AD_Tree.TreeType='EV'
Additional Tree (2)
- Physical column name: Add2Tree_ID
- Property Name: additionalTree2
- Reference: Table
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
It has a validation "AD_Tree Element Value", with the following code
AD_Tree.TreeType='EV'
Balancing
- Physical column name: IsBalancing
- Property Name: balancing
- Reference: YesNo
- Default value: N
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_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
Description
- Physical column name: Description
- Property Name: description
- Reference: String
Name
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Natural Account
- Physical column name: IsNaturalAccount
- Property Name: naturalAccount
- Reference: YesNo
- Default value: Y
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Tree
- Physical column name: AD_Tree_ID
- Property Name: tree
- Reference: TableDir
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
It has a validation "AD_TreeClientValidation", with the following code
AD_Tree.AD_Client_ID = @AD_Client_ID@ and AD_Tree.TreeType = 'EV'
Type
- Physical column name: ElementType
- Property Name: type
- Reference: List
List values: C_Element Type
The allowed values for this list are:
- A (Account): Account Element
- U (User defined): User defined element
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)
Value Format
- Physical column name: VFormat
- Property Name: valueFormat
- Reference: String
Other Info
Check Constraints
These are the check constraints for this table:
- C_ELEMENT_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- C_ELEMENT_ISBALANCING_CHECK: ISBALANCING IN ('Y', 'N')
- C_ELEMENT_ISNATURALACCOUNT_CHK: ISNATURALACCOUNT IN ('Y', 'N')