Process Plan Header fields and estimated time trigger
authorrafaeldemiguel <rdm@openbravo.com>
Wed, 24 Aug 2011 10:21:34 +0200
changeset 14970 f27ae92d213a
parent 13522 e303b38f24e9
child 14971 647881af7155
Process Plan Header fields and estimated time trigger
src-db/database/model/tables/MA_PROCESSPLAN_VERSION.xml
src-db/database/model/tables/MA_SEQUENCE.xml
src-db/database/model/triggers/MA_SEQUENCE_TRG.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/model/tables/MA_PROCESSPLAN_VERSION.xml	Fri Aug 12 10:45:34 2011 +0000
+++ b/src-db/database/model/tables/MA_PROCESSPLAN_VERSION.xml	Wed Aug 24 10:21:34 2011 +0200
@@ -49,6 +49,10 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="ESTIMATEDTIME" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_ORG" name="AD_ORG_MAPROCESSPLANVERSION">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
--- a/src-db/database/model/tables/MA_SEQUENCE.xml	Fri Aug 12 10:45:34 2011 +0000
+++ b/src-db/database/model/tables/MA_SEQUENCE.xml	Wed Aug 24 10:21:34 2011 +0200
@@ -97,6 +97,14 @@
         <default><![CDATA[Y]]></default>
         <onCreateDefault/>
       </column>
+      <column name="ESTIMATEDTIME" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
+        <default><![CDATA[0]]></default>
+        <onCreateDefault><![CDATA[0]]></onCreateDefault>
+      </column>
+      <column name="DIVISIONGROUPQTY" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_ORG" name="AD_ORG_MASEQUENCE">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src-db/database/model/triggers/MA_SEQUENCE_TRG.xml	Wed Aug 24 10:21:34 2011 +0200
@@ -0,0 +1,49 @@
+<?xml version="1.0"?>
+  <database name="TRIGGER MA_SEQUENCE_TRG">
+    <trigger name="MA_SEQUENCE_TRG" table="MA_SEQUENCE" fires="after" insert="true" update="true" delete="true" foreach="row">
+      <body><![CDATA[
+/*************************************************************************
+* The contents of this file are subject to the Openbravo  Public  License
+* Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
+* Version 1.1  with a permitted attribution clause; you may not  use this
+* file except in compliance with the License. You  may  obtain  a copy of
+* the License at http://www.openbravo.com/legal/license.html
+* Software distributed under the License  is  distributed  on  an "AS IS"
+* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+* License for the specific  language  governing  rights  and  limitations
+* under the License.
+* The Original Code is Openbravo ERP.
+* The Initial Developer of the Original Code is Openbravo SLU
+* All portions are Copyright (C) 2001-2010 Openbravo SLU
+* All Rights Reserved.
+* Contributor(s):  ______________________________________.
+************************************************************************/
+
+    
+BEGIN
+    
+    IF AD_isTriggerEnabled()='N' THEN RETURN;
+    END IF;
+
+IF (INSERTING) THEN
+	UPDATE MA_PROCESSPLAN_VERSION 
+	SET ESTIMATEDTIME = ESTIMATEDTIME + :NEW.ESTIMATEDTIME
+	WHERE MA_PROCESSPLAN_VERSION_ID = :NEW.MA_PROCESSPLAN_VERSION_ID;
+END IF;
+
+IF (UPDATING) THEN
+	UPDATE MA_PROCESSPLAN_VERSION 
+	SET ESTIMATEDTIME = ESTIMATEDTIME + :NEW.ESTIMATEDTIME - :OLD.ESTIMATEDTIME
+	WHERE MA_PROCESSPLAN_VERSION_ID = :NEW.MA_PROCESSPLAN_VERSION_ID;
+END IF;
+
+IF (DELETING) THEN
+	UPDATE MA_PROCESSPLAN_VERSION 
+	SET ESTIMATEDTIME = ESTIMATEDTIME - :OLD.ESTIMATEDTIME
+	WHERE MA_PROCESSPLAN_VERSION_ID = :OLD.MA_PROCESSPLAN_VERSION_ID;
+END IF;
+
+END MA_SEQUENCE_TRG
+]]></body>
+    </trigger>
+  </database>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Fri Aug 12 10:45:34 2011 +0000
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Wed Aug 24 10:21:34 2011 +0200
@@ -224070,6 +224070,40 @@
 <!--592C52B8FE6B473C9E374B40B09A7194-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--592C52B8FE6B473C9E374B40B09A7194--></AD_COLUMN>
 
+<!--5968D63AD3FB4C039F459EF1EA03BDE1--><AD_COLUMN>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <AD_COLUMN_ID><![CDATA[5968D63AD3FB4C039F459EF1EA03BDE1]]></AD_COLUMN_ID>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <NAME><![CDATA[Estimatedtime]]></NAME>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <DESCRIPTION><![CDATA[Estimated time for the operation]]></DESCRIPTION>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <HELP><![CDATA[Estimated time for the operation]]></HELP>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <COLUMNNAME><![CDATA[Estimatedtime]]></COLUMNNAME>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <AD_TABLE_ID><![CDATA[800125]]></AD_TABLE_ID>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <AD_REFERENCE_ID><![CDATA[22]]></AD_REFERENCE_ID>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <DEFAULTVALUE><![CDATA[0]]></DEFAULTVALUE>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <SEQNO><![CDATA[130]]></SEQNO>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <AD_ELEMENT_ID><![CDATA[5BCA37B278504F459215615AABC0BF2C]]></AD_ELEMENT_ID>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <POSITION><![CDATA[13]]></POSITION>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--5968D63AD3FB4C039F459EF1EA03BDE1--></AD_COLUMN>
+
 <!--59C4D0498A3471B8E040007F010133FD--><AD_COLUMN>
 <!--59C4D0498A3471B8E040007F010133FD-->  <AD_COLUMN_ID><![CDATA[59C4D0498A3471B8E040007F010133FD]]></AD_COLUMN_ID>
 <!--59C4D0498A3471B8E040007F010133FD-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -237484,6 +237518,39 @@
 <!--7C4AEC0BF04F4588A2D26D46E1EE0E7B-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--7C4AEC0BF04F4588A2D26D46E1EE0E7B--></AD_COLUMN>
 
+<!--7D9C264F6B3040B89A939CC2E857E149--><AD_COLUMN>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <AD_COLUMN_ID><![CDATA[7D9C264F6B3040B89A939CC2E857E149]]></AD_COLUMN_ID>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <NAME><![CDATA[Divisiongroupqty]]></NAME>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <DESCRIPTION><![CDATA[Indicates the quantity in which P+ products will be grouped ]]></DESCRIPTION>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <HELP><![CDATA[Indicates the quantity in which P+ products will be grouped]]></HELP>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <COLUMNNAME><![CDATA[Divisiongroupqty]]></COLUMNNAME>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <AD_TABLE_ID><![CDATA[800096]]></AD_TABLE_ID>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <SEQNO><![CDATA[300]]></SEQNO>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <AD_ELEMENT_ID><![CDATA[687290BF756545829E283A6AF2CC2576]]></AD_ELEMENT_ID>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <POSITION><![CDATA[26]]></POSITION>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--7D9C264F6B3040B89A939CC2E857E149-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--7D9C264F6B3040B89A939CC2E857E149--></AD_COLUMN>
+
 <!--7DBD795B18BA4B6589BAADF480BD0440--><AD_COLUMN>
 <!--7DBD795B18BA4B6589BAADF480BD0440-->  <AD_COLUMN_ID><![CDATA[7DBD795B18BA4B6589BAADF480BD0440]]></AD_COLUMN_ID>
 <!--7DBD795B18BA4B6589BAADF480BD0440-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -260184,6 +260251,40 @@
 <!--D8C00B0F9EC14D17AEE6EB72D9E871E1-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--D8C00B0F9EC14D17AEE6EB72D9E871E1--></AD_COLUMN>
 
+<!--D952D13F51DD4BE390C2BDBD7D09C377--><AD_COLUMN>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <AD_COLUMN_ID><![CDATA[D952D13F51DD4BE390C2BDBD7D09C377]]></AD_COLUMN_ID>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <NAME><![CDATA[Estimated Time]]></NAME>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <DESCRIPTION><![CDATA[Estimated time for the operation]]></DESCRIPTION>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <HELP><![CDATA[Estimated time for the operation]]></HELP>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <COLUMNNAME><![CDATA[Estimatedtime]]></COLUMNNAME>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <AD_TABLE_ID><![CDATA[800096]]></AD_TABLE_ID>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <AD_REFERENCE_ID><![CDATA[22]]></AD_REFERENCE_ID>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <DEFAULTVALUE><![CDATA[0]]></DEFAULTVALUE>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <SEQNO><![CDATA[310]]></SEQNO>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <AD_ELEMENT_ID><![CDATA[5BCA37B278504F459215615AABC0BF2C]]></AD_ELEMENT_ID>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <POSITION><![CDATA[25]]></POSITION>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--D952D13F51DD4BE390C2BDBD7D09C377-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--D952D13F51DD4BE390C2BDBD7D09C377--></AD_COLUMN>
+
 <!--D982E3A4B4B7495689D960E855F9DFD5--><AD_COLUMN>
 <!--D982E3A4B4B7495689D960E855F9DFD5-->  <AD_COLUMN_ID><![CDATA[D982E3A4B4B7495689D960E855F9DFD5]]></AD_COLUMN_ID>
 <!--D982E3A4B4B7495689D960E855F9DFD5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Fri Aug 12 10:45:34 2011 +0000
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Wed Aug 24 10:21:34 2011 +0200
@@ -21781,6 +21781,19 @@
 <!--5BA951974876BDB2E040007F01011671-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--5BA951974876BDB2E040007F01011671--></AD_ELEMENT>
 
+<!--5BCA37B278504F459215615AABC0BF2C--><AD_ELEMENT>
+<!--5BCA37B278504F459215615AABC0BF2C-->  <AD_ELEMENT_ID><![CDATA[5BCA37B278504F459215615AABC0BF2C]]></AD_ELEMENT_ID>
+<!--5BCA37B278504F459215615AABC0BF2C-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5BCA37B278504F459215615AABC0BF2C-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5BCA37B278504F459215615AABC0BF2C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5BCA37B278504F459215615AABC0BF2C-->  <COLUMNNAME><![CDATA[Estimatedtime]]></COLUMNNAME>
+<!--5BCA37B278504F459215615AABC0BF2C-->  <NAME><![CDATA[Estimated Time]]></NAME>
+<!--5BCA37B278504F459215615AABC0BF2C-->  <PRINTNAME><![CDATA[Estimated Time]]></PRINTNAME>
+<!--5BCA37B278504F459215615AABC0BF2C-->  <DESCRIPTION><![CDATA[Estimated time for the operation]]></DESCRIPTION>
+<!--5BCA37B278504F459215615AABC0BF2C-->  <HELP><![CDATA[Estimated time for the operation]]></HELP>
+<!--5BCA37B278504F459215615AABC0BF2C-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--5BCA37B278504F459215615AABC0BF2C--></AD_ELEMENT>
+
 <!--5BE187236833538BE040007F010169BF--><AD_ELEMENT>
 <!--5BE187236833538BE040007F010169BF-->  <AD_ELEMENT_ID><![CDATA[5BE187236833538BE040007F010169BF]]></AD_ELEMENT_ID>
 <!--5BE187236833538BE040007F010169BF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -22104,6 +22117,19 @@
 <!--6860321CEBD211DD85DF0016D4EE9DB3-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--6860321CEBD211DD85DF0016D4EE9DB3--></AD_ELEMENT>
 
+<!--687290BF756545829E283A6AF2CC2576--><AD_ELEMENT>
+<!--687290BF756545829E283A6AF2CC2576-->  <AD_ELEMENT_ID><![CDATA[687290BF756545829E283A6AF2CC2576]]></AD_ELEMENT_ID>
+<!--687290BF756545829E283A6AF2CC2576-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--687290BF756545829E283A6AF2CC2576-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--687290BF756545829E283A6AF2CC2576-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--687290BF756545829E283A6AF2CC2576-->  <COLUMNNAME><![CDATA[Divisiongroupqty]]></COLUMNNAME>
+<!--687290BF756545829E283A6AF2CC2576-->  <NAME><![CDATA[Division Group Quantity]]></NAME>
+<!--687290BF756545829E283A6AF2CC2576-->  <PRINTNAME><![CDATA[Division Group Quantity]]></PRINTNAME>
+<!--687290BF756545829E283A6AF2CC2576-->  <DESCRIPTION><![CDATA[Indicates the quantity in which P+ products will be grouped ]]></DESCRIPTION>
+<!--687290BF756545829E283A6AF2CC2576-->  <HELP><![CDATA[Indicates the quantity in which P+ products will be grouped]]></HELP>
+<!--687290BF756545829E283A6AF2CC2576-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--687290BF756545829E283A6AF2CC2576--></AD_ELEMENT>
+
 <!--69C0AB4BC5474357B8119A12E75FBBA9--><AD_ELEMENT>
 <!--69C0AB4BC5474357B8119A12E75FBBA9-->  <AD_ELEMENT_ID><![CDATA[69C0AB4BC5474357B8119A12E75FBBA9]]></AD_ELEMENT_ID>
 <!--69C0AB4BC5474357B8119A12E75FBBA9-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Fri Aug 12 10:45:34 2011 +0000
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Wed Aug 24 10:21:34 2011 +0200
@@ -163680,6 +163680,33 @@
 <!--18DA0F94F716487DB3B71E4466231D94-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--18DA0F94F716487DB3B71E4466231D94--></AD_FIELD>
 
+<!--18EEEC623C8947E6961F9C4C7943F1AD--><AD_FIELD>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <AD_FIELD_ID><![CDATA[18EEEC623C8947E6961F9C4C7943F1AD]]></AD_FIELD_ID>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <NAME><![CDATA[Estimated Time]]></NAME>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <DESCRIPTION><![CDATA[Estimated time for the operation]]></DESCRIPTION>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <HELP><![CDATA[Estimated time for the operation]]></HELP>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <AD_TAB_ID><![CDATA[800146]]></AD_TAB_ID>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <AD_COLUMN_ID><![CDATA[5968D63AD3FB4C039F459EF1EA03BDE1]]></AD_COLUMN_ID>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <GRID_SEQNO><![CDATA[50]]></GRID_SEQNO>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--18EEEC623C8947E6961F9C4C7943F1AD-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--18EEEC623C8947E6961F9C4C7943F1AD--></AD_FIELD>
+
 <!--195CCC8EDC094481AAF5ACA4F6381E09--><AD_FIELD>
 <!--195CCC8EDC094481AAF5ACA4F6381E09-->  <AD_FIELD_ID><![CDATA[195CCC8EDC094481AAF5ACA4F6381E09]]></AD_FIELD_ID>
 <!--195CCC8EDC094481AAF5ACA4F6381E09-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -164790,6 +164817,33 @@
 <!--2DFC15C032E841C9A8261D197A44AA86-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--2DFC15C032E841C9A8261D197A44AA86--></AD_FIELD>
 
+<!--2E2587D8ADA54D739F1AFAFD9120C602--><AD_FIELD>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <AD_FIELD_ID><![CDATA[2E2587D8ADA54D739F1AFAFD9120C602]]></AD_FIELD_ID>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <NAME><![CDATA[Division Group Quantity]]></NAME>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <DESCRIPTION><![CDATA[Indicates the quantity in which P+ products will be grouped ]]></DESCRIPTION>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <HELP><![CDATA[Indicates the quantity in which P+ products will be grouped]]></HELP>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <AD_TAB_ID><![CDATA[800109]]></AD_TAB_ID>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <AD_COLUMN_ID><![CDATA[7D9C264F6B3040B89A939CC2E857E149]]></AD_COLUMN_ID>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <SEQNO><![CDATA[85]]></SEQNO>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <GRID_SEQNO><![CDATA[85]]></GRID_SEQNO>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--2E2587D8ADA54D739F1AFAFD9120C602-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--2E2587D8ADA54D739F1AFAFD9120C602--></AD_FIELD>
+
 <!--2EAC51CA976642A6A24F72CB4A57DF2E--><AD_FIELD>
 <!--2EAC51CA976642A6A24F72CB4A57DF2E-->  <AD_FIELD_ID><![CDATA[2EAC51CA976642A6A24F72CB4A57DF2E]]></AD_FIELD_ID>
 <!--2EAC51CA976642A6A24F72CB4A57DF2E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -190097,6 +190151,33 @@
 <!--B5B19E73B9AF4A7F8BDF45C44CAF0A90-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--B5B19E73B9AF4A7F8BDF45C44CAF0A90--></AD_FIELD>
 
+<!--B69D72C0C3464AF99C5448C06A6C881A--><AD_FIELD>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <AD_FIELD_ID><![CDATA[B69D72C0C3464AF99C5448C06A6C881A]]></AD_FIELD_ID>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <NAME><![CDATA[Estimated Time]]></NAME>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <DESCRIPTION><![CDATA[Estimated time for the operation]]></DESCRIPTION>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <HELP><![CDATA[Estimated time for the operation]]></HELP>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <AD_TAB_ID><![CDATA[800109]]></AD_TAB_ID>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <AD_COLUMN_ID><![CDATA[D952D13F51DD4BE390C2BDBD7D09C377]]></AD_COLUMN_ID>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <DISPLAYLENGTH><![CDATA[2]]></DISPLAYLENGTH>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <SEQNO><![CDATA[45]]></SEQNO>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <GRID_SEQNO><![CDATA[45]]></GRID_SEQNO>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--B69D72C0C3464AF99C5448C06A6C881A-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--B69D72C0C3464AF99C5448C06A6C881A--></AD_FIELD>
+
 <!--B69E1F6A0B104339B0FDAB3F65C905EB--><AD_FIELD>
 <!--B69E1F6A0B104339B0FDAB3F65C905EB-->  <AD_FIELD_ID><![CDATA[B69E1F6A0B104339B0FDAB3F65C905EB]]></AD_FIELD_ID>
 <!--B69E1F6A0B104339B0FDAB3F65C905EB-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>