Fixes issue 4198: Database XML files not synced
authorJuan Pablo Aroztegi <juanpablo.aroztegi@openbravo.com>
Fri, 27 Jun 2008 14:37:32 +0000
changeset 1370 5d68bf7eedb9
parent 1369 6a4059ae058f
child 1371 386a7fe5d25e
Fixes issue 4198: Database XML files not synced
src-db/database/model/views/C_DEBT_PAYMENT_V.xml
src-db/database/model/views/C_INVOICE_V.xml
src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml
src-db/database/model/views/RV_C_INVOICE.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_MESSAGE.xml
src-db/database/sourcedata/AD_TEXTINTERFACES.xml
--- a/src-db/database/model/views/C_DEBT_PAYMENT_V.xml	Fri Jun 27 13:35:57 2008 +0000
+++ b/src-db/database/model/views/C_DEBT_PAYMENT_V.xml	Fri Jun 27 14:37:32 2008 +0000
@@ -3,15 +3,15 @@
     <view name="C_DEBT_PAYMENT_V"><![CDATA[SELECT c_debt_payment.c_debt_payment_id, c_debt_payment.ad_client_id, c_debt_payment.ad_org_id, c_debt_payment.isactive, c_debt_payment.created, c_debt_payment.createdby, c_debt_payment.updated, c_debt_payment.updatedby, c_debt_payment.isreceipt, c_debt_payment.c_settlement_cancel_id, c_debt_payment.c_settlement_generate_id, c_debt_payment.description, c_debt_payment.c_invoice_id, c_debt_payment.c_bpartner_id, c_debt_payment.c_currency_id, c_debt_payment.c_cashline_id, c_debt_payment.c_bankaccount_id, c_debt_payment.c_cashbook_id, c_debt_payment.paymentrule, c_debt_payment.ispaid, c_debt_payment.dateplanned, c_debt_payment.ismanual, c_debt_payment.isvalid, c_debt_payment.c_bankstatementline_id, c_debt_payment.changesettlementcancel, c_debt_payment.cancel_processed, c_debt_payment.generate_processed, c_debt_payment.c_withholding_id, c_debt_payment.withholdingamount, 
         CASE c_debt_payment.isreceipt
             WHEN 'Y' THEN c_debt_payment.amount
-            ELSE c_debt_payment.amount * -1
+            ELSE c_debt_payment.amount * (-1)
         END AS amount, 
         CASE c_debt_payment.isreceipt
             WHEN 'Y' THEN c_debt_payment.writeoffamt
-            ELSE c_debt_payment.writeoffamt * -1
+            ELSE c_debt_payment.writeoffamt * (-1)
         END AS writeoffamt, 
         CASE c_debt_payment.isreceipt
             WHEN 'Y' THEN 1
-            ELSE -1
+            ELSE (-1)
         END AS multiplierap, c_debt_payment.glitemamt, c_debt_payment.c_order_id, c_debt_payment.status
    FROM c_debt_payment]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_V.xml	Fri Jun 27 13:35:57 2008 +0000
+++ b/src-db/database/model/views/C_INVOICE_V.xml	Fri Jun 27 14:37:32 2008 +0000
@@ -2,23 +2,23 @@
   <database name="VIEW C_INVOICE_V">
     <view name="C_INVOICE_V"><![CDATA[SELECT i.c_invoice_id, i.ad_client_id, i.ad_org_id, i.isactive, i.created, i.createdby, i.updated, i.updatedby, i.issotrx, i.documentno, i.docstatus, i.docaction, i.processing, i.processed, i.c_doctype_id, i.c_doctypetarget_id, i.c_order_id, i.description, i.salesrep_id, i.dateinvoiced, i.dateprinted, i.dateacct, i.c_bpartner_id, i.c_bpartner_location_id, i.ad_user_id, i.poreference, i.dateordered, i.c_currency_id, i.paymentrule, i.c_paymentterm_id, i.c_charge_id, i.m_pricelist_id, i.c_campaign_id, i.c_project_id, i.c_activity_id, i.isprinted, i.isdiscountprinted, 
         CASE
-            WHEN substr(d.docbasetype, 3) = 'C' THEN i.chargeamt * -1
+            WHEN substr(d.docbasetype, 3) = 'C' THEN i.chargeamt * (-1)
             ELSE i.chargeamt
         END AS chargeamt, 
         CASE
-            WHEN substr(d.docbasetype, 3) = 'C' THEN i.totallines * -1
+            WHEN substr(d.docbasetype, 3) = 'C' THEN i.totallines * (-1)
             ELSE i.totallines
         END AS totallines, 
         CASE
-            WHEN substr(d.docbasetype, 3) = 'C' THEN i.grandtotal * -1
+            WHEN substr(d.docbasetype, 3) = 'C' THEN i.grandtotal * (-1)
             ELSE i.grandtotal
         END AS grandtotal, 
         CASE
-            WHEN substr(d.docbasetype, 3) = 'C' THEN -1
+            WHEN substr(d.docbasetype, 3) = 'C' THEN (-1)
             ELSE 1
         END AS multiplier, 
         CASE
-            WHEN substr(d.docbasetype, 2, 1) = 'P' THEN -1
+            WHEN substr(d.docbasetype, 2, 1) = 'P' THEN (-1)
             ELSE 1
         END AS multiplierap, d.docbasetype
    FROM c_invoice i
--- a/src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml	Fri Jun 27 13:35:57 2008 +0000
+++ b/src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml	Fri Jun 27 14:37:32 2008 +0000
@@ -4,7 +4,7 @@
    FROM m_product, ma_processplan_version, ( SELECT ma_processplan_version.ma_processplan_version_id, ma_sequenceproduct.m_product_id, sum(
                 CASE ma_sequenceproduct.productiontype
                     WHEN '+' THEN ma_sequenceproduct.quantity * ma_sequence.multiplier
-                    WHEN '-' THEN ma_sequenceproduct.quantity * ma_sequence.multiplier * -1
+                    WHEN '-' THEN ma_sequenceproduct.quantity * ma_sequence.multiplier * (-1)
                     ELSE NULL
                 END) AS qty
            FROM ma_processplan_version, ma_sequence, ma_sequenceproduct
@@ -12,7 +12,7 @@
           GROUP BY ma_processplan_version.ma_processplan_version_id, ma_sequenceproduct.m_product_id) sp1, ( SELECT ma_processplan_version.ma_processplan_version_id, ma_sequenceproduct.m_product_id, sum(
                 CASE ma_sequenceproduct.productiontype
                     WHEN '+' THEN ma_sequenceproduct.quantity * ma_sequence.multiplier
-                    WHEN '-' THEN ma_sequenceproduct.quantity * ma_sequence.multiplier * -1
+                    WHEN '-' THEN ma_sequenceproduct.quantity * ma_sequence.multiplier * (-1)
                     ELSE NULL
                 END) AS qty
            FROM ma_processplan_version, ma_sequence, ma_sequenceproduct
--- a/src-db/database/model/views/RV_C_INVOICE.xml	Fri Jun 27 13:35:57 2008 +0000
+++ b/src-db/database/model/views/RV_C_INVOICE.xml	Fri Jun 27 14:37:32 2008 +0000
@@ -2,19 +2,19 @@
   <database name="VIEW RV_C_INVOICE">
     <view name="RV_C_INVOICE"><![CDATA[SELECT i.c_invoice_id, i.ad_client_id, i.ad_org_id, i.isactive, i.created, i.createdby, i.updated, i.updatedby, i.issotrx, i.documentno, i.docstatus, i.docaction, i.isprinted, i.isdiscountprinted, i.processing, i.processed, i.c_doctype_id, i.c_doctypetarget_id, i.c_order_id, i.description, i.salesrep_id, i.dateinvoiced, i.dateprinted, i.dateacct, i.c_bpartner_id, i.c_bpartner_location_id, i.ad_user_id, b.c_bp_group_id, i.poreference, i.dateordered, i.c_currency_id, i.paymentrule, i.c_paymentterm_id, i.m_pricelist_id, i.c_campaign_id, i.c_project_id, i.c_activity_id, i.c_charge_id, 
         CASE substr(d.docbasetype, 3)
-            WHEN 'C' THEN i.chargeamt * -1
+            WHEN 'C' THEN i.chargeamt * (-1)
             ELSE i.chargeamt
         END AS chargeamt, 
         CASE substr(d.docbasetype, 3)
-            WHEN 'C' THEN i.totallines * -1
+            WHEN 'C' THEN i.totallines * (-1)
             ELSE i.totallines
         END AS totallines, 
         CASE substr(d.docbasetype, 3)
-            WHEN 'C' THEN i.grandtotal * -1
+            WHEN 'C' THEN i.grandtotal * (-1)
             ELSE i.grandtotal
         END AS grandtotal, 
         CASE substr(d.docbasetype, 3)
-            WHEN 'C' THEN -1
+            WHEN 'C' THEN (-1)
             ELSE 1
         END AS multiplier
    FROM c_invoice i, c_doctype d, c_bpartner b
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Fri Jun 27 13:35:57 2008 +0000
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Fri Jun 27 14:37:32 2008 +0000
@@ -363984,13 +363984,13 @@
 <!--801035 CREATED-->
 <!--801035-->              <CREATED><![CDATA[2005-12-26 11:06:58.0]]></CREATED>
 <!--801035 UPDATED-->
-<!--801035-->              <UPDATED><![CDATA[2005-12-26 12:04:50.0]]></UPDATED>
+<!--801035-->              <UPDATED><![CDATA[2008-06-27 15:52:58.0]]></UPDATED>
 <!--801035 CREATEDBY-->
 <!--801035-->              <CREATEDBY><![CDATA[0]]></CREATEDBY>
 <!--801035 UPDATEDBY-->
 <!--801035-->              <UPDATEDBY><![CDATA[100]]></UPDATEDBY>
 <!--801035 NAME-->
-<!--801035-->              <NAME><![CDATA[FixMonthCutoff]]></NAME>
+<!--801035-->              <NAME><![CDATA[Last Day Cut-off]]></NAME>
 <!--801035 DESCRIPTION-->
 <!--801035-->              <DESCRIPTION><![CDATA[Last day to include for next due date]]></DESCRIPTION>
 <!--801035 HELP-->
--- a/src-db/database/sourcedata/AD_FIELD.xml	Fri Jun 27 13:35:57 2008 +0000
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Fri Jun 27 14:37:32 2008 +0000
@@ -380039,11 +380039,11 @@
 <!--1005400217 CREATEDBY-->
 <!--1005400217-->              <CREATEDBY><![CDATA[0]]></CREATEDBY>
 <!--1005400217 UPDATED-->
-<!--1005400217-->              <UPDATED><![CDATA[2008-06-19 16:36:15.0]]></UPDATED>
+<!--1005400217-->              <UPDATED><![CDATA[2008-06-27 15:52:58.0]]></UPDATED>
 <!--1005400217 UPDATEDBY-->
 <!--1005400217-->              <UPDATEDBY><![CDATA[100]]></UPDATEDBY>
 <!--1005400217 NAME-->
-<!--1005400217-->              <NAME><![CDATA[Test Heartbeat]]></NAME>
+<!--1005400217-->              <NAME><![CDATA[TestHeartbeat]]></NAME>
 <!--1005400217 DESCRIPTION-->
 <!--1005400217-->              <DESCRIPTION><![CDATA[Test the Heartbeat Configuration]]></DESCRIPTION>
 <!--1005400217 ISCENTRALLYMAINTAINED-->
--- a/src-db/database/sourcedata/AD_MESSAGE.xml	Fri Jun 27 13:35:57 2008 +0000
+++ b/src-db/database/sourcedata/AD_MESSAGE.xml	Fri Jun 27 14:37:32 2008 +0000
@@ -137524,11 +137524,11 @@
 <!--1000400003 ISACTIVE-->
 <!--1000400003-->              <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--1000400003 CREATED-->
-<!--1000400003-->              <CREATED><![CDATA[2008-06-25 08:46:50.351822]]></CREATED>
+<!--1000400003-->              <CREATED><![CDATA[2008-06-25 08:46:50.0]]></CREATED>
 <!--1000400003 CREATEDBY-->
 <!--1000400003-->              <CREATEDBY><![CDATA[100]]></CREATEDBY>
 <!--1000400003 UPDATED-->
-<!--1000400003-->              <UPDATED><![CDATA[2008-06-25 08:46:50.351822]]></UPDATED>
+<!--1000400003-->              <UPDATED><![CDATA[2008-06-25 08:46:50.0]]></UPDATED>
 <!--1000400003 UPDATEDBY-->
 <!--1000400003-->              <UPDATEDBY><![CDATA[100]]></UPDATEDBY>
 <!--1000400003 VALUE-->
@@ -137549,11 +137549,11 @@
 <!--1000400004 ISACTIVE-->
 <!--1000400004-->              <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--1000400004 CREATED-->
-<!--1000400004-->              <CREATED><![CDATA[2008-06-25 08:48:33.946085]]></CREATED>
+<!--1000400004-->              <CREATED><![CDATA[2008-06-25 08:48:33.0]]></CREATED>
 <!--1000400004 CREATEDBY-->
 <!--1000400004-->              <CREATEDBY><![CDATA[100]]></CREATEDBY>
 <!--1000400004 UPDATED-->
-<!--1000400004-->              <UPDATED><![CDATA[2008-06-25 08:48:33.946085]]></UPDATED>
+<!--1000400004-->              <UPDATED><![CDATA[2008-06-25 08:48:33.0]]></UPDATED>
 <!--1000400004 UPDATEDBY-->
 <!--1000400004-->              <UPDATEDBY><![CDATA[100]]></UPDATEDBY>
 <!--1000400004 VALUE-->
@@ -137574,11 +137574,11 @@
 <!--1000400005 ISACTIVE-->
 <!--1000400005-->              <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--1000400005 CREATED-->
-<!--1000400005-->              <CREATED><![CDATA[2008-06-25 13:12:30.586722]]></CREATED>
+<!--1000400005-->              <CREATED><![CDATA[2008-06-25 13:12:30.0]]></CREATED>
 <!--1000400005 CREATEDBY-->
 <!--1000400005-->              <CREATEDBY><![CDATA[100]]></CREATEDBY>
 <!--1000400005 UPDATED-->
-<!--1000400005-->              <UPDATED><![CDATA[2008-06-25 13:12:30.586722]]></UPDATED>
+<!--1000400005-->              <UPDATED><![CDATA[2008-06-25 13:12:30.0]]></UPDATED>
 <!--1000400005 UPDATEDBY-->
 <!--1000400005-->              <UPDATEDBY><![CDATA[100]]></UPDATEDBY>
 <!--1000400005 VALUE-->
@@ -137599,11 +137599,11 @@
 <!--1000400006 ISACTIVE-->
 <!--1000400006-->              <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--1000400006 CREATED-->
-<!--1000400006-->              <CREATED><![CDATA[2008-06-25 13:25:33.949177]]></CREATED>
+<!--1000400006-->              <CREATED><![CDATA[2008-06-25 13:25:33.0]]></CREATED>
 <!--1000400006 CREATEDBY-->
 <!--1000400006-->              <CREATEDBY><![CDATA[100]]></CREATEDBY>
 <!--1000400006 UPDATED-->
-<!--1000400006-->              <UPDATED><![CDATA[2008-06-25 13:25:33.949177]]></UPDATED>
+<!--1000400006-->              <UPDATED><![CDATA[2008-06-25 13:25:33.0]]></UPDATED>
 <!--1000400006 UPDATEDBY-->
 <!--1000400006-->              <UPDATEDBY><![CDATA[100]]></UPDATEDBY>
 <!--1000400006 VALUE-->
--- a/src-db/database/sourcedata/AD_TEXTINTERFACES.xml	Fri Jun 27 13:35:57 2008 +0000
+++ b/src-db/database/sourcedata/AD_TEXTINTERFACES.xml	Fri Jun 27 14:37:32 2008 +0000
@@ -35468,7 +35468,7 @@
 <!--1000100018 FILENAME-->
 <!--1000100018-->              <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportAnnualCertification.jrxml]]></FILENAME>
 <!--1000100018 ISUSED-->
-<!--1000100018-->              <ISUSED><![CDATA[Y]]></ISUSED>
+<!--1000100018-->              <ISUSED><![CDATA[N]]></ISUSED>
 <!--1000100018**************--></AD_TEXTINTERFACES>
 
 <!--1000200000**************--><AD_TEXTINTERFACES>
@@ -43541,7 +43541,7 @@
 <!--1002100156 FILENAME-->
 <!--1002100156-->              <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportAnnualCertification.jrxml]]></FILENAME>
 <!--1002100156 ISUSED-->
-<!--1002100156-->              <ISUSED><![CDATA[Y]]></ISUSED>
+<!--1002100156-->              <ISUSED><![CDATA[N]]></ISUSED>
 <!--1002100156**************--></AD_TEXTINTERFACES>
 
 <!--1002100157**************--><AD_TEXTINTERFACES>
@@ -43716,7 +43716,7 @@
 <!--1002100163 FILENAME-->
 <!--1002100163-->              <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportAnnualCertification.jrxml]]></FILENAME>
 <!--1002100163 ISUSED-->
-<!--1002100163-->              <ISUSED><![CDATA[Y]]></ISUSED>
+<!--1002100163-->              <ISUSED><![CDATA[N]]></ISUSED>
 <!--1002100163**************--></AD_TEXTINTERFACES>
 
 <!--1002100164**************--><AD_TEXTINTERFACES>
@@ -43741,7 +43741,7 @@
 <!--1002100164 FILENAME-->
 <!--1002100164-->              <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportAnnualCertification.jrxml]]></FILENAME>
 <!--1002100164 ISUSED-->
-<!--1002100164-->              <ISUSED><![CDATA[Y]]></ISUSED>
+<!--1002100164-->              <ISUSED><![CDATA[N]]></ISUSED>
 <!--1002100164**************--></AD_TEXTINTERFACES>
 
 <!--1002100165**************--><AD_TEXTINTERFACES>
@@ -43766,7 +43766,7 @@
 <!--1002100165 FILENAME-->
 <!--1002100165-->              <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportAnnualCertification.jrxml]]></FILENAME>
 <!--1002100165 ISUSED-->
-<!--1002100165-->              <ISUSED><![CDATA[Y]]></ISUSED>
+<!--1002100165-->              <ISUSED><![CDATA[N]]></ISUSED>
 <!--1002100165**************--></AD_TEXTINTERFACES>
 
 <!--1002100166**************--><AD_TEXTINTERFACES>