CI: promote changesets from pi to main
authorRM packaging bot <staff.rm@openbravo.com>
Wed, 08 Dec 2010 09:55:50 +0000
changeset 9082 5535c247b006
parent 9080 5f011dfcb6cd (current diff)
parent 9081 2c1319271a23 (diff)
child 9084 b70642c77209
CI: promote changesets from pi to main
src-db/database/sourcedata/AD_MODULE.xml
--- a/src-db/database/model/functions/C_GENERATESOFROMPROJECTPHASE.xml	Wed Dec 08 06:40:04 2010 +0000
+++ b/src-db/database/model/functions/C_GENERATESOFROMPROJECTPHASE.xml	Wed Dec 08 09:55:50 2010 +0000
@@ -79,7 +79,7 @@
           P.C_CURRENCY_ID, P.PAYMENTRULE, P.C_PAYMENTTERM_ID, P.M_WAREHOUSE_ID, P.SALESREP_ID,
           P.BILLTO_ID, P.C_CAMPAIGN_ID, P.C_PROJECT_ID, P.AD_USER_ID, P.DESCRIPTION, P.PROJECTSTATUS,
           PP.NAME AS PHASE_NAME, PP.AD_CLIENT_ID, PP.AD_ORG_ID, OI.C_LOCATION_ID AS ORGLOCATIONID,
-          P.FIN_PAYMENTMETHOD_ID
+          P.FIN_PAYMENTMETHOD_ID, P.POREFERENCE
         FROM C_PROJECT P,
           C_PROJECTPHASE PP,
           M_PRICELIST PL,
@@ -150,7 +150,7 @@
             TOTALLINES, GRANDTOTAL, M_WAREHOUSE_ID, M_PRICELIST_ID,
             ISTAXINCLUDED, POSTED, PROCESSING, SALESREP_ID,
             BILLTO_ID, C_CAMPAIGN_ID, C_PROJECT_ID, AD_USER_ID,
-            COPYFROM, DATEPROMISED, DESCRIPTION, FIN_PAYMENTMETHOD_ID
+            COPYFROM, DATEPROMISED, DESCRIPTION, FIN_PAYMENTMETHOD_ID, POREFERENCE
           )
           VALUES
           (
@@ -164,7 +164,7 @@
              'N', 'N', 'N', Cur_SO.SALESREP_ID,
             v_Billto_ID, Cur_SO.C_CAMPAIGN_ID, Cur_SO.C_PROJECT_ID, Cur_SO.AD_User_ID,
              'N', TRUNC(now(), 'DD'), Cur_SO.PHASE_NAME || ' - ' || COALESCE(TO_CHAR(Cur_SO.DESCRIPTION),''), 
-             COALESCE(Cur_SO.FIN_PAYMENTMETHOD_ID, v_fin_paymentmethod_id)
+             COALESCE(Cur_SO.FIN_PAYMENTMETHOD_ID, v_fin_paymentmethod_id), Cur_SO.POREFERENCE
              
           );
 
--- a/src-db/database/sourcedata/AD_MODULE.xml	Wed Dec 08 06:40:04 2010 +0000
+++ b/src-db/database/sourcedata/AD_MODULE.xml	Wed Dec 08 09:55:50 2010 +0000
@@ -6,7 +6,7 @@
 <!--0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--0-->  <NAME><![CDATA[Core]]></NAME>
-<!--0-->  <VERSION><![CDATA[2.50.19079]]></VERSION>
+<!--0-->  <VERSION><![CDATA[2.50.19081]]></VERSION>
 <!--0-->  <DESCRIPTION><![CDATA[Core module is the base one]]></DESCRIPTION>
 <!--0-->  <HELP><![CDATA[Core module is the base one, all developments in core are included as part of the standard Openbravo ERP.]]></HELP>
 <!--0-->  <URL><![CDATA[www.openbravo.com]]></URL>