details: https://code.openbravo.com/erp/devel/pi/rev/627fb422fbe8
changeset: 22292:627fb422fbe8
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Fri Feb 28 11:23:32 2014 +0100
summary: [Relaxing Reconciliations] New buttons to be able to edit old
documents
diffstat:
modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/UpdateReconciliationStatementProcessedValue.class
| 0
modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/UpdateReconciliationStatementProcessedValueData.class
| 0
modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_BANKSTATEMENT.xml
| 4 +
modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_FINANCIAL_ACCOUNT.xml
| 4 +
modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_RECONCILIATION.xml
| 4 +
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_BNKSTM_LINE_CHECK_TRG.xml
| 22 +
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_RECON_CHECK_TRG.xml
| 2 -
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
|
25 +
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
| 115 +++++-
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml
| 36 +
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
| 87 +++-
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MESSAGE.xml
| 24 +
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODEL_OBJECT.xml
| 36 +
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
| 10 +
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS.xml
| 63 ++
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS_PARA.xml
| 43 ++
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml
| 2 +-
modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateReconciliationStatementProcessedValue.java
| 39 +
modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateReconciliationStatementProcessedValue_data.xsql
| 54 ++
modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/src/org/openbravo/advpaymentmngt/modulescript/UpdateReconciliationStatementProcessedValueData.java
| 211 ++++++++++
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/MatchTransaction.java
| 37 +-
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/dao/MatchTransactionDao.java
| 104 ++++-
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_BankStatementProcess.java
| 104 ++++-
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_ReconciliationProcess.java
| 97 +++-
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/utility/FIN_BankStatementImport.java
| 4 +
modules/org.openbravo.client.application/web/org.openbravo.client.application/js/toolbar/ob-action-button.js
| 1 +
src-db/database/sourcedata/AD_AUXILIARINPUT.xml
| 25 +
27 files changed, 1083 insertions(+), 70 deletions(-)
diffs (truncated from 1721 to 300 lines):
diff -r 89155988f108 -r 627fb422fbe8
modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/UpdateReconciliationStatementProcessedValue.class
Binary file
modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/UpdateReconciliationStatementProcessedValue.class
has changed
diff -r 89155988f108 -r 627fb422fbe8
modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/UpdateReconciliationStatementProcessedValueData.class
Binary file
modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/UpdateReconciliationStatementProcessedValueData.class
has changed
diff -r 89155988f108 -r 627fb422fbe8
modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_BANKSTATEMENT.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_BANKSTATEMENT.xml
Thu Feb 27 20:13:13 2014 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_BANKSTATEMENT.xml
Fri Feb 28 11:23:32 2014 +0100
@@ -5,5 +5,9 @@
<default><![CDATA[P]]></default>
<onCreateDefault/>
</column>
+ <column name="EM_APRM_PROCESS_BS_FORCE" primaryKey="false"
required="false" type="VARCHAR" size="60" autoIncrement="false">
+ <default><![CDATA[P]]></default>
+ <onCreateDefault/>
+ </column>
</table>
</database>
diff -r 89155988f108 -r 627fb422fbe8
modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_FINANCIAL_ACCOUNT.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_FINANCIAL_ACCOUNT.xml
Thu Feb 27 20:13:13 2014 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_FINANCIAL_ACCOUNT.xml
Fri Feb 28 11:23:32 2014 +0100
@@ -17,5 +17,9 @@
<default/>
<onCreateDefault/>
</column>
+ <column name="EM_APRM_MATCHTRANS_FORCE" primaryKey="false"
required="false" type="CHAR" size="1" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
</table>
</database>
diff -r 89155988f108 -r 627fb422fbe8
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
Thu Feb 27 20:13:13 2014 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_RECONCILIATION.xml
Fri Feb 28 11:23:32 2014 +0100
@@ -17,6 +17,10 @@
<default><![CDATA[P]]></default>
<onCreateDefault/>
</column>
+ <column name="EM_APRM_PROCESS_REC_FORCE" 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 89155988f108 -r 627fb422fbe8
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_BNKSTM_LINE_CHECK_TRG.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_BNKSTM_LINE_CHECK_TRG.xml
Thu Feb 27 20:13:13 2014 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_BNKSTM_LINE_CHECK_TRG.xml
Fri Feb 28 11:23:32 2014 +0100
@@ -62,6 +62,28 @@
IF((DELETING OR INSERTING) AND v_Processed='Y') THEN
RAISE_APPLICATION_ERROR(-20000, '@20501@');
END IF;
+ IF(DELETING) THEN
+ IF( :OLD.FIN_FINACC_TRANSACTION_ID IS NOT NULL) THEN
+ RAISE_APPLICATION_ERROR(-20000, '@APRM_BSTLine_Matched@');
+ END IF;
+ END IF;
+ IF (UPDATING) THEN
+ IF (:OLD.FIN_FINACC_TRANSACTION_ID IS NOT NULL) THEN
+ IF(((COALESCE(:OLD.AD_ORG_ID, '0') <> COALESCE(:NEW.AD_ORG_ID, '0'))
+ OR(COALESCE(:OLD.ISACTIVE, '0') <> COALESCE(:NEW.ISACTIVE, '0'))
+ OR(COALESCE(:OLD.FIN_BANKSTATEMENT_ID, '0') <>
COALESCE(:NEW.FIN_BANKSTATEMENT_ID, '0'))
+ OR(COALESCE(:OLD.LINE, 0) <> COALESCE(:NEW.LINE, 0))
+ OR(COALESCE(:OLD.BPARTNERNAME, '0') <> COALESCE(:NEW.BPARTNERNAME, '0'))
+ OR(COALESCE(:OLD.DATETRX, v_DateNull) <> COALESCE(:NEW.DATETRX,
v_DateNull))
+ OR(COALESCE(:OLD.CRAMOUNT, 0) <> COALESCE(:NEW.CRAMOUNT, 0))
+ OR(COALESCE(:OLD.DRAMOUNT, 0) <> COALESCE(:NEW.DRAMOUNT, 0))
+ OR(COALESCE(:OLD.REFERENCENO, '0') <> COALESCE(:NEW.REFERENCENO, '0'))
+ )) THEN
+ RAISE_APPLICATION_ERROR(-20000, '@APRM_BSTLine_Matched@');
+ END IF;
+
+ END IF;
+ END IF;
END APRM_FIN_BNKSTM_LINE_CHECK_TRG
]]></body>
</trigger>
diff -r 89155988f108 -r 627fb422fbe8
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_RECON_CHECK_TRG.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_RECON_CHECK_TRG.xml
Thu Feb 27 20:13:13 2014 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_RECON_CHECK_TRG.xml
Fri Feb 28 11:23:32 2014 +0100
@@ -34,8 +34,6 @@
OR(COALESCE(:OLD.C_DOCTYPE_ID, '0') <> COALESCE(:NEW.C_DOCTYPE_ID, '0'))
OR(COALESCE(:OLD.DATETO, v_DateNull) <> COALESCE(:NEW.DATETO,
v_DateNull))
OR(COALESCE(:OLD.STATEMENTDATE, v_DateNull) <>
COALESCE(:NEW.STATEMENTDATE, v_DateNull))
- OR(COALESCE(:OLD.ENDINGBALANCE, 0) <> COALESCE(:NEW.ENDINGBALANCE, 0))
- OR(COALESCE(:OLD.STARTINGBALANCE, 0) <> COALESCE(:NEW.STARTINGBALANCE,
0))
OR(COALESCE(:OLD.DOCSTATUS, '0') <> COALESCE(:NEW.DOCSTATUS, '0')))) THEN
RAISE_APPLICATION_ERROR(-20000, '@20501@');
END IF;
diff -r 89155988f108 -r 627fb422fbe8
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
Thu Feb 27 20:13:13 2014 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
Fri Feb 28 11:23:32 2014 +0100
@@ -22,6 +22,20 @@
<!--21943DF0B89F4AE3AF14A9C06F1181C2-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
<!--21943DF0B89F4AE3AF14A9C06F1181C2--></AD_AUXILIARINPUT>
+<!--29B80A89DBA84293A75434979C655101--><AD_AUXILIARINPUT>
+<!--29B80A89DBA84293A75434979C655101-->
<AD_AUXILIARINPUT_ID><![CDATA[29B80A89DBA84293A75434979C655101]]></AD_AUXILIARINPUT_ID>
+<!--29B80A89DBA84293A75434979C655101-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--29B80A89DBA84293A75434979C655101--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--29B80A89DBA84293A75434979C655101--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--29B80A89DBA84293A75434979C655101-->
<AD_TAB_ID><![CDATA[FF8080813320657F0133209DE21B0042]]></AD_TAB_ID>
+<!--29B80A89DBA84293A75434979C655101--> <NAME><![CDATA[APRM_LASTREC]]></NAME>
+<!--29B80A89DBA84293A75434979C655101--> <CODE><![CDATA[@SQL=select
fin_reconciliation_id from fin_reconciliation where created = (
+select max(created)
+from fin_reconciliation
+where fin_financial_account_id = @FIN_Financial_Account_ID@)]]></CODE>
+<!--29B80A89DBA84293A75434979C655101-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--29B80A89DBA84293A75434979C655101--></AD_AUXILIARINPUT>
+
<!--4FA457B12B4E411FA662D4D97A53B2E1--><AD_AUXILIARINPUT>
<!--4FA457B12B4E411FA662D4D97A53B2E1-->
<AD_AUXILIARINPUT_ID><![CDATA[4FA457B12B4E411FA662D4D97A53B2E1]]></AD_AUXILIARINPUT_ID>
<!--4FA457B12B4E411FA662D4D97A53B2E1-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -44,6 +58,17 @@
<!--9D630C9E4C734361BFB09B153EEE3BCB-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
<!--9D630C9E4C734361BFB09B153EEE3BCB--></AD_AUXILIARINPUT>
+<!--B1C25B989C164EDFB7F9B26CB799DDAA--><AD_AUXILIARINPUT>
+<!--B1C25B989C164EDFB7F9B26CB799DDAA-->
<AD_AUXILIARINPUT_ID><![CDATA[B1C25B989C164EDFB7F9B26CB799DDAA]]></AD_AUXILIARINPUT_ID>
+<!--B1C25B989C164EDFB7F9B26CB799DDAA-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B1C25B989C164EDFB7F9B26CB799DDAA--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B1C25B989C164EDFB7F9B26CB799DDAA--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B1C25B989C164EDFB7F9B26CB799DDAA-->
<AD_TAB_ID><![CDATA[C56E698100314ABBBBD3A89626CA551C]]></AD_TAB_ID>
+<!--B1C25B989C164EDFB7F9B26CB799DDAA-->
<NAME><![CDATA[APRM_ISRECONCILED]]></NAME>
+<!--B1C25B989C164EDFB7F9B26CB799DDAA--> <CODE><![CDATA[@SQL=SELECT 1 FROM
DUAL WHERE EXISTS (SELECT 1 FROM FIN_BANKSTATEMENTLINE WHERE
FIN_FINACC_TRANSACTION_ID IS NOT NULL AND FIN_BANKSTATEMENT_ID =
@FIN_BankStatement_ID@) OR EXISTS (SELECT 1 FROM FIN_BANKSTATEMENTLINE,
FIN_BANKSTATEMENT WHERE DATETRX > (SELECT MAX(DATETRX) FROM
FIN_BANKSTATEMENTLINE WHERE FIN_BANKSTATEMENT_ID = @FIN_BankStatement_ID@) AND
FIN_BANKSTATEMENT.FIN_BANKSTATEMENT_ID =
FIN_BANKSTATEMENTLINE.FIN_BANKSTATEMENT_ID AND
FIN_BANKSTATEMENT.FIN_FINANCIAL_ACCOUNT_ID = @FIN_Financial_Account_ID@)
]]></CODE>
+<!--B1C25B989C164EDFB7F9B26CB799DDAA-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--B1C25B989C164EDFB7F9B26CB799DDAA--></AD_AUXILIARINPUT>
+
<!--D08EBACB459849488F49089EA28F96D9--><AD_AUXILIARINPUT>
<!--D08EBACB459849488F49089EA28F96D9-->
<AD_AUXILIARINPUT_ID><![CDATA[D08EBACB459849488F49089EA28F96D9]]></AD_AUXILIARINPUT_ID>
<!--D08EBACB459849488F49089EA28F96D9-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 89155988f108 -r 627fb422fbe8
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
Thu Feb 27 20:13:13 2014 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
Fri Feb 28 11:23:32 2014 +0100
@@ -1545,6 +1545,43 @@
<!--41DAD5FF72274650A3C41D103F20C111-->
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
<!--41DAD5FF72274650A3C41D103F20C111--></AD_COLUMN>
+<!--422F3732DA324AE2AA34AE2E44D42037--><AD_COLUMN>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<AD_COLUMN_ID><![CDATA[422F3732DA324AE2AA34AE2E44D42037]]></AD_COLUMN_ID>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--422F3732DA324AE2AA34AE2E44D42037--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--422F3732DA324AE2AA34AE2E44D42037--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<NAME><![CDATA[EM_APRM_Process_Reconciliation_Force]]></NAME>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<COLUMNNAME><![CDATA[EM_APRM_Process_Rec_Force]]></COLUMNNAME>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<AD_TABLE_ID><![CDATA[B1B7075C46934F0A9FD4C4D0F1457B42]]></AD_TABLE_ID>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<AD_REFERENCE_VALUE_ID><![CDATA[FF8080812E443491012E443C053A001A]]></AD_REFERENCE_VALUE_ID>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<AD_VAL_RULE_ID><![CDATA[FF8080812E448A62012E44943A160017]]></AD_VAL_RULE_ID>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<DEFAULTVALUE><![CDATA[P]]></DEFAULTVALUE>
+<!--422F3732DA324AE2AA34AE2E44D42037--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--422F3732DA324AE2AA34AE2E44D42037--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--422F3732DA324AE2AA34AE2E44D42037--> <SEQNO><![CDATA[280]]></SEQNO>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<AD_ELEMENT_ID><![CDATA[1C8028555014460F81C6ACC811CA74E2]]></AD_ELEMENT_ID>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<AD_PROCESS_ID><![CDATA[6BF16EFC772843AC9A17552AE0B26AB7]]></AD_PROCESS_ID>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--422F3732DA324AE2AA34AE2E44D42037--> <POSITION><![CDATA[27]]></POSITION>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--422F3732DA324AE2AA34AE2E44D42037--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--422F3732DA324AE2AA34AE2E44D42037-->
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--422F3732DA324AE2AA34AE2E44D42037--></AD_COLUMN>
+
<!--42C6FD4ECBF6451F9D570317F4472FD7--><AD_COLUMN>
<!--42C6FD4ECBF6451F9D570317F4472FD7-->
<AD_COLUMN_ID><![CDATA[42C6FD4ECBF6451F9D570317F4472FD7]]></AD_COLUMN_ID>
<!--42C6FD4ECBF6451F9D570317F4472FD7-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -2466,6 +2503,42 @@
<!--68C853FD393C4620A3947EC34C416B9A-->
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
<!--68C853FD393C4620A3947EC34C416B9A--></AD_COLUMN>
+<!--6B5C965B623748689A689838835C0AC2--><AD_COLUMN>
+<!--6B5C965B623748689A689838835C0AC2-->
<AD_COLUMN_ID><![CDATA[6B5C965B623748689A689838835C0AC2]]></AD_COLUMN_ID>
+<!--6B5C965B623748689A689838835C0AC2-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6B5C965B623748689A689838835C0AC2--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6B5C965B623748689A689838835C0AC2--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6B5C965B623748689A689838835C0AC2--> <NAME><![CDATA[EM_APRM_Process Bank
Statement Force]]></NAME>
+<!--6B5C965B623748689A689838835C0AC2-->
<COLUMNNAME><![CDATA[EM_APRM_Process_BS_Force]]></COLUMNNAME>
+<!--6B5C965B623748689A689838835C0AC2-->
<AD_TABLE_ID><![CDATA[D4C23A17190649E7B78F55A05AF3438C]]></AD_TABLE_ID>
+<!--6B5C965B623748689A689838835C0AC2-->
<AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
+<!--6B5C965B623748689A689838835C0AC2-->
<AD_REFERENCE_VALUE_ID><![CDATA[EC75B6F5A9504DB6B3F3356EA85F15EE]]></AD_REFERENCE_VALUE_ID>
+<!--6B5C965B623748689A689838835C0AC2-->
<FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--6B5C965B623748689A689838835C0AC2-->
<DEFAULTVALUE><![CDATA[P]]></DEFAULTVALUE>
+<!--6B5C965B623748689A689838835C0AC2--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--6B5C965B623748689A689838835C0AC2--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--6B5C965B623748689A689838835C0AC2-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--6B5C965B623748689A689838835C0AC2-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--6B5C965B623748689A689838835C0AC2-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--6B5C965B623748689A689838835C0AC2--> <SEQNO><![CDATA[220]]></SEQNO>
+<!--6B5C965B623748689A689838835C0AC2-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--6B5C965B623748689A689838835C0AC2-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--6B5C965B623748689A689838835C0AC2-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--6B5C965B623748689A689838835C0AC2-->
<AD_ELEMENT_ID><![CDATA[D42C1F18622F4773989190BB8C2C8436]]></AD_ELEMENT_ID>
+<!--6B5C965B623748689A689838835C0AC2-->
<AD_PROCESS_ID><![CDATA[2DDE7D3618034C38A4462B7F3456C28D]]></AD_PROCESS_ID>
+<!--6B5C965B623748689A689838835C0AC2-->
<ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
+<!--6B5C965B623748689A689838835C0AC2-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--6B5C965B623748689A689838835C0AC2-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--6B5C965B623748689A689838835C0AC2-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--6B5C965B623748689A689838835C0AC2-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--6B5C965B623748689A689838835C0AC2--> <POSITION><![CDATA[22]]></POSITION>
+<!--6B5C965B623748689A689838835C0AC2-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--6B5C965B623748689A689838835C0AC2--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--6B5C965B623748689A689838835C0AC2-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--6B5C965B623748689A689838835C0AC2-->
<IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--6B5C965B623748689A689838835C0AC2-->
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--6B5C965B623748689A689838835C0AC2--></AD_COLUMN>
+
<!--6BBCB749C7C640A08F573BF86D270171--><AD_COLUMN>
<!--6BBCB749C7C640A08F573BF86D270171-->
<AD_COLUMN_ID><![CDATA[6BBCB749C7C640A08F573BF86D270171]]></AD_COLUMN_ID>
<!--6BBCB749C7C640A08F573BF86D270171-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -5377,6 +5450,40 @@
<!--9D382AE31EFB4496B0A531A0FD72E73B-->
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
<!--9D382AE31EFB4496B0A531A0FD72E73B--></AD_COLUMN>
+<!--9DC8500B414640E09BF61A3D14FE13D1--><AD_COLUMN>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<AD_COLUMN_ID><![CDATA[9DC8500B414640E09BF61A3D14FE13D1]]></AD_COLUMN_ID>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9DC8500B414640E09BF61A3D14FE13D1--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9DC8500B414640E09BF61A3D14FE13D1--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<NAME><![CDATA[EM_APRM_MatchTransactions_Force]]></NAME>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<COLUMNNAME><![CDATA[EM_APRM_MatchTrans_Force]]></COLUMNNAME>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<AD_TABLE_ID><![CDATA[B129E53BC0E747879F7BA17F0AECEC32]]></AD_TABLE_ID>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--9DC8500B414640E09BF61A3D14FE13D1--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--9DC8500B414640E09BF61A3D14FE13D1--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9DC8500B414640E09BF61A3D14FE13D1--> <SEQNO><![CDATA[450]]></SEQNO>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<AD_ELEMENT_ID><![CDATA[F79620AE1CC041308045C23E661BD907]]></AD_ELEMENT_ID>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<AD_PROCESS_ID><![CDATA[19EEA22FCA464979B3ADAD3A967ADA52]]></AD_PROCESS_ID>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--9DC8500B414640E09BF61A3D14FE13D1--> <POSITION><![CDATA[39]]></POSITION>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9DC8500B414640E09BF61A3D14FE13D1--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--9DC8500B414640E09BF61A3D14FE13D1-->
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--9DC8500B414640E09BF61A3D14FE13D1--></AD_COLUMN>
+
<!--9DE9E45A80994A969AC623FA97A3C0E8--><AD_COLUMN>
<!--9DE9E45A80994A969AC623FA97A3C0E8-->
<AD_COLUMN_ID><![CDATA[9DE9E45A80994A969AC623FA97A3C0E8]]></AD_COLUMN_ID>
<!--9DE9E45A80994A969AC623FA97A3C0E8-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -5511,7 +5618,7 @@
<!--A028C07508878CB9E040007F01007210-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--A028C07508878CB9E040007F01007210-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--A028C07508878CB9E040007F01007210-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--A028C07508878CB9E040007F01007210--> <POSITION><![CDATA[30]]></POSITION>
+<!--A028C07508878CB9E040007F01007210--> <POSITION><![CDATA[35]]></POSITION>
<!--A028C07508878CB9E040007F01007210-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--A028C07508878CB9E040007F01007210--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--A028C07508878CB9E040007F01007210-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -5545,7 +5652,7 @@
<!--A04179EAC69DF848E040007F01004523-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--A04179EAC69DF848E040007F01004523-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--A04179EAC69DF848E040007F01004523-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--A04179EAC69DF848E040007F01004523--> <POSITION><![CDATA[31]]></POSITION>
+<!--A04179EAC69DF848E040007F01004523--> <POSITION><![CDATA[36]]></POSITION>
<!--A04179EAC69DF848E040007F01004523-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--A04179EAC69DF848E040007F01004523--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--A04179EAC69DF848E040007F01004523-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -5579,7 +5686,7 @@
<!--A04179EAC69EF848E040007F01004523-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--A04179EAC69EF848E040007F01004523-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--A04179EAC69EF848E040007F01004523-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--A04179EAC69EF848E040007F01004523--> <POSITION><![CDATA[32]]></POSITION>
+<!--A04179EAC69EF848E040007F01004523--> <POSITION><![CDATA[37]]></POSITION>
<!--A04179EAC69EF848E040007F01004523-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--A04179EAC69EF848E040007F01004523--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--A04179EAC69EF848E040007F01004523-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -5614,7 +5721,7 @@
<!--A04179EAC69FF848E040007F01004523-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--A04179EAC69FF848E040007F01004523-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--A04179EAC69FF848E040007F01004523-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--A04179EAC69FF848E040007F01004523--> <POSITION><![CDATA[33]]></POSITION>
+<!--A04179EAC69FF848E040007F01004523--> <POSITION><![CDATA[38]]></POSITION>
<!--A04179EAC69FF848E040007F01004523-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--A04179EAC69FF848E040007F01004523--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--A04179EAC69FF848E040007F01004523-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
diff -r 89155988f108 -r 627fb422fbe8
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml
Thu Feb 27 20:13:13 2014 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml
Fri Feb 28 11:23:32 2014 +0100
------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
