details: https://code.openbravo.com/erp/devel/pi/rev/3333d134feee changeset: 14123:3333d134feee user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Wed Oct 26 20:30:56 2011 +0200 summary: Fixes view id length for oracle
details: https://code.openbravo.com/erp/devel/pi/rev/7129a47b86b5 changeset: 14124:7129a47b86b5 user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Thu Oct 27 00:07:46 2011 +0200 summary: Fixes build int-inc-oracle #3225 diffstat: modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_RECONCILIATION.xml | 4 + modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_DETAIL_V.xml | 36 ------- modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_REC_DETAIL_V.xml | 36 +++++++ modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml | 49 ++++++++- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml | 19 +++- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml | 28 +++++- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml | 6 +- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml | 2 +- src-db/database/model/tables/AD_COLUMN.xml | 2 +- src-db/database/sourcedata/AD_COLUMN.xml | 2 +- 10 files changed, 132 insertions(+), 52 deletions(-) diffs (truncated from 319 to 300 lines): diff -r 14583e731ec1 -r 7129a47b86b5 modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_RECONCILIATION.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_RECONCILIATION.xml Wed Oct 26 20:03:26 2011 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_RECONCILIATION.xml Thu Oct 27 00:07:46 2011 +0200 @@ -13,6 +13,10 @@ <default><![CDATA[N]]></default> <onCreateDefault/> </column> + <column name="EM_APRM_PROCESS_REC" primaryKey="false" required="false" type="VARCHAR" size="60" autoIncrement="false"> + <default><![CDATA[P]]></default> + <onCreateDefault/> + </column> <check name="EM_APRM_REC_PRINTDET_CHK"><![CDATA[EM_APRM_PRINTDETAILED IN ('Y', 'N')]]></check> <check name="EM_APRM_REC_PRINTSUM_CHK"><![CDATA[EM_APRM_PRINTSUMMARY IN ('Y', 'N')]]></check> </table> diff -r 14583e731ec1 -r 7129a47b86b5 modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_DETAIL_V.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_DETAIL_V.xml Wed Oct 26 20:03:26 2011 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,36 +0,0 @@ -<?xml version="1.0"?> - <database name="VIEW APRM_RECONCILIATION_DETAIL_V"> - <view name="APRM_RECONCILIATION_DETAIL_V"><![CDATA[((SELECT get_uuid() AS aprm_reconciliation_detail_v_id, to_char('APRM_Reconciled') AS type, fin_finacc_transaction.fin_reconciliation_id, COALESCE(count(*), 0) AS item_no, COALESCE(sum(fin_finacc_transaction.depositamt - fin_finacc_transaction.paymentamt), 0) AS item_amt, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive -FROM fin_finacc_transaction, fin_reconciliation -WHERE fin_finacc_transaction.fin_reconciliation_id = fin_reconciliation.fin_reconciliation_id -GROUP BY fin_finacc_transaction.fin_reconciliation_id, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive -UNION ALL -SELECT get_uuid() AS aprm_reconciliation_detail_v_id, to_char('APRM_UnReconciled') AS type, fin_reconciliation.fin_reconciliation_id, COALESCE(count(*), 0) AS item_no, COALESCE(sum(fin_bankstatementline.cramount - fin_bankstatementline.dramount), 0) AS item_amt, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive -FROM fin_bankstatementline, fin_bankstatement, fin_reconciliation -WHERE (fin_bankstatementline.fin_finacc_transaction_id IS NULL OR (EXISTS (SELECT 1 -FROM fin_finacc_transaction, fin_reconciliation rec -WHERE fin_finacc_transaction.fin_reconciliation_id = rec.fin_reconciliation_id AND fin_bankstatementline.fin_finacc_transaction_id = fin_finacc_transaction.fin_finacc_transaction_id AND fin_finacc_transaction.fin_financial_account_id = fin_bankstatement.fin_financial_account_id AND rec.created > fin_reconciliation.created))) AND fin_bankstatementline.datetrx <= fin_reconciliation.dateto AND fin_bankstatement.fin_bankstatement_id = fin_bankstatementline.fin_bankstatement_id AND fin_bankstatement.fin_financial_account_id = fin_reconciliation.fin_financial_account_id -GROUP BY fin_reconciliation.fin_reconciliation_id, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive) -UNION ALL -SELECT get_uuid() AS aprm_reconciliation_detail_v_id, to_char('APRM_OutstandingPayments') AS type, fin_reconciliation.fin_reconciliation_id, COALESCE(sum( -CASE COALESCE(fin_finacc_transaction.paymentamt, 0) -WHEN 0 THEN 0 -ELSE 1 -END), 0) AS item_no, COALESCE(sum(fin_finacc_transaction.paymentamt), 0) AS item_amt, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive -FROM fin_finacc_transaction, fin_reconciliation -WHERE (fin_finacc_transaction.fin_reconciliation_id IS NULL OR (EXISTS (SELECT 1 -FROM fin_reconciliation r -WHERE r.dateto > fin_reconciliation.dateto AND fin_finacc_transaction.fin_reconciliation_id = r.fin_reconciliation_id))) AND fin_finacc_transaction.statementdate <= fin_reconciliation.dateto AND fin_finacc_transaction.fin_financial_account_id = fin_reconciliation.fin_financial_account_id -GROUP BY fin_reconciliation.fin_reconciliation_id, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive) -UNION ALL -SELECT get_uuid() AS aprm_reconciliation_detail_v_id, to_char('APRM_OutstandingDeposits') AS type, fin_reconciliation.fin_reconciliation_id, COALESCE(sum( -CASE COALESCE(fin_finacc_transaction.depositamt, 0) -WHEN 0 THEN 0 -ELSE 1 -END), 0) AS item_no, COALESCE(sum(fin_finacc_transaction.depositamt), 0) AS item_amt, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive -FROM fin_finacc_transaction, fin_reconciliation -WHERE (fin_finacc_transaction.fin_reconciliation_id IS NULL OR (EXISTS (SELECT 1 -FROM fin_reconciliation r -WHERE r.dateto > fin_reconciliation.dateto AND fin_finacc_transaction.fin_reconciliation_id = r.fin_reconciliation_id))) AND fin_finacc_transaction.statementdate <= fin_reconciliation.dateto AND fin_finacc_transaction.fin_financial_account_id = fin_reconciliation.fin_financial_account_id -GROUP BY fin_reconciliation.fin_reconciliation_id, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive]]></view> - </database> diff -r 14583e731ec1 -r 7129a47b86b5 modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_REC_DETAIL_V.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_REC_DETAIL_V.xml Thu Oct 27 00:07:46 2011 +0200 @@ -0,0 +1,36 @@ +<?xml version="1.0"?> + <database name="VIEW APRM_REC_DETAIL_V"> + <view name="APRM_REC_DETAIL_V"><![CDATA[((SELECT get_uuid() AS aprm_rec_detail_v_id, to_char('APRM_Reconciled') AS type, fin_finacc_transaction.fin_reconciliation_id, COALESCE(count(*), 0) AS item_no, COALESCE(sum(fin_finacc_transaction.depositamt - fin_finacc_transaction.paymentamt), 0) AS item_amt, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive +FROM fin_finacc_transaction, fin_reconciliation +WHERE fin_finacc_transaction.fin_reconciliation_id = fin_reconciliation.fin_reconciliation_id +GROUP BY fin_finacc_transaction.fin_reconciliation_id, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive +UNION ALL +SELECT get_uuid() AS aprm_rec_detail_v_id, to_char('APRM_UnReconciled') AS type, fin_reconciliation.fin_reconciliation_id, COALESCE(count(*), 0) AS item_no, COALESCE(sum(fin_bankstatementline.cramount - fin_bankstatementline.dramount), 0) AS item_amt, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive +FROM fin_bankstatementline, fin_bankstatement, fin_reconciliation +WHERE (fin_bankstatementline.fin_finacc_transaction_id IS NULL OR (EXISTS (SELECT 1 +FROM fin_finacc_transaction, fin_reconciliation rec +WHERE fin_finacc_transaction.fin_reconciliation_id = rec.fin_reconciliation_id AND fin_bankstatementline.fin_finacc_transaction_id = fin_finacc_transaction.fin_finacc_transaction_id AND fin_finacc_transaction.fin_financial_account_id = fin_bankstatement.fin_financial_account_id AND rec.created > fin_reconciliation.created))) AND fin_bankstatementline.datetrx <= fin_reconciliation.dateto AND fin_bankstatement.fin_bankstatement_id = fin_bankstatementline.fin_bankstatement_id AND fin_bankstatement.fin_financial_account_id = fin_reconciliation.fin_financial_account_id +GROUP BY fin_reconciliation.fin_reconciliation_id, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive) +UNION ALL +SELECT get_uuid() AS aprm_rec_detail_v_id, to_char('APRM_OutstandingPayments') AS type, fin_reconciliation.fin_reconciliation_id, COALESCE(sum( +CASE COALESCE(fin_finacc_transaction.paymentamt, 0) +WHEN 0 THEN 0 +ELSE 1 +END), 0) AS item_no, COALESCE(sum(fin_finacc_transaction.paymentamt), 0) AS item_amt, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive +FROM fin_finacc_transaction, fin_reconciliation +WHERE (fin_finacc_transaction.fin_reconciliation_id IS NULL OR (EXISTS (SELECT 1 +FROM fin_reconciliation r +WHERE r.dateto > fin_reconciliation.dateto AND fin_finacc_transaction.fin_reconciliation_id = r.fin_reconciliation_id))) AND fin_finacc_transaction.statementdate <= fin_reconciliation.dateto AND fin_finacc_transaction.fin_financial_account_id = fin_reconciliation.fin_financial_account_id +GROUP BY fin_reconciliation.fin_reconciliation_id, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive) +UNION ALL +SELECT get_uuid() AS aprm_rec_detail_v_id, to_char('APRM_OutstandingDeposits') AS type, fin_reconciliation.fin_reconciliation_id, COALESCE(sum( +CASE COALESCE(fin_finacc_transaction.depositamt, 0) +WHEN 0 THEN 0 +ELSE 1 +END), 0) AS item_no, COALESCE(sum(fin_finacc_transaction.depositamt), 0) AS item_amt, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive +FROM fin_finacc_transaction, fin_reconciliation +WHERE (fin_finacc_transaction.fin_reconciliation_id IS NULL OR (EXISTS (SELECT 1 +FROM fin_reconciliation r +WHERE r.dateto > fin_reconciliation.dateto AND fin_finacc_transaction.fin_reconciliation_id = r.fin_reconciliation_id))) AND fin_finacc_transaction.statementdate <= fin_reconciliation.dateto AND fin_finacc_transaction.fin_financial_account_id = fin_reconciliation.fin_financial_account_id +GROUP BY fin_reconciliation.fin_reconciliation_id, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive]]></view> + </database> diff -r 14583e731ec1 -r 7129a47b86b5 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml Wed Oct 26 20:03:26 2011 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml Thu Oct 27 00:07:46 2011 +0200 @@ -1401,7 +1401,7 @@ <!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> <!--50301A7B213B468F9CFEBE289F6BA2B1--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> <!--50301A7B213B468F9CFEBE289F6BA2B1--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> -<!--50301A7B213B468F9CFEBE289F6BA2B1--> <POSITION><![CDATA[23]]></POSITION> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <POSITION><![CDATA[24]]></POSITION> <!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> <!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISAUTOSAVE><![CDATA[N]]></ISAUTOSAVE> <!--50301A7B213B468F9CFEBE289F6BA2B1--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> @@ -3513,7 +3513,7 @@ <!--8505522E56C849E1B76AD10840AB2AA8--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> <!--8505522E56C849E1B76AD10840AB2AA8--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> <!--8505522E56C849E1B76AD10840AB2AA8--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> -<!--8505522E56C849E1B76AD10840AB2AA8--> <POSITION><![CDATA[24]]></POSITION> +<!--8505522E56C849E1B76AD10840AB2AA8--> <POSITION><![CDATA[25]]></POSITION> <!--8505522E56C849E1B76AD10840AB2AA8--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> <!--8505522E56C849E1B76AD10840AB2AA8--> <ISAUTOSAVE><![CDATA[N]]></ISAUTOSAVE> <!--8505522E56C849E1B76AD10840AB2AA8--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> @@ -6242,6 +6242,43 @@ <!--B01D6A5AF6F14FD6947BDEEF22C35CF8--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> <!--B01D6A5AF6F14FD6947BDEEF22C35CF8--></AD_COLUMN> +<!--B50241F11C4F404583CACB2A88CE875F--><AD_COLUMN> +<!--B50241F11C4F404583CACB2A88CE875F--> <AD_COLUMN_ID><![CDATA[B50241F11C4F404583CACB2A88CE875F]]></AD_COLUMN_ID> +<!--B50241F11C4F404583CACB2A88CE875F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--B50241F11C4F404583CACB2A88CE875F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--B50241F11C4F404583CACB2A88CE875F--> <NAME><![CDATA[EM_Aprm_Process_Rec]]></NAME> +<!--B50241F11C4F404583CACB2A88CE875F--> <DESCRIPTION><![CDATA[Process Reconciliation Document]]></DESCRIPTION> +<!--B50241F11C4F404583CACB2A88CE875F--> <HELP><![CDATA[Used to process and reactivate reconciliation documents]]></HELP> +<!--B50241F11C4F404583CACB2A88CE875F--> <COLUMNNAME><![CDATA[EM_Aprm_Process_Rec]]></COLUMNNAME> +<!--B50241F11C4F404583CACB2A88CE875F--> <AD_TABLE_ID><![CDATA[B1B7075C46934F0A9FD4C4D0F1457B42]]></AD_TABLE_ID> +<!--B50241F11C4F404583CACB2A88CE875F--> <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID> +<!--B50241F11C4F404583CACB2A88CE875F--> <AD_REFERENCE_VALUE_ID><![CDATA[FF8080812E443491012E443C053A001A]]></AD_REFERENCE_VALUE_ID> +<!--B50241F11C4F404583CACB2A88CE875F--> <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH> +<!--B50241F11C4F404583CACB2A88CE875F--> <DEFAULTVALUE><![CDATA[P]]></DEFAULTVALUE> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISKEY><![CDATA[N]]></ISKEY> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--B50241F11C4F404583CACB2A88CE875F--> <SEQNO><![CDATA[270]]></SEQNO> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--B50241F11C4F404583CACB2A88CE875F--> <AD_ELEMENT_ID><![CDATA[FC780C136EFA4D98B2435A9448FA44AD]]></AD_ELEMENT_ID> +<!--B50241F11C4F404583CACB2A88CE875F--> <AD_PROCESS_ID><![CDATA[FF8080812E2F8EAE012E2F94CF470014]]></AD_PROCESS_ID> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--B50241F11C4F404583CACB2A88CE875F--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--B50241F11C4F404583CACB2A88CE875F--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> +<!--B50241F11C4F404583CACB2A88CE875F--> <POSITION><![CDATA[26]]></POSITION> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--B50241F11C4F404583CACB2A88CE875F--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--B50241F11C4F404583CACB2A88CE875F--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--B50241F11C4F404583CACB2A88CE875F--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--B50241F11C4F404583CACB2A88CE875F--></AD_COLUMN> + <!--B6030F7885494DFC9B08C1649B388D5B--><AD_COLUMN> <!--B6030F7885494DFC9B08C1649B388D5B--> <AD_COLUMN_ID><![CDATA[B6030F7885494DFC9B08C1649B388D5B]]></AD_COLUMN_ID> <!--B6030F7885494DFC9B08C1649B388D5B--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -6759,8 +6796,8 @@ <!--DD5C635F60EF4CA6BD8395F81E8466AD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> <!--DD5C635F60EF4CA6BD8395F81E8466AD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> <!--DD5C635F60EF4CA6BD8395F81E8466AD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> -<!--DD5C635F60EF4CA6BD8395F81E8466AD--> <NAME><![CDATA[Aprm_Reconciliation_Detail_V_ID]]></NAME> -<!--DD5C635F60EF4CA6BD8395F81E8466AD--> <COLUMNNAME><![CDATA[Aprm_Reconciliation_Detail_V_ID]]></COLUMNNAME> +<!--DD5C635F60EF4CA6BD8395F81E8466AD--> <NAME><![CDATA[APRM_Rec_Detail_V_ID]]></NAME> +<!--DD5C635F60EF4CA6BD8395F81E8466AD--> <COLUMNNAME><![CDATA[APRM_Rec_Detail_V_ID]]></COLUMNNAME> <!--DD5C635F60EF4CA6BD8395F81E8466AD--> <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID> <!--DD5C635F60EF4CA6BD8395F81E8466AD--> <AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID> <!--DD5C635F60EF4CA6BD8395F81E8466AD--> <FIELDLENGTH><![CDATA[-5]]></FIELDLENGTH> @@ -6999,7 +7036,7 @@ <!--F362B84F4718449EAD840F1C25667B37--> <HELP><![CDATA[Used to process and reactivate reconciliation documents]]></HELP> <!--F362B84F4718449EAD840F1C25667B37--> <COLUMNNAME><![CDATA[EM_APRM_Process_Reconciliation]]></COLUMNNAME> <!--F362B84F4718449EAD840F1C25667B37--> <AD_TABLE_ID><![CDATA[B1B7075C46934F0A9FD4C4D0F1457B42]]></AD_TABLE_ID> -<!--F362B84F4718449EAD840F1C25667B37--> <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID> +<!--F362B84F4718449EAD840F1C25667B37--> <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID> <!--F362B84F4718449EAD840F1C25667B37--> <AD_REFERENCE_VALUE_ID><![CDATA[FF8080812E443491012E443C053A001A]]></AD_REFERENCE_VALUE_ID> <!--F362B84F4718449EAD840F1C25667B37--> <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH> <!--F362B84F4718449EAD840F1C25667B37--> <DEFAULTVALUE><![CDATA[P]]></DEFAULTVALUE> @@ -7019,7 +7056,7 @@ <!--F362B84F4718449EAD840F1C25667B37--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> <!--F362B84F4718449EAD840F1C25667B37--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> <!--F362B84F4718449EAD840F1C25667B37--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> -<!--F362B84F4718449EAD840F1C25667B37--> <POSITION><![CDATA[22]]></POSITION> +<!--F362B84F4718449EAD840F1C25667B37--> <POSITION><![CDATA[23]]></POSITION> <!--F362B84F4718449EAD840F1C25667B37--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> <!--F362B84F4718449EAD840F1C25667B37--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> <!--F362B84F4718449EAD840F1C25667B37--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> diff -r 14583e731ec1 -r 7129a47b86b5 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml Wed Oct 26 20:03:26 2011 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml Thu Oct 27 00:07:46 2011 +0200 @@ -27,9 +27,9 @@ <!--4AC57284C5C745EB9087C105222EDF02--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> <!--4AC57284C5C745EB9087C105222EDF02--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> <!--4AC57284C5C745EB9087C105222EDF02--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> -<!--4AC57284C5C745EB9087C105222EDF02--> <COLUMNNAME><![CDATA[Aprm_Reconciliation_Detail_V_ID]]></COLUMNNAME> -<!--4AC57284C5C745EB9087C105222EDF02--> <NAME><![CDATA[Aprm_Reconciliation_Detail_V_ID]]></NAME> -<!--4AC57284C5C745EB9087C105222EDF02--> <PRINTNAME><![CDATA[Aprm_Reconciliation_Detail_V_ID]]></PRINTNAME> +<!--4AC57284C5C745EB9087C105222EDF02--> <COLUMNNAME><![CDATA[APRM_Rec_Detail_V_ID]]></COLUMNNAME> +<!--4AC57284C5C745EB9087C105222EDF02--> <NAME><![CDATA[APRM_Rec_Detail_V_ID]]></NAME> +<!--4AC57284C5C745EB9087C105222EDF02--> <PRINTNAME><![CDATA[APRM_Rec_Detail_V_ID]]></PRINTNAME> <!--4AC57284C5C745EB9087C105222EDF02--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> <!--4AC57284C5C745EB9087C105222EDF02--></AD_ELEMENT> @@ -448,4 +448,17 @@ <!--DB85AA94D6DF4D7CB29CE7999B15F9C7--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> <!--DB85AA94D6DF4D7CB29CE7999B15F9C7--></AD_ELEMENT> +<!--FC780C136EFA4D98B2435A9448FA44AD--><AD_ELEMENT> +<!--FC780C136EFA4D98B2435A9448FA44AD--> <AD_ELEMENT_ID><![CDATA[FC780C136EFA4D98B2435A9448FA44AD]]></AD_ELEMENT_ID> +<!--FC780C136EFA4D98B2435A9448FA44AD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--FC780C136EFA4D98B2435A9448FA44AD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--FC780C136EFA4D98B2435A9448FA44AD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--FC780C136EFA4D98B2435A9448FA44AD--> <COLUMNNAME><![CDATA[EM_Aprm_Process_Rec]]></COLUMNNAME> +<!--FC780C136EFA4D98B2435A9448FA44AD--> <NAME><![CDATA[Process_Reconciliation]]></NAME> +<!--FC780C136EFA4D98B2435A9448FA44AD--> <PRINTNAME><![CDATA[Process Reconciliation]]></PRINTNAME> +<!--FC780C136EFA4D98B2435A9448FA44AD--> <DESCRIPTION><![CDATA[Process Reconciliation Document]]></DESCRIPTION> +<!--FC780C136EFA4D98B2435A9448FA44AD--> <HELP><![CDATA[Used to process and reactivate reconciliation documents]]></HELP> +<!--FC780C136EFA4D98B2435A9448FA44AD--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> +<!--FC780C136EFA4D98B2435A9448FA44AD--></AD_ELEMENT> + </data> diff -r 14583e731ec1 -r 7129a47b86b5 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml Wed Oct 26 20:03:26 2011 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml Thu Oct 27 00:07:46 2011 +0200 @@ -2349,7 +2349,7 @@ <!--5422F2DED3234598A429221281F8B61D--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> <!--5422F2DED3234598A429221281F8B61D--> <AD_TAB_ID><![CDATA[FF8080813320657F0133209DE21B0042]]></AD_TAB_ID> <!--5422F2DED3234598A429221281F8B61D--> <AD_COLUMN_ID><![CDATA[F362B84F4718449EAD840F1C25667B37]]></AD_COLUMN_ID> -<!--5422F2DED3234598A429221281F8B61D--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> +<!--5422F2DED3234598A429221281F8B61D--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--5422F2DED3234598A429221281F8B61D--> <DISPLAYLOGIC><![CDATA[@Processed@='Y']]></DISPLAYLOGIC> <!--5422F2DED3234598A429221281F8B61D--> <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH> <!--5422F2DED3234598A429221281F8B61D--> <ISREADONLY><![CDATA[N]]></ISREADONLY> @@ -9199,6 +9199,32 @@ <!--C2323D9D1E62481B879289D373E65E96--> <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR> <!--C2323D9D1E62481B879289D373E65E96--></AD_FIELD> +<!--C2639FEBB29C4CB4A363DE376E294FD6--><AD_FIELD> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <AD_FIELD_ID><![CDATA[C2639FEBB29C4CB4A363DE376E294FD6]]></AD_FIELD_ID> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <NAME><![CDATA[Reconcile]]></NAME> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <DESCRIPTION><![CDATA[Manages processing of reconciliation documents]]></DESCRIPTION> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <AD_TAB_ID><![CDATA[FF8080813320657F0133209DE21B0042]]></AD_TAB_ID> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <AD_COLUMN_ID><![CDATA[B50241F11C4F404583CACB2A88CE875F]]></AD_COLUMN_ID> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <DISPLAYLOGIC><![CDATA[@Processed@='Y']]></DISPLAYLOGIC> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <SEQNO><![CDATA[180]]></SEQNO> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE> +<!--C2639FEBB29C4CB4A363DE376E294FD6--> <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR> +<!--C2639FEBB29C4CB4A363DE376E294FD6--></AD_FIELD> + <!--C732681993E641238FE56E1BCD304344--><AD_FIELD> <!--C732681993E641238FE56E1BCD304344--> <AD_FIELD_ID><![CDATA[C732681993E641238FE56E1BCD304344]]></AD_FIELD_ID> <!--C732681993E641238FE56E1BCD304344--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r 14583e731ec1 -r 7129a47b86b5 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml Wed Oct 26 20:03:26 2011 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml Thu Oct 27 00:07:46 2011 +0200 @@ -114,9 +114,9 @@ <!--FF808081331848750133184B38D20009--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> <!--FF808081331848750133184B38D20009--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> <!--FF808081331848750133184B38D20009--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> -<!--FF808081331848750133184B38D20009--> <NAME><![CDATA[aprm_reconciliation_detail_v]]></NAME> -<!--FF808081331848750133184B38D20009--> <TABLENAME><![CDATA[aprm_reconciliation_detail_v]]></TABLENAME> -<!--FF808081331848750133184B38D20009--> <CLASSNAME><![CDATA[aprm_reconciliation_detail_v]]></CLASSNAME> +<!--FF808081331848750133184B38D20009--> <NAME><![CDATA[APRM_Rec_Detail_v]]></NAME> +<!--FF808081331848750133184B38D20009--> <TABLENAME><![CDATA[APRM_Rec_Detail_v]]></TABLENAME> +<!--FF808081331848750133184B38D20009--> <CLASSNAME><![CDATA[ReconciliationDetail]]></CLASSNAME> <!--FF808081331848750133184B38D20009--> <ISVIEW><![CDATA[Y]]></ISVIEW> <!--FF808081331848750133184B38D20009--> <ACCESSLEVEL><![CDATA[1]]></ACCESSLEVEL> <!--FF808081331848750133184B38D20009--> <ISSECURITYENABLED><![CDATA[N]]></ISSECURITYENABLED> diff -r 14583e731ec1 -r 7129a47b86b5 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml Wed Oct 26 20:03:26 2011 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml Thu Oct 27 00:07:46 2011 +0200 @@ -8,7 +8,7 @@ <!--FF80808133186ADD01331B3B733B0011--> <OBKMO_WIDGET_CLASS_ID><![CDATA[FF80808133186ADD01331B3A932C000D]]></OBKMO_WIDGET_CLASS_ID> <!--FF80808133186ADD01331B3B733B0011--> <HQL><![CDATA[select m.messageText as regType, a.reconciledItems as itemNo , a.reconciledItemsAmount as itemAmt -from aprm_reconciliation_detail_v as a, ADMessageTrl as m +from APRM_Rec_Detail_v as a, ADMessageTrl as m where a.type = m.message.searchKey and a.reconciliation.id = :reconciliationId and m.language.language = :language]]></HQL> <!--FF80808133186ADD01331B3B733B0011--></OBCQL_WIDGET_QUERY> diff -r 14583e731ec1 -r 7129a47b86b5 src-db/database/model/tables/AD_COLUMN.xml --- a/src-db/database/model/tables/AD_COLUMN.xml Wed Oct 26 20:03:26 2011 +0200 +++ b/src-db/database/model/tables/AD_COLUMN.xml Thu Oct 27 00:07:46 2011 +0200 @@ -186,7 +186,7 @@ <onCreateDefault><![CDATA['N']]></onCreateDefault> ------------------------------------------------------------------------------ The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
