rv_pp_order_receipt_issue

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pp_order_bomline_id numeric 10 √ null
pp_order_bomline.pp_order_bomline_id Implied Constraint R
iscritical bpchar 1 √ null
value varchar 510 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
productname varchar 255 √ null
m_attributesetinstance_id numeric 10 √ null
m_attributesetinstance.m_attributesetinstance_id Implied Constraint R
instancename varchar 255 √ null
c_uom_id numeric 10 √ null
c_uom.c_uom_id Implied Constraint R
uomname varchar 60 √ null
qtyrequiered numeric 0 √ null
qtyreserved_order numeric 0 √ null
qtyonhand numeric 0 √ null
qtyreserved_storage numeric 0 √ null
qtyavailable numeric 0 √ null
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
warehousename varchar 60 √ null
qtybom numeric 0 √ null
isqtypercentage bpchar 1 √ null
qtybatch numeric 0 √ null
componenttype bpchar 2 √ null
qtyopen numeric 0 √ null
pp_order_id numeric 10 √ null
pp_order.pp_order_id Implied Constraint R

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views