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

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.dataimport/I ElementValue

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.dataimport

Index

Contents

I_ElementValue

This process imports the accounting accounts tree into the organization

This table contains the following columns:

Name Nullable Data Type Description
I_ElementValue_ID NVARCHAR2(32)Import Account Value
AD_Client_ID YVARCHAR2(32)Client for this installation.
AD_Org_ID YVARCHAR2(32)Organizational entity within client
IsActive YCHAR(1)A flag indicating whether this record is available for use or de-activated.
CreatedBy YVARCHAR2(32)User who created this records
Created YDATEThe date that this record is completed.
Updated YDATEx not implemented
UpdatedBy YVARCHAR2(32)User who updated this records
C_Element_ID YVARCHAR2(32)A unique identifier for an account type.
ElementName YNVARCHAR2(60)Name of the Element
C_ElementValue_ID YVARCHAR2(32)A identification code for an account type.
Value YNVARCHAR2(40)A fast method for finding a particular record.
Name YNVARCHAR2(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 YVARCHAR2(60)Indicates the type of account
AccountSign YVARCHAR2(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
IsSummary YCHAR(1)A means of grouping fields in order to view or hide additional information.
ParentValue YNVARCHAR2(40)Key if the Parent
ParentElementValue_ID YVARCHAR2(32)The parent (summary) account
PostActual YCHAR(1)Actual Values can be posted
PostBudget YCHAR(1)Budget values can be posted
PostStatistical YCHAR(1)Post statistical quantities to this account?
PostEncumbrance YCHAR(1)Post commitments to this account
Default_Account YNVARCHAR2(30)Name of the Default Account Column
AD_Column_ID YVARCHAR2(32)A link to the database column of the table.
Processing YCHAR(1)A request to process the respective document or task.
Processed YCHAR(1)A confirmation that the associated documents or requests are processed.
I_ErrorMsg YNVARCHAR2(2000)A message that appears when errors occur during the importing process.
I_IsImported YCHAR(1)A indication that the desired process has been completed successfully.
Elementlevel YVARCHAR2(60)Element Level
Operands YNVARCHAR2(1000)null
Seqno YNUMBER(10, 0)The order of records in a specified document.

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):

Unique

top

Columns

Import Account

Import Account Value

top

Client

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@)

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

Created By

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

top

Creation Date

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

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

Accounting Element

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

top

Element Name

Name of the Element

top

Account Element

Foreign key column to C_ElementValue table, (column: C_ElementValue_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

top

Account Sign

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

top

Document Controlled

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

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

Parent Key

Key if the Parent

top

Parent Account

Foreign key column to C_ElementValue table, (column: C_ElementValue_ID)


Reference Table C_ElementValue (Parents) With the following where clause:

 
C_ElementValue.IsSummary='Y'


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 Statistical

Post statistical quantities to this account?

top

Post Encumbrance

Post commitments to this account

top

Default Account

Name of the Default Account Column

top

Column

Foreign key column to AD_Column table, (column: AD_Column_ID)


Reference Table I_ElementValue Column With the following where clause:

 
AD_Column.AD_Table_ID IN ('315','266') AND AD_Column.AD_Reference_ID='25'


top

Process Now

When this field is set as 'Y' a process is being performed on this record.

top

Processed

The Processed checkbox indicates that a document has been processed.

top

Import Error Message

The Import Error Message displays any error messages generated during the import process.

top

Import Process Complete

The Imported check box indicates if this import has been processed.

top

Element Level

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

top

Operands

top

Sequence Number

The Sequence indicates the order of records

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.dataimport/I_ElementValue"

This page has been accessed 3,105 times. This page was last modified on 14 June 2011, at 11:04. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.