View idempiere11.adempiere.m_storage
M_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
m_product_id numeric 10  √  null Product, Service, Item
m_locator_id numeric 10  √  null Warehouse Locator
ad_client_id numeric 10  √  null Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within tenant
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
qtyonhand numeric 0  √  null On Hand Quantity
qtyreserved numeric 0  √  null Reserved Quantity
qtyordered numeric 0  √  null Ordered Quantity
datelastinventory timestamp 29,6  √  null Date of Last Inventory Count
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_storage_uu varchar 36  √  null M_Storage_UU
datematerialpolicy timestamp 29,6  √  null Time used for LIFO and FIFO Material Policy

Analyzed at 2024-01-03 13:51 +0100