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

ERP/2.50/Developers Guide/Database Model/org.openbravo.model.dataimport/I BPartner

Contents

I_BPartner

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

This table contains the following columns:

Name Nullable Data Type Description
I_BPartner_ID NVARCHAR2(32)null
AD_Client_ID YVARCHAR2(32)Client for this installation.
AD_Org_ID YVARCHAR2(32)Organizational entity within client
IsActive YCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created YDATEThe date that this record is completed.
CreatedBy YVARCHAR2(32)User who created this records
Updated YDATEx not implemented
UpdatedBy YVARCHAR2(32)User who updated this records
C_BPartner_ID YVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Value YNVARCHAR2(40)A fast method for finding a particular record.
Name YNVARCHAR2(60)A non-unique identifier for a record/document often used as a search tool.
Name2 YNVARCHAR2(60)Additional space to write the name of a business partner.
Description YNVARCHAR2(255)A space to write additional related information.
DUNS YCHAR(11)Dun & Bradstreet Number
TaxID YVARCHAR2(20)The government defined unique number for assigning and paying taxes.
NAICS YCHAR(6)Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
GroupValue YNVARCHAR2(40)Business Partner Group Key
C_BP_Group_ID YVARCHAR2(32)A classification of business partners based on defined similarities.
C_BPartner_Location_ID YVARCHAR2(32)The location of the selected business partner.
Address1 YNVARCHAR2(60)A space to write the location of a business partner.
Address2 YNVARCHAR2(60)A space to write the location of a business partner.
Postal YVARCHAR2(10)A identification code used to help get items to a specific location.
Postal_Add YVARCHAR2(10)Additional ZIP or Postal code
City YNVARCHAR2(60)A populated defined area located within a larger area such as a state, province, or country.
C_Region_ID YVARCHAR2(32)An area of a specific country.
RegionName YNVARCHAR2(60)The name of an area in a specific country.
C_Country_ID YVARCHAR2(32)A state or a nation.
CountryCode YCHAR(2)The geographic country code for a country based on the ISO standard.
Title YNVARCHAR2(40)A defined job, title, or ranking within a company.
ContactName YNVARCHAR2(60)The name of the person to get in touch with.
ContactDescription YNVARCHAR2(255)Description of Contact
Comments YNVARCHAR2(2000)A space to write additional related information.
Phone YNVARCHAR2(40)A telephone number for a specified business partner.
Phone2 YNVARCHAR2(40)A second contact telephone number for a business partner.
Fax YNVARCHAR2(40)A fax number for a specified business partner.
Email YNVARCHAR2(40)An email address for a specified business partner.
Password YNVARCHAR2(20)A secret code used to allow access to a specified window or tab.
Birthday YDATEAn anniversary of birth for a business partner.
C_Greeting_ID YVARCHAR2(32)A description, often abbreviated, of how to address a business partner.
BPContactGreeting YNVARCHAR2(60)Greeting for Business Partner Contact
Processing YCHAR(1)A request to process the respective document or task.
Processed YCHAR(1)A confirmation that the associated documents or requests are processed.
AD_User_ID YVARCHAR2(32)An acquaintance to reach for information related to the business partner.
I_ErrorMsg YNVARCHAR2(2000)A message that appears when errors occur during the importing process.
I_IsImported YCHAR(1)A indication that the desired process has been completed successfully.

Other Info

Check constraints

These are the check constraints for this table:

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

Import Business Partner

The ID identifies a unique business partner to import

top

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)


Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Active

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.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Business Partner

Foreign key column to C_BPartner table, (column: C_BPartner_ID)

top

Search Key

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.

top

Name

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.

top

Name 2

Additional Name

top

Description

A description is limited to 255 characters.

top

D-U-N-S

Used for EDI - For details see www.dnb.com/dunsno/list.htm

top

Tax ID

The Tax ID field identifies the legal Identification number of this Entity.

top

NAICS/SIC

The NAICS/SIC identifies either of these codes that may be applicable to this Business Partner.

top

Group Key

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

top

Business Partner Category

Foreign key column to C_BP_Group table, (column: C_BP_Group_ID)

top

Partner Address

Foreign key column to C_BPartner_Location table, (column: C_BPartner_Location_ID)

top

Address Line 1

The Address 1 identifies the address for an entity's location

top

Address Line 2

The Address 2 provides additional address information for an entity. It can be used for building location, apartment number or similar information.

top

Postal Code

The Postal Code field identifies the postal code for this entity's address.

top

Postal add

The Additional ZIP or Postal Code identifies, if appropriate, any additional Postal Code information.

top

City Name

The City identifies a unique City for this Country or Region.

top

Region

Foreign key column to C_Region table, (column: C_Region_ID)


Validation Rule C_Region of Country: null. With the following code:

 
C_Region.C_Country_ID=@C_Country_ID@

top

Region Name

The Region Name defines the name that will print when this region is used in a document.

top

Country

Foreign key column to C_Country table, (column: C_Country_ID)

top

ISO Country Code

For details - http://www.din.de/gremien/nas/nabd/iso3166ma/codlstp1.html or - http://www.unece.org/trade/rec/rec03en.htm

top

Position

The Title indicates the name that an entity is referred to as.

top

Contact Name

Business Partner Contact Name

top

Contact Description

Description of Contact

top

Comments

The Comments field allows for free form entry of additional information.

top

Phone

The Phone field identifies a telephone number

top

Alternative Phone

The 2nd Phone field identifies an alternate telephone number.

top

Fax

The Fax identifies a facsimile number for this Business Partner or Location

top

Email

The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com).

top

Password

The Password indicates the Password for this User Id. Passwords are required to identify authorized users.

top

Birthday

Birthday or Anniversary day

top

Greeting

Foreign key column to C_Greeting table, (column: C_Greeting_ID)

top

BP Contact Greeting

Greeting for Business Partner Contact

top

Process Now

When this field is set as 'Y' a process is being performed on this record.

top

Processed

The Processed checkbox indicates that a document has been processed.

top

User/Contact

Foreign key column to AD_User table, (column: AD_User_ID)


Validation Rule AD_User C_BPartner User/Contacts: null. With the following code:

 
AD_User.C_BPartner_ID=@C_BPartner_ID@

top

Import Error Message

The Import Error Message displays any error messages generated during the import process.

top

Import Process Complete

The Imported check box indicates if this import has been processed.

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Database_Model/org.openbravo.model.dataimport/I_BPartner"

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