t_bomline_costs

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
seqno numeric 10 √ null
levelno numeric 10 √ null
levels varchar 250 √ null
ad_client_id numeric 10 √ null
c_acctschema_id numeric 10 √ null
ad_org_id numeric 10 √ null
createdby numeric 10 √ null
updatedby numeric 10 √ null
updated timestamp 29,6 √ null
created timestamp 29,6 √ null
ad_pinstance_id numeric 10 √ null
ad_pinstance.ad_pinstance_id Implied Constraint R
implosion bpchar 1 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
m_costelement_id numeric 10 √ null
m_costelement.m_costelement_id Implied Constraint R
currentcostprice numeric 0 √ null
currentcostpricell numeric 0 √ null
futurecostprice numeric 0 √ null
futurecostpricell numeric 0 √ null
iscostfrozen bpchar 1 √ null
qtybom numeric 0 √ null
cost numeric 0 √ null
coststandard numeric 0 √ null
m_costtype_id numeric 10 √ null
m_costtype.m_costtype_id Implied Constraint R
costingmethod bpchar 1 √ null
isactive bpchar 1 √ null
pp_product_bom_id numeric 10 √ null
pp_product_bom.pp_product_bom_id Implied Constraint R
pp_product_bomline_id numeric 10 √ null
pp_product_bomline.pp_product_bomline_id Implied Constraint R
description varchar 255 √ null
iscritical bpchar 1 √ null
componenttype bpchar 2 √ null
tm_product_id numeric 10 √ null
c_uom_id numeric 10 √ null
c_uom.c_uom_id Implied Constraint R
issuemethod bpchar 1 √ null
line numeric 10 √ null
m_attributesetinstance_id numeric 10 √ null
m_attributesetinstance.m_attributesetinstance_id Implied Constraint R
scrap numeric 0 √ null
validfrom timestamp 29,6 √ null
validto timestamp 29,6 √ null
isqtypercentage bpchar 1 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views