Table idempiere9.adempiere.i_bpartner
Import Business Partner

Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
i_bpartner_id numeric 10 Import Business Partner
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  'Y'::bpchar The record is active in the system
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10  √  null User who updated this records
i_isimported bpchar 1 'N'::bpchar Has this import been processed
i_errormsg varchar 2000  √  null Messages generated from import process
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_ibpartner N
Identifies a Business Partner
value varchar 40  √  null Search key for the record in the format required - must be unique
name varchar 60  √  null Alphanumeric identifier of the entity
name2 varchar 60  √  null Additional Name
description varchar 255  √  null Optional short description of the record
duns varchar 11  √  null Dun & Bradstreet Number
taxid varchar 20  √  null Tax Identification
naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
groupvalue varchar 40  √  null Business Partner Group Key
c_bp_group_id numeric 10  √  null
c_bp_group.c_bp_group_id cbpgroup_ibpartner N
Business Partner Group
c_bpartner_location_id numeric 10  √  null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_ibpartner N
Identifies the (ship to) address for this Business Partner
address1 varchar 60  √  null Address line 1 for this location
address2 varchar 60  √  null Address line 2 for this location
postal varchar 10  √  null Postal code
postal_add varchar 10  √  null Additional ZIP or Postal code
city varchar 60  √  null Identifies a City
c_region_id numeric 10  √  null
c_region.c_region_id cregion_ibpartner N
Identifies a geographical Region
regionname varchar 60  √  null Name of the Region
c_country_id numeric 10  √  null
c_country.c_country_id ccountry_ipartner N
Country
countrycode bpchar 2  √  null Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
title varchar 40  √  null Name this entity is referred to as
contactname varchar 60  √  null Business Partner Contact Name
contactdescription varchar 255  √  null Description of Contact
comments varchar 2000  √  null Comments or additional information
phone varchar 40  √  null Identifies a telephone number
phone2 varchar 40  √  null Identifies an alternate telephone number.
fax varchar 40  √  null Facsimile number
email varchar 60  √  null Electronic Mail Address
password varchar 20  √  null Password of any length (case sensitive)
birthday timestamp 29,6  √  null Birthday or Anniversary day
c_greeting_id numeric 10  √  null
c_greeting.c_greeting_id cgreeting_ibpartner N
Greeting to print on correspondence
bpcontactgreeting varchar 60  √  null Greeting for Business Partner Contact
processing bpchar 1  √  null Process Now
processed bpchar 1  √  'N'::bpchar The document has been processed
ad_user_id numeric 10  √  null
ad_user.ad_user_id aduser_ibpartner N
User within the system - Internal or Business Partner Contact
r_interestarea_id numeric 10  √  null
r_interestarea.r_interestarea_id rinterestarea_ibpartner R
Interest Area or Topic
interestareaname varchar 40  √  null Name of the Interest Area
iscustomer bpchar 1  √  NULL::bpchar Indicates if this Business Partner is a Customer
isemployee bpchar 1  √  NULL::bpchar Indicates if this Business Partner is an employee
isvendor bpchar 1  √  NULL::bpchar Indicates if this Business Partner is a Vendor
i_bpartner_uu varchar 36  √  NULL::character varying I_BPartner_UU

Table contained 0 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
i_bpartner_id Primary key Asc i_bpartner_pkey
i_bpartner_uu Must be unique Asc i_bpartner_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.