Attached Files | formal-changes-pg95.diff [^] (53,131 bytes) 2015-07-21 13:08 [Show Content] [Hide Content]diff -r f6885205cc8d src-db/database/model/tables/AD_ORGTYPE.xml
--- a/src-db/database/model/tables/AD_ORGTYPE.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/AD_ORGTYPE.xml Tue Jul 21 08:02:15 2015 +0200
@@ -72,7 +72,7 @@
<check name="AD_ORGTYPE_ISBU_CHECK"><![CDATA[ISBUSINESSUNIT IN ('Y', 'N')]]></check>
<check name="AD_ORGTYPE_ISDEFAULT_CHECK"><![CDATA[ISDEFAULT IN ('Y', 'N')]]></check>
<check name="AD_ORGTYPE_ISLEGALENTITY_CHECK"><![CDATA[ISLEGALENTITY IN ('Y', 'N')]]></check>
- <check name="AD_ORGTYPE_ISLEGALENTITY_CHK"><![CDATA[(((ISLEGALENTITY = 'Y') AND (ISBUSINESSUNIT = 'N')) OR ((ISLEGALENTITY = 'N') AND (ISBUSINESSUNIT = 'Y'))) OR ((ISLEGALENTITY = 'N') AND (ISBUSINESSUNIT = 'N'))]]></check>
+ <check name="AD_ORGTYPE_ISLEGALENTITY_CHK"><![CDATA[((ISLEGALENTITY = 'Y') AND (ISBUSINESSUNIT = 'N')) OR ((ISLEGALENTITY = 'N') AND (ISBUSINESSUNIT = 'Y')) OR ((ISLEGALENTITY = 'N') AND (ISBUSINESSUNIT = 'N'))]]></check>
<check name="AD_ORGTYPE_ISTRALLOWED_CHECK"><![CDATA[ISTRANSACTIONSALLOWED IN ('Y', 'N')]]></check>
</table>
</database>
diff -r f6885205cc8d src-db/database/model/tables/AD_ORG_ACCTSCHEMA.xml
--- a/src-db/database/model/tables/AD_ORG_ACCTSCHEMA.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/AD_ORG_ACCTSCHEMA.xml Tue Jul 21 08:02:15 2015 +0200
@@ -79,10 +79,10 @@
<index name="AD_ORGACCTSCHEMA_ORG_IDX" unique="false">
<index-column name="AD_ORG_ID"/>
</index>
- <check name="AD_ORG_ACCTSCHEMA_BPFIELDS_CHK"><![CDATA[(ISBPNEWACCOUNT = 'N') OR ((((ISBPNEWACCOUNT = 'Y') AND (AD_SEQUENCE_BP_ID IS NOT NULL)) AND (ACCT_LENGTH IS NOT NULL)) AND (SUBACCT_LENGTH IS NOT NULL))]]></check>
+ <check name="AD_ORG_ACCTSCHEMA_BPFIELDS_CHK"><![CDATA[(ISBPNEWACCOUNT = 'N') OR ((ISBPNEWACCOUNT = 'Y') AND (AD_SEQUENCE_BP_ID IS NOT NULL) AND (ACCT_LENGTH IS NOT NULL) AND (SUBACCT_LENGTH IS NOT NULL))]]></check>
<check name="AD_ORG_ACCTSCHEMA_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
<check name="AD_ORG_ACCTSCHEMA_ISBPNEWA_CHK"><![CDATA[ISBPNEWACCOUNT IN ('Y', 'N')]]></check>
<check name="AD_ORG_ACCTSCHEMA_ISPRNEWA_CHK"><![CDATA[ISPRNEWACCOUNT IN ('Y', 'N')]]></check>
- <check name="AD_ORG_ACCTSCHEMA_PRFIELDS_CHK"><![CDATA[(ISPRNEWACCOUNT = 'N') OR ((((ISPRNEWACCOUNT = 'Y') AND (AD_SEQUENCE_PR_ID IS NOT NULL)) AND (ACCT_LENGTH IS NOT NULL)) AND (SUBACCT_LENGTH IS NOT NULL))]]></check>
+ <check name="AD_ORG_ACCTSCHEMA_PRFIELDS_CHK"><![CDATA[(ISPRNEWACCOUNT = 'N') OR ((ISPRNEWACCOUNT = 'Y') AND (AD_SEQUENCE_PR_ID IS NOT NULL) AND (ACCT_LENGTH IS NOT NULL) AND (SUBACCT_LENGTH IS NOT NULL))]]></check>
</table>
</database>
diff -r f6885205cc8d src-db/database/model/tables/AD_PREFERENCE.xml
--- a/src-db/database/model/tables/AD_PREFERENCE.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/AD_PREFERENCE.xml Tue Jul 21 08:02:15 2015 +0200
@@ -108,7 +108,7 @@
<index-column name="PROPERTY"/>
</index>
<check name="AD_PREFERENCE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
- <check name="AD_PREFERENCE_LIST_CHECK"><![CDATA[(((ISPROPERTYLIST = 'Y') AND (PROPERTY IS NOT NULL)) AND (ATTRIBUTE IS NULL)) OR (((ISPROPERTYLIST = 'N') AND (ATTRIBUTE IS NOT NULL)) AND (PROPERTY IS NULL))]]></check>
+ <check name="AD_PREFERENCE_LIST_CHECK"><![CDATA[((ISPROPERTYLIST = 'Y') AND (PROPERTY IS NOT NULL) AND (ATTRIBUTE IS NULL)) OR ((ISPROPERTYLIST = 'N') AND (ATTRIBUTE IS NOT NULL) AND (PROPERTY IS NULL))]]></check>
<check name="AD_PREFERENCE_SELECTED_CHECK"><![CDATA[SELECTED IN ('Y', 'N')]]></check>
</table>
</database>
diff -r f6885205cc8d src-db/database/model/tables/AD_TABLE.xml
--- a/src-db/database/model/tables/AD_TABLE.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/AD_TABLE.xml Tue Jul 21 08:02:15 2015 +0200
@@ -175,7 +175,7 @@
<unique name="AD_TABLE_TREETYPE_UN">
<unique-column name="TREETYPE"/>
</unique>
- <check name="AD_TABLE_CLASSNAME_CHK"><![CDATA[((UPPER((DATAORIGINTYPE)) = 'DATASOURCE') OR (UPPER((DATAORIGINTYPE)) = 'HQL')) OR (CLASSNAME IS NOT NULL)]]></check>
+ <check name="AD_TABLE_CLASSNAME_CHK"><![CDATA[(UPPER((DATAORIGINTYPE)) = 'DATASOURCE') OR (UPPER((DATAORIGINTYPE)) = 'HQL') OR (CLASSNAME IS NOT NULL)]]></check>
<check name="AD_TABLE_DATASOURCE_CHK"><![CDATA[(UPPER((DATAORIGINTYPE)) <> 'DATASOURCE') OR (OBSERDS_DATASOURCE_ID IS NOT NULL)]]></check>
<check name="AD_TABLE_HQL_CHK"><![CDATA[(UPPER((DATAORIGINTYPE)) <> 'HQL') OR (HQLQUERY IS NOT NULL)]]></check>
<check name="AD_TABLE_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
diff -r f6885205cc8d src-db/database/model/tables/C_BANK.xml
--- a/src-db/database/model/tables/C_BANK.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/C_BANK.xml Tue Jul 21 08:02:15 2015 +0200
@@ -92,7 +92,7 @@
<foreign-key foreignTable="C_LOCATION" name="C_BANK_C_LOCATION">
<reference local="C_LOCATION_ID" foreign="C_LOCATION_ID"/>
</foreign-key>
- <check name="C_BANK_CODEBANK_CHK"><![CDATA[(((CODEBANK IS NULL) OR (LENGTH((CODEBANK)) = 4)) AND ((CODEBRANCH IS NULL) OR (LENGTH((CODEBRANCH)) = 4))) AND ((DIGITCONTROL IS NULL) OR (LENGTH((DIGITCONTROL)) = 1))]]></check>
+ <check name="C_BANK_CODEBANK_CHK"><![CDATA[((CODEBANK IS NULL) OR (LENGTH((CODEBANK)) = 4)) AND ((CODEBRANCH IS NULL) OR (LENGTH((CODEBRANCH)) = 4)) AND ((DIGITCONTROL IS NULL) OR (LENGTH((DIGITCONTROL)) = 1))]]></check>
<check name="C_BANK_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
<check name="C_BANK_ISOWNBANK_CHK"><![CDATA[ISOWNBANK IN ('Y', 'N')]]></check>
</table>
diff -r f6885205cc8d src-db/database/model/tables/C_BANKACCOUNT.xml
--- a/src-db/database/model/tables/C_BANKACCOUNT.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/C_BANKACCOUNT.xml Tue Jul 21 08:02:15 2015 +0200
@@ -110,9 +110,9 @@
</index>
<check name="C_BANKACC_SHOWGENERIC_CHECK"><![CDATA[(GENERICACCOUNT IS NOT NULL) OR (SHOWGENERIC = 'N')]]></check>
<check name="C_BANKACC_SHOWIBAN_CHECK"><![CDATA[(IBAN IS NOT NULL) OR (SHOWIBAN = 'N')]]></check>
- <check name="C_BANKACC_SHOWONE_CHECK"><![CDATA[((((SHOWSPANISH = 'Y') AND (SHOWGENERIC = 'N')) AND (SHOWIBAN = 'N')) OR (((SHOWSPANISH = 'N') AND (SHOWGENERIC = 'Y')) AND (SHOWIBAN = 'N'))) OR (((SHOWSPANISH = 'N') AND (SHOWGENERIC = 'N')) AND (SHOWIBAN = 'Y'))]]></check>
- <check name="C_BANKACC_SHOWSPANISH_CHECK"><![CDATA[((((DIGITCONTROL IS NOT NULL) AND (CODEACCOUNT IS NOT NULL)) AND (LENGTH((DIGITCONTROL)) = 1)) AND (LENGTH((CODEACCOUNT)) = 10)) OR (((DIGITCONTROL IS NULL) AND (CODEACCOUNT IS NULL)) AND (SHOWSPANISH = 'N'))]]></check>
- <check name="C_BANKACCOUNT_ACCOUNTNO_CHECK"><![CDATA[((GENERICACCOUNT IS NOT NULL) OR (IBAN IS NOT NULL)) OR ((CODEACCOUNT IS NOT NULL) AND (DIGITCONTROL IS NOT NULL))]]></check>
+ <check name="C_BANKACC_SHOWONE_CHECK"><![CDATA[((SHOWSPANISH = 'Y') AND (SHOWGENERIC = 'N') AND (SHOWIBAN = 'N')) OR ((SHOWSPANISH = 'N') AND (SHOWGENERIC = 'Y') AND (SHOWIBAN = 'N')) OR ((SHOWSPANISH = 'N') AND (SHOWGENERIC = 'N') AND (SHOWIBAN = 'Y'))]]></check>
+ <check name="C_BANKACC_SHOWSPANISH_CHECK"><![CDATA[((DIGITCONTROL IS NOT NULL) AND (CODEACCOUNT IS NOT NULL) AND (LENGTH((DIGITCONTROL)) = 1) AND (LENGTH((CODEACCOUNT)) = 10)) OR ((DIGITCONTROL IS NULL) AND (CODEACCOUNT IS NULL) AND (SHOWSPANISH = 'N'))]]></check>
+ <check name="C_BANKACCOUNT_ACCOUNTNO_CHECK"><![CDATA[(GENERICACCOUNT IS NOT NULL) OR (IBAN IS NOT NULL) OR ((CODEACCOUNT IS NOT NULL) AND (DIGITCONTROL IS NOT NULL))]]></check>
<check name="C_BANKACCOUNT_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
</table>
</database>
diff -r f6885205cc8d src-db/database/model/tables/C_BPARTNER.xml
--- a/src-db/database/model/tables/C_BPARTNER.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/C_BPARTNER.xml Tue Jul 21 08:02:15 2015 +0200
@@ -465,7 +465,7 @@
<unique-column name="VALUE"/>
</unique>
<check name="C_BPARTNER_CBLOCKING_CHK"><![CDATA[CUSTOMER_BLOCKING IN ('Y', 'N')]]></check>
- <check name="C_BPARTNER_CUSBLOCKING_CHK"><![CDATA[(CUSTOMER_BLOCKING = 'N') OR ((((SO_ORDER_BLOCKING = 'Y') OR (SO_GOODS_BLOCKING = 'Y')) OR (SO_INVOICE_BLOCKING = 'Y')) OR (SO_PAYMENT_BLOCKING = 'Y'))]]></check>
+ <check name="C_BPARTNER_CUSBLOCKING_CHK"><![CDATA[(CUSTOMER_BLOCKING = 'N') OR ((SO_ORDER_BLOCKING = 'Y') OR (SO_GOODS_BLOCKING = 'Y') OR (SO_INVOICE_BLOCKING = 'Y') OR (SO_PAYMENT_BLOCKING = 'Y'))]]></check>
<check name="C_BPARTNER_INVOICERULE_CHK"><![CDATA[((INVOICERULE) <> 'S') OR (C_INVOICESCHEDULE_ID IS NOT NULL)]]></check>
<check name="C_BPARTNER_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
<check name="C_BPARTNER_ISCASHVAT_CH"><![CDATA[ISCASHVAT IN ('Y', 'N')]]></check>
@@ -488,6 +488,6 @@
<check name="C_BPARTNER_SOBLOCKING_CHK"><![CDATA[SO_ORDER_BLOCKING IN ('Y', 'N')]]></check>
<check name="C_BPARTNER_SPBLOCKING_CHK"><![CDATA[SO_PAYMENT_BLOCKING IN ('Y', 'N')]]></check>
<check name="C_BPARTNER_VBLOCKING_CHK"><![CDATA[VENDOR_BLOCKING IN ('Y', 'N')]]></check>
- <check name="C_BPARTNER_VENBLOCKING_CHK"><![CDATA[(VENDOR_BLOCKING = 'N') OR ((((PO_ORDER_BLOCKING = 'Y') OR (PO_GOODS_BLOCKING = 'Y')) OR (PO_INVOICE_BLOCKING = 'Y')) OR (PO_PAYMENT_BLOCKING = 'Y'))]]></check>
+ <check name="C_BPARTNER_VENBLOCKING_CHK"><![CDATA[(VENDOR_BLOCKING = 'N') OR ((PO_ORDER_BLOCKING = 'Y') OR (PO_GOODS_BLOCKING = 'Y') OR (PO_INVOICE_BLOCKING = 'Y') OR (PO_PAYMENT_BLOCKING = 'Y'))]]></check>
</table>
</database>
diff -r f6885205cc8d src-db/database/model/tables/C_BP_BANKACCOUNT.xml
--- a/src-db/database/model/tables/C_BP_BANKACCOUNT.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/C_BP_BANKACCOUNT.xml Tue Jul 21 08:02:15 2015 +0200
@@ -162,7 +162,7 @@
<check name="C_BP_BACC_COUNTRY_CHECK"><![CDATA[(IBAN IS NULL) OR (C_COUNTRY_ID IS NOT NULL)]]></check>
<check name="C_BP_BACC_SHOWGENERIC_CHK"><![CDATA[((UPPER((BANKFORMAT)) = UPPER('GENERIC')) AND (ACCOUNTNO IS NOT NULL)) OR (UPPER((BANKFORMAT)) <> UPPER('GENERIC'))]]></check>
<check name="C_BP_BACC_SHOWIBAN_CHK"><![CDATA[((UPPER((BANKFORMAT)) = UPPER('IBAN')) AND (IBAN IS NOT NULL)) OR (UPPER((BANKFORMAT)) <> UPPER('IBAN'))]]></check>
- <check name="C_BP_BACC_SHOWSWIFT_CHK"><![CDATA[(((UPPER((BANKFORMAT)) = UPPER('SWIFT')) AND (SWIFTCODE IS NOT NULL)) AND (ACCOUNTNO IS NOT NULL)) OR (UPPER((BANKFORMAT)) <> UPPER('SWIFT'))]]></check>
+ <check name="C_BP_BACC_SHOWSWIFT_CHK"><![CDATA[((UPPER((BANKFORMAT)) = UPPER('SWIFT')) AND (SWIFTCODE IS NOT NULL) AND (ACCOUNTNO IS NOT NULL)) OR (UPPER((BANKFORMAT)) <> UPPER('SWIFT'))]]></check>
<check name="C_BP_BANKACCOUNT_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
</table>
</database>
diff -r f6885205cc8d src-db/database/model/tables/C_DEBT_PAYMENT.xml
--- a/src-db/database/model/tables/C_DEBT_PAYMENT.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/C_DEBT_PAYMENT.xml Tue Jul 21 08:02:15 2015 +0200
@@ -220,7 +220,7 @@
<check name="C_DEBT_PAYMENT_C_BANKSTATE_CHK"><![CDATA[((C_BANKSTATEMENTLINE_ID IS NULL) AND (C_CASHLINE_ID IS NULL)) OR (ISPAID = 'Y')]]></check>
<check name="C_DEBT_PAYMENT_C_BPARTNER__CHK"><![CDATA[C_BPARTNER_ID IS NOT NULL]]></check>
<check name="C_DEBT_PAYMENT_C_CASHLINE__CHK"><![CDATA[(C_CASHLINE_ID IS NULL) OR (C_BANKSTATEMENTLINE_ID IS NULL)]]></check>
- <check name="C_DEBT_PAYMENT_C_SETTLEMEN_CH1"><![CDATA[((C_SETTLEMENT_CANCEL_ID IS NOT NULL) OR (C_SETTLEMENT_GENERATE_ID IS NOT NULL)) OR (ISPAID = 'N')]]></check>
+ <check name="C_DEBT_PAYMENT_C_SETTLEMEN_CH1"><![CDATA[(C_SETTLEMENT_CANCEL_ID IS NOT NULL) OR (C_SETTLEMENT_GENERATE_ID IS NOT NULL) OR (ISPAID = 'N')]]></check>
<check name="C_DEBT_PAYMENT_C_SETTLEMEN_CHK"><![CDATA[(C_SETTLEMENT_CANCEL_ID IS NULL) OR (ISVALID = 'Y')]]></check>
<check name="C_DEBT_PAYMENT_CANCEL_PROC_CH1"><![CDATA[CANCEL_PROCESSED IN ('Y', 'N')]]></check>
<check name="C_DEBT_PAYMENT_CANCEL_PROC_CHK"><![CDATA[(CANCEL_PROCESSED = 'N') OR (C_SETTLEMENT_CANCEL_ID IS NOT NULL)]]></check>
@@ -231,6 +231,6 @@
<check name="C_DEBT_PAYMENT_ISRECEIPT"><![CDATA[ISRECEIPT IN ('Y', 'N')]]></check>
<check name="C_DEBT_PAYMENT_ISVALID"><![CDATA[ISVALID IN ('Y', 'N')]]></check>
<check name="C_DEBT_PAYMENT_ISVALID_CHK"><![CDATA[(ISVALID = 'N') OR (ISACTIVE = 'Y')]]></check>
- <check name="C_DEBT_PAYMENT_ISVALID_CHK1"><![CDATA[(((ISVALID = 'Y') AND (((C_SETTLEMENT_GENERATE_ID IS NULL) AND (GENERATE_PROCESSED = 'N')) OR ((C_SETTLEMENT_GENERATE_ID IS NOT NULL) AND (GENERATE_PROCESSED = 'Y')))) OR (((ISVALID = 'N') AND (C_SETTLEMENT_GENERATE_ID IS NOT NULL)) AND (GENERATE_PROCESSED = 'N'))) OR ((ISVALID = 'N') AND (ISAUTOMATICGENERATED = 'N'))]]></check>
+ <check name="C_DEBT_PAYMENT_ISVALID_CHK1"><![CDATA[((ISVALID = 'Y') AND (((C_SETTLEMENT_GENERATE_ID IS NULL) AND (GENERATE_PROCESSED = 'N')) OR ((C_SETTLEMENT_GENERATE_ID IS NOT NULL) AND (GENERATE_PROCESSED = 'Y')))) OR ((ISVALID = 'N') AND (C_SETTLEMENT_GENERATE_ID IS NOT NULL) AND (GENERATE_PROCESSED = 'N')) OR ((ISVALID = 'N') AND (ISAUTOMATICGENERATED = 'N'))]]></check>
</table>
</database>
diff -r f6885205cc8d src-db/database/model/tables/C_GLITEM.xml
--- a/src-db/database/model/tables/C_GLITEM.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/C_GLITEM.xml Tue Jul 21 08:02:15 2015 +0200
@@ -79,7 +79,7 @@
<check name="C_GLITEM_FINCAT_CHECK"><![CDATA[((ENABLEINFININVOICES = 'Y') AND (C_TAXCATEGORY_ID IS NOT NULL)) OR ((ENABLEINFININVOICES = 'N') AND (C_TAXCATEGORY_ID IS NULL))]]></check>
<check name="C_GLITEM_FININVOICES_CHECK"><![CDATA[ENABLEINFININVOICES IN ('Y', 'N')]]></check>
<check name="C_GLITEM_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
- <check name="C_GLITEM_TAXANDCAT_CHECK"><![CDATA[(((C_TAXCATEGORY_ID IS NOT NULL) AND (C_TAX_ID IS NULL)) AND (C_WITHHOLDING_ID IS NULL)) OR (C_TAXCATEGORY_ID IS NULL)]]></check>
+ <check name="C_GLITEM_TAXANDCAT_CHECK"><![CDATA[((C_TAXCATEGORY_ID IS NOT NULL) AND (C_TAX_ID IS NULL) AND (C_WITHHOLDING_ID IS NULL)) OR (C_TAXCATEGORY_ID IS NULL)]]></check>
<check name="C_GLITEM_TAXANDWH_CHECK"><![CDATA[(C_TAX_ID IS NULL) OR (C_WITHHOLDING_ID IS NULL)]]></check>
</table>
</database>
diff -r f6885205cc8d src-db/database/model/tables/C_INVOICELINE.xml
--- a/src-db/database/model/tables/C_INVOICELINE.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/C_INVOICELINE.xml Tue Jul 21 08:02:15 2015 +0200
@@ -309,7 +309,7 @@
<check name="C_INVLINE_PERIODNUMBER_CHK"><![CDATA[((ISDEFERRED = 'Y') AND (PERIODNUMBER > 0)) OR (ISDEFERRED = 'N')]]></check>
<check name="C_INVOICELINE_CHECK1"><![CDATA[((QUANTITYORDER IS NULL) AND (M_PRODUCT_UOM_ID IS NULL)) OR ((QUANTITYORDER IS NOT NULL) AND (M_PRODUCT_UOM_ID IS NOT NULL))]]></check>
<check name="C_INVOICELINE_CHECK2"><![CDATA[(LINENETAMT = 0) OR (C_TAX_ID IS NOT NULL)]]></check>
- <check name="C_INVOICELINE_CHECK3"><![CDATA[(((((ISDEFERRED = 'Y') AND (C_PERIOD_ID IS NOT NULL)) AND (DEFPLANTYPE IS NOT NULL)) AND (M_PRODUCT_ID IS NOT NULL)) AND (PERIODNUMBER IS NOT NULL)) OR (ISDEFERRED = 'N')]]></check>
+ <check name="C_INVOICELINE_CHECK3"><![CDATA[((ISDEFERRED = 'Y') AND (C_PERIOD_ID IS NOT NULL) AND (DEFPLANTYPE IS NOT NULL) AND (M_PRODUCT_ID IS NOT NULL) AND (PERIODNUMBER IS NOT NULL)) OR (ISDEFERRED = 'N')]]></check>
<check name="C_INVOICELINE_EXPLODE_CHECK"><![CDATA[EXPLODE IN ('Y', 'N')]]></check>
<check name="C_INVOICELINE_FIN_INVLINE_CHK"><![CDATA[FINANCIAL_INVOICE_LINE IN ('Y', 'N')]]></check>
<check name="C_INVOICELINE_FINACCT_CHK"><![CDATA[((FINANCIAL_INVOICE_LINE = 'Y') AND (ACCOUNT_ID IS NOT NULL)) OR ((FINANCIAL_INVOICE_LINE = 'N') AND (ACCOUNT_ID IS NULL))]]></check>
diff -r f6885205cc8d src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT.xml
--- a/src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT.xml Tue Jul 21 08:02:15 2015 +0200
@@ -161,7 +161,7 @@
<check name="FIN_FINACC_DEFAULT_CHECK"><![CDATA[ISDEFAULT IN ('Y', 'N')]]></check>
<check name="FIN_FINACC_SHOWGENERIC_CHK"><![CDATA[((UPPER((BANKFORMAT)) = UPPER('GENERIC')) AND (GENERICACCOUNTNO IS NOT NULL)) OR (UPPER((BANKFORMAT)) <> UPPER('GENERIC'))]]></check>
<check name="FIN_FINACC_SHOWIBAN_CHK"><![CDATA[((UPPER((BANKFORMAT)) = UPPER('IBAN')) AND (IBAN IS NOT NULL)) OR (UPPER((BANKFORMAT)) <> UPPER('IBAN'))]]></check>
- <check name="FIN_FINACC_SHOWSWIFT_CHK"><![CDATA[(((UPPER((BANKFORMAT)) = UPPER('SWIFT')) AND (SWIFTCODE IS NOT NULL)) AND (GENERICACCOUNTNO IS NOT NULL)) OR (UPPER((BANKFORMAT)) <> UPPER('SWIFT'))]]></check>
- <check name="FIN_FINACC_SPANISH_CHK"><![CDATA[((((((UPPER((BANKFORMAT)) = UPPER('SPANISH')) AND (CODEBANK IS NOT NULL)) AND (CODEBRANCH IS NOT NULL)) AND (BANK_DIGITCONTROL IS NOT NULL)) AND (ACCOUNT_DIGITCONTROL IS NOT NULL)) AND (CODEACCOUNT IS NOT NULL)) OR (UPPER((BANKFORMAT)) <> UPPER('SPANISH'))]]></check>
+ <check name="FIN_FINACC_SHOWSWIFT_CHK"><![CDATA[((UPPER((BANKFORMAT)) = UPPER('SWIFT')) AND (SWIFTCODE IS NOT NULL) AND (GENERICACCOUNTNO IS NOT NULL)) OR (UPPER((BANKFORMAT)) <> UPPER('SWIFT'))]]></check>
+ <check name="FIN_FINACC_SPANISH_CHK"><![CDATA[((UPPER((BANKFORMAT)) = UPPER('SPANISH')) AND (CODEBANK IS NOT NULL) AND (CODEBRANCH IS NOT NULL) AND (BANK_DIGITCONTROL IS NOT NULL) AND (ACCOUNT_DIGITCONTROL IS NOT NULL) AND (CODEACCOUNT IS NOT NULL)) OR (UPPER((BANKFORMAT)) <> UPPER('SPANISH'))]]></check>
</table>
</database>
diff -r f6885205cc8d src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT_ACCT.xml
--- a/src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT_ACCT.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT_ACCT.xml Tue Jul 21 08:02:15 2015 +0200
@@ -169,7 +169,7 @@
<unique-column name="FIN_FINANCIAL_ACCOUNT_ID"/>
<unique-column name="C_ACCTSCHEMA_ID"/>
</unique>
- <check name="FIN_FINACC_ACCT_BSCONFIG_CHECK"><![CDATA[(((ENABLEBANKSTATEMENT = 'Y') AND (FIN_TRANSITORY_ACCT IS NOT NULL)) AND (FIN_ASSET_ACCT IS NOT NULL)) OR (ENABLEBANKSTATEMENT <> 'Y')]]></check>
+ <check name="FIN_FINACC_ACCT_BSCONFIG_CHECK"><![CDATA[((ENABLEBANKSTATEMENT = 'Y') AND (FIN_TRANSITORY_ACCT IS NOT NULL) AND (FIN_ASSET_ACCT IS NOT NULL)) OR (ENABLEBANKSTATEMENT <> 'Y')]]></check>
<check name="FIN_FINACC_ACCT_ENABLEBS_CHECK"><![CDATA[ENABLEBANKSTATEMENT IN ('Y', 'N')]]></check>
<check name="FIN_FINACC_ACCT_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
</table>
diff -r f6885205cc8d src-db/database/model/tables/GL_JOURNALLINE.xml
--- a/src-db/database/model/tables/GL_JOURNALLINE.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/GL_JOURNALLINE.xml Tue Jul 21 08:02:15 2015 +0200
@@ -252,6 +252,6 @@
<check name="GL_JOURNALLINE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
<check name="GL_JOURNALLINE_ISGENERATED_CHK"><![CDATA[ISGENERATED IN ('Y', 'N')]]></check>
<check name="GL_JOURNALLINE_MGL_GLJ_CHECK"><![CDATA[((C_VALIDCOMBINATION_ID IS NOT NULL) AND (ACCOUNT_ID IS NULL)) OR ((C_VALIDCOMBINATION_ID IS NULL) AND (ACCOUNT_ID IS NOT NULL))]]></check>
- <check name="GL_JOURNALLINE_OPENITEM_CHECK"><![CDATA[(OPEN_ITEMS = 'N') OR (((((OPEN_ITEMS = 'Y') AND (FIN_FINANCIAL_ACCOUNT_ID IS NOT NULL)) AND (FIN_PAYMENTMETHOD_ID IS NOT NULL)) AND (C_GLITEM_ID IS NOT NULL)) AND (PAYMENTDATE IS NOT NULL))]]></check>
+ <check name="GL_JOURNALLINE_OPENITEM_CHECK"><![CDATA[(OPEN_ITEMS = 'N') OR ((OPEN_ITEMS = 'Y') AND (FIN_FINANCIAL_ACCOUNT_ID IS NOT NULL) AND (FIN_PAYMENTMETHOD_ID IS NOT NULL) AND (C_GLITEM_ID IS NOT NULL) AND (PAYMENTDATE IS NOT NULL))]]></check>
</table>
</database>
diff -r f6885205cc8d src-db/database/model/tables/M_INOUT.xml
--- a/src-db/database/model/tables/M_INOUT.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/M_INOUT.xml Tue Jul 21 08:02:15 2015 +0200
@@ -342,7 +342,7 @@
<index-column name="UPDATED"/>
</index>
<check name="M_INOUT_CREATEFROM_CHECK"><![CDATA[CREATEFROM IN ('Y', 'N')]]></check>
- <check name="M_INOUT_CURRENCY_CHECK"><![CDATA[((FREIGHTAMT = 0) OR (FREIGHTAMT IS NULL)) OR (FREIGHT_CURRENCY_ID IS NOT NULL)]]></check>
+ <check name="M_INOUT_CURRENCY_CHECK"><![CDATA[(FREIGHTAMT = 0) OR (FREIGHTAMT IS NULL) OR (FREIGHT_CURRENCY_ID IS NOT NULL)]]></check>
<check name="M_INOUT_GENERATELINES_CHECK"><![CDATA[GENERATELINES IN ('N', 'Y')]]></check>
<check name="M_INOUT_GENERATETO_CHECK"><![CDATA[GENERATETO IN ('Y', 'N')]]></check>
<check name="M_INOUT_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
diff -r f6885205cc8d src-db/database/model/tables/M_PRODUCT.xml
--- a/src-db/database/model/tables/M_PRODUCT.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/M_PRODUCT.xml Tue Jul 21 08:02:15 2015 +0200
@@ -446,14 +446,14 @@
<check name="M_PRODUCT_ENFORCE_ATTRIBUT_CHK"><![CDATA[ENFORCE_ATTRIBUTE IN ('Y', 'N')]]></check>
<check name="M_PRODUCT_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
<check name="M_PRODUCT_ISBOM_CHECK"><![CDATA[ISBOM IN ('Y', 'N')]]></check>
- <check name="M_PRODUCT_ISEXPDEFCOMPLETE_CHK"><![CDATA[(ISDEFERREDEXPENSE = 'N') OR ((((ISDEFERREDEXPENSE = 'Y') AND (EXPPLANTYPE IS NOT NULL)) AND (DEFAULTPERIOD_EXP IS NOT NULL)) AND (PERIODNUMBER_EXP IS NOT NULL))]]></check>
+ <check name="M_PRODUCT_ISEXPDEFCOMPLETE_CHK"><![CDATA[(ISDEFERREDEXPENSE = 'N') OR ((ISDEFERREDEXPENSE = 'Y') AND (EXPPLANTYPE IS NOT NULL) AND (DEFAULTPERIOD_EXP IS NOT NULL) AND (PERIODNUMBER_EXP IS NOT NULL))]]></check>
<check name="M_PRODUCT_ISEXPDEFERRED_CHK"><![CDATA[ISDEFERREDEXPENSE IN ('Y', 'N')]]></check>
<check name="M_PRODUCT_ISGENERIC"><![CDATA[ISGENERIC IN ('Y', 'N')]]></check>
<check name="M_PRODUCT_ISINVOICEPRINTDE_CHK"><![CDATA[ISINVOICEPRINTDETAILS IN ('Y', 'N')]]></check>
<check name="M_PRODUCT_ISPICKLISTPRINTD_CHK"><![CDATA[ISPICKLISTPRINTDETAILS IN ('Y', 'N')]]></check>
<check name="M_PRODUCT_ISPURCHASED_CHECK"><![CDATA[ISPURCHASED IN ('Y', 'N')]]></check>
<check name="M_PRODUCT_ISQTYVAR_CHECK"><![CDATA[ISQUANTITYVARIABLE IN ('Y', 'N')]]></check>
- <check name="M_PRODUCT_ISREVDEFCOMPLETE_CHK"><![CDATA[(ISDEFERREDREVENUE = 'N') OR ((((ISDEFERREDREVENUE = 'Y') AND (REVPLANTYPE IS NOT NULL)) AND (DEFAULTPERIOD IS NOT NULL)) AND (PERIODNUMBER IS NOT NULL))]]></check>
+ <check name="M_PRODUCT_ISREVDEFCOMPLETE_CHK"><![CDATA[(ISDEFERREDREVENUE = 'N') OR ((ISDEFERREDREVENUE = 'Y') AND (REVPLANTYPE IS NOT NULL) AND (DEFAULTPERIOD IS NOT NULL) AND (PERIODNUMBER IS NOT NULL))]]></check>
<check name="M_PRODUCT_ISREVDEFERRED_CHK"><![CDATA[ISDEFERREDREVENUE IN ('Y', 'N')]]></check>
<check name="M_PRODUCT_ISSOLD_CHECK"><![CDATA[ISSOLD IN ('Y', 'N')]]></check>
<check name="M_PRODUCT_ISSTOCKED_CHECK"><![CDATA[ISSTOCKED IN ('Y', 'N')]]></check>
diff -r f6885205cc8d src-db/database/model/tables/M_STORAGE_DETAIL.xml
--- a/src-db/database/model/tables/M_STORAGE_DETAIL.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/M_STORAGE_DETAIL.xml Tue Jul 21 08:02:15 2015 +0200
@@ -124,6 +124,6 @@
<unique-column name="C_UOM_ID"/>
<unique-column name="M_PRODUCT_UOM_ID"/>
</unique>
- <check name="M_STORAGE_DETAIL_CHECK1"><![CDATA[(((QTYORDERONHAND IS NULL) AND (M_PRODUCT_UOM_ID IS NULL)) AND (PREQTYORDERONHAND IS NULL)) OR (((QTYORDERONHAND IS NOT NULL) AND (M_PRODUCT_UOM_ID IS NOT NULL)) AND (PREQTYORDERONHAND IS NOT NULL))]]></check>
+ <check name="M_STORAGE_DETAIL_CHECK1"><![CDATA[((QTYORDERONHAND IS NULL) AND (M_PRODUCT_UOM_ID IS NULL) AND (PREQTYORDERONHAND IS NULL)) OR ((QTYORDERONHAND IS NOT NULL) AND (M_PRODUCT_UOM_ID IS NOT NULL) AND (PREQTYORDERONHAND IS NOT NULL))]]></check>
</table>
</database>
diff -r f6885205cc8d src-db/database/model/tables/M_STORAGE_PENDING.xml
--- a/src-db/database/model/tables/M_STORAGE_PENDING.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/tables/M_STORAGE_PENDING.xml Tue Jul 21 08:02:15 2015 +0200
@@ -97,6 +97,6 @@
<unique-column name="C_UOM_ID"/>
<unique-column name="M_PRODUCT_UOM_ID"/>
</unique>
- <check name="M_STORAGE_PENDING_CHECK1"><![CDATA[(((QTYORDERORDERED IS NULL) AND (M_PRODUCT_UOM_ID IS NULL)) AND (QTYORDERRESERVED IS NULL)) OR (((QTYORDERORDERED IS NOT NULL) AND (M_PRODUCT_UOM_ID IS NOT NULL)) AND (QTYORDERRESERVED IS NOT NULL))]]></check>
+ <check name="M_STORAGE_PENDING_CHECK1"><![CDATA[((QTYORDERORDERED IS NULL) AND (M_PRODUCT_UOM_ID IS NULL) AND (QTYORDERRESERVED IS NULL)) OR ((QTYORDERORDERED IS NOT NULL) AND (M_PRODUCT_UOM_ID IS NOT NULL) AND (QTYORDERRESERVED IS NOT NULL))]]></check>
</table>
</database>
diff -r f6885205cc8d src-db/database/model/views/C_DEBT_PAYMENT_V.xml
--- a/src-db/database/model/views/C_DEBT_PAYMENT_V.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/views/C_DEBT_PAYMENT_V.xml Tue Jul 21 08:02:15 2015 +0200
@@ -1,4 +1,4 @@
<?xml version="1.0"?>
<database name="VIEW C_DEBT_PAYMENT_V">
- <view name="C_DEBT_PAYMENT_V"><![CDATA[SELECT c_debt_payment.c_debt_payment_id AS c_debt_payment_v_id, 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) END AS amount, CASE c_debt_payment.isreceipt WHEN 'Y' THEN c_debt_payment.writeoffamt ELSE c_debt_payment.writeoffamt * (-1) END AS writeoffamt, CASE c_debt_payment.isreceipt WHEN 'Y' THEN 1 ELSE (-1) END AS multiplierap, CASE WHEN c_debt_payment.c_invoice_id IS NOT NULL THEN c_invoice.dateinvoiced WHEN c_debt_payment.c_settlement_generate_id IS NOT NULL THEN c_settlement.datetrx ELSE to_date(now()) END AS docdate, c_debt_payment.glitemamt, c_debt_payment.c_order_id, c_debt_payment.status FROM c_debt_payment LEFT JOIN c_invoice ON c_debt_payment.c_invoice_id = c_invoice.c_invoice_id LEFT JOIN c_settlement ON c_debt_payment.c_settlement_generate_id = c_settlement.c_settlement_id]]></view>
+ <view name="C_DEBT_PAYMENT_V"><![CDATA[SELECT c_debt_payment.c_debt_payment_id AS c_debt_payment_v_id, 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' END AS amount, CASE c_debt_payment.isreceipt WHEN 'Y' THEN c_debt_payment.writeoffamt ELSE c_debt_payment.writeoffamt * '-1' END AS writeoffamt, CASE c_debt_payment.isreceipt WHEN 'Y' THEN 1 ELSE '-1' END AS multiplierap, CASE WHEN c_debt_payment.c_invoice_id IS NOT NULL THEN c_invoice.dateinvoiced WHEN c_debt_payment.c_settlement_generate_id IS NOT NULL THEN c_settlement.datetrx ELSE to_date(now()) END AS docdate, c_debt_payment.glitemamt, c_debt_payment.c_order_id, c_debt_payment.status FROM c_debt_payment LEFT JOIN c_invoice ON c_debt_payment.c_invoice_id = c_invoice.c_invoice_id LEFT JOIN c_settlement ON c_debt_payment.c_settlement_generate_id = c_settlement.c_settlement_id]]></view>
</database>
diff -r f6885205cc8d src-db/database/model/views/C_INVOICE_V.xml
--- a/src-db/database/model/views/C_INVOICE_V.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/views/C_INVOICE_V.xml Tue Jul 21 08:02:15 2015 +0200
@@ -1,4 +1,4 @@
<?xml version="1.0"?>
<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) ELSE i.chargeamt END AS chargeamt, CASE 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) ELSE i.grandtotal END AS grandtotal, CASE WHEN substr(d.docbasetype, 3) = 'C' THEN (-1) ELSE 1 END AS multiplier, CASE WHEN substr(d.docbasetype, 2, 1) = 'P' THEN (-1) ELSE 1 END AS multiplierap, d.docbasetype FROM c_invoice i JOIN c_doctype d ON i.c_doctype_id = d.c_doctype_id]]></view>
+ <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' ELSE i.chargeamt END AS chargeamt, CASE 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' ELSE i.grandtotal END AS grandtotal, CASE WHEN substr(d.docbasetype, 3) = 'C' THEN '-1' ELSE 1 END AS multiplier, CASE WHEN substr(d.docbasetype, 2, 1) = 'P' THEN '-1' ELSE 1 END AS multiplierap, d.docbasetype FROM c_invoice i JOIN c_doctype d ON i.c_doctype_id = d.c_doctype_id]]></view>
</database>
diff -r f6885205cc8d src-db/database/model/views/C_INVOICE_V2.xml
--- a/src-db/database/model/views/C_INVOICE_V2.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/views/C_INVOICE_V2.xml Tue Jul 21 08:02:15 2015 +0200
@@ -1,4 +1,4 @@
<?xml version="1.0"?>
<database name="VIEW C_INVOICE_V2">
- <view name="C_INVOICE_V2"><![CDATA[SELECT i.c_invoice_id AS c_invoice_v2_id, 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) ELSE i.chargeamt END AS chargeamt, CASE substr(d.docbasetype, 3) WHEN 'C' THEN i.totallines * (-1) ELSE i.totallines END AS totallines, CASE substr(d.docbasetype, 3) WHEN 'C' THEN i.grandtotal * (-1) ELSE i.grandtotal END AS grandtotal, CASE substr(d.docbasetype, 3) WHEN 'C' THEN (-1) ELSE 1 END AS multiplier FROM c_invoice i, c_doctype d, c_bpartner b WHERE i.c_doctype_id = d.c_doctype_id AND i.c_bpartner_id = b.c_bpartner_id]]></view>
+ <view name="C_INVOICE_V2"><![CDATA[SELECT i.c_invoice_id AS c_invoice_v2_id, 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' ELSE i.chargeamt END AS chargeamt, CASE substr(d.docbasetype, 3) WHEN 'C' THEN i.totallines * '-1' ELSE i.totallines END AS totallines, CASE substr(d.docbasetype, 3) WHEN 'C' THEN i.grandtotal * '-1' ELSE i.grandtotal END AS grandtotal, CASE substr(d.docbasetype, 3) WHEN 'C' THEN '-1' ELSE 1 END AS multiplier FROM c_invoice i, c_doctype d, c_bpartner b WHERE i.c_doctype_id = d.c_doctype_id AND i.c_bpartner_id = b.c_bpartner_id]]></view>
</database>
diff -r f6885205cc8d src-db/database/model/views/FIN_DOUBTFUL_DEBT_V.xml
--- a/src-db/database/model/views/FIN_DOUBTFUL_DEBT_V.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/views/FIN_DOUBTFUL_DEBT_V.xml Tue Jul 21 08:02:15 2015 +0200
@@ -1,4 +1,4 @@
<?xml version="1.0"?>
<database name="VIEW FIN_DOUBTFUL_DEBT_V">
- <view name="FIN_DOUBTFUL_DEBT_V"><![CDATA[SELECT a.fin_doubtful_debt_v_id || to_char(1000 + b.aux) AS fin_doubtful_debt_v_id, a.fin_doubtful_debt_v_id AS fin_payment_schedule_id, a.ad_client_id, a.ad_org_id, a.isactive, a.created, a.createdby, a.updated, a.updatedby, a.documentno, a.c_bpartner_id, a.c_bp_group_id, a.dateinvoiced, a.fin_paymentmethod_id, a.c_currency_id, a.duedate, to_date((trunc(now()) - b.aux)) AS rundate, a.amount, a.outstandingamt, a.doubtfuldebt_amount, a.daysoverdue - b.aux AS daysoverdue, a.fin_doubtful_debt_run_id, a.fin_doubtful_debt_id, a.ob_selected FROM (SELECT ps.fin_payment_schedule_id AS fin_doubtful_debt_v_id, ps.ad_client_id, ps.ad_org_id, ps.isactive, ps.created, ps.createdby, ps.updated, ps.updatedby, inv.documentno, inv.c_bpartner_id, bp.c_bp_group_id, inv.dateinvoiced, inv.fin_paymentmethod_id, inv.c_currency_id, ps.duedate, ps.amount, ps.outstandingamt, sum(COALESCE(dd.amount, 0)) AS doubtfuldebt_amount, trunc(now()) - trunc(ps.duedate) AS daysoverdue, dd.fin_doubtful_debt_run_id, dd.fin_doubtful_debt_id, CASE WHEN dd.fin_doubtful_debt_run_id IS NULL THEN 'N' ELSE 'Y' END AS ob_selected FROM fin_payment_schedule ps JOIN c_invoice inv ON ps.c_invoice_id = inv.c_invoice_id JOIN c_bpartner bp ON inv.c_bpartner_id = bp.c_bpartner_id LEFT JOIN fin_doubtful_debt dd ON dd.fin_payment_schedule_id = ps.fin_payment_schedule_id WHERE ps.outstandingamt > 0 AND inv.issotrx = 'Y' GROUP BY ps.fin_payment_schedule_id, ps.ad_client_id, ps.ad_org_id, ps.isactive, ps.created, ps.createdby, ps.updated, ps.updatedby, inv.documentno, inv.c_bpartner_id, bp.c_bp_group_id, inv.dateinvoiced, inv.fin_paymentmethod_id, inv.c_currency_id, ps.duedate, ps.amount, ps.outstandingamt, dd.amount, trunc(now()) - trunc(ps.duedate), dd.fin_doubtful_debt_run_id, dd.fin_payment_schedule_id, dd.fin_doubtful_debt_id UNION SELECT ps.fin_payment_schedule_id AS fin_doubtful_debt_v_id, ps.ad_client_id, ps.ad_org_id, ps.isactive, ps.created, ps.createdby, ps.updated, ps.updatedby, inv.documentno, inv.c_bpartner_id, bp.c_bp_group_id, inv.dateinvoiced, inv.fin_paymentmethod_id, inv.c_currency_id, ps.duedate, ps.amount, ps.outstandingamt - sum(COALESCE(dd.amount, 0)) AS outstandingamt, 0 AS doubtfuldebt_amount, trunc(now()) - trunc(ps.duedate) AS daysoverdue, '' AS fin_doubtful_debt_run_id, '' AS fin_doubtful_debt_id, 'N' AS ob_selected FROM fin_payment_schedule ps JOIN c_invoice inv ON ps.c_invoice_id = inv.c_invoice_id JOIN c_bpartner bp ON inv.c_bpartner_id = bp.c_bpartner_id LEFT JOIN fin_doubtful_debt dd ON dd.fin_payment_schedule_id = ps.fin_payment_schedule_id WHERE ps.outstandingamt > 0 AND inv.issotrx = 'Y' AND dd.processed = 'Y' GROUP BY ps.fin_payment_schedule_id, ps.ad_client_id, ps.ad_org_id, ps.isactive, ps.created, ps.createdby, ps.updated, ps.updatedby, inv.documentno, inv.c_bpartner_id, bp.c_bp_group_id, inv.dateinvoiced, inv.fin_paymentmethod_id, inv.c_currency_id, ps.duedate, ps.amount, ps.outstandingamt, dd.amount, trunc(now()) - trunc(ps.duedate), dd.fin_payment_schedule_id) a, (SELECT ad_integer.value - 1 AS aux FROM ad_integer WHERE ad_integer.value <= 1000) b ORDER BY a.fin_doubtful_debt_v_id, b.aux]]></view>
+ <view name="FIN_DOUBTFUL_DEBT_V"><![CDATA[SELECT a.fin_doubtful_debt_v_id || to_char(1000 + b.aux) AS fin_doubtful_debt_v_id, a.fin_doubtful_debt_v_id AS fin_payment_schedule_id, a.ad_client_id, a.ad_org_id, a.isactive, a.created, a.createdby, a.updated, a.updatedby, a.documentno, a.c_bpartner_id, a.c_bp_group_id, a.dateinvoiced, a.fin_paymentmethod_id, a.c_currency_id, a.duedate, to_date((trunc(now()) - b.aux)) AS rundate, a.amount, a.outstandingamt, a.doubtfuldebt_amount, a.daysoverdue - b.aux AS daysoverdue, a.fin_doubtful_debt_run_id, a.fin_doubtful_debt_id, a.ob_selected FROM (SELECT ps.fin_payment_schedule_id AS fin_doubtful_debt_v_id, ps.ad_client_id, ps.ad_org_id, ps.isactive, ps.created, ps.createdby, ps.updated, ps.updatedby, inv.documentno, inv.c_bpartner_id, bp.c_bp_group_id, inv.dateinvoiced, inv.fin_paymentmethod_id, inv.c_currency_id, ps.duedate, ps.amount, ps.outstandingamt, sum(COALESCE(dd.amount, 0)) AS doubtfuldebt_amount, trunc(now()) - trunc(ps.duedate) AS daysoverdue, dd.fin_doubtful_debt_run_id, dd.fin_doubtful_debt_id, CASE WHEN dd.fin_doubtful_debt_run_id IS NULL THEN 'N' ELSE 'Y' END AS ob_selected FROM fin_payment_schedule ps JOIN c_invoice inv ON ps.c_invoice_id = inv.c_invoice_id JOIN c_bpartner bp ON inv.c_bpartner_id = bp.c_bpartner_id LEFT JOIN fin_doubtful_debt dd ON dd.fin_payment_schedule_id = ps.fin_payment_schedule_id WHERE ps.outstandingamt > 0 AND inv.issotrx = 'Y' GROUP BY ps.fin_payment_schedule_id, ps.ad_client_id, ps.ad_org_id, ps.isactive, ps.created, ps.createdby, ps.updated, ps.updatedby, inv.documentno, inv.c_bpartner_id, bp.c_bp_group_id, inv.dateinvoiced, inv.fin_paymentmethod_id, inv.c_currency_id, ps.duedate, ps.amount, ps.outstandingamt, dd.amount, (trunc(now()) - trunc(ps.duedate)), dd.fin_doubtful_debt_run_id, dd.fin_payment_schedule_id, dd.fin_doubtful_debt_id UNION SELECT ps.fin_payment_schedule_id AS fin_doubtful_debt_v_id, ps.ad_client_id, ps.ad_org_id, ps.isactive, ps.created, ps.createdby, ps.updated, ps.updatedby, inv.documentno, inv.c_bpartner_id, bp.c_bp_group_id, inv.dateinvoiced, inv.fin_paymentmethod_id, inv.c_currency_id, ps.duedate, ps.amount, ps.outstandingamt - sum(COALESCE(dd.amount, 0)) AS outstandingamt, 0 AS doubtfuldebt_amount, trunc(now()) - trunc(ps.duedate) AS daysoverdue, '' AS fin_doubtful_debt_run_id, '' AS fin_doubtful_debt_id, 'N' AS ob_selected FROM fin_payment_schedule ps JOIN c_invoice inv ON ps.c_invoice_id = inv.c_invoice_id JOIN c_bpartner bp ON inv.c_bpartner_id = bp.c_bpartner_id LEFT JOIN fin_doubtful_debt dd ON dd.fin_payment_schedule_id = ps.fin_payment_schedule_id WHERE ps.outstandingamt > 0 AND inv.issotrx = 'Y' AND dd.processed = 'Y' GROUP BY ps.fin_payment_schedule_id, ps.ad_client_id, ps.ad_org_id, ps.isactive, ps.created, ps.createdby, ps.updated, ps.updatedby, inv.documentno, inv.c_bpartner_id, bp.c_bp_group_id, inv.dateinvoiced, inv.fin_paymentmethod_id, inv.c_currency_id, ps.duedate, ps.amount, ps.outstandingamt, dd.amount, (trunc(now()) - trunc(ps.duedate)), dd.fin_payment_schedule_id) a, (SELECT ad_integer.value - 1 AS aux FROM ad_integer WHERE ad_integer.value <= 1000) b ORDER BY a.fin_doubtful_debt_v_id, b.aux]]></view>
</database>
diff -r f6885205cc8d src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml
--- a/src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml Tue Jul 21 08:02:15 2015 +0200
@@ -1,4 +1,4 @@
<?xml version="1.0"?>
<database name="VIEW MA_PROCESSPLAN_TOTALIZED">
- <view name="MA_PROCESSPLAN_TOTALIZED"><![CDATA[SELECT ma_processplan_version.ma_processplan_id, ma_processplan_version.ma_processplan_version_id, m_product.m_product_id AS produced, sp1.qty AS proqty, sp2.m_product_id AS dependantproduct, sp2.qty AS depqty FROM m_product, ma_processplan, ma_processplan_version, (SELECT ma_sequence.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) ELSE NULL END) AS qty FROM ma_sequence, ma_sequenceproduct WHERE ma_sequence.ma_sequence_id = ma_sequenceproduct.ma_sequence_id AND ma_sequence.isactive = 'Y' AND ma_sequenceproduct.isactive = 'Y' GROUP BY ma_sequence.ma_processplan_version_id, ma_sequenceproduct.m_product_id) sp1, (SELECT ma_sequence.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) ELSE NULL END) AS qty FROM ma_sequence, ma_sequenceproduct WHERE ma_sequence.ma_sequence_id = ma_sequenceproduct.ma_sequence_id AND ma_sequence.isactive = 'Y' AND ma_sequenceproduct.isactive = 'Y' GROUP BY ma_sequence.ma_processplan_version_id, ma_sequenceproduct.m_product_id) sp2 WHERE ma_processplan.ma_processplan_id = ma_processplan_version.ma_processplan_id AND m_product.ma_processplan_id = ma_processplan_version.ma_processplan_id AND ma_processplan.isactive = 'Y' AND ma_processplan_version.isactive = 'Y' AND ma_processplan_version.datefrom <= now() AND ma_processplan_version.dateto > now() AND ma_processplan_version.ma_processplan_version_id = sp1.ma_processplan_version_id AND ma_processplan_version.ma_processplan_version_id = sp2.ma_processplan_version_id AND sp1.m_product_id = m_product.m_product_id AND sp2.m_product_id <> m_product.m_product_id AND sp1.qty > 0 AND sp2.qty <> 0]]></view>
+ <view name="MA_PROCESSPLAN_TOTALIZED"><![CDATA[SELECT ma_processplan_version.ma_processplan_id, ma_processplan_version.ma_processplan_version_id, m_product.m_product_id AS produced, sp1.qty AS proqty, sp2.m_product_id AS dependantproduct, sp2.qty AS depqty FROM m_product, ma_processplan, ma_processplan_version, (SELECT ma_sequence.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' ELSE NULL END) AS qty FROM ma_sequence, ma_sequenceproduct WHERE ma_sequence.ma_sequence_id = ma_sequenceproduct.ma_sequence_id AND ma_sequence.isactive = 'Y' AND ma_sequenceproduct.isactive = 'Y' GROUP BY ma_sequence.ma_processplan_version_id, ma_sequenceproduct.m_product_id) sp1, (SELECT ma_sequence.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' ELSE NULL END) AS qty FROM ma_sequence, ma_sequenceproduct WHERE ma_sequence.ma_sequence_id = ma_sequenceproduct.ma_sequence_id AND ma_sequence.isactive = 'Y' AND ma_sequenceproduct.isactive = 'Y' GROUP BY ma_sequence.ma_processplan_version_id, ma_sequenceproduct.m_product_id) sp2 WHERE ma_processplan.ma_processplan_id = ma_processplan_version.ma_processplan_id AND m_product.ma_processplan_id = ma_processplan_version.ma_processplan_id AND ma_processplan.isactive = 'Y' AND ma_processplan_version.isactive = 'Y' AND ma_processplan_version.datefrom <= now() AND ma_processplan_version.dateto > now() AND ma_processplan_version.ma_processplan_version_id = sp1.ma_processplan_version_id AND ma_processplan_version.ma_processplan_version_id = sp2.ma_processplan_version_id AND sp1.m_product_id = m_product.m_product_id AND sp2.m_product_id <> m_product.m_product_id AND sp1.qty > 0 AND sp2.qty <> 0]]></view>
</database>
diff -r f6885205cc8d src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml
--- a/src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml Tue Jul 21 08:02:15 2015 +0200
@@ -1,4 +1,4 @@
<?xml version="1.0"?>
<database name="VIEW M_RM_RECEIPT_PICK_EDIT">
- <view name="M_RM_RECEIPT_PICK_EDIT"><![CDATA[SELECT ol.c_orderline_id AS m_rm_receipt_pick_edit_id, ol.ad_client_id, COALESCE(iol.ad_org_id, ol.ad_org_id) AS ad_org_id, ol.isactive, ol.created, ol.createdby, COALESCE(iol.updated, ol.updated) AS updated, ol.updatedby, iol.m_inout_id, CASE WHEN iol.m_inoutline_id IS NOT NULL THEN 'Y' ELSE 'N' END AS ob_selected, ol.c_orderline_id, ol.m_product_id, ol.c_uom_id, ol.m_attributesetinstance_id, (-1) * ol.qtyordered AS returned, (-1) * (ol.qtyordered - ol.qtydelivered) AS pendingqty, (-1) * iol.movementqty AS receivingqty, iol.m_condition_goods_id, iol.m_locator_id, o.documentno AS returnorderno, o.issotrx, ol.line, iol.m_inoutline_id FROM c_orderline ol JOIN c_order o ON o.c_order_id = ol.c_order_id JOIN m_product p ON ol.m_product_id = p.m_product_id JOIN c_doctype dt ON dt.c_doctype_id = o.c_doctypetarget_id AND dt.isreturn = 'Y' LEFT JOIN (SELECT il2.m_inoutline_id, il2.ad_client_id, il2.ad_org_id, il2.isactive, il2.created, il2.createdby, il2.updated, il2.updatedby, il2.line, il2.description, il2.m_inout_id, il2.c_orderline_id, il2.m_locator_id, il2.m_product_id, il2.c_uom_id, il2.movementqty, il2.isinvoiced, il2.m_attributesetinstance_id, il2.isdescription, il2.quantityorder, il2.m_product_uom_id, il2.m_condition_goods_id FROM m_inoutline il2 JOIN m_inout i2 ON il2.m_inout_id = i2.m_inout_id AND i2.processed = 'N') iol ON iol.c_orderline_id = ol.c_orderline_id WHERE (ol.qtyordered - ol.qtydelivered) <> 0 AND o.docstatus = 'CO']]></view>
+ <view name="M_RM_RECEIPT_PICK_EDIT"><![CDATA[SELECT ol.c_orderline_id AS m_rm_receipt_pick_edit_id, ol.ad_client_id, COALESCE(iol.ad_org_id, ol.ad_org_id) AS ad_org_id, ol.isactive, ol.created, ol.createdby, COALESCE(iol.updated, ol.updated) AS updated, ol.updatedby, iol.m_inout_id, CASE WHEN iol.m_inoutline_id IS NOT NULL THEN 'Y' ELSE 'N' END AS ob_selected, ol.c_orderline_id, ol.m_product_id, ol.c_uom_id, ol.m_attributesetinstance_id, '-1' * ol.qtyordered AS returned, '-1' * (ol.qtyordered - ol.qtydelivered) AS pendingqty, '-1' * iol.movementqty AS receivingqty, iol.m_condition_goods_id, iol.m_locator_id, o.documentno AS returnorderno, o.issotrx, ol.line, iol.m_inoutline_id FROM c_orderline ol JOIN c_order o ON o.c_order_id = ol.c_order_id JOIN m_product p ON ol.m_product_id = p.m_product_id JOIN c_doctype dt ON dt.c_doctype_id = o.c_doctypetarget_id AND dt.isreturn = 'Y' LEFT JOIN (SELECT il2.m_inoutline_id, il2.ad_client_id, il2.ad_org_id, il2.isactive, il2.created, il2.createdby, il2.updated, il2.updatedby, il2.line, il2.description, il2.m_inout_id, il2.c_orderline_id, il2.m_locator_id, il2.m_product_id, il2.c_uom_id, il2.movementqty, il2.isinvoiced, il2.m_attributesetinstance_id, il2.isdescription, il2.quantityorder, il2.m_product_uom_id, il2.m_condition_goods_id FROM m_inoutline il2 JOIN m_inout i2 ON il2.m_inout_id = i2.m_inout_id AND i2.processed = 'N') iol ON iol.c_orderline_id = ol.c_orderline_id WHERE (ol.qtyordered - ol.qtydelivered) <> 0 AND o.docstatus = 'CO']]></view>
</database>
diff -r f6885205cc8d src-db/database/model/views/M_RM_SHIPMENT_PICK_EDIT.xml
--- a/src-db/database/model/views/M_RM_SHIPMENT_PICK_EDIT.xml Fri Jul 17 15:04:27 2015 +0200
+++ b/src-db/database/model/views/M_RM_SHIPMENT_PICK_EDIT.xml Tue Jul 21 08:02:15 2015 +0200
@@ -1,4 +1,4 @@
<?xml version="1.0"?>
<database name="VIEW M_RM_SHIPMENT_PICK_EDIT">
- <view name="M_RM_SHIPMENT_PICK_EDIT"><![CDATA[SELECT COALESCE(sd.m_storage_detail_id, '') || ol.c_orderline_id AS m_rm_shipment_pick_edit_id, ol.ad_client_id, COALESCE(iol.ad_org_id, ol.ad_org_id) AS ad_org_id, ol.isactive, ol.createdby, ol.created, ol.updatedby, ol.updated, o.documentno AS returnorderno, ol.m_product_id, ol.m_attributesetinstance_id, ol.c_uom_id, (-1) * ol.qtyordered AS returned, (-1) * iol.movementqty AS movementqty, sd.m_locator_id, CASE WHEN sd.m_locator_id IS NULL THEN (-1) * ol.qtyordered ELSE COALESCE(sd.qtyonhand, 0) END AS availableqty, (-1) * (ol.qtyordered - to_number(COALESCE((SELECT to_char(sum(COALESCE(iol3.movementqty, 0))) AS sum FROM m_inoutline iol3 JOIN m_inout io3 ON iol3.m_inout_id = io3.m_inout_id AND io3.processed = 'Y' WHERE iol3.c_orderline_id = ol.c_orderline_id), '0'))) AS pendingqty, iol.m_inout_id, CASE WHEN iol.m_inout_id IS NOT NULL THEN 'Y' ELSE 'N' END AS ob_selected, ol.c_orderline_id, ol.line, iol.m_inoutline_id, p.isstocked FROM c_orderline ol JOIN c_order o ON o.c_order_id = ol.c_order_id AND o.processed = 'Y' AND o.issotrx = 'N' LEFT JOIN m_storage_detail sd ON sd.m_product_id = ol.m_product_id AND COALESCE(sd.m_attributesetinstance_id, '0') = COALESCE(ol.m_attributesetinstance_id, '0') AND sd.qtyonhand > 0 LEFT JOIN m_locator l ON sd.m_locator_id = l.m_locator_id JOIN m_product p ON p.m_product_id = ol.m_product_id JOIN c_doctype dt ON o.c_doctypetarget_id = dt.c_doctype_id AND dt.isreturn = 'Y' LEFT JOIN (SELECT iol2.m_inoutline_id, iol2.m_inout_id, iol2.movementqty, iol2.c_orderline_id, iol2.ad_org_id, iol2.m_locator_id FROM m_inoutline iol2 JOIN m_inout io2 ON iol2.m_inout_id = io2.m_inout_id AND io2.processed = 'N') iol ON iol.c_orderline_id = ol.c_orderline_id AND iol.m_locator_id = sd.m_locator_id WHERE o.docstatus = 'CO']]></view>
+ <view name="M_RM_SHIPMENT_PICK_EDIT"><![CDATA[SELECT COALESCE(sd.m_storage_detail_id, '') || ol.c_orderline_id AS m_rm_shipment_pick_edit_id, ol.ad_client_id, COALESCE(iol.ad_org_id, ol.ad_org_id) AS ad_org_id, ol.isactive, ol.createdby, ol.created, ol.updatedby, ol.updated, o.documentno AS returnorderno, ol.m_product_id, ol.m_attributesetinstance_id, ol.c_uom_id, '-1' * ol.qtyordered AS returned, '-1' * iol.movementqty AS movementqty, sd.m_locator_id, CASE WHEN sd.m_locator_id IS NULL THEN '-1' * ol.qtyordered ELSE COALESCE(sd.qtyonhand, 0) END AS availableqty, '-1' * (ol.qtyordered - to_number(COALESCE((SELECT to_char(sum(COALESCE(iol3.movementqty, 0))) AS sum FROM m_inoutline iol3 JOIN m_inout io3 ON iol3.m_inout_id = io3.m_inout_id AND io3.processed = 'Y' WHERE iol3.c_orderline_id = ol.c_orderline_id), '0'))) AS pendingqty, iol.m_inout_id, CASE WHEN iol.m_inout_id IS NOT NULL THEN 'Y' ELSE 'N' END AS ob_selected, ol.c_orderline_id, ol.line, iol.m_inoutline_id, p.isstocked FROM c_orderline ol JOIN c_order o ON o.c_order_id = ol.c_order_id AND o.processed = 'Y' AND o.issotrx = 'N' LEFT JOIN m_storage_detail sd ON sd.m_product_id = ol.m_product_id AND COALESCE(sd.m_attributesetinstance_id, '0') = COALESCE(ol.m_attributesetinstance_id, '0') AND sd.qtyonhand > 0 LEFT JOIN m_locator l ON sd.m_locator_id = l.m_locator_id JOIN m_product p ON p.m_product_id = ol.m_product_id JOIN c_doctype dt ON o.c_doctypetarget_id = dt.c_doctype_id AND dt.isreturn = 'Y' LEFT JOIN (SELECT iol2.m_inoutline_id, iol2.m_inout_id, iol2.movementqty, iol2.c_orderline_id, iol2.ad_org_id, iol2.m_locator_id FROM m_inoutline iol2 JOIN m_inout io2 ON iol2.m_inout_id = io2.m_inout_id AND io2.processed = 'N') iol ON iol.c_orderline_id = ol.c_orderline_id AND iol.m_locator_id = sd.m_locator_id WHERE o.docstatus = 'CO']]></view>
</database>
issue-30397.export [^] (24,458 bytes) 2015-07-22 09:34 |