pp_product_bom

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
value varchar 80 null
name varchar 60 null
documentno varchar 22 √ null
revision varchar 10 √ null
description varchar 255 √ null
copyfrom bpchar 1 √ null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
help varchar 2000 √ null
isactive bpchar 1 null
ad_client_id numeric 10 null
m_changenotice_id numeric 10 √ null
m_changenotice.m_changenotice_id mchangenotice_ppproductbom R
m_product_id numeric 10 null
m_product.m_product_id mproduct_ppproductbom R
pp_product_bom_id numeric 10 null
c_invoiceline.pp_product_bom_id ppproductbom_cinvoiceline R
c_orderline.pp_product_bom_id ppproductbom_corderline R
cof_pp_planomestreprod.pp_product_bom_id ppproductbom_cofppplanomestrep R
i_productplanning.pp_product_bom_id ppproductbom_iproductplanning R
m_changerequest.pp_product_bom_id ppproductbom_mchangerequest R
m_inoutline.pp_product_bom_id ppproductbom_minoutline R
m_production.pp_product_bom_id ppproductbom_mproduction R
pp_order.pp_product_bom_id ppproductbom_pporder R
pp_product_bom_trl.pp_product_bom_id ppproductbom_ppproductbomtrl R
pp_product_bomline.pp_product_bom_id ppproductbom_ppproductbomline R
pp_product_planning.pp_product_bom_id ppproductbom_ppproductplanning R
qm_specification.pp_product_bom_id ppproductbom_qmspecification R
r_group.pp_product_bom_id ppproductbom_rgroup R
processing bpchar 1 √ null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
validfrom timestamp 29,6 √ null
validto timestamp 29,6 √ null
m_attributesetinstance_id numeric 10 √ null
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_ppproduc R
ad_org_id numeric 10 null
bomtype bpchar 1 √ 'A'::bpchar
bomuse bpchar 1 √ 'M'::bpchar
c_uom_id numeric 10 √ null
c_uom.c_uom_id cuom_ppproductbom R
pp_product_bom_uu varchar 36 √ NULL::character varying
cof_iskitldm bpchar 1 'N'::bpchar
cof_iskitpadrao bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
pp_product_bom_key Primary key Asc pp_product_bom_id
pp_product_bom_product_id_idx Performance Asc m_product_id
pp_product_bom_uu_idx Must be unique Asc pp_product_bom_uu
ppproductbomunique Must be unique Asc/Asc ad_client_id + value

Check Constraints

Constraint Name Constraint
pp_product_bom_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pp_product_bom_cof_iskitldm_check ((cof_iskitldm = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pp_product_bom_cof_iskitpadrao_check ((cof_iskitpadrao = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation