m_product_bom

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

m_product_bom_id

numeric

√

null

m_product_bom_old.m_product_bom_id

Implied Constraint

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

isactive

bpchar

√

null

created

timestamp

29,6

√

null

createdby

numeric

√

null

updated

timestamp

29,6

√

null

updatedby

numeric

√

null

line

numeric

√

null

m_product_id

numeric

√

null

m_product.m_product_id

Implied Constraint

m_productbom_id

numeric

√

null

bomqty

numeric

√

null

description

varchar

255

√

null

bomtype

varchar

2147483647

√

null

m_product_bom_uu

varchar

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT l.pp_product_bomline_id AS m_product_bom_id,
    l.ad_client_id,
    l.ad_org_id,
    l.isactive,
    l.created,
    l.createdby,
    l.updated,
    l.updatedby,
    l.line,
    b.m_product_id,
    l.m_product_id AS m_productbom_id,
    l.qtybom AS bomqty,
    b.description,
        CASE l.componenttype
            WHEN 'OP'::bpchar THEN 'O'::character varying
            WHEN 'CO'::bpchar THEN 'P'::character varying
            WHEN 'PH'::bpchar THEN 'P'::character varying
            WHEN 'PK'::bpchar THEN 'P'::character varying
            WHEN 'VA'::bpchar THEN
            CASE
                WHEN ((l.feature)::text = ANY (ARRAY[('1'::character varying)::text, ('2'::character varying)::text, ('3'::character varying)::text, ('4'::character varying)::text, ('5'::character varying)::text, ('6'::character varying)::text, ('7'::character varying)::text, ('8'::character varying)::text, ('9'::character varying)::text])) THEN l.feature
                ELSE 'O'::character varying
            END
            ELSE 'P'::character varying
        END AS bomtype,
    l.pp_product_bomline_uu AS m_product_bom_uu
   FROM (pp_product_bom b
     JOIN pp_product_bomline l ON ((b.pp_product_bom_id = l.pp_product_bom_id)))
  WHERE ((b.bomtype = 'A'::bpchar) AND (b.bomuse = 'A'::bpchar) AND (b.isactive = 'Y'::bpchar));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views