details: /erp/devel/pi/rev/819314bb0020
changeset: 11076:819314bb0020
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Tue Mar 08 11:16:13 2011 +0100
summary: Fix in payment accounting to always post payments with amount equal 0
details: /erp/devel/pi/rev/e512eb8da0b2
changeset: 11077:e512eb8da0b2
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Tue Mar 08 11:19:07 2011 +0100
summary: Fixes bug 0015504: Implement procedure to rollback reconciliations
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_RECONCILIATION.xml
| 9 +
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml
| 2 +-
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
| 89 +++++-
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml
| 13 +
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
| 28 +-
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MESSAGE.xml
| 22 +
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODEL_OBJECT.xml
| 12 +
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS.xml
| 19 +
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS_PARA.xml
| 22 +
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml
| 13 +
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REF_LIST.xml
| 23 +
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_VAL_RULE.xml
| 11 +
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/MatchTransaction.java
| 5 +-
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/Reconciliation.java
| 1 +
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_ReconciliationProcess.java
| 159 ++++++++++
src-db/database/sourcedata/AD_REF_LIST.xml
| 2 +-
src/org/openbravo/erpCommon/ad_forms/DocFINPayment.java
| 7 +-
17 files changed, 419 insertions(+), 18 deletions(-)
diffs (truncated from 664 to 300 lines):
diff -r e2de6f86f183 -r e512eb8da0b2
modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_RECONCILIATION.xml
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_RECONCILIATION.xml
Tue Mar 08 11:19:07 2011 +0100
@@ -0,0 +1,9 @@
+<?xml version="1.0"?>
+ <database name="MODIFIED TABLE FIN_RECONCILIATION">
+ <table name="FIN_RECONCILIATION" primaryKey="FIN_RECONCILIATION_KEY">
+ <column name="EM_APRM_PROCESS_RECONCILIATION" primaryKey="false"
required="false" type="VARCHAR" size="60" autoIncrement="false">
+ <default><![CDATA[P]]></default>
+ <onCreateDefault/>
+ </column>
+ </table>
+ </database>
diff -r e2de6f86f183 -r e512eb8da0b2
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
Tue Mar 08 10:02:24 2011 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml
Tue Mar 08 11:19:07 2011 +0100
@@ -1,6 +1,6 @@
<?xml version="1.0"?>
<database name="VIEW APRM_RECONCILIATION_V">
- <view name="APRM_RECONCILIATION_V"><![CDATA[SELECT
fin_reconciliation.fin_reconciliation_id AS aprm_reconciliation_v_id,
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,
fin_reconciliation.fin_financial_account_id, fin_reconciliation.documentno,
fin_reconciliation.c_doctype_id, fin_reconciliation.dateto,
fin_reconciliation.statementdate, fin_reconciliation.endingbalance,
fin_reconciliation.startingbalance, fin_reconciliation.docstatus,
fin_reconciliation.processing, fin_reconciliation.processed,
fin_reconciliation.posted, fin_reconciliation.printdetailed,
fin_reconciliation.printsummary, COALESCE(item.item_no, 0) AS item_no,
COALESCE(item.item_amt, 0) AS item_amt, COALESCE(unrec.unrec_no, 0) AS
unrec_no, COALESCE(unrec.unrec_amt, 0) AS unrec_amt,
COALESCE(outstanding.payment_no, 0) AS payment_no,
COALESCE(outstanding.payment_amt, 0) AS payment_amt,
COALESCE(outstanding.deposit_no, 0) AS deposit_no,
COALESCE(outstanding.deposit_amt, 0) AS deposit_amt, (SELECT
ad_table.ad_table_id
+ <view name="APRM_RECONCILIATION_V"><![CDATA[SELECT
fin_reconciliation.fin_reconciliation_id AS aprm_reconciliation_v_id,
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,
fin_reconciliation.fin_financial_account_id, fin_reconciliation.documentno,
fin_reconciliation.c_doctype_id, fin_reconciliation.dateto,
fin_reconciliation.statementdate, fin_reconciliation.endingbalance,
fin_reconciliation.startingbalance, fin_reconciliation.docstatus,
fin_reconciliation.processing, fin_reconciliation.processed,
fin_reconciliation.posted, fin_reconciliation.printdetailed,
fin_reconciliation.em_aprm_process_reconciliation,
fin_reconciliation.printsummary, COALESCE(item.item_no, 0) AS item_no,
COALESCE(item.item_amt, 0) AS item_amt, COALESCE(unrec.unrec_no, 0) AS
unrec_no, COALESCE(unrec.unrec_amt, 0) AS unrec_amt,
COALESCE(outstanding.payment_no, 0) AS payment_no,
COALESCE(outstanding.payment_amt, 0) AS payment_amt,
COALESCE(outstanding.deposit_no, 0) AS deposit_no,
COALESCE(outstanding.deposit_amt, 0) AS deposit_amt, (SELECT
ad_table.ad_table_id
FROM ad_table
WHERE lower(ad_table.tablename) = 'fin_reconciliation') AS forced_table_id
FROM fin_reconciliation
diff -r e2de6f86f183 -r e512eb8da0b2
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
Tue Mar 08 10:02:24 2011 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
Tue Mar 08 11:19:07 2011 +0100
@@ -666,6 +666,41 @@
<!--57D5BC1D263243128DCD16E2836AE3E1-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
<!--57D5BC1D263243128DCD16E2836AE3E1--></AD_COLUMN>
+<!--63454E73F07B4C908EB1268C41F5DE8A--><AD_COLUMN>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<AD_COLUMN_ID><![CDATA[63454E73F07B4C908EB1268C41F5DE8A]]></AD_COLUMN_ID>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--63454E73F07B4C908EB1268C41F5DE8A--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--63454E73F07B4C908EB1268C41F5DE8A--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--63454E73F07B4C908EB1268C41F5DE8A--> <NAME><![CDATA[Process
Reconciliation]]></NAME>
+<!--63454E73F07B4C908EB1268C41F5DE8A--> <DESCRIPTION><![CDATA[Process
Reconciliation Document]]></DESCRIPTION>
+<!--63454E73F07B4C908EB1268C41F5DE8A--> <HELP><![CDATA[Used to process and
reactivate reconciliation documents]]></HELP>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<COLUMNNAME><![CDATA[EM_APRM_Process_Reconciliation]]></COLUMNNAME>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<AD_TABLE_ID><![CDATA[0DFF5BACFB964FDABAA5042C8809C813]]></AD_TABLE_ID>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<AD_REFERENCE_VALUE_ID><![CDATA[36972531DA994BB38ECB91993058282F]]></AD_REFERENCE_VALUE_ID>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--63454E73F07B4C908EB1268C41F5DE8A--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--63454E73F07B4C908EB1268C41F5DE8A--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--63454E73F07B4C908EB1268C41F5DE8A--> <SEQNO><![CDATA[350]]></SEQNO>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<AD_ELEMENT_ID><![CDATA[C8E8009C6BF5427EA930515F217F768E]]></AD_ELEMENT_ID>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<AD_PROCESS_ID><![CDATA[FF8080812E2F8EAE012E2F94CF470014]]></AD_PROCESS_ID>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--63454E73F07B4C908EB1268C41F5DE8A--> <POSITION><![CDATA[23]]></POSITION>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--63454E73F07B4C908EB1268C41F5DE8A--> <ISAUTOSAVE><![CDATA[N]]></ISAUTOSAVE>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--63454E73F07B4C908EB1268C41F5DE8A--></AD_COLUMN>
+
<!--68C853FD393C4620A3947EC34C416B9A--><AD_COLUMN>
<!--68C853FD393C4620A3947EC34C416B9A-->
<AD_COLUMN_ID><![CDATA[68C853FD393C4620A3947EC34C416B9A]]></AD_COLUMN_ID>
<!--68C853FD393C4620A3947EC34C416B9A-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -1762,7 +1797,7 @@
<!--82EFB8E4045319C9E040007F01003778-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--82EFB8E4045319C9E040007F01003778-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--82EFB8E4045319C9E040007F01003778-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--82EFB8E4045319C9E040007F01003778--> <POSITION><![CDATA[23]]></POSITION>
+<!--82EFB8E4045319C9E040007F01003778--> <POSITION><![CDATA[24]]></POSITION>
<!--82EFB8E4045319C9E040007F01003778-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--82EFB8E4045319C9E040007F01003778--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--82EFB8E4045319C9E040007F01003778-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -1793,7 +1828,7 @@
<!--82EFB8E4045419C9E040007F01003778-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--82EFB8E4045419C9E040007F01003778-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--82EFB8E4045419C9E040007F01003778-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--82EFB8E4045419C9E040007F01003778--> <POSITION><![CDATA[24]]></POSITION>
+<!--82EFB8E4045419C9E040007F01003778--> <POSITION><![CDATA[25]]></POSITION>
<!--82EFB8E4045419C9E040007F01003778-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--82EFB8E4045419C9E040007F01003778--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--82EFB8E4045419C9E040007F01003778-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -1824,7 +1859,7 @@
<!--82EFB8E4045519C9E040007F01003778-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--82EFB8E4045519C9E040007F01003778-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--82EFB8E4045519C9E040007F01003778-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--82EFB8E4045519C9E040007F01003778--> <POSITION><![CDATA[25]]></POSITION>
+<!--82EFB8E4045519C9E040007F01003778--> <POSITION><![CDATA[26]]></POSITION>
<!--82EFB8E4045519C9E040007F01003778-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--82EFB8E4045519C9E040007F01003778--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--82EFB8E4045519C9E040007F01003778-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -1855,7 +1890,7 @@
<!--82EFB8E4045619C9E040007F01003778-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--82EFB8E4045619C9E040007F01003778-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--82EFB8E4045619C9E040007F01003778-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--82EFB8E4045619C9E040007F01003778--> <POSITION><![CDATA[26]]></POSITION>
+<!--82EFB8E4045619C9E040007F01003778--> <POSITION><![CDATA[27]]></POSITION>
<!--82EFB8E4045619C9E040007F01003778-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--82EFB8E4045619C9E040007F01003778--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--82EFB8E4045619C9E040007F01003778-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -1886,7 +1921,7 @@
<!--82EFB8E4045719C9E040007F01003778-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--82EFB8E4045719C9E040007F01003778-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--82EFB8E4045719C9E040007F01003778-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--82EFB8E4045719C9E040007F01003778--> <POSITION><![CDATA[27]]></POSITION>
+<!--82EFB8E4045719C9E040007F01003778--> <POSITION><![CDATA[28]]></POSITION>
<!--82EFB8E4045719C9E040007F01003778-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--82EFB8E4045719C9E040007F01003778--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--82EFB8E4045719C9E040007F01003778-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -1917,7 +1952,7 @@
<!--82EFB8E4045819C9E040007F01003778-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--82EFB8E4045819C9E040007F01003778-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--82EFB8E4045819C9E040007F01003778-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--82EFB8E4045819C9E040007F01003778--> <POSITION><![CDATA[28]]></POSITION>
+<!--82EFB8E4045819C9E040007F01003778--> <POSITION><![CDATA[29]]></POSITION>
<!--82EFB8E4045819C9E040007F01003778-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--82EFB8E4045819C9E040007F01003778--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--82EFB8E4045819C9E040007F01003778-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -1948,7 +1983,7 @@
<!--82EFB8E4045919C9E040007F01003778-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--82EFB8E4045919C9E040007F01003778-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--82EFB8E4045919C9E040007F01003778-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--82EFB8E4045919C9E040007F01003778--> <POSITION><![CDATA[29]]></POSITION>
+<!--82EFB8E4045919C9E040007F01003778--> <POSITION><![CDATA[30]]></POSITION>
<!--82EFB8E4045919C9E040007F01003778-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--82EFB8E4045919C9E040007F01003778--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--82EFB8E4045919C9E040007F01003778-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -1979,7 +2014,7 @@
<!--82EFB8E4045A19C9E040007F01003778-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--82EFB8E4045A19C9E040007F01003778-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--82EFB8E4045A19C9E040007F01003778-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--82EFB8E4045A19C9E040007F01003778--> <POSITION><![CDATA[30]]></POSITION>
+<!--82EFB8E4045A19C9E040007F01003778--> <POSITION><![CDATA[31]]></POSITION>
<!--82EFB8E4045A19C9E040007F01003778-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--82EFB8E4045A19C9E040007F01003778--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--82EFB8E4045A19C9E040007F01003778-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -2046,7 +2081,7 @@
<!--8448D679EF655513E040007F01001B17-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--8448D679EF655513E040007F01001B17-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--8448D679EF655513E040007F01001B17-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
-<!--8448D679EF655513E040007F01001B17--> <POSITION><![CDATA[31]]></POSITION>
+<!--8448D679EF655513E040007F01001B17--> <POSITION><![CDATA[32]]></POSITION>
<!--8448D679EF655513E040007F01001B17-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--8448D679EF655513E040007F01001B17--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--8448D679EF655513E040007F01001B17-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -3179,6 +3214,42 @@
<!--F30A5F00B30D407B8C05119E8B91A275-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
<!--F30A5F00B30D407B8C05119E8B91A275--></AD_COLUMN>
+<!--F362B84F4718449EAD840F1C25667B37--><AD_COLUMN>
+<!--F362B84F4718449EAD840F1C25667B37-->
<AD_COLUMN_ID><![CDATA[F362B84F4718449EAD840F1C25667B37]]></AD_COLUMN_ID>
+<!--F362B84F4718449EAD840F1C25667B37-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F362B84F4718449EAD840F1C25667B37--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F362B84F4718449EAD840F1C25667B37--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F362B84F4718449EAD840F1C25667B37-->
<NAME><![CDATA[EM_APRM_Process_Reconciliation]]></NAME>
+<!--F362B84F4718449EAD840F1C25667B37--> <DESCRIPTION><![CDATA[Process
Reconciliation Document]]></DESCRIPTION>
+<!--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_VALUE_ID><![CDATA[FF8080812E443491012E443C053A001A]]></AD_REFERENCE_VALUE_ID>
+<!--F362B84F4718449EAD840F1C25667B37-->
<FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--F362B84F4718449EAD840F1C25667B37-->
<DEFAULTVALUE><![CDATA[P]]></DEFAULTVALUE>
+<!--F362B84F4718449EAD840F1C25667B37--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--F362B84F4718449EAD840F1C25667B37--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--F362B84F4718449EAD840F1C25667B37-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--F362B84F4718449EAD840F1C25667B37-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--F362B84F4718449EAD840F1C25667B37-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--F362B84F4718449EAD840F1C25667B37--> <SEQNO><![CDATA[240]]></SEQNO>
+<!--F362B84F4718449EAD840F1C25667B37-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--F362B84F4718449EAD840F1C25667B37-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--F362B84F4718449EAD840F1C25667B37-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--F362B84F4718449EAD840F1C25667B37-->
<AD_ELEMENT_ID><![CDATA[C8E8009C6BF5427EA930515F217F768E]]></AD_ELEMENT_ID>
+<!--F362B84F4718449EAD840F1C25667B37-->
<AD_PROCESS_ID><![CDATA[FF8080812E2F8EAE012E2F94CF470014]]></AD_PROCESS_ID>
+<!--F362B84F4718449EAD840F1C25667B37-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--F362B84F4718449EAD840F1C25667B37-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--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-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--F362B84F4718449EAD840F1C25667B37--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--F362B84F4718449EAD840F1C25667B37-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--F362B84F4718449EAD840F1C25667B37--></AD_COLUMN>
+
<!--F79D0173541B42CD9F41A58D53929BFA--><AD_COLUMN>
<!--F79D0173541B42CD9F41A58D53929BFA-->
<AD_COLUMN_ID><![CDATA[F79D0173541B42CD9F41A58D53929BFA]]></AD_COLUMN_ID>
<!--F79D0173541B42CD9F41A58D53929BFA-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r e2de6f86f183 -r e512eb8da0b2
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml
Tue Mar 08 10:02:24 2011 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml
Tue Mar 08 11:19:07 2011 +0100
@@ -225,4 +225,17 @@
<!--8BBA8342ED3C20FFE040007F01002E9B-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
<!--8BBA8342ED3C20FFE040007F01002E9B--></AD_ELEMENT>
+<!--C8E8009C6BF5427EA930515F217F768E--><AD_ELEMENT>
+<!--C8E8009C6BF5427EA930515F217F768E-->
<AD_ELEMENT_ID><![CDATA[C8E8009C6BF5427EA930515F217F768E]]></AD_ELEMENT_ID>
+<!--C8E8009C6BF5427EA930515F217F768E-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C8E8009C6BF5427EA930515F217F768E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C8E8009C6BF5427EA930515F217F768E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C8E8009C6BF5427EA930515F217F768E-->
<COLUMNNAME><![CDATA[EM_APRM_Process_Reconciliation]]></COLUMNNAME>
+<!--C8E8009C6BF5427EA930515F217F768E--> <NAME><![CDATA[Process
Reconciliation]]></NAME>
+<!--C8E8009C6BF5427EA930515F217F768E--> <PRINTNAME><![CDATA[Process
Reconciliation]]></PRINTNAME>
+<!--C8E8009C6BF5427EA930515F217F768E--> <DESCRIPTION><![CDATA[Process
Reconciliation Document]]></DESCRIPTION>
+<!--C8E8009C6BF5427EA930515F217F768E--> <HELP><![CDATA[Used to process and
reactivate reconciliation documents]]></HELP>
+<!--C8E8009C6BF5427EA930515F217F768E-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--C8E8009C6BF5427EA930515F217F768E--></AD_ELEMENT>
+
</data>
diff -r e2de6f86f183 -r e512eb8da0b2
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
Tue Mar 08 10:02:24 2011 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
Tue Mar 08 11:19:07 2011 +0100
@@ -1580,6 +1580,32 @@
<!--6217B6E7C2CA46E8A399B7B4178F8CEC-->
<STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
<!--6217B6E7C2CA46E8A399B7B4178F8CEC--></AD_FIELD>
+<!--6376408E4B3B4208825144CBD72F54CA--><AD_FIELD>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<AD_FIELD_ID><![CDATA[6376408E4B3B4208825144CBD72F54CA]]></AD_FIELD_ID>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6376408E4B3B4208825144CBD72F54CA--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6376408E4B3B4208825144CBD72F54CA--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6376408E4B3B4208825144CBD72F54CA--> <NAME><![CDATA[Reconciliation
Process]]></NAME>
+<!--6376408E4B3B4208825144CBD72F54CA--> <DESCRIPTION><![CDATA[Manages
processing of reconciliation documents]]></DESCRIPTION>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<AD_TAB_ID><![CDATA[C095D2CC39704DBE8B906B7CD7710968]]></AD_TAB_ID>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<AD_COLUMN_ID><![CDATA[63454E73F07B4C908EB1268C41F5DE8A]]></AD_COLUMN_ID>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<DISPLAYLOGIC><![CDATA[@Processed@='Y']]></DISPLAYLOGIC>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
+<!--6376408E4B3B4208825144CBD72F54CA--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--6376408E4B3B4208825144CBD72F54CA--> <SEQNO><![CDATA[192]]></SEQNO>
+<!--6376408E4B3B4208825144CBD72F54CA--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--6376408E4B3B4208825144CBD72F54CA--> <GRID_SEQNO><![CDATA[0]]></GRID_SEQNO>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--6376408E4B3B4208825144CBD72F54CA-->
<STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--6376408E4B3B4208825144CBD72F54CA--></AD_FIELD>
+
<!--642FBD2AB83147E395BF96708345108D--><AD_FIELD>
<!--642FBD2AB83147E395BF96708345108D-->
<AD_FIELD_ID><![CDATA[642FBD2AB83147E395BF96708345108D]]></AD_FIELD_ID>
<!--642FBD2AB83147E395BF96708345108D-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -3401,7 +3427,7 @@
<!--82F2E8A160CE472CE040007F01005324-->
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
<!--82F2E8A160CE472CE040007F01005324-->
<DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
<!--82F2E8A160CE472CE040007F01005324--> <ISREADONLY><![CDATA[Y]]></ISREADONLY>
-<!--82F2E8A160CE472CE040007F01005324--> <SEQNO><![CDATA[190]]></SEQNO>
+<!--82F2E8A160CE472CE040007F01005324--> <SEQNO><![CDATA[186]]></SEQNO>
<!--82F2E8A160CE472CE040007F01005324--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
<!--82F2E8A160CE472CE040007F01005324-->
<ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
<!--82F2E8A160CE472CE040007F01005324-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
diff -r e2de6f86f183 -r e512eb8da0b2
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MESSAGE.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MESSAGE.xml
Tue Mar 08 10:02:24 2011 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MESSAGE.xml
Tue Mar 08 11:19:07 2011 +0100
@@ -583,4 +583,26 @@
<!--FCDC2F10EAAD46A5A24BCEC2BF017A05-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
<!--FCDC2F10EAAD46A5A24BCEC2BF017A05--></AD_MESSAGE>
+<!--FF8080812E44C5F1012E44D2099A001A--><AD_MESSAGE>
+<!--FF8080812E44C5F1012E44D2099A001A-->
<AD_MESSAGE_ID><![CDATA[FF8080812E44C5F1012E44D2099A001A]]></AD_MESSAGE_ID>
+<!--FF8080812E44C5F1012E44D2099A001A-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080812E44C5F1012E44D2099A001A--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080812E44C5F1012E44D2099A001A--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080812E44C5F1012E44D2099A001A-->
<VALUE><![CDATA[APRM_FutureReconciliationExists]]></VALUE>
+<!--FF8080812E44C5F1012E44D2099A001A--> <MSGTEXT><![CDATA[Action can not be
performed as a later reconciliation exists. First reactivate and delete later
reconciliations.]]></MSGTEXT>
+<!--FF8080812E44C5F1012E44D2099A001A--> <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--FF8080812E44C5F1012E44D2099A001A-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--FF8080812E44C5F1012E44D2099A001A--></AD_MESSAGE>
+
+<!--FF8080812E44C5F1012E44D35D750020--><AD_MESSAGE>
+<!--FF8080812E44C5F1012E44D35D750020-->
<AD_MESSAGE_ID><![CDATA[FF8080812E44C5F1012E44D35D750020]]></AD_MESSAGE_ID>
+<!--FF8080812E44C5F1012E44D35D750020-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080812E44C5F1012E44D35D750020--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080812E44C5F1012E44D35D750020--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080812E44C5F1012E44D35D750020-->
<VALUE><![CDATA[APRM_ReconciliationNoLines]]></VALUE>
+<!--FF8080812E44C5F1012E44D35D750020--> <MSGTEXT><![CDATA[Reconciliation
contains no line. At least one cleared item is required for a reconciliation
document to be processed.]]></MSGTEXT>
+<!--FF8080812E44C5F1012E44D35D750020--> <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--FF8080812E44C5F1012E44D35D750020-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--FF8080812E44C5F1012E44D35D750020--></AD_MESSAGE>
+
</data>
diff -r e2de6f86f183 -r e512eb8da0b2
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODEL_OBJECT.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODEL_OBJECT.xml
Tue Mar 08 10:02:24 2011 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODEL_OBJECT.xml
Tue Mar 08 11:19:07 2011 +0100
@@ -216,4 +216,16 @@
<!--FF73C27402EB45558A1925859CD484F0-->
<OBJECT_TYPE><![CDATA[S]]></OBJECT_TYPE>
<!--FF73C27402EB45558A1925859CD484F0--></AD_MODEL_OBJECT>
+<!--FF8080812E437710012E43BE26A3000E--><AD_MODEL_OBJECT>
+<!--FF8080812E437710012E43BE26A3000E-->
<AD_MODEL_OBJECT_ID><![CDATA[FF8080812E437710012E43BE26A3000E]]></AD_MODEL_OBJECT_ID>
+<!--FF8080812E437710012E43BE26A3000E-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080812E437710012E43BE26A3000E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
