m_productionline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_productionline_id numeric 10 null
c_invoiceline.cof_linhaopindusprestador_id coflinhaopindusprestador_cinvo R
c_invoiceline.cof_linhaopmataplicadoprest_id coflinhaopmataplicadoprest_cin R
c_orderline.cof_linhaopindusprestador_id coflinhaopindustrializacaopres R
c_orderline.m_productionline_id Implied Constraint R
cof_pp_consumomateriaprima.m_productionline_id mproductionline_cofppconsumoma R
cof_rv_detalhesestoqueprevisto.m_productionline_id Implied Constraint R
cof_trxestoqueprevisto.m_productionline_id mproductionline_coftrxestoquep R
m_costdetail.m_productionline_id mproductionline_mcostdetail R
m_costmovement_v.m_productionline_id Implied Constraint R
m_productionlinema.m_productionline_id mproductionline_mplinema C
m_transaction.m_productionline_id mproductionline_mtransaction R
m_transaction_v.m_productionline_id Implied Constraint R
m_transactionallocation.m_productionline_id mproductionline_mtrxalloc R
m_transactionallocation.out_m_productionline_id mproductionlineout_mtrxalloc R
rv_costdetail.m_productionline_id Implied Constraint R
rv_m_transaction.m_productionline_id Implied Constraint R
rv_transaction.m_productionline_id Implied Constraint R
t_transaction.m_productionline_id mproductionline_ttransaction 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
m_productionplan_id numeric 10 √ null
m_productionplan.m_productionplan_id mproductionplan_line C
line numeric 10 null
m_product_id numeric 10 null
m_product.m_product_id mproduct_mproductionline R
movementqty numeric 0 0
m_locator_id numeric 10 null
m_locator.m_locator_id mlocator_mproductionline R
description varchar 255 √ null
m_attributesetinstance_id numeric 10 √ 0
m_attributesetinstance.m_attributesetinstance_id mattrsetinst_mproductionline R
processed bpchar 1 'N'::bpchar
m_productionline_uu varchar 36 √ NULL::character varying
m_production_id numeric 10 √ null
m_production.m_production_id mproduction_mproductionline R
plannedqty numeric 0 √ null
qtyused numeric 0 √ null
isendproduct bpchar 1 √ NULL::bpchar
qtydelivered numeric 0 (0)::numeric
user1_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user1_mproductionline R
user2_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user2_mproductionline R
c_activity_id numeric 10 √ NULL::numeric
c_activity.c_activity_id cactivity_mproductionline R
c_campaign_id numeric 10 √ NULL::numeric
c_campaign.c_campaign_id ccampaign_mproductionline R
c_project_id numeric 10 √ NULL::numeric
c_project.c_project_id cproject_mproductionline R
cof_iscoproduct bpchar 1 √ 'N'::bpchar
cof_isbyproduct bpchar 1 √ 'N'::bpchar
cof_costallocationperc numeric 0 √ '0'::numeric
cof_pp_isperda bpchar 1 √ 'N'::bpchar
cof_pp_planomestreprod_id numeric 10 √ NULL::numeric
cof_pp_planomestreprod.cof_pp_planomestreprod_id cofppplanomestreprod_mproducti R
cof_pp_gestaomp_id numeric 10 √ NULL::numeric
cof_pp_gestaomp.cof_pp_gestaomp_id cofppgestaomp_mproductionline R
cof_quantidadeprevista numeric 0 '0'::numeric
cof_produtosubstituto_id numeric 10 √ NULL::numeric
cof_controleremessasind_id numeric 10 √ NULL::numeric
cof_controleremessasind.cof_controleremessasind_id cofcontroleremessasind_mproduc R
cof_mprecebida_id numeric 10 √ null
cof_mprecebida.cof_mprecebida_id cofmprecebida_mproductionline R

Indexes

Constraint Name Type Sort Column(s)
m_productionline_pkey Primary key Asc m_productionline_id
m_productionline_prodplan Performance Asc m_productionplan_id
m_productionline_uu_idx Must be unique Asc m_productionline_uu

Check Constraints

Constraint Name Constraint
m_productionline_isendproduct_check ((isendproduct = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_productionline_cof_iscoproduct_check ((cof_iscoproduct = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_productionline_cof_pp_isperda_check ((cof_pp_isperda = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_productionline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_productionline_cof_isbyproduct_check ((cof_isbyproduct = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation