ERP 2.50:Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting.coa/C Element
C_Element
The Element defines the Name, Description and Format for an Element. Additionally, a Type of Account or User Defined is selected. Each Account Schema must have an Account Element type. The User Defined Elements are optional.
- Name:FinancialMgmtElement
- Classname:Element
This table contains the following columns:
Name | Nullable | Data Type | Description |
C_Element_ID | N | VARCHAR2(32) | A unique identifier 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 |
Name | N | NVARCHAR2(60) | 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. |
VFormat | Y | NVARCHAR2(40) | x not implemented |
ElementType | N | VARCHAR2(60) | A distinct item characteristic used for processes and sometimes grouped within a category. |
IsBalancing | Y | CHAR(1) | All transactions within an element value must balance (e.g. cost centers) |
IsNaturalAccount | Y | CHAR(1) | The primary natural account |
AD_Tree_ID | Y | VARCHAR2(32) | Identifies a Tree |
Add2Tree_ID | Y | VARCHAR2(32) | For parallel Reporting |
Add1Tree_ID | Y | VARCHAR2(32) | For parallel Reporting |
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')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Unique
- C_ELEMENT_KEY
- C_ELEMENT_NAME
Columns
Accounting Element
The Account Element uniquely identifies an Account Type. These are commonly known as a Chart of Accounts.
- Physical column name: C_Element_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)
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
Value Format
Value Format is the format the value will be displayed with.
- Physical column name: VFormat
- Property Name: valueFormat
- Reference: String
Type
The Element Type indicates if this element is the Account element or is a User Defined element.
- Physical column name: ElementType
- Property Name: type
- Reference: List
- Default value: A
List values: C_Element Type
The allowed values for this list are:
- A (Account): Account Element
- U (User defined): User defined element
Balancing
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.
- Physical column name: IsBalancing
- Property Name: balancing
- Reference: YesNo
Natural Account
The natural account is often based on (industry specific) chart of accounts
- Physical column name: IsNaturalAccount
- Property Name: naturalAccount
- Reference: YesNo
Tree
- Physical column name: AD_Tree_ID
- Property Name: tree
- Reference: TableDir
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
Additional Tree (2)
- Physical column name: Add2Tree_ID
- Property Name: additionalTree2
- Reference: Table
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
Reference Table AD_Tree
Validation Rule AD_Tree Element Value: Only Element Value items. With the following code:
AD_Tree.TreeType='EV'
Additional Tree (1)
- Physical column name: Add1Tree_ID
- Property Name: additionalTree1
- Reference: Table
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
Reference Table AD_Tree
Validation Rule AD_Tree Element Value: Only Element Value items. With the following code:
AD_Tree.TreeType='EV'
Related tables
Tables that link this table:
- DataImportElementValue.Accounting Element
- FinancialMgmtAcctSchemaElement.Accounting Element
- FinancialMgmtElementValue.Accounting Element