rv_pp_order_storage

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_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
isactive bpchar 1 √ null
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
iscritical bpchar 1 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
name varchar 255 √ null
c_uom_id numeric 10 √ null
c_uom.c_uom_id Implied Constraint R
qtyonhand numeric 0 √ null
qtyrequiered numeric 0 √ null
qtybatchsize numeric 0 √ null
qtyreserved numeric 0 √ null
qtyavailable numeric 0 √ null
m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id Implied Constraint R
qtybom numeric 0 √ null
isqtypercentage bpchar 1 √ null
qtybatch numeric 0 √ null
m_attributesetinstance_id numeric 10 √ null
m_attributesetinstance.m_attributesetinstance_id Implied Constraint R
m_locator_id numeric 10 √ null
m_locator.m_locator_id Implied Constraint R
x varchar 60 √ null
y varchar 60 √ null
z varchar 60 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views