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

ERP/2.50/Developers Guide/Reference/Entity Model/DataImportElementValue


This process imports the accounting accounts tree into the organization

To the database table (I_ElementValue) of this entity.

Back to the entity model.



Property Column Constraints Type Description
id* I_ElementValue_ID Mandatory
Max Length: 32
java.lang.String Import Account Value
client AD_Client_ID ADClient A Client is a company or a legal entity. You cannot share data between Clients.
organization AD_Org_ID Organization An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
active IsActive java.lang.Boolean 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.

createdBy CreatedBy ADUser The Created By field indicates the user who created this record.
creationDate Created java.util.Date The Created field indicates the date that this record was created.
updated Updated java.util.Date The Updated field indicates the date that this record was updated.
updatedBy UpdatedBy ADUser The Updated By field indicates the user who updated this record.
accountingElement C_Element_ID FinancialMgmtElement The Account Element uniquely identifies an Account Type. These are commonly known as a Chart of Accounts.
elementName ElementName Max Length: 60 java.lang.String Name of the Element
accountElement C_ElementValue_ID FinancialMgmtElementValue Account Elements can be natural accounts or user defined values.
searchKey# Value Max Length: 40 java.lang.String 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.

name Name Max Length: 60 java.lang.String 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.
description Description Max Length: 255 java.lang.String A description is limited to 255 characters.
accountType AccountType Max Length: 60 java.lang.String 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
accountSign AccountSign Max Length: 60 java.lang.String Indicates if the expected balance for this account should be a Debit or a Credit.
documentControlled IsDocControlled java.lang.Boolean Control account - If an account is controlled by a document, you cannot post manually to it
summaryLevel IsSummary java.lang.Boolean 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.
parentKey ParentValue Max Length: 40 java.lang.String Key if the Parent
parentAccount ParentElementValue_ID FinancialMgmtElementValue The parent (summary) account
postActual PostActual java.lang.Boolean The Post Actual indicates if actual values can be posted to this element value.
postBudget PostBudget java.lang.Boolean The Post Budget indicates if budget values can be posted to this element value.
postStatistical PostStatistical java.lang.Boolean Post statistical quantities to this account?
postEncumbrance PostEncumbrance java.lang.Boolean Post commitments to this account
defaultAccount Default_Account Max Length: 30 java.lang.String Name of the Default Account Column
column AD_Column_ID ADColumn Link to the database column of the table
processNow Processing java.lang.Boolean When this field is set as 'Y' a process is being performed on this record.
processed Processed java.lang.Boolean The Processed checkbox indicates that a document has been processed.
importErrorMessage I_ErrorMsg Max Length: 2000 java.lang.String The Import Error Message displays any error messages generated during the import process.
importProcessComplete I_IsImported java.lang.Boolean The Imported check box indicates if this import has been processed.
elementLevel Elementlevel Max Length: 60 java.lang.String Indicates the level of the account (heading, account, breakdown or subaccount).
operands Operands Max Length: 1000 java.lang.String
sequenceNumber Seqno java.lang.Long The Sequence indicates the order of records

Java Entity Class

 * The contents of this file are subject to the Openbravo  Public  License
 * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
 * Version 1.1  with a permitted attribution clause; you may not  use this
 * file except in compliance with the License. You  may  obtain  a copy of
 * the License at
 * Software distributed under the License  is  distributed  on  an "AS IS"
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
 * License for the specific  language  governing  rights  and  limitations
 * under the License.
 * The Original Code is Openbravo ERP.
 * The Initial Developer of the Original Code is Openbravo SLU
 * All portions are Copyright (C) 2008-2010 Openbravo SLU
 * All Rights Reserved.
 * Contributor(s):  ______________________________________.
package org.openbravo.model.dataimport;
import org.openbravo.base.structure.ActiveEnabled;
import org.openbravo.base.structure.BaseOBObject;
import org.openbravo.base.structure.ClientEnabled;
import org.openbravo.base.structure.OrganizationEnabled;
import org.openbravo.base.structure.Traceable;
import org.openbravo.model.common.enterprise.Organization;
import org.openbravo.model.financialmgmt.accounting.coa.Element;
import java.lang.Boolean;
import java.lang.Long;
import java.lang.String;
import java.util.Date;
 * Entity class for entity DataImportElementValue (stored in table I_ElementValue).
 * NOTE: This class should not be instantiated directly. To instantiate this
 * class the {@link org.openbravo.base.provider.OBProvider} should be used.
public class ElementValue extends BaseOBObject implements Traceable,
    ClientEnabled, OrganizationEnabled, ActiveEnabled {
    private static final long serialVersionUID = 1L;
    public static final String TABLE_NAME = "I_ElementValue";
    public static final String DataImportElementValue = "DataImportElementValue";
    public static final String PROPERTY_ID = "id";
    public static final String PROPERTY_CLIENT = "client";
    public static final String PROPERTY_ORGANIZATION = "organization";
    public static final String PROPERTY_ACTIVE = "active";
    public static final String PROPERTY_CREATEDBY = "createdBy";
    public static final String PROPERTY_CREATIONDATE = "creationDate";
    public static final String PROPERTY_UPDATED = "updated";
    public static final String PROPERTY_UPDATEDBY = "updatedBy";
    public static final String PROPERTY_ACCOUNTINGELEMENT = "accountingElement";
    public static final String PROPERTY_ELEMENTNAME = "elementName";
    public static final String PROPERTY_ACCOUNTELEMENT = "accountElement";
    public static final String PROPERTY_SEARCHKEY = "searchKey";
    public static final String PROPERTY_NAME = "name";
    public static final String PROPERTY_DESCRIPTION = "description";
    public static final String PROPERTY_ACCOUNTTYPE = "accountType";
    public static final String PROPERTY_ACCOUNTSIGN = "accountSign";
    public static final String PROPERTY_DOCUMENTCONTROLLED =
    public static final String PROPERTY_SUMMARYLEVEL = "summaryLevel";
    public static final String PROPERTY_PARENTKEY = "parentKey";
    public static final String PROPERTY_PARENTACCOUNT = "parentAccount";
    public static final String PROPERTY_POSTACTUAL = "postActual";
    public static final String PROPERTY_POSTBUDGET = "postBudget";
    public static final String PROPERTY_POSTSTATISTICAL = "postStatistical";
    public static final String PROPERTY_POSTENCUMBRANCE = "postEncumbrance";
    public static final String PROPERTY_DEFAULTACCOUNT = "defaultAccount";
    public static final String PROPERTY_COLUMN = "column";
    public static final String PROPERTY_PROCESSNOW = "processNow";
    public static final String PROPERTY_PROCESSED = "processed";
    public static final String PROPERTY_IMPORTERRORMESSAGE =
    public static final String PROPERTY_IMPORTPROCESSCOMPLETE =
    public static final String PROPERTY_ELEMENTLEVEL = "elementLevel";
    public static final String PROPERTY_OPERANDS = "operands";
    public static final String PROPERTY_SEQUENCENUMBER = "sequenceNumber";
    public ElementValue() {
        setDefaultValue(PROPERTY_ACTIVE, true);
        setDefaultValue(PROPERTY_DOCUMENTCONTROLLED, false);
        setDefaultValue(PROPERTY_SUMMARYLEVEL, false);
        setDefaultValue(PROPERTY_POSTACTUAL, false);
        setDefaultValue(PROPERTY_POSTBUDGET, false);
        setDefaultValue(PROPERTY_POSTSTATISTICAL, false);
        setDefaultValue(PROPERTY_POSTENCUMBRANCE, false);
        setDefaultValue(PROPERTY_PROCESSNOW, false);
        setDefaultValue(PROPERTY_PROCESSED, false);
        setDefaultValue(PROPERTY_IMPORTPROCESSCOMPLETE, false);
    public String getEntityName() {
        return DataImportElementValue;
    public String getId() {
        return (String) get(PROPERTY_ID);
    public void setId(String id) {
        set(PROPERTY_ID, id);
    public Client getClient() {
        return (Client) get(PROPERTY_CLIENT);
    public void setClient(Client client) {
        set(PROPERTY_CLIENT, client);
    public Organization getOrganization() {
        return (Organization) get(PROPERTY_ORGANIZATION);
    public void setOrganization(Organization organization) {
        set(PROPERTY_ORGANIZATION, organization);
    public Boolean isActive() {
        return (Boolean) get(PROPERTY_ACTIVE);
    public void setActive(Boolean active) {
        set(PROPERTY_ACTIVE, active);
    public User getCreatedBy() {
        return (User) get(PROPERTY_CREATEDBY);
    public void setCreatedBy(User createdBy) {
        set(PROPERTY_CREATEDBY, createdBy);
    public Date getCreationDate() {
        return (Date) get(PROPERTY_CREATIONDATE);
    public void setCreationDate(Date creationDate) {
        set(PROPERTY_CREATIONDATE, creationDate);
    public Date getUpdated() {
        return (Date) get(PROPERTY_UPDATED);
    public void setUpdated(Date updated) {
        set(PROPERTY_UPDATED, updated);
    public User getUpdatedBy() {
        return (User) get(PROPERTY_UPDATEDBY);
    public void setUpdatedBy(User updatedBy) {
        set(PROPERTY_UPDATEDBY, updatedBy);
    public Element getAccountingElement() {
        return (Element) get(PROPERTY_ACCOUNTINGELEMENT);
    public void setAccountingElement(Element accountingElement) {
        set(PROPERTY_ACCOUNTINGELEMENT, accountingElement);
    public String getElementName() {
        return (String) get(PROPERTY_ELEMENTNAME);
    public void setElementName(String elementName) {
        set(PROPERTY_ELEMENTNAME, elementName);
    public org.openbravo.model.financialmgmt.accounting.coa.ElementValue getAccountElement() {
        return (org.openbravo.model.financialmgmt.accounting.coa.ElementValue) get(PROPERTY_ACCOUNTELEMENT);
    public void setAccountElement(
        org.openbravo.model.financialmgmt.accounting.coa.ElementValue accountElement) {
        set(PROPERTY_ACCOUNTELEMENT, accountElement);
    public String getSearchKey() {
        return (String) get(PROPERTY_SEARCHKEY);
    public void setSearchKey(String searchKey) {
        set(PROPERTY_SEARCHKEY, searchKey);
    public String getName() {
        return (String) get(PROPERTY_NAME);
    public void setName(String name) {
        set(PROPERTY_NAME, name);
    public String getDescription() {
        return (String) get(PROPERTY_DESCRIPTION);
    public void setDescription(String description) {
        set(PROPERTY_DESCRIPTION, description);
    public String getAccountType() {
        return (String) get(PROPERTY_ACCOUNTTYPE);
    public void setAccountType(String accountType) {
        set(PROPERTY_ACCOUNTTYPE, accountType);
    public String getAccountSign() {
        return (String) get(PROPERTY_ACCOUNTSIGN);
    public void setAccountSign(String accountSign) {
        set(PROPERTY_ACCOUNTSIGN, accountSign);
    public Boolean isDocumentControlled() {
        return (Boolean) get(PROPERTY_DOCUMENTCONTROLLED);
    public void setDocumentControlled(Boolean documentControlled) {
        set(PROPERTY_DOCUMENTCONTROLLED, documentControlled);
    public Boolean isSummaryLevel() {
        return (Boolean) get(PROPERTY_SUMMARYLEVEL);
    public void setSummaryLevel(Boolean summaryLevel) {
        set(PROPERTY_SUMMARYLEVEL, summaryLevel);
    public String getParentKey() {
        return (String) get(PROPERTY_PARENTKEY);
    public void setParentKey(String parentKey) {
        set(PROPERTY_PARENTKEY, parentKey);
    public org.openbravo.model.financialmgmt.accounting.coa.ElementValue getParentAccount() {
        return (org.openbravo.model.financialmgmt.accounting.coa.ElementValue) get(PROPERTY_PARENTACCOUNT);
    public void setParentAccount(
        org.openbravo.model.financialmgmt.accounting.coa.ElementValue parentAccount) {
        set(PROPERTY_PARENTACCOUNT, parentAccount);
    public Boolean isPostActual() {
        return (Boolean) get(PROPERTY_POSTACTUAL);
    public void setPostActual(Boolean postActual) {
        set(PROPERTY_POSTACTUAL, postActual);
    public Boolean isPostBudget() {
        return (Boolean) get(PROPERTY_POSTBUDGET);
    public void setPostBudget(Boolean postBudget) {
        set(PROPERTY_POSTBUDGET, postBudget);
    public Boolean isPostStatistical() {
        return (Boolean) get(PROPERTY_POSTSTATISTICAL);
    public void setPostStatistical(Boolean postStatistical) {
        set(PROPERTY_POSTSTATISTICAL, postStatistical);
    public Boolean isPostEncumbrance() {
        return (Boolean) get(PROPERTY_POSTENCUMBRANCE);
    public void setPostEncumbrance(Boolean postEncumbrance) {
        set(PROPERTY_POSTENCUMBRANCE, postEncumbrance);
    public String getDefaultAccount() {
        return (String) get(PROPERTY_DEFAULTACCOUNT);
    public void setDefaultAccount(String defaultAccount) {
        set(PROPERTY_DEFAULTACCOUNT, defaultAccount);
    public Column getColumn() {
        return (Column) get(PROPERTY_COLUMN);
    public void setColumn(Column column) {
        set(PROPERTY_COLUMN, column);
    public Boolean isProcessNow() {
        return (Boolean) get(PROPERTY_PROCESSNOW);
    public void setProcessNow(Boolean processNow) {
        set(PROPERTY_PROCESSNOW, processNow);
    public Boolean isProcessed() {
        return (Boolean) get(PROPERTY_PROCESSED);
    public void setProcessed(Boolean processed) {
        set(PROPERTY_PROCESSED, processed);
    public String getImportErrorMessage() {
        return (String) get(PROPERTY_IMPORTERRORMESSAGE);
    public void setImportErrorMessage(String importErrorMessage) {
        set(PROPERTY_IMPORTERRORMESSAGE, importErrorMessage);
    public Boolean isImportProcessComplete() {
        return (Boolean) get(PROPERTY_IMPORTPROCESSCOMPLETE);
    public void setImportProcessComplete(Boolean importProcessComplete) {
        set(PROPERTY_IMPORTPROCESSCOMPLETE, importProcessComplete);
    public String getElementLevel() {
        return (String) get(PROPERTY_ELEMENTLEVEL);
    public void setElementLevel(String elementLevel) {
        set(PROPERTY_ELEMENTLEVEL, elementLevel);
    public String getOperands() {
        return (String) get(PROPERTY_OPERANDS);
    public void setOperands(String operands) {
        set(PROPERTY_OPERANDS, operands);
    public Long getSequenceNumber() {
        return (Long) get(PROPERTY_SEQUENCENUMBER);
    public void setSequenceNumber(Long sequenceNumber) {
        set(PROPERTY_SEQUENCENUMBER, sequenceNumber);

Retrieved from ""

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