details: https://code.openbravo.com/erp/devel/pi/rev/21ad60710ca2 changeset: 14114:21ad60710ca2 user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Thu Oct 20 11:55:28 2011 +0200 summary: Widget step
details: https://code.openbravo.com/erp/devel/pi/rev/0d807044fd8a changeset: 14115:0d807044fd8a user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Mon Oct 24 14:30:22 2011 +0200 summary: Widget in reconciliation 2 details: https://code.openbravo.com/erp/devel/pi/rev/a922c7c6bc76 changeset: 14116:a922c7c6bc76 user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Tue Oct 25 11:06:38 2011 +0200 summary: Sets processed as session value for tab reconciliations details: https://code.openbravo.com/erp/devel/pi/rev/7315538f9e8e changeset: 14117:7315538f9e8e user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Wed Oct 26 10:04:40 2011 +0200 summary: Creates new columns for reconciliation printing details: https://code.openbravo.com/erp/devel/pi/rev/ed0daf830e65 changeset: 14118:ed0daf830e65 user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Wed Oct 26 13:24:47 2011 +0200 summary: Modifies widget element details: https://code.openbravo.com/erp/devel/pi/rev/db40450e36d0 changeset: 14119:db40450e36d0 user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Wed Oct 26 18:48:56 2011 +0200 summary: Fixes bug 18165: Project Praxis - Reconciliation tab in financial account doesn't work diffstat: modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_RECONCILIATION.xml | 10 + 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_RECONCILIATION_V.xml | 4 +- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml | 483 +++++++++- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml | 59 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml | 519 ++++++++++ modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MESSAGE.xml | 44 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS_PARA.xml | 2 +- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml | 12 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml | 27 +- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml | 20 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_VAL_RULE.xml | 11 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml | 51 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml | 15 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml | 18 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBKMO_WIDGET_REFERENCE.xml | 12 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml | 83 + modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_reports/ReportReconciliation.java | 11 +- modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_ReconciliationProcess.java | 7 +- src-db/database/model/tables/FIN_RECONCILIATION.xml | 4 + src-db/database/sourcedata/AD_COLUMN.xml | 73 +- src-db/database/sourcedata/AD_ELEMENT.xml | 13 + src-db/database/sourcedata/AD_FIELD.xml | 28 + 23 files changed, 1513 insertions(+), 29 deletions(-) diffs (truncated from 2123 to 300 lines): diff -r c51ad47f9b16 -r db40450e36d0 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 18:29:31 2011 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_RECONCILIATION.xml Wed Oct 26 18:48:56 2011 +0200 @@ -5,5 +5,15 @@ <default><![CDATA[P]]></default> <onCreateDefault/> </column> + <column name="EM_APRM_PRINTDETAILED" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false"> + <default><![CDATA[N]]></default> + <onCreateDefault/> + </column> + <column name="EM_APRM_PRINTSUMMARY" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false"> + <default><![CDATA[N]]></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> </database> diff -r c51ad47f9b16 -r db40450e36d0 modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_DETAIL_V.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_DETAIL_V.xml Wed Oct 26 18:48:56 2011 +0200 @@ -0,0 +1,36 @@ +<?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 c51ad47f9b16 -r db40450e36d0 modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml Wed Oct 26 18:29:31 2011 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml Wed Oct 26 18:48:56 2011 +0200 @@ -23,8 +23,8 @@ ELSE 1 END), 0) AS deposit_no, COALESCE(sum(fin_finacc_transaction.depositamt), 0) AS deposit_amt FROM fin_finacc_transaction, fin_reconciliation -WHERE (fin_finacc_transaction.fin_reconciliation_id IS NULL OR (fin_finacc_transaction.fin_reconciliation_id IN (SELECT r.fin_reconciliation_id +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.statementdate <= fin_reconciliation.dateto AND fin_finacc_transaction.fin_financial_account_id = fin_reconciliation.fin_financial_account_id +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) outstanding ON fin_reconciliation.fin_reconciliation_id = outstanding.fin_reconciliation_id]]></view> </database> diff -r c51ad47f9b16 -r db40450e36d0 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 18:29:31 2011 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml Wed Oct 26 18:48:56 2011 +0200 @@ -104,6 +104,42 @@ <!--09A1C598D8134CAC92CB30E476A213B0--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> <!--09A1C598D8134CAC92CB30E476A213B0--></AD_COLUMN> +<!--09A973768AD449FCBDB2B78580BAE637--><AD_COLUMN> +<!--09A973768AD449FCBDB2B78580BAE637--> <AD_COLUMN_ID><![CDATA[09A973768AD449FCBDB2B78580BAE637]]></AD_COLUMN_ID> +<!--09A973768AD449FCBDB2B78580BAE637--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--09A973768AD449FCBDB2B78580BAE637--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--09A973768AD449FCBDB2B78580BAE637--> <NAME><![CDATA[Active]]></NAME> +<!--09A973768AD449FCBDB2B78580BAE637--> <DESCRIPTION><![CDATA[A flag indicating whether this record is available for use or de-activated.]]></DESCRIPTION> +<!--09A973768AD449FCBDB2B78580BAE637--> <HELP><![CDATA[There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records: +(1) The system requires the record for auditing purposes. +(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.]]></HELP> +<!--09A973768AD449FCBDB2B78580BAE637--> <COLUMNNAME><![CDATA[Isactive]]></COLUMNNAME> +<!--09A973768AD449FCBDB2B78580BAE637--> <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID> +<!--09A973768AD449FCBDB2B78580BAE637--> <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID> +<!--09A973768AD449FCBDB2B78580BAE637--> <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISKEY><![CDATA[N]]></ISKEY> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--09A973768AD449FCBDB2B78580BAE637--> <SEQNO><![CDATA[140]]></SEQNO> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--09A973768AD449FCBDB2B78580BAE637--> <AD_ELEMENT_ID><![CDATA[348]]></AD_ELEMENT_ID> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--09A973768AD449FCBDB2B78580BAE637--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--09A973768AD449FCBDB2B78580BAE637--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> +<!--09A973768AD449FCBDB2B78580BAE637--> <POSITION><![CDATA[12]]></POSITION> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--09A973768AD449FCBDB2B78580BAE637--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--09A973768AD449FCBDB2B78580BAE637--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--09A973768AD449FCBDB2B78580BAE637--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--09A973768AD449FCBDB2B78580BAE637--></AD_COLUMN> + <!--0CE41B7829C54AF3B7193B1FA52B3C62--><AD_COLUMN> <!--0CE41B7829C54AF3B7193B1FA52B3C62--> <AD_COLUMN_ID><![CDATA[0CE41B7829C54AF3B7193B1FA52B3C62]]></AD_COLUMN_ID> <!--0CE41B7829C54AF3B7193B1FA52B3C62--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -243,6 +279,40 @@ <!--137DEB7F4BAF46A783F86044A1817D66--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> <!--137DEB7F4BAF46A783F86044A1817D66--></AD_COLUMN> +<!--1485BE46BB7E48D78834C85C8E970D00--><AD_COLUMN> +<!--1485BE46BB7E48D78834C85C8E970D00--> <AD_COLUMN_ID><![CDATA[1485BE46BB7E48D78834C85C8E970D00]]></AD_COLUMN_ID> +<!--1485BE46BB7E48D78834C85C8E970D00--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--1485BE46BB7E48D78834C85C8E970D00--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--1485BE46BB7E48D78834C85C8E970D00--> <NAME><![CDATA[Type]]></NAME> +<!--1485BE46BB7E48D78834C85C8E970D00--> <DESCRIPTION><![CDATA[A distinct item characteristic used for processes and sometimes grouped within a category.]]></DESCRIPTION> +<!--1485BE46BB7E48D78834C85C8E970D00--> <HELP><![CDATA[The Type indicates the type of validation that will occur. This can be SQL, Java Script or Java Language.]]></HELP> +<!--1485BE46BB7E48D78834C85C8E970D00--> <COLUMNNAME><![CDATA[Type]]></COLUMNNAME> +<!--1485BE46BB7E48D78834C85C8E970D00--> <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID> +<!--1485BE46BB7E48D78834C85C8E970D00--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--1485BE46BB7E48D78834C85C8E970D00--> <FIELDLENGTH><![CDATA[-5]]></FIELDLENGTH> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISKEY><![CDATA[N]]></ISKEY> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER> +<!--1485BE46BB7E48D78834C85C8E970D00--> <SEQNO><![CDATA[170]]></SEQNO> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--1485BE46BB7E48D78834C85C8E970D00--> <AD_ELEMENT_ID><![CDATA[600]]></AD_ELEMENT_ID> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--1485BE46BB7E48D78834C85C8E970D00--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--1485BE46BB7E48D78834C85C8E970D00--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> +<!--1485BE46BB7E48D78834C85C8E970D00--> <POSITION><![CDATA[2]]></POSITION> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--1485BE46BB7E48D78834C85C8E970D00--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--1485BE46BB7E48D78834C85C8E970D00--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--1485BE46BB7E48D78834C85C8E970D00--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--1485BE46BB7E48D78834C85C8E970D00--></AD_COLUMN> + <!--1678A44C2B7543DD8393C8E4E32D6F3E--><AD_COLUMN> <!--1678A44C2B7543DD8393C8E4E32D6F3E--> <AD_COLUMN_ID><![CDATA[1678A44C2B7543DD8393C8E4E32D6F3E]]></AD_COLUMN_ID> <!--1678A44C2B7543DD8393C8E4E32D6F3E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1028,6 +1098,40 @@ <!--3F41C500ECEB40D09089FEA4C3793F29--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> <!--3F41C500ECEB40D09089FEA4C3793F29--></AD_COLUMN> +<!--406EE714C6B645909609BA820A112F2C--><AD_COLUMN> +<!--406EE714C6B645909609BA820A112F2C--> <AD_COLUMN_ID><![CDATA[406EE714C6B645909609BA820A112F2C]]></AD_COLUMN_ID> +<!--406EE714C6B645909609BA820A112F2C--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--406EE714C6B645909609BA820A112F2C--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--406EE714C6B645909609BA820A112F2C--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--406EE714C6B645909609BA820A112F2C--> <NAME><![CDATA[Updated]]></NAME> +<!--406EE714C6B645909609BA820A112F2C--> <DESCRIPTION><![CDATA[x not implemented]]></DESCRIPTION> +<!--406EE714C6B645909609BA820A112F2C--> <HELP><![CDATA[The Updated field indicates the date that this record was updated.]]></HELP> +<!--406EE714C6B645909609BA820A112F2C--> <COLUMNNAME><![CDATA[Updated]]></COLUMNNAME> +<!--406EE714C6B645909609BA820A112F2C--> <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID> +<!--406EE714C6B645909609BA820A112F2C--> <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID> +<!--406EE714C6B645909609BA820A112F2C--> <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH> +<!--406EE714C6B645909609BA820A112F2C--> <ISKEY><![CDATA[N]]></ISKEY> +<!--406EE714C6B645909609BA820A112F2C--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--406EE714C6B645909609BA820A112F2C--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--406EE714C6B645909609BA820A112F2C--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> +<!--406EE714C6B645909609BA820A112F2C--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--406EE714C6B645909609BA820A112F2C--> <SEQNO><![CDATA[100]]></SEQNO> +<!--406EE714C6B645909609BA820A112F2C--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--406EE714C6B645909609BA820A112F2C--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--406EE714C6B645909609BA820A112F2C--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--406EE714C6B645909609BA820A112F2C--> <AD_ELEMENT_ID><![CDATA[607]]></AD_ELEMENT_ID> +<!--406EE714C6B645909609BA820A112F2C--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--406EE714C6B645909609BA820A112F2C--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--406EE714C6B645909609BA820A112F2C--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--406EE714C6B645909609BA820A112F2C--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--406EE714C6B645909609BA820A112F2C--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> +<!--406EE714C6B645909609BA820A112F2C--> <POSITION><![CDATA[10]]></POSITION> +<!--406EE714C6B645909609BA820A112F2C--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--406EE714C6B645909609BA820A112F2C--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--406EE714C6B645909609BA820A112F2C--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--406EE714C6B645909609BA820A112F2C--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--406EE714C6B645909609BA820A112F2C--></AD_COLUMN> + <!--40E02E5A0DCA4C7EA2CADBFA06D8EA39--><AD_COLUMN> <!--40E02E5A0DCA4C7EA2CADBFA06D8EA39--> <AD_COLUMN_ID><![CDATA[40E02E5A0DCA4C7EA2CADBFA06D8EA39]]></AD_COLUMN_ID> <!--40E02E5A0DCA4C7EA2CADBFA06D8EA39--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1131,6 +1235,40 @@ <!--437AA9021406408BA74FA0710375ECA5--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> <!--437AA9021406408BA74FA0710375ECA5--></AD_COLUMN> +<!--46B2EF2686C849CF8ACAC56810041AEB--><AD_COLUMN> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <AD_COLUMN_ID><![CDATA[46B2EF2686C849CF8ACAC56810041AEB]]></AD_COLUMN_ID> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <NAME><![CDATA[Creation Date]]></NAME> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <DESCRIPTION><![CDATA[The date that this record is completed.]]></DESCRIPTION> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <HELP><![CDATA[The Created field indicates the date that this record was created.]]></HELP> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <COLUMNNAME><![CDATA[Created]]></COLUMNNAME> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISKEY><![CDATA[N]]></ISKEY> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <SEQNO><![CDATA[80]]></SEQNO> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <AD_ELEMENT_ID><![CDATA[245]]></AD_ELEMENT_ID> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <POSITION><![CDATA[8]]></POSITION> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--46B2EF2686C849CF8ACAC56810041AEB--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--46B2EF2686C849CF8ACAC56810041AEB--></AD_COLUMN> + <!--49BEE6AEC60D4C61922B2B2DB42D7918--><AD_COLUMN> <!--49BEE6AEC60D4C61922B2B2DB42D7918--> <AD_COLUMN_ID><![CDATA[49BEE6AEC60D4C61922B2B2DB42D7918]]></AD_COLUMN_ID> <!--49BEE6AEC60D4C61922B2B2DB42D7918--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1234,6 +1372,42 @@ <!--4B98FCB4357B49DA9DB7D79FD28838AF--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> <!--4B98FCB4357B49DA9DB7D79FD28838AF--></AD_COLUMN> +<!--50301A7B213B468F9CFEBE289F6BA2B1--><AD_COLUMN> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <AD_COLUMN_ID><![CDATA[50301A7B213B468F9CFEBE289F6BA2B1]]></AD_COLUMN_ID> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <NAME><![CDATA[EM_APRM_PrintDetailed]]></NAME> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <DESCRIPTION><![CDATA[Print Detailed reconciliation report]]></DESCRIPTION> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <HELP><![CDATA[Print Detailed reconciliation report]]></HELP> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <COLUMNNAME><![CDATA[EM_APRM_PrintDetailed]]></COLUMNNAME> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <AD_TABLE_ID><![CDATA[B1B7075C46934F0A9FD4C4D0F1457B42]]></AD_TABLE_ID> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <DEFAULTVALUE><![CDATA[N]]></DEFAULTVALUE> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISKEY><![CDATA[N]]></ISKEY> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <SEQNO><![CDATA[250]]></SEQNO> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <AD_ELEMENT_ID><![CDATA[DB85AA94D6DF4D7CB29CE7999B15F9C7]]></AD_ELEMENT_ID> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <AD_PROCESS_ID><![CDATA[3C4A5FB206B74C3CA9FE20116FCA0464]]></AD_PROCESS_ID> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--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--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <ISAUTOSAVE><![CDATA[N]]></ISAUTOSAVE> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--50301A7B213B468F9CFEBE289F6BA2B1--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--50301A7B213B468F9CFEBE289F6BA2B1--></AD_COLUMN> + <!--50D9D2D098E54FB7B5109C4BAA8977A5--><AD_COLUMN> <!--50D9D2D098E54FB7B5109C4BAA8977A5--> <AD_COLUMN_ID><![CDATA[50D9D2D098E54FB7B5109C4BAA8977A5]]></AD_COLUMN_ID> <!--50D9D2D098E54FB7B5109C4BAA8977A5--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1437,6 +1611,40 @@ <!--5B278C5EA0AC4FDAB225F6A7A61FC094--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> <!--5B278C5EA0AC4FDAB225F6A7A61FC094--></AD_COLUMN> +<!--5B783EC445B04714B33004F9993EBB07--><AD_COLUMN> +<!--5B783EC445B04714B33004F9993EBB07--> <AD_COLUMN_ID><![CDATA[5B783EC445B04714B33004F9993EBB07]]></AD_COLUMN_ID> +<!--5B783EC445B04714B33004F9993EBB07--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--5B783EC445B04714B33004F9993EBB07--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--5B783EC445B04714B33004F9993EBB07--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--5B783EC445B04714B33004F9993EBB07--> <NAME><![CDATA[Reconciliation]]></NAME> +<!--5B783EC445B04714B33004F9993EBB07--> <DESCRIPTION><![CDATA[Reconciliation events related to the financial account]]></DESCRIPTION> +<!--5B783EC445B04714B33004F9993EBB07--> <HELP><![CDATA[Reconciliation events related to the financial account]]></HELP> +<!--5B783EC445B04714B33004F9993EBB07--> <COLUMNNAME><![CDATA[FIN_Reconciliation_ID]]></COLUMNNAME> +<!--5B783EC445B04714B33004F9993EBB07--> <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID> +<!--5B783EC445B04714B33004F9993EBB07--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> ------------------------------------------------------------------------------ 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
