svn commit: r560054 - /ofbiz/trunk/applications/product/entitydef/entitymodel.xml

[jonesde]

Author: jonesde
Date: Thu Jul 26 18:35:27 2007
New Revision: 560054

URL: http://svn.apache.org/viewvc?view=rev&rev=560054
Log:
Added inventoryItemTypeId to the two views for getting QOH totals at a certain point in time, make sure we don't have any overlap

Modified:
    ofbiz/trunk/applications/product/entitydef/entitymodel.xml

Modified: ofbiz/trunk/applications/product/entitydef/entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/product/entitydef/entitymodel.xml?view=diff&rev=560054&r1=560053&r2=560054
==============================================================================
--- ofbiz/trunk/applications/product/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/applications/product/entitydef/entitymodel.xml Thu Jul 26 18:35:27 2007
@@ -1291,6 +1291,7 @@
         <member-entity entity-alias="II" entity-name="InventoryItem"/>        
         <member-entity entity-alias="IID" entity-name="InventoryItemDetail"/>
         <alias entity-alias="IID" name="quantityOnHandSum" field="quantityOnHandDiff" function="sum"/>
+        <alias entity-alias="II" name="inventoryItemTypeId" group-by="true"></alias>
         <alias entity-alias="II" name="facilityId" group-by="true"></alias>
         <alias entity-alias="II" name="productId" group-by="true"></alias>
         <alias entity-alias="IID" name="effectiveDate"><description>For query only, not in fields to select.</description></alias>  
@@ -1322,6 +1323,7 @@
         <member-entity entity-alias="IIS" entity-name="InventoryItemStatus"/>
         <member-entity entity-alias="II" entity-name="InventoryItem"/>
         <alias name="facilityId" entity-alias="II"/>
+        <alias name="inventoryItemTypeId" entity-alias="II"/>
         <alias name="inventoryItemId" entity-alias="IIS"/>
         <alias name="productId" entity-alias="IIS"><description>Note that this is from the status entity because it may change over time.</description></alias>
         <alias name="statusId" entity-alias="IIS"/>