m_costtype

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_costtype_id numeric 10 null
c_acctschema.m_costtype_id mcosttype_cacctschema R
cof_ajusteqtdcontabil.m_costtype_id mcosttype_cofajusteqtdcontabil R
cof_c_sped_fiscal.m_costtype_id mcosttype_cofcspedfiscal R
cof_rv_detalhesmovimentocusto.m_costtype_id Implied Constraint R
cof_rv_faturamentoprodutomargem.m_costtype_id Implied Constraint R
m_cost.m_costtype_id mcosttype_mcost C
m_costhistory.m_costtype_id mcosttype_mcosthistory R
m_costmovement_v.m_costtype_id Implied Constraint R
m_costqueue.m_costtype_id mcosttype_mcostqueue C
pp_order_cost.m_costtype_id mcosttype_ppordercost R
rv_cost.m_costtype_id Implied Constraint R
rv_costdetail.m_costtype_id Implied Constraint R
rv_costsummary.m_costtype_id Implied Constraint R
t_bomline.m_costtype_id Implied Constraint R
t_bomline_costs.m_costtype_id Implied Constraint R
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
help varchar 2000 √ null
m_costtype_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
m_costtype_pkey Primary key Asc m_costtype_id
m_costtype_uu_idx Must be unique Asc m_costtype_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation