pp_order_bomline_v

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
isactive bpchar 1 √ null
created timestamp 29,6 √ null
createdby numeric 10 √ null
updated timestamp 29,6 √ null
updatedby numeric 10 √ null
ad_language varchar 2147483647 √ null
description varchar 255 √ null
feature varchar 30 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
backflushgroup varchar 30 √ null
c_uom_id numeric 10 √ null
c_uom.c_uom_id Implied Constraint R
componenttype bpchar 2 √ null
datedelivered timestamp 29,6 √ null
forecast numeric 0 √ null
help varchar 2000 √ null
iscritical bpchar 1 √ null
issuemethod bpchar 1 √ null
leadtimeoffset numeric 10 √ null
line numeric 10 √ null
m_attributesetinstance_id numeric 10 √ null
m_attributesetinstance.m_attributesetinstance_id Implied Constraint R
m_changenotice_id numeric 10 √ null
m_changenotice.m_changenotice_id Implied Constraint R
m_locator_id numeric 10 √ null
m_locator.m_locator_id Implied Constraint R
m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id Implied Constraint R
pp_order_bom_id numeric 10 √ null
pp_order_bom.pp_order_bom_id Implied Constraint R
pp_order_bomline_id numeric 10 √ null
pp_order_bomline.pp_order_bomline_id Implied Constraint R
pp_order_id numeric 10 √ null
pp_order.pp_order_id Implied Constraint R
qtydelivered numeric 0 √ null
qtypost numeric 0 √ null
qtyreject numeric 0 √ null
qtyscrap numeric 0 √ null
scrap numeric 0 √ null
validfrom timestamp 29,6 √ null
validto timestamp 29,6 √ null
assay numeric 0 √ null
ad_user_id numeric 10 √ null
qtyrequiered numeric 0 √ null
qtyreserved numeric 0 √ null
qtyavailable numeric 0 √ null
qtyonhand numeric 0 √ null
qtybom numeric 0 √ null
isqtypercentage bpchar 1 √ null
qtybatch numeric 0 √ null
qtybatchsize numeric 0 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views