[Reconciliation] Candidates Manual Datasource in progress
authorVíctor Martínez Romanos <victor.martinez@openbravo.com>
Tue, 19 Aug 2014 17:23:18 +0200
changeset 24530 0ed2c558ac49
parent 24529 bdb5ce4274ff
child 24531 cf796d5d0587
[Reconciliation] Candidates Manual Datasource in progress
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.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_TAB.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_WINDOW.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBSERDS_DATASOURCE.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUIAPP_REF_WINDOW.xml
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/algorithm/StandardMatchingCandidatesAlgorithm.java
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/datasource/CandidatesDatasource.java
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/utility/FIN_CandidateRecord.java
modules/org.openbravo.advpaymentmngt/web/org.openbravo.advpaymentmngt/js/ob-aprm-matchStatement.js
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml	Tue Aug 19 12:29:16 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml	Tue Aug 19 17:23:18 2014 +0200
@@ -1404,6 +1404,40 @@
 <!--2B609CEE0C4E4DFBA000FFAFBC24917F-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--2B609CEE0C4E4DFBA000FFAFBC24917F--></AD_COLUMN>
 
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E--><AD_COLUMN>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <AD_COLUMN_ID><![CDATA[2C2036AF22A84DD29AFE7E42BFF5C88E]]></AD_COLUMN_ID>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <NAME><![CDATA[Updated By]]></NAME>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <DESCRIPTION><![CDATA[User who updated this records]]></DESCRIPTION>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <HELP><![CDATA[The Updated By field indicates the user who updated this record.]]></HELP>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <COLUMNNAME><![CDATA[updatedby]]></COLUMNNAME>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <AD_ELEMENT_ID><![CDATA[608]]></AD_ELEMENT_ID>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--2C2036AF22A84DD29AFE7E42BFF5C88E--></AD_COLUMN>
+
 <!--2DC02F74DA62406AACF3C3911C2AD807--><AD_COLUMN>
 <!--2DC02F74DA62406AACF3C3911C2AD807-->  <AD_COLUMN_ID><![CDATA[2DC02F74DA62406AACF3C3911C2AD807]]></AD_COLUMN_ID>
 <!--2DC02F74DA62406AACF3C3911C2AD807-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -1474,6 +1508,40 @@
 <!--31820F9EAD6B48489FC3875553CB6ED7-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--31820F9EAD6B48489FC3875553CB6ED7--></AD_COLUMN>
 
+<!--32595588E533456BBCCCEA2F2B2235C1--><AD_COLUMN>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <AD_COLUMN_ID><![CDATA[32595588E533456BBCCCEA2F2B2235C1]]></AD_COLUMN_ID>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <NAME><![CDATA[Organization]]></NAME>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <DESCRIPTION><![CDATA[Organizational entity within client]]></DESCRIPTION>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <HELP><![CDATA[An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.]]></HELP>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <COLUMNNAME><![CDATA[ad_org_id]]></COLUMNNAME>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <SEQNO><![CDATA[40]]></SEQNO>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <AD_ELEMENT_ID><![CDATA[113]]></AD_ELEMENT_ID>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--32595588E533456BBCCCEA2F2B2235C1-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--32595588E533456BBCCCEA2F2B2235C1--></AD_COLUMN>
+
 <!--3441F879B5DA4DB4BFAC1B8C5DEBF970--><AD_COLUMN>
 <!--3441F879B5DA4DB4BFAC1B8C5DEBF970-->  <AD_COLUMN_ID><![CDATA[3441F879B5DA4DB4BFAC1B8C5DEBF970]]></AD_COLUMN_ID>
 <!--3441F879B5DA4DB4BFAC1B8C5DEBF970-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -2246,6 +2314,38 @@
 <!--49BEE6AEC60D4C61922B2B2DB42D7918-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--49BEE6AEC60D4C61922B2B2DB42D7918--></AD_COLUMN>
 
+<!--49E83F583D6A4FBE8417F2742A4CAB46--><AD_COLUMN>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <AD_COLUMN_ID><![CDATA[49E83F583D6A4FBE8417F2742A4CAB46]]></AD_COLUMN_ID>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <NAME><![CDATA[Affinity]]></NAME>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <COLUMNNAME><![CDATA[affinity]]></COLUMNNAME>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <SEQNO><![CDATA[100]]></SEQNO>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <AD_ELEMENT_ID><![CDATA[829F6BFDD7254498B88C1BEFD397BFE3]]></AD_ELEMENT_ID>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--49E83F583D6A4FBE8417F2742A4CAB46-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--49E83F583D6A4FBE8417F2742A4CAB46--></AD_COLUMN>
+
 <!--4AE64134057846AFB053090561EA31D2--><AD_COLUMN>
 <!--4AE64134057846AFB053090561EA31D2-->  <AD_COLUMN_ID><![CDATA[4AE64134057846AFB053090561EA31D2]]></AD_COLUMN_ID>
 <!--4AE64134057846AFB053090561EA31D2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -3126,6 +3226,40 @@
 <!--670423B76C554A6C957A58F1DA4A6D98-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--670423B76C554A6C957A58F1DA4A6D98--></AD_COLUMN>
 
+<!--680E210AB84542E483FF770F9B14B0B9--><AD_COLUMN>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <AD_COLUMN_ID><![CDATA[680E210AB84542E483FF770F9B14B0B9]]></AD_COLUMN_ID>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <NAME><![CDATA[Created By]]></NAME>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <DESCRIPTION><![CDATA[User who created this records]]></DESCRIPTION>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <HELP><![CDATA[The Created By field indicates the user who created this record.]]></HELP>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <COLUMNNAME><![CDATA[createdby]]></COLUMNNAME>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <AD_ELEMENT_ID><![CDATA[246]]></AD_ELEMENT_ID>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--680E210AB84542E483FF770F9B14B0B9-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--680E210AB84542E483FF770F9B14B0B9--></AD_COLUMN>
+
 <!--68C853FD393C4620A3947EC34C416B9A--><AD_COLUMN>
 <!--68C853FD393C4620A3947EC34C416B9A-->  <AD_COLUMN_ID><![CDATA[68C853FD393C4620A3947EC34C416B9A]]></AD_COLUMN_ID>
 <!--68C853FD393C4620A3947EC34C416B9A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -3588,6 +3722,76 @@
 <!--76C4D6CDF96B4CB5B80967475AA3D2A9-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--76C4D6CDF96B4CB5B80967475AA3D2A9--></AD_COLUMN>
 
+<!--77A46591A67E4CE491C01F33865C87FB--><AD_COLUMN>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <AD_COLUMN_ID><![CDATA[77A46591A67E4CE491C01F33865C87FB]]></AD_COLUMN_ID>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <NAME><![CDATA[Active]]></NAME>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <DESCRIPTION><![CDATA[A flag indicating whether this record is available for use or de-activated.]]></DESCRIPTION>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <HELP><![CDATA[There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records: 
+(1) The system requires the record for auditing purposes.
+(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.]]></HELP>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <COLUMNNAME><![CDATA[isactive]]></COLUMNNAME>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <SEQNO><![CDATA[90]]></SEQNO>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <AD_ELEMENT_ID><![CDATA[348]]></AD_ELEMENT_ID>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--77A46591A67E4CE491C01F33865C87FB-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--77A46591A67E4CE491C01F33865C87FB--></AD_COLUMN>
+
+<!--78918F4C85454FD5AA4D8FBC818F73D2--><AD_COLUMN>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <AD_COLUMN_ID><![CDATA[78918F4C85454FD5AA4D8FBC818F73D2]]></AD_COLUMN_ID>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <NAME><![CDATA[Client]]></NAME>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <DESCRIPTION><![CDATA[Client for this installation.]]></DESCRIPTION>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <HELP><![CDATA[A Client is a company or a legal entity. You cannot share data between Clients.]]></HELP>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <COLUMNNAME><![CDATA[ad_client_id]]></COLUMNNAME>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <AD_ELEMENT_ID><![CDATA[102]]></AD_ELEMENT_ID>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--78918F4C85454FD5AA4D8FBC818F73D2-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--78918F4C85454FD5AA4D8FBC818F73D2--></AD_COLUMN>
+
 <!--78A3367822B35459E040007F01012510--><AD_COLUMN>
 <!--78A3367822B35459E040007F01012510-->  <AD_COLUMN_ID><![CDATA[78A3367822B35459E040007F01012510]]></AD_COLUMN_ID>
 <!--78A3367822B35459E040007F01012510-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -3904,6 +4108,38 @@
 <!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--8071EA28ABEA4E1E919AD14F3EE5B033--></AD_COLUMN>
 
+<!--82BB3A1CA1E14094B799659BE81A7E6C--><AD_COLUMN>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <AD_COLUMN_ID><![CDATA[82BB3A1CA1E14094B799659BE81A7E6C]]></AD_COLUMN_ID>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <NAME><![CDATA[Date]]></NAME>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <COLUMNNAME><![CDATA[Date]]></COLUMNNAME>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <SEQNO><![CDATA[110]]></SEQNO>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <AD_ELEMENT_ID><![CDATA[17ADA898A5534B858EC8BD7651492088]]></AD_ELEMENT_ID>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--82BB3A1CA1E14094B799659BE81A7E6C-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--82BB3A1CA1E14094B799659BE81A7E6C--></AD_COLUMN>
+
 <!--82EFB8E4043C19C9E040007F01003778--><AD_COLUMN>
 <!--82EFB8E4043C19C9E040007F01003778-->  <AD_COLUMN_ID><![CDATA[82EFB8E4043C19C9E040007F01003778]]></AD_COLUMN_ID>
 <!--82EFB8E4043C19C9E040007F01003778-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -8586,6 +8822,38 @@
 <!--B01D6A5AF6F14FD6947BDEEF22C35CF8-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--B01D6A5AF6F14FD6947BDEEF22C35CF8--></AD_COLUMN>
 
+<!--B31F203A1F1E46B496924F71684DBD9D--><AD_COLUMN>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <AD_COLUMN_ID><![CDATA[B31F203A1F1E46B496924F71684DBD9D]]></AD_COLUMN_ID>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <NAME><![CDATA[Amount]]></NAME>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <COLUMNNAME><![CDATA[Amount]]></COLUMNNAME>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <SEQNO><![CDATA[120]]></SEQNO>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <AD_ELEMENT_ID><![CDATA[7890366979712CEFE040007F01013334]]></AD_ELEMENT_ID>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--B31F203A1F1E46B496924F71684DBD9D-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--B31F203A1F1E46B496924F71684DBD9D--></AD_COLUMN>
+
 <!--B3645A0D0F674CD3BC3FCB6225C4E1A6--><AD_COLUMN>
 <!--B3645A0D0F674CD3BC3FCB6225C4E1A6-->  <AD_COLUMN_ID><![CDATA[B3645A0D0F674CD3BC3FCB6225C4E1A6]]></AD_COLUMN_ID>
 <!--B3645A0D0F674CD3BC3FCB6225C4E1A6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -8939,6 +9207,40 @@
 <!--B8A0E2E81E294B2AB10F4325BD4B563C-->  <ENTITY_ALIAS><![CDATA[bsl.transactionDate]]></ENTITY_ALIAS>
 <!--B8A0E2E81E294B2AB10F4325BD4B563C--></AD_COLUMN>
 
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43--><AD_COLUMN>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <AD_COLUMN_ID><![CDATA[B8F092DDA9504050ACF1F6C1D1ED8B43]]></AD_COLUMN_ID>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <NAME><![CDATA[Updated]]></NAME>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <DESCRIPTION><![CDATA[The date that this record was last updated]]></DESCRIPTION>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <HELP><![CDATA[The Updated field indicates the date that this record was updated.]]></HELP>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <COLUMNNAME><![CDATA[updated]]></COLUMNNAME>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <SEQNO><![CDATA[80]]></SEQNO>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <AD_ELEMENT_ID><![CDATA[607]]></AD_ELEMENT_ID>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--B8F092DDA9504050ACF1F6C1D1ED8B43--></AD_COLUMN>
+
 <!--B9DAC6015F8F4F94965030A72199BC55--><AD_COLUMN>
 <!--B9DAC6015F8F4F94965030A72199BC55-->  <AD_COLUMN_ID><![CDATA[B9DAC6015F8F4F94965030A72199BC55]]></AD_COLUMN_ID>
 <!--B9DAC6015F8F4F94965030A72199BC55-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -9469,6 +9771,40 @@
 <!--C4248185C139416FA0B6E1F11E4B3B29-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--C4248185C139416FA0B6E1F11E4B3B29--></AD_COLUMN>
 
+<!--C823C7E947264B9F938A53B36E4067CF--><AD_COLUMN>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <AD_COLUMN_ID><![CDATA[C823C7E947264B9F938A53B36E4067CF]]></AD_COLUMN_ID>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <NAME><![CDATA[Creation Date]]></NAME>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <DESCRIPTION><![CDATA[The date that this record is completed.]]></DESCRIPTION>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <HELP><![CDATA[The Created field indicates the date that this record was created.]]></HELP>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <COLUMNNAME><![CDATA[created]]></COLUMNNAME>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <AD_ELEMENT_ID><![CDATA[245]]></AD_ELEMENT_ID>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--C823C7E947264B9F938A53B36E4067CF-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--C823C7E947264B9F938A53B36E4067CF--></AD_COLUMN>
+
 <!--C9FD369BECE545828033CC49CAB85D9D--><AD_COLUMN>
 <!--C9FD369BECE545828033CC49CAB85D9D-->  <AD_COLUMN_ID><![CDATA[C9FD369BECE545828033CC49CAB85D9D]]></AD_COLUMN_ID>
 <!--C9FD369BECE545828033CC49CAB85D9D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -9535,6 +9871,38 @@
 <!--CBAF582C3F674FEEB1D38C2A10E03E2F-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--CBAF582C3F674FEEB1D38C2A10E03E2F--></AD_COLUMN>
 
+<!--CFCAE42083044B9AA6862205BCD2BD0B--><AD_COLUMN>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <AD_COLUMN_ID><![CDATA[CFCAE42083044B9AA6862205BCD2BD0B]]></AD_COLUMN_ID>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <NAME><![CDATA[id]]></NAME>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <COLUMNNAME><![CDATA[id]]></COLUMNNAME>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <FIELDLENGTH><![CDATA[0]]></FIELDLENGTH>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISKEY><![CDATA[Y]]></ISKEY>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <SEQNO><![CDATA[20]]></SEQNO>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <AD_ELEMENT_ID><![CDATA[C581AB086E0141EEAA2EEAA8605BD8F0]]></AD_ELEMENT_ID>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--CFCAE42083044B9AA6862205BCD2BD0B-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--CFCAE42083044B9AA6862205BCD2BD0B--></AD_COLUMN>
+
 <!--D4C27D211DF9416DA498EEFB6C008B7B--><AD_COLUMN>
 <!--D4C27D211DF9416DA498EEFB6C008B7B-->  <AD_COLUMN_ID><![CDATA[D4C27D211DF9416DA498EEFB6C008B7B]]></AD_COLUMN_ID>
 <!--D4C27D211DF9416DA498EEFB6C008B7B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -9747,6 +10115,41 @@
 <!--E206BFA90CC94498B257BC65C516B9C5-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--E206BFA90CC94498B257BC65C516B9C5--></AD_COLUMN>
 
+<!--E297E8C56BE84A64B46CD1439A93CDF9--><AD_COLUMN>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <AD_COLUMN_ID><![CDATA[E297E8C56BE84A64B46CD1439A93CDF9]]></AD_COLUMN_ID>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <NAME><![CDATA[Business Partner]]></NAME>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <DESCRIPTION><![CDATA[Anyone who takes part in daily business operations by acting as a customer, employee, etc.]]></DESCRIPTION>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <HELP><![CDATA[A Business Partner is anyone with whom you transact.  This can include a customer, vendor, employee or any combination of these.]]></HELP>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <COLUMNNAME><![CDATA[c_bpartner_id]]></COLUMNNAME>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <AD_REFERENCE_VALUE_ID><![CDATA[138]]></AD_REFERENCE_VALUE_ID>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <AD_ELEMENT_ID><![CDATA[187]]></AD_ELEMENT_ID>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--E297E8C56BE84A64B46CD1439A93CDF9-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--E297E8C56BE84A64B46CD1439A93CDF9--></AD_COLUMN>
+
 <!--E3E034DC47244E1B9D20971FDAE3F453--><AD_COLUMN>
 <!--E3E034DC47244E1B9D20971FDAE3F453-->  <AD_COLUMN_ID><![CDATA[E3E034DC47244E1B9D20971FDAE3F453]]></AD_COLUMN_ID>
 <!--E3E034DC47244E1B9D20971FDAE3F453-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml	Tue Aug 19 12:29:16 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml	Tue Aug 19 17:23:18 2014 +0200
@@ -1394,6 +1394,18 @@
 <!--F1D81ADE47094291B577E6B10B2B95E4-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--F1D81ADE47094291B577E6B10B2B95E4--></AD_ELEMENT>
 
+<!--F2859342BF064E72AE57CA4E2E448EC0--><AD_ELEMENT>
+<!--F2859342BF064E72AE57CA4E2E448EC0-->  <AD_ELEMENT_ID><![CDATA[F2859342BF064E72AE57CA4E2E448EC0]]></AD_ELEMENT_ID>
+<!--F2859342BF064E72AE57CA4E2E448EC0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F2859342BF064E72AE57CA4E2E448EC0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F2859342BF064E72AE57CA4E2E448EC0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F2859342BF064E72AE57CA4E2E448EC0-->  <COLUMNNAME><![CDATA[candidates]]></COLUMNNAME>
+<!--F2859342BF064E72AE57CA4E2E448EC0-->  <NAME><![CDATA[Candidates]]></NAME>
+<!--F2859342BF064E72AE57CA4E2E448EC0-->  <PRINTNAME><![CDATA[Candidates]]></PRINTNAME>
+<!--F2859342BF064E72AE57CA4E2E448EC0-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--F2859342BF064E72AE57CA4E2E448EC0-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--F2859342BF064E72AE57CA4E2E448EC0--></AD_ELEMENT>
+
 <!--F3ABC3F6561D43CF8C08E69212487ECE--><AD_ELEMENT>
 <!--F3ABC3F6561D43CF8C08E69212487ECE-->  <AD_ELEMENT_ID><![CDATA[F3ABC3F6561D43CF8C08E69212487ECE]]></AD_ELEMENT_ID>
 <!--F3ABC3F6561D43CF8C08E69212487ECE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml	Tue Aug 19 12:29:16 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml	Tue Aug 19 17:23:18 2014 +0200
@@ -3029,6 +3029,34 @@
 <!--2FF77BE337D74C23BE0AF89A815C2FD3-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--2FF77BE337D74C23BE0AF89A815C2FD3--></AD_FIELD>
 
+<!--3051C28FEDA14C34B17B95922DDD5E1F--><AD_FIELD>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <AD_FIELD_ID><![CDATA[3051C28FEDA14C34B17B95922DDD5E1F]]></AD_FIELD_ID>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <NAME><![CDATA[Business Partner]]></NAME>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <DESCRIPTION><![CDATA[Anyone who takes part in daily business operations by acting as a customer, employee, etc.]]></DESCRIPTION>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <HELP><![CDATA[A Business Partner is anyone with whom you transact.  This can include a customer, vendor, employee or any combination of these.]]></HELP>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <AD_TAB_ID><![CDATA[5BDDC298B6944AA6942DD2868D1AF6EB]]></AD_TAB_ID>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <AD_COLUMN_ID><![CDATA[E297E8C56BE84A64B46CD1439A93CDF9]]></AD_COLUMN_ID>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <SEQNO><![CDATA[20]]></SEQNO>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--3051C28FEDA14C34B17B95922DDD5E1F-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--3051C28FEDA14C34B17B95922DDD5E1F--></AD_FIELD>
+
 <!--315521157B374B5480E1C2B65710EC88--><AD_FIELD>
 <!--315521157B374B5480E1C2B65710EC88-->  <AD_FIELD_ID><![CDATA[315521157B374B5480E1C2B65710EC88]]></AD_FIELD_ID>
 <!--315521157B374B5480E1C2B65710EC88-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -4409,6 +4437,36 @@
 <!--40289C1D2E1298CF012E12F26EB1010A-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--40289C1D2E1298CF012E12F26EB1010A--></AD_FIELD>
 
+<!--412FC46C28A442E6A42CE169C40C54B9--><AD_FIELD>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <AD_FIELD_ID><![CDATA[412FC46C28A442E6A42CE169C40C54B9]]></AD_FIELD_ID>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <NAME><![CDATA[Active]]></NAME>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <DESCRIPTION><![CDATA[A flag indicating whether this record is available for use or de-activated.]]></DESCRIPTION>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <HELP><![CDATA[There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records: 
+(1) The system requires the record for auditing purposes.
+(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.]]></HELP>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <AD_TAB_ID><![CDATA[5BDDC298B6944AA6942DD2868D1AF6EB]]></AD_TAB_ID>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <AD_COLUMN_ID><![CDATA[77A46591A67E4CE491C01F33865C87FB]]></AD_COLUMN_ID>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--412FC46C28A442E6A42CE169C40C54B9-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--412FC46C28A442E6A42CE169C40C54B9--></AD_FIELD>
+
 <!--415EA1A7A7084D1485CC4413DAC73458--><AD_FIELD>
 <!--415EA1A7A7084D1485CC4413DAC73458-->  <AD_FIELD_ID><![CDATA[415EA1A7A7084D1485CC4413DAC73458]]></AD_FIELD_ID>
 <!--415EA1A7A7084D1485CC4413DAC73458-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -7459,6 +7517,33 @@
 <!--6C7C6E2543B543AFA1171C12D356CC38-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--6C7C6E2543B543AFA1171C12D356CC38--></AD_FIELD>
 
+<!--6CA56FDAA683479D969CAFD341A78600--><AD_FIELD>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <AD_FIELD_ID><![CDATA[6CA56FDAA683479D969CAFD341A78600]]></AD_FIELD_ID>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <NAME><![CDATA[Client]]></NAME>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <DESCRIPTION><![CDATA[Client for this installation.]]></DESCRIPTION>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <HELP><![CDATA[A Client is a company or a legal entity. You cannot share data between Clients.]]></HELP>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <AD_TAB_ID><![CDATA[5BDDC298B6944AA6942DD2868D1AF6EB]]></AD_TAB_ID>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <AD_COLUMN_ID><![CDATA[78918F4C85454FD5AA4D8FBC818F73D2]]></AD_COLUMN_ID>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--6CA56FDAA683479D969CAFD341A78600-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--6CA56FDAA683479D969CAFD341A78600--></AD_FIELD>
+
 <!--6CF8A431D2F84F4BB1428D0595EA9C74--><AD_FIELD>
 <!--6CF8A431D2F84F4BB1428D0595EA9C74-->  <AD_FIELD_ID><![CDATA[6CF8A431D2F84F4BB1428D0595EA9C74]]></AD_FIELD_ID>
 <!--6CF8A431D2F84F4BB1428D0595EA9C74-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -8158,6 +8243,33 @@
 <!--797FE216F70D4B318CEB1FE6C1EA7B5E-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--797FE216F70D4B318CEB1FE6C1EA7B5E--></AD_FIELD>
 
+<!--79A4CEEC89F54403BF9030AF18EE22B1--><AD_FIELD>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <AD_FIELD_ID><![CDATA[79A4CEEC89F54403BF9030AF18EE22B1]]></AD_FIELD_ID>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <NAME><![CDATA[Affinity]]></NAME>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <AD_TAB_ID><![CDATA[5BDDC298B6944AA6942DD2868D1AF6EB]]></AD_TAB_ID>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <AD_COLUMN_ID><![CDATA[49E83F583D6A4FBE8417F2742A4CAB46]]></AD_COLUMN_ID>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <DISPLAYLENGTH><![CDATA[3]]></DISPLAYLENGTH>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <CLIENTCLASS><![CDATA[OBLevelImg {"valuesList":["NO", "dummy1", "AP", "dummy3", "AU"]}]]></CLIENTCLASS>
+<!--79A4CEEC89F54403BF9030AF18EE22B1-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--79A4CEEC89F54403BF9030AF18EE22B1--></AD_FIELD>
+
 <!--7A169944D6C3486EBB925F5C3E5F9830--><AD_FIELD>
 <!--7A169944D6C3486EBB925F5C3E5F9830-->  <AD_FIELD_ID><![CDATA[7A169944D6C3486EBB925F5C3E5F9830]]></AD_FIELD_ID>
 <!--7A169944D6C3486EBB925F5C3E5F9830-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -12325,6 +12437,32 @@
 <!--9291D83BEDAC4FBD87042F6FC1C6C7B4-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--9291D83BEDAC4FBD87042F6FC1C6C7B4--></AD_FIELD>
 
+<!--92B561ADF6C34DC4B06FF12ECE280047--><AD_FIELD>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <AD_FIELD_ID><![CDATA[92B561ADF6C34DC4B06FF12ECE280047]]></AD_FIELD_ID>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <NAME><![CDATA[id]]></NAME>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <AD_TAB_ID><![CDATA[5BDDC298B6944AA6942DD2868D1AF6EB]]></AD_TAB_ID>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <AD_COLUMN_ID><![CDATA[CFCAE42083044B9AA6862205BCD2BD0B]]></AD_COLUMN_ID>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <DISPLAYLENGTH><![CDATA[0]]></DISPLAYLENGTH>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <SEQNO><![CDATA[40]]></SEQNO>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--92B561ADF6C34DC4B06FF12ECE280047-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--92B561ADF6C34DC4B06FF12ECE280047--></AD_FIELD>
+
 <!--94246C150887416DBFD264F09EE0EEA6--><AD_FIELD>
 <!--94246C150887416DBFD264F09EE0EEA6-->  <AD_FIELD_ID><![CDATA[94246C150887416DBFD264F09EE0EEA6]]></AD_FIELD_ID>
 <!--94246C150887416DBFD264F09EE0EEA6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -18329,6 +18467,34 @@
 <!--CB9B7A7C9AB845E299BA3385935C33B5-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--CB9B7A7C9AB845E299BA3385935C33B5--></AD_FIELD>
 
+<!--CBD105AD24C441FD85F9B3DC5AC2819D--><AD_FIELD>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <AD_FIELD_ID><![CDATA[CBD105AD24C441FD85F9B3DC5AC2819D]]></AD_FIELD_ID>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <NAME><![CDATA[Organization]]></NAME>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <DESCRIPTION><![CDATA[Organizational entity within client]]></DESCRIPTION>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <HELP><![CDATA[An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.]]></HELP>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <AD_TAB_ID><![CDATA[5BDDC298B6944AA6942DD2868D1AF6EB]]></AD_TAB_ID>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <AD_COLUMN_ID><![CDATA[32595588E533456BBCCCEA2F2B2235C1]]></AD_COLUMN_ID>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--CBD105AD24C441FD85F9B3DC5AC2819D--></AD_FIELD>
+
 <!--CBF872363CCC4F6BA39996C23C9E2E79--><AD_FIELD>
 <!--CBF872363CCC4F6BA39996C23C9E2E79-->  <AD_FIELD_ID><![CDATA[CBF872363CCC4F6BA39996C23C9E2E79]]></AD_FIELD_ID>
 <!--CBF872363CCC4F6BA39996C23C9E2E79-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -20480,6 +20646,32 @@
 <!--EE7FC2EB831145CA9D1B48C209CCB581-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--EE7FC2EB831145CA9D1B48C209CCB581--></AD_FIELD>
 
+<!--F15766DD1B8347C69992805F41FCEBF5--><AD_FIELD>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <AD_FIELD_ID><![CDATA[F15766DD1B8347C69992805F41FCEBF5]]></AD_FIELD_ID>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <NAME><![CDATA[Amount]]></NAME>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <AD_TAB_ID><![CDATA[5BDDC298B6944AA6942DD2868D1AF6EB]]></AD_TAB_ID>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <AD_COLUMN_ID><![CDATA[B31F203A1F1E46B496924F71684DBD9D]]></AD_COLUMN_ID>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--F15766DD1B8347C69992805F41FCEBF5-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--F15766DD1B8347C69992805F41FCEBF5--></AD_FIELD>
+
 <!--F183507AF521490292E8E31141D1610E--><AD_FIELD>
 <!--F183507AF521490292E8E31141D1610E-->  <AD_FIELD_ID><![CDATA[F183507AF521490292E8E31141D1610E]]></AD_FIELD_ID>
 <!--F183507AF521490292E8E31141D1610E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -20957,6 +21149,32 @@
 <!--F6B85BC485464404B0A58105D8D38B61-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--F6B85BC485464404B0A58105D8D38B61--></AD_FIELD>
 
+<!--F734811D3120487B8E122C91307AC077--><AD_FIELD>
+<!--F734811D3120487B8E122C91307AC077-->  <AD_FIELD_ID><![CDATA[F734811D3120487B8E122C91307AC077]]></AD_FIELD_ID>
+<!--F734811D3120487B8E122C91307AC077-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F734811D3120487B8E122C91307AC077-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F734811D3120487B8E122C91307AC077-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F734811D3120487B8E122C91307AC077-->  <NAME><![CDATA[Date]]></NAME>
+<!--F734811D3120487B8E122C91307AC077-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--F734811D3120487B8E122C91307AC077-->  <AD_TAB_ID><![CDATA[5BDDC298B6944AA6942DD2868D1AF6EB]]></AD_TAB_ID>
+<!--F734811D3120487B8E122C91307AC077-->  <AD_COLUMN_ID><![CDATA[82BB3A1CA1E14094B799659BE81A7E6C]]></AD_COLUMN_ID>
+<!--F734811D3120487B8E122C91307AC077-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--F734811D3120487B8E122C91307AC077-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--F734811D3120487B8E122C91307AC077-->  <DISPLAYLENGTH><![CDATA[19]]></DISPLAYLENGTH>
+<!--F734811D3120487B8E122C91307AC077-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
+<!--F734811D3120487B8E122C91307AC077-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--F734811D3120487B8E122C91307AC077-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--F734811D3120487B8E122C91307AC077-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--F734811D3120487B8E122C91307AC077-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--F734811D3120487B8E122C91307AC077-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--F734811D3120487B8E122C91307AC077-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--F734811D3120487B8E122C91307AC077-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--F734811D3120487B8E122C91307AC077-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--F734811D3120487B8E122C91307AC077-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--F734811D3120487B8E122C91307AC077-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--F734811D3120487B8E122C91307AC077-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--F734811D3120487B8E122C91307AC077--></AD_FIELD>
+
 <!--F83BE4C9F07A4BFD8C0B7723BCAA2641--><AD_FIELD>
 <!--F83BE4C9F07A4BFD8C0B7723BCAA2641-->  <AD_FIELD_ID><![CDATA[F83BE4C9F07A4BFD8C0B7723BCAA2641]]></AD_FIELD_ID>
 <!--F83BE4C9F07A4BFD8C0B7723BCAA2641-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml	Tue Aug 19 12:29:16 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml	Tue Aug 19 17:23:18 2014 +0200
@@ -108,6 +108,18 @@
 <!--414E5DD3A1304C7781FB856A6872F428-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--414E5DD3A1304C7781FB856A6872F428--></AD_REFERENCE>
 
+<!--4386AB37DEF94AEF90D118895C0A37D8--><AD_REFERENCE>
+<!--4386AB37DEF94AEF90D118895C0A37D8-->  <AD_REFERENCE_ID><![CDATA[4386AB37DEF94AEF90D118895C0A37D8]]></AD_REFERENCE_ID>
+<!--4386AB37DEF94AEF90D118895C0A37D8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--4386AB37DEF94AEF90D118895C0A37D8-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--4386AB37DEF94AEF90D118895C0A37D8-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--4386AB37DEF94AEF90D118895C0A37D8-->  <NAME><![CDATA[Candidates P&E]]></NAME>
+<!--4386AB37DEF94AEF90D118895C0A37D8-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--4386AB37DEF94AEF90D118895C0A37D8-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--4386AB37DEF94AEF90D118895C0A37D8-->  <PARENTREFERENCE_ID><![CDATA[FF80818132D8F0F30132D9BC395D0038]]></PARENTREFERENCE_ID>
+<!--4386AB37DEF94AEF90D118895C0A37D8-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--4386AB37DEF94AEF90D118895C0A37D8--></AD_REFERENCE>
+
 <!--4BD88BC3C76C44F09F01AD56D3604D02--><AD_REFERENCE>
 <!--4BD88BC3C76C44F09F01AD56D3604D02-->  <AD_REFERENCE_ID><![CDATA[4BD88BC3C76C44F09F01AD56D3604D02]]></AD_REFERENCE_ID>
 <!--4BD88BC3C76C44F09F01AD56D3604D02-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml	Tue Aug 19 12:29:16 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml	Tue Aug 19 17:23:18 2014 +0200
@@ -202,6 +202,35 @@
 <!--5B9941AC1F6A4529A76FCA7CDA0A7D7A-->  <EM_OBUIAPP_SHOW_SELECT><![CDATA[Y]]></EM_OBUIAPP_SHOW_SELECT>
 <!--5B9941AC1F6A4529A76FCA7CDA0A7D7A--></AD_TAB>
 
+<!--5BDDC298B6944AA6942DD2868D1AF6EB--><AD_TAB>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <AD_TAB_ID><![CDATA[5BDDC298B6944AA6942DD2868D1AF6EB]]></AD_TAB_ID>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <NAME><![CDATA[Candidates]]></NAME>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <AD_WINDOW_ID><![CDATA[87EB966E5F1945369FBBB36368B49D74]]></AD_WINDOW_ID>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <TABLEVEL><![CDATA[0]]></TABLEVEL>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <ISSINGLEROW><![CDATA[N]]></ISSINGLEROW>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <ISINFOTAB><![CDATA[N]]></ISINFOTAB>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <ISTRANSLATIONTAB><![CDATA[N]]></ISTRANSLATIONTAB>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <HASTREE><![CDATA[N]]></HASTREE>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <PROCESSING><![CDATA[N]]></PROCESSING>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <IMPORTFIELDS><![CDATA[N]]></IMPORTFIELDS>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <ISSORTTAB><![CDATA[N]]></ISSORTTAB>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <UIPATTERN><![CDATA[RO]]></UIPATTERN>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <DISABLE_PARENT_KEY_PROPERTY><![CDATA[N]]></DISABLE_PARENT_KEY_PROPERTY>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <ISREADONLYTREE><![CDATA[N]]></ISREADONLYTREE>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <ISSHOWTREENODEICONS><![CDATA[Y]]></ISSHOWTREENODEICONS>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB-->  <EM_OBUIAPP_SHOW_SELECT><![CDATA[Y]]></EM_OBUIAPP_SHOW_SELECT>
+<!--5BDDC298B6944AA6942DD2868D1AF6EB--></AD_TAB>
+
 <!--60825C9E68644DBC9C530DDCABE05A6E--><AD_TAB>
 <!--60825C9E68644DBC9C530DDCABE05A6E-->  <AD_TAB_ID><![CDATA[60825C9E68644DBC9C530DDCABE05A6E]]></AD_TAB_ID>
 <!--60825C9E68644DBC9C530DDCABE05A6E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml	Tue Aug 19 12:29:16 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml	Tue Aug 19 17:23:18 2014 +0200
@@ -142,6 +142,29 @@
 <!--5AAFAB80FB6740D2A6190CB3939D90EC-->  <ISTREE><![CDATA[N]]></ISTREE>
 <!--5AAFAB80FB6740D2A6190CB3939D90EC--></AD_TABLE>
 
+<!--85DA470A6BB3479E955D88C136EEC8A3--><AD_TABLE>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <AD_TABLE_ID><![CDATA[85DA470A6BB3479E955D88C136EEC8A3]]></AD_TABLE_ID>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <NAME><![CDATA[APRM_Candidates_DS]]></NAME>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <TABLENAME><![CDATA[APRM_Candidates_DS]]></TABLENAME>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <ISVIEW><![CDATA[N]]></ISVIEW>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <ACCESSLEVEL><![CDATA[1]]></ACCESSLEVEL>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <AD_WINDOW_ID><![CDATA[87EB966E5F1945369FBBB36368B49D74]]></AD_WINDOW_ID>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <ISSECURITYENABLED><![CDATA[N]]></ISSECURITYENABLED>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <ISDELETEABLE><![CDATA[N]]></ISDELETEABLE>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <ISHIGHVOLUME><![CDATA[N]]></ISHIGHVOLUME>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <IMPORTTABLE><![CDATA[N]]></IMPORTTABLE>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <ISCHANGELOG><![CDATA[N]]></ISCHANGELOG>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <AD_PACKAGE_ID><![CDATA[AC33B2262748414A816510545755435A]]></AD_PACKAGE_ID>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <DATAORIGINTYPE><![CDATA[Datasource]]></DATAORIGINTYPE>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <OBSERDS_DATASOURCE_ID><![CDATA[5FC254F7AAFF49C4B60E06B541DADB57]]></OBSERDS_DATASOURCE_ID>
+<!--85DA470A6BB3479E955D88C136EEC8A3-->  <ISTREE><![CDATA[N]]></ISTREE>
+<!--85DA470A6BB3479E955D88C136EEC8A3--></AD_TABLE>
+
 <!--864A35C8FCD548B0AD1D69C89BBA6118--><AD_TABLE>
 <!--864A35C8FCD548B0AD1D69C89BBA6118-->  <AD_TABLE_ID><![CDATA[864A35C8FCD548B0AD1D69C89BBA6118]]></AD_TABLE_ID>
 <!--864A35C8FCD548B0AD1D69C89BBA6118-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_WINDOW.xml	Tue Aug 19 12:29:16 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_WINDOW.xml	Tue Aug 19 17:23:18 2014 +0200
@@ -100,6 +100,21 @@
 <!--81BAC97FE7754C669254C9CF4FA20292-->  <ISADVANCEDFEATURE><![CDATA[N]]></ISADVANCEDFEATURE>
 <!--81BAC97FE7754C669254C9CF4FA20292--></AD_WINDOW>
 
+<!--87EB966E5F1945369FBBB36368B49D74--><AD_WINDOW>
+<!--87EB966E5F1945369FBBB36368B49D74-->  <AD_WINDOW_ID><![CDATA[87EB966E5F1945369FBBB36368B49D74]]></AD_WINDOW_ID>
+<!--87EB966E5F1945369FBBB36368B49D74-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--87EB966E5F1945369FBBB36368B49D74-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--87EB966E5F1945369FBBB36368B49D74-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--87EB966E5F1945369FBBB36368B49D74-->  <NAME><![CDATA[Candidates]]></NAME>
+<!--87EB966E5F1945369FBBB36368B49D74-->  <WINDOWTYPE><![CDATA[OBUIAPP_PickAndExecute]]></WINDOWTYPE>
+<!--87EB966E5F1945369FBBB36368B49D74-->  <ISSOTRX><![CDATA[Y]]></ISSOTRX>
+<!--87EB966E5F1945369FBBB36368B49D74-->  <PROCESSING><![CDATA[N]]></PROCESSING>
+<!--87EB966E5F1945369FBBB36368B49D74-->  <ISDEFAULT><![CDATA[N]]></ISDEFAULT>
+<!--87EB966E5F1945369FBBB36368B49D74-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--87EB966E5F1945369FBBB36368B49D74-->  <ISTHREADSAFE><![CDATA[N]]></ISTHREADSAFE>
+<!--87EB966E5F1945369FBBB36368B49D74-->  <ISADVANCEDFEATURE><![CDATA[N]]></ISADVANCEDFEATURE>
+<!--87EB966E5F1945369FBBB36368B49D74--></AD_WINDOW>
+
 <!--C57DED2495184380AFBAAA3CA720C3DA--><AD_WINDOW>
 <!--C57DED2495184380AFBAAA3CA720C3DA-->  <AD_WINDOW_ID><![CDATA[C57DED2495184380AFBAAA3CA720C3DA]]></AD_WINDOW_ID>
 <!--C57DED2495184380AFBAAA3CA720C3DA-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBSERDS_DATASOURCE.xml	Tue Aug 19 17:23:18 2014 +0200
@@ -0,0 +1,15 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--5FC254F7AAFF49C4B60E06B541DADB57--><OBSERDS_DATASOURCE>
+<!--5FC254F7AAFF49C4B60E06B541DADB57-->  <OBSERDS_DATASOURCE_ID><![CDATA[5FC254F7AAFF49C4B60E06B541DADB57]]></OBSERDS_DATASOURCE_ID>
+<!--5FC254F7AAFF49C4B60E06B541DADB57-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5FC254F7AAFF49C4B60E06B541DADB57-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5FC254F7AAFF49C4B60E06B541DADB57-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--5FC254F7AAFF49C4B60E06B541DADB57-->  <NAME><![CDATA[CandidatesDatasource]]></NAME>
+<!--5FC254F7AAFF49C4B60E06B541DADB57-->  <CLASSNAME><![CDATA[org.openbravo.advpaymentmngt.datasource.CandidatesDatasource]]></CLASSNAME>
+<!--5FC254F7AAFF49C4B60E06B541DADB57-->  <OBCLKER_TEMPLATE_ID><![CDATA[2BAD445C2A0343C58E455F9BD379C690]]></OBCLKER_TEMPLATE_ID>
+<!--5FC254F7AAFF49C4B60E06B541DADB57-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5FC254F7AAFF49C4B60E06B541DADB57-->  <USEASTABLEDATAORIGIN><![CDATA[Y]]></USEASTABLEDATAORIGIN>
+<!--5FC254F7AAFF49C4B60E06B541DADB57--></OBSERDS_DATASOURCE>
+
+</data>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml	Tue Aug 19 12:29:16 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml	Tue Aug 19 17:23:18 2014 +0200
@@ -1403,6 +1403,29 @@
 <!--BC5E638E184C4F3AB36B9DA574E0E8BB-->  <DISPLAYTITLE><![CDATA[N]]></DISPLAYTITLE>
 <!--BC5E638E184C4F3AB36B9DA574E0E8BB--></OBUIAPP_PARAMETER>
 
+<!--BF986A21D4FC4692AA9368CB0BDE1A54--><OBUIAPP_PARAMETER>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <OBUIAPP_PARAMETER_ID><![CDATA[BF986A21D4FC4692AA9368CB0BDE1A54]]></OBUIAPP_PARAMETER_ID>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <NAME><![CDATA[Candidates]]></NAME>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <AD_REFERENCE_ID><![CDATA[FF80818132D8F0F30132D9BC395D0038]]></AD_REFERENCE_ID>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <AD_REFERENCE_VALUE_ID><![CDATA[4386AB37DEF94AEF90D118895C0A37D8]]></AD_REFERENCE_VALUE_ID>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <COLUMNNAME><![CDATA[candidates]]></COLUMNNAME>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <FIELDLENGTH><![CDATA[0]]></FIELDLENGTH>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <AD_ELEMENT_ID><![CDATA[F2859342BF064E72AE57CA4E2E448EC0]]></AD_ELEMENT_ID>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <ISFIXED><![CDATA[N]]></ISFIXED>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <EVALUATEFIXEDVALUE><![CDATA[N]]></EVALUATEFIXEDVALUE>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <OBUIAPP_PROCESS_ID><![CDATA[F2B2DB751AF245D3A5DF28EE00EF2685]]></OBUIAPP_PROCESS_ID>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <STARTINNEWLINE><![CDATA[N]]></STARTINNEWLINE>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <DISPLAYEDROWS><![CDATA[5]]></DISPLAYEDROWS>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54-->  <DISPLAYTITLE><![CDATA[N]]></DISPLAYTITLE>
+<!--BF986A21D4FC4692AA9368CB0BDE1A54--></OBUIAPP_PARAMETER>
+
 <!--C0BB1F1D542A41DC9FE160E3A19CADC9--><OBUIAPP_PARAMETER>
 <!--C0BB1F1D542A41DC9FE160E3A19CADC9-->  <OBUIAPP_PARAMETER_ID><![CDATA[C0BB1F1D542A41DC9FE160E3A19CADC9]]></OBUIAPP_PARAMETER_ID>
 <!--C0BB1F1D542A41DC9FE160E3A19CADC9-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUIAPP_REF_WINDOW.xml	Tue Aug 19 12:29:16 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUIAPP_REF_WINDOW.xml	Tue Aug 19 17:23:18 2014 +0200
@@ -63,4 +63,13 @@
 <!--98B655EC65BF4D669F3474F07CF22131-->  <AD_WINDOW_ID><![CDATA[C57DED2495184380AFBAAA3CA720C3DA]]></AD_WINDOW_ID>
 <!--98B655EC65BF4D669F3474F07CF22131--></OBUIAPP_REF_WINDOW>
 
+<!--AAE7153E4281430B97096227FAD8BE99--><OBUIAPP_REF_WINDOW>
+<!--AAE7153E4281430B97096227FAD8BE99-->  <OBUIAPP_REF_WINDOW_ID><![CDATA[AAE7153E4281430B97096227FAD8BE99]]></OBUIAPP_REF_WINDOW_ID>
+<!--AAE7153E4281430B97096227FAD8BE99-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--AAE7153E4281430B97096227FAD8BE99-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--AAE7153E4281430B97096227FAD8BE99-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--AAE7153E4281430B97096227FAD8BE99-->  <AD_REFERENCE_ID><![CDATA[4386AB37DEF94AEF90D118895C0A37D8]]></AD_REFERENCE_ID>
+<!--AAE7153E4281430B97096227FAD8BE99-->  <AD_WINDOW_ID><![CDATA[87EB966E5F1945369FBBB36368B49D74]]></AD_WINDOW_ID>
+<!--AAE7153E4281430B97096227FAD8BE99--></OBUIAPP_REF_WINDOW>
+
 </data>
--- a/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/algorithm/StandardMatchingCandidatesAlgorithm.java	Tue Aug 19 12:29:16 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/algorithm/StandardMatchingCandidatesAlgorithm.java	Tue Aug 19 17:23:18 2014 +0200
@@ -21,11 +21,14 @@
 
 import java.math.BigDecimal;
 import java.util.ArrayList;
-import java.util.HashSet;
 import java.util.Iterator;
 import java.util.List;
 import java.util.Set;
 
+import org.hibernate.Query;
+import org.hibernate.ScrollMode;
+import org.hibernate.ScrollableResults;
+import org.hibernate.Session;
 import org.openbravo.advpaymentmngt.dao.MatchTransactionDao;
 import org.openbravo.advpaymentmngt.utility.FIN_CandidateRecord;
 import org.openbravo.advpaymentmngt.utility.FIN_MatchingCandidatesAlgorithm_I;
@@ -64,11 +67,9 @@
     final List<Object> parameters = new ArrayList<Object>();
     BigDecimal amount = line.getCramount().subtract(line.getDramount());
     boolean isReceipt = amount.signum() > 0;
-    // FIXME: added to access the FIN_PaymentSchedule and FIN_PaymentScheduleDetail tables to be
-    // removed when new security implementation is done
-    OBContext.setAdminMode();
+    OBContext.setAdminMode(true);
+    ScrollableResults scrollLines = null;
     try {
-
       whereClause.append(" as p "); // pending payments //
       whereClause.append(" where not exists ");
       whereClause
@@ -124,13 +125,22 @@
 
       obqPayment.setParameters(parameters);
 
-      // TODO use Scrollable
       final List<FIN_CandidateRecord> candidateRecords = new ArrayList<FIN_CandidateRecord>();
-      for (final FIN_Payment paymentCandidate : obqPayment.list()) {
+      scrollLines = obqPayment.scroll(ScrollMode.FORWARD_ONLY);
+      int j = 1;
+      while (scrollLines.next()) {
+        final FIN_Payment paymentCandidate = (FIN_Payment) scrollLines.get(0);
         candidateRecords.add(new FIN_CandidateRecord(paymentCandidate));
+        if (j % 100 == 0) {
+          OBDal.getInstance().getSession().clear();
+        }
+        j++;
       }
       return candidateRecords;
     } finally {
+      if (scrollLines != null) {
+        scrollLines.close();
+      }
       OBContext.restorePreviousMode();
     }
   }
@@ -138,59 +148,68 @@
   @Override
   public List<FIN_CandidateRecord> getInvoiceCandidates(FIN_BankStatementLine line,
       List<Invoice> excluded) {
-    final StringBuilder whereClause = new StringBuilder();
+    final StringBuilder hql = new StringBuilder();
     final List<Object> parameters = new ArrayList<Object>();
     BigDecimal amount = line.getCramount().subtract(line.getDramount());
     boolean isReceipt = amount.signum() > 0;
-    // FIXME: added to access the FIN_PaymentSchedule and FIN_PaymentScheduleDetail tables to be
-    // removed when new security implementation is done
-    OBContext.setAdminMode();
+    OBContext.setAdminMode(true);
+    ScrollableResults scrollLines = null;
     try {
+      hql.append(" select distinct(i.id) ");
 
-      whereClause.append(" as psd "); // pending scheduled payments //
-      whereClause.append(" left outer join psd.invoicePaymentSchedule as psdi");
-      whereClause.append(" left outer join psdi.invoice ");
-      whereClause.append(" where psd.");
-      whereClause.append(FIN_PaymentScheduleDetail.PROPERTY_PAYMENTDETAILS);
-      whereClause.append(" is null");
-      whereClause.append(" and psd.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_ORGANIZATION);
-      whereClause.append(".id in (");
-      whereClause.append(parse(OBContext.getOBContext().getOrganizationStructureProvider()
+      // hql.append(" psdi.");
+      // hql.append(FIN_PaymentSchedule.PROPERTY_FINPAYMENTPRIORITY);
+      // hql.append(", psdi.");
+      // hql.append(FIN_PaymentSchedule.PROPERTY_DUEDATE);
+      // hql.append(", psdi.");
+      // hql.append(FIN_PaymentSchedule.PROPERTY_INVOICE);
+      // hql.append(".");
+      // hql.append(Invoice.PROPERTY_DOCUMENTNO);
+
+      hql.append(" from FIN_Payment_ScheduleDetail as psd "); // pending scheduled payments //
+      hql.append(" inner join psd.invoicePaymentSchedule as psdi");
+      hql.append(" inner join psdi.invoice as i ");
+      hql.append(" where psd.");
+      hql.append(FIN_PaymentScheduleDetail.PROPERTY_PAYMENTDETAILS);
+      hql.append(" is null");
+      hql.append(" and psd.");
+      hql.append(FIN_PaymentSchedule.PROPERTY_ORGANIZATION);
+      hql.append(".id in (");
+      hql.append(parse(OBContext.getOBContext().getOrganizationStructureProvider()
           .getNaturalTree(line.getOrganization().getId())));
-      whereClause.append(")");
+      hql.append(")");
 
       // Transaction type filter
-      whereClause.append(" and psdi.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_INVOICE);
-      whereClause.append(" is not null");
+      hql.append(" and psdi.");
+      hql.append(FIN_PaymentSchedule.PROPERTY_INVOICE);
+      hql.append(" is not null");
 
       if (line.getBusinessPartner() != null) {
-        whereClause.append(" and psdi.");
-        whereClause.append(FIN_PaymentSchedule.PROPERTY_INVOICE);
-        whereClause.append(".");
-        whereClause.append(Invoice.PROPERTY_BUSINESSPARTNER);
-        whereClause.append(".id = '");
-        whereClause.append(line.getBusinessPartner().getId());
-        whereClause.append("'");
+        hql.append(" and psdi.");
+        hql.append(FIN_PaymentSchedule.PROPERTY_INVOICE);
+        hql.append(".");
+        hql.append(Invoice.PROPERTY_BUSINESSPARTNER);
+        hql.append(".id = '");
+        hql.append(line.getBusinessPartner().getId());
+        hql.append("'");
       }
-      whereClause.append(" and psdi.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_INVOICE);
-      whereClause.append(".");
-      whereClause.append(Invoice.PROPERTY_SALESTRANSACTION);
-      whereClause.append(" = ");
-      whereClause.append(isReceipt);
-      whereClause.append(" and psdi.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_INVOICE);
-      whereClause.append(".");
-      whereClause.append(Invoice.PROPERTY_CURRENCY);
-      whereClause.append(".id = '");
-      whereClause.append(line.getBankStatement().getAccount().getCurrency().getId());
-      whereClause.append("'");
+      hql.append(" and psdi.");
+      hql.append(FIN_PaymentSchedule.PROPERTY_INVOICE);
+      hql.append(".");
+      hql.append(Invoice.PROPERTY_SALESTRANSACTION);
+      hql.append(" = ");
+      hql.append(isReceipt);
+      hql.append(" and psdi.");
+      hql.append(FIN_PaymentSchedule.PROPERTY_INVOICE);
+      hql.append(".");
+      hql.append(Invoice.PROPERTY_CURRENCY);
+      hql.append(".id = '");
+      hql.append(line.getBankStatement().getAccount().getCurrency().getId());
+      hql.append("'");
       // amount
-      whereClause.append(" and psdi.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_OUTSTANDINGAMOUNT);
-      whereClause.append(" = ?");
+      hql.append(" and psdi.");
+      hql.append(FIN_PaymentSchedule.PROPERTY_OUTSTANDINGAMOUNT);
+      hql.append(" = ?");
       parameters.add(amount.abs());
       // dateTo
       // TODO Review this date. i guess someone can pay a bill prior to due date
@@ -202,93 +221,99 @@
       // parameters.add(line.getTransactionDate());
       // TODO: Add order to show first scheduled payments from invoices and later scheduled payments
       // from not invoiced orders.
-      whereClause.append(" order by");
-      whereClause.append(" psdi.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_FINPAYMENTPRIORITY);
-      whereClause.append(", psdi.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_DUEDATE);
-      whereClause.append(", psdi.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_INVOICE);
-      whereClause.append(".");
-      whereClause.append(Invoice.PROPERTY_DOCUMENTNO);
-      final OBQuery<FIN_PaymentScheduleDetail> obqPSD = OBDal.getInstance().createQuery(
-          FIN_PaymentScheduleDetail.class, whereClause.toString());
+      // hql.append(" order by");
+      // hql.append(" psdi.");
+      // hql.append(FIN_PaymentSchedule.PROPERTY_FINPAYMENTPRIORITY);
+      // hql.append(", psdi.");
+      // hql.append(FIN_PaymentSchedule.PROPERTY_DUEDATE);
+      // hql.append(", psdi.");
+      // hql.append(FIN_PaymentSchedule.PROPERTY_INVOICE);
+      // hql.append(".");
+      // hql.append(Invoice.PROPERTY_DOCUMENTNO);
 
-      obqPSD.setParameters(parameters);
+      final Session session = OBDal.getInstance().getSession();
+      final Query query = session.createQuery(hql.toString());
+      for (int i = 0; i < parameters.size(); i++) {
+        query.setParameter(i, parameters.get(i));
+      }
 
-      // TODO get invoices and use Scrollable
       final List<FIN_CandidateRecord> candidateRecords = new ArrayList<FIN_CandidateRecord>();
-      final Set<Invoice> invoices = new HashSet<Invoice>();
-      for (final FIN_PaymentScheduleDetail psd : obqPSD.list()) {
-        invoices.add(psd.getInvoicePaymentSchedule().getInvoice());
-      }
-      for (final Invoice invoice : invoices) {
-        candidateRecords.add(new FIN_CandidateRecord(invoice));
+      scrollLines = query.scroll(ScrollMode.FORWARD_ONLY);
+      int j = 1;
+      while (scrollLines.next()) {
+        final String invoiceId = scrollLines.getString(0);
+        candidateRecords.add(new FIN_CandidateRecord(OBDal.getInstance().get(Invoice.class,
+            invoiceId)));
+        if (j % 100 == 0) {
+          session.clear();
+        }
+        j++;
       }
 
       return candidateRecords;
     } finally {
+      if (scrollLines != null) {
+        scrollLines.close();
+      }
       OBContext.restorePreviousMode();
     }
-
   }
 
   @Override
   public List<FIN_CandidateRecord> getOrderCandidates(FIN_BankStatementLine line,
       List<Order> excluded) {
-    final StringBuilder whereClause = new StringBuilder();
+    final StringBuilder hql = new StringBuilder();
     final List<Object> parameters = new ArrayList<Object>();
     BigDecimal amount = line.getCramount().subtract(line.getDramount());
     boolean isReceipt = amount.signum() > 0;
-    // FIXME: added to access the FIN_PaymentSchedule and FIN_PaymentScheduleDetail tables to be
-    // removed when new security implementation is done
-    OBContext.setAdminMode();
+    OBContext.setAdminMode(true);
+    ScrollableResults scrollLines = null;
     try {
-
-      whereClause.append(" as psd "); // pending scheduled payments //
-      whereClause.append(" left outer join psd.orderPaymentSchedule psdo");
-      whereClause.append(" left outer join psdo.order ");
-      whereClause.append(" where psd.");
-      whereClause.append(FIN_PaymentScheduleDetail.PROPERTY_PAYMENTDETAILS);
-      whereClause.append(" is null");
-      whereClause.append(" and psd.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_ORGANIZATION);
-      whereClause.append(".id in (");
-      whereClause.append(parse(OBContext.getOBContext().getOrganizationStructureProvider()
+      hql.append(" select distinct(o.id) ");
+      hql.append(" from FIN_Payment_ScheduleDetail as psd "); // pending scheduled payments //
+      hql.append(" inner join psd.orderPaymentSchedule psdo");
+      hql.append(" inner join psdo.order as o ");
+      hql.append(" where psd.");
+      hql.append(FIN_PaymentScheduleDetail.PROPERTY_PAYMENTDETAILS);
+      hql.append(" is null");
+      hql.append(" and psd.");
+      hql.append(FIN_PaymentSchedule.PROPERTY_ORGANIZATION);
+      hql.append(".id in (");
+      hql.append(parse(OBContext.getOBContext().getOrganizationStructureProvider()
           .getNaturalTree(line.getOrganization().getId())));
-      whereClause.append(")");
+      hql.append(")");
 
       // Transaction type filter
-      whereClause.append(" and psdo.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_ORDER);
-      whereClause.append(" is not null");
+      hql.append(" and psdo.");
+      hql.append(FIN_PaymentSchedule.PROPERTY_ORDER);
+      hql.append(" is not null");
 
       if (line.getBusinessPartner() != null) {
-        whereClause.append(" and psdo.");
-        whereClause.append(FIN_PaymentSchedule.PROPERTY_ORDER);
-        whereClause.append(".");
-        whereClause.append(Order.PROPERTY_BUSINESSPARTNER);
-        whereClause.append(".id = '");
-        whereClause.append(line.getBusinessPartner().getId());
-        whereClause.append("'");
+        hql.append(" and psdo.");
+        hql.append(FIN_PaymentSchedule.PROPERTY_ORDER);
+        hql.append(".");
+        hql.append(Order.PROPERTY_BUSINESSPARTNER);
+        hql.append(".id = '");
+        hql.append(line.getBusinessPartner().getId());
+        hql.append("'");
       }
-      whereClause.append(" and psdo.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_ORDER);
-      whereClause.append(".");
-      whereClause.append(Order.PROPERTY_SALESTRANSACTION);
-      whereClause.append(" = ");
-      whereClause.append(isReceipt);
-      whereClause.append(" and psdo.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_ORDER);
-      whereClause.append(".");
-      whereClause.append(Order.PROPERTY_CURRENCY);
-      whereClause.append(".id = '");
-      whereClause.append(line.getBankStatement().getAccount().getCurrency().getId());
-      whereClause.append("'");
+      hql.append(" and psdo.");
+      hql.append(FIN_PaymentSchedule.PROPERTY_ORDER);
+      hql.append(".");
+      hql.append(Order.PROPERTY_SALESTRANSACTION);
+      hql.append(" = ");
+      hql.append(isReceipt);
+      hql.append(" and psdo.");
+      hql.append(FIN_PaymentSchedule.PROPERTY_ORDER);
+      hql.append(".");
+      hql.append(Order.PROPERTY_CURRENCY);
+      hql.append(".id = '");
+      hql.append(line.getBankStatement().getAccount().getCurrency().getId());
+      hql.append("'");
       // amount
-      whereClause.append(" and psdo.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_OUTSTANDINGAMOUNT);
-      whereClause.append(" = ?");
+      hql.append(" and psdo.");
+      hql.append(FIN_PaymentSchedule.PROPERTY_OUTSTANDINGAMOUNT);
+      hql.append(" = ?");
       parameters.add(amount.abs());
       // dateTo
       // TODO Review this date. i guess someone can pay a bill prior to due date
@@ -300,33 +325,32 @@
       // parameters.add(line.getTransactionDate());
       // TODO: Add order to show first scheduled payments from invoices and later scheduled payments
       // from not invoiced orders.
-      whereClause.append(" order by");
-      whereClause.append(" psdo.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_FINPAYMENTPRIORITY);
-      whereClause.append(", psdo.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_DUEDATE);
-      whereClause.append(", psdo.");
-      whereClause.append(FIN_PaymentSchedule.PROPERTY_ORDER);
-      whereClause.append(".");
-      whereClause.append(Order.PROPERTY_DOCUMENTNO);
-      final OBQuery<FIN_PaymentScheduleDetail> obqPSD = OBDal.getInstance().createQuery(
-          FIN_PaymentScheduleDetail.class, whereClause.toString());
 
-      obqPSD.setParameters(parameters);
+      final Session session = OBDal.getInstance().getSession();
+      final Query query = session.createQuery(hql.toString());
+      for (int i = 0; i < parameters.size(); i++) {
+        query.setParameter(i, parameters.get(i));
+      }
 
-      // TODO get invoices and use Scrollable
       final List<FIN_CandidateRecord> candidateRecords = new ArrayList<FIN_CandidateRecord>();
-      final Set<Order> orders = new HashSet<Order>();
-      for (final FIN_PaymentScheduleDetail psd : obqPSD.list()) {
-        orders.add(psd.getOrderPaymentSchedule().getOrder());
-      }
-      for (final Order order : orders) {
-        candidateRecords.add(new FIN_CandidateRecord(order));
+      scrollLines = query.scroll(ScrollMode.FORWARD_ONLY);
+      int j = 1;
+      while (scrollLines.next()) {
+        final String orderId = scrollLines.getString(0);
+        candidateRecords
+            .add(new FIN_CandidateRecord(OBDal.getInstance().get(Order.class, orderId)));
+        if (j % 100 == 0) {
+          session.clear();
+        }
+        j++;
       }
 
       return candidateRecords;
 
     } finally {
+      if (scrollLines != null) {
+        scrollLines.close();
+      }
       OBContext.restorePreviousMode();
     }
   }
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/datasource/CandidatesDatasource.java	Tue Aug 19 17:23:18 2014 +0200
@@ -0,0 +1,121 @@
+package org.openbravo.advpaymentmngt.datasource;
+
+import java.util.ArrayList;
+import java.util.List;
+import java.util.Map;
+
+import org.codehaus.jettison.json.JSONArray;
+import org.codehaus.jettison.json.JSONException;
+import org.codehaus.jettison.json.JSONObject;
+import org.openbravo.advpaymentmngt.algorithm.StandardMatchingCandidatesAlgorithm;
+import org.openbravo.advpaymentmngt.utility.FIN_CandidateRecord;
+import org.openbravo.base.model.Entity;
+import org.openbravo.base.model.ModelProvider;
+import org.openbravo.base.provider.OBProvider;
+import org.openbravo.dal.service.OBDal;
+import org.openbravo.model.common.invoice.Invoice;
+import org.openbravo.model.common.order.Order;
+import org.openbravo.model.financialmgmt.payment.FIN_BankStatementLine;
+import org.openbravo.model.financialmgmt.payment.FIN_FinaccTransaction;
+import org.openbravo.model.financialmgmt.payment.FIN_Payment;
+import org.openbravo.service.datasource.ReadOnlyDataSourceService;
+import org.openbravo.service.json.DataToJsonConverter;
+import org.openbravo.service.json.JsonConstants;
+import org.openbravo.service.json.JsonUtils;
+
+public class CandidatesDatasource extends ReadOnlyDataSourceService {
+
+  // Table ID of the datasource based table defined in the application dictionary
+  private static final String AD_TABLE_ID = "85DA470A6BB3479E955D88C136EEC8A3";
+
+  @Override
+  public Entity getEntity() {
+    return ModelProvider.getInstance().getEntityByTableId(AD_TABLE_ID);
+  }
+
+  @Override
+  public String fetch(Map<String, String> parameters) {
+    int startRow = 0;
+    final String startRowStr = parameters.get(JsonConstants.STARTROW_PARAMETER);
+    if (startRowStr != null) {
+      startRow = Integer.parseInt(startRowStr);
+    }
+
+    final List<JSONObject> jsonObjects = fetchJSONObject(parameters);
+
+    final JSONObject jsonResult = new JSONObject();
+    final JSONObject jsonResponse = new JSONObject();
+    try {
+      jsonResponse.put(JsonConstants.RESPONSE_STATUS, JsonConstants.RPCREQUEST_STATUS_SUCCESS);
+      jsonResponse.put(JsonConstants.RESPONSE_STARTROW, startRow);
+      jsonResponse.put(JsonConstants.RESPONSE_ENDROW, jsonObjects.size() + startRow - 1);
+      // jsonResponse.put(JsonConstants.RESPONSE_TOTALROWS, getCount(parameters));
+      jsonResponse.put(JsonConstants.RESPONSE_DATA, new JSONArray(jsonObjects));
+      jsonResult.put(JsonConstants.RESPONSE_RESPONSE, jsonResponse);
+    } catch (JSONException e) {
+    }
+
+    return jsonResult.toString();
+  }
+
+  private List<JSONObject> fetchJSONObject(Map<String, String> parameters) {
+    final String startRowStr = parameters.get(JsonConstants.STARTROW_PARAMETER);
+    final String endRowStr = parameters.get(JsonConstants.ENDROW_PARAMETER);
+    int startRow = -1;
+    int endRow = -1;
+    if (startRowStr != null) {
+      startRow = Integer.parseInt(startRowStr);
+    }
+    if (endRowStr != null) {
+      endRow = Integer.parseInt(endRowStr);
+    }
+    final List<Map<String, Object>> data = getData(parameters, startRow, endRow);
+    final DataToJsonConverter toJsonConverter = OBProvider.getInstance().get(
+        DataToJsonConverter.class);
+    toJsonConverter.setAdditionalProperties(JsonUtils.getAdditionalProperties(parameters));
+    return toJsonConverter.convertToJsonObjects(data);
+  }
+
+  protected List<Map<String, Object>> getData(Map<String, String> parameters, int startRow,
+      int endRow) {
+    List<Map<String, Object>> result = new ArrayList<Map<String, Object>>();
+
+    int offset = startRow;
+    int nRows = endRow - startRow + 1;
+
+    // String fetchType = null;
+    // SQLQuery qry = null;
+    // if (parameters.get(JsonConstants.DISTINCT_PARAMETER) != null) {
+    // // FETCHTYPE = (STRING) PARAMETERS.GET(JSONCONSTANTS.DISTINCT_PARAMETER);
+    // // QRY = OBDAL.GETINSTANCE().GETSESSION()
+    // // .CREATESQLQuery(getDistinctProductQuery(parameters, offset, nRows));
+    // } else {
+    // fetchType = "grid";
+    // qry = OBDal.getInstance().getSession().createSQLQuery(getSQLQuery(parameters, offset,
+    // nRows));
+    // }
+
+    // TODO recover bank line
+    final FIN_BankStatementLine line = OBDal.getInstance().get(FIN_BankStatementLine.class,
+        "25869E0C419A4C1BA6361BFA4EE5404A");
+    StandardMatchingCandidatesAlgorithm smc = new StandardMatchingCandidatesAlgorithm();
+    List<FIN_CandidateRecord> transactionCandidates = smc.getTransactionCandidates(line,
+        new ArrayList<FIN_FinaccTransaction>());
+    transactionCandidates.addAll(smc.getPaymentCandidates(line, new ArrayList<FIN_Payment>()));
+    transactionCandidates.addAll(smc.getInvoiceCandidates(line, new ArrayList<Invoice>()));
+    transactionCandidates.addAll(smc.getOrderCandidates(line, new ArrayList<Order>()));
+
+    for (FIN_CandidateRecord transactionCandidate : transactionCandidates) {
+      result.add(transactionCandidate.toMap());
+    }
+
+    return result;
+  }
+
+  @Override
+  protected int getCount(Map<String, String> parameters) {
+    // TODO Auto-generated method stub
+    return 1;
+  }
+
+}
--- a/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/utility/FIN_CandidateRecord.java	Tue Aug 19 12:29:16 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/utility/FIN_CandidateRecord.java	Tue Aug 19 17:23:18 2014 +0200
@@ -21,6 +21,8 @@
 
 import java.math.BigDecimal;
 import java.util.Date;
+import java.util.HashMap;
+import java.util.Map;
 
 import org.openbravo.base.exception.OBException;
 import org.openbravo.base.structure.BaseOBObject;
@@ -141,4 +143,25 @@
     return "TODO";
   }
 
+  public Map<String, Object> toMap() {
+    // TODO other columns
+    final Map<String, Object> map = new HashMap<String, Object>();
+
+    map.put("id", baseOBObject.getId());
+    map.put("ad_client_id", "23C59575B9CF467C9620760EB255B389");
+    map.put("ad_org_id", "B843C30461EA4501935CB1D125C9C25A");
+    map.put("createdby", "100");
+    map.put("updatedby", "100");
+    map.put("created", new Date());
+    map.put("updated", new Date());
+    map.put("isactive", "Y");
+    // map.put("affinity", affinity);
+    map.put("affinity", "dummy3");
+    map.put("date", getDate());
+    map.put("c_bpartner_id", getBusinessPartner().getId());
+    map.put("amount", getAmount());
+    map.put("date", new Date());
+
+    return map;
+  }
 }
--- a/modules/org.openbravo.advpaymentmngt/web/org.openbravo.advpaymentmngt/js/ob-aprm-matchStatement.js	Tue Aug 19 12:29:16 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/web/org.openbravo.advpaymentmngt/js/ob-aprm-matchStatement.js	Tue Aug 19 17:23:18 2014 +0200
@@ -54,6 +54,8 @@
           callerField: me,
           paramWindow: true,
           processId: processId,
+          record: record,
+          recordId: record,
           windowId: grid.view.windowId,
           windowTitle: 'Search'
         });