Widget step
authorEduardo Argal Guibert <eduardo.argal@openbravo.com>
Thu, 20 Oct 2011 11:55:28 +0200
changeset 14114 21ad60710ca2
parent 14113 c51ad47f9b16
child 14115 0d807044fd8a
Widget step
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_DETAIL_V.xml
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBKMO_WIDGET_REFERENCE.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUIAPP_PARAMETER.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	Thu Oct 20 11:55:28 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('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('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('Outstanding Payments') 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('Outstanding Deposits') 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>
--- 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	Thu Oct 20 11:55:28 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>
--- 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	Thu Oct 20 11:55:28 2011 +0200
@@ -104,6 +104,36 @@
 <!--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-->  <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-->  <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--></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 +273,36 @@
 <!--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-->  <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[N]]></ISIDENTIFIER>
+<!--1485BE46BB7E48D78834C85C8E970D00-->  <SEQNO><![CDATA[170]]></SEQNO>
+<!--1485BE46BB7E48D78834C85C8E970D00-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--1485BE46BB7E48D78834C85C8E970D00-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--1485BE46BB7E48D78834C85C8E970D00-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--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--></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 +1088,36 @@
 <!--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-->  <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-->  <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--></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 +1221,36 @@
 <!--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-->  <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-->  <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--></AD_COLUMN>
+
 <!--49BEE6AEC60D4C61922B2B2DB42D7918--><AD_COLUMN>
 <!--49BEE6AEC60D4C61922B2B2DB42D7918-->  <AD_COLUMN_ID><![CDATA[49BEE6AEC60D4C61922B2B2DB42D7918]]></AD_COLUMN_ID>
 <!--49BEE6AEC60D4C61922B2B2DB42D7918-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -1437,6 +1557,36 @@
 <!--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[FIN_Reconciliation_ID]]></NAME>
+<!--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>
+<!--5B783EC445B04714B33004F9993EBB07-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--5B783EC445B04714B33004F9993EBB07-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--5B783EC445B04714B33004F9993EBB07-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--5B783EC445B04714B33004F9993EBB07-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--5B783EC445B04714B33004F9993EBB07-->  <POSITION><![CDATA[3]]></POSITION>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--5B783EC445B04714B33004F9993EBB07-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--5B783EC445B04714B33004F9993EBB07-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--5B783EC445B04714B33004F9993EBB07--></AD_COLUMN>
+
 <!--5D8DC67BCE524D33B008CBC108394C9A--><AD_COLUMN>
 <!--5D8DC67BCE524D33B008CBC108394C9A-->  <AD_COLUMN_ID><![CDATA[5D8DC67BCE524D33B008CBC108394C9A]]></AD_COLUMN_ID>
 <!--5D8DC67BCE524D33B008CBC108394C9A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -2858,7 +3008,8 @@
 <!--82EFB8E4045119C9E040007F01003778-->  <HELP><![CDATA[Print Detailed]]></HELP>
 <!--82EFB8E4045119C9E040007F01003778-->  <COLUMNNAME><![CDATA[Printdetailed]]></COLUMNNAME>
 <!--82EFB8E4045119C9E040007F01003778-->  <AD_TABLE_ID><![CDATA[0DFF5BACFB964FDABAA5042C8809C813]]></AD_TABLE_ID>
-<!--82EFB8E4045119C9E040007F01003778-->  <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
+<!--82EFB8E4045119C9E040007F01003778-->  <AD_REFERENCE_ID><![CDATA[FF8080813123BF670131241C2BB30012]]></AD_REFERENCE_ID>
+<!--82EFB8E4045119C9E040007F01003778-->  <AD_REFERENCE_VALUE_ID><![CDATA[FF80808133186ADD01331B465E32002D]]></AD_REFERENCE_VALUE_ID>
 <!--82EFB8E4045119C9E040007F01003778-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
 <!--82EFB8E4045119C9E040007F01003778-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--82EFB8E4045119C9E040007F01003778-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -3929,6 +4080,37 @@
 <!--8BFE5B396F1743BBB9CDC7F821E5EF89-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
 <!--8BFE5B396F1743BBB9CDC7F821E5EF89--></AD_COLUMN>
 
+<!--9220C8010FFB4EAABB8B367633EA9454--><AD_COLUMN>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <AD_COLUMN_ID><![CDATA[9220C8010FFB4EAABB8B367633EA9454]]></AD_COLUMN_ID>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <NAME><![CDATA[Client]]></NAME>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <COLUMNNAME><![CDATA[AD_Client_ID]]></COLUMNNAME>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <DEFAULTVALUE><![CDATA[@AD_CLIENT_ID@]]></DEFAULTVALUE>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <POSITION><![CDATA[6]]></POSITION>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9220C8010FFB4EAABB8B367633EA9454-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9220C8010FFB4EAABB8B367633EA9454--></AD_COLUMN>
+
 <!--923F5B228E5F4D2D96C00C206D47BC63--><AD_COLUMN>
 <!--923F5B228E5F4D2D96C00C206D47BC63-->  <AD_COLUMN_ID><![CDATA[923F5B228E5F4D2D96C00C206D47BC63]]></AD_COLUMN_ID>
 <!--923F5B228E5F4D2D96C00C206D47BC63-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -4134,6 +4316,36 @@
 <!--9D382AE31EFB4496B0A531A0FD72E73B-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
 <!--9D382AE31EFB4496B0A531A0FD72E73B--></AD_COLUMN>
 
+<!--9DE9E45A80994A969AC623FA97A3C0E8--><AD_COLUMN>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <AD_COLUMN_ID><![CDATA[9DE9E45A80994A969AC623FA97A3C0E8]]></AD_COLUMN_ID>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <NAME><![CDATA[Created By]]></NAME>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <COLUMNNAME><![CDATA[Createdby]]></COLUMNNAME>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <SEQNO><![CDATA[90]]></SEQNO>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <POSITION><![CDATA[9]]></POSITION>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9DE9E45A80994A969AC623FA97A3C0E8-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9DE9E45A80994A969AC623FA97A3C0E8--></AD_COLUMN>
+
 <!--A028C06E679F6F62E040007F01007206--><AD_COLUMN>
 <!--A028C06E679F6F62E040007F01007206-->  <AD_COLUMN_ID><![CDATA[A028C06E679F6F62E040007F01007206]]></AD_COLUMN_ID>
 <!--A028C06E679F6F62E040007F01007206-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -5862,6 +6074,36 @@
 <!--AE840317B6694DBAA5DC6898969B8210-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
 <!--AE840317B6694DBAA5DC6898969B8210--></AD_COLUMN>
 
+<!--B0140FD7843840979CB847D51E858ABA--><AD_COLUMN>
+<!--B0140FD7843840979CB847D51E858ABA-->  <AD_COLUMN_ID><![CDATA[B0140FD7843840979CB847D51E858ABA]]></AD_COLUMN_ID>
+<!--B0140FD7843840979CB847D51E858ABA-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B0140FD7843840979CB847D51E858ABA-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B0140FD7843840979CB847D51E858ABA-->  <NAME><![CDATA[Item_No]]></NAME>
+<!--B0140FD7843840979CB847D51E858ABA-->  <COLUMNNAME><![CDATA[Item_No]]></COLUMNNAME>
+<!--B0140FD7843840979CB847D51E858ABA-->  <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID>
+<!--B0140FD7843840979CB847D51E858ABA-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
+<!--B0140FD7843840979CB847D51E858ABA-->  <FIELDLENGTH><![CDATA[2]]></FIELDLENGTH>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--B0140FD7843840979CB847D51E858ABA-->  <SEQNO><![CDATA[160]]></SEQNO>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--B0140FD7843840979CB847D51E858ABA-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--B0140FD7843840979CB847D51E858ABA-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--B0140FD7843840979CB847D51E858ABA-->  <POSITION><![CDATA[4]]></POSITION>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--B0140FD7843840979CB847D51E858ABA-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--B0140FD7843840979CB847D51E858ABA-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--B0140FD7843840979CB847D51E858ABA--></AD_COLUMN>
+
 <!--B01D6A5AF6F14FD6947BDEEF22C35CF8--><AD_COLUMN>
 <!--B01D6A5AF6F14FD6947BDEEF22C35CF8-->  <AD_COLUMN_ID><![CDATA[B01D6A5AF6F14FD6947BDEEF22C35CF8]]></AD_COLUMN_ID>
 <!--B01D6A5AF6F14FD6947BDEEF22C35CF8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -6101,6 +6343,36 @@
 <!--B9DAC6015F8F4F94965030A72199BC55-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
 <!--B9DAC6015F8F4F94965030A72199BC55--></AD_COLUMN>
 
+<!--BB2A987CBD534A18B91D77B7D43AF879--><AD_COLUMN>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <AD_COLUMN_ID><![CDATA[BB2A987CBD534A18B91D77B7D43AF879]]></AD_COLUMN_ID>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <NAME><![CDATA[Updated By]]></NAME>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <COLUMNNAME><![CDATA[Updatedby]]></COLUMNNAME>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <SEQNO><![CDATA[110]]></SEQNO>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <POSITION><![CDATA[11]]></POSITION>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--BB2A987CBD534A18B91D77B7D43AF879-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--BB2A987CBD534A18B91D77B7D43AF879--></AD_COLUMN>
+
 <!--BBE36F9268AD4E4D9F8BD3E152E7D3BA--><AD_COLUMN>
 <!--BBE36F9268AD4E4D9F8BD3E152E7D3BA-->  <AD_COLUMN_ID><![CDATA[BBE36F9268AD4E4D9F8BD3E152E7D3BA]]></AD_COLUMN_ID>
 <!--BBE36F9268AD4E4D9F8BD3E152E7D3BA-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -6374,6 +6646,36 @@
 <!--D6A01A3BA0674CC49C7F17FA2251E7C6-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
 <!--D6A01A3BA0674CC49C7F17FA2251E7C6--></AD_COLUMN>
 
+<!--DD5C635F60EF4CA6BD8395F81E8466AD--><AD_COLUMN>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <AD_COLUMN_ID><![CDATA[DD5C635F60EF4CA6BD8395F81E8466AD]]></AD_COLUMN_ID>
+<!--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-->  <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <FIELDLENGTH><![CDATA[-5]]></FIELDLENGTH>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISKEY><![CDATA[Y]]></ISKEY>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <POSITION><![CDATA[1]]></POSITION>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--DD5C635F60EF4CA6BD8395F81E8466AD--></AD_COLUMN>
+
 <!--E3E69DDF3725407BABA84827647EF002--><AD_COLUMN>
 <!--E3E69DDF3725407BABA84827647EF002-->  <AD_COLUMN_ID><![CDATA[E3E69DDF3725407BABA84827647EF002]]></AD_COLUMN_ID>
 <!--E3E69DDF3725407BABA84827647EF002-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -6442,6 +6744,36 @@
 <!--E6DB13E1516947B7A8DC5741D58A7AB2-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
 <!--E6DB13E1516947B7A8DC5741D58A7AB2--></AD_COLUMN>
 
+<!--EA4E28B26B6A4157830C4D2C09F93DCB--><AD_COLUMN>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <AD_COLUMN_ID><![CDATA[EA4E28B26B6A4157830C4D2C09F93DCB]]></AD_COLUMN_ID>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <NAME><![CDATA[Item_Amt]]></NAME>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <COLUMNNAME><![CDATA[Item_Amt]]></COLUMNNAME>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <FIELDLENGTH><![CDATA[2]]></FIELDLENGTH>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <POSITION><![CDATA[5]]></POSITION>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--EA4E28B26B6A4157830C4D2C09F93DCB--></AD_COLUMN>
+
 <!--EBF40746D2584CCC991B1F592C3A5DB9--><AD_COLUMN>
 <!--EBF40746D2584CCC991B1F592C3A5DB9-->  <AD_COLUMN_ID><![CDATA[EBF40746D2584CCC991B1F592C3A5DB9]]></AD_COLUMN_ID>
 <!--EBF40746D2584CCC991B1F592C3A5DB9-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -6650,6 +6982,37 @@
 <!--F79D0173541B42CD9F41A58D53929BFA-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
 <!--F79D0173541B42CD9F41A58D53929BFA--></AD_COLUMN>
 
+<!--F860918881E54495981462670E8882BF--><AD_COLUMN>
+<!--F860918881E54495981462670E8882BF-->  <AD_COLUMN_ID><![CDATA[F860918881E54495981462670E8882BF]]></AD_COLUMN_ID>
+<!--F860918881E54495981462670E8882BF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F860918881E54495981462670E8882BF-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F860918881E54495981462670E8882BF-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F860918881E54495981462670E8882BF-->  <NAME><![CDATA[Organization]]></NAME>
+<!--F860918881E54495981462670E8882BF-->  <COLUMNNAME><![CDATA[AD_Org_ID]]></COLUMNNAME>
+<!--F860918881E54495981462670E8882BF-->  <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID>
+<!--F860918881E54495981462670E8882BF-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--F860918881E54495981462670E8882BF-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--F860918881E54495981462670E8882BF-->  <DEFAULTVALUE><![CDATA[@AD_ORG_ID@]]></DEFAULTVALUE>
+<!--F860918881E54495981462670E8882BF-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--F860918881E54495981462670E8882BF-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--F860918881E54495981462670E8882BF-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--F860918881E54495981462670E8882BF-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--F860918881E54495981462670E8882BF-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--F860918881E54495981462670E8882BF-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--F860918881E54495981462670E8882BF-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--F860918881E54495981462670E8882BF-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--F860918881E54495981462670E8882BF-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--F860918881E54495981462670E8882BF-->  <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
+<!--F860918881E54495981462670E8882BF-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--F860918881E54495981462670E8882BF-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--F860918881E54495981462670E8882BF-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--F860918881E54495981462670E8882BF-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--F860918881E54495981462670E8882BF-->  <POSITION><![CDATA[7]]></POSITION>
+<!--F860918881E54495981462670E8882BF-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--F860918881E54495981462670E8882BF-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--F860918881E54495981462670E8882BF-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--F860918881E54495981462670E8882BF--></AD_COLUMN>
+
 <!--FA5D73939D454F8E804DFACEE44D0C6E--><AD_COLUMN>
 <!--FA5D73939D454F8E804DFACEE44D0C6E-->  <AD_COLUMN_ID><![CDATA[FA5D73939D454F8E804DFACEE44D0C6E]]></AD_COLUMN_ID>
 <!--FA5D73939D454F8E804DFACEE44D0C6E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml	Wed Oct 26 18:29:31 2011 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml	Thu Oct 20 11:55:28 2011 +0200
@@ -4873,6 +4873,8 @@
 <!--82F2E8A160DB472CE040007F01005324-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
 <!--82F2E8A160DB472CE040007F01005324-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
 <!--82F2E8A160DB472CE040007F01005324-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--82F2E8A160DB472CE040007F01005324-->  <EM_OBUIAPP_COLSPAN><![CDATA[2]]></EM_OBUIAPP_COLSPAN>
+<!--82F2E8A160DB472CE040007F01005324-->  <EM_OBUIAPP_ROWSPAN><![CDATA[8]]></EM_OBUIAPP_ROWSPAN>
 <!--82F2E8A160DB472CE040007F01005324--></AD_FIELD>
 
 <!--82F2E8A160DC472CE040007F01005324--><AD_FIELD>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml	Wed Oct 26 18:29:31 2011 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml	Thu Oct 20 11:55:28 2011 +0200
@@ -134,6 +134,18 @@
 <!--FF8080812E443491012E443C053A001A-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--FF8080812E443491012E443C053A001A--></AD_REFERENCE>
 
+<!--FF80808133186ADD01331B465E32002D--><AD_REFERENCE>
+<!--FF80808133186ADD01331B465E32002D-->  <AD_REFERENCE_ID><![CDATA[FF80808133186ADD01331B465E32002D]]></AD_REFERENCE_ID>
+<!--FF80808133186ADD01331B465E32002D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80808133186ADD01331B465E32002D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80808133186ADD01331B465E32002D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80808133186ADD01331B465E32002D-->  <NAME><![CDATA[Reconciliation Detail Widget]]></NAME>
+<!--FF80808133186ADD01331B465E32002D-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--FF80808133186ADD01331B465E32002D-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--FF80808133186ADD01331B465E32002D-->  <PARENTREFERENCE_ID><![CDATA[FF8080813123BF670131241C2BB30012]]></PARENTREFERENCE_ID>
+<!--FF80808133186ADD01331B465E32002D-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--FF80808133186ADD01331B465E32002D--></AD_REFERENCE>
+
 <!--FF808181312414380131241C5A41001F--><AD_REFERENCE>
 <!--FF808181312414380131241C5A41001F-->  <AD_REFERENCE_ID><![CDATA[FF808181312414380131241C5A41001F]]></AD_REFERENCE_ID>
 <!--FF808181312414380131241C5A41001F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml	Wed Oct 26 18:29:31 2011 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml	Thu Oct 20 11:55:28 2011 +0200
@@ -109,4 +109,24 @@
 <!--FF80808130BB89090130BB8E3D7E0012-->  <AD_PACKAGE_ID><![CDATA[AC33B2262748414A816510545755435A]]></AD_PACKAGE_ID>
 <!--FF80808130BB89090130BB8E3D7E0012--></AD_TABLE>
 
+<!--FF808081331848750133184B38D20009--><AD_TABLE>
+<!--FF808081331848750133184B38D20009-->  <AD_TABLE_ID><![CDATA[FF808081331848750133184B38D20009]]></AD_TABLE_ID>
+<!--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-->  <ISVIEW><![CDATA[Y]]></ISVIEW>
+<!--FF808081331848750133184B38D20009-->  <ACCESSLEVEL><![CDATA[1]]></ACCESSLEVEL>
+<!--FF808081331848750133184B38D20009-->  <ISSECURITYENABLED><![CDATA[N]]></ISSECURITYENABLED>
+<!--FF808081331848750133184B38D20009-->  <ISDELETEABLE><![CDATA[N]]></ISDELETEABLE>
+<!--FF808081331848750133184B38D20009-->  <ISHIGHVOLUME><![CDATA[N]]></ISHIGHVOLUME>
+<!--FF808081331848750133184B38D20009-->  <IMPORTTABLE><![CDATA[N]]></IMPORTTABLE>
+<!--FF808081331848750133184B38D20009-->  <ISCHANGELOG><![CDATA[N]]></ISCHANGELOG>
+<!--FF808081331848750133184B38D20009-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
+<!--FF808081331848750133184B38D20009-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--FF808081331848750133184B38D20009-->  <AD_PACKAGE_ID><![CDATA[AC33B2262748414A816510545755435A]]></AD_PACKAGE_ID>
+<!--FF808081331848750133184B38D20009--></AD_TABLE>
+
 </data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml	Thu Oct 20 11:55:28 2011 +0200
@@ -0,0 +1,52 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF80808133186ADD01331B407CE5001D--><OBCQL_QUERY_COLUMN>
+<!--FF80808133186ADD01331B407CE5001D-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[FF80808133186ADD01331B407CE5001D]]></OBCQL_QUERY_COLUMN_ID>
+<!--FF80808133186ADD01331B407CE5001D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80808133186ADD01331B407CE5001D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80808133186ADD01331B407CE5001D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80808133186ADD01331B407CE5001D-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[FF80808133186ADD01331B3B733B0011]]></OBCQL_WIDGET_QUERY_ID>
+<!--FF80808133186ADD01331B407CE5001D-->  <DISPLAY_EXPRESSION><![CDATA[type]]></DISPLAY_EXPRESSION>
+<!--FF80808133186ADD01331B407CE5001D-->  <NAME><![CDATA[Type]]></NAME>
+<!--FF80808133186ADD01331B407CE5001D-->  <WIDTH><![CDATA[40]]></WIDTH>
+<!--FF80808133186ADD01331B407CE5001D-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--FF80808133186ADD01331B407CE5001D-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--FF80808133186ADD01331B407CE5001D-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
+<!--FF80808133186ADD01331B407CE5001D-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--FF80808133186ADD01331B407CE5001D-->  <CAN_BE_FILTERED><![CDATA[N]]></CAN_BE_FILTERED>
+<!--FF80808133186ADD01331B407CE5001D--></OBCQL_QUERY_COLUMN>
+
+<!--FF80808133186ADD01331B41475B0022--><OBCQL_QUERY_COLUMN>
+<!--FF80808133186ADD01331B41475B0022-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[FF80808133186ADD01331B41475B0022]]></OBCQL_QUERY_COLUMN_ID>
+<!--FF80808133186ADD01331B41475B0022-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80808133186ADD01331B41475B0022-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80808133186ADD01331B41475B0022-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80808133186ADD01331B41475B0022-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[FF80808133186ADD01331B3B733B0011]]></OBCQL_WIDGET_QUERY_ID>
+<!--FF80808133186ADD01331B41475B0022-->  <DISPLAY_EXPRESSION><![CDATA[itemNo]]></DISPLAY_EXPRESSION>
+<!--FF80808133186ADD01331B41475B0022-->  <NAME><![CDATA[Item No]]></NAME>
+<!--FF80808133186ADD01331B41475B0022-->  <WIDTH><![CDATA[30]]></WIDTH>
+<!--FF80808133186ADD01331B41475B0022-->  <SEQNO><![CDATA[20]]></SEQNO>
+<!--FF80808133186ADD01331B41475B0022-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
+<!--FF80808133186ADD01331B41475B0022-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
+<!--FF80808133186ADD01331B41475B0022-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--FF80808133186ADD01331B41475B0022-->  <CAN_BE_FILTERED><![CDATA[N]]></CAN_BE_FILTERED>
+<!--FF80808133186ADD01331B41475B0022--></OBCQL_QUERY_COLUMN>
+
+<!--FF80808133186ADD01331B41D7830027--><OBCQL_QUERY_COLUMN>
+<!--FF80808133186ADD01331B41D7830027-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[FF80808133186ADD01331B41D7830027]]></OBCQL_QUERY_COLUMN_ID>
+<!--FF80808133186ADD01331B41D7830027-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80808133186ADD01331B41D7830027-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80808133186ADD01331B41D7830027-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80808133186ADD01331B41D7830027-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[FF80808133186ADD01331B3B733B0011]]></OBCQL_WIDGET_QUERY_ID>
+<!--FF80808133186ADD01331B41D7830027-->  <DISPLAY_EXPRESSION><![CDATA[itemAmt]]></DISPLAY_EXPRESSION>
+<!--FF80808133186ADD01331B41D7830027-->  <NAME><![CDATA[Item Amount]]></NAME>
+<!--FF80808133186ADD01331B41D7830027-->  <SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE>
+<!--FF80808133186ADD01331B41D7830027-->  <WIDTH><![CDATA[30]]></WIDTH>
+<!--FF80808133186ADD01331B41D7830027-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--FF80808133186ADD01331B41D7830027-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
+<!--FF80808133186ADD01331B41D7830027-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
+<!--FF80808133186ADD01331B41D7830027-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--FF80808133186ADD01331B41D7830027-->  <CAN_BE_FILTERED><![CDATA[N]]></CAN_BE_FILTERED>
+<!--FF80808133186ADD01331B41D7830027--></OBCQL_QUERY_COLUMN>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Thu Oct 20 11:55:28 2011 +0200
@@ -0,0 +1,12 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF80808133186ADD01331B3B733B0011--><OBCQL_WIDGET_QUERY>
+<!--FF80808133186ADD01331B3B733B0011-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[FF80808133186ADD01331B3B733B0011]]></OBCQL_WIDGET_QUERY_ID>
+<!--FF80808133186ADD01331B3B733B0011-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80808133186ADD01331B3B733B0011-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80808133186ADD01331B3B733B0011-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80808133186ADD01331B3B733B0011-->  <OBKMO_WIDGET_CLASS_ID><![CDATA[FF80808133186ADD01331B3A932C000D]]></OBKMO_WIDGET_CLASS_ID>
+<!--FF80808133186ADD01331B3B733B0011-->  <HQL><![CDATA[select a.type, a.itemNo, a.itemAmt, a.fINReconciliation.id as reconciliationId from aprm_reconciliation_detail_v as a]]></HQL>
+<!--FF80808133186ADD01331B3B733B0011--></OBCQL_WIDGET_QUERY>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml	Thu Oct 20 11:55:28 2011 +0200
@@ -0,0 +1,18 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF80808133186ADD01331B3A932C000D--><OBKMO_WIDGET_CLASS>
+<!--FF80808133186ADD01331B3A932C000D-->  <OBKMO_WIDGET_CLASS_ID><![CDATA[FF80808133186ADD01331B3A932C000D]]></OBKMO_WIDGET_CLASS_ID>
+<!--FF80808133186ADD01331B3A932C000D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80808133186ADD01331B3A932C000D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80808133186ADD01331B3A932C000D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80808133186ADD01331B3A932C000D-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--FF80808133186ADD01331B3A932C000D-->  <TITLE><![CDATA[Reconciliation Details]]></TITLE>
+<!--FF80808133186ADD01331B3A932C000D-->  <HEIGHT><![CDATA[300]]></HEIGHT>
+<!--FF80808133186ADD01331B3A932C000D-->  <ALLOW_ANONYMOUS_ACCESS><![CDATA[Y]]></ALLOW_ANONYMOUS_ACCESS>
+<!--FF80808133186ADD01331B3A932C000D-->  <ISSUPERCLASS><![CDATA[N]]></ISSUPERCLASS>
+<!--FF80808133186ADD01331B3A932C000D-->  <WIDGET_SUPERCLASS_ID><![CDATA[2A32CF26F3F64FE39C7F94E9D82497D1]]></WIDGET_SUPERCLASS_ID>
+<!--FF80808133186ADD01331B3A932C000D-->  <CAN_MAXIMIZE><![CDATA[N]]></CAN_MAXIMIZE>
+<!--FF80808133186ADD01331B3A932C000D-->  <ACCESSLEVEL><![CDATA[1]]></ACCESSLEVEL>
+<!--FF80808133186ADD01331B3A932C000D--></OBKMO_WIDGET_CLASS>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBKMO_WIDGET_REFERENCE.xml	Thu Oct 20 11:55:28 2011 +0200
@@ -0,0 +1,12 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF80808133186ADD01331B465E32002D--><OBKMO_WIDGET_REFERENCE>
+<!--FF80808133186ADD01331B465E32002D-->  <AD_REFERENCE_ID><![CDATA[FF80808133186ADD01331B465E32002D]]></AD_REFERENCE_ID>
+<!--FF80808133186ADD01331B465E32002D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80808133186ADD01331B465E32002D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80808133186ADD01331B465E32002D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80808133186ADD01331B465E32002D-->  <OBKMO_WIDGET_CLASS_ID><![CDATA[FF80808133186ADD01331B3A932C000D]]></OBKMO_WIDGET_CLASS_ID>
+<!--FF80808133186ADD01331B465E32002D-->  <SHOWFIELDTITLE><![CDATA[Y]]></SHOWFIELDTITLE>
+<!--FF80808133186ADD01331B465E32002D--></OBKMO_WIDGET_REFERENCE>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml	Thu Oct 20 11:55:28 2011 +0200
@@ -0,0 +1,62 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269--><OBUIAPP_PARAMETER>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <OBUIAPP_PARAMETER_ID><![CDATA[0A9E075CCC6E4D59AAC37E3AEF1FE269]]></OBUIAPP_PARAMETER_ID>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <NAME><![CDATA[Show all data]]></NAME>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <COLUMNNAME><![CDATA[showAll]]></COLUMNNAME>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <DEFAULTVALUE><![CDATA[false]]></DEFAULTVALUE>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <AD_ELEMENT_ID><![CDATA[9A0C92898CEE7AC8E040007F01003160]]></AD_ELEMENT_ID>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <ISFIXED><![CDATA[N]]></ISFIXED>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <EVALUATEFIXEDVALUE><![CDATA[N]]></EVALUATEFIXEDVALUE>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[FF80808133186ADD01331B3A932C000D]]></EM_OBKMO_WIDGET_CLASS_ID>
+<!--0A9E075CCC6E4D59AAC37E3AEF1FE269--></OBUIAPP_PARAMETER>
+
+<!--2653B134344A4BBEBA417F6CFEDE8D91--><OBUIAPP_PARAMETER>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <OBUIAPP_PARAMETER_ID><![CDATA[2653B134344A4BBEBA417F6CFEDE8D91]]></OBUIAPP_PARAMETER_ID>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <NAME><![CDATA[Number of Rows]]></NAME>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <SEQNO><![CDATA[0]]></SEQNO>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <COLUMNNAME><![CDATA[RowsNumber]]></COLUMNNAME>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <DEFAULTVALUE><![CDATA[4]]></DEFAULTVALUE>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <AD_ELEMENT_ID><![CDATA[9A0C92898CF17AC8E040007F01003160]]></AD_ELEMENT_ID>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <ISFIXED><![CDATA[N]]></ISFIXED>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <EVALUATEFIXEDVALUE><![CDATA[N]]></EVALUATEFIXEDVALUE>
+<!--2653B134344A4BBEBA417F6CFEDE8D91-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[FF80808133186ADD01331B3A932C000D]]></EM_OBKMO_WIDGET_CLASS_ID>
+<!--2653B134344A4BBEBA417F6CFEDE8D91--></OBUIAPP_PARAMETER>
+
+<!--FF808081331B5EE901331B68C4540018--><OBUIAPP_PARAMETER>
+<!--FF808081331B5EE901331B68C4540018-->  <OBUIAPP_PARAMETER_ID><![CDATA[FF808081331B5EE901331B68C4540018]]></OBUIAPP_PARAMETER_ID>
+<!--FF808081331B5EE901331B68C4540018-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808081331B5EE901331B68C4540018-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808081331B5EE901331B68C4540018-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808081331B5EE901331B68C4540018-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--FF808081331B5EE901331B68C4540018-->  <NAME><![CDATA[reconciliationId]]></NAME>
+<!--FF808081331B5EE901331B68C4540018-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--FF808081331B5EE901331B68C4540018-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
+<!--FF808081331B5EE901331B68C4540018-->  <COLUMNNAME><![CDATA[reconciliationId]]></COLUMNNAME>
+<!--FF808081331B5EE901331B68C4540018-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--FF808081331B5EE901331B68C4540018-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--FF808081331B5EE901331B68C4540018-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--FF808081331B5EE901331B68C4540018-->  <DEFAULTVALUE><![CDATA[${formValues.id}]]></DEFAULTVALUE>
+<!--FF808081331B5EE901331B68C4540018-->  <ISFIXED><![CDATA[N]]></ISFIXED>
+<!--FF808081331B5EE901331B68C4540018-->  <EVALUATEFIXEDVALUE><![CDATA[N]]></EVALUATEFIXEDVALUE>
+<!--FF808081331B5EE901331B68C4540018-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[FF80808133186ADD01331B3A932C000D]]></EM_OBKMO_WIDGET_CLASS_ID>
+<!--FF808081331B5EE901331B68C4540018--></OBUIAPP_PARAMETER>
+
+</data>