You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by jo...@apache.org on 2007/07/27 03:35:28 UTC
svn commit: r560054 -
/ofbiz/trunk/applications/product/entitydef/entitymodel.xml
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"/>