t_bomline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_pinstance_id numeric 10 √ null
ad_pinstance.ad_pinstance_id Implied Constraint R
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
isactive bpchar 1 √ null
levelno numeric 10 √ null
levels varchar 250 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
pp_product_bomline_id numeric 10 √ null
pp_product_bomline.pp_product_bomline_id Implied Constraint R
pp_product_bom_id numeric 10 √ null
pp_product_bom.pp_product_bom_id Implied Constraint R
seqno numeric 10 √ null
t_bomline_id numeric 10 null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
sel_product_id numeric 10 null
implosion bpchar 1 √ 'N'::bpchar
m_costelement_id numeric 10 √ null
m_costelement.m_costelement_id Implied Constraint R
currentcostprice numeric 0 √ null
currentcostpricell numeric 0 √ null
qtybom numeric 0 √ null
cost varchar 22 √ null
c_acctschema_id numeric 10 √ null
costingmethod bpchar 1 √ NULL::bpchar
m_costtype_id numeric 10 √ NULL::numeric
m_costtype.m_costtype_id Implied Constraint R
futurecostprice numeric 0 √ null
futurecostpricell numeric 0 √ null
iscostfrozen bpchar 1 √ NULL::bpchar
coststandard numeric 0 √ null
t_bomline_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
t_bomline_key Primary key Asc t_bomline_id
t_bomline_uu_idx Must be unique Asc t_bomline_uu

Check Constraints

Constraint Name Constraint
t_bomline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
t_bomline_iscostfrozen_check ((iscostfrozen = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
t_bomline_implosion_check ((implosion = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation