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

ERP/3.0/Developers Guide/Reference/Entity Model/DataImportBusinessPartner


The import business partner is an interim table which is used when importing external data into the system

To the database table (I_BPartner) of this entity.

Back to the entity model.



Property Column Constraints Type Description
id* I_BPartner_ID Mandatory
Max Length: 32
java.lang.String The ID identifies a unique business partner to import
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.

creationDate Created java.util.Date The Created field indicates the date that this record was created.
createdBy CreatedBy ADUser The Created By field indicates the user who created this record.
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.
businessPartner C_BPartner_ID BusinessPartner A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.
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.
name2 Name2 Max Length: 60 java.lang.String Additional Name
description Description Max Length: 255 java.lang.String A description is limited to 255 characters.
dUNS DUNS Max Length: 11 java.lang.String Used for EDI - For details see
taxID TaxID Max Length: 20 java.lang.String The Tax ID field identifies the legal Identification number of this Entity.
nAICSSIC NAICS Max Length: 6 java.lang.String The NAICS/SIC identifies either of these codes that may be applicable to this Business Partner.
groupKey GroupValue Max Length: 40 java.lang.String The value of the business partner group. This value is the short name for the group. If before inserting it doesn't exists in the table C_BP_Group, it won't work
businessPartnerCategory C_BP_Group_ID BusinessPartnerCategory A way of grouping business partners together for classification and reporting purposes. Provides a method of defining certain defaults to be used when opening new business partners.
partnerAddress C_BPartner_Location_ID BusinessPartnerLocation The Partner address indicates the location of a Business Partner
addressLine1 Address1 Max Length: 60 java.lang.String The Address 1 identifies the address for an entity's location
addressLine2 Address2 Max Length: 60 java.lang.String The Address 2 provides additional address information for an entity. It can be used for building location, apartment number or similar information.
postalCode Postal Max Length: 10 java.lang.String The Postal Code field identifies the postal code for this entity's address.
postalAdd Postal_Add Max Length: 10 java.lang.String The Additional ZIP or Postal Code identifies, if appropriate, any additional Postal Code information.
cityName City Max Length: 60 java.lang.String The City identifies a unique City for this Country or Region.
region C_Region_ID Region The Region identifies a unique Region for this Country.
regionName RegionName Max Length: 60 java.lang.String The Region Name defines the name that will print when this region is used in a document.
country C_Country_ID Country The Country defines a Country. Each Country must be defined before it can be used in any document.
iSOCountryCode CountryCode Max Length: 2 java.lang.String For details - or -
position Title Max Length: 40 java.lang.String The Title indicates the name that an entity is referred to as.
contactName ContactName Max Length: 60 java.lang.String Business Partner Contact Name
contactDescription ContactDescription Max Length: 255 java.lang.String Description of Contact
comments Comments Max Length: 2000 java.lang.String The Comments field allows for free form entry of additional information.
phone Phone Max Length: 40 java.lang.String The Phone field identifies a telephone number
alternativePhone Phone2 Max Length: 40 java.lang.String The 2nd Phone field identifies an alternate telephone number.
fax Fax Max Length: 40 java.lang.String The Fax identifies a facsimile number for this Business Partner or Location
email Email Max Length: 40 java.lang.String The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g.
password Password Max Length: 20 java.lang.String The Password indicates the Password for this User Id. Passwords are required to identify authorized users.
birthday Birthday java.util.Date Birthday or Anniversary day
greeting C_Greeting_ID Greeting The Greeting identifies the greeting to print on correspondence.
bPContactGreeting BPContactGreeting Max Length: 60 java.lang.String Greeting for Business Partner Contact
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.
userContact AD_User_ID ADUser The User identifies a unique user in the system. This could be an internal user or a business partner contact
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.

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.businesspartner.Category;
import org.openbravo.model.common.businesspartner.Greeting;
import org.openbravo.model.common.businesspartner.Location;
import org.openbravo.model.common.enterprise.Organization;
import org.openbravo.model.common.geography.Country;
import org.openbravo.model.common.geography.Region;
import java.lang.Boolean;
import java.lang.String;
import java.util.Date;
 * Entity class for entity DataImportBusinessPartner (stored in table I_BPartner).
 * NOTE: This class should not be instantiated directly. To instantiate this
 * class the {@link org.openbravo.base.provider.OBProvider} should be used.
public class BusinessPartner extends BaseOBObject implements Traceable,
    ClientEnabled, OrganizationEnabled, ActiveEnabled {
    private static final long serialVersionUID = 1L;
    public static final String TABLE_NAME = "I_BPartner";
    public static final String DataImportBusinessPartner = "DataImportBusinessPartner";
    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_BUSINESSPARTNER = "businessPartner";
    public static final String PROPERTY_SEARCHKEY = "searchKey";
    public static final String PROPERTY_NAME = "name";
    public static final String PROPERTY_NAME2 = "name2";
    public static final String PROPERTY_DESCRIPTION = "description";
    public static final String PROPERTY_DUNS = "dUNS";
    public static final String PROPERTY_TAXID = "taxID";
    public static final String PROPERTY_NAICSSIC = "nAICSSIC";
    public static final String PROPERTY_GROUPKEY = "groupKey";
    public static final String PROPERTY_BUSINESSPARTNERCATEGORY =
    public static final String PROPERTY_PARTNERADDRESS = "partnerAddress";
    public static final String PROPERTY_ADDRESSLINE1 = "addressLine1";
    public static final String PROPERTY_ADDRESSLINE2 = "addressLine2";
    public static final String PROPERTY_POSTALCODE = "postalCode";
    public static final String PROPERTY_POSTALADD = "postalAdd";
    public static final String PROPERTY_CITYNAME = "cityName";
    public static final String PROPERTY_REGION = "region";
    public static final String PROPERTY_REGIONNAME = "regionName";
    public static final String PROPERTY_COUNTRY = "country";
    public static final String PROPERTY_ISOCOUNTRYCODE = "iSOCountryCode";
    public static final String PROPERTY_POSITION = "position";
    public static final String PROPERTY_CONTACTNAME = "contactName";
    public static final String PROPERTY_CONTACTDESCRIPTION =
    public static final String PROPERTY_COMMENTS = "comments";
    public static final String PROPERTY_PHONE = "phone";
    public static final String PROPERTY_ALTERNATIVEPHONE = "alternativePhone";
    public static final String PROPERTY_FAX = "fax";
    public static final String PROPERTY_EMAIL = "email";
    public static final String PROPERTY_PASSWORD = "password";
    public static final String PROPERTY_BIRTHDAY = "birthday";
    public static final String PROPERTY_GREETING = "greeting";
    public static final String PROPERTY_BPCONTACTGREETING = "bPContactGreeting";
    public static final String PROPERTY_PROCESSNOW = "processNow";
    public static final String PROPERTY_PROCESSED = "processed";
    public static final String PROPERTY_USERCONTACT = "userContact";
    public static final String PROPERTY_IMPORTERRORMESSAGE =
    public static final String PROPERTY_IMPORTPROCESSCOMPLETE =
    public BusinessPartner() {
        setDefaultValue(PROPERTY_ACTIVE, true);
        setDefaultValue(PROPERTY_PROCESSNOW, false);
        setDefaultValue(PROPERTY_PROCESSED, false);
        setDefaultValue(PROPERTY_IMPORTPROCESSCOMPLETE, false);
    public String getEntityName() {
        return DataImportBusinessPartner;
    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 org.openbravo.model.common.businesspartner.BusinessPartner getBusinessPartner() {
        return (org.openbravo.model.common.businesspartner.BusinessPartner) get(PROPERTY_BUSINESSPARTNER);
    public void setBusinessPartner(
        org.openbravo.model.common.businesspartner.BusinessPartner businessPartner) {
        set(PROPERTY_BUSINESSPARTNER, businessPartner);
    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 getName2() {
        return (String) get(PROPERTY_NAME2);
    public void setName2(String name2) {
        set(PROPERTY_NAME2, name2);
    public String getDescription() {
        return (String) get(PROPERTY_DESCRIPTION);
    public void setDescription(String description) {
        set(PROPERTY_DESCRIPTION, description);
    public String getDUNS() {
        return (String) get(PROPERTY_DUNS);
    public void setDUNS(String dUNS) {
        set(PROPERTY_DUNS, dUNS);
    public String getTaxID() {
        return (String) get(PROPERTY_TAXID);
    public void setTaxID(String taxID) {
        set(PROPERTY_TAXID, taxID);
    public String getNAICSSIC() {
        return (String) get(PROPERTY_NAICSSIC);
    public void setNAICSSIC(String nAICSSIC) {
    public String getGroupKey() {
        return (String) get(PROPERTY_GROUPKEY);
    public void setGroupKey(String groupKey) {
        set(PROPERTY_GROUPKEY, groupKey);
    public Category getBusinessPartnerCategory() {
        return (Category) get(PROPERTY_BUSINESSPARTNERCATEGORY);
    public void setBusinessPartnerCategory(Category businessPartnerCategory) {
        set(PROPERTY_BUSINESSPARTNERCATEGORY, businessPartnerCategory);
    public Location getPartnerAddress() {
        return (Location) get(PROPERTY_PARTNERADDRESS);
    public void setPartnerAddress(Location partnerAddress) {
        set(PROPERTY_PARTNERADDRESS, partnerAddress);
    public String getAddressLine1() {
        return (String) get(PROPERTY_ADDRESSLINE1);
    public void setAddressLine1(String addressLine1) {
        set(PROPERTY_ADDRESSLINE1, addressLine1);
    public String getAddressLine2() {
        return (String) get(PROPERTY_ADDRESSLINE2);
    public void setAddressLine2(String addressLine2) {
        set(PROPERTY_ADDRESSLINE2, addressLine2);
    public String getPostalCode() {
        return (String) get(PROPERTY_POSTALCODE);
    public void setPostalCode(String postalCode) {
        set(PROPERTY_POSTALCODE, postalCode);
    public String getPostalAdd() {
        return (String) get(PROPERTY_POSTALADD);
    public void setPostalAdd(String postalAdd) {
        set(PROPERTY_POSTALADD, postalAdd);
    public String getCityName() {
        return (String) get(PROPERTY_CITYNAME);
    public void setCityName(String cityName) {
        set(PROPERTY_CITYNAME, cityName);
    public Region getRegion() {
        return (Region) get(PROPERTY_REGION);
    public void setRegion(Region region) {
        set(PROPERTY_REGION, region);
    public String getRegionName() {
        return (String) get(PROPERTY_REGIONNAME);
    public void setRegionName(String regionName) {
        set(PROPERTY_REGIONNAME, regionName);
    public Country getCountry() {
        return (Country) get(PROPERTY_COUNTRY);
    public void setCountry(Country country) {
        set(PROPERTY_COUNTRY, country);
    public String getISOCountryCode() {
        return (String) get(PROPERTY_ISOCOUNTRYCODE);
    public void setISOCountryCode(String iSOCountryCode) {
        set(PROPERTY_ISOCOUNTRYCODE, iSOCountryCode);
    public String getPosition() {
        return (String) get(PROPERTY_POSITION);
    public void setPosition(String position) {
        set(PROPERTY_POSITION, position);
    public String getContactName() {
        return (String) get(PROPERTY_CONTACTNAME);
    public void setContactName(String contactName) {
        set(PROPERTY_CONTACTNAME, contactName);
    public String getContactDescription() {
        return (String) get(PROPERTY_CONTACTDESCRIPTION);
    public void setContactDescription(String contactDescription) {
        set(PROPERTY_CONTACTDESCRIPTION, contactDescription);
    public String getComments() {
        return (String) get(PROPERTY_COMMENTS);
    public void setComments(String comments) {
        set(PROPERTY_COMMENTS, comments);
    public String getPhone() {
        return (String) get(PROPERTY_PHONE);
    public void setPhone(String phone) {
        set(PROPERTY_PHONE, phone);
    public String getAlternativePhone() {
        return (String) get(PROPERTY_ALTERNATIVEPHONE);
    public void setAlternativePhone(String alternativePhone) {
        set(PROPERTY_ALTERNATIVEPHONE, alternativePhone);
    public String getFax() {
        return (String) get(PROPERTY_FAX);
    public void setFax(String fax) {
        set(PROPERTY_FAX, fax);
    public String getEmail() {
        return (String) get(PROPERTY_EMAIL);
    public void setEmail(String email) {
        set(PROPERTY_EMAIL, email);
    public String getPassword() {
        return (String) get(PROPERTY_PASSWORD);
    public void setPassword(String password) {
        set(PROPERTY_PASSWORD, password);
    public Date getBirthday() {
        return (Date) get(PROPERTY_BIRTHDAY);
    public void setBirthday(Date birthday) {
        set(PROPERTY_BIRTHDAY, birthday);
    public Greeting getGreeting() {
        return (Greeting) get(PROPERTY_GREETING);
    public void setGreeting(Greeting greeting) {
        set(PROPERTY_GREETING, greeting);
    public String getBPContactGreeting() {
        return (String) get(PROPERTY_BPCONTACTGREETING);
    public void setBPContactGreeting(String bPContactGreeting) {
        set(PROPERTY_BPCONTACTGREETING, bPContactGreeting);
    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 User getUserContact() {
        return (User) get(PROPERTY_USERCONTACT);
    public void setUserContact(User userContact) {
        set(PROPERTY_USERCONTACT, userContact);
    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);

Retrieved from ""

This page has been accessed 846 times. This page was last modified on 15 April 2011, at 22:12. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.