[OBCQL] Changed links on example query list widgets.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Wed, 29 Dec 2010 18:08:55 +0100
changeset 9469 87c027fb8bd2
parent 9468 e82cba7d05b9
child 9470 f5271f780cb9
[OBCQL] Changed links on example query list widgets.
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
--- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml	Wed Dec 29 17:59:25 2010 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml	Wed Dec 29 18:08:55 2010 +0100
@@ -9,12 +9,10 @@
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  <DISPLAY_EXPRESSION><![CDATA[paymentDate]]></DISPLAY_EXPRESSION>
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  <NAME><![CDATA[Date]]></NAME>
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--15817E30D88A4E04ACA56D1E92D24FD7-->  <LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION>
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  <SEQNO><![CDATA[30]]></SEQNO>
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--15817E30D88A4E04ACA56D1E92D24FD7-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--15817E30D88A4E04ACA56D1E92D24FD7-->  <AD_TAB_ID><![CDATA[F7A52FDAAA0346EFA07D53C125B40404]]></AD_TAB_ID>
+<!--15817E30D88A4E04ACA56D1E92D24FD7-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--15817E30D88A4E04ACA56D1E92D24FD7--></OBCQL_QUERY_COLUMN>
 
 <!--1FCFFA0840074019BF84BBD9E507CB91--><OBCQL_QUERY_COLUMN>
@@ -26,12 +24,10 @@
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  <DISPLAY_EXPRESSION><![CDATA[invoiceDate]]></DISPLAY_EXPRESSION>
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  <NAME><![CDATA[Date]]></NAME>
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--1FCFFA0840074019BF84BBD9E507CB91-->  <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  <SEQNO><![CDATA[30]]></SEQNO>
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--1FCFFA0840074019BF84BBD9E507CB91-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--1FCFFA0840074019BF84BBD9E507CB91-->  <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID>
+<!--1FCFFA0840074019BF84BBD9E507CB91-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--1FCFFA0840074019BF84BBD9E507CB91--></OBCQL_QUERY_COLUMN>
 
 <!--379830F53AF44639B79DB5AB113A575F--><OBCQL_QUERY_COLUMN>
@@ -60,12 +56,12 @@
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <NAME><![CDATA[Business Partner]]></NAME>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <WIDTH><![CDATA[40]]></WIDTH>
-<!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
+<!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <LINK_EXPRESSION><![CDATA[businessPartnerId]]></LINK_EXPRESSION>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <SEQNO><![CDATA[20]]></SEQNO>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <AD_TAB_ID><![CDATA[263]]></AD_TAB_ID>
+<!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--></OBCQL_QUERY_COLUMN>
 
 <!--4FE8DE4D7CF94B128CBA09973BD21C1D--><OBCQL_QUERY_COLUMN>
@@ -112,12 +108,10 @@
 <!--56DC401F52BF4BE593C782240AE4AB67-->  <NAME><![CDATA[Amount]]></NAME>
 <!--56DC401F52BF4BE593C782240AE4AB67-->  <SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE>
 <!--56DC401F52BF4BE593C782240AE4AB67-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--56DC401F52BF4BE593C782240AE4AB67-->  <LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION>
 <!--56DC401F52BF4BE593C782240AE4AB67-->  <SEQNO><![CDATA[40]]></SEQNO>
 <!--56DC401F52BF4BE593C782240AE4AB67-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
 <!--56DC401F52BF4BE593C782240AE4AB67-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--56DC401F52BF4BE593C782240AE4AB67-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--56DC401F52BF4BE593C782240AE4AB67-->  <AD_TAB_ID><![CDATA[C4B6506838E14A349D6717D6856F1B56]]></AD_TAB_ID>
+<!--56DC401F52BF4BE593C782240AE4AB67-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--56DC401F52BF4BE593C782240AE4AB67--></OBCQL_QUERY_COLUMN>
 
 <!--6B151041105E4DD0805AC2F709A7A81E--><OBCQL_QUERY_COLUMN>
@@ -129,12 +123,10 @@
 <!--6B151041105E4DD0805AC2F709A7A81E-->  <DISPLAY_EXPRESSION><![CDATA[paymentDate]]></DISPLAY_EXPRESSION>
 <!--6B151041105E4DD0805AC2F709A7A81E-->  <NAME><![CDATA[Date]]></NAME>
 <!--6B151041105E4DD0805AC2F709A7A81E-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--6B151041105E4DD0805AC2F709A7A81E-->  <LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION>
 <!--6B151041105E4DD0805AC2F709A7A81E-->  <SEQNO><![CDATA[30]]></SEQNO>
 <!--6B151041105E4DD0805AC2F709A7A81E-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
 <!--6B151041105E4DD0805AC2F709A7A81E-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--6B151041105E4DD0805AC2F709A7A81E-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--6B151041105E4DD0805AC2F709A7A81E-->  <AD_TAB_ID><![CDATA[C4B6506838E14A349D6717D6856F1B56]]></AD_TAB_ID>
+<!--6B151041105E4DD0805AC2F709A7A81E-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--6B151041105E4DD0805AC2F709A7A81E--></OBCQL_QUERY_COLUMN>
 
 <!--70CEB497CA254F3C892AE0B68920897D--><OBCQL_QUERY_COLUMN>
@@ -146,12 +138,12 @@
 <!--70CEB497CA254F3C892AE0B68920897D-->  <DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION>
 <!--70CEB497CA254F3C892AE0B68920897D-->  <NAME><![CDATA[Business Partner]]></NAME>
 <!--70CEB497CA254F3C892AE0B68920897D-->  <WIDTH><![CDATA[40]]></WIDTH>
-<!--70CEB497CA254F3C892AE0B68920897D-->  <LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION>
+<!--70CEB497CA254F3C892AE0B68920897D-->  <LINK_EXPRESSION><![CDATA[businessPartnerId]]></LINK_EXPRESSION>
 <!--70CEB497CA254F3C892AE0B68920897D-->  <SEQNO><![CDATA[20]]></SEQNO>
 <!--70CEB497CA254F3C892AE0B68920897D-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
 <!--70CEB497CA254F3C892AE0B68920897D-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
 <!--70CEB497CA254F3C892AE0B68920897D-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--70CEB497CA254F3C892AE0B68920897D-->  <AD_TAB_ID><![CDATA[C4B6506838E14A349D6717D6856F1B56]]></AD_TAB_ID>
+<!--70CEB497CA254F3C892AE0B68920897D-->  <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
 <!--70CEB497CA254F3C892AE0B68920897D--></OBCQL_QUERY_COLUMN>
 
 <!--742D993ADF7444318F8CAF38DDCB1997--><OBCQL_QUERY_COLUMN>
@@ -163,12 +155,12 @@
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION>
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <NAME><![CDATA[Business Partner]]></NAME>
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <WIDTH><![CDATA[40]]></WIDTH>
-<!--742D993ADF7444318F8CAF38DDCB1997-->  <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
+<!--742D993ADF7444318F8CAF38DDCB1997-->  <LINK_EXPRESSION><![CDATA[businessPartnerId]]></LINK_EXPRESSION>
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <SEQNO><![CDATA[20]]></SEQNO>
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--742D993ADF7444318F8CAF38DDCB1997-->  <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID>
+<!--742D993ADF7444318F8CAF38DDCB1997-->  <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
 <!--742D993ADF7444318F8CAF38DDCB1997--></OBCQL_QUERY_COLUMN>
 
 <!--94B1051270614629B02531C5F894BCF1--><OBCQL_QUERY_COLUMN>
@@ -180,12 +172,12 @@
 <!--94B1051270614629B02531C5F894BCF1-->  <DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION>
 <!--94B1051270614629B02531C5F894BCF1-->  <NAME><![CDATA[Business Partner]]></NAME>
 <!--94B1051270614629B02531C5F894BCF1-->  <WIDTH><![CDATA[40]]></WIDTH>
-<!--94B1051270614629B02531C5F894BCF1-->  <LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION>
+<!--94B1051270614629B02531C5F894BCF1-->  <LINK_EXPRESSION><![CDATA[businessPartnerId]]></LINK_EXPRESSION>
 <!--94B1051270614629B02531C5F894BCF1-->  <SEQNO><![CDATA[20]]></SEQNO>
 <!--94B1051270614629B02531C5F894BCF1-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
 <!--94B1051270614629B02531C5F894BCF1-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
 <!--94B1051270614629B02531C5F894BCF1-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--94B1051270614629B02531C5F894BCF1-->  <AD_TAB_ID><![CDATA[F7A52FDAAA0346EFA07D53C125B40404]]></AD_TAB_ID>
+<!--94B1051270614629B02531C5F894BCF1-->  <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
 <!--94B1051270614629B02531C5F894BCF1--></OBCQL_QUERY_COLUMN>
 
 <!--9FC7E75A21F34920AA2695261935FD06--><OBCQL_QUERY_COLUMN>
@@ -214,12 +206,10 @@
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <DISPLAY_EXPRESSION><![CDATA[invoiceDate]]></DISPLAY_EXPRESSION>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <NAME><![CDATA[Date]]></NAME>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <SEQNO><![CDATA[30]]></SEQNO>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <AD_TAB_ID><![CDATA[263]]></AD_TAB_ID>
+<!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1--></OBCQL_QUERY_COLUMN>
 
 <!--CDC05CE5642E4327BA12FEA50597A8A3--><OBCQL_QUERY_COLUMN>
@@ -232,12 +222,10 @@
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <NAME><![CDATA[Amount]]></NAME>
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE>
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--CDC05CE5642E4327BA12FEA50597A8A3-->  <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <SEQNO><![CDATA[40]]></SEQNO>
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--CDC05CE5642E4327BA12FEA50597A8A3-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--CDC05CE5642E4327BA12FEA50597A8A3-->  <AD_TAB_ID><![CDATA[263]]></AD_TAB_ID>
+<!--CDC05CE5642E4327BA12FEA50597A8A3-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--CDC05CE5642E4327BA12FEA50597A8A3--></OBCQL_QUERY_COLUMN>
 
 <!--FAB0DB1A67D948DB85AD5918B7845ABF--><OBCQL_QUERY_COLUMN>
@@ -250,12 +238,10 @@
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <NAME><![CDATA[Amount]]></NAME>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <SEQNO><![CDATA[40]]></SEQNO>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID>
+<!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF--></OBCQL_QUERY_COLUMN>
 
 <!--FE9812790C0943C584999CEAAD93E95D--><OBCQL_QUERY_COLUMN>
@@ -268,12 +254,10 @@
 <!--FE9812790C0943C584999CEAAD93E95D-->  <NAME><![CDATA[Amount]]></NAME>
 <!--FE9812790C0943C584999CEAAD93E95D-->  <SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE>
 <!--FE9812790C0943C584999CEAAD93E95D-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--FE9812790C0943C584999CEAAD93E95D-->  <LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION>
 <!--FE9812790C0943C584999CEAAD93E95D-->  <SEQNO><![CDATA[40]]></SEQNO>
 <!--FE9812790C0943C584999CEAAD93E95D-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
 <!--FE9812790C0943C584999CEAAD93E95D-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--FE9812790C0943C584999CEAAD93E95D-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--FE9812790C0943C584999CEAAD93E95D-->  <AD_TAB_ID><![CDATA[F7A52FDAAA0346EFA07D53C125B40404]]></AD_TAB_ID>
+<!--FE9812790C0943C584999CEAAD93E95D-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--FE9812790C0943C584999CEAAD93E95D--></OBCQL_QUERY_COLUMN>
 
 </data>
--- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Wed Dec 29 17:59:25 2010 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Wed Dec 29 18:08:55 2010 +0100
@@ -7,7 +7,7 @@
 <!--1EF87E8E961A4E5BA3B41E1AB772B47C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--1EF87E8E961A4E5BA3B41E1AB772B47C-->  <OBKMO_WIDGET_CLASS_ID><![CDATA[147D825456D54D0486C3D7072531C5C9]]></OBKMO_WIDGET_CLASS_ID>
 <!--1EF87E8E961A4E5BA3B41E1AB772B47C-->  <HQL><![CDATA[select inv.id as invoiceId, inv.documentNo as documentNo,
-       inv.businessPartner.name as businessPartnerName,
+       inv.businessPartner.id as businessPartnerId, inv.businessPartner.name as businessPartnerName,
        inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount
 from Invoice as inv
 where inv.businessPartner.name like :businessPartnerName
@@ -26,7 +26,7 @@
 <!--58BCB96595FA45678CC1423402238309-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--58BCB96595FA45678CC1423402238309-->  <OBKMO_WIDGET_CLASS_ID><![CDATA[34F279BBB85945519DC38F21573106C0]]></OBKMO_WIDGET_CLASS_ID>
 <!--58BCB96595FA45678CC1423402238309-->  <HQL><![CDATA[select inv.id as invoiceId, inv.documentNo as documentNo,
-       inv.businessPartner.name as businessPartnerName,
+       inv.businessPartner.id as businessPartnerId, inv.businessPartner.name as businessPartnerName,
        inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount
 from Invoice as inv
 where inv.businessPartner.name like :businessPartnerName
@@ -45,7 +45,7 @@
 <!--E5A0DC8536134185AC8B1897F15DB816-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--E5A0DC8536134185AC8B1897F15DB816-->  <OBKMO_WIDGET_CLASS_ID><![CDATA[2662490B7D3B4F80AF308C88F6DB68C0]]></OBKMO_WIDGET_CLASS_ID>
 <!--E5A0DC8536134185AC8B1897F15DB816-->  <HQL><![CDATA[select p.id as finpaymentId, p.documentNo as documentNo,
-       p.businessPartner.name as businessPartnerName,
+       p.businessPartner.id as businessPartnerId, p.businessPartner.name as businessPartnerName,
        p.paymentDate as paymentDate, p.amount as amount
 from FIN_Payment as p
 where p.businessPartner.name like :businessPartnerName
@@ -64,7 +64,7 @@
 <!--F94AEB4680AD4AD48255071903000A43-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--F94AEB4680AD4AD48255071903000A43-->  <OBKMO_WIDGET_CLASS_ID><![CDATA[F8E4F382BCFB441CADBB4AC693C41C93]]></OBKMO_WIDGET_CLASS_ID>
 <!--F94AEB4680AD4AD48255071903000A43-->  <HQL><![CDATA[select p.id as finpaymentId, p.documentNo as documentNo,
-       p.businessPartner.name as businessPartnerName,
+       p.businessPartner.id as businessPartnerId, p.businessPartner.name as businessPartnerName,
        p.paymentDate as paymentDate, p.amount as amount
 from FIN_Payment as p
 where p.businessPartner.name like :businessPartnerName