[Production-Development] Triggers, DisplayLogics and ReadonlyLogics for windows WorkEffort and Production Run
authorrafaeldemiguel <rdm@openbravo.com>
Thu, 22 Sep 2011 18:28:46 +0200
changeset 14983 fcf3ccf492f3
parent 14982 0efd2107a1a5
child 14984 683e0e1ac318
[Production-Development] Triggers, DisplayLogics and ReadonlyLogics for windows WorkEffort and Production Run
src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml
src-db/database/model/tables/MA_PL_EMPLOYEE.xml
src-db/database/model/triggers/MA_WRPHASE_TRG.xml
src-db/database/sourcedata/AD_AUXILIARINPUT.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_PROCESS.xml
src/org/openbravo/erpCommon/ad_actionButton/SequenceProductCreate.java
src/org/openbravo/erpCommon/ad_callouts/SL_SequenceProduct_Product_Attribute.java
--- a/src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml	Mon Sep 19 19:12:18 2011 +0200
+++ b/src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml	Thu Sep 22 18:28:46 2011 +0200
@@ -16,7 +16,7 @@
 * 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 portions are Copyright (C) 2001-2011 Openbravo SLU
 * All Rights Reserved.
 * Contributor(s):  ______________________________________.
 ************************************************************************/
@@ -67,6 +67,7 @@
     v_AD_Org_ID VARCHAR2(32);
     v_prodline NUMBER;
     v_line NUMBER;
+    v_AD_Pinstance_ID VARCHAR2(32);
   BEGIN
     -- Process Parameters
     IF(p_PInstance_ID IS NOT NULL) THEN
@@ -328,15 +329,29 @@
         (SELECT *  FROM M_PRODUCTIONPLAN pp  WHERE pp.M_PRODUCTION_ID=v_Record_ID)
       LOOP
         UPDATE MA_WRPHASE
-          SET DONEQUANTITY=DONEQUANTITY + Cur_ProductionPlan.PRODUCTIONQTY
+          SET DONEQUANTITY=DONEQUANTITY + Cur_ProductionPlan.PRODUCTIONQTY, RUNTIME=Cur_ProductionPlan.RUNTIME
         WHERE MA_WRPhase_ID=Cur_ProductionPlan.MA_WRPHASE_ID;
+        -- Close Phase if its marked
+	IF (Cur_ProductionPlan.CLOSEPHASE='Y') THEN
+	  v_AD_Pinstance_ID := GET_UUID();
+	  INSERT INTO AD_PINSTANCE 
+	  (AD_PINSTANCE_ID, AD_PROCESS_ID, RECORD_ID, ISACTIVE, 
+	  AD_USER_ID, AD_CLIENT_ID, AD_ORG_ID, CREATED, CREATEDBY,
+	  UPDATED, UPDATEDBY)
+	  VALUES
+	  (v_AD_Pinstance_ID,'800118',Cur_ProductionPlan.MA_WRPHASE_ID,'Y',
+	  v_User_ID, v_Client_ID, v_Org_ID, now(), v_User_ID,
+	  now(), v_User_ID
+	  );
+	  MA_WRPHASE_CLOSE(v_AD_Pinstance_ID);
+	END IF;
       END LOOP;
       -- Indicate that we are done
       UPDATE M_PRODUCTION
         SET Processed='Y',
         updated=now(),
         updatedby=v_User_ID
-      WHERE M_Production_ID=v_Record_ID;
+      WHERE M_Production_ID=v_Record_ID;    
     END IF; --FINISH_PROCESS
     IF(NOT FINISH_PROCESS) THEN
       v_ResultStr:='Updating used toolsets';
--- a/src-db/database/model/tables/MA_PL_EMPLOYEE.xml	Mon Sep 19 19:12:18 2011 +0200
+++ b/src-db/database/model/tables/MA_PL_EMPLOYEE.xml	Thu Sep 22 18:28:46 2011 +0200
@@ -49,14 +49,14 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="REALQUANTITY" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
-        <default><![CDATA[0]]></default>
-        <onCreateDefault><![CDATA[0]]></onCreateDefault>
-      </column>
       <column name="C_BPARTNER_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="RUNTIME" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
+        <default><![CDATA[0]]></default>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_CLIENT" name="MA_PL_EMPLOYEE_AD_CLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
--- a/src-db/database/model/triggers/MA_WRPHASE_TRG.xml	Mon Sep 19 19:12:18 2011 +0200
+++ b/src-db/database/model/triggers/MA_WRPHASE_TRG.xml	Thu Sep 22 18:28:46 2011 +0200
@@ -27,19 +27,19 @@
 
 IF (INSERTING) THEN
 	UPDATE MA_WORKREQUIREMENT 
-	SET ESTIMATEDTIME = ESTIMATEDTIME + :NEW.ESTIMATEDTIME
+	SET ESTIMATEDTIME = ESTIMATEDTIME + :NEW.ESTIMATEDTIME, RUNTIME = RUNTIME + :NEW.RUNTIME
 	WHERE MA_WORKREQUIREMENT_ID = :NEW.MA_WORKREQUIREMENT_ID;
 END IF;
 
 IF (UPDATING) THEN
 	UPDATE MA_WORKREQUIREMENT 
-	SET ESTIMATEDTIME = ESTIMATEDTIME + :NEW.ESTIMATEDTIME - :OLD.ESTIMATEDTIME
+	SET ESTIMATEDTIME = ESTIMATEDTIME + :NEW.ESTIMATEDTIME - :OLD.ESTIMATEDTIME, RUNTIME = RUNTIME + :NEW.RUNTIME - :OLD.RUNTIME
 	WHERE MA_WORKREQUIREMENT_ID = :NEW.MA_WORKREQUIREMENT_ID;
 END IF;
 
 IF (DELETING) THEN
 	UPDATE MA_WORKREQUIREMENT 
-	SET ESTIMATEDTIME = ESTIMATEDTIME - :OLD.ESTIMATEDTIME
+	SET ESTIMATEDTIME = ESTIMATEDTIME - :OLD.ESTIMATEDTIME, RUNTIME = RUNTIME - :OLD.RUNTIME
 	WHERE MA_WORKREQUIREMENT_ID = :OLD.MA_WORKREQUIREMENT_ID;
 END IF;
 
--- a/src-db/database/sourcedata/AD_AUXILIARINPUT.xml	Mon Sep 19 19:12:18 2011 +0200
+++ b/src-db/database/sourcedata/AD_AUXILIARINPUT.xml	Thu Sep 22 18:28:46 2011 +0200
@@ -1885,4 +1885,169 @@
 <!--FF808181323F83E801323F959F07002C-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--FF808181323F83E801323F959F07002C--></AD_AUXILIARINPUT>
 
+<!--FF80818132916D6E0132919D933E0087--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E0132919D933E0087-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E0132919D933E0087]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E0132919D933E0087-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E0132919D933E0087-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E0132919D933E0087-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E0132919D933E0087-->  <AD_TAB_ID><![CDATA[800117]]></AD_TAB_ID>
+<!--FF80818132916D6E0132919D933E0087-->  <NAME><![CDATA[WorkEffortValidated]]></NAME>
+<!--FF80818132916D6E0132919D933E0087-->  <CODE><![CDATA[@SQL=SELECT M_PRODUCTION.PROCESSED FROM M_PRODUCTION WHERE M_PRODUCTION.M_PRODUCTION_ID =  @M_PRODUCTION_ID@]]></CODE>
+<!--FF80818132916D6E0132919D933E0087-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E0132919D933E0087--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291BEEFDA00CC--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291BEEFDA00CC-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291BEEFDA00CC]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291BEEFDA00CC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291BEEFDA00CC-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291BEEFDA00CC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291BEEFDA00CC-->  <AD_TAB_ID><![CDATA[3E580F9A9D684ACC99B47E8BAE5E5563]]></AD_TAB_ID>
+<!--FF80818132916D6E013291BEEFDA00CC-->  <NAME><![CDATA[ATTRIBUTESET]]></NAME>
+<!--FF80818132916D6E013291BEEFDA00CC-->  <CODE><![CDATA[@SQL=SELECT M_ATTRIBUTESET_ID FROM M_PRODUCT WHERE M_PRODUCT_ID=@M_Product_ID@]]></CODE>
+<!--FF80818132916D6E013291BEEFDA00CC-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291BEEFDA00CC--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291BF872E00CE--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291BF872E00CE-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291BF872E00CE]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291BF872E00CE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291BF872E00CE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291BF872E00CE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291BF872E00CE-->  <AD_TAB_ID><![CDATA[3E580F9A9D684ACC99B47E8BAE5E5563]]></AD_TAB_ID>
+<!--FF80818132916D6E013291BF872E00CE-->  <NAME><![CDATA[ATTRSETVALUETYPE]]></NAME>
+<!--FF80818132916D6E013291BF872E00CE-->  <CODE><![CDATA[@SQL=SELECT ATTRSETVALUETYPE FROM M_PRODUCT WHERE M_PRODUCT_ID=@M_Product_ID@]]></CODE>
+<!--FF80818132916D6E013291BF872E00CE-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291BF872E00CE--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291BFE7E000D0--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291BFE7E000D0-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291BFE7E000D0]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291BFE7E000D0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291BFE7E000D0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291BFE7E000D0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291BFE7E000D0-->  <AD_TAB_ID><![CDATA[3E580F9A9D684ACC99B47E8BAE5E5563]]></AD_TAB_ID>
+<!--FF80818132916D6E013291BFE7E000D0-->  <NAME><![CDATA[HASSECONDUOM]]></NAME>
+<!--FF80818132916D6E013291BFE7E000D0-->  <CODE><![CDATA[@SQL=SELECT (CASE COUNT(*) WHEN 0 THEN 0 ELSE 1 END) AS TOTAL FROM M_PRODUCT_UOM WHERE M_PRODUCT_ID=@M_Product_ID@]]></CODE>
+<!--FF80818132916D6E013291BFE7E000D0-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291BFE7E000D0--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291C16F3800D2--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291C16F3800D2-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291C16F3800D2]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291C16F3800D2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291C16F3800D2-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291C16F3800D2-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291C16F3800D2-->  <AD_TAB_ID><![CDATA[5E3A5960E4D54826A923EF58A052E5AF]]></AD_TAB_ID>
+<!--FF80818132916D6E013291C16F3800D2-->  <NAME><![CDATA[Posted]]></NAME>
+<!--FF80818132916D6E013291C16F3800D2-->  <CODE><![CDATA[@SQL=SELECT M_PRODUCTION.POSTED FROM M_PRODUCTION, M_PRODUCTIONPLAN WHERE M_PRODUCTIONPLAN.M_PRODUCTION_ID = M_PRODUCTION.M_PRODUCTION_ID AND M_PRODUCTIONPLAN_ID = @M_PRODUCTIONPLAN_ID@]]></CODE>
+<!--FF80818132916D6E013291C16F3800D2-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291C16F3800D2--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291C1C1D900D4--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291C1C1D900D4-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291C1C1D900D4]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291C1C1D900D4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291C1C1D900D4-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291C1C1D900D4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291C1C1D900D4-->  <AD_TAB_ID><![CDATA[9E7E3EF08A054A30BB084DC5D2830926]]></AD_TAB_ID>
+<!--FF80818132916D6E013291C1C1D900D4-->  <NAME><![CDATA[Posted]]></NAME>
+<!--FF80818132916D6E013291C1C1D900D4-->  <CODE><![CDATA[@SQL=SELECT M_PRODUCTION.POSTED FROM M_PRODUCTION, M_PRODUCTIONPLAN WHERE M_PRODUCTIONPLAN.M_PRODUCTION_ID = M_PRODUCTION.M_PRODUCTION_ID AND M_PRODUCTIONPLAN_ID = @M_PRODUCTIONPLAN_ID@]]></CODE>
+<!--FF80818132916D6E013291C1C1D900D4-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291C1C1D900D4--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291C2010900D6--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291C2010900D6-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291C2010900D6]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291C2010900D6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291C2010900D6-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291C2010900D6-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291C2010900D6-->  <AD_TAB_ID><![CDATA[ABCEE18A05EB4C7CADB2DC30C9924717]]></AD_TAB_ID>
+<!--FF80818132916D6E013291C2010900D6-->  <NAME><![CDATA[Posted]]></NAME>
+<!--FF80818132916D6E013291C2010900D6-->  <CODE><![CDATA[@SQL=SELECT M_PRODUCTION.POSTED FROM M_PRODUCTION, M_PRODUCTIONPLAN WHERE M_PRODUCTIONPLAN.M_PRODUCTION_ID = M_PRODUCTION.M_PRODUCTION_ID AND M_PRODUCTIONPLAN_ID = @M_PRODUCTIONPLAN_ID@]]></CODE>
+<!--FF80818132916D6E013291C2010900D6-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291C2010900D6--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291C23E6500D8--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291C23E6500D8-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291C23E6500D8]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291C23E6500D8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291C23E6500D8-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291C23E6500D8-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291C23E6500D8-->  <AD_TAB_ID><![CDATA[78DB1C6BBAFF46A5B80AA1FB3D5F18F9]]></AD_TAB_ID>
+<!--FF80818132916D6E013291C23E6500D8-->  <NAME><![CDATA[Posted]]></NAME>
+<!--FF80818132916D6E013291C23E6500D8-->  <CODE><![CDATA[@SQL=SELECT M_PRODUCTION.POSTED FROM M_PRODUCTION, M_PRODUCTIONPLAN WHERE M_PRODUCTIONPLAN.M_PRODUCTION_ID = M_PRODUCTION.M_PRODUCTION_ID AND M_PRODUCTIONPLAN_ID = @M_PRODUCTIONPLAN_ID@]]></CODE>
+<!--FF80818132916D6E013291C23E6500D8-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291C23E6500D8--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291C2866200DA--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291C2866200DA-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291C2866200DA]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291C2866200DA-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291C2866200DA-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291C2866200DA-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291C2866200DA-->  <AD_TAB_ID><![CDATA[CCE9944CB341484AAF200340ABAEE787]]></AD_TAB_ID>
+<!--FF80818132916D6E013291C2866200DA-->  <NAME><![CDATA[Posted]]></NAME>
+<!--FF80818132916D6E013291C2866200DA-->  <CODE><![CDATA[@SQL=SELECT M_PRODUCTION.POSTED FROM M_PRODUCTION, M_PRODUCTIONPLAN WHERE M_PRODUCTIONPLAN.M_PRODUCTION_ID = M_PRODUCTION.M_PRODUCTION_ID AND M_PRODUCTIONPLAN_ID = @M_PRODUCTIONPLAN_ID@]]></CODE>
+<!--FF80818132916D6E013291C2866200DA-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291C2866200DA--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291C2D75E00DC--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291C2D75E00DC-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291C2D75E00DC]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291C2D75E00DC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291C2D75E00DC-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291C2D75E00DC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291C2D75E00DC-->  <AD_TAB_ID><![CDATA[5E3A5960E4D54826A923EF58A052E5AF]]></AD_TAB_ID>
+<!--FF80818132916D6E013291C2D75E00DC-->  <NAME><![CDATA[Processed]]></NAME>
+<!--FF80818132916D6E013291C2D75E00DC-->  <CODE><![CDATA[@SQL=SELECT M_PRODUCTION.PROCESSED FROM M_PRODUCTION, M_PRODUCTIONPLAN WHERE M_PRODUCTIONPLAN.M_PRODUCTION_ID = M_PRODUCTION.M_PRODUCTION_ID AND M_PRODUCTIONPLAN_ID = @M_PRODUCTIONPLAN_ID@]]></CODE>
+<!--FF80818132916D6E013291C2D75E00DC-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291C2D75E00DC--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291C32CBB00DE--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291C32CBB00DE-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291C32CBB00DE]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291C32CBB00DE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291C32CBB00DE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291C32CBB00DE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291C32CBB00DE-->  <AD_TAB_ID><![CDATA[78DB1C6BBAFF46A5B80AA1FB3D5F18F9]]></AD_TAB_ID>
+<!--FF80818132916D6E013291C32CBB00DE-->  <NAME><![CDATA[Processed]]></NAME>
+<!--FF80818132916D6E013291C32CBB00DE-->  <CODE><![CDATA[@SQL=SELECT M_PRODUCTION.PROCESSED FROM M_PRODUCTION, M_PRODUCTIONPLAN WHERE M_PRODUCTIONPLAN.M_PRODUCTION_ID = M_PRODUCTION.M_PRODUCTION_ID AND M_PRODUCTIONPLAN_ID = @M_PRODUCTIONPLAN_ID@]]></CODE>
+<!--FF80818132916D6E013291C32CBB00DE-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291C32CBB00DE--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291C370DC00E0--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291C370DC00E0-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291C370DC00E0]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291C370DC00E0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291C370DC00E0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291C370DC00E0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291C370DC00E0-->  <AD_TAB_ID><![CDATA[9E7E3EF08A054A30BB084DC5D2830926]]></AD_TAB_ID>
+<!--FF80818132916D6E013291C370DC00E0-->  <NAME><![CDATA[Processed]]></NAME>
+<!--FF80818132916D6E013291C370DC00E0-->  <CODE><![CDATA[@SQL=SELECT M_PRODUCTION.PROCESSED FROM M_PRODUCTION, M_PRODUCTIONPLAN WHERE M_PRODUCTIONPLAN.M_PRODUCTION_ID = M_PRODUCTION.M_PRODUCTION_ID AND M_PRODUCTIONPLAN_ID = @M_PRODUCTIONPLAN_ID@]]></CODE>
+<!--FF80818132916D6E013291C370DC00E0-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291C370DC00E0--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291C3C08F00E2--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291C3C08F00E2-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291C3C08F00E2]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291C3C08F00E2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291C3C08F00E2-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291C3C08F00E2-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291C3C08F00E2-->  <AD_TAB_ID><![CDATA[CCE9944CB341484AAF200340ABAEE787]]></AD_TAB_ID>
+<!--FF80818132916D6E013291C3C08F00E2-->  <NAME><![CDATA[Processed]]></NAME>
+<!--FF80818132916D6E013291C3C08F00E2-->  <CODE><![CDATA[@SQL=SELECT M_PRODUCTION.PROCESSED FROM M_PRODUCTION, M_PRODUCTIONPLAN WHERE M_PRODUCTIONPLAN.M_PRODUCTION_ID = M_PRODUCTION.M_PRODUCTION_ID AND M_PRODUCTIONPLAN_ID = @M_PRODUCTIONPLAN_ID@]]></CODE>
+<!--FF80818132916D6E013291C3C08F00E2-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291C3C08F00E2--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291C40E8A00E4--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291C40E8A00E4-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291C40E8A00E4]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291C40E8A00E4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291C40E8A00E4-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291C40E8A00E4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291C40E8A00E4-->  <AD_TAB_ID><![CDATA[ABCEE18A05EB4C7CADB2DC30C9924717]]></AD_TAB_ID>
+<!--FF80818132916D6E013291C40E8A00E4-->  <NAME><![CDATA[Processed]]></NAME>
+<!--FF80818132916D6E013291C40E8A00E4-->  <CODE><![CDATA[@SQL=SELECT M_PRODUCTION.PROCESSED FROM M_PRODUCTION, M_PRODUCTIONPLAN WHERE M_PRODUCTIONPLAN.M_PRODUCTION_ID = M_PRODUCTION.M_PRODUCTION_ID AND M_PRODUCTIONPLAN_ID = @M_PRODUCTIONPLAN_ID@]]></CODE>
+<!--FF80818132916D6E013291C40E8A00E4-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291C40E8A00E4--></AD_AUXILIARINPUT>
+
+<!--FF80818132916D6E013291C49E7E00E6--><AD_AUXILIARINPUT>
+<!--FF80818132916D6E013291C49E7E00E6-->  <AD_AUXILIARINPUT_ID><![CDATA[FF80818132916D6E013291C49E7E00E6]]></AD_AUXILIARINPUT_ID>
+<!--FF80818132916D6E013291C49E7E00E6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80818132916D6E013291C49E7E00E6-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80818132916D6E013291C49E7E00E6-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80818132916D6E013291C49E7E00E6-->  <AD_TAB_ID><![CDATA[C9B5394DBA8C465C9CE26A361696B06E]]></AD_TAB_ID>
+<!--FF80818132916D6E013291C49E7E00E6-->  <NAME><![CDATA[WorkEffortValidated]]></NAME>
+<!--FF80818132916D6E013291C49E7E00E6-->  <CODE><![CDATA[@SQL=SELECT M_PRODUCTION.PROCESSED FROM M_PRODUCTION WHERE M_PRODUCTION.M_PRODUCTION_ID =  @M_PRODUCTION_ID@]]></CODE>
+<!--FF80818132916D6E013291C49E7E00E6-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF80818132916D6E013291C49E7E00E6--></AD_AUXILIARINPUT>
+
 </data>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Mon Sep 19 19:12:18 2011 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Thu Sep 22 18:28:46 2011 +0200
@@ -55456,6 +55456,7 @@
 <!--3608-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--3608-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--3608-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--3608-->  <READONLYLOGIC><![CDATA[@Processed@='Y']]></READONLYLOGIC>
 <!--3608-->  <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
 <!--3608-->  <SEQNO><![CDATA[100]]></SEQNO>
 <!--3608-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -55817,6 +55818,7 @@
 <!--3619-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--3619-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--3619-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--3619-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--3619-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--3619-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--3619-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -55850,6 +55852,7 @@
 <!--3620-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--3620-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--3620-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--3620-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--3620-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--3620-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--3620-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -55884,6 +55887,7 @@
 <!--3622-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--3622-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--3622-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--3622-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--3622-->  <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
 <!--3622-->  <SEQNO><![CDATA[2]]></SEQNO>
 <!--3622-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -65818,6 +65822,7 @@
 <!--4753-->  <ISPARENT><![CDATA[Y]]></ISPARENT>
 <!--4753-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--4753-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--4753-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--4753-->  <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
 <!--4753-->  <SEQNO><![CDATA[3]]></SEQNO>
 <!--4753-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -66146,6 +66151,7 @@
 <!--4763-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--4763-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--4763-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--4763-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--4763-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--4763-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--4763-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -66178,6 +66184,7 @@
 <!--4764-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--4764-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--4764-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--4764-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--4764-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--4764-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--4764-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -66213,6 +66220,7 @@
 <!--4765-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--4765-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--4765-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--4765-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--4765-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--4765-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--4765-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -102296,6 +102304,7 @@
 <!--8552-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--8552-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--8552-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--8552-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--8552-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--8552-->  <SEQNO><![CDATA[0]]></SEQNO>
 <!--8552-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -109330,6 +109339,7 @@
 <!--9552-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--9552-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--9552-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--9552-->  <READONLYLOGIC><![CDATA[@Processed@='Y']]></READONLYLOGIC>
 <!--9552-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--9552-->  <SEQNO><![CDATA[0]]></SEQNO>
 <!--9552-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -116419,6 +116429,7 @@
 <!--800147-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--800147-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--800147-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--800147-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--800147-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--800147-->  <SEQNO><![CDATA[0]]></SEQNO>
 <!--800147-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -116455,6 +116466,7 @@
 <!--800148-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--800148-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--800148-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--800148-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--800148-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--800148-->  <SEQNO><![CDATA[0]]></SEQNO>
 <!--800148-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -116556,6 +116568,7 @@
 <!--800151-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--800151-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--800151-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--800151-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--800151-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--800151-->  <SEQNO><![CDATA[0]]></SEQNO>
 <!--800151-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -148029,6 +148042,7 @@
 <!--802026-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--802026-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--802026-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--802026-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--802026-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--802026-->  <SEQNO><![CDATA[12]]></SEQNO>
 <!--802026-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -148062,6 +148076,7 @@
 <!--802027-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--802027-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--802027-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--802027-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--802027-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--802027-->  <SEQNO><![CDATA[22]]></SEQNO>
 <!--802027-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -148128,6 +148143,7 @@
 <!--802029-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--802029-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--802029-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--802029-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--802029-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--802029-->  <SEQNO><![CDATA[42]]></SEQNO>
 <!--802029-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -148161,6 +148177,7 @@
 <!--802030-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--802030-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--802030-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--802030-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--802030-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--802030-->  <SEQNO><![CDATA[52]]></SEQNO>
 <!--802030-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -148197,6 +148214,7 @@
 <!--802031-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--802031-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--802031-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--802031-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--802031-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--802031-->  <SEQNO><![CDATA[23]]></SEQNO>
 <!--802031-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -148264,6 +148282,7 @@
 <!--802033-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--802033-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--802033-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--802033-->  <READONLYLOGIC><![CDATA[@Processed@='Y']]></READONLYLOGIC>
 <!--802033-->  <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
 <!--802033-->  <SEQNO><![CDATA[61]]></SEQNO>
 <!--802033-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -149811,6 +149830,7 @@
 <!--802181-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--802181-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--802181-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--802181-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--802181-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--802181-->  <SEQNO><![CDATA[82]]></SEQNO>
 <!--802181-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -150116,6 +150136,7 @@
 <!--802204-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--802204-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--802204-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--802204-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--802204-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--802204-->  <SEQNO><![CDATA[92]]></SEQNO>
 <!--802204-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -150149,6 +150170,7 @@
 <!--802205-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--802205-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--802205-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--802205-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--802205-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--802205-->  <SEQNO><![CDATA[102]]></SEQNO>
 <!--802205-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -150186,6 +150208,7 @@
 <!--802206-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--802206-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--802206-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--802206-->  <READONLYLOGIC><![CDATA[@WorkEffortValidated@='Y']]></READONLYLOGIC>
 <!--802206-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--802206-->  <SEQNO><![CDATA[112]]></SEQNO>
 <!--802206-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -210302,6 +210325,38 @@
 <!--239CBB762B674D098AB048C768E03346-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--239CBB762B674D098AB048C768E03346--></AD_COLUMN>
 
+<!--24A3A68F65AC4ACB93051653575F4A3F--><AD_COLUMN>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <AD_COLUMN_ID><![CDATA[24A3A68F65AC4ACB93051653575F4A3F]]></AD_COLUMN_ID>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <NAME><![CDATA[Runtime]]></NAME>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <COLUMNNAME><![CDATA[Runtime]]></COLUMNNAME>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <AD_TABLE_ID><![CDATA[800201]]></AD_TABLE_ID>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <FIELDLENGTH><![CDATA[2]]></FIELDLENGTH>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <DEFAULTVALUE><![CDATA[0]]></DEFAULTVALUE>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <READONLYLOGIC><![CDATA[@Processed@='Y' | @Posted@='Y']]></READONLYLOGIC>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <SEQNO><![CDATA[160]]></SEQNO>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <POSITION><![CDATA[15]]></POSITION>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--24A3A68F65AC4ACB93051653575F4A3F--></AD_COLUMN>
+
 <!--25B76152C3DC4DAC89050ECD9C3F20AD--><AD_COLUMN>
 <!--25B76152C3DC4DAC89050ECD9C3F20AD-->  <AD_COLUMN_ID><![CDATA[25B76152C3DC4DAC89050ECD9C3F20AD]]></AD_COLUMN_ID>
 <!--25B76152C3DC4DAC89050ECD9C3F20AD-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -224789,7 +224844,8 @@
 <!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <NAME><![CDATA[Validate Work Effort]]></NAME>
-<!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <HELP><![CDATA[Process to validate the work effort.]]></HELP>
+<!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <DESCRIPTION><![CDATA[Process to validate and actualize stocks of production run.]]></DESCRIPTION>
+<!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <HELP><![CDATA[Process to validate the work effort in Production Run Window. With this process the work effort is closed. Stocks are actualized and average costs are calculated]]></HELP>
 <!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <COLUMNNAME><![CDATA[Validating]]></COLUMNNAME>
 <!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <AD_TABLE_ID><![CDATA[385]]></AD_TABLE_ID>
 <!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
@@ -248813,40 +248869,6 @@
 <!--856F36F847D1FC23E040007F0101352B-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--856F36F847D1FC23E040007F0101352B--></AD_COLUMN>
 
-<!--866FE5FE0D1E4958A2DA8A4516671E68--><AD_COLUMN>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <AD_COLUMN_ID><![CDATA[866FE5FE0D1E4958A2DA8A4516671E68]]></AD_COLUMN_ID>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <NAME><![CDATA[Realquantity]]></NAME>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <DESCRIPTION><![CDATA[Real Quantity]]></DESCRIPTION>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <HELP><![CDATA[Real Quantity]]></HELP>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <COLUMNNAME><![CDATA[Realquantity]]></COLUMNNAME>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <AD_TABLE_ID><![CDATA[800201]]></AD_TABLE_ID>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <FIELDLENGTH><![CDATA[2]]></FIELDLENGTH>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <DEFAULTVALUE><![CDATA[0]]></DEFAULTVALUE>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <SEQNO><![CDATA[140]]></SEQNO>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <AD_ELEMENT_ID><![CDATA[F599393EED9B40B88661B2E3948BC6BF]]></AD_ELEMENT_ID>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <POSITION><![CDATA[13]]></POSITION>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--866FE5FE0D1E4958A2DA8A4516671E68-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--866FE5FE0D1E4958A2DA8A4516671E68--></AD_COLUMN>
-
 <!--8672E2CEC4B143EDA3FD16235CE39FF3--><AD_COLUMN>
 <!--8672E2CEC4B143EDA3FD16235CE39FF3-->  <AD_COLUMN_ID><![CDATA[8672E2CEC4B143EDA3FD16235CE39FF3]]></AD_COLUMN_ID>
 <!--8672E2CEC4B143EDA3FD16235CE39FF3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Mon Sep 19 19:12:18 2011 +0200
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Sep 22 18:28:46 2011 +0200
@@ -25634,19 +25634,6 @@
 <!--F3BF680089754BAC858ECFF2D5D0F232-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--F3BF680089754BAC858ECFF2D5D0F232--></AD_ELEMENT>
 
-<!--F599393EED9B40B88661B2E3948BC6BF--><AD_ELEMENT>
-<!--F599393EED9B40B88661B2E3948BC6BF-->  <AD_ELEMENT_ID><![CDATA[F599393EED9B40B88661B2E3948BC6BF]]></AD_ELEMENT_ID>
-<!--F599393EED9B40B88661B2E3948BC6BF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--F599393EED9B40B88661B2E3948BC6BF-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--F599393EED9B40B88661B2E3948BC6BF-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--F599393EED9B40B88661B2E3948BC6BF-->  <COLUMNNAME><![CDATA[Realquantity]]></COLUMNNAME>
-<!--F599393EED9B40B88661B2E3948BC6BF-->  <NAME><![CDATA[Real Quantity]]></NAME>
-<!--F599393EED9B40B88661B2E3948BC6BF-->  <PRINTNAME><![CDATA[Real Quantity]]></PRINTNAME>
-<!--F599393EED9B40B88661B2E3948BC6BF-->  <DESCRIPTION><![CDATA[Real Quantity]]></DESCRIPTION>
-<!--F599393EED9B40B88661B2E3948BC6BF-->  <HELP><![CDATA[Real Quantity]]></HELP>
-<!--F599393EED9B40B88661B2E3948BC6BF-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--F599393EED9B40B88661B2E3948BC6BF--></AD_ELEMENT>
-
 <!--F668C2865A2F462BBFE89754F2B06274--><AD_ELEMENT>
 <!--F668C2865A2F462BBFE89754F2B06274-->  <AD_ELEMENT_ID><![CDATA[F668C2865A2F462BBFE89754F2B06274]]></AD_ELEMENT_ID>
 <!--F668C2865A2F462BBFE89754F2B06274-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Mon Sep 19 19:12:18 2011 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Thu Sep 22 18:28:46 2011 +0200
@@ -117978,6 +117978,7 @@
 <!--801863-->  <AD_TAB_ID><![CDATA[800114]]></AD_TAB_ID>
 <!--801863-->  <AD_COLUMN_ID><![CDATA[802025]]></AD_COLUMN_ID>
 <!--801863-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--801863-->  <DISPLAYLOGIC><![CDATA[@Processed@='N']]></DISPLAYLOGIC>
 <!--801863-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
 <!--801863-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--801863-->  <SEQNO><![CDATA[60]]></SEQNO>
@@ -165373,33 +165374,6 @@
 <!--308A606019294CE6B77DD6491A763C96-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--308A606019294CE6B77DD6491A763C96--></AD_FIELD>
 
-<!--30B8C856C7CA4B03B0DEEED69B96658E--><AD_FIELD>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <AD_FIELD_ID><![CDATA[30B8C856C7CA4B03B0DEEED69B96658E]]></AD_FIELD_ID>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <NAME><![CDATA[Real Quantity]]></NAME>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <DESCRIPTION><![CDATA[Real Quantity]]></DESCRIPTION>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <HELP><![CDATA[Real Quantity]]></HELP>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <AD_TAB_ID><![CDATA[ABCEE18A05EB4C7CADB2DC30C9924717]]></AD_TAB_ID>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <AD_COLUMN_ID><![CDATA[866FE5FE0D1E4958A2DA8A4516671E68]]></AD_COLUMN_ID>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <DISPLAYLENGTH><![CDATA[2]]></DISPLAYLENGTH>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <SEQNO><![CDATA[50]]></SEQNO>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <GRID_SEQNO><![CDATA[50]]></GRID_SEQNO>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
-<!--30B8C856C7CA4B03B0DEEED69B96658E-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
-<!--30B8C856C7CA4B03B0DEEED69B96658E--></AD_FIELD>
-
 <!--30D6C84CE8FB45B6B00C8F38C28A38F5--><AD_FIELD>
 <!--30D6C84CE8FB45B6B00C8F38C28A38F5-->  <AD_FIELD_ID><![CDATA[30D6C84CE8FB45B6B00C8F38C28A38F5]]></AD_FIELD_ID>
 <!--30D6C84CE8FB45B6B00C8F38C28A38F5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -179231,6 +179205,31 @@
 <!--73FD4F3CD5F24E3C958F4A768CD40D16-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--73FD4F3CD5F24E3C958F4A768CD40D16--></AD_FIELD>
 
+<!--748A08B0350744ADA48DE2FAC4033F3E--><AD_FIELD>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <AD_FIELD_ID><![CDATA[748A08B0350744ADA48DE2FAC4033F3E]]></AD_FIELD_ID>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <NAME><![CDATA[Runtime]]></NAME>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <AD_TAB_ID><![CDATA[800237]]></AD_TAB_ID>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <AD_COLUMN_ID><![CDATA[24A3A68F65AC4ACB93051653575F4A3F]]></AD_COLUMN_ID>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <DISPLAYLENGTH><![CDATA[2]]></DISPLAYLENGTH>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <GRID_SEQNO><![CDATA[50]]></GRID_SEQNO>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--748A08B0350744ADA48DE2FAC4033F3E--></AD_FIELD>
+
 <!--7526828ADF604AFC9E1BD0DACDCA1F5B--><AD_FIELD>
 <!--7526828ADF604AFC9E1BD0DACDCA1F5B-->  <AD_FIELD_ID><![CDATA[7526828ADF604AFC9E1BD0DACDCA1F5B]]></AD_FIELD_ID>
 <!--7526828ADF604AFC9E1BD0DACDCA1F5B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -193194,33 +193193,6 @@
 <!--C394D7D344EB41E8B83A76E9404D40F3-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--C394D7D344EB41E8B83A76E9404D40F3--></AD_FIELD>
 
-<!--C3FA82516E4C46BBBF996DA6CFE80F88--><AD_FIELD>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <AD_FIELD_ID><![CDATA[C3FA82516E4C46BBBF996DA6CFE80F88]]></AD_FIELD_ID>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <NAME><![CDATA[Real Quantity]]></NAME>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <DESCRIPTION><![CDATA[Real Quantity]]></DESCRIPTION>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <HELP><![CDATA[Real Quantity]]></HELP>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <AD_TAB_ID><![CDATA[800237]]></AD_TAB_ID>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <AD_COLUMN_ID><![CDATA[866FE5FE0D1E4958A2DA8A4516671E68]]></AD_COLUMN_ID>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <DISPLAYLENGTH><![CDATA[2]]></DISPLAYLENGTH>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <SEQNO><![CDATA[50]]></SEQNO>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <GRID_SEQNO><![CDATA[50]]></GRID_SEQNO>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
-<!--C3FA82516E4C46BBBF996DA6CFE80F88--></AD_FIELD>
-
 <!--C424D68ACE9C4A90A5037D81633A0E9E--><AD_FIELD>
 <!--C424D68ACE9C4A90A5037D81633A0E9E-->  <AD_FIELD_ID><![CDATA[C424D68ACE9C4A90A5037D81633A0E9E]]></AD_FIELD_ID>
 <!--C424D68ACE9C4A90A5037D81633A0E9E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -193767,6 +193739,31 @@
 <!--CDB44BC768524004A512F12675BF9399-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--CDB44BC768524004A512F12675BF9399--></AD_FIELD>
 
+<!--CDCEB8A436794783BE180739C34F49FE--><AD_FIELD>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <AD_FIELD_ID><![CDATA[CDCEB8A436794783BE180739C34F49FE]]></AD_FIELD_ID>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <NAME><![CDATA[Runtime]]></NAME>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <AD_TAB_ID><![CDATA[ABCEE18A05EB4C7CADB2DC30C9924717]]></AD_TAB_ID>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <AD_COLUMN_ID><![CDATA[24A3A68F65AC4ACB93051653575F4A3F]]></AD_COLUMN_ID>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <DISPLAYLENGTH><![CDATA[2]]></DISPLAYLENGTH>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <GRID_SEQNO><![CDATA[50]]></GRID_SEQNO>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--CDCEB8A436794783BE180739C34F49FE--></AD_FIELD>
+
 <!--CE5BB1DDE01F4FF4B79B6FA34CE7F657--><AD_FIELD>
 <!--CE5BB1DDE01F4FF4B79B6FA34CE7F657-->  <AD_FIELD_ID><![CDATA[CE5BB1DDE01F4FF4B79B6FA34CE7F657]]></AD_FIELD_ID>
 <!--CE5BB1DDE01F4FF4B79B6FA34CE7F657-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -195686,12 +195683,13 @@
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <NAME><![CDATA[Validate Work Effort]]></NAME>
-<!--F36C5360FCA7427AA77D5543BE7B0C46-->  <HELP><![CDATA[Process to validate the work effort in Production Run Window.]]></HELP>
+<!--F36C5360FCA7427AA77D5543BE7B0C46-->  <DESCRIPTION><![CDATA[Process to validate and actualize stocks of production run.]]></DESCRIPTION>
+<!--F36C5360FCA7427AA77D5543BE7B0C46-->  <HELP><![CDATA[Process to validate the work effort in Production Run Window. With this process the work effort is closed. Stocks are actualized and average costs are calculated]]></HELP>
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <AD_TAB_ID><![CDATA[C9B5394DBA8C465C9CE26A361696B06E]]></AD_TAB_ID>
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <AD_COLUMN_ID><![CDATA[5A02BD2E7E2C4C0497524E2748B11BBE]]></AD_COLUMN_ID>
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--F36C5360FCA7427AA77D5543BE7B0C46-->  <DISPLAYLOGIC><![CDATA[@Processed@='Y']]></DISPLAYLOGIC>
+<!--F36C5360FCA7427AA77D5543BE7B0C46-->  <DISPLAYLOGIC><![CDATA[@Processed@='Y' & @WorkEffortValidated@='N']]></DISPLAYLOGIC>
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <SEQNO><![CDATA[170]]></SEQNO>
@@ -195704,7 +195702,7 @@
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <GRID_SEQNO><![CDATA[170]]></GRID_SEQNO>
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
 <!--F36C5360FCA7427AA77D5543BE7B0C46-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
-<!--F36C5360FCA7427AA77D5543BE7B0C46-->  <ISSHOWNINSTATUSBAR><![CDATA[Y]]></ISSHOWNINSTATUSBAR>
+<!--F36C5360FCA7427AA77D5543BE7B0C46-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--F36C5360FCA7427AA77D5543BE7B0C46--></AD_FIELD>
 
 <!--F489C0DA5BFE40D28C0C888FBC1EF4A5--><AD_FIELD>
--- a/src-db/database/sourcedata/AD_PROCESS.xml	Mon Sep 19 19:12:18 2011 +0200
+++ b/src-db/database/sourcedata/AD_PROCESS.xml	Thu Sep 22 18:28:46 2011 +0200
@@ -5609,7 +5609,8 @@
 <!--FF808181326CD80501326CE906D70042-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--FF808181326CD80501326CE906D70042-->  <VALUE><![CDATA[ValidateWorkEffort_ProductionRun]]></VALUE>
 <!--FF808181326CD80501326CE906D70042-->  <NAME><![CDATA[Validate Work Effort]]></NAME>
-<!--FF808181326CD80501326CE906D70042-->  <HELP><![CDATA[Process to validate the work effort in Production Run Window.]]></HELP>
+<!--FF808181326CD80501326CE906D70042-->  <DESCRIPTION><![CDATA[Process to validate and actualize stocks of production run.]]></DESCRIPTION>
+<!--FF808181326CD80501326CE906D70042-->  <HELP><![CDATA[Process to validate the work effort in Production Run Window. With this process the work effort is closed. Stocks are actualized and average costs are calculated]]></HELP>
 <!--FF808181326CD80501326CE906D70042-->  <ACCESSLEVEL><![CDATA[7]]></ACCESSLEVEL>
 <!--FF808181326CD80501326CE906D70042-->  <ISUSERSTARTABLE><![CDATA[N]]></ISUSERSTARTABLE>
 <!--FF808181326CD80501326CE906D70042-->  <ISREPORT><![CDATA[N]]></ISREPORT>
--- a/src/org/openbravo/erpCommon/ad_actionButton/SequenceProductCreate.java	Mon Sep 19 19:12:18 2011 +0200
+++ b/src/org/openbravo/erpCommon/ad_actionButton/SequenceProductCreate.java	Thu Sep 22 18:28:46 2011 +0200
@@ -35,10 +35,9 @@
 
 public class SequenceProductCreate implements Process {
 
-  private static final String specialAttListId = "FF808181322476640132249E3417002F";
   private static final String lotSearchKey = "LOT";
   private static final String serialNoSearchKey = "SNO";
-  private static final String expirationDateearchKey = "EXD";
+  private static final String expirationDateSearchKey = "EXD";
 
   @Override
   public void execute(ProcessBundle bundle) throws Exception {
@@ -97,7 +96,7 @@
         if (newProduct.getAttributeSet().isSerialNo())
           copyAtt(newOpProduct, opProduct.getProduct(), true, serialNoSearchKey, null);
         if (newProduct.getAttributeSet().isExpirationDate())
-          copyAtt(newOpProduct, opProduct.getProduct(), true, expirationDateearchKey, null);
+          copyAtt(newOpProduct, opProduct.getProduct(), true, expirationDateSearchKey, null);
         // Normal Attribute
         for (AttributeUse attributeuse : newProduct.getAttributeSet().getAttributeUseList()) {
           copyAtt(newOpProduct, opProduct.getProduct(), false, "", attributeuse);
--- a/src/org/openbravo/erpCommon/ad_callouts/SL_SequenceProduct_Product_Attribute.java	Mon Sep 19 19:12:18 2011 +0200
+++ b/src/org/openbravo/erpCommon/ad_callouts/SL_SequenceProduct_Product_Attribute.java	Thu Sep 22 18:28:46 2011 +0200
@@ -36,7 +36,7 @@
   private static final String specialAttListId = "FF808181322476640132249E3417002F";
   private static final String lotSearchKey = "LOT";
   private static final String serialNoSearchKey = "SNO";
-  private static final String expirationDateearchKey = "EXD";
+  private static final String expirationDateSearchKey = "EXD";
 
   @Override
   protected void execute(CalloutInfo info) throws ServletException {
@@ -84,7 +84,7 @@
         // ExpirationDate
         if (product.getAttributeSet().isExpirationDate()
             && opProduct.getProduct().getAttributeSet().isExpirationDate()) {
-          org.openbravo.model.ad.domain.List ed = SpecialAttListValue(expirationDateearchKey);
+          org.openbravo.model.ad.domain.List ed = SpecialAttListValue(expirationDateSearchKey);
           if (ed != null)
             info.addSelectResult(ed.getSearchKey(), ed.getName());
         }