View idempiere9.adempiere.rv_pp_order_storage
View Order Storage

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
createdby numeric 10  √  null User who created this records
updatedby numeric 10  √  null User who updated this records
updated timestamp 29,6  √  null Date this record was updated
created timestamp 29,6  √  null Date this record was created
isactive bpchar 1  √  null The record is active in the system
pp_order_bom_id numeric 10  √  null Manufacturing Order BOM
pp_order_bomline_id numeric 10  √  null Manufacturing Order BOM Line
pp_order_id numeric 10  √  null Manufacturing Order
iscritical bpchar 1  √  null Indicate that a Manufacturing Order can not begin without have this component
m_product_id numeric 10  √  null Product, Service, Item
name varchar 255  √  null Alphanumeric identifier of the entity
c_uom_id numeric 10  √  null Unit of Measure
qtyonhand numeric 0  √  null On Hand Quantity
qtyrequiered numeric 0  √  null Qty Requiered
qtybatchsize numeric 0  √  null Qty Batch Size
qtyreserved numeric 0  √  null Reserved Quantity
qtyavailable numeric 0  √  null Available Quantity (On Hand - Reserved)
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
qtybom numeric 0  √  null Indicate the Quantity use in this BOM
isqtypercentage bpchar 1  √  null Indicate that this component is based in % Quantity
qtybatch numeric 0  √  null Indicate the Quantity % use in this Formula
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_locator_id numeric 10  √  null Warehouse Locator
x varchar 60  √  null X dimension, e.g., Aisle
y varchar 60  √  null Y dimension, e.g., Bin
z varchar 60  √  null Z dimension, e.g., Level

Analyzed at 2021-12-25 14:43 +0100