rv_bpartner

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
isactive bpchar 1 √ null
created timestamp 29,6 √ null
createdby numeric 10 √ null
updated timestamp 29,6 √ null
updatedby numeric 10 √ null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
value varchar 40 √ null
name varchar 120 √ null
name2 varchar 60 √ null
description varchar 255 √ null
issummary bpchar 1 √ null
c_bp_group_id numeric 10 √ null
c_bp_group.c_bp_group_id Implied Constraint R
isonetime bpchar 1 √ null
isprospect bpchar 1 √ null
isvendor bpchar 1 √ null
iscustomer bpchar 1 √ null
isemployee bpchar 1 √ null
issalesrep bpchar 1 √ null
referenceno varchar 40 √ null
duns varchar 11 √ null
url varchar 120 √ null
ad_language varchar 6 √ null
ad_language.ad_language Implied Constraint R
taxid varchar 20 √ null
istaxexempt bpchar 1 √ null
c_invoiceschedule_id numeric 10 √ null
c_invoiceschedule.c_invoiceschedule_id Implied Constraint R
rating bpchar 1 √ null
salesvolume numeric 10 √ null
numberemployees numeric 10 √ null
naics varchar 6 √ null
firstsale timestamp 29,6 √ null
acqusitioncost numeric 0 √ null
potentiallifetimevalue numeric 0 √ null
actuallifetimevalue numeric 0 √ null
shareofcustomer numeric 10 √ null
paymentrule bpchar 1 √ null
so_creditlimit numeric 0 √ null
so_creditused numeric 0 √ null
so_creditavailable numeric 0 √ null
c_paymentterm_id numeric 10 √ null
c_paymentterm.c_paymentterm_id Implied Constraint R
m_pricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id Implied Constraint R
m_discountschema_id numeric 10 √ null
m_discountschema.m_discountschema_id Implied Constraint R
c_dunning_id numeric 10 √ null
c_dunning.c_dunning_id Implied Constraint R
isdiscountprinted bpchar 1 √ null
so_description varchar 255 √ null
poreference varchar 20 √ null
paymentrulepo bpchar 1 √ null
po_pricelist_id numeric 10 √ null
po_discountschema_id numeric 10 √ null
po_paymentterm_id numeric 10 √ null
documentcopies numeric 10 √ null
c_greeting_id numeric 10 √ null
c_greeting.c_greeting_id Implied Constraint R
invoicerule bpchar 1 √ null
deliveryrule bpchar 1 √ null
freightcostrule bpchar 1 √ null
deliveryviarule bpchar 1 √ null
salesrep_id numeric 10 √ null
sendemail bpchar 1 √ null
bpartner_parent_id numeric 10 √ null
invoice_printformat_id numeric 10 √ null
socreditstatus bpchar 1 √ null
shelflifeminpct numeric 10 √ null
ad_orgbp_id numeric 10 √ null
flatdiscount numeric 0 √ null
totalopenbalance numeric 0 √ null
ad_user_id numeric 10 √ null
contactname varchar 60 √ null
contactdescription text 2147483647 √ null
email varchar 60 √ null
supervisor_id numeric 10 √ null
emailuser varchar 60 √ null
bpcontactgreeting numeric 10 √ null
title varchar 40 √ null
comments varchar 2000 √ null
phone varchar 40 √ null
phone2 varchar 40 √ null
fax varchar 40 √ null
lastcontact timestamp 29,6 √ null
lastresult varchar 255 √ null
birthday timestamp 29,6 √ null
ad_orgtrx_id numeric 10 √ null
emailverify varchar 40 √ null
ldapuser varchar 60 √ null
emailverifydate timestamp 29,6 √ null
notificationtype bpchar 1 √ null
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id Implied Constraint R
postal varchar 10 √ null
city varchar 60 √ null
address1 varchar 60 √ null
address2 varchar 60 √ null
address3 varchar 60 √ null
c_region_id numeric 10 √ null
c_region.c_region_id Implied Constraint R
regionname varchar 2147483647 √ null
c_country_id numeric 10 √ null
c_country.c_country_id Implied Constraint R
countryname varchar 60 √ null
c_bp_c_taxgroup_id numeric 10 √ null
c_taxgroup.c_taxgroup_id Implied Constraint R
c_bp_dunninggrace timestamp 29,6 √ null
c_bp_ismanufacturer bpchar 1 √ null
c_bp_ispotaxexempt bpchar 1 √ null
c_bp_logo_id numeric 10 √ null
c_bp_location_ad_org_id numeric 10 √ null
c_bp_location_c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
c_bp_location_c_location_id numeric 10 √ null
c_location.c_location_id Implied Constraint R
c_bp_location_created timestamp 29,6 √ null
c_bp_location_createdby numeric 10 √ null
c_bp_location_salesregion_id numeric 10 √ null
c_bp_location_cof_m_shipregion_id numeric 10 √ null
cof_m_shipregion.cof_m_shipregion_id Implied Constraint R
c_bp_location_fax varchar 40 √ null
c_bp_location_isactive bpchar 1 √ null
c_bp_location_isbillto bpchar 1 √ null
c_bp_location_isdn varchar 40 √ null
c_bp_location_ispayfrom bpchar 1 √ null
c_bp_location_isremitto bpchar 1 √ null
c_bp_location_isshipto bpchar 1 √ null
c_bp_location_name varchar 60 √ null
c_bp_location_phone varchar 40 √ null
c_bp_location_phone2 varchar 40 √ null
c_bp_location_updated timestamp 29,6 √ null
c_bp_location_updatedby numeric 10 √ null
ad_user_ad_org_id numeric 10 √ null
ad_user_c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
ad_user_c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id Implied Constraint R
ad_user_created timestamp 29,6 √ null
ad_user_createdby numeric 10 √ null
ad_user_isactive bpchar 1 √ null
ad_user_updated timestamp 29,6 √ null
ad_user_updatedby numeric 10 √ null
ad_user_value varchar 40 √ null
address4 varchar 60 √ null
c_location_ad_org_id numeric 10 √ null
c_city_id numeric 10 √ null
c_city.c_city_id Implied Constraint R
c_location_id numeric 10 √ null
c_location.c_location_id Implied Constraint R
c_location_created timestamp 29,6 √ null
c_location_createdby numeric 10 √ null
c_location_isactive bpchar 1 √ null
postal_add varchar 10 √ null
c_location_updated timestamp 29,6 √ null
c_location_updatedby numeric 10 √ null
c_region_ad_org_id numeric 10 √ null
c_region_c_country_id numeric 10 √ null
c_country.c_country_id Implied Constraint R
c_region_description varchar 255 √ null
c_region_isactive bpchar 1 √ null
isdefault bpchar 1 √ null
c_country_ad_language varchar 6 √ null
ad_language.ad_language Implied Constraint R
c_country_c_currency_id numeric 10 √ null
c_currency.c_currency_id Implied Constraint R
countrycode bpchar 2 √ null
c_country_description varchar 255 √ null
c_country_isactive bpchar 1 √ null
cof_registerrevision timestamp 29,6 √ null
lbr_bptypebr varchar 2 √ null
lbr_cnpj varchar 18 √ null
lbr_cpf varchar 14 √ null
cof_indie bpchar 1 √ null
lbr_ie varchar 30 √ null
cof_taxregimecode bpchar 1 √ null
lbr_transactiontype bpchar 3 √ null
lbr_suframa varchar 30 √ null
lbr_ccm varchar 30 √ null
lbr_isnfecontact bpchar 1 √ null
cof_latitude varchar 15 √ null
cof_longitude varchar 15 √ null
cof_situacaocomercial varchar 4 √ null
cof_m_shipregion_id numeric 10 √ null
cof_m_shipregion.cof_m_shipregion_id Implied Constraint R
c_salesregion_id numeric 10 √ null
c_salesregion.c_salesregion_id Implied Constraint R
cof_tipoparceiro_id numeric 10 √ null
cof_tipoparceiro.cof_tipoparceiro_id Implied Constraint R
cof_classeparceiro_id numeric 10 √ null
cof_classeparceiro.cof_classeparceiro_id Implied Constraint R

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views