[Warehouse]Fixes in fields and unique locator rule.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Tue, 09 Oct 2012 16:53:25 +0200
changeset 18642 fce0cb0998d9
parent 18641 1a1231b55075
child 18643 923d07185690
[Warehouse]Fixes in fields and unique locator rule.
src-db/database/model/functions/M_UNIQUELOCATOR_RULE.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/model/functions/M_UNIQUELOCATOR_RULE.xml	Tue Oct 09 16:53:02 2012 +0200
+++ b/src-db/database/model/functions/M_UNIQUELOCATOR_RULE.xml	Tue Oct 09 16:53:25 2012 +0200
@@ -63,7 +63,7 @@
         AND l.m_warehouse_id = p_warehouse_id
       GROUP BY t.m_locator_id
       HAVING sum(ms.quantity) >= v_quantity
-      ORDER BY ms.priority
+      ORDER BY MIN(ms.priority)
   ) LOOP
     v_selectedlocatorid := cur_mstock.m_locator_id;
     EXIT;
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Tue Oct 09 16:53:02 2012 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Tue Oct 09 16:53:25 2012 +0200
@@ -291878,6 +291878,8 @@
 <!--CB9E2FD2CC3EDE61E040007F010001E1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--CB9E2FD2CC3EDE61E040007F010001E1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--CB9E2FD2CC3EDE61E040007F010001E1-->  <NAME><![CDATA[Description]]></NAME>
+<!--CB9E2FD2CC3EDE61E040007F010001E1-->  <DESCRIPTION><![CDATA[A space to write additional related information.]]></DESCRIPTION>
+<!--CB9E2FD2CC3EDE61E040007F010001E1-->  <HELP><![CDATA[A description is limited to 255 characters.]]></HELP>
 <!--CB9E2FD2CC3EDE61E040007F010001E1-->  <COLUMNNAME><![CDATA[Description]]></COLUMNNAME>
 <!--CB9E2FD2CC3EDE61E040007F010001E1-->  <AD_TABLE_ID><![CDATA[8D057FD1218B44C3BD5B97DA65A6E3C1]]></AD_TABLE_ID>
 <!--CB9E2FD2CC3EDE61E040007F010001E1-->  <AD_REFERENCE_ID><![CDATA[14]]></AD_REFERENCE_ID>
@@ -291891,6 +291893,7 @@
 <!--CB9E2FD2CC3EDE61E040007F010001E1-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--CB9E2FD2CC3EDE61E040007F010001E1-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--CB9E2FD2CC3EDE61E040007F010001E1-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--CB9E2FD2CC3EDE61E040007F010001E1-->  <AD_ELEMENT_ID><![CDATA[275]]></AD_ELEMENT_ID>
 <!--CB9E2FD2CC3EDE61E040007F010001E1-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
 <!--CB9E2FD2CC3EDE61E040007F010001E1-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--CB9E2FD2CC3EDE61E040007F010001E1-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
@@ -291943,7 +291946,8 @@
 <!--CB9E308EE8DFDCBAE040007F010001E7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--CB9E308EE8DFDCBAE040007F010001E7-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--CB9E308EE8DFDCBAE040007F010001E7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--CB9E308EE8DFDCBAE040007F010001E7-->  <NAME><![CDATA[M_Warehouse_Rule_ID]]></NAME>
+<!--CB9E308EE8DFDCBAE040007F010001E7-->  <NAME><![CDATA[Warehouse Rule]]></NAME>
+<!--CB9E308EE8DFDCBAE040007F010001E7-->  <HELP><![CDATA[Definition of a Warehouse Rule to be applied when getting stock from the warehouse.]]></HELP>
 <!--CB9E308EE8DFDCBAE040007F010001E7-->  <COLUMNNAME><![CDATA[M_Warehouse_Rule_ID]]></COLUMNNAME>
 <!--CB9E308EE8DFDCBAE040007F010001E7-->  <AD_TABLE_ID><![CDATA[260]]></AD_TABLE_ID>
 <!--CB9E308EE8DFDCBAE040007F010001E7-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
@@ -291957,6 +291961,7 @@
 <!--CB9E308EE8DFDCBAE040007F010001E7-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--CB9E308EE8DFDCBAE040007F010001E7-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--CB9E308EE8DFDCBAE040007F010001E7-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--CB9E308EE8DFDCBAE040007F010001E7-->  <AD_ELEMENT_ID><![CDATA[CB8AD3FC3535A9FCE040007F01002CB2]]></AD_ELEMENT_ID>
 <!--CB9E308EE8DFDCBAE040007F010001E7-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
 <!--CB9E308EE8DFDCBAE040007F010001E7-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--CB9E308EE8DFDCBAE040007F010001E7-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Tue Oct 09 16:53:02 2012 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Tue Oct 09 16:53:25 2012 +0200
@@ -232149,7 +232149,8 @@
 <!--CB9E2FD2CC1FDE61E040007F010001E1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--CB9E2FD2CC1FDE61E040007F010001E1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--CB9E2FD2CC1FDE61E040007F010001E1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--CB9E2FD2CC1FDE61E040007F010001E1-->  <NAME><![CDATA[M_Warehouse_Rule_ID]]></NAME>
+<!--CB9E2FD2CC1FDE61E040007F010001E1-->  <NAME><![CDATA[Warehouse Rule]]></NAME>
+<!--CB9E2FD2CC1FDE61E040007F010001E1-->  <HELP><![CDATA[Definition of a Warehouse Rule to be applied when getting stock from the warehouse.]]></HELP>
 <!--CB9E2FD2CC1FDE61E040007F010001E1-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--CB9E2FD2CC1FDE61E040007F010001E1-->  <AD_TAB_ID><![CDATA[187]]></AD_TAB_ID>
 <!--CB9E2FD2CC1FDE61E040007F010001E1-->  <AD_COLUMN_ID><![CDATA[CB9E308EE8DFDCBAE040007F010001E7]]></AD_COLUMN_ID>
@@ -232177,6 +232178,8 @@
 <!--CB9E2FD2CC3FDE61E040007F010001E1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--CB9E2FD2CC3FDE61E040007F010001E1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--CB9E2FD2CC3FDE61E040007F010001E1-->  <NAME><![CDATA[Description]]></NAME>
+<!--CB9E2FD2CC3FDE61E040007F010001E1-->  <DESCRIPTION><![CDATA[A space to write additional related information.]]></DESCRIPTION>
+<!--CB9E2FD2CC3FDE61E040007F010001E1-->  <HELP><![CDATA[A description is limited to 255 characters.]]></HELP>
 <!--CB9E2FD2CC3FDE61E040007F010001E1-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--CB9E2FD2CC3FDE61E040007F010001E1-->  <AD_TAB_ID><![CDATA[8A7BC392A4D548E1B97E11548E20E5F2]]></AD_TAB_ID>
 <!--CB9E2FD2CC3FDE61E040007F010001E1-->  <AD_COLUMN_ID><![CDATA[CB9E2FD2CC3EDE61E040007F010001E1]]></AD_COLUMN_ID>
@@ -232259,7 +232262,8 @@
 <!--CB9F7E1068589731E040007F01000F07-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--CB9F7E1068589731E040007F01000F07-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--CB9F7E1068589731E040007F01000F07-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--CB9F7E1068589731E040007F01000F07-->  <NAME><![CDATA[M_Warehouse_Rule_ID]]></NAME>
+<!--CB9F7E1068589731E040007F01000F07-->  <NAME><![CDATA[Warehouse Rule]]></NAME>
+<!--CB9F7E1068589731E040007F01000F07-->  <HELP><![CDATA[Definition of a Warehouse Rule to be applied when getting stock from the warehouse.]]></HELP>
 <!--CB9F7E1068589731E040007F01000F07-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--CB9F7E1068589731E040007F01000F07-->  <AD_TAB_ID><![CDATA[387B6179438D4C4CB40769A77F4C304C]]></AD_TAB_ID>
 <!--CB9F7E1068589731E040007F01000F07-->  <AD_COLUMN_ID><![CDATA[CB9E308EE8DFDCBAE040007F010001E7]]></AD_COLUMN_ID>
@@ -232284,7 +232288,8 @@
 <!--CB9F7E1068599731E040007F01000F07-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--CB9F7E1068599731E040007F01000F07-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--CB9F7E1068599731E040007F01000F07-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--CB9F7E1068599731E040007F01000F07-->  <NAME><![CDATA[M_Warehouse_Rule_ID]]></NAME>
+<!--CB9F7E1068599731E040007F01000F07-->  <NAME><![CDATA[Warehouse Rule]]></NAME>
+<!--CB9F7E1068599731E040007F01000F07-->  <HELP><![CDATA[Definition of a Warehouse Rule to be applied when getting stock from the warehouse.]]></HELP>
 <!--CB9F7E1068599731E040007F01000F07-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--CB9F7E1068599731E040007F01000F07-->  <AD_TAB_ID><![CDATA[AF4090093D471431E040007F010048A5]]></AD_TAB_ID>
 <!--CB9F7E1068599731E040007F01000F07-->  <AD_COLUMN_ID><![CDATA[CB9E308EE8DFDCBAE040007F010001E7]]></AD_COLUMN_ID>
@@ -232309,7 +232314,8 @@
 <!--CB9F7E1068619731E040007F01000F07-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--CB9F7E1068619731E040007F01000F07-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--CB9F7E1068619731E040007F01000F07-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--CB9F7E1068619731E040007F01000F07-->  <NAME><![CDATA[M_Warehouse_Rule_ID]]></NAME>
+<!--CB9F7E1068619731E040007F01000F07-->  <NAME><![CDATA[Warehouse Rule]]></NAME>
+<!--CB9F7E1068619731E040007F01000F07-->  <HELP><![CDATA[Definition of a Warehouse Rule to be applied when getting stock from the warehouse.]]></HELP>
 <!--CB9F7E1068619731E040007F01000F07-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--CB9F7E1068619731E040007F01000F07-->  <AD_TAB_ID><![CDATA[293]]></AD_TAB_ID>
 <!--CB9F7E1068619731E040007F01000F07-->  <AD_COLUMN_ID><![CDATA[CB9E308EE8DFDCBAE040007F010001E7]]></AD_COLUMN_ID>