cof_rv_detalheslocalizacao

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_org_id numeric 10 √ null
ad_client_id numeric 10 √ null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
c_bp_group_id numeric 10 √ null
c_bp_group.c_bp_group_id Implied Constraint R
name varchar 120 √ null
cof_situacaocomercial varchar 4 √ null
cof_nameloc varchar 60 √ null
phone varchar 40 √ null
isshipto bpchar 1 √ null
ispayfrom bpchar 1 √ null
isbillto bpchar 1 √ null
isremitto bpchar 1 √ null
cof_m_shipregion_id numeric 10 √ null
cof_m_shipregion.cof_m_shipregion_id Implied Constraint R
cof_modfrete bpchar 1 √ null
cof_sequenciaentrega numeric 10 √ null
cof_sequenciaentregacidade numeric 10 √ null
cof_sequenciaentregaregiao numeric 10 √ null
c_salesregion_id numeric 10 √ null
c_salesregion.c_salesregion_id Implied Constraint R
cof_shipper_id numeric 10 √ null
address1 varchar 60 √ null
address2 varchar 60 √ null
address3 varchar 60 √ null
address4 varchar 60 √ null
address5 varchar 60 √ null
c_city_id numeric 10 √ null
c_city.c_city_id Implied Constraint R
c_country_id numeric 10 √ null
c_country.c_country_id Implied Constraint R
c_region_id numeric 10 √ null
c_region.c_region_id Implied Constraint R
regionname varchar 40 √ null
city varchar 60 √ null
cof_latitude varchar 15 √ null
cof_longitude varchar 15 √ null
postal varchar 10 √ null
cityname varchar 60 √ null
areacode varchar 10 √ null
locode varchar 10 √ null
coordinates varchar 15 √ null
lbr_citycode varchar 10 √ null
lbr_regioncode numeric 10 √ null
cof_regiondescription varchar 255 √ null
ad_language varchar 6 √ null
ad_language.ad_language Implied Constraint R
cof_countryname varchar 60 √ null
cof_countrydescription varchar 255 √ null
c_currency_id numeric 10 √ null
c_currency.c_currency_id Implied Constraint R
countrycode bpchar 2 √ null
value varchar 40 √ null
cof_nameregiaoentrega varchar 60 √ null
cof_shipregiondescription varchar 255 √ null
isactive bpchar 1 √ null
isdefault bpchar 1 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views