ERP/3.0/Developers Guide/Reference/Entity Model/DataImportBusinessPartner
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.
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_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 www.dnb.com/dunsno/list.htm |
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 - http://www.din.de/gremien/nas/nabd/iso3166ma/codlstp1.html or - http://www.unece.org/trade/rec/rec03en.htm |
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 |
Max Length: 40 | java.lang.String | The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com). | ||
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 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.system.Client; 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 = "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 = "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 = "importErrorMessage"; public static final String PROPERTY_IMPORTPROCESSCOMPLETE = "importProcessComplete"; public BusinessPartner() { setDefaultValue(PROPERTY_ACTIVE, true); setDefaultValue(PROPERTY_PROCESSNOW, false); setDefaultValue(PROPERTY_PROCESSED, false); setDefaultValue(PROPERTY_IMPORTPROCESSCOMPLETE, false); } @Override 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) { set(PROPERTY_NAICSSIC, 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); } }