[Warehouse] Add warehouse rules to sampledata
authorSandra Huguet <sandra.huguet@openbravo.com>
Thu, 08 Nov 2012 17:34:27 +0100
changeset 18511 5e3f4e1e01c1
parent 18510 e97cfb32893f
child 18512 c609be6c16ed
[Warehouse] Add warehouse rules to sampledata
referencedata/sampledata/F_B_International_Group.xml
referencedata/sampledata/QA_Testing.xml
src-db/database/sourcedata/AD_DATASET_TABLE.xml
--- a/referencedata/sampledata/F_B_International_Group.xml	Thu Nov 08 17:24:00 2012 +0100
+++ b/referencedata/sampledata/F_B_International_Group.xml	Thu Nov 08 17:34:27 2012 +0100
@@ -42415,6 +42415,33 @@
     <description>Execution process that on negative payments. Sets the leaves the payment amount as credit while modifying the payment's amount to zero.</description>
     <javaClassName>org.openbravo.advpaymentmngt.executionprocess.LeaveAsCredit</javaClassName>
   </FinancialMgmtPaymentExecutionProcess>
+  <WarehouseRule id="6CFB787443074B52AA5E49BDDAA4AD0B">
+    <id>6CFB787443074B52AA5E49BDDAA4AD0B</id>
+    <client id="23C59575B9CF467C9620760EB255B389"/>
+    <organization id="0"/>
+    <active>true</active>
+    <name>Default Warehouse Rule</name>
+    <procedure>M_WAREHOUSE_DEFAULT_RULE</procedure>
+    <description>Useful to overwrite a warehouse rule defined at warehouse on specific documents.</description>
+  </WarehouseRule>
+  <WarehouseRule id="735F422175FE4176815B68B00243385B">
+    <id>735F422175FE4176815B68B00243385B</id>
+    <client id="23C59575B9CF467C9620760EB255B389"/>
+    <organization id="0"/>
+    <active>true</active>
+    <name>Unique Attribute</name>
+    <procedure>M_UNIQUEATTRIBUTE_RULE</procedure>
+    <description>Returns stock of the first attribute set instance in the warehouse with enough stock.</description>
+  </WarehouseRule>
+  <WarehouseRule id="C3A79283EC5F44D59CEDF473D8FBCDC8">
+    <id>C3A79283EC5F44D59CEDF473D8FBCDC8</id>
+    <client id="23C59575B9CF467C9620760EB255B389"/>
+    <organization id="0"/>
+    <active>true</active>
+    <name>Unique Storage Bin</name>
+    <procedure>M_UNIQUELOCATOR_RULE</procedure>
+    <description>Returns stock of the first storage bin in the warehouse with enough stock.</description>
+  </WarehouseRule>
   <ProcessRequest id="0151B27027E44217B2F9FC77DDA10BC7">
     <id>0151B27027E44217B2F9FC77DDA10BC7</id>
     <client id="23C59575B9CF467C9620760EB255B389"/>
@@ -65644,8 +65671,8 @@
     <securityBasedOnRole>true</securityBasedOnRole>
     <openbravoContext>{"org.openbravo.scheduling.ProcessContext":{"user":100,"role":"42D0EEB1C66F497A90DD526DC597E6F0","language":"en_US","theme":"ltr\/org.openbravo.userinterface.skin.250to300Comp\/250to300Comp","client":"23C59575B9CF467C9620760EB255B389","organization":0,"warehouse":"","command":"DEFAULT","userClient":"","userOrganization":"","dbSessionID":"","javaDateFormat":"","jsDateFormat":"","sqlDateFormat":"","accessLevel":"","roleSecurity":true}}</openbravoContext>
     <status>SCH</status>
-    <nextExecution>2012-11-08T13:01:07.0Z</nextExecution>
-    <previousExecution>2012-11-08T13:00:07.0Z</previousExecution>
+    <nextExecution>2012-11-08T17:32:07.0Z</nextExecution>
+    <previousExecution>2012-11-08T17:31:07.0Z</previousExecution>
     <finish xsi:nil="true"/>
     <channel>Process Scheduler</channel>
     <timing>S</timing>
--- a/referencedata/sampledata/QA_Testing.xml	Thu Nov 08 17:24:00 2012 +0100
+++ b/referencedata/sampledata/QA_Testing.xml	Thu Nov 08 17:34:27 2012 +0100
@@ -6683,6 +6683,33 @@
     <description>Simple process that prompts for a check number and sets it as the reference number of the payment.</description>
     <javaClassName>org.openbravo.advpaymentmngt.executionprocess.PrintCheck</javaClassName>
   </FinancialMgmtPaymentExecutionProcess>
+  <WarehouseRule id="33DAC92D21624E0A9D8C537382F2D28C">
+    <id>33DAC92D21624E0A9D8C537382F2D28C</id>
+    <client id="4028E6C72959682B01295A070852010D"/>
+    <organization id="0"/>
+    <active>true</active>
+    <name>Unique Storage Bin</name>
+    <procedure>M_UNIQUELOCATOR_RULE</procedure>
+    <description>Returns stock of the first storage bin in the warehouse with enough stock.</description>
+  </WarehouseRule>
+  <WarehouseRule id="5F23F9B25A834B78A0549AF028E29051">
+    <id>5F23F9B25A834B78A0549AF028E29051</id>
+    <client id="4028E6C72959682B01295A070852010D"/>
+    <organization id="0"/>
+    <active>true</active>
+    <name>Unique Attribute</name>
+    <procedure>M_UNIQUEATTRIBUTE_RULE</procedure>
+    <description>Returns stock of the first attribute set instance in the warehouse with enough stock.</description>
+  </WarehouseRule>
+  <WarehouseRule id="F2DEA5B4C39F4423BF0AAC73DABD4146">
+    <id>F2DEA5B4C39F4423BF0AAC73DABD4146</id>
+    <client id="4028E6C72959682B01295A070852010D"/>
+    <organization id="0"/>
+    <active>true</active>
+    <name>Default Warehouse Rule</name>
+    <procedure>M_WAREHOUSE_DEFAULT_RULE</procedure>
+    <description>Useful to overwrite a warehouse rule defined at warehouse on specific documents.</description>
+  </WarehouseRule>
   <ProcessRequest id="1E1EE06DC9C849C2A15206EC7899C9AB">
     <id>1E1EE06DC9C849C2A15206EC7899C9AB</id>
     <client id="4028E6C72959682B01295A070852010D"/>
--- a/src-db/database/sourcedata/AD_DATASET_TABLE.xml	Thu Nov 08 17:24:00 2012 +0100
+++ b/src-db/database/sourcedata/AD_DATASET_TABLE.xml	Thu Nov 08 17:34:27 2012 +0100
@@ -280,6 +280,20 @@
 <!--0DD1EC601DE74B8F914F09E80F75AE51-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--0DD1EC601DE74B8F914F09E80F75AE51--></AD_DATASET_TABLE>
 
+<!--0EC1B1081A4343939DA72BB0C542FD20--><AD_DATASET_TABLE>
+<!--0EC1B1081A4343939DA72BB0C542FD20-->  <AD_DATASET_TABLE_ID><![CDATA[0EC1B1081A4343939DA72BB0C542FD20]]></AD_DATASET_TABLE_ID>
+<!--0EC1B1081A4343939DA72BB0C542FD20-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0EC1B1081A4343939DA72BB0C542FD20-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0EC1B1081A4343939DA72BB0C542FD20-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0EC1B1081A4343939DA72BB0C542FD20-->  <AD_DATASET_ID><![CDATA[D81C5C810AEF47C690E4F688ABC8AAC8]]></AD_DATASET_ID>
+<!--0EC1B1081A4343939DA72BB0C542FD20-->  <AD_TABLE_ID><![CDATA[8D057FD1218B44C3BD5B97DA65A6E3C1]]></AD_TABLE_ID>
+<!--0EC1B1081A4343939DA72BB0C542FD20-->  <INCLUDEALLCOLUMNS><![CDATA[Y]]></INCLUDEALLCOLUMNS>
+<!--0EC1B1081A4343939DA72BB0C542FD20-->  <WHERECLAUSE><![CDATA[client.id=:ClientID]]></WHERECLAUSE>
+<!--0EC1B1081A4343939DA72BB0C542FD20-->  <EXCLUDEAUDITINFO><![CDATA[N]]></EXCLUDEAUDITINFO>
+<!--0EC1B1081A4343939DA72BB0C542FD20-->  <ISBUSINESSOBJECT><![CDATA[N]]></ISBUSINESSOBJECT>
+<!--0EC1B1081A4343939DA72BB0C542FD20-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--0EC1B1081A4343939DA72BB0C542FD20--></AD_DATASET_TABLE>
+
 <!--0EC7C0E18259457CAA1B443CD87CF621--><AD_DATASET_TABLE>
 <!--0EC7C0E18259457CAA1B443CD87CF621-->  <AD_DATASET_TABLE_ID><![CDATA[0EC7C0E18259457CAA1B443CD87CF621]]></AD_DATASET_TABLE_ID>
 <!--0EC7C0E18259457CAA1B443CD87CF621-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>