i_bpartner

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
i_bpartner_id numeric 10 null
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
isactive bpchar 1 √ 'Y'::bpchar
created timestamp 29,6 statement_timestamp()
createdby numeric 10 √ null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 √ null
i_isimported bpchar 1 'N'::bpchar
i_errormsg varchar 2000 √ null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_ibpartner N
value varchar 40 √ null
name varchar 60 √ null
name2 varchar 60 √ null
description varchar 255 √ null
duns varchar 11 √ null
taxid varchar 20 √ null
naics varchar 6 √ null
groupvalue varchar 40 √ null
c_bp_group_id numeric 10 √ null
c_bp_group.c_bp_group_id cbpgroup_ibpartner N
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_ibpartner N
address1 varchar 60 √ null
address2 varchar 60 √ null
postal varchar 10 √ null
postal_add varchar 10 √ null
city varchar 60 √ null
c_region_id numeric 10 √ null
c_region.c_region_id cregion_ibpartner N
regionname varchar 60 √ null
c_country_id numeric 10 √ null
c_country.c_country_id ccountry_ipartner N
countrycode bpchar 2 √ null
title varchar 40 √ null
contactname varchar 60 √ null
contactdescription varchar 255 √ null
comments varchar 2000 √ null
phone varchar 40 √ null
phone2 varchar 40 √ null
fax varchar 40 √ null
email varchar 60 √ null
password varchar 20 √ null
birthday timestamp 29,6 √ null
c_greeting_id numeric 10 √ null
c_greeting.c_greeting_id cgreeting_ibpartner N
bpcontactgreeting varchar 60 √ null
processing bpchar 1 √ null
processed bpchar 1 √ 'N'::bpchar
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_ibpartner N
r_interestarea_id numeric 10 √ null
r_interestarea.r_interestarea_id rinterestarea_ibpartner R
interestareaname varchar 40 √ null
iscustomer bpchar 1 √ NULL::bpchar
isemployee bpchar 1 √ NULL::bpchar
isvendor bpchar 1 √ NULL::bpchar
i_bpartner_uu varchar 36 √ NULL::character varying
isprospect bpchar 1 √ 'N'::bpchar
issalesrep bpchar 1 √ NULL::bpchar
socreditstatus bpchar 1 √ NULL::bpchar
so_creditlimit numeric 0 √ null
ad_language varchar 6 √ NULL::character varying
ad_language.ad_language adlanguage_ibpartner R
lbr_bptypebr varchar 2 √ NULL::character varying
lbr_cnpj varchar 30 √ NULL::character varying
lbr_ie varchar 30 √ NULL::character varying
lbr_cpf varchar 14 √ NULL::character varying
lbr_rg varchar 30 √ NULL::character varying
lbr_suframa varchar 30 √ NULL::character varying
cof_indie bpchar 1 √ '2'::bpchar
lbr_hassubstitution bpchar 1 √ 'N'::bpchar
cof_taxregimecode bpchar 1 √ NULL::bpchar
lbr_transactiontype varchar 3 √ NULL::character varying
lbr_isnfecontact bpchar 1 √ 'N'::bpchar
isshipto bpchar 1 √ NULL::bpchar
isbillto bpchar 1 √ NULL::bpchar
ispayfrom bpchar 1 √ NULL::bpchar
isremitto bpchar 1 √ NULL::bpchar
address3 varchar 60 √ NULL::character varying

Indexes

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

Check Constraints

Constraint Name Constraint
i_bpartner_isprospect_check ((isprospect = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_bpartner_lbr_isnfecontact_check ((lbr_isnfecontact = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_bpartner_isremitto_check ((isremitto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_bpartner_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_bpartner_iscustomer_check ((iscustomer = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_bpartner_isemployee_check ((isemployee = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_bpartner_isvendor_check ((isvendor = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_bpartner_ispayfrom_check ((ispayfrom = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_bpartner_isbillto_check ((isbillto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_bpartner_isshipto_check ((isshipto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_bpartner_issalesrep_check ((issalesrep = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_bpartner_lbr_hassubstitution_check ((lbr_hassubstitution = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_bpartner_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation