ERP 2.50:Developers Guide/Reference/Entity Model/DataImportElementValue
DataImportElementValue
This process imports the accounting accounts tree into the organization
To the database table (I_ElementValue) of this entity.
Properties
Note:
- Properties marked with a * are part of the Id of the Entity.
- Properties marked with a # are part of the Identifier of the Entity.
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 http://www.openbravo.com/legal/license.html * 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.ad.access.User; import org.openbravo.model.ad.datamodel.Column; import org.openbravo.model.ad.system.Client; 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 = "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 = "importErrorMessage"; public static final String PROPERTY_IMPORTPROCESSCOMPLETE = "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); } @Override 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); } }