m_costelement

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_costelement_id numeric 10 null
c_landedcost.m_costelement_id ccostelement_clandedcost R
c_landedcostallocation.m_costelement_id mcostelement_mlandedcostalloc R
c_orderlandedcost.m_costelement_id mcostelement_corderlandedcost R
cof_ajusteqtdcontabil.m_costelement_id mcostelement_cofajusteqtdconta R
cof_c_sped_fiscal.m_costelement_id mcostelement_cofcspedfiscal R
cof_rv_detalhesmovimentocusto.m_costelement_id Implied Constraint R
cof_rv_faturamentoprodutomargem.m_costelement_id Implied Constraint R
lbr_averagecost.m_costelement_id Implied Constraint R
m_cost.m_costelement_id mcostelement_mcost C
m_costdetail.m_costelement_id mcostelement_mcostdetail R
m_costhistory.m_costelement_id mcostelement_mcosthistory R
m_costmovement_v.m_costelement_id Implied Constraint R
m_costqueue.m_costelement_id mcostelement_mcostqueue C
pp_order_cost.m_costelement_id mcostelement_ppordercost R
rv_cost.m_costelement_id Implied Constraint R
rv_costdetail.m_costelement_id Implied Constraint R
rv_costsummary.m_costelement_id Implied Constraint R
t_bom_indented.m_costelement_id Implied Constraint R
t_bomline.m_costelement_id Implied Constraint R
t_bomline_costs.m_costelement_id Implied Constraint R
t_inventoryvalue.m_costelement_id mcostelement_tinventoryvalue C
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
costelementtype bpchar 1 null
costingmethod bpchar 1 √ null
iscalculated bpchar 1 'N'::bpchar
m_costelement_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
m_costelement_pkey Primary key Asc m_costelement_id
m_costelement_uu_idx Must be unique Asc m_costelement_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation