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

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


Define the individual field based on the table definition. Please note that you have to make sure that a Constant has the correct SQL data type (i.e. if it is a 'string', you need to enclose it like 'this')

To the database table (AD_ImpFormat_Row) of this entity.

Back to the entity model.



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

creationDate Created Mandatory java.util.Date The Created field indicates the date that this record was created.
createdBy CreatedBy Mandatory ADUser The Created By field indicates the user who created this record.
updated Updated Mandatory java.util.Date The Updated field indicates the date that this record was updated.
updatedBy UpdatedBy Mandatory ADUser The Updated By field indicates the user who updated this record.
importFormat AD_ImpFormat_ID Mandatory DataImportFormat The ID identifies a unique import format
sequenceNumber SeqNo Mandatory java.lang.Long The Sequence indicates the order of records
name# Name Mandatory
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.
column AD_Column_ID Mandatory ADColumn Link to the database column of the table
startingNo StartNo java.lang.Long The Start Number indicates the starting position in the line or field number in the line
endNo EndNo java.lang.Long
dataType DataType Mandatory
Max Length: 60
java.lang.String Type of data
dataFormat DataFormat Max Length: 20 java.lang.String The Date Format indicates how dates are defined on the record to be imported. It must be in Java Notation
decimalPoint DecimalPoint Mandatory
Max Length: 1
java.lang.String Decimal Point in the data file
divideBy100 DivideBy100 Mandatory java.lang.Boolean Divide number by 100 to get correct amount
constantValue ConstantValue Max Length: 60 java.lang.String Constant value
calloutFunction Callout Max Length: 60 java.lang.String Function Calls separated by semicolons; SE_/SL_/UE_/UL_ - 1st: System/User; 2nd: Enter/Leave; 3rd: _ Underscore, - then Function Name
script Script Max Length: 2000 java.lang.String Use Java language constructs to define the result of the calculation

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 java.lang.Boolean;
import java.lang.Long;
import java.lang.String;
import java.util.Date;
 * Entity class for entity DataImportFormatRow (stored in table AD_ImpFormat_Row).
 * NOTE: This class should not be instantiated directly. To instantiate this
 * class the {@link org.openbravo.base.provider.OBProvider} should be used.
public class ImportFormatRow extends BaseOBObject implements Traceable,
    ClientEnabled, OrganizationEnabled, ActiveEnabled {
    private static final long serialVersionUID = 1L;
    public static final String TABLE_NAME = "AD_ImpFormat_Row";
    public static final String DataImportFormatRow = "DataImportFormatRow";
    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_CREATIONDATE = "creationDate";
    public static final String PROPERTY_CREATEDBY = "createdBy";
    public static final String PROPERTY_UPDATED = "updated";
    public static final String PROPERTY_UPDATEDBY = "updatedBy";
    public static final String PROPERTY_IMPORTFORMAT = "importFormat";
    public static final String PROPERTY_SEQUENCENUMBER = "sequenceNumber";
    public static final String PROPERTY_NAME = "name";
    public static final String PROPERTY_COLUMN = "column";
    public static final String PROPERTY_STARTINGNO = "startingNo";
    public static final String PROPERTY_ENDNO = "endNo";
    public static final String PROPERTY_DATATYPE = "dataType";
    public static final String PROPERTY_DATAFORMAT = "dataFormat";
    public static final String PROPERTY_DECIMALPOINT = "decimalPoint";
    public static final String PROPERTY_DIVIDEBY100 = "divideBy100";
    public static final String PROPERTY_CONSTANTVALUE = "constantValue";
    public static final String PROPERTY_CALLOUTFUNCTION = "calloutFunction";
    public static final String PROPERTY_SCRIPT = "script";
    public ImportFormatRow() {
        setDefaultValue(PROPERTY_ACTIVE, true);
        setDefaultValue(PROPERTY_DECIMALPOINT, ".");
        setDefaultValue(PROPERTY_DIVIDEBY100, false);
    public String getEntityName() {
        return DataImportFormatRow;
    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 Date getCreationDate() {
        return (Date) get(PROPERTY_CREATIONDATE);
    public void setCreationDate(Date creationDate) {
        set(PROPERTY_CREATIONDATE, creationDate);
    public User getCreatedBy() {
        return (User) get(PROPERTY_CREATEDBY);
    public void setCreatedBy(User createdBy) {
        set(PROPERTY_CREATEDBY, createdBy);
    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 ImportFormat getImportFormat() {
        return (ImportFormat) get(PROPERTY_IMPORTFORMAT);
    public void setImportFormat(ImportFormat importFormat) {
        set(PROPERTY_IMPORTFORMAT, importFormat);
    public Long getSequenceNumber() {
        return (Long) get(PROPERTY_SEQUENCENUMBER);
    public void setSequenceNumber(Long sequenceNumber) {
        set(PROPERTY_SEQUENCENUMBER, sequenceNumber);
    public String getName() {
        return (String) get(PROPERTY_NAME);
    public void setName(String name) {
        set(PROPERTY_NAME, name);
    public Column getColumn() {
        return (Column) get(PROPERTY_COLUMN);
    public void setColumn(Column column) {
        set(PROPERTY_COLUMN, column);
    public Long getStartingNo() {
        return (Long) get(PROPERTY_STARTINGNO);
    public void setStartingNo(Long startingNo) {
        set(PROPERTY_STARTINGNO, startingNo);
    public Long getEndNo() {
        return (Long) get(PROPERTY_ENDNO);
    public void setEndNo(Long endNo) {
        set(PROPERTY_ENDNO, endNo);
    public String getDataType() {
        return (String) get(PROPERTY_DATATYPE);
    public void setDataType(String dataType) {
        set(PROPERTY_DATATYPE, dataType);
    public String getDataFormat() {
        return (String) get(PROPERTY_DATAFORMAT);
    public void setDataFormat(String dataFormat) {
        set(PROPERTY_DATAFORMAT, dataFormat);
    public String getDecimalPoint() {
        return (String) get(PROPERTY_DECIMALPOINT);
    public void setDecimalPoint(String decimalPoint) {
        set(PROPERTY_DECIMALPOINT, decimalPoint);
    public Boolean isDivideBy100() {
        return (Boolean) get(PROPERTY_DIVIDEBY100);
    public void setDivideBy100(Boolean divideBy100) {
        set(PROPERTY_DIVIDEBY100, divideBy100);
    public String getConstantValue() {
        return (String) get(PROPERTY_CONSTANTVALUE);
    public void setConstantValue(String constantValue) {
        set(PROPERTY_CONSTANTVALUE, constantValue);
    public String getCalloutFunction() {
        return (String) get(PROPERTY_CALLOUTFUNCTION);
    public void setCalloutFunction(String calloutFunction) {
        set(PROPERTY_CALLOUTFUNCTION, calloutFunction);
    public String getScript() {
        return (String) get(PROPERTY_SCRIPT);
    public void setScript(String script) {
        set(PROPERTY_SCRIPT, script);

Retrieved from ""

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