View almasdd.COMPIERE.RV_STORAGE

 Generated by
SchemaSpy
Implied relationships Related columns Constraint names Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents
AD_CLIENT_ID number 10
AD_CLIENTINFO AD_CLIENT_ID Implied Constraint
AD_ORG_ID number 10
AD_ORGINFO AD_ORG_ID Implied Constraint
M_PRODUCT_ID number 10
M_PRODUCT M_PRODUCT_ID Implied Constraint
VALUE nvarchar2 80
NAME nvarchar2 120
DESCRIPTION nvarchar2 510  √  null
UPC varchar2 30  √  null
SKU varchar2 30  √  null
C_UOM_ID number 10
C_UOM C_UOM_ID Implied Constraint
M_PRODUCT_CATEGORY_ID number 10
M_PRODUCT_CATEGORY M_PRODUCT_CATEGORY_ID Implied Constraint
CLASSIFICATION char 1  √  null
WEIGHT number 22  √  null
VOLUME number 22  √  null
VERSIONNO nvarchar2 40  √  null
GUARANTEEDAYS number 10  √  null
GUARANTEEDAYSMIN number 10  √  null
M_LOCATOR_ID number 10
M_LOCATOR M_LOCATOR_ID Implied Constraint
M_WAREHOUSE_ID number 10
M_WAREHOUSE M_WAREHOUSE_ID Implied Constraint
X nvarchar2 120  √  null
Y nvarchar2 120  √  null
Z nvarchar2 120  √  null
QTYONHAND number 22
QTYRESERVED number 22
QTYAVAILABLE number 22  √  null
QTYORDERED number 22
DATELASTINVENTORY date 7  √  null
M_ATTRIBUTESETINSTANCE_ID number 10
M_ATTRIBUTESETINSTANCE M_ATTRIBUTESETINSTANCE_ID Implied Constraint
M_ATTRIBUTESET_ID number 10  √  null
M_ATTRIBUTESET M_ATTRIBUTESET_ID Implied Constraint
SERNO nvarchar2 80  √  null
LOT nvarchar2 80  √  null
M_LOT_ID number 10  √  null
M_LOT M_LOT_ID Implied Constraint
GUARANTEEDATE date 7  √  null
SHELFLIFEDAYS number 22  √  null
GOODFORDAYS number 22  √  null
SHELFLIFEREMAININGPCT number 22  √  null
View SQL:
SELECT s.AD_Client_ID, s.AD_Org_ID,
    -- Product
    s.M_Product_ID,p.Value,p.Name,p.Description,p.UPC,p.SKU,
    p.C_UOM_ID,p.M_Product_Category_ID,p.Classification, p.Weight,p.Volume,p.VersionNo,
    p.GuaranteeDays,p.GuaranteeDaysMin,
    --  Locator
    s.M_Locator_ID, l.M_Warehouse_ID, l.X, l.Y, l.Z,
    -- Storage
    s.QtyOnHand, s.QtyReserved, s.QtyOnHand-s.QtyReserved AS QtyAvailable, 
    s.QtyOrdered, s.DateLastInventory,
    -- Instance
    s.M_AttributeSetInstance_ID, asi.M_AttributeSet_ID, asi.SerNo, asi.Lot, asi.M_Lot_ID,
    asi.GuaranteeDate,  -- see PAttributeInstance.java
    daysBetween(asi.GuaranteeDate,getdate()) AS ShelfLifeDays,
    daysBetween(asi.GuaranteeDate,getdate())-p.GuaranteeDaysMin AS GoodForDays,
    ROUND((daysBetween(asi.GuaranteeDate,getdate())/p.GuaranteeDays)*100,0) AS ShelfLifeRemainingPct
FROM M_Storage s
  INNER JOIN M_Locator l ON (s.M_Locator_ID=l.M_Locator_ID)
  INNER JOIN M_Product p ON (s.M_Product_ID=p.M_Product_ID)
  LEFT OUTER JOIN M_AttributeSetInstance asi ON (s.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID)


SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.