svn commit: r661700 - in /ofbiz/trunk/applications/order/entitydef: entitygroup.xml entitymodel.xml

[mor-2]

Author: mor
Date: Fri May 30 06:03:55 2008
New Revision: 661700

URL: http://svn.apache.org/viewvc?rev=661700&view=rev
Log:
New entity SalesForcastDetail - part of jira issue OFBIZ-194

Modified:
    ofbiz/trunk/applications/order/entitydef/entitygroup.xml
    ofbiz/trunk/applications/order/entitydef/entitymodel.xml

Modified: ofbiz/trunk/applications/order/entitydef/entitygroup.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/order/entitydef/entitygroup.xml?rev=661700&r1=661699&r2=661700&view=diff
==============================================================================
--- ofbiz/trunk/applications/order/entitydef/entitygroup.xml (original)
+++ ofbiz/trunk/applications/order/entitydef/entitygroup.xml Fri May 30 06:03:55 2008
@@ -207,6 +207,7 @@
     <entity-group group="org.ofbiz" entity="SalesOpportunityQuote" />
     <entity-group group="org.ofbiz" entity="SalesOpportunityTrckCode" />
     <entity-group group="org.ofbiz" entity="SalesForecast" />
+    <entity-group group="org.ofbiz" entity="SalesForecastDetail" />
     <entity-group group="org.ofbiz" entity="SalesForecastHistory" />
     <entity-group group="org.ofbiz" entity="SalesForecastAndCustomTimePeriod" />
     

Modified: ofbiz/trunk/applications/order/entitydef/entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/order/entitydef/entitymodel.xml?rev=661700&r1=661699&r2=661700&view=diff
==============================================================================
--- ofbiz/trunk/applications/order/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/applications/order/entitydef/entitymodel.xml Fri May 30 06:03:55 2008
@@ -2879,6 +2879,32 @@
         </relation>
     </entity>
 
+    <entity entity-name="SalesForecastDetail"
+            package-name="org.ofbiz.order.opportunity"
+            title="Stores Details of Resourses of Sales Forecast for simulation of MRP">
+        <field name="salesForecastId" type="id-ne"/>    
+        <field name="salesForecastDetailId" type="id-ne"/>
+        <field name="amount" type="currency-amount"/>
+        <field name="quantityUomId" type="id"/>
+        <field name="quantity" type="floating-point"/>
+        <field name="productId" type="id"/>
+        <field name="productCategoryId" type="id"/>
+        <prim-key field="salesForecastId"/>
+        <prim-key field="salesForecastDetailId"/>
+        <relation type="one" fk-name="SALES4CDTL_SALES4C" rel-entity-name="SalesForecast">
+            <key-map field-name="salesForecastId"/>
+        </relation>
+        <relation type="one" fk-name="SALES4CDTL_QTY_UOM" title="Quantity" rel-entity-name="Uom">
+            <key-map field-name="quantityUomId" rel-field-name="uomId"/>
+        </relation>
+        <relation type="one" fk-name="SALES4CDTL_PROD" rel-entity-name="Product">
+            <key-map field-name="productId"/>
+        </relation>
+        <relation type="one" fk-name="SALES4CDTL_PCTGRY" rel-entity-name="ProductCategory">
+            <key-map field-name="productCategoryId"/>
+        </relation>
+    </entity>
+    
     <entity entity-name="SalesForecastHistory"
             package-name="org.ofbiz.order.opportunity"
             title="Keeps a record of changes to a sales forecast.">