ManPageW ImportBusinessPartner
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Window: Import Business Partner
Description : Import Business Partner
Help : The Import Business Partner Window is an interim table which is used when importing external data into the system. Selecting the large 'Import Business Partner' button at the bottom of the screen will either add or modify the appropriate records. The button is only visible on form view, not grid view, and will import all records.
If the import fails, the Import Error Message field at the top of the screen may have the reason, for example ERR=Invalid Country,
All Business Partner records must have a country column.
Tab: Import Business Partner
Description :
Help :
Table Name : I_BPartner
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Import Business Partner | I_BPartner_ID
NUMBER(10) ID | ||
Imported | Has this import been processed | The Imported check box indicates if this import has been processed. | I_IsImported
CHAR(1) YesNo |
Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_BPartner_ID
NUMBER(10) Search |
Import Error Message | Messages generated from import process | The Import Error Message displays any error messages generated during the import process. | I_ErrorMsg
NVARCHAR2(2000) String |
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Search Key | Search key for the record in the format required - must be unique | A search key allows you a fast method of finding a particular record.
If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order). |
Value
NVARCHAR2(40) String |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Name 2 | Additional Name | Name2
NVARCHAR2(60) String | |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
D-U-N-S | Dun & Bradstreet Number | Used for EDI - For details see www.dnb.com/dunsno/list.htm | DUNS
CHAR(11) String |
NAICS/SIC | Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html | The NAICS/SIC identifies either of these codes that may be applicable to this Business Partner. | NAICS
CHAR(6) String |
Tax ID | Tax Identification | The Tax ID field identifies the legal Identification number of this Entity. | TaxID
VARCHAR2 String |
Group Key | Business Partner Group Key | GroupValue
NVARCHAR2(40) String | |
Business Partner Group | Business Partner Group | The Business Partner Group provides a method of defining defaults to be used for individual Business Partners. | C_BP_Group_ID
NUMBER(10) TableDir |
Partner Location | Identifies the (ship to) address for this Business Partner | The Partner address indicates the location of a Business Partner | C_BPartner_Location_ID
NUMBER(10) TableDir |
Address 1 | Address line 1 for this location | The Address 1 identifies the address for an entity's location | Address1
NVARCHAR2(60) String |
Address 2 | Address line 2 for this location | The Address 2 provides additional address information for an entity. It can be used for building location, apartment number or similar information. | Address2
NVARCHAR2(60) String |
ZIP | Postal code | The Postal Code or ZIP identifies the postal code for this entity's address. | Postal
VARCHAR2 String |
- | Additional ZIP or Postal code | The Additional ZIP or Postal Code identifies, if appropriate, any additional Postal Code information. | Postal_Add
VARCHAR2 String |
City | Identifies a City | The City identifies a unique City for this Country or Region. | City
NVARCHAR2(60) String |
Region | Name of the Region | The Region Name defines the name that will print when this region is used in a document. | RegionName
NVARCHAR2(60) String |
Region | Identifies a geographical Region | The Region identifies a unique Region for this Country. | C_Region_ID
NUMBER(10) TableDir |
ISO Country Code | Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html | For details - http://www.din.de/gremien/nas/nabd/iso3166ma/codlstp1.html or - http://www.unece.org/trade/rec/rec03en.htm | CountryCode
CHAR(2) String |
Country | Country | The Country defines a Country. Each Country must be defined before it can be used in any document. | C_Country_ID
NUMBER(10) TableDir |
User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | AD_User_ID
NUMBER(10) TableDir |
Title | Name this entity is referred to as | The Title indicates the name that an entity is referred to as. | Title
NVARCHAR2(40) String |
Contact Name | Business Partner Contact Name | ContactName
NVARCHAR2(60) String | |
Contact Description | Description of Contact | ContactDescription
NVARCHAR2(255) String | |
Comments | Comments or additional information | The Comments field allows for free form entry of additional information. | Comments
NVARCHAR2(2000) Text |
Phone | Identifies a telephone number | The Phone field identifies a telephone number | Phone
NVARCHAR2(40) String |
2nd Phone | Identifies an alternate telephone number. | The 2nd Phone field identifies an alternate telephone number. | Phone2
NVARCHAR2(40) String |
Fax | Facsimile number | The Fax identifies a facsimile number for this Business Partner or Location | Fax
NVARCHAR2(40) String |
Birthday | Birthday or Anniversary day | Birthday or Anniversary day | Birthday
DATE Date |
EMail Address | Electronic Mail Address | The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com). The Email Address is used to access the self service application functionality from the web. | EMail
NVARCHAR2(60) String |
Password | Password of any length (case sensitive) | The Password for this User. Passwords are required to identify authorized users. For Adempiere Users, you can change the password via the Process "Reset Password". | Password
NVARCHAR2(20) String |
Interest Area | Name of the Interest Area | Name of the Interest Area of the user | InterestAreaName
NVARCHAR2(40) String |
Interest Area | Interest Area or Topic | Interest Areas reflect interest in a topic by a contact. Interest areas can be used for marketing campaigns. | R_InterestArea_ID
NUMBER(10) TableDir |
BP Contact Greeting | Greeting for Business Partner Contact | BPContactGreeting
NVARCHAR2(60) String | |
Greeting | Greeting to print on correspondence | The Greeting identifies the greeting to print on correspondence. | C_Greeting_ID
NUMBER(10) TableDir |
Import Business Partners | Import Business Partners | The Parameters are default values for null import record values, they do not overwrite any data. | Processing
CHAR(1) Button |
Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | Processed
CHAR(1) YesNo |