cof_paramformacaopreco

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cofparamformacaopreco R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cofparamformacaopreco R
cof_paramformacaopreco_id numeric 10 null
cof_paramformacaopreco_uu varchar 36 √ NULL::character varying
cof_perccf numeric 0 √ null
cof_perccapex numeric 0 √ null
cof_percdf numeric 0 √ null
cof_percinflacao numeric 0 √ null
cof_percjuros numeric 0 √ null
cof_percmargem numeric 0 √ 0
cof_percmarketing numeric 0 √ null
cof_percopex numeric 0 √ null
cof_percredicms numeric 0 √ null
cof_percst numeric 0 √ 0
cof_peso numeric 0 √ 0
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_cofparamformacaoprec R
isactive bpchar 1 'Y'::bpchar
updated timestamp 29,6 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_cofparamformacaoprec R
value varchar 40 √ NULL::character varying
cof_perccofins numeric 0 √ 0
cof_percicms numeric 0 √ 0
cof_percipi numeric 0 √ 0
cof_percpis numeric 0 √ 0
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_cofparamformacaopreco R
cof_producttype_id numeric 10 √ NULL::numeric
cof_producttype.cof_producttype_id cofproducttype_cofparamformaca R
cof_productclass_id numeric 10 √ NULL::numeric
cof_productclass.cof_productclass_id cofproductclass_cofparamformac R
cof_productgroup_id numeric 10 √ NULL::numeric
cof_productgroup.cof_productgroup_id cofproductgroup_cofparamformac R

Indexes

Constraint Name Type Sort Column(s)
cof_paramformacaopreco_key Primary key Asc cof_paramformacaopreco_id
cof_paramformacaopreco_uu_idx Must be unique Asc cof_paramformacaopreco_uu

Check Constraints

Constraint Name Constraint
cof_paramformacaopreco_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation