Attached Files | src_db_xml_differences.diff [^] (6,749 bytes) 2009-01-21 18:51 [Show Content] [Hide Content]Index: src-db/database/model/triggers/AD_REF_LIST_TRG.xml
===================================================================
--- src-db/database/model/triggers/AD_REF_LIST_TRG.xml (revision 12103)
+++ src-db/database/model/triggers/AD_REF_LIST_TRG.xml (working copy)
@@ -27,7 +27,7 @@
* Title: Ref List Translation
* Description:
************************************************************************/
- v_aux number;
+ v_aux NUMBER;
BEGIN
IF AD_isTriggerEnabled()='N' THEN RETURN;
Index: src-db/database/model/tables/C_BPARTNER.xml
===================================================================
--- src-db/database/model/tables/C_BPARTNER.xml (revision 12103)
+++ src-db/database/model/tables/C_BPARTNER.xml (working copy)
@@ -370,6 +370,6 @@
<check name="CBPARTNER_ISTAXEXEMPT_CHECK"><![CDATA[ISTAXEXEMPT IN ('Y', 'N')]]></check>
<check name="CBPARTNER_ISVENDOR_CHECK"><![CDATA[ISVENDOR IN ('Y', 'N')]]></check>
<check name="CBPARTNER_SHOWPRICE_CHECK"><![CDATA[SHOWPRICEINORDER IN ('Y', 'N')]]></check>
- <check name="INVOICERULE_CK_CBPARTNER"><![CDATA[(INVOICERULE <> 'S') OR (C_INVOICESCHEDULE_ID IS NOT NULL)]]></check>
+ <check name="INVOICERULE_CK_CBPARTNER"><![CDATA[((INVOICERULE) <> 'S') OR (C_INVOICESCHEDULE_ID IS NOT NULL)]]></check>
</table>
</database>
Index: src-db/database/model/tables/C_CASHLINE.xml
===================================================================
--- src-db/database/model/tables/C_CASHLINE.xml (revision 12103)
+++ src-db/database/model/tables/C_CASHLINE.xml (working copy)
@@ -119,8 +119,8 @@
<unique name="C_CASHLINE_DEBT_PAYMENT">
<unique-column name="C_DEBT_PAYMENT_ID"/>
</unique>
- <check name="CCASHLINE_CHARGE_CHECK"><![CDATA[(CASHTYPE <> 'C') OR (C_CHARGE_ID IS NOT NULL)]]></check>
- <check name="CCASHLINE_GLITEM_CHECK"><![CDATA[(CASHTYPE <> 'G') OR (C_GLITEM_ID IS NOT NULL)]]></check>
+ <check name="CCASHLINE_CHARGE_CHECK"><![CDATA[((CASHTYPE) <> 'C') OR (C_CHARGE_ID IS NOT NULL)]]></check>
+ <check name="CCASHLINE_GLITEM_CHECK"><![CDATA[((CASHTYPE) <> 'G') OR (C_GLITEM_ID IS NOT NULL)]]></check>
<check name="CCASHLINE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
<check name="CCASHLINE_ISGENERATED_CHECK"><![CDATA[ISGENERATED IN ('Y', 'N')]]></check>
</table>
Index: src-db/database/model/views/M_INOUT_CANDIDATE_V.xml
===================================================================
--- src-db/database/model/views/M_INOUT_CANDIDATE_V.xml (revision 12103)
+++ src-db/database/model/views/M_INOUT_CANDIDATE_V.xml (working copy)
@@ -5,6 +5,6 @@
JOIN c_orderline l ON o.c_order_id = l.c_order_id
WHERE o.docstatus = 'CO' AND o.isdelivered = 'N' AND (o.c_doctype_id IN ( SELECT c_doctype.c_doctype_id
FROM c_doctype
- WHERE c_doctype.docbasetype = 'SOO' AND (c_doctype.docsubtypeso NOT IN ('ON', 'OB', 'WR')))) AND l.qtyordered <> l.qtydelivered AND l.directship = 'N' AND l.m_product_id IS NOT NULL
+ WHERE c_doctype.docbasetype = 'SOO' AND (c_doctype.docsubtypeso NOT IN ('ON', 'OB', 'WR'][)))) AND l.qtyordered <> l.qtydelivered AND l.directship = 'N' AND l.m_product_id IS NOT NULL
GROUP BY o.ad_client_id, o.ad_org_id, o.c_bpartner_id, o.c_order_id, o.documentno, o.dateordered, o.totallines, o.c_doctype_id]]></view>
</database>
Index: src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
===================================================================
--- src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml (revision 12103)
+++ src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml (working copy)
@@ -5,8 +5,8 @@
JOIN c_orderline l ON o.c_order_id = l.c_order_id
JOIN c_bpartner bp ON o.c_bpartner_id = bp.c_bpartner_id
LEFT JOIN c_invoiceschedule si ON bp.c_invoiceschedule_id = si.c_invoiceschedule_id
- WHERE (o.docstatus IN ('CO', 'CL', 'IP')) AND (o.c_doctype_id IN ( SELECT c_doctype.c_doctype_id
+ WHERE (o.docstatus IN ('CO', 'CL', 'IP'][)) AND (o.c_doctype_id IN ( SELECT c_doctype.c_doctype_id
FROM c_doctype
- WHERE c_doctype.docbasetype = 'SOO' AND (c_doctype.docsubtypeso NOT IN ('ON', 'OB', 'WR')))) AND l.qtyordered <> l.qtyinvoiced AND (o.invoicerule = 'I' OR o.invoicerule = 'O' OR o.invoicerule = 'N' OR o.invoicerule = 'D' AND l.qtyinvoiced <> l.qtydelivered OR o.invoicerule = 'S' AND bp.c_invoiceschedule_id IS NULL OR o.invoicerule = 'S' AND bp.c_invoiceschedule_id IS NOT NULL AND (si.invoicefrequency IS NULL OR si.invoicefrequency = 'D' OR si.invoicefrequency = 'W' OR si.invoicefrequency = 'T' AND trunc(o.dateordered) <= (TRUNC(now(), 'MM') + si.invoicedaycutoff - 1) AND trunc(now()) >= (TRUNC(o.dateordered, 'MM') + si.invoiceday - 1) OR trunc(o.dateordered) <= (TRUNC(now(), 'MM') + si.invoicedaycutoff + 14) AND trunc(now()) >= (TRUNC(o.dateordered, 'MM') + si.invoiceday + 14) OR si.invoicefrequency = 'M' AND trunc(o.dateordered) <= (TRUNC(now(), 'MM') + si.invoicedaycutoff - 1) AND trunc(now()) >= (TRUNC(o.dateordered, 'MM') + si.invoiceday - 1)))
+ WHERE c_doctype.docbasetype = 'SOO' AND (c_doctype.docsubtypeso NOT IN ('ON', 'OB', 'WR'][)))) AND l.qtyordered <> l.qtyinvoiced AND (o.invoicerule = 'I' OR o.invoicerule = 'O' OR o.invoicerule = 'N' OR o.invoicerule = 'D' AND l.qtyinvoiced <> l.qtydelivered OR o.invoicerule = 'S' AND bp.c_invoiceschedule_id IS NULL OR o.invoicerule = 'S' AND bp.c_invoiceschedule_id IS NOT NULL AND (si.invoicefrequency IS NULL OR si.invoicefrequency = 'D' OR si.invoicefrequency = 'W' OR si.invoicefrequency = 'T' AND trunc(o.dateordered) <= (TRUNC(now(), 'MM') + si.invoicedaycutoff - 1) AND trunc(now()) >= (TRUNC(o.dateordered, 'MM') + si.invoiceday - 1) OR trunc(o.dateordered) <= (TRUNC(now(), 'MM') + si.invoicedaycutoff + 14) AND trunc(now()) >= (TRUNC(o.dateordered, 'MM') + si.invoiceday + 14) OR si.invoicefrequency = 'M' AND trunc(o.dateordered) <= (TRUNC(now(), 'MM') + si.invoicedaycutoff - 1) AND trunc(now()) >= (TRUNC(o.dateordered, 'MM') + si.invoiceday - 1)))
GROUP BY o.ad_client_id, o.ad_org_id, o.c_bpartner_id, o.c_order_id, o.documentno, o.dateordered, o.c_doctype_id, o.totallines]]></view>
</database>
Index: src-db/database/sourcedata/AD_COLUMN.xml
===================================================================
--- src-db/database/sourcedata/AD_COLUMN.xml (revision 12103)
+++ src-db/database/sourcedata/AD_COLUMN.xml (working copy)
@@ -1,7 +1,7 @@
<?xml version='1.0' encoding='UTF-8'?>
<data>
<!--100**************--><AD_COLUMN>
-<!--100 AD_COLUMN_ID-->8020
+<!--100 AD_COLUMN_ID-->
<!--100--> <AD_COLUMN_ID><![CDATA[100]]></AD_COLUMN_ID>
<!--100 AD_CLIENT_ID-->
<!--100--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
|