[OBCQL] Added columns for maximize view on invoice to pay and collect widgets.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Thu, 30 Dec 2010 13:15:23 +0100
changeset 9495 10cfde195c41
parent 9494 09239a2a07da
child 9496 473d2973a5ad
[OBCQL] Added columns for maximize view on invoice to pay and collect 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	Thu Dec 30 12:32:20 2010 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml	Thu Dec 30 13:15:23 2010 +0100
@@ -1,5 +1,20 @@
 <?xml version='1.0' encoding='UTF-8'?>
 <data>
+<!--01AA894DAA8040218F90CC3B9E73344B--><OBCQL_QUERY_COLUMN>
+<!--01AA894DAA8040218F90CC3B9E73344B-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[01AA894DAA8040218F90CC3B9E73344B]]></OBCQL_QUERY_COLUMN_ID>
+<!--01AA894DAA8040218F90CC3B9E73344B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--01AA894DAA8040218F90CC3B9E73344B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--01AA894DAA8040218F90CC3B9E73344B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--01AA894DAA8040218F90CC3B9E73344B-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID>
+<!--01AA894DAA8040218F90CC3B9E73344B-->  <DISPLAY_EXPRESSION><![CDATA[outstandingAmount]]></DISPLAY_EXPRESSION>
+<!--01AA894DAA8040218F90CC3B9E73344B-->  <NAME><![CDATA[Outstanding amount]]></NAME>
+<!--01AA894DAA8040218F90CC3B9E73344B-->  <WIDTH><![CDATA[20]]></WIDTH>
+<!--01AA894DAA8040218F90CC3B9E73344B-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--01AA894DAA8040218F90CC3B9E73344B-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
+<!--01AA894DAA8040218F90CC3B9E73344B-->  <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN>
+<!--01AA894DAA8040218F90CC3B9E73344B-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--01AA894DAA8040218F90CC3B9E73344B--></OBCQL_QUERY_COLUMN>
+
 <!--15817E30D88A4E04ACA56D1E92D24FD7--><OBCQL_QUERY_COLUMN>
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[15817E30D88A4E04ACA56D1E92D24FD7]]></OBCQL_QUERY_COLUMN_ID>
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -64,6 +79,21 @@
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--></OBCQL_QUERY_COLUMN>
 
+<!--493479BFB7D94915889AA9BDD6BB3EA8--><OBCQL_QUERY_COLUMN>
+<!--493479BFB7D94915889AA9BDD6BB3EA8-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[493479BFB7D94915889AA9BDD6BB3EA8]]></OBCQL_QUERY_COLUMN_ID>
+<!--493479BFB7D94915889AA9BDD6BB3EA8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--493479BFB7D94915889AA9BDD6BB3EA8-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--493479BFB7D94915889AA9BDD6BB3EA8-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--493479BFB7D94915889AA9BDD6BB3EA8-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID>
+<!--493479BFB7D94915889AA9BDD6BB3EA8-->  <DISPLAY_EXPRESSION><![CDATA[daysTillDue]]></DISPLAY_EXPRESSION>
+<!--493479BFB7D94915889AA9BDD6BB3EA8-->  <NAME><![CDATA[Days till due]]></NAME>
+<!--493479BFB7D94915889AA9BDD6BB3EA8-->  <WIDTH><![CDATA[20]]></WIDTH>
+<!--493479BFB7D94915889AA9BDD6BB3EA8-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--493479BFB7D94915889AA9BDD6BB3EA8-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
+<!--493479BFB7D94915889AA9BDD6BB3EA8-->  <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN>
+<!--493479BFB7D94915889AA9BDD6BB3EA8-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--493479BFB7D94915889AA9BDD6BB3EA8--></OBCQL_QUERY_COLUMN>
+
 <!--4FE8DE4D7CF94B128CBA09973BD21C1D--><OBCQL_QUERY_COLUMN>
 <!--4FE8DE4D7CF94B128CBA09973BD21C1D-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[4FE8DE4D7CF94B128CBA09973BD21C1D]]></OBCQL_QUERY_COLUMN_ID>
 <!--4FE8DE4D7CF94B128CBA09973BD21C1D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -98,6 +128,21 @@
 <!--51429339D294475986634D7E876F4A53-->  <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID>
 <!--51429339D294475986634D7E876F4A53--></OBCQL_QUERY_COLUMN>
 
+<!--5410706611F04069A9326D70425EAD22--><OBCQL_QUERY_COLUMN>
+<!--5410706611F04069A9326D70425EAD22-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[5410706611F04069A9326D70425EAD22]]></OBCQL_QUERY_COLUMN_ID>
+<!--5410706611F04069A9326D70425EAD22-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5410706611F04069A9326D70425EAD22-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5410706611F04069A9326D70425EAD22-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5410706611F04069A9326D70425EAD22-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID>
+<!--5410706611F04069A9326D70425EAD22-->  <DISPLAY_EXPRESSION><![CDATA[dueAmount]]></DISPLAY_EXPRESSION>
+<!--5410706611F04069A9326D70425EAD22-->  <NAME><![CDATA[Due amount]]></NAME>
+<!--5410706611F04069A9326D70425EAD22-->  <WIDTH><![CDATA[20]]></WIDTH>
+<!--5410706611F04069A9326D70425EAD22-->  <SEQNO><![CDATA[80]]></SEQNO>
+<!--5410706611F04069A9326D70425EAD22-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
+<!--5410706611F04069A9326D70425EAD22-->  <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN>
+<!--5410706611F04069A9326D70425EAD22-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--5410706611F04069A9326D70425EAD22--></OBCQL_QUERY_COLUMN>
+
 <!--56DC401F52BF4BE593C782240AE4AB67--><OBCQL_QUERY_COLUMN>
 <!--56DC401F52BF4BE593C782240AE4AB67-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[56DC401F52BF4BE593C782240AE4AB67]]></OBCQL_QUERY_COLUMN_ID>
 <!--56DC401F52BF4BE593C782240AE4AB67-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -163,6 +208,21 @@
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
 <!--742D993ADF7444318F8CAF38DDCB1997--></OBCQL_QUERY_COLUMN>
 
+<!--7EFCCE042B4841D0B9377B54F11973E7--><OBCQL_QUERY_COLUMN>
+<!--7EFCCE042B4841D0B9377B54F11973E7-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[7EFCCE042B4841D0B9377B54F11973E7]]></OBCQL_QUERY_COLUMN_ID>
+<!--7EFCCE042B4841D0B9377B54F11973E7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7EFCCE042B4841D0B9377B54F11973E7-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7EFCCE042B4841D0B9377B54F11973E7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7EFCCE042B4841D0B9377B54F11973E7-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID>
+<!--7EFCCE042B4841D0B9377B54F11973E7-->  <DISPLAY_EXPRESSION><![CDATA[daysTillDue]]></DISPLAY_EXPRESSION>
+<!--7EFCCE042B4841D0B9377B54F11973E7-->  <NAME><![CDATA[Days till due]]></NAME>
+<!--7EFCCE042B4841D0B9377B54F11973E7-->  <WIDTH><![CDATA[20]]></WIDTH>
+<!--7EFCCE042B4841D0B9377B54F11973E7-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--7EFCCE042B4841D0B9377B54F11973E7-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
+<!--7EFCCE042B4841D0B9377B54F11973E7-->  <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN>
+<!--7EFCCE042B4841D0B9377B54F11973E7-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--7EFCCE042B4841D0B9377B54F11973E7--></OBCQL_QUERY_COLUMN>
+
 <!--94B1051270614629B02531C5F894BCF1--><OBCQL_QUERY_COLUMN>
 <!--94B1051270614629B02531C5F894BCF1-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[94B1051270614629B02531C5F894BCF1]]></OBCQL_QUERY_COLUMN_ID>
 <!--94B1051270614629B02531C5F894BCF1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -180,6 +240,21 @@
 <!--94B1051270614629B02531C5F894BCF1-->  <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
 <!--94B1051270614629B02531C5F894BCF1--></OBCQL_QUERY_COLUMN>
 
+<!--9F88542C3F944CDF867298D292C8113C--><OBCQL_QUERY_COLUMN>
+<!--9F88542C3F944CDF867298D292C8113C-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[9F88542C3F944CDF867298D292C8113C]]></OBCQL_QUERY_COLUMN_ID>
+<!--9F88542C3F944CDF867298D292C8113C-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9F88542C3F944CDF867298D292C8113C-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9F88542C3F944CDF867298D292C8113C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9F88542C3F944CDF867298D292C8113C-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID>
+<!--9F88542C3F944CDF867298D292C8113C-->  <DISPLAY_EXPRESSION><![CDATA[paymentTerms]]></DISPLAY_EXPRESSION>
+<!--9F88542C3F944CDF867298D292C8113C-->  <NAME><![CDATA[Payment Terms]]></NAME>
+<!--9F88542C3F944CDF867298D292C8113C-->  <WIDTH><![CDATA[30]]></WIDTH>
+<!--9F88542C3F944CDF867298D292C8113C-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--9F88542C3F944CDF867298D292C8113C-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--9F88542C3F944CDF867298D292C8113C-->  <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN>
+<!--9F88542C3F944CDF867298D292C8113C-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--9F88542C3F944CDF867298D292C8113C--></OBCQL_QUERY_COLUMN>
+
 <!--9FC7E75A21F34920AA2695261935FD06--><OBCQL_QUERY_COLUMN>
 <!--9FC7E75A21F34920AA2695261935FD06-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[9FC7E75A21F34920AA2695261935FD06]]></OBCQL_QUERY_COLUMN_ID>
 <!--9FC7E75A21F34920AA2695261935FD06-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -228,6 +303,51 @@
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--CDC05CE5642E4327BA12FEA50597A8A3--></OBCQL_QUERY_COLUMN>
 
+<!--D8C77A2A8B934351ACF38542FD807183--><OBCQL_QUERY_COLUMN>
+<!--D8C77A2A8B934351ACF38542FD807183-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[D8C77A2A8B934351ACF38542FD807183]]></OBCQL_QUERY_COLUMN_ID>
+<!--D8C77A2A8B934351ACF38542FD807183-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D8C77A2A8B934351ACF38542FD807183-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D8C77A2A8B934351ACF38542FD807183-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D8C77A2A8B934351ACF38542FD807183-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID>
+<!--D8C77A2A8B934351ACF38542FD807183-->  <DISPLAY_EXPRESSION><![CDATA[outstandingAmount]]></DISPLAY_EXPRESSION>
+<!--D8C77A2A8B934351ACF38542FD807183-->  <NAME><![CDATA[Outstanding amount]]></NAME>
+<!--D8C77A2A8B934351ACF38542FD807183-->  <WIDTH><![CDATA[20]]></WIDTH>
+<!--D8C77A2A8B934351ACF38542FD807183-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--D8C77A2A8B934351ACF38542FD807183-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
+<!--D8C77A2A8B934351ACF38542FD807183-->  <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN>
+<!--D8C77A2A8B934351ACF38542FD807183-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--D8C77A2A8B934351ACF38542FD807183--></OBCQL_QUERY_COLUMN>
+
+<!--F582F7725D3F40469A956945A85A67AD--><OBCQL_QUERY_COLUMN>
+<!--F582F7725D3F40469A956945A85A67AD-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[F582F7725D3F40469A956945A85A67AD]]></OBCQL_QUERY_COLUMN_ID>
+<!--F582F7725D3F40469A956945A85A67AD-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F582F7725D3F40469A956945A85A67AD-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F582F7725D3F40469A956945A85A67AD-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F582F7725D3F40469A956945A85A67AD-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID>
+<!--F582F7725D3F40469A956945A85A67AD-->  <DISPLAY_EXPRESSION><![CDATA[dueAmount]]></DISPLAY_EXPRESSION>
+<!--F582F7725D3F40469A956945A85A67AD-->  <NAME><![CDATA[Due amount]]></NAME>
+<!--F582F7725D3F40469A956945A85A67AD-->  <WIDTH><![CDATA[20]]></WIDTH>
+<!--F582F7725D3F40469A956945A85A67AD-->  <SEQNO><![CDATA[80]]></SEQNO>
+<!--F582F7725D3F40469A956945A85A67AD-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
+<!--F582F7725D3F40469A956945A85A67AD-->  <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN>
+<!--F582F7725D3F40469A956945A85A67AD-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--F582F7725D3F40469A956945A85A67AD--></OBCQL_QUERY_COLUMN>
+
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6--><OBCQL_QUERY_COLUMN>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[F62EBD9018364D61A8F6D4A5CC0E52E6]]></OBCQL_QUERY_COLUMN_ID>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6-->  <DISPLAY_EXPRESSION><![CDATA[paymentTerms]]></DISPLAY_EXPRESSION>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6-->  <NAME><![CDATA[Payment terms]]></NAME>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6-->  <WIDTH><![CDATA[30]]></WIDTH>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6-->  <AD_REFERENCE_ID><![CDATA[14]]></AD_REFERENCE_ID>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6-->  <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--F62EBD9018364D61A8F6D4A5CC0E52E6--></OBCQL_QUERY_COLUMN>
+
 <!--FAB0DB1A67D948DB85AD5918B7845ABF--><OBCQL_QUERY_COLUMN>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[FAB0DB1A67D948DB85AD5918B7845ABF]]></OBCQL_QUERY_COLUMN_ID>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Thu Dec 30 12:32:20 2010 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Thu Dec 30 13:15:23 2010 +0100
@@ -8,7 +8,9 @@
 <!--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.id as businessPartnerId, inv.businessPartner.name as businessPartnerName,
-       inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount
+       inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount,
+       inv.paymentTerms.name as paymentTerms, inv.outstandingAmount as outstandingAmount,
+       inv.daysTillDue as daysTillDue, inv.dueAmount as dueAmount
 from Invoice as inv
 where inv.businessPartner.name like :businessPartnerName
       and inv.documentNo like :documentNo
@@ -27,7 +29,9 @@
 <!--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.id as businessPartnerId, inv.businessPartner.name as businessPartnerName,
-       inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount
+       inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount,
+       inv.paymentTerms.name as paymentTerms, inv.outstandingAmount as outstandingAmount,
+       inv.daysTillDue as daysTillDue, inv.dueAmount as dueAmount
 from Invoice as inv
 where inv.businessPartner.name like :businessPartnerName
       and inv.documentNo like :documentNo