Feature Request [ 1877668 ] Pareto Report for Products
authorCarlos Romero <carlos.romero@openbravo.com>
Tue, 08 Apr 2008 15:35:33 +0000
changeset 616 fe70905f43fe
parent 615 e416ed828eed
child 617 590f3c8e634d
Feature Request [ 1877668 ] Pareto Report for Products
database/model/functions/GET_PARETO_ABC.xml
database/model/functions/M_INVENTORY_LISTCREATE.xml
database/model/functions/M_UPDATE_PARETO_PRODUCT.xml
database/model/functions/M_UPDATE_PARETO_PRODUCT0.xml
database/model/tables/M_PRODUCT_ORG.xml
database/sourcedata/AD_COLUMN.xml
database/sourcedata/AD_ELEMENT.xml
database/sourcedata/AD_ELEMENT_TRL.xml
database/sourcedata/AD_FIELD.xml
database/sourcedata/AD_FIELD_TRL.xml
database/sourcedata/AD_MENU.xml
database/sourcedata/AD_MENU_TRL.xml
database/sourcedata/AD_MODEL_OBJECT.xml
database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
database/sourcedata/AD_PROCESS.xml
database/sourcedata/AD_PROCESS_PARA.xml
database/sourcedata/AD_PROCESS_PARA_TRL.xml
database/sourcedata/AD_PROCESS_TRL.xml
database/sourcedata/AD_REFERENCE.xml
database/sourcedata/AD_REFERENCE_TRL.xml
database/sourcedata/AD_REF_LIST.xml
database/sourcedata/AD_REF_LIST_TRL.xml
database/sourcedata/AD_TEXTINTERFACES.xml
database/sourcedata/AD_TEXTINTERFACES_TRL.xml
database/sourcedata/AD_TREENODE.xml
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.html
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.java
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.xml
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/database/model/functions/GET_PARETO_ABC.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -0,0 +1,82 @@
+<?xml version="1.0"?>
+  <database name="FUNCTION GET_PARETO_ABC">
+    <function name="GET_PARETO_ABC" type="VARCHAR">
+      <parameter name="p_warehouse_ID" type="NUMERIC" mode="in"/>
+      <parameter name="p_org_ID" type="NUMERIC" mode="in"/>
+      <parameter name="p_porcentajeactual" type="NUMERIC" mode="in"/>
+      <body><![CDATA[/*************************************************************************
+* The contents of this file are subject to the Openbravo  Public  License
+* Version  1.0  (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 SL
+* All portions are Copyright (C) 2001-2008 Openbravo SL
+* All Rights Reserved.
+* Contributor(s):  ______________________________________.
+************************************************************************/
+
+v_orgList VARCHAR2(4000) ;
+  VARaCUM number:=0;
+  VARaCUMB number:=0;
+  varComprobadoA Number:=0;
+  varComprobadoB Number:=0;
+  TYPE RECORD IS REF CURSOR;
+    Cur_Roles RECORD;
+BEGIN
+varAcum :=0;
+varComprobadoA := 0;
+for Cur_Cursor in (
+   SELECT 
+  100*(GET_PRODUCT_COST(PR.M_PRODUCT_ID,to_date(now()),'AV')/ (select SUM(GET_PRODUCT_COST(PR1.M_PRODUCT_ID,to_date(now()),'AV')) 
+                                                       from M_WAREHOUSE MW1  
+                                                       LEFT JOIN M_LOCATOR ML1 ON ML1.M_WAREHOUSE_ID=MW1.M_WAREHOUSE_ID
+                                                       LEFT JOIN M_STORAGE_DETAIL MSD1 ON ML1.M_LOCATOR_ID=MSD1.M_LOCATOR_ID
+                                                       LEFT JOIN M_ATTRIBUTESETINSTANCE MAT1 ON MAT1.M_ATTRIBUTESETINSTANCE_ID=MSD1.M_ATTRIBUTESETINSTANCE_ID
+                                                       LEFT JOIN M_PRODUCT PR1 ON MSD1.M_PRODUCT_ID=PR1.M_PRODUCT_ID   
+                                                       WHERE MW1.M_WAREHOUSE_ID=p_warehouse_ID
+                                                       AND MSD1.AD_ORG_ID=p_org_ID
+                                                       AND MSD1.QTYONHAND>0) ) as PORCENTAJE
+FROM
+ M_WAREHOUSE MW 
+   LEFT JOIN M_LOCATOR ML ON ML.M_WAREHOUSE_ID=MW.M_WAREHOUSE_ID
+   LEFT JOIN M_STORAGE_DETAIL MSD ON ML.M_LOCATOR_ID=MSD.M_LOCATOR_ID
+   LEFT JOIN M_ATTRIBUTESETINSTANCE MAT ON MAT.M_ATTRIBUTESETINSTANCE_ID=MSD.M_ATTRIBUTESETINSTANCE_ID
+   LEFT JOIN M_PRODUCT PR ON MSD.M_PRODUCT_ID=PR.M_PRODUCT_ID   
+WHERE MW.M_WAREHOUSE_ID=p_warehouse_ID
+   AND MSD.AD_ORG_ID=p_org_ID
+   AND MSD.QTYONHAND>0
+   AND GET_PRODUCT_COST(PR.M_PRODUCT_ID,to_date(now()),'AV') IS NOT NULL
+   AND GET_PRODUCT_COST(PR.M_PRODUCT_ID,to_date(now()),'AV') <> 0
+ORDER BY PORCENTAJE DESC) loop
+varAcum := varAcum+Cur_Cursor.porcentaje;
+ if(varComprobadoA=0)then
+  if (varAcum>=75) then
+    if (p_porcentajeactual>=Cur_Cursor.porcentaje) then return 'A';
+ else
+   varComprobadoA:=-1;
+   varAcumB:=-1*Cur_Cursor.porcentaje;
+ end if;
+  end if;
+ end if;
+
+  if (varComprobadoA=-1 and varComprobadoB=0) then
+  varAcumB:=varAcumB+Cur_Cursor.porcentaje;
+   if (varAcumB>=15) then
+     if (p_porcentajeactual>=Cur_Cursor.porcentaje) then return 'B';
+	 else varComprobadoB:=-1;
+     end if;
+   end if;   
+  end if;
+
+end loop;
+return 'C';
+
+end GET_PARETO_ABC]]></body>
+    </function>
+  </database>
--- a/database/model/functions/M_INVENTORY_LISTCREATE.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/model/functions/M_INVENTORY_LISTCREATE.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -45,6 +45,7 @@
     v_Product_Category_ID NUMBER;
     v_QtyRange CHAR(1) ;
     v_Regularization CHAR(1) ;
+    v_ABC CHAR(1);
     --
     v_Warehouse_ID NUMBER;
     v_Client_ID NUMBER;
@@ -92,6 +93,9 @@
       ELSIF(Cur_Parameter.ParameterName='M_Product_Category_ID') THEN
         v_Product_Category_ID:=Cur_Parameter.P_Number;
         DBMS_OUTPUT.PUT_LINE('  M_Product_Category_ID=' || v_Product_Category_ID) ;
+      ELSIF(Cur_Parameter.ParameterName='ABC') THEN
+        v_ABC:=Cur_Parameter.P_String;
+        DBMS_OUTPUT.PUT_LINE('  ABC=' || v_ABC) ;        
       ELSE
         DBMS_OUTPUT.PUT_LINE('*** Unknown Parameter=' || Cur_Parameter.ParameterName) ;
       END IF;
@@ -204,11 +208,15 @@
       FROM M_Product p
       INNER JOIN M_Storage_Detail s
         ON(s.M_Product_ID=p.M_Product_ID)
+      LEFT JOIN M_Product_org o
+        ON(o.M_Product_ID=p.M_Product_ID) 
       WHERE p.AD_Client_ID=v_Client_ID  --    only ..
         AND(v_ProductValue IS NULL
         OR UPPER(p.Value) LIKE v_ProductValue)
         AND(v_Locator_ID IS NULL
         OR s.M_Locator_ID=v_Locator_ID)
+        AND(v_ABC IS NULL
+        OR o.ABC=v_ABC)        
         AND(v_Warehouse_ID IS NULL
         OR s.M_Locator_ID IN
         (SELECT M_Locator_ID FROM M_Locator WHERE M_Warehouse_ID=v_Warehouse_ID))
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/database/model/functions/M_UPDATE_PARETO_PRODUCT.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -0,0 +1,171 @@
+<?xml version="1.0"?>
+  <database name="FUNCTION M_UPDATE_PARETO_PRODUCT">
+    <function name="M_UPDATE_PARETO_PRODUCT" type="NULL">
+      <parameter name="p_PInstance_ID" type="NUMERIC" mode="in"/>
+      <parameter name="p_warehouse_ID" type="NUMERIC" mode="in"/>
+      <parameter name="p_org_ID" type="NUMERIC" mode="in"/>
+      <body><![CDATA[/*************************************************************************
+* The contents of this file are subject to the Openbravo  Public  License
+* Version  1.0  (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 SL
+* All portions are Copyright (C) 2001-2008 Openbravo SL
+* All Rights Reserved.
+* Contributor(s):  ______________________________________.
+************************************************************************/
+
+v_ResultStr VARCHAR2(2000):='';
+  v_Result NUMBER := 1;  
+  v_Message VARCHAR2(2000):='';
+  v_exist number:=0;
+  v_M_Product_Org_ID number(10);
+  v_warehouse_ID number(10);
+  v_org_ID number(10);
+  v_count_update NUMBER := 0;
+  v_count_insert NUMBER := 0;  
+  TYPE RECORD IS REF CURSOR;
+  Cur_Cursor RECORD;
+  Cur_Parameter RECORD;  
+BEGIN
+
+  IF(p_PInstance_ID IS NOT NULL) THEN
+      --  Update AD_PInstance
+      DBMS_OUTPUT.PUT_LINE('Updating PInstance - Processing ' || p_PInstance_ID) ;
+      v_ResultStr:='PInstanceNotFound';
+      AD_UPDATE_PINSTANCE(p_PInstance_ID, NULL, 'Y', NULL, NULL) ;
+      -- Get Parameters
+      v_ResultStr:='ReadingParameters';
+      FOR Cur_Parameter IN (SELECT i.Record_ID, i.AD_User_ID, p.ParameterName, p.P_String, p.P_Number, p.P_Date, i.UpdatedBy
+                            FROM AD_PINSTANCE i LEFT JOIN AD_PINSTANCE_PARA p ON i.AD_PInstance_ID=p.AD_PInstance_ID
+                            WHERE i.AD_PInstance_ID=p_PInstance_ID
+                            ORDER BY p.SeqNo) LOOP
+        IF (Cur_Parameter.ParameterName = 'm_warehouse_id') THEN
+          v_warehouse_ID := Cur_Parameter.P_String;
+          DBMS_OUTPUT.PUT_LINE('  m_warehouse_id=' || v_warehouse_ID) ;
+        ELSIF (Cur_Parameter.ParameterName = 'ad_org_id') THEN
+          v_org_ID := Cur_Parameter.P_String;
+          DBMS_OUTPUT.PUT_LINE('  ad_org_id=' || v_org_ID) ;
+        END IF;
+      END LOOP; --Get Parameter
+
+    ELSE
+      DBMS_OUTPUT.PUT_LINE('--<<M_UPDATE_PARETO_PRODUCT>>') ;
+      v_warehouse_ID:=p_warehouse_ID;
+      v_org_ID:=p_org_ID;    
+    END IF;
+    BEGIN --BODY
+    
+  for Cur_Cursor in (
+     SELECT ORGID, SEARCHKEY, NAME, ATTRIBUTE, COST, PORCENTAJE
+     ,GET_PARETO_ABC(M_WAREHOUSE_ID, AD_ORG_ID, PORCENTAJE) AS ISABC,
+     M_WAREHOUSE_ID, AD_ORG_ID, AD_CLIENT_ID, M_PRODUCT_ID
+     FROM
+     (
+     SELECT 
+      AD_ORG.NAME AS ORGID,
+      PR.VALUE AS SEARCHKEY,
+      PR.NAME,
+      MAT.DESCRIPTION AS ATTRIBUTE,
+      GET_PRODUCT_COST(PR.M_PRODUCT_ID,to_date(now()),'AV') AS COST,
+      100*(GET_PRODUCT_COST(PR.M_PRODUCT_ID,to_date(now()),'AV')/ (SELECT SUM(GET_PRODUCT_COST(PR1.M_PRODUCT_ID,to_date(now()),'AV')) 
+                                                           from M_WAREHOUSE MW1  
+                                                           LEFT JOIN M_LOCATOR ML1 ON ML1.M_WAREHOUSE_ID=MW1.M_WAREHOUSE_ID
+                                                           LEFT JOIN M_STORAGE_DETAIL MSD1 ON ML1.M_LOCATOR_ID=MSD1.M_LOCATOR_ID
+                                                           LEFT JOIN M_ATTRIBUTESETINSTANCE MAT1 ON MAT1.M_ATTRIBUTESETINSTANCE_ID=MSD1.M_ATTRIBUTESETINSTANCE_ID
+                                                           LEFT JOIN M_PRODUCT PR1 ON MSD1.M_PRODUCT_ID=PR1.M_PRODUCT_ID   
+                                                           WHERE MSD1.QTYONHAND>0
+                                                           AND (v_warehouse_ID IS NULL OR MW1.M_WAREHOUSE_ID = TO_NUMBER(v_warehouse_ID))
+                                                           AND (v_org_ID IS NULL OR MSD1.AD_ORG_ID = TO_NUMBER(v_org_ID)) 
+                                                           ) ) as PORCENTAJE,
+      ML.X,
+      ML.Y,
+      ML.Z,
+      MW.M_WAREHOUSE_ID,
+      MSD.AD_ORG_ID,
+      MSD.AD_CLIENT_ID,
+      PR.M_PRODUCT_ID
+     FROM
+     M_WAREHOUSE MW 
+       LEFT JOIN M_LOCATOR ML ON ML.M_WAREHOUSE_ID=MW.M_WAREHOUSE_ID
+       LEFT JOIN M_STORAGE_DETAIL MSD ON ML.M_LOCATOR_ID=MSD.M_LOCATOR_ID
+       LEFT JOIN M_ATTRIBUTESETINSTANCE MAT ON MAT.M_ATTRIBUTESETINSTANCE_ID=MSD.M_ATTRIBUTESETINSTANCE_ID
+       LEFT JOIN M_PRODUCT PR ON MSD.M_PRODUCT_ID=PR.M_PRODUCT_ID, AD_ORG   
+     WHERE (v_warehouse_ID IS NULL OR MW.M_WAREHOUSE_ID = TO_NUMBER(v_warehouse_ID))
+       AND (v_org_ID IS NULL OR MSD.AD_ORG_ID = TO_NUMBER(v_org_ID))
+       AND MSD.QTYONHAND>0
+       AND GET_PRODUCT_COST(PR.M_PRODUCT_ID,to_date(now()),'AV') IS NOT NULL
+       AND GET_PRODUCT_COST(PR.M_PRODUCT_ID,to_date(now()),'AV') <> 0
+       AND MSD.AD_ORG_ID = AD_ORG.AD_ORG_ID
+     ORDER BY PORCENTAJE DESC) BBB) loop
+     
+     SELECT COUNT(*) 
+     INTO v_exist 
+     FROM M_PRODUCT_ORG
+     WHERE M_PRODUCT_ID = Cur_Cursor.M_PRODUCT_ID
+     AND AD_ORG_ID = Cur_Cursor.AD_ORG_ID; 
+     
+     IF (v_exist > 0) THEN
+       UPDATE M_PRODUCT_ORG SET
+       ABC = Cur_Cursor.ISABC
+       WHERE M_PRODUCT_ID = Cur_Cursor.M_PRODUCT_ID
+       AND AD_ORG_ID = Cur_Cursor.AD_ORG_ID; 
+       v_count_update := v_count_update + 1;
+     ELSE
+       AD_Sequence_Next('M_Product_Org', Cur_Cursor.AD_CLIENT_ID, v_M_Product_Org_ID) ;
+       INSERT INTO M_PRODUCT_ORG (M_PRODUCT_ORG_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, M_PRODUCT_ID, ABC) VALUES
+       (v_M_Product_Org_ID, Cur_Cursor.AD_CLIENT_ID, Cur_Cursor.AD_ORG_ID, 'Y', now(), 100, now(), 100, Cur_Cursor.M_PRODUCT_ID, Cur_Cursor.ISABC);
+       v_count_insert := v_count_insert + 1;
+     END IF;
+
+  end loop;
+  v_Message:='@Created@=' || v_count_insert || ', @Updated@=' || v_count_update;
+--<<FINISH_PROCESS>>
+    IF(p_PInstance_ID IS NOT NULL) THEN
+      --  Update AD_PInstance
+      DBMS_OUTPUT.PUT_LINE('Updating PInstance - Finished ' || v_Message) ;
+      AD_UPDATE_PINSTANCE(p_PInstance_ID, NULL, 'N', v_Result, v_Message) ;
+    ELSE
+      DBMS_OUTPUT.PUT_LINE('--<<M_UPDATE_PARETO_PRODUCT finished>>') ;
+    END IF;
+    RETURN;
+  END; --BODY
+EXCEPTION
+WHEN OTHERS THEN
+  v_ResultStr:= '@ERROR=' || SQLERRM;
+  DBMS_OUTPUT.PUT_LINE(v_ResultStr) ;
+  IF(p_PInstance_ID IS NOT NULL) THEN
+    ROLLBACK;
+    AD_UPDATE_PINSTANCE(p_PInstance_ID, NULL, 'N', 0, v_ResultStr) ;
+  ELSE
+    DECLARE
+      v_Code NUMBER:=SQLCode;
+    BEGIN
+      INSERT
+      INTO DBA_ERRORLOG
+        (
+          DBA_ErrorLog_ID, Created,
+          Code, Msg,
+          Info
+        )
+        VALUES
+        (
+          DBA_ErrorLog_Seq.NEXTVAL, now(),
+          v_Code, v_ResultStr,
+           'M_UPDATE_PARETO_PRODUCT'
+        )
+        ;
+    END;
+    RAISE;
+  END IF;
+  RETURN;
+
+end M_UPDATE_PARETO_PRODUCT]]></body>
+    </function>
+  </database>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/database/model/functions/M_UPDATE_PARETO_PRODUCT0.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -0,0 +1,25 @@
+<?xml version="1.0"?>
+  <database name="FUNCTION M_UPDATE_PARETO_PRODUCT0">
+    <function name="M_UPDATE_PARETO_PRODUCT0" type="NULL">
+      <parameter name="PInstance_ID" type="NUMERIC" mode="in"/>
+      <body><![CDATA[/*************************************************************************
+* The contents of this file are subject to the Openbravo  Public  License
+* Version  1.0  (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 SL
+* All portions are Copyright (C) 2001-2008 Openbravo SL
+* All Rights Reserved.
+* Contributor(s):  ______________________________________.
+************************************************************************/
+BEGIN
+  M_Update_Pareto_Product(PInstance_ID, NULL, NULL) ;
+END M_Update_Pareto_Product0]]></body>
+    </function>
+  </database>
--- a/database/model/tables/M_PRODUCT_ORG.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/model/tables/M_PRODUCT_ORG.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -13,13 +13,14 @@
       <column name="M_LOCATOR_ID" primaryKey="false" required="false" type="DECIMAL" size="10,0" autoIncrement="false"/>
       <column name="CAPACITY" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false"/>
       <column name="DELAYMIN" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false"/>
-      <column name="MRP_PLANNER_ID" primaryKey="false" required="true" type="DECIMAL" size="10,0" autoIncrement="false"/>
-      <column name="MRP_PLANNINGMETHOD_ID" primaryKey="false" required="true" type="DECIMAL" size="10,0" autoIncrement="false"/>
+      <column name="MRP_PLANNER_ID" primaryKey="false" required="false" type="DECIMAL" size="10,0" autoIncrement="false"/>
+      <column name="MRP_PLANNINGMETHOD_ID" primaryKey="false" required="false" type="DECIMAL" size="10,0" autoIncrement="false"/>
       <column name="QTYMAX" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false"/>
       <column name="QTYMIN" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false"/>
       <column name="QTYSTD" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false"/>
       <column name="QTYTYPE" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false"/>
       <column name="STOCKMIN" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false"/>
+      <column name="ABC" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false"/>
       <foreign-key foreignTable="AD_CLIENT" name="CLIENT_FK_PRODUCTORG">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
--- a/database/sourcedata/AD_COLUMN.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_COLUMN.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -10596,8 +10596,8 @@
   <AD_COLUMN AD_COLUMN_ID="803698" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-22 20:48:26.0" UPDATED="2007-05-09 18:27:14.0" CREATEDBY="0" UPDATEDBY="100" NAME="Total Movement Quantity" DESCRIPTION="The final quantity to be moved based on the related business process." HELP="Cumulate quantity." VERSION="1" ENTITYTYPE="U" COLUMNNAME="Cumqty" AD_TABLE_ID="800219" AD_REFERENCE_ID="29" FIELDLENGTH="12" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="260" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800172" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
   <AD_COLUMN AD_COLUMN_ID="803699" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-22 21:00:31.0" UPDATED="2007-01-23 17:35:56.0" CREATEDBY="0" UPDATEDBY="100" NAME="Business Partner " DESCRIPTION="Anyone who takes part in daily business operations by acting as a customer, employee, etc." HELP="A Business Partner is anyone with whom you transact.  This can include Vendor, Customer, Employee or Salesperson" VERSION="1" ENTITYTYPE="U" COLUMNNAME="C_BPartner_ID" AD_TABLE_ID="800221" AD_REFERENCE_ID="30" AD_REFERENCE_VALUE_ID="800057" FIELDLENGTH="60" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="240" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="187" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
   <AD_COLUMN AD_COLUMN_ID="803700" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-22 21:00:31.0" UPDATED="2007-01-23 17:35:56.0" CREATEDBY="0" UPDATEDBY="0" NAME="Total Movement Quantity" DESCRIPTION="The final quantity to be moved based on the related business process." HELP="Cumulate quantity." VERSION="1" ENTITYTYPE="U" COLUMNNAME="Cumqty" AD_TABLE_ID="800221" AD_REFERENCE_ID="29" FIELDLENGTH="12" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="250" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800172" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
-  <AD_COLUMN AD_COLUMN_ID="803701" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-23 17:33:17.0" UPDATED="2007-01-23 17:35:56.0" CREATEDBY="0" UPDATEDBY="0" NAME="Planner" DESCRIPTION="The person in charge of making an MRP plan." HELP="Identifies a planner of the MRP." VERSION="1" ENTITYTYPE="U" COLUMNNAME="MRP_Planner_ID" AD_TABLE_ID="800205" AD_REFERENCE_ID="19" FIELDLENGTH="12" ISKEY="N" ISPARENT="N" ISMANDATORY="Y" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="110" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800735" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
-  <AD_COLUMN AD_COLUMN_ID="803702" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-23 17:33:17.0" UPDATED="2007-01-23 17:35:56.0" CREATEDBY="0" UPDATEDBY="0" NAME="Planning Method" HELP="Identifies a method for filtering the input for planning processes." VERSION="1" ENTITYTYPE="U" COLUMNNAME="MRP_Planningmethod_ID" AD_TABLE_ID="800205" AD_REFERENCE_ID="19" FIELDLENGTH="12" ISKEY="N" ISPARENT="N" ISMANDATORY="Y" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="120" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800741" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
+  <AD_COLUMN AD_COLUMN_ID="803701" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-23 17:33:17.0" UPDATED="2008-04-07 00:34:15.0" CREATEDBY="0" UPDATEDBY="100" NAME="Planner" DESCRIPTION="The person in charge of making an MRP plan." HELP="Identifies a planner of the MRP." VERSION="1" ENTITYTYPE="U" COLUMNNAME="MRP_Planner_ID" AD_TABLE_ID="800205" AD_REFERENCE_ID="19" FIELDLENGTH="12" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="110" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800735" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
+  <AD_COLUMN AD_COLUMN_ID="803702" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-23 17:33:17.0" UPDATED="2008-04-07 00:33:55.0" CREATEDBY="0" UPDATEDBY="100" NAME="Planning Method" HELP="Identifies a method for filtering the input for planning processes." VERSION="1" ENTITYTYPE="U" COLUMNNAME="MRP_Planningmethod_ID" AD_TABLE_ID="800205" AD_REFERENCE_ID="19" FIELDLENGTH="12" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="120" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800741" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
   <AD_COLUMN AD_COLUMN_ID="803703" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-23 17:33:17.0" UPDATED="2007-01-23 17:33:17.0" CREATEDBY="0" UPDATEDBY="0" NAME="Safety Stock" HELP="Safety Stock" VERSION="1" ENTITYTYPE="U" COLUMNNAME="Stockmin" AD_TABLE_ID="800205" AD_REFERENCE_ID="22" FIELDLENGTH="12" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="130" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800750" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
   <AD_COLUMN AD_COLUMN_ID="803704" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-23 17:33:17.0" UPDATED="2007-01-24 10:56:17.0" CREATEDBY="0" UPDATEDBY="100" NAME="Quantity Type" DESCRIPTION="Quantity Type" HELP="Quantity Type" VERSION="1" ENTITYTYPE="U" COLUMNNAME="Qtytype" AD_TABLE_ID="800205" AD_REFERENCE_ID="17" AD_REFERENCE_VALUE_ID="800099" FIELDLENGTH="1" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="140" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800753" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
   <AD_COLUMN AD_COLUMN_ID="803705" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-23 17:33:17.0" UPDATED="2008-02-14 15:51:16.0" CREATEDBY="0" UPDATEDBY="0" NAME="Min. Quantity" DESCRIPTION="Minumun Quantity." HELP="Minumun Quantity." VERSION="1" ENTITYTYPE="U" COLUMNNAME="Qtymin" AD_TABLE_ID="800205" AD_REFERENCE_ID="29" FIELDLENGTH="12" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="150" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800754" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
@@ -10800,6 +10800,7 @@
   <AD_COLUMN AD_COLUMN_ID="803878" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-14 12:44:18.0" UPDATED="2007-09-14 12:45:35.0" CREATEDBY="0" UPDATEDBY="100" NAME="CFS Order Account" DESCRIPTION="Cash Flow Statement Order Account" HELP="Account used in cash flow statement for entries related to orders, which have no entries in accounting." VERSION="1" ENTITYTYPE="D" COLUMNNAME="CFS_Order_Acct" AD_TABLE_ID="266" AD_REFERENCE_ID="30" AD_REFERENCE_VALUE_ID="25" FIELDLENGTH="12" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="11" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800821" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
   <AD_COLUMN AD_COLUMN_ID="1000300000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-12 17:59:35.0" UPDATED="2008-04-02 18:15:04.0" CREATEDBY="0" UPDATEDBY="100" NAME="Type" DESCRIPTION="A distinct item characteristic used for processes and sometimes grouped within a category." HELP="The Type indicates the type of validation that will occur.  This can be SQL, Java Script or Java Language." VERSION="1" ENTITYTYPE="D" COLUMNNAME="Type" AD_TABLE_ID="593" AD_REFERENCE_ID="17" AD_REFERENCE_VALUE_ID="1000300000" FIELDLENGTH="1" DEFAULTVALUE="D" ISKEY="N" ISPARENT="N" ISMANDATORY="Y" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="130" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="600" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
   <AD_COLUMN AD_COLUMN_ID="1000500000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 16:41:11.0" UPDATED="2008-03-17 16:53:02.0" CREATEDBY="0" UPDATEDBY="100" NAME="Cost Applied" DESCRIPTION="Specify if the Salary Category is intended to be applied for costing calculation" HELP="Specify if the Salary Category is intended to be applied for costing calculation" VERSION="1" ENTITYTYPE="U" COLUMNNAME="Iscostapplied" AD_TABLE_ID="800187" AD_REFERENCE_ID="20" FIELDLENGTH="1" DEFAULTVALUE="Y" ISKEY="N" ISPARENT="N" ISMANDATORY="Y" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="110" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="1000500000" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
+  <AD_COLUMN AD_COLUMN_ID="1000500001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 15:00:16.0" UPDATED="2008-04-06 16:08:33.0" CREATEDBY="0" UPDATEDBY="100" NAME="Abc" DESCRIPTION="ABC classification according to a Pareto distribution" HELP="ABC classification according to a Pareto distribution" VERSION="1" ENTITYTYPE="U" COLUMNNAME="Abc" AD_TABLE_ID="800205" AD_REFERENCE_ID="17" AD_REFERENCE_VALUE_ID="1000500000" FIELDLENGTH="1" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="200" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="1000500001" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
   <AD_COLUMN AD_COLUMN_ID="1000600012" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 11:52:47.0" UPDATED="2007-10-21 11:52:47.0" CREATEDBY="0" UPDATEDBY="0" NAME="Accounting Fact (Cash Flow Statement)" VERSION="1" ENTITYTYPE="U" COLUMNNAME="Fact_Acct_Cfs_ID" AD_TABLE_ID="1000600001" AD_REFERENCE_ID="13" FIELDLENGTH="12" ISKEY="Y" ISPARENT="N" ISMANDATORY="Y" ISUPDATEABLE="N" ISIDENTIFIER="N" SEQNO="10" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="1000600003" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
   <AD_COLUMN AD_COLUMN_ID="1000600013" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 11:52:47.0" UPDATED="2007-10-21 12:04:48.0" CREATEDBY="0" UPDATEDBY="0" NAME="Accounting Fact" VERSION="1" ENTITYTYPE="U" COLUMNNAME="Fact_Acct_ID" AD_TABLE_ID="1000600001" AD_REFERENCE_ID="19" FIELDLENGTH="12" ISKEY="N" ISPARENT="N" ISMANDATORY="Y" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="20" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="885" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
   <AD_COLUMN AD_COLUMN_ID="1000600014" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 11:52:47.0" UPDATED="2007-10-21 12:04:48.0" CREATEDBY="0" UPDATEDBY="0" NAME="Client" DESCRIPTION="Client for this installation." HELP="A Client is a company or a legal entity. You cannot share data between Clients." VERSION="1" ENTITYTYPE="U" COLUMNNAME="AD_Client_ID" AD_TABLE_ID="1000600001" AD_REFERENCE_ID="19" AD_VAL_RULE_ID="103" FIELDLENGTH="12" DEFAULTVALUE="@AD_CLIENT_ID@" ISKEY="N" ISPARENT="N" ISMANDATORY="Y" ISUPDATEABLE="N" ISIDENTIFIER="N" SEQNO="30" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="102" ISSYNCDATABASE="N" ISSESSIONATTR="Y" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />
--- a/database/sourcedata/AD_ELEMENT.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_ELEMENT.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -2108,6 +2108,7 @@
   <AD_ELEMENT AD_ELEMENT_ID="800820" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-06-29 18:31:18.0" CREATEDBY="100" UPDATED="2007-06-29 18:31:18.0" UPDATEDBY="100" COLUMNNAME="AD_Forced_Org_ID" ENTITYTYPE="U" NAME="Forced Org" PRINTNAME="Forced Org" />
   <AD_ELEMENT AD_ELEMENT_ID="800821" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-14 12:46:11.0" CREATEDBY="0" UPDATED="2007-09-14 12:50:45.0" UPDATEDBY="100" COLUMNNAME="CFS_Order_Acct" ENTITYTYPE="D" NAME="CFS Order Account" PRINTNAME="CFS Order Account" DESCRIPTION="Cash Flow Statement Order Account" HELP="Account used in cash flow statement for entries related to orders, which have no entries in accounting." />
   <AD_ELEMENT AD_ELEMENT_ID="1000500000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 16:51:48.0" CREATEDBY="100" UPDATED="2008-03-17 16:53:22.0" UPDATEDBY="100" COLUMNNAME="Iscostapplied" ENTITYTYPE="U" NAME="Cost Applied" PRINTNAME="Cost Applied" DESCRIPTION="Specify if the Salary Category is intended to be applied for costing calculation" HELP="Specify if the Salary Category is intended to be applied for costing calculation" />
+  <AD_ELEMENT AD_ELEMENT_ID="1000500001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 15:03:47.0" CREATEDBY="100" UPDATED="2008-04-06 15:03:47.0" UPDATEDBY="100" COLUMNNAME="ABC" ENTITYTYPE="U" NAME="Abc" PRINTNAME="Abc" DESCRIPTION="ABC classification according to a Pareto distribution" HELP="ABC classification according to a Pareto distribution" />
   <AD_ELEMENT AD_ELEMENT_ID="1000600002" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 11:53:04.0" CREATEDBY="0" UPDATED="2007-10-21 12:11:27.0" UPDATEDBY="100" COLUMNNAME="Fact_Acct_Ref_ID" ENTITYTYPE="D" NAME="Accounting Fact Reference" PRINTNAME="Accounting Fact Reference" />
   <AD_ELEMENT AD_ELEMENT_ID="1000600003" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 11:53:04.0" CREATEDBY="0" UPDATED="2007-10-21 12:10:39.0" UPDATEDBY="100" COLUMNNAME="Fact_Acct_Cfs_ID" ENTITYTYPE="D" NAME="Accounting Fact (Cash Flow Statement)" PRINTNAME="Accounting Fact (Cash Flow Statement)" />
   <AD_ELEMENT AD_ELEMENT_ID="1000600004" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 12:15:54.0" CREATEDBY="0" UPDATED="2007-10-21 12:15:54.0" UPDATEDBY="0" COLUMNNAME="Operands" ENTITYTYPE="D" NAME="Operands" PRINTNAME="Operands" />
--- a/database/sourcedata/AD_ELEMENT_TRL.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_ELEMENT_TRL.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -2326,6 +2326,7 @@
   <AD_ELEMENT_TRL AD_ELEMENT_ID="800820" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-06-29 18:31:18.0" CREATEDBY="100" UPDATED="2007-06-29 18:31:33.0" UPDATEDBY="100" NAME="Organización forzado" PRINTNAME="Organización forzado" ISTRANSLATED="Y" />
   <AD_ELEMENT_TRL AD_ELEMENT_ID="800821" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-14 12:46:11.0" CREATEDBY="0" UPDATED="2007-09-14 12:53:58.0" UPDATEDBY="100" NAME="Cuenta para pedidos en CFS" PRINTNAME="Cuenta para pedidos en CFS" HELP="Cuenta usada para el cash flow statement  para los pedidos, los cuales  o tienen entrada en contabilidad" ISTRANSLATED="Y" />
   <AD_ELEMENT_TRL AD_ELEMENT_ID="1000500000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 16:51:48.0" CREATEDBY="100" UPDATED="2008-03-17 16:51:48.0" UPDATEDBY="100" NAME="Cost Applied" PRINTNAME="Cost Applied" DESCRIPTION="Specify if the Salary Category is intended to be applied for costing calculation" HELP="Specify if the Salary Category is intended to be applied for costing calculation" ISTRANSLATED="N" />
+  <AD_ELEMENT_TRL AD_ELEMENT_ID="1000500001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 15:03:47.0" CREATEDBY="100" UPDATED="2008-04-06 15:03:47.0" UPDATEDBY="100" NAME="Abc" PRINTNAME="Abc" DESCRIPTION="ABC classification according to a Pareto distribution" HELP="ABC classification according to a Pareto distribution" ISTRANSLATED="N" />
   <AD_ELEMENT_TRL AD_ELEMENT_ID="1000600002" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 11:53:04.0" CREATEDBY="0" UPDATED="2007-10-21 11:53:04.0" UPDATEDBY="0" NAME="Fact_Acct_Ref_ID" PRINTNAME="Fact_Acct_Ref_ID" ISTRANSLATED="N" />
   <AD_ELEMENT_TRL AD_ELEMENT_ID="1000600003" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 11:53:04.0" CREATEDBY="0" UPDATED="2007-10-21 11:53:04.0" UPDATEDBY="0" NAME="Fact_Acct_Cfs_ID" PRINTNAME="Fact_Acct_Cfs_ID" ISTRANSLATED="N" />
   <AD_ELEMENT_TRL AD_ELEMENT_ID="1000600004" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 12:15:54.0" CREATEDBY="0" UPDATED="2007-10-21 12:17:21.0" UPDATEDBY="100" NAME="Operandos" PRINTNAME="Operandos" ISTRANSLATED="Y" />
--- a/database/sourcedata/AD_FIELD.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_FIELD.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -10327,6 +10327,8 @@
   <AD_FIELD AD_FIELD_ID="1000500000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 16:43:04.0" CREATEDBY="0" UPDATED="2008-03-17 16:43:04.0" UPDATEDBY="0" NAME="Creation Date" DESCRIPTION="The date that this record is completed." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="800067" AD_COLUMN_ID="800973" ISDISPLAYED="Y" DISPLAYLENGTH="19" ISREADONLY="N" SEQNO="0" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="U" SHOWINRELATION="Y" />
   <AD_FIELD AD_FIELD_ID="1000500001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 16:44:05.0" CREATEDBY="0" UPDATED="2008-03-17 18:10:50.0" UPDATEDBY="100" NAME="Creation Date" DESCRIPTION="The date that this record is completed." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="800225" AD_COLUMN_ID="803143" ISDISPLAYED="N" DISPLAYLENGTH="19" ISREADONLY="N" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="U" SHOWINRELATION="Y" />
   <AD_FIELD AD_FIELD_ID="1000500002" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 16:44:05.0" CREATEDBY="0" UPDATED="2008-03-17 18:10:50.0" UPDATEDBY="100" NAME="Cost Applied" DESCRIPTION="Specify if the Salary Category is intended to be applied for costing calculation" HELP="Specify if the Salary Category is intended to be applied for costing calculation" ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="800225" AD_COLUMN_ID="1000500000" ISDISPLAYED="Y" DISPLAYLENGTH="1" ISREADONLY="N" SEQNO="60" ISSAMELINE="Y" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="U" SHOWINRELATION="Y" />
+  <AD_FIELD AD_FIELD_ID="1000500003" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 15:07:53.0" CREATEDBY="0" UPDATED="2008-04-06 15:09:40.0" UPDATEDBY="100" NAME="Abc" DESCRIPTION="ABC classification according to a Pareto distribution" HELP="ABC classification according to a Pareto distribution" ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="800241" AD_COLUMN_ID="1000500001" ISDISPLAYED="Y" DISPLAYLENGTH="1" ISREADONLY="N" SEQNO="140" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="U" SHOWINRELATION="Y" />
+  <AD_FIELD AD_FIELD_ID="1000500004" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 15:07:53.0" CREATEDBY="0" UPDATED="2008-04-06 15:08:13.0" UPDATEDBY="100" NAME="Creation Date" DESCRIPTION="The date that this record is completed." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="800241" AD_COLUMN_ID="803455" ISDISPLAYED="N" DISPLAYLENGTH="19" ISREADONLY="N" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="U" SHOWINRELATION="Y" />
   <AD_FIELD AD_FIELD_ID="1000600001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-15 18:41:45.0" CREATEDBY="0" UPDATED="2008-03-06 19:48:10.0" UPDATEDBY="100" NAME="Accounting Schema" DESCRIPTION="The structure used in accounting including costing methods, currencies, and the calendar." HELP="An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar" ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="800261" AD_COLUMN_ID="1000600025" ISDISPLAYED="Y" DISPLAYLENGTH="12" ISREADONLY="N" SEQNO="40" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="U" SHOWINRELATION="Y" />
   <AD_FIELD AD_FIELD_ID="1000600002" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-02-05 12:03:58.0" CREATEDBY="100" UPDATED="2008-02-05 12:03:58.0" UPDATEDBY="100" NAME="Posted" ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="800114" AD_COLUMN_ID="6537" ISDISPLAYED="Y" DISPLAYLOGIC="@Processed@='Y'" DISPLAYLENGTH="0" ISREADONLY="N" SEQNO="100" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="U" SHOWINRELATION="N" />
   <AD_FIELD AD_FIELD_ID="1004400001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-22 17:45:58.0" CREATEDBY="0" UPDATED="2008-04-02 10:59:30.0" UPDATEDBY="100" NAME="Business Partner " DESCRIPTION="Anyone who takes part in daily business operations by acting as a customer, employee, etc." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="800251" AD_COLUMN_ID="1004400000" ISDISPLAYED="Y" DISPLAYLENGTH="40" ISREADONLY="N" SEQNO="110" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="U" SHOWINRELATION="Y" />
--- a/database/sourcedata/AD_FIELD_TRL.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_FIELD_TRL.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -11250,6 +11250,8 @@
   <AD_FIELD_TRL AD_FIELD_ID="1000500000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 16:43:04.0" CREATEDBY="0" UPDATED="2008-04-02 18:15:05.0" UPDATEDBY="0" NAME="Fecha Creación" DESCRIPTION="Fecha en que se completa este registro." HELP="Indica la fecha en la que el dato fue creado. " ISTRANSLATED="N" />
   <AD_FIELD_TRL AD_FIELD_ID="1000500001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 16:44:05.0" CREATEDBY="0" UPDATED="2008-04-02 18:15:05.0" UPDATEDBY="0" NAME="Fecha Creación" DESCRIPTION="Fecha en que se completa este registro." HELP="Indica la fecha en la que el dato fue creado. " ISTRANSLATED="N" />
   <AD_FIELD_TRL AD_FIELD_ID="1000500002" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 16:44:05.0" CREATEDBY="0" UPDATED="2008-04-02 18:15:05.0" UPDATEDBY="0" NAME="Cost Applied" DESCRIPTION="Specify if the Salary Category is intended to be applied for costing calculation" HELP="Specify if the Salary Category is intended to be applied for costing calculation" ISTRANSLATED="N" />
+  <AD_FIELD_TRL AD_FIELD_ID="1000500003" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 15:07:53.0" CREATEDBY="0" UPDATED="2008-04-06 15:07:53.0" UPDATEDBY="0" NAME="Abc" DESCRIPTION="ABC classification according to a Pareto distribution" ISTRANSLATED="N" />
+  <AD_FIELD_TRL AD_FIELD_ID="1000500004" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 15:07:53.0" CREATEDBY="0" UPDATED="2008-04-06 15:07:53.0" UPDATEDBY="0" NAME="Creation Date" DESCRIPTION="The date that this record is completed." ISTRANSLATED="N" />
   <AD_FIELD_TRL AD_FIELD_ID="1000600001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-15 18:41:45.0" CREATEDBY="0" UPDATED="2008-03-06 19:48:10.0" UPDATEDBY="0" NAME="Esquema contable" DESCRIPTION="Estructura de contabilidad, incluidos métodos de coste, monedas y calendario." HELP="El esquema contable define las reglas de contabilidad, la moneda y el calendario." ISTRANSLATED="N" />
   <AD_FIELD_TRL AD_FIELD_ID="1000600002" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-02-05 12:03:58.0" CREATEDBY="100" UPDATED="2008-02-05 12:03:58.0" UPDATEDBY="100" NAME="Posted" ISTRANSLATED="N" />
   <AD_FIELD_TRL AD_FIELD_ID="1004400001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-22 17:45:58.0" CREATEDBY="0" UPDATED="2008-01-22 17:45:58.0" UPDATEDBY="0" NAME="Business Partner " DESCRIPTION="Anyone who takes part in daily business operations by acting as a customer, employee, etc." ISTRANSLATED="N" />
--- a/database/sourcedata/AD_MENU.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_MENU.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -470,6 +470,7 @@
   <AD_MENU AD_MENU_ID="800289" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-17 10:45:35.0" CREATEDBY="100" UPDATED="2007-09-17 10:45:35.0" NAME="Report Cash Flow" UPDATEDBY="100" DESCRIPTION="Report Cash Flow" ISSUMMARY="N" ISSOTRX="N" ISREADONLY="N" ACTION="R" AD_PROCESS_ID="800206" ENTITYTYPE="U" />
   <AD_MENU AD_MENU_ID="800290" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-17 10:46:29.0" CREATEDBY="100" UPDATED="2007-09-17 10:46:29.0" NAME="Create Cash Flow Statement" UPDATEDBY="100" DESCRIPTION="Create Cash Flow Statement" ISSUMMARY="N" ISSOTRX="N" ISREADONLY="N" ACTION="P" AD_PROCESS_ID="800207" ENTITYTYPE="U" />
   <AD_MENU AD_MENU_ID="1000001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-19 12:09:01.0" CREATEDBY="100" UPDATED="2007-07-17 19:26:15.0" NAME="Openbravo ERP" UPDATEDBY="100" DESCRIPTION="Openbravo Homepage" ISSUMMARY="N" ISSOTRX="N" ISREADONLY="N" ACTION="L" ENTITYTYPE="U" URL="http://www.openbravo.com" />
+  <AD_MENU AD_MENU_ID="1000500000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 20:18:15.0" CREATEDBY="100" UPDATED="2008-04-06 20:18:15.0" NAME="Report Pareto Product" UPDATEDBY="100" DESCRIPTION="Report Pareto Product" ISSUMMARY="N" ISSOTRX="N" ISREADONLY="N" ACTION="R" AD_PROCESS_ID="1000500000" ENTITYTYPE="U" />
   <AD_MENU AD_MENU_ID="1004400000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-02-06 19:55:16.0" CREATEDBY="100" UPDATED="2008-02-06 19:55:16.0" NAME="Manage Requisitions" UPDATEDBY="100" ISSUMMARY="N" ISSOTRX="N" ISREADONLY="N" ACTION="W" AD_WINDOW_ID="1004400000" ENTITYTYPE="U" />
   <AD_MENU AD_MENU_ID="1004400001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-05 18:30:31.0" CREATEDBY="100" UPDATED="2008-03-05 18:30:31.0" NAME="Requisition To Order" UPDATEDBY="100" DESCRIPTION="Create a Purchase Order from Requisition lines." ISSUMMARY="N" ISSOTRX="N" ISREADONLY="N" ACTION="X" AD_FORM_ID="1004400000" ENTITYTYPE="U" />
 </data>
--- a/database/sourcedata/AD_MENU_TRL.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_MENU_TRL.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -470,6 +470,7 @@
   <AD_MENU_TRL AD_MENU_ID="800289" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-17 10:45:35.0" CREATEDBY="100" UPDATED="2007-10-21 21:17:32.0" UPDATEDBY="100" NAME="ReportCashFlow" DESCRIPTION="ReportCashFlow" ISTRANSLATED="N" />
   <AD_MENU_TRL AD_MENU_ID="800290" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-17 10:46:29.0" CREATEDBY="100" UPDATED="2007-09-17 10:46:52.0" UPDATEDBY="100" NAME="Generar Cash Flow" DESCRIPTION="Generar Cash Flow" ISTRANSLATED="Y" />
   <AD_MENU_TRL AD_MENU_ID="1000001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-19 12:09:01.0" CREATEDBY="100" UPDATED="2007-01-19 14:03:23.0" UPDATEDBY="100" NAME="Openbravo página oficial" DESCRIPTION="Openbravo página oficial" ISTRANSLATED="Y" />
+  <AD_MENU_TRL AD_MENU_ID="1000500000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 20:18:15.0" CREATEDBY="100" UPDATED="2008-04-07 18:20:12.0" UPDATEDBY="100" NAME="Informe de Pareto para Productos" DESCRIPTION="Informe de Pareto para Productos" ISTRANSLATED="N" />
   <AD_MENU_TRL AD_MENU_ID="1004400000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-02-06 19:55:16.0" CREATEDBY="100" UPDATED="2008-02-06 19:55:16.0" UPDATEDBY="100" NAME="Administrar necesidades" ISTRANSLATED="Y" />
   <AD_MENU_TRL AD_MENU_ID="1004400001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-05 18:30:31.0" CREATEDBY="100" UPDATED="2008-03-12 13:20:51.0" UPDATEDBY="100" NAME="Necesidad a Pedido" DESCRIPTION="Crear un pedido de compra desde líneas de necesidad de material." ISTRANSLATED="Y" />
 </data>
--- a/database/sourcedata/AD_MODEL_OBJECT.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_MODEL_OBJECT.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -1492,6 +1492,7 @@
   <AD_MODEL_OBJECT AD_MODEL_OBJECT_ID="1000100035" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-11-15 16:48:36.0" CREATEDBY="100" UPDATED="2007-11-15 16:48:36.0" UPDATEDBY="100" ACTION="W" AD_TAB_ID="800257" CLASSNAME="org.openbravo.erpCommon.ad_callouts.ComboReloads800257" ISDEFAULT="N" />
   <AD_MODEL_OBJECT AD_MODEL_OBJECT_ID="1000500006" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-12 18:25:29.0" CREATEDBY="100" UPDATED="2008-03-12 18:25:29.0" UPDATEDBY="100" ACTION="W" AD_TAB_ID="800263" CLASSNAME="org.openbravo.erpWindows.GeneralAccountReportSetup.Groupingcategory" ISDEFAULT="Y" />
   <AD_MODEL_OBJECT AD_MODEL_OBJECT_ID="1000500007" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-12 18:25:29.0" CREATEDBY="100" UPDATED="2008-03-12 18:25:29.0" UPDATEDBY="100" ACTION="W" AD_TAB_ID="800263" CLASSNAME="org.openbravo.erpCommon.ad_callouts.ComboReloads800263" ISDEFAULT="N" />
+  <AD_MODEL_OBJECT AD_MODEL_OBJECT_ID="1000500008" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 20:16:39.0" CREATEDBY="100" UPDATED="2008-04-07 18:18:29.0" UPDATEDBY="100" ACTION="R" CLASSNAME="org.openbravo.erpCommon.ad_reports.ReportParetoProduct" ISDEFAULT="Y" AD_PROCESS_ID="1000500000" />
   <AD_MODEL_OBJECT AD_MODEL_OBJECT_ID="1004400004" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-29 19:21:41.0" CREATEDBY="100" UPDATED="2008-01-29 19:21:41.0" UPDATEDBY="100" ACTION="C" CLASSNAME="org.openbravo.erpCommon.ad_callouts.SL_RequisitionLine_Amt" ISDEFAULT="Y" AD_CALLOUT_ID="1004400000" />
   <AD_MODEL_OBJECT AD_MODEL_OBJECT_ID="1004400006" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-29 19:22:28.0" CREATEDBY="100" UPDATED="2008-01-29 19:22:28.0" UPDATEDBY="100" ACTION="C" CLASSNAME="org.openbravo.erpCommon.ad_callouts.SL_RequisitionLine_Product" ISDEFAULT="Y" AD_CALLOUT_ID="800013" />
   <AD_MODEL_OBJECT AD_MODEL_OBJECT_ID="1004400008" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-29 19:23:41.0" CREATEDBY="100" UPDATED="2008-01-29 19:23:41.0" UPDATEDBY="100" ACTION="C" CLASSNAME="org.openbravo.erpCommon.ad_callouts.SL_RequisitionLine_Conversion" ISDEFAULT="Y" AD_CALLOUT_ID="1004400001" />
--- a/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -2844,6 +2844,7 @@
   <AD_MODEL_OBJECT_MAPPING AD_MODEL_OBJECT_MAPPING_ID="1000500013" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-12 18:25:29.0" CREATEDBY="100" UPDATED="2008-03-12 18:25:29.0" UPDATEDBY="100" AD_MODEL_OBJECT_ID="1000500006" MAPPINGNAME="/GeneralAccountReportSetup/Groupingcategory_Edition.html" ISDEFAULT="N" />
   <AD_MODEL_OBJECT_MAPPING AD_MODEL_OBJECT_MAPPING_ID="1000500014" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-12 18:25:29.0" CREATEDBY="100" UPDATED="2008-03-12 18:25:29.0" UPDATEDBY="100" AD_MODEL_OBJECT_ID="1000500006" MAPPINGNAME="/GeneralAccountReportSetup/Groupingcategory_Excel.xls" ISDEFAULT="N" />
   <AD_MODEL_OBJECT_MAPPING AD_MODEL_OBJECT_MAPPING_ID="1000500015" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-12 18:25:29.0" CREATEDBY="100" UPDATED="2008-03-12 18:25:29.0" UPDATEDBY="100" AD_MODEL_OBJECT_ID="1000500007" MAPPINGNAME="/ad_callouts/ComboReloads800263.html" ISDEFAULT="N" />
+  <AD_MODEL_OBJECT_MAPPING AD_MODEL_OBJECT_MAPPING_ID="1000500016" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 20:17:04.0" CREATEDBY="100" UPDATED="2008-04-07 18:18:43.0" UPDATEDBY="100" AD_MODEL_OBJECT_ID="1000500008" MAPPINGNAME="/ad_reports/ReportParetoProduct.html" ISDEFAULT="Y" />
   <AD_MODEL_OBJECT_MAPPING AD_MODEL_OBJECT_MAPPING_ID="1000600000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 20:26:50.0" CREATEDBY="100" UPDATED="2007-10-21 20:26:50.0" UPDATEDBY="100" AD_MODEL_OBJECT_ID="804366" MAPPINGNAME="/ad_reports/ReportCashFlow_F0.html" ISDEFAULT="N" />
   <AD_MODEL_OBJECT_MAPPING AD_MODEL_OBJECT_MAPPING_ID="1000600001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 20:26:57.0" CREATEDBY="100" UPDATED="2007-10-21 20:26:57.0" UPDATEDBY="100" AD_MODEL_OBJECT_ID="804366" MAPPINGNAME="/ad_reports/ReportCashFlow_F1.html" ISDEFAULT="N" />
   <AD_MODEL_OBJECT_MAPPING AD_MODEL_OBJECT_MAPPING_ID="1004400006" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-29 19:21:41.0" CREATEDBY="100" UPDATED="2008-01-29 19:21:41.0" UPDATEDBY="100" AD_MODEL_OBJECT_ID="1004400004" MAPPINGNAME="/ad_callouts/SL_RequisitionLine_Amt.html" ISDEFAULT="Y" />
--- a/database/sourcedata/AD_PROCESS.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_PROCESS.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -286,6 +286,8 @@
   <AD_PROCESS AD_PROCESS_ID="800205" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-24 18:58:26.0" CREATEDBY="100" UPDATED="2007-07-24 18:58:48.0" UPDATEDBY="100" VALUE="ReportSalesDimensionalAnalyzeJR" NAME="Invoice (customer) Dimensional Report " DESCRIPTION="Invoice customer dimensional analyses " HELP="Invoice customer dimensional analyses JR" ACCESSLEVEL="3" ENTITYTYPE="U" ISUSERSTARTABLE="N" ISREPORT="Y" ISDIRECTPRINT="N" ISBACKGROUND="N" ISJASPER="N" />
   <AD_PROCESS AD_PROCESS_ID="800206" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-17 10:41:31.0" CREATEDBY="100" UPDATED="2007-09-17 10:44:49.0" UPDATEDBY="100" VALUE="ReportCashFlow" NAME="Report Cash Flow" DESCRIPTION="Report Cash Flow" ACCESSLEVEL="3" ENTITYTYPE="U" ISUSERSTARTABLE="N" ISREPORT="Y" ISDIRECTPRINT="N" ISBACKGROUND="N" ISJASPER="N" />
   <AD_PROCESS AD_PROCESS_ID="800207" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-17 10:43:37.0" CREATEDBY="100" UPDATED="2007-09-17 10:43:37.0" UPDATEDBY="100" VALUE="CreateCashFlowStatement" NAME="Create Cash Flow Statement" DESCRIPTION="Create Cash Flow Statement" ACCESSLEVEL="3" ENTITYTYPE="U" ISUSERSTARTABLE="N" ISREPORT="N" ISDIRECTPRINT="N" ISBACKGROUND="N" ISJASPER="N" />
+  <AD_PROCESS AD_PROCESS_ID="1000500000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 20:15:26.0" CREATEDBY="100" UPDATED="2008-04-06 20:15:26.0" UPDATEDBY="100" VALUE="Report Pareto Product" NAME="Report Pareto Product" DESCRIPTION="Report Pareto Product" HELP="Report Pareto Product" ACCESSLEVEL="3" ENTITYTYPE="U" ISUSERSTARTABLE="N" ISREPORT="Y" ISDIRECTPRINT="N" ISBACKGROUND="N" ISJASPER="N" />
+  <AD_PROCESS AD_PROCESS_ID="1000500001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-07 18:57:49.0" CREATEDBY="100" UPDATED="2008-04-07 18:57:49.0" UPDATEDBY="100" VALUE="M_UPDATE_PARETO_PRODUCT" NAME="M_UPDATE_PARETO_PRODUCT" DESCRIPTION="Updates a Org specific column of the product depending on the Pareto distribution" HELP="Updates a Org specific column of the product depending on the Pareto distribution" ACCESSLEVEL="1" ENTITYTYPE="U" ISUSERSTARTABLE="N" PROCEDURENAME="M_UPDATE_PARETO_PRODUCT0" ISREPORT="N" ISDIRECTPRINT="N" ISBACKGROUND="N" ISJASPER="N" />
   <AD_PROCESS AD_PROCESS_ID="1004400000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-28 13:42:55.0" CREATEDBY="100" UPDATED="2008-03-25 16:52:15.0" UPDATEDBY="100" VALUE="M_Requisition_CreatePO" NAME="Create Purchase Order" ACCESSLEVEL="1" ENTITYTYPE="U" ISUSERSTARTABLE="N" PROCEDURENAME="M_Requisition_CreatePO" ISREPORT="N" ISDIRECTPRINT="N" ISBACKGROUND="N" ISJASPER="N">
     <HELP><![CDATA[This process will create several Purchase Orders to complete all the requisition lines. One order line is created for each requisition line with the necessary quantity to fulfill the requested quantity. The process closes the requisition when it finishes successfully.
 The Order Date is used for the necessary dates of the Purchase Orders.
--- a/database/sourcedata/AD_PROCESS_PARA.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_PROCESS_PARA.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -273,10 +273,12 @@
   <AD_PROCESS_PARA AD_PROCESS_PARA_ID="800058" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-11 10:51:42.0" CREATEDBY="100" UPDATED="2007-07-31 09:01:46.0" UPDATEDBY="100" NAME="Ending Date" DESCRIPTION="A parameter stating the ending time range related for a specified request, query, etc. " HELP="The Date To indicates the end date of a range (inclusive)" AD_PROCESS_ID="800171" SEQNO="40" AD_REFERENCE_ID="15" COLUMNNAME="DateTo" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="10" ISMANDATORY="N" ISRANGE="N" AD_ELEMENT_ID="1582" ENTITYTYPE="U" />
   <AD_PROCESS_PARA AD_PROCESS_PARA_ID="800059" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-11 10:53:38.0" CREATEDBY="100" UPDATED="2007-07-31 09:01:56.0" UPDATEDBY="100" NAME="Project" DESCRIPTION="A defined task or undertaking" HELP="Project ID is a user defined identifier for a Project" AD_PROCESS_ID="800171" SEQNO="50" AD_REFERENCE_ID="30" AD_REFERENCE_VALUE_ID="800061" COLUMNNAME="C_Project_ID" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="40" ISMANDATORY="N" ISRANGE="N" AD_ELEMENT_ID="208" ENTITYTYPE="U" />
   <AD_PROCESS_PARA AD_PROCESS_PARA_ID="800060" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-11 10:59:25.0" CREATEDBY="100" UPDATED="2007-08-09 17:47:26.0" UPDATEDBY="100" NAME="Service Point" DESCRIPTION="The location where products arrive to or are sent from." HELP="&#xd;&#xa;The Warehouse identifies a unique Warehouse where products are stored or Services are provided." AD_PROCESS_ID="800171" SEQNO="60" AD_REFERENCE_ID="19" COLUMNNAME="M_Warehouse_ID" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="0" ISMANDATORY="N" ISRANGE="N" AD_ELEMENT_ID="459" ENTITYTYPE="U" />
+  <AD_PROCESS_PARA AD_PROCESS_PARA_ID="1000500000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 15:31:51.0" CREATEDBY="100" UPDATED="2008-04-06 16:09:11.0" UPDATEDBY="100" NAME="ABC" DESCRIPTION="ABC classification according to a Pareto distribution" HELP="ABC classification according to a Pareto distribution" AD_PROCESS_ID="105" SEQNO="40" AD_REFERENCE_ID="17" AD_REFERENCE_VALUE_ID="1000500000" COLUMNNAME="ABC" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="1" ISMANDATORY="N" ISRANGE="N" AD_ELEMENT_ID="1000500001" ENTITYTYPE="U" />
+  <AD_PROCESS_PARA AD_PROCESS_PARA_ID="1000600000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-07 11:31:48.0" CREATEDBY="100" UPDATED="2008-04-07 12:51:22.0" UPDATEDBY="100" NAME="Accounting schema" AD_PROCESS_ID="140" SEQNO="20" AD_REFERENCE_ID="19" COLUMNNAME="C_AcctSchema_ID" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="10" ISMANDATORY="N" ISRANGE="N" DEFAULTVALUE="@C_AcctSchema_ID@" AD_ELEMENT_ID="181" ENTITYTYPE="U" />
+  <AD_PROCESS_PARA AD_PROCESS_PARA_ID="1000600001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-07 16:48:41.0" CREATEDBY="100" UPDATED="2008-04-07 16:58:33.0" UPDATEDBY="100" NAME="Accounting schema" AD_PROCESS_ID="112" SEQNO="20" AD_REFERENCE_ID="19" COLUMNNAME="C_AcctSchema_ID" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="10" ISMANDATORY="N" ISRANGE="N" DEFAULTVALUE="@C_AcctSchema_ID@" ENTITYTYPE="U" />
   <AD_PROCESS_PARA AD_PROCESS_PARA_ID="1004400000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-25 12:14:41.0" CREATEDBY="100" UPDATED="2008-03-25 12:37:34.0" UPDATEDBY="100" NAME="Order Date" DESCRIPTION="The time listed on the order." HELP="Indicates the Date an item was ordered." AD_PROCESS_ID="1004400000" SEQNO="10" AD_REFERENCE_ID="15" COLUMNNAME="DateOrdered" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="10" ISMANDATORY="Y" ISRANGE="N" AD_ELEMENT_ID="268" ENTITYTYPE="U" />
   <AD_PROCESS_PARA AD_PROCESS_PARA_ID="1004400001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-25 12:15:41.0" CREATEDBY="100" UPDATED="2008-03-25 12:56:05.0" UPDATEDBY="100" NAME="Business Partner " DESCRIPTION="Anyone who takes part in daily business operations by acting as a customer, employee, etc." HELP="A Business Partner is anyone with whom you transact.  This can include Vendor, Customer, Employee or Salesperson" AD_PROCESS_ID="1004400000" SEQNO="20" AD_REFERENCE_ID="30" AD_REFERENCE_VALUE_ID="800057" COLUMNNAME="C_BPartner_ID" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="30" ISMANDATORY="N" ISRANGE="N" AD_ELEMENT_ID="187" ENTITYTYPE="U" />
   <AD_PROCESS_PARA AD_PROCESS_PARA_ID="1004400002" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-25 12:16:31.0" CREATEDBY="100" UPDATED="2008-03-27 12:19:44.0" UPDATEDBY="100" NAME="Price List" DESCRIPTION="A catalog of selected items with prices defined generally or for a specific partner." HELP="Price Lists are used to determine the pricing, margin and cost of items purchased or sold." AD_PROCESS_ID="1004400000" SEQNO="30" AD_REFERENCE_ID="19" AD_VAL_RULE_ID="1004400001" COLUMNNAME="M_PriceList_ID" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="20" ISMANDATORY="N" ISRANGE="N" AD_ELEMENT_ID="449" ENTITYTYPE="U" />
   <AD_PROCESS_PARA AD_PROCESS_PARA_ID="1004400003" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-25 12:17:15.0" CREATEDBY="100" UPDATED="2008-03-25 17:06:41.0" UPDATEDBY="100" NAME="Organization" DESCRIPTION="Organizational entity within client" HELP="An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations." AD_PROCESS_ID="1004400000" SEQNO="40" AD_REFERENCE_ID="19" AD_VAL_RULE_ID="130" COLUMNNAME="AD_Org_ID" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="20" ISMANDATORY="Y" ISRANGE="N" AD_ELEMENT_ID="113" ENTITYTYPE="U" />
   <AD_PROCESS_PARA AD_PROCESS_PARA_ID="1004400004" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-25 12:18:01.0" CREATEDBY="100" UPDATED="2008-04-02 11:01:06.0" UPDATEDBY="100" NAME="Service Point" DESCRIPTION="The location where products arrive to or are sent from." HELP="&#xd;&#xa;The Warehouse identifies a unique Warehouse where products are stored or Services are provided." AD_PROCESS_ID="1004400000" SEQNO="50" AD_REFERENCE_ID="19" COLUMNNAME="M_Warehouse_ID" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="20" ISMANDATORY="Y" ISRANGE="N" AD_ELEMENT_ID="459" ENTITYTYPE="U" />
-  <AD_PROCESS_PARA AD_PROCESS_PARA_ID="1000600000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-07 11:31:48.0" CREATEDBY="100" UPDATED="2008-04-07 12:51:22.0" UPDATEDBY="100" NAME="Accounting schema" AD_PROCESS_ID="140" SEQNO="20" AD_REFERENCE_ID="19" COLUMNNAME="C_AcctSchema_ID" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="10" ISMANDATORY="N" ISRANGE="N" DEFAULTVALUE="@C_AcctSchema_ID@" AD_ELEMENT_ID="181" ENTITYTYPE="U" />
-  <AD_PROCESS_PARA AD_PROCESS_PARA_ID="1000600001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-07 16:48:41.0" CREATEDBY="100" UPDATED="2008-04-07 16:58:33.0" UPDATEDBY="100" NAME="Accounting schema" AD_PROCESS_ID="112" SEQNO="20" AD_REFERENCE_ID="19" COLUMNNAME="C_AcctSchema_ID" ISCENTRALLYMAINTAINED="Y" FIELDLENGTH="10" ISMANDATORY="N" ISRANGE="N" DEFAULTVALUE="@C_AcctSchema_ID@" ENTITYTYPE="U" /></data>
+  </data>
--- a/database/sourcedata/AD_PROCESS_PARA_TRL.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_PROCESS_PARA_TRL.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -275,6 +275,7 @@
   <AD_PROCESS_PARA_TRL AD_PROCESS_PARA_ID="800058" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-11 10:51:42.0" CREATEDBY="100" UPDATED="2007-07-11 17:01:30.0" UPDATEDBY="100" NAME="Hasta la fecha" DESCRIPTION="Parámetro que establece el intervalo de finalización de una petición, consulta, etc. específicas." HELP="&lt;P>Indica la fecha de finalización de la oferta.&lt;/P>" ISTRANSLATED="N" />
   <AD_PROCESS_PARA_TRL AD_PROCESS_PARA_ID="800059" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-11 10:53:38.0" CREATEDBY="100" UPDATED="2007-07-11 17:01:41.0" UPDATEDBY="100" NAME="Proyecto" DESCRIPTION="Tarea o emprendimiento definido." HELP="Identificador&amp;nbsp;del proyecto definido por el usuario. " ISTRANSLATED="N" />
   <AD_PROCESS_PARA_TRL AD_PROCESS_PARA_ID="800060" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-11 10:59:25.0" CREATEDBY="100" UPDATED="2007-08-09 17:47:26.0" UPDATEDBY="100" NAME="Almacén" DESCRIPTION="Ubicación a la que se envían, o de donde proceden, los productos." HELP="Identifica un único almacén donde los productos son almacenados o los servicios facilitados." ISTRANSLATED="N" />
+  <AD_PROCESS_PARA_TRL AD_PROCESS_PARA_ID="1000500000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 15:31:51.0" CREATEDBY="100" UPDATED="2008-04-06 15:31:51.0" UPDATEDBY="100" NAME="ABC" DESCRIPTION="ABC classification according to a Pareto distribution" HELP="ABC classification according to a Pareto distribution" ISTRANSLATED="N" />
   <AD_PROCESS_PARA_TRL AD_PROCESS_PARA_ID="1004400000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-25 12:14:41.0" CREATEDBY="100" UPDATED="2008-03-25 12:37:34.0" UPDATEDBY="100" NAME="Fecha de pedido" DESCRIPTION="Fecha de factura del pedido." HELP="Fecha en la que se hizo el pedido." ISTRANSLATED="N" />
   <AD_PROCESS_PARA_TRL AD_PROCESS_PARA_ID="1004400001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-25 12:15:41.0" CREATEDBY="100" UPDATED="2008-03-25 12:37:34.0" UPDATEDBY="100" NAME="Tercero" DESCRIPTION="Persona que participa en operaciones diarias de negocios, como cliente, empleado, etc." HELP="Un tercero es cualquier entidad, organización o particular&amp;nbsp;con&amp;nbsp;quien se realizan operaciones y&amp;nbsp;transacciones. Esto incluye proveedores, clientes y empleados. " ISTRANSLATED="N" />
   <AD_PROCESS_PARA_TRL AD_PROCESS_PARA_ID="1004400002" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-25 12:16:31.0" CREATEDBY="100" UPDATED="2008-03-25 12:37:34.0" UPDATEDBY="100" NAME="Tarifa" DESCRIPTION="Catálogo de ítems seleccionados que contiene los precios generales o los de un partner específico." ISTRANSLATED="N">
--- a/database/sourcedata/AD_PROCESS_TRL.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_PROCESS_TRL.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -309,6 +309,8 @@
   <AD_PROCESS_TRL AD_PROCESS_ID="800205" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-24 18:58:26.0" CREATEDBY="100" UPDATED="2007-07-27 15:27:38.0" UPDATEDBY="100" NAME="Análisis dimensional facturas " DESCRIPTION="Análisis dimensional de factura venta " ISTRANSLATED="N" />
   <AD_PROCESS_TRL AD_PROCESS_ID="800206" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-17 10:41:31.0" CREATEDBY="100" UPDATED="2007-09-17 10:44:49.0" UPDATEDBY="100" NAME="ReportCashFlow" DESCRIPTION="ReportCashFlow" ISTRANSLATED="N" />
   <AD_PROCESS_TRL AD_PROCESS_ID="800207" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-17 10:43:37.0" CREATEDBY="100" UPDATED="2007-09-17 10:47:17.0" UPDATEDBY="100" NAME="Generar Cash Flow" DESCRIPTION="Generar Cash Flow" ISTRANSLATED="Y" />
+  <AD_PROCESS_TRL AD_PROCESS_ID="1000500000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 20:15:26.0" CREATEDBY="100" UPDATED="2008-04-06 20:15:26.0" UPDATEDBY="100" NAME="Report Pareto Product" DESCRIPTION="Report Pareto Product" HELP="Report Pareto Product" ISTRANSLATED="N" />
+  <AD_PROCESS_TRL AD_PROCESS_ID="1000500001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-07 18:57:49.0" CREATEDBY="100" UPDATED="2008-04-07 18:57:49.0" UPDATEDBY="100" NAME="M_UPDATE_PARETO_PRODUCT" DESCRIPTION="Updates a Org specific column of the product depending on the Pareto distribution" HELP="Updates a Org specific column of the product depending on the Pareto distribution" ISTRANSLATED="N" />
   <AD_PROCESS_TRL AD_PROCESS_ID="1004400000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-28 13:42:55.0" CREATEDBY="100" UPDATED="2008-03-25 17:02:28.0" UPDATEDBY="100" NAME="Crear Pedido de Compra" ISTRANSLATED="Y">
     <HELP><![CDATA[Este proceso genere diferentes Pedidos de Compra para cumplir con las líneas de la necesidad de material. Por cada línea de necesidad de material es generada una línea de Pedido de Compra con la cantidad necesaria para cumplir con la requerida. El proceso cierra la necesidad de material cuando finaliza satisfactoriamente.
 La Fecha de Pedido es la usada para todas las fechas necesarias de los Pedidos de Compra.
--- a/database/sourcedata/AD_REFERENCE.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_REFERENCE.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -318,6 +318,7 @@
   <AD_REFERENCE AD_REFERENCE_ID="800105" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-06-19 13:28:30.0" CREATEDBY="100" UPDATED="2007-06-19 13:35:29.0" UPDATEDBY="100" NAME="AD_Role" DESCRIPTION="User Role" VALIDATIONTYPE="T" ENTITYTYPE="U" />
   <AD_REFERENCE AD_REFERENCE_ID="800106" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-06-19 18:29:03.0" CREATEDBY="100" UPDATED="2007-06-19 18:29:10.0" UPDATEDBY="100" NAME="AD_Language system" VALIDATIONTYPE="T" ENTITYTYPE="U" />
   <AD_REFERENCE AD_REFERENCE_ID="1000300000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-12 17:48:54.0" CREATEDBY="100" UPDATED="2008-03-12 17:56:31.0" UPDATEDBY="100" NAME="AD_AlertRule Type" DESCRIPTION="Alert Rule Type" HELP="Type of an Alert Rule. Data driven (check for a valid SQL clause) or External (not check the SQL clause)." VALIDATIONTYPE="L" ENTITYTYPE="U" />
+  <AD_REFERENCE AD_REFERENCE_ID="1000500000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 16:03:17.0" CREATEDBY="100" UPDATED="2008-04-06 16:03:17.0" UPDATEDBY="100" NAME="M_Product_Org - ABC" DESCRIPTION="ABC classification according to a Pareto distribution" HELP="ABC classification according to a Pareto distribution" VALIDATIONTYPE="L" ENTITYTYPE="U" />
   <AD_REFERENCE AD_REFERENCE_ID="1004400000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-22 17:03:49.0" CREATEDBY="100" UPDATED="2008-01-28 16:21:16.0" UPDATEDBY="100" NAME="Requisition status" HELP="List of the possible status of a requisition:&#xd;&#xa;-O: Open&#xd;&#xa;-P: Planned&#xd;&#xa;-C: Closed&#xd;&#xa;-D: Cancelled" VALIDATIONTYPE="L" ENTITYTYPE="U" />
   <AD_REFERENCE AD_REFERENCE_ID="1004400001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-01 17:58:13.0" CREATEDBY="100" UPDATED="2008-04-01 17:58:13.0" UPDATEDBY="100" NAME="Requisition lock cause" VALIDATIONTYPE="L" ENTITYTYPE="U" />
   <AD_REFERENCE AD_REFERENCE_ID="1005900000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-25 09:42:45.0" CREATEDBY="100" UPDATED="2008-03-25 09:42:45.0" UPDATEDBY="100" NAME="All_Processed_Status_Expenses" VALIDATIONTYPE="L" ENTITYTYPE="U" />
--- a/database/sourcedata/AD_REFERENCE_TRL.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_REFERENCE_TRL.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -299,6 +299,7 @@
   <AD_REFERENCE_TRL AD_REFERENCE_ID="800105" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-06-19 13:28:30.0" CREATEDBY="100" UPDATED="2007-06-19 13:35:29.0" UPDATEDBY="100" NAME="AD_Rol" DESCRIPTION="User Rol" ISTRANSLATED="N" />
   <AD_REFERENCE_TRL AD_REFERENCE_ID="800106" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-06-19 18:29:03.0" CREATEDBY="100" UPDATED="2007-06-19 18:29:03.0" UPDATEDBY="100" NAME="AD_Language system" ISTRANSLATED="N" />
   <AD_REFERENCE_TRL AD_REFERENCE_ID="1000300000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-12 17:48:54.0" CREATEDBY="100" UPDATED="2008-03-12 17:56:31.0" UPDATEDBY="100" NAME="AD_AlertRuleType" DESCRIPTION="Tipo de Alerta" HELP="Verificar la sentencia SQL o no" ISTRANSLATED="N" />
+  <AD_REFERENCE_TRL AD_REFERENCE_ID="1000500000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 16:03:17.0" CREATEDBY="100" UPDATED="2008-04-06 16:03:17.0" UPDATEDBY="100" NAME="M_Product_Org - ABC" DESCRIPTION="ABC classification according to a Pareto distribution" HELP="ABC classification according to a Pareto distribution" ISTRANSLATED="N" />
   <AD_REFERENCE_TRL AD_REFERENCE_ID="1004400000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-22 17:03:49.0" CREATEDBY="100" UPDATED="2008-01-28 16:21:16.0" UPDATEDBY="100" NAME="Estado de necesidad de material" HELP="List of the possible status of a requisition:&#xd;&#xa;-O: Open&#xd;&#xa;-P: Planned&#xd;&#xa;-C: Closed" ISTRANSLATED="N" />
   <AD_REFERENCE_TRL AD_REFERENCE_ID="1004400001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-01 17:58:13.0" CREATEDBY="100" UPDATED="2008-04-01 17:58:34.0" UPDATEDBY="100" NAME="Causa de bloqueo de necesidad" ISTRANSLATED="Y" />
   <AD_REFERENCE_TRL AD_REFERENCE_ID="1005900000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-25 09:42:45.0" CREATEDBY="100" UPDATED="2008-03-25 09:42:45.0" UPDATEDBY="100" NAME="All_Processed_Status_Expenses" ISTRANSLATED="N" />
--- a/database/sourcedata/AD_REF_LIST.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_REF_LIST.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -686,6 +686,9 @@
   <AD_REF_LIST AD_REF_LIST_ID="800259" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-08-02 19:09:10.0" CREATEDBY="100" UPDATED="2007-08-02 19:09:10.0" UPDATEDBY="100" VALUE="TR" NAME="Tax report" AD_REFERENCE_ID="120" ENTITYTYPE="U" />
   <AD_REF_LIST AD_REF_LIST_ID="1000300000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-12 17:54:03.0" CREATEDBY="100" UPDATED="2008-03-12 17:54:03.0" UPDATEDBY="100" VALUE="D" NAME="Data Driven" DESCRIPTION="Check for a valid SQL clause" AD_REFERENCE_ID="1000300000" ENTITYTYPE="U" />
   <AD_REF_LIST AD_REF_LIST_ID="1000300001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-12 17:54:49.0" CREATEDBY="100" UPDATED="2008-03-12 17:54:49.0" UPDATEDBY="100" VALUE="E" NAME="External" DESCRIPTION="Not check for a valid SQL clause. Used for external alert creation" AD_REFERENCE_ID="1000300000" ENTITYTYPE="U" />
+  <AD_REF_LIST AD_REF_LIST_ID="1000500000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 16:03:37.0" CREATEDBY="100" UPDATED="2008-04-06 16:03:37.0" UPDATEDBY="100" VALUE="A" NAME="A" AD_REFERENCE_ID="1000500000" ENTITYTYPE="U" />
+  <AD_REF_LIST AD_REF_LIST_ID="1000500001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 16:03:48.0" CREATEDBY="100" UPDATED="2008-04-06 16:03:48.0" UPDATEDBY="100" VALUE="B" NAME="B" AD_REFERENCE_ID="1000500000" ENTITYTYPE="U" />
+  <AD_REF_LIST AD_REF_LIST_ID="1000500002" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 16:03:54.0" CREATEDBY="100" UPDATED="2008-04-06 16:03:54.0" UPDATEDBY="100" VALUE="C" NAME="C" AD_REFERENCE_ID="1000500000" ENTITYTYPE="U" />
   <AD_REF_LIST AD_REF_LIST_ID="1004400000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-22 17:06:37.0" CREATEDBY="100" UPDATED="2008-01-22 17:07:23.0" UPDATEDBY="100" VALUE="O" NAME="Open" DESCRIPTION="The requisition line has not been inclluded in a Purchasing plan, neither has an associated purchase order." AD_REFERENCE_ID="1004400000" ENTITYTYPE="U" />
   <AD_REF_LIST AD_REF_LIST_ID="1004400001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-22 17:08:39.0" CREATEDBY="100" UPDATED="2008-01-22 17:08:39.0" UPDATEDBY="100" VALUE="P" NAME="Planned" DESCRIPTION="The requisition has been included in a Purchase Plan and purchase orders have been created." AD_REFERENCE_ID="1004400000" ENTITYTYPE="U" />
   <AD_REF_LIST AD_REF_LIST_ID="1004400002" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-22 17:10:13.0" CREATEDBY="100" UPDATED="2008-01-22 17:10:59.0" UPDATEDBY="100" VALUE="C" NAME="Closed" DESCRIPTION="The requisition has at least an associated purchase order." AD_REFERENCE_ID="1004400000" ENTITYTYPE="U" />
--- a/database/sourcedata/AD_REF_LIST_TRL.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_REF_LIST_TRL.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -686,6 +686,9 @@
   <AD_REF_LIST_TRL AD_REF_LIST_ID="800259" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-08-02 19:09:10.0" CREATEDBY="100" UPDATED="2007-08-02 19:09:10.0" UPDATEDBY="100" NAME="Tax report" ISTRANSLATED="N" />
   <AD_REF_LIST_TRL AD_REF_LIST_ID="1000300000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-12 17:54:03.0" CREATEDBY="100" UPDATED="2008-03-12 17:54:03.0" UPDATEDBY="100" NAME="Data Driven" DESCRIPTION="Check for a valid SQL clause" ISTRANSLATED="N" />
   <AD_REF_LIST_TRL AD_REF_LIST_ID="1000300001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-12 17:54:49.0" CREATEDBY="100" UPDATED="2008-03-12 17:54:49.0" UPDATEDBY="100" NAME="External" DESCRIPTION="Not check for a valid SQL clause. Used for external alert creation" ISTRANSLATED="N" />
+  <AD_REF_LIST_TRL AD_REF_LIST_ID="1000500000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 16:03:37.0" CREATEDBY="100" UPDATED="2008-04-06 16:03:37.0" UPDATEDBY="100" NAME="A" ISTRANSLATED="N" />
+  <AD_REF_LIST_TRL AD_REF_LIST_ID="1000500001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 16:03:48.0" CREATEDBY="100" UPDATED="2008-04-06 16:03:48.0" UPDATEDBY="100" NAME="B" ISTRANSLATED="N" />
+  <AD_REF_LIST_TRL AD_REF_LIST_ID="1000500002" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 16:03:54.0" CREATEDBY="100" UPDATED="2008-04-06 16:03:54.0" UPDATEDBY="100" NAME="C" ISTRANSLATED="N" />
   <AD_REF_LIST_TRL AD_REF_LIST_ID="1004400000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-22 17:06:37.0" CREATEDBY="100" UPDATED="2008-01-22 17:11:28.0" UPDATEDBY="100" NAME="Abierta" DESCRIPTION="La necesidad de material no ha sido incluída en un Plan de producción ni tiene un pedido de compra asociado." ISTRANSLATED="N" />
   <AD_REF_LIST_TRL AD_REF_LIST_ID="1004400001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-22 17:08:39.0" CREATEDBY="100" UPDATED="2008-01-22 17:09:23.0" UPDATEDBY="100" NAME="Planificada" DESCRIPTION="La necesidad de material ha sido incluída en una planificación de compras de la que se han generado pedidos de compra." ISTRANSLATED="Y" />
   <AD_REF_LIST_TRL AD_REF_LIST_ID="1004400002" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-01-22 17:10:13.0" CREATEDBY="100" UPDATED="2008-01-22 17:10:59.0" UPDATEDBY="100" NAME="Closed" DESCRIPTION="La necesidad de material tiene al menos un pedido de compra asociado." ISTRANSLATED="N" />
--- a/database/sourcedata/AD_TEXTINTERFACES.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_TEXTINTERFACES.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -1478,6 +1478,9 @@
   <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="1000500011" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 12:33:42.0" CREATEDBY="0" UPDATED="2008-03-17 12:33:42.0" UPDATEDBY="0" TEXT="Accounting schema" FILENAME="/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.html" ISUSED="Y" />
   <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="1000500012" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 12:33:51.0" CREATEDBY="0" UPDATED="2008-03-17 12:33:51.0" UPDATEDBY="0" TEXT="Organization:  " FILENAME="/org/openbravo/erpCommon/ad_reports/GeneralAccountingReportsPDF.fo" ISUSED="Y" />
   <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="1000500013" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-27 07:45:44.0" CREATEDBY="0" UPDATED="2008-03-27 07:45:44.0" UPDATEDBY="0" TEXT="Accounting schema " FILENAME="/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.html" ISUSED="Y" />
+  <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="1000500017" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-07 18:29:14.0" CREATEDBY="0" UPDATED="2008-04-07 18:29:14.0" UPDATEDBY="0" TEXT="Pareto Report for Products" FILENAME="/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.html" ISUSED="Y" />
+  <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="1000500018" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-07 18:29:14.0" CREATEDBY="0" UPDATED="2008-04-07 18:29:14.0" UPDATEDBY="0" TEXT="Search Key" FILENAME="/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.html" ISUSED="Y" />
+  <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="1000500019" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-07 18:29:14.0" CREATEDBY="0" UPDATED="2008-04-07 18:29:14.0" UPDATEDBY="0" TEXT="Percentage" FILENAME="/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.html" ISUSED="Y" />
   <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="1002500000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-12-14 09:14:38.0" CREATEDBY="0" UPDATED="2007-12-14 09:14:38.0" UPDATEDBY="0" TEXT="Year " FILENAME="/org/openbravo/erpCommon/ad_process/CreateAccountingReport.html" ISUSED="Y" />
   <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="1002500001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-12-14 09:14:38.0" CREATEDBY="0" UPDATED="2007-12-14 09:14:38.0" UPDATEDBY="0" TEXT="Role information" FILENAME="/org/openbravo/erpCommon/ad_forms/Role.html" ISUSED="Y" />
   <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="1004400008" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-02-18 14:03:41.0" CREATEDBY="0" UPDATED="2008-02-18 14:03:41.0" UPDATEDBY="0" TEXT="Qty." FILENAME="/org/openbravo/erpReports/RptM_Requisition_Lines.jrxml" ISUSED="Y" />
--- a/database/sourcedata/AD_TEXTINTERFACES_TRL.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_TEXTINTERFACES_TRL.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -1476,6 +1476,9 @@
   <AD_TEXTINTERFACES_TRL AD_TEXTINTERFACES_ID="1000500011" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 12:33:42.0" CREATEDBY="0" UPDATED="2008-03-17 12:33:42.0" UPDATEDBY="0" TEXT="Accounting schema" ISTRANSLATED="N" />
   <AD_TEXTINTERFACES_TRL AD_TEXTINTERFACES_ID="1000500012" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-17 12:33:51.0" CREATEDBY="0" UPDATED="2008-03-17 12:33:51.0" UPDATEDBY="0" TEXT="Organization:  " ISTRANSLATED="N" />
   <AD_TEXTINTERFACES_TRL AD_TEXTINTERFACES_ID="1000500013" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-27 07:45:44.0" CREATEDBY="0" UPDATED="2008-03-27 07:45:44.0" UPDATEDBY="0" TEXT="Accounting schema " ISTRANSLATED="N" />
+  <AD_TEXTINTERFACES_TRL AD_TEXTINTERFACES_ID="1000500017" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-07 18:29:14.0" CREATEDBY="0" UPDATED="2008-04-07 18:32:59.0" UPDATEDBY="0" TEXT="Informe de Pareto para Productos" ISTRANSLATED="Y" />
+  <AD_TEXTINTERFACES_TRL AD_TEXTINTERFACES_ID="1000500018" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-07 18:29:14.0" CREATEDBY="0" UPDATED="2008-04-07 18:35:13.0" UPDATEDBY="0" TEXT="Clave" ISTRANSLATED="Y" />
+  <AD_TEXTINTERFACES_TRL AD_TEXTINTERFACES_ID="1000500019" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-07 18:29:14.0" CREATEDBY="0" UPDATED="2008-04-07 18:33:34.0" UPDATEDBY="0" TEXT="Porcentaje" ISTRANSLATED="Y" />
   <AD_TEXTINTERFACES_TRL AD_TEXTINTERFACES_ID="1002500000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-12-14 09:14:38.0" CREATEDBY="0" UPDATED="2007-12-14 09:46:03.0" UPDATEDBY="100" TEXT="Año " ISTRANSLATED="Y" />
   <AD_TEXTINTERFACES_TRL AD_TEXTINTERFACES_ID="1002500001" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-12-14 09:14:38.0" CREATEDBY="0" UPDATED="2007-12-14 09:56:27.0" UPDATEDBY="100" TEXT="Información de Rol" ISTRANSLATED="Y" />
   <AD_TEXTINTERFACES_TRL AD_TEXTINTERFACES_ID="1004400008" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-02-18 14:03:41.0" CREATEDBY="0" UPDATED="2008-02-18 14:03:41.0" UPDATEDBY="0" TEXT="Cant." ISTRANSLATED="N" />
--- a/database/sourcedata/AD_TREENODE.xml	Tue Apr 08 13:58:00 2008 +0000
+++ b/database/sourcedata/AD_TREENODE.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -471,6 +471,7 @@
   <AD_TREENODE AD_TREE_ID="10" NODE_ID="800289" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-17 10:45:35.0" CREATEDBY="100" UPDATED="2007-09-17 10:49:59.0" UPDATEDBY="100" PARENT_ID="280" SEQNO="200" />
   <AD_TREENODE AD_TREE_ID="10" NODE_ID="800290" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-09-17 10:46:29.0" CREATEDBY="100" UPDATED="2007-09-17 10:49:59.0" UPDATEDBY="100" PARENT_ID="280" SEQNO="190" />
   <AD_TREENODE AD_TREE_ID="10" NODE_ID="1000001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-01-19 12:09:01.0" CREATEDBY="100" UPDATED="2007-08-13 18:02:37.0" UPDATEDBY="100" PARENT_ID="0" SEQNO="160" />
+  <AD_TREENODE AD_TREE_ID="10" NODE_ID="1000500000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-04-06 20:18:15.0" CREATEDBY="100" UPDATED="2008-04-07 20:04:39.0" UPDATEDBY="100" PARENT_ID="800078" SEQNO="240" />
   <AD_TREENODE AD_TREE_ID="10" NODE_ID="1004400000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-02-06 19:55:16.0" CREATEDBY="100" UPDATED="2008-03-05 18:30:57.0" UPDATEDBY="100" PARENT_ID="800242" SEQNO="20" />
   <AD_TREENODE AD_TREE_ID="10" NODE_ID="1004400001" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-03-05 18:30:31.0" CREATEDBY="100" UPDATED="2008-03-05 18:30:57.0" UPDATEDBY="100" PARENT_ID="800242" SEQNO="30" />
   <AD_TREENODE AD_TREE_ID="20" NODE_ID="0" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-11-16 14:56:00.0" CREATEDBY="0" UPDATED="1999-12-09 20:37:12.0" UPDATEDBY="0" SEQNO="0" />
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.html	Tue Apr 08 15:35:33 2008 +0000
@@ -0,0 +1,369 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD Xhtml 1.0 Transitional//EN" "http://www.w3.org/tr/xhtml1/Dtd/xhtml1-transitional.dtd">
+<!--
+ *************************************************************************
+ * The contents of this file are subject to the Openbravo  Public  License
+ * Version  1.0  (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 SL
+ * All portions are Copyright (C) 2001-2008 Openbravo SL
+ * All Rights Reserved.
+ * Contributor(s):  ______________________________________.
+ ************************************************************************
+-->
+<html xmlns="http://www.w3.org/1999/xhtml">
+  <head>
+    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+    <TITLE>Pareto Report for Products</TITLE>
+    <link rel="SHORTCUT ICON" href="../../../../../web/images/favicon.ico" type="image/x-icon" />
+    <link rel="stylesheet" type="text/css" href="../../../../../web/skins/Default/Main/Main_Manual.css" id="paramCSS" />
+    <link rel="stylesheet" type="text/css" href="../../../../../web/skins/Default/Main/Client/DataGrid/DataGrid.css" id="paramCSS" />
+
+    <script language="JavaScript" type="text/javascript" id="paramDirection">
+      var baseDirection = "../../../../../web/";
+      </script>
+      <script language="JavaScript" src="../../../../../web/js/messages.js" type="text/javascript">
+      </script>
+      <script language="JavaScript" src="../utility/MessagesJS.js" type="text/javascript"></script>
+      <script language="JavaScript" type="text/javascript" id="paramLanguage">
+        var LNG_POR_DEFECTO = "en_US";
+      </script>
+      <script language="JavaScript" src="../../../../../web/js/shortcuts.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../../../../../web/js/utils.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../../../../../web/js/windowKeyboard.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../../../../../web/js/searchs.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../../../../../web/js/ajax.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../../../../../web/js/default/MessageBox.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../../../../../web/js/messages.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../utility/MessagesJS.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../../../../../web/js/jscalendar/calendar.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../../../../../web/js/jscalendar/lang/calendar-es.js" type="text/javascript" id="fieldCalendar"></script>
+      <script language="JavaScript" src="../../../../../web/js/default/DateTextBox.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../../../../../web/js/String.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../../../../../web/js/TypeAheadCombo.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../../../../../web/js/dojoConfig.js" type="text/javascript"></script>
+      <script language="JavaScript" src="../../../../../web/js/dojo/dojo.js" type="text/javascript"></script>
+      <script type="text/javascript">
+        dojo.hostenv.writeIncludes(); //makes debugging in Venkman possible
+      </script>
+<SCRIPT language="JavaScript" type="text/javascript">
+function depurar()
+{
+  return true;
+}
+function onloadFunctions() {
+  new TypeAheadCombo("inpadOrgId");
+  new TypeAheadCombo("inpmWarehouseId");  
+}
+</SCRIPT>	  
+    <SCRIPT language="JavaScript" type="text/javascript">
+    function onLoadDo(){
+        this.windowTables = new Array(
+          new windowTableId('client')
+        );
+        setWindowTableParentElement();
+        this.tabsTables = new Array(
+          new tabTableId('tdtopTabs')
+        );
+        setTabTableParentElement();
+        enableShortcuts('edition');
+        
+        resizeArea();
+        updateMenuIcon('buttonMenu');
+
+        setWindowElementFocus('firstElement');
+    }
+
+    function onResizeDo(){
+        resizeArea();
+    }
+    </SCRIPT>
+
+</HEAD>
+<BODY leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="onLoadDo();" onresize="onResizeDo();">
+<FORM method="POST" action="ReportParetoProduct.html" name="frmMain" id="form">
+  <INPUT type="hidden" name="Command"></INPUT>
+  <INPUT type="hidden" name="inpLastFieldChanged" id="paramChanged" value=""></INPUT>  
+  <table height="100%" border="0" cellpadding="0" cellspacing="0" id="main">
+    <tr>
+      <td valign="top" id="tdleftTabs"></td>
+      <td valign="top">
+        <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="Main_ContentPane_Left">
+          <TR><TD class="Main_NavBar_bg_left" id="tdleftSeparator"></TD></TR>
+          <TR><TD class="Main_ToolBar_bg_left" valign="top"></TD></TR>
+          <TR><TD class="Main_Client_bg_left"></TD></TR>
+          <TR><TD class="Main_Bottom_bg_left"></TD></TR>
+        </TABLE>
+      </td>
+      <td valign="top">
+        <div class="Main_ContentPane_NavBar" id="tdtopButtons"></div>
+        <div class="Main_ContentPane_ToolBar" id="paramToolBar"></div>
+        <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="Main_ContentPane_TabPane" id="tdtopTabs">
+          <TR id="paramParentTabContainer"></TR>
+          <TR id="paramMainTabContainer"></TR>
+          <TR id="paramChildTabContainer"></TR>
+        </TABLE>
+        <DIV class="Main_ContentPane_Client" style="overflow: auto; display: none; border-bottom: 0px none;" id="client">
+
+          <!-- MessageBox BEGIN -->
+          <table cellpadding="0" cellspacing="0" id="messageBoxID" class="MessageBoxyy">
+            <TBODY>
+            <tr class="MessageBox_TopMargin">
+              <td class="MessageBox_LeftMargin"></td>
+              <td></td>
+              <td class="MessageBox_RightMargin"></td>
+            </tr>
+            <tr>
+              <td class="MessageBox_LeftMargin"></td>
+              <td>
+
+                <table cellpadding="0" cellspacing="0" style="width: 100%;">
+                  <TBODY>
+                  <tr>
+                    <td>
+                      <div class="MessageBox_TopLeft"></div>
+                      <div class="MessageBox_Left"></div>
+                    </td>
+                    <td class="MessageBox_bg">
+
+                      <table class="MessageBox_Top">
+                      <TBODY>
+                        <tr>
+                          <td>
+                            <span>
+                            <table cellpadding="0" cellspacing="0" class="MessageBox_Body_ContentCell">
+                              <TBODY>
+                              <tr>
+                                <td class="MessageBox_Icon_ContentCell">
+                                  <div class="MessageBox_Icon"></div>
+                                </td>
+                                <td style="vertical-align: top;" id="messageBoxIDContent">
+                                  <span>
+                                    <div class="MessageBox_TextTitle" id="messageBoxIDTitle">
+                                      xxInfo: AccessTableWithNoView
+                                    </div>
+                                    <div class="MessageBox_TextDescription" id="messageBoxIDMessage">
+                                      xxThe current information is empty.
+                                    </div>
+                                    <div class="MessageBox_TextSeparator"></div>
+                                  </span>
+                                </td>
+                              </tr>
+                              </TBODY>
+                            </table>
+                            </span>
+                          </td>
+                        </tr>
+                        </TBODY>
+                      </table>
+
+                    </td>
+                    <td class="MessageBox_RightTrans">
+                      <div class="MessageBox_TopRight"></div>
+                      <div class="MessageBox_Right"></div>
+                    </td>
+                  </tr>
+                  <tr>
+                    <td rowspan="2" class="MessageBox_BottomLeft">
+                    </td>
+                    <td class="MessageBox_BottomTrans MessageBox_bg">
+                    </td>
+                    <td rowspan="2" class="MessageBox_BottomRight">
+                    </td>
+                  </tr>
+                  <tr>
+                    <td class="MessageBox_Bottom">
+                    </td>
+                  </tr>
+                  </TBODY>
+                </table>
+
+              </td>
+              <td class="MessageBox_RightMargin"></td>
+            </tr>
+            <tr class="MessageBox_BottomMargin">
+              <td class="MessageBox_LeftMargin"></td>
+              <td></td>
+              <td class="MessageBox_RightMargin"></td>
+            </tr>
+            </TBODY>
+          </table>
+		  <!-- MessageBox END -->
+          <!-- USER CONTROLS BEGIN -->
+          <TABLE class="Main_Client_TableEdition">
+            <tr>
+              <td class="TableEdition_OneCell_width"></td>
+              <td class="TableEdition_OneCell_width"></td>
+              <td class="TableEdition_OneCell_width"></td>
+              <td class="TableEdition_OneCell_width"></td>
+              <td class="TableEdition_OneCell_width"></td>
+              <td class="TableEdition_OneCell_width"></td>
+            </tr>
+            <TR>
+              <td colspan="6">
+                <table class="FieldGroup" cellspacing="0" cellpadding="0" border="0">
+                <tbody>
+                  <tr class="FieldGroup_TopMargin"/>
+                  <tr>
+                    <td class="FieldGroupTitle_Left"><img class="FieldGroupTitle_Left_bg" border="0" src="../../../../../web/images/blank.gif"/></td>
+                    <td class="FieldGroupTitle">Filter</td>
+                    <td class="FieldGroupTitle_Right"><img class="FieldGroupTitle_Right_bg" border="0" src="../../../../../web/images/blank.gif"/></td>
+                    <td class="FieldGroupContent"/>
+                  </tr>
+                  <tr class="FieldGroup_BottomMargin"/>
+                </tbody>
+                </table>
+              </td>
+            </TR>
+            <TR>
+            <TD class="TitleCell"><SPAN class="LabelText">Organization</SPAN></TD>		
+              <TD class="Combo_ContentCell" colspan="2"> 
+                <SELECT name="inpadOrgId"  id="inpadOrgId" class="Combo Combo_TwoCells_width" onchange="logChanges(this);return true;">
+                  <OPTION value=""> <DIV id="reportAD_Org_ID"></DIV></OPTION>
+                </SELECT>
+              </TD>
+	      <TD class="TitleCell"> <SPAN class="LabelText">Warehouse</SPAN></TD>
+             <TD class="Combo_ContentCell" colspan="2">
+                 <SELECT  name="inpmWarehouseId" id="inpmWarehouseId" class="Combo Combo_TwoCells_width" onchange="logChanges(this);return true;">
+                  <OPTION value=""> <DIV id="reportM_Warehouse_ID"></DIV></OPTION>
+                </SELECT>
+             </TD>
+            </TR>
+			<TR>
+              <td colspan="6">
+                <table class="FieldGroup" cellspacing="0" cellpadding="0" border="0">
+                <tbody>
+                  <tr class="FieldGroup_TopMargin"/>
+                  <tr>
+                    <td class="FieldGroupTitle_Left"><img class="FieldGroupTitle_Left_bg" border="0" src="../../../../../web/images/blank.gif"/></td>
+                    <td class="FieldGroupTitle">View Results</td>
+                    <td class="FieldGroupTitle_Right"><img class="FieldGroupTitle_Right_bg" border="0" src="../../../../../web/images/blank.gif"/></td>
+                    <td class="FieldGroupContent"/>
+                  </tr>
+                  <tr class="FieldGroup_BottomMargin"/>
+                </tbody>
+                </table>
+              </td>
+            </TR>
+
+            <tr>
+              <TD class="TitleCell"></TD>
+              <TD class="Button_CenterAlign_ContentCell">
+                <div>
+                  <a class="ButtonLink" href="#" onfocus="this.className='ButtonLink_hover'; window.status='View Results'; return true;" onblur="this.className='ButtonLink'; window.status=''; return true;" onkeypress="this.className='ButtonLink_active'; return true;" onkeyup="this.className='ButtonLink_hover'; return true;"onclick="submitCommandForm('FIND', false, null, 'ReportParetoProduct.html', '_self', null, false);return false;" >
+                  <table class="Button" onmouseout="this.className='Button';window.status='';return true;" onmouseover="this.className='Button_hover';window.status='Search';return true;" onmousedown="this.className='Button_active';return true;" onmouseup="this.className='Button';return true;">
+                    <tr>
+                      <td class="Button_left"><img class="Button_Icon Button_Icon_search" alt="View Results in a New Window" title="View Results in a New Window" src="../../../../../web/images/blank.gif" border=0/></td>
+                      <td class="Button_text">Search</td>
+                      <td class="Button_right"></td>
+                    </tr>
+                  </table>
+                  </a>
+                </div>
+              </TD>
+              <TD class="ContentCell"></TD>
+              <TD class="TitleCell"></TD>
+              <TD class="ContentCell"></TD>
+              <TD class="ContentCell"></TD>
+            </TR>
+
+          </TABLE>
+          <!-- OUTPUT -->
+          <TABLE class="Main_Client_TableEdition">
+            <TR>
+              <TD colspan="6">
+                <div style="height:25px;" />
+				 
+                <TABLE cellspacing="0" cellpadding="0" width="100%" class="DataGrid_Header_Table DataGrid_Body_Table" style="table-layout: auto;" id="selEliminar">
+				<DIV id="sectionOrg">
+                    
+                    <TR class="DataGrid_Body_Row"> 
+                      <TH colspan="6" class="DataGrid_Header_Cell"><SPAN>Organization<span>: </span><SPAN id="fieldAdOrg">xxOrganization</SPAN></SPAN></TH>
+                    </TR>
+					  <DIV id="sectionPartner">
+                      <TR class="DataGrid_Body_Row"> 
+                        <TH class="DataGrid_Header_Cell">Search Key</TH>
+                        <TH class="DataGrid_Header_Cell">Name</TH>						
+						<TH class="DataGrid_Header_Cell">Attribute</TH>
+						<TH class="DataGrid_Header_Cell">Cost</TH>
+						<TH class="DataGrid_Header_Cell">Percentage</TH>
+						<TH class="DataGrid_Header_Cell">Category</TH>
+                      </TR>                      					  
+	                  <DIV id="sectionDetail"> 
+	                    <TR class="DataGrid_Body_Row DataGrid_Body_Row_yy" id="funcEvenOddRow1xx">
+	                      <TD width="10%" class="DataGrid_Body_Cell" id="fieldSearchKey">xxName</TD>
+	                      <TD width="50%"  class="DataGrid_Body_Cell" id="fieldName">xxY</TD>
+	                      <TD width="15%"  class="DataGrid_Body_Cell" id="fieldAttribute">xxY</TD>
+	                      <TD width="9%"  class="DataGrid_Body_Cell" id="fieldCost">xxY</TD>
+	                      <TD width="8%"  class="DataGrid_Body_Cell" id="fieldPercentage">xxY</TD>
+                          <TD width="8%"  class="DataGrid_Body_Cell" id="fieldIsabc">xxY</TD>
+	                    </TR>
+	                  </DIV>
+                    </DIV>						
+                  </DIV>  
+                </TABLE>				
+                <!-- OUTPUT END -->
+              <!-- USER CONTROLS END -->
+			  
+              </TD>
+            </TR>
+          </TABLE>
+        </div>
+		    <div >
+            <DIV class="Main_ContentPane_Client" style="overflow: auto; border-top: 0px none;" id="tdbottomButtons">
+              <TABLE class="Main_Client_TableEdition" cellspacing="0" cellpadding="0" style="width: 435px">
+                <tr>
+                  <td class="TableEdition_OneCell_width"></td>
+                  <td class="TableEdition_OneCell_width"></td>
+                  <td class="TableEdition_OneCell_width"></td>
+
+                </tr>
+
+                <TR>
+                  <TD></TD>
+                  <TD class="Button_LeftAlign_ContentCell">
+                    <div>
+                        <a class="ButtonLink" href="#" onfocus="setWindowElementFocus(this); window.status='Process'; return true;" onblur="window.status=''; return true;" onkeypress="this.className='ButtonLink_active'; return true;" onkeyup="this.className='ButtonLink_focus'; return true;" onclick="submitCommandForm('GENERATE', true, null, null, null, true, true);return false;">
+                        <table class="Button" onmouseout="this.className='Button';window.status='';return true;" onmouseover="this.className='Button_hover';window.status='Process';return true;" onmousedown="this.className='Button_active';return true;" onmouseup="this.className='Button';return true;">
+                        <tr>
+                          <td class="Button_left"><img class="Button_Icon Button_Icon_process" alt="Process" title="Process" src="../../../../../web/images/blank.gif" border=0/></td>
+                          <td class="Button_text Button_width">Process</td>
+                          <td class="Button_right"></td>
+                        </tr>
+                      </table>
+                      </a>
+                    </div>
+                  </TD>
+                  <TD class="TitleCell"></TD>
+                  <TD class="ContentCell"></TD>
+                  <TD class="TitleCell"></TD>
+                  <TD class="ContentCell"></TD>
+                </TR>
+              </TABLE>
+            </div>
+
+        <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="Menu_ContentPane_Bottom" id="tdbottomSeparator">
+          <TR>
+            <TD class="Main_Bottom_bg"><IMG src="../../../../../web/images/blank.gif" border="0"></TD>
+          </TR>
+        </TABLE></td>
+      <td valign="top">
+        <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="Main_ContentPane_Right" id="tdrightSeparator">
+          <TR><TD class="Main_NavBar_bg_right"></TD></TR>
+          <TR><TD class="Main_ToolBar_bg_right" valign="top"></TD></TR>
+          <TR><TD class="Main_Client_bg_right"></TD></TR>
+          <TR><TD class="Main_Bottom_bg_right"></TD></TR>
+        </TABLE>
+      </td>
+    </tr>
+  </table>
+</form>
+</body>
+</html>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.java	Tue Apr 08 15:35:33 2008 +0000
@@ -0,0 +1,172 @@
+/*
+ *************************************************************************
+ * The contents of this file are subject to the Openbravo  Public  License
+ * Version  1.0  (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 SL 
+ * All portions are Copyright (C) 2001-2008 Openbravo SL 
+ * All Rights Reserved.
+ * Contributor(s):  ______________________________________.
+ ************************************************************************
+ */
+package org.openbravo.erpCommon.ad_reports;
+
+import org.openbravo.erpCommon.reference.ActionButtonData;
+import org.openbravo.erpCommon.reference.PInstanceProcessData;
+import org.openbravo.erpCommon.utility.*;
+import org.openbravo.erpCommon.ad_forms.GenerateInvoicesmanualData;
+import org.openbravo.erpCommon.ad_forms.MaterialReceiptPendingData;
+import org.openbravo.erpCommon.businessUtility.WindowTabs;
+import org.openbravo.base.secureApp.HttpSecureAppServlet;
+import org.openbravo.base.secureApp.VariablesSecureApp;
+import org.openbravo.xmlEngine.XmlDocument;
+import java.io.*;
+import java.sql.Connection;
+
+import javax.servlet.*;
+import javax.servlet.http.*;
+
+public class ReportParetoProduct extends HttpSecureAppServlet {
+  private static final long serialVersionUID = 1L;
+
+  public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException {
+    VariablesSecureApp vars = new VariablesSecureApp(request);
+
+    if (vars.commandIn("DEFAULT")) {
+      String strWarehouse = vars.getGlobalVariable("inpmWarehouseId", "ReportParetoProduct|M_Warehouse_ID", "");
+      String strAD_Org_ID = vars.getGlobalVariable("inpadOrgId", "ReportParetoProduct|AD_Org_ID", "");
+      printPageDataSheet(response, vars, strWarehouse, strAD_Org_ID);
+    } else if (vars.commandIn("FIND")) {
+      String strWarehouse = vars.getRequestGlobalVariable("inpmWarehouseId", "ReportParetoProduct|M_Warehouse_ID");
+      String strAD_Org_ID = vars.getRequestGlobalVariable("inpadOrgId", "ReportParetoProduct|AD_Org_ID");      
+      printPageDataSheet(response, vars, strWarehouse, strAD_Org_ID);
+    } else if (vars.commandIn("GENERATE")) {
+      String strWarehouse = vars.getRequestGlobalVariable("inpmWarehouseId", "ReportParetoProduct|M_Warehouse_ID");
+      String strAD_Org_ID = vars.getRequestGlobalVariable("inpadOrgId", "ReportParetoProduct|AD_Org_ID");      
+      //ReportParetoProductData result = ReportParetoProductData.updateOrgSpecific(this, strWarehouse, strAD_Org_ID);
+      OBError myMessage = mUpdateParetoProduct(vars, strWarehouse, strAD_Org_ID);
+      String message="";
+      myMessage.setTitle("");      
+        myMessage.setType("Success");
+        myMessage.setTitle(Utility.messageBD(this, "Success", vars.getLanguage()));
+        vars.setMessage("ReportParetoProduct", myMessage);
+        printPageDataSheet(response, vars, strWarehouse, strAD_Org_ID);
+     } else pageError(response);
+  }
+
+  void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String strWarehouse, String strAD_Org_ID)
+    throws IOException, ServletException {
+    if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet");
+    response.setContentType("text/html; charset=UTF-8");
+    PrintWriter out = response.getWriter();
+    XmlDocument xmlDocument=null;
+    ReportParetoProductData[] data = null;
+
+    String discard[] = {"discard"};
+
+    xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportParetoProduct", discard).createXmlDocument();
+    if (vars.commandIn("FIND")){
+        data = ReportParetoProductData.select(this, strWarehouse, strAD_Org_ID);
+        if (data == null || data.length == 0){
+          discard[0] = "selEliminar";
+          data = ReportParetoProductData.set();
+        }
+        else {
+          xmlDocument.setData("structure1", data);
+        }
+    }
+    else {
+      discard[0] = "selEliminar";
+      data = ReportParetoProductData.set();
+    }
+    
+    //Load Toolbar
+    ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportParetoProduct", false, "", "", "",false, "ad_reports",  strReplaceWith, false,  true);
+    toolbar.prepareSimpleToolBarTemplate();
+    xmlDocument.setParameter("toolbar", toolbar.toString());
+
+    //Create WindowTabs
+    try {
+      WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportParetoProduct");
+      xmlDocument.setParameter("parentTabContainer", tabs.parentTabs());
+      xmlDocument.setParameter("mainTabContainer", tabs.mainTabs());
+      xmlDocument.setParameter("childTabContainer", tabs.childTabs());
+      xmlDocument.setParameter("theme", vars.getTheme());
+      NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportParetoProduct.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb());
+      xmlDocument.setParameter("navigationBar", nav.toString());
+      LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportParetoProduct.html", strReplaceWith);
+      xmlDocument.setParameter("leftTabs", lBar.manualTemplate());
+    } catch (Exception ex) {
+      throw new ServletException(ex);
+    }
+    
+    //Load Message Area
+    {
+      OBError myMessage = vars.getMessage("ReportParetoProduct");
+      vars.removeMessage("ReportParetoProduct");
+      if (myMessage!=null) {
+        xmlDocument.setParameter("messageType", myMessage.getType());
+        xmlDocument.setParameter("messageTitle", myMessage.getTitle());
+        xmlDocument.setParameter("messageMessage", myMessage.getMessage());
+      }
+    }  
+
+    //Pass parameters to the window
+    xmlDocument.setParameter("calendar", vars.getLanguage().substring(0,2));
+    xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n");
+    xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";");
+      
+    //Load Business Partner Group combo with data
+    try {
+      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "M_Warehouse_ID", "", "", Utility.getContext(this, vars, "#User_Org", "ReportParetoProduct"), Utility.getContext(this, vars, "#User_Client", "ReportParetoProduct"), 0);
+      Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportParetoProduct", strWarehouse);
+        xmlDocument.setData("reportM_Warehouse_ID","liststructure", comboTableData.select(false));
+        comboTableData = null;
+    } catch (Exception ex) {
+      throw new ServletException(ex);
+    }
+
+    try {
+      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "AD_Org_ID", "", "", Utility.getContext(this, vars, "#User_Org", "ReportParetoProduct"), Utility.getContext(this, vars, "#User_Client", "ReportParetoProduct"), 0);
+      Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportParetoProduct", strAD_Org_ID);
+      xmlDocument.setData("reportAD_Org_ID","liststructure", comboTableData.select(false));
+      comboTableData = null;
+    } catch (Exception ex) {
+      throw new ServletException(ex);
+    }
+        
+    xmlDocument.setParameter("mWarehouseId", strWarehouse);
+    xmlDocument.setParameter("adOrg", strAD_Org_ID);
+    
+    //Print document in the output
+    out.println(xmlDocument.print());
+    out.close();
+  }
+
+  OBError mUpdateParetoProduct(VariablesSecureApp vars, String strWarehouse, String strAD_Org_ID)
+  throws IOException, ServletException {
+    String pinstance = SequenceIdData.getSequence(this, "AD_PInstance", vars.getClient());
+
+    PInstanceProcessData.insertPInstance(this, pinstance, "1000500001", "0", "N", vars.getUser(), vars.getClient(), vars.getOrg());
+    PInstanceProcessData.insertPInstanceParam(this, pinstance, "1", "m_warehouse_id", strWarehouse, vars.getClient(), vars.getOrg(), vars.getUser());
+    PInstanceProcessData.insertPInstanceParam(this, pinstance, "2", "ad_org_id", strAD_Org_ID, vars.getClient(), vars.getOrg(), vars.getUser());
+    ReportParetoProductData.mUpdateParetoProduct0(this, pinstance);
+
+    PInstanceProcessData[] pinstanceData = PInstanceProcessData.select(this, pinstance);
+    OBError myMessage = Utility.getProcessInstanceMessage(this, vars, pinstanceData);
+    return myMessage;
+  }
+  
+  public String getServletInfo() {
+    return "Servlet ReportParetoProduct info. Insert here any relevant information";
+  } // end of getServletInfo() method
+}
+
+
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.xml	Tue Apr 08 15:35:33 2008 +0000
@@ -0,0 +1,60 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!--
+*************************************************************************
+* The contents of this file are subject to the Openbravo  Public  License
+* Version  1.0  (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 SL 
+* All portions are Copyright (C) 2001-2008 Openbravo SL 
+* All Rights Reserved. 
+* Contributor(s):  ______________________________________.
+************************************************************************
+-->
+<REPORT>
+  <template file="ReportParetoProduct.html"/>
+  <PARAMETER id="paramToolBar" name="toolbar" default=""/>
+  <PARAMETER id="fieldCalendar" name="calendar" attribute="src" replace="es" default="en"/>
+  <PARAMETER id="paramDirection" name="direction" default=""/>
+  <PARAMETER id="paramLanguage" name="paramLanguage" default=""/>
+  <PARAMETER id="paramCSS" name="theme" attribute="href" replace="Default"/>
+  <PARAMETER id="tdleftTabs" name="leftTabs" default=""/>
+  <PARAMETER id="paramParentTabContainer" name="parentTabContainer" default=" "/>
+  <PARAMETER id="paramMainTabContainer" name="mainTabContainer" default=" "/>
+  <PARAMETER id="paramChildTabContainer" name="childTabContainer" default=" "/>
+  <PARAMETER id="tdtopButtons" name="navigationBar" default=""/>
+  <PARAMETER id="messageBoxID" name="messageType" attribute="class" replace="yy" default="HIDDEN"/>
+  <PARAMETER id="messageBoxIDTitle" name="messageTitle" default=""/>
+  <PARAMETER id="messageBoxIDMessage" name="messageMessage" default=""/>
+
+  <PARAMETER id="paramM_Warehouse_ID" name="mWarehouseId" default=""/>
+  <SUBREPORT id="reportM_Warehouse_ID" name="reportM_Warehouse_ID" report="org/openbravo/erpCommon/reference/List">
+    <ARGUMENT name="parameterListSelected" withId="paramM_Warehouse_ID"/>
+  </SUBREPORT>
+
+  <PARAMETER id="paramAD_Org_ID" name="adOrg" default=""/>
+  <SUBREPORT id="reportAD_Org_ID" name="reportAD_Org_ID" report="org/openbravo/erpCommon/reference/List">
+    <ARGUMENT name="parameterListSelected" withId="paramAD_Org_ID"/>
+  </SUBREPORT>
+	  
+  <PARAMETER id="param2" name="param2" default="2"/>
+
+  <structure name="structure1">
+    <FIELD id="fieldRownum1">rownum</FIELD>
+    <FUNCTION id="funcEvenOddRow1xx" name="MODULE" arg1="fieldRownum1" arg2="param2" format="integerEdition" attribute="class" replace="yy"/>
+    <FIELD id="fieldAdOrg">orgid</FIELD>
+    <FIELD id="fieldName">name</FIELD>
+    <FIELD id="fieldSearchKey">searchkey</FIELD>
+    <FIELD id="fieldCost" format="euroInform">cost</FIELD>
+    <FIELD id="fieldPercentage" format="euroInform">porcentaje</FIELD>
+    <FIELD id="fieldAttribute">attribute</FIELD>
+    <FIELD id="fieldIsabc">isabc</FIELD>     
+    <SECTION id="sectionDetail"/>
+  </structure>
+</REPORT>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql	Tue Apr 08 15:35:33 2008 +0000
@@ -0,0 +1,100 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!--
+ *************************************************************************
+ * The contents of this file are subject to the Openbravo  Public  License
+ * Version  1.0  (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 SL 
+ * All portions are Copyright (C) 2001-2008 Openbravo SL 
+ * All Rights Reserved. 
+ * Contributor(s):  ______________________________________.
+ ************************************************************************
+-->
+
+
+
+
+
+<SqlClass name="ReportParetoProductData" package="org.openbravo.erpCommon.ad_reports">
+  <SqlClassComment></SqlClassComment>
+  <SqlMethod name="select" type="preparedStatement" return="multiple">
+    <SqlMethodComment></SqlMethodComment>
+    <Sql>
+    <![CDATA[
+     SELECT ORGID, SEARCHKEY, NAME, ATTRIBUTE, COST, PORCENTAJE
+     ,GET_PARETO_ABC(M_WAREHOUSE_ID, AD_ORG_ID, PORCENTAJE) AS ISABC 
+     FROM
+     (
+     SELECT 
+      AD_ORG.NAME AS ORGID,
+      PR.VALUE AS SEARCHKEY,
+      PR.NAME,
+      MAT.DESCRIPTION AS ATTRIBUTE,
+      GET_PRODUCT_COST(PR.M_PRODUCT_ID,to_date(now()),'AV') AS COST,
+      100*(GET_PRODUCT_COST(PR.M_PRODUCT_ID,to_date(now()),'AV')/ (SELECT SUM(GET_PRODUCT_COST(PR1.M_PRODUCT_ID,to_date(now()),'AV')) 
+                                                           from M_WAREHOUSE MW1  
+                                                           LEFT JOIN M_LOCATOR ML1 ON ML1.M_WAREHOUSE_ID=MW1.M_WAREHOUSE_ID
+                                                           LEFT JOIN M_STORAGE_DETAIL MSD1 ON ML1.M_LOCATOR_ID=MSD1.M_LOCATOR_ID
+                                                           LEFT JOIN M_ATTRIBUTESETINSTANCE MAT1 ON MAT1.M_ATTRIBUTESETINSTANCE_ID=MSD1.M_ATTRIBUTESETINSTANCE_ID
+                                                           LEFT JOIN M_PRODUCT PR1 ON MSD1.M_PRODUCT_ID=PR1.M_PRODUCT_ID   
+                                                           WHERE MSD1.QTYONHAND>0
+                                                           AND 1=1
+                                                           AND 2=2 
+                                                           ) ) as PORCENTAJE,
+      ML.X,
+      ML.Y,
+      ML.Z,
+      MW.M_WAREHOUSE_ID,
+      MSD.AD_ORG_ID
+     FROM
+     M_WAREHOUSE MW 
+       LEFT JOIN M_LOCATOR ML ON ML.M_WAREHOUSE_ID=MW.M_WAREHOUSE_ID
+       LEFT JOIN M_STORAGE_DETAIL MSD ON ML.M_LOCATOR_ID=MSD.M_LOCATOR_ID
+       LEFT JOIN M_ATTRIBUTESETINSTANCE MAT ON MAT.M_ATTRIBUTESETINSTANCE_ID=MSD.M_ATTRIBUTESETINSTANCE_ID
+       LEFT JOIN M_PRODUCT PR ON MSD.M_PRODUCT_ID=PR.M_PRODUCT_ID, AD_ORG   
+     WHERE 3=3
+       AND 4=4
+       AND MSD.QTYONHAND>0
+       AND GET_PRODUCT_COST(PR.M_PRODUCT_ID,to_date(now()),'AV') IS NOT NULL
+       AND GET_PRODUCT_COST(PR.M_PRODUCT_ID,to_date(now()),'AV') <> 0
+       AND MSD.AD_ORG_ID = AD_ORG.AD_ORG_ID
+     ORDER BY PORCENTAJE DESC) BBB
+    ]]></Sql>
+    <Field name="rownum" value="count"/>
+    <Parameter name="mWarehouseId" optional="true" after="1=1" text=" AND MW1.M_WAREHOUSE_ID = TO_NUMBER(?) "/>
+    <Parameter name="adOrgId" optional="true" after="2=2" text=" AND MSD1.AD_ORG_ID = TO_NUMBER(?) "/>    
+    <Parameter name="mWarehouseId" optional="true" after="3=3" text=" AND MW.M_WAREHOUSE_ID = TO_NUMBER(?) "/>    
+    <Parameter name="adOrgId" optional="true" after="4=4" text=" AND MSD.AD_ORG_ID = TO_NUMBER(?) "/>
+  </SqlMethod>
+
+  <SqlMethod name="set" type="constant" return="multiple">
+      <SqlMethodComment></SqlMethodComment>
+      <Sql></Sql>
+  </SqlMethod>
+  
+
+   
+  <SqlMethod name="mUpdateParetoProduct0" type="callableStatement" return="object" object="ReportParetoProductData">
+      <SqlMethodComment></SqlMethodComment>
+      <Sql><![CDATA[
+        CALL M_UPDATE_PARETO_PRODUCT0(TO_NUMBER(?))
+      ]]></Sql>
+      <Parameter name="adPinstanceId"/>    
+   </SqlMethod> 
+    
+  <!-- SqlMethod name="updateOrgSpecific" type="callableStatement" return="object" object="ReportParetoProductData">
+      <SqlMethodComment></SqlMethodComment>
+      <Sql><![CDATA[
+        CALL M_UPDATE_PARETO_PRODUCT(TO_NUMBER(?), TO_NUMBER(?))
+      ]]></Sql>
+      <Parameter name="mWarehouseId"/>    
+      <Parameter name="adOrgId"/>
+   </SqlMethod -->        
+</SqlClass>