[OBCQL] Added widget pending goods receipt
authorPablo Sarobe <pablo.sarobe@openbravo.com>
Thu, 30 Dec 2010 18:06:38 +0100
changeset 9487 353409564ae1
parent 9486 fe2d742aaf33
child 9488 7cae10b1b544
[OBCQL] Added widget pending goods receipt
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
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
--- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml	Thu Dec 30 18:00:48 2010 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml	Thu Dec 30 18:06:38 2010 +0100
@@ -45,6 +45,21 @@
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--1FCFFA0840074019BF84BBD9E507CB91--></OBCQL_QUERY_COLUMN>
 
+<!--366186B2156C445EA59FECA4E1B72F51--><OBCQL_QUERY_COLUMN>
+<!--366186B2156C445EA59FECA4E1B72F51-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[366186B2156C445EA59FECA4E1B72F51]]></OBCQL_QUERY_COLUMN_ID>
+<!--366186B2156C445EA59FECA4E1B72F51-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--366186B2156C445EA59FECA4E1B72F51-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--366186B2156C445EA59FECA4E1B72F51-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--366186B2156C445EA59FECA4E1B72F51-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[F5DEE669DD8047FB831A12064BB277BE]]></OBCQL_WIDGET_QUERY_ID>
+<!--366186B2156C445EA59FECA4E1B72F51-->  <DISPLAY_EXPRESSION><![CDATA[uom]]></DISPLAY_EXPRESSION>
+<!--366186B2156C445EA59FECA4E1B72F51-->  <NAME><![CDATA[UOM]]></NAME>
+<!--366186B2156C445EA59FECA4E1B72F51-->  <WIDTH><![CDATA[10]]></WIDTH>
+<!--366186B2156C445EA59FECA4E1B72F51-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--366186B2156C445EA59FECA4E1B72F51-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--366186B2156C445EA59FECA4E1B72F51-->  <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN>
+<!--366186B2156C445EA59FECA4E1B72F51-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--366186B2156C445EA59FECA4E1B72F51--></OBCQL_QUERY_COLUMN>
+
 <!--379830F53AF44639B79DB5AB113A575F--><OBCQL_QUERY_COLUMN>
 <!--379830F53AF44639B79DB5AB113A575F-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[379830F53AF44639B79DB5AB113A575F]]></OBCQL_QUERY_COLUMN_ID>
 <!--379830F53AF44639B79DB5AB113A575F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -62,6 +77,21 @@
 <!--379830F53AF44639B79DB5AB113A575F-->  <AD_TAB_ID><![CDATA[263]]></AD_TAB_ID>
 <!--379830F53AF44639B79DB5AB113A575F--></OBCQL_QUERY_COLUMN>
 
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC--><OBCQL_QUERY_COLUMN>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[379E3A62E4FF4007B32C6A96BEFDEFCC]]></OBCQL_QUERY_COLUMN_ID>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[F5DEE669DD8047FB831A12064BB277BE]]></OBCQL_WIDGET_QUERY_ID>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC-->  <DISPLAY_EXPRESSION><![CDATA[attribute]]></DISPLAY_EXPRESSION>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC-->  <NAME><![CDATA[Attribute]]></NAME>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC-->  <WIDTH><![CDATA[10]]></WIDTH>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC-->  <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--379E3A62E4FF4007B32C6A96BEFDEFCC--></OBCQL_QUERY_COLUMN>
+
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--><OBCQL_QUERY_COLUMN>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[3C3DBC6021C94CFFA82AF855A7AF6C2F]]></OBCQL_QUERY_COLUMN_ID>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -208,6 +238,21 @@
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
 <!--742D993ADF7444318F8CAF38DDCB1997--></OBCQL_QUERY_COLUMN>
 
+<!--7DF4871F997942C1A51E064F022CF5E8--><OBCQL_QUERY_COLUMN>
+<!--7DF4871F997942C1A51E064F022CF5E8-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[7DF4871F997942C1A51E064F022CF5E8]]></OBCQL_QUERY_COLUMN_ID>
+<!--7DF4871F997942C1A51E064F022CF5E8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7DF4871F997942C1A51E064F022CF5E8-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7DF4871F997942C1A51E064F022CF5E8-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7DF4871F997942C1A51E064F022CF5E8-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[F5DEE669DD8047FB831A12064BB277BE]]></OBCQL_WIDGET_QUERY_ID>
+<!--7DF4871F997942C1A51E064F022CF5E8-->  <DISPLAY_EXPRESSION><![CDATA[bpartner]]></DISPLAY_EXPRESSION>
+<!--7DF4871F997942C1A51E064F022CF5E8-->  <NAME><![CDATA[Supplier]]></NAME>
+<!--7DF4871F997942C1A51E064F022CF5E8-->  <WIDTH><![CDATA[15]]></WIDTH>
+<!--7DF4871F997942C1A51E064F022CF5E8-->  <SEQNO><![CDATA[40]]></SEQNO>
+<!--7DF4871F997942C1A51E064F022CF5E8-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--7DF4871F997942C1A51E064F022CF5E8-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
+<!--7DF4871F997942C1A51E064F022CF5E8-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--7DF4871F997942C1A51E064F022CF5E8--></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>
@@ -223,6 +268,36 @@
 <!--7EFCCE042B4841D0B9377B54F11973E7-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--7EFCCE042B4841D0B9377B54F11973E7--></OBCQL_QUERY_COLUMN>
 
+<!--88104CDF6CC2418FB405A4B5BA74265D--><OBCQL_QUERY_COLUMN>
+<!--88104CDF6CC2418FB405A4B5BA74265D-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[88104CDF6CC2418FB405A4B5BA74265D]]></OBCQL_QUERY_COLUMN_ID>
+<!--88104CDF6CC2418FB405A4B5BA74265D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--88104CDF6CC2418FB405A4B5BA74265D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--88104CDF6CC2418FB405A4B5BA74265D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--88104CDF6CC2418FB405A4B5BA74265D-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[F5DEE669DD8047FB831A12064BB277BE]]></OBCQL_WIDGET_QUERY_ID>
+<!--88104CDF6CC2418FB405A4B5BA74265D-->  <DISPLAY_EXPRESSION><![CDATA[plannedDeliveryDate]]></DISPLAY_EXPRESSION>
+<!--88104CDF6CC2418FB405A4B5BA74265D-->  <NAME><![CDATA[Planned delivery]]></NAME>
+<!--88104CDF6CC2418FB405A4B5BA74265D-->  <WIDTH><![CDATA[10]]></WIDTH>
+<!--88104CDF6CC2418FB405A4B5BA74265D-->  <SEQNO><![CDATA[20]]></SEQNO>
+<!--88104CDF6CC2418FB405A4B5BA74265D-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
+<!--88104CDF6CC2418FB405A4B5BA74265D-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
+<!--88104CDF6CC2418FB405A4B5BA74265D-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--88104CDF6CC2418FB405A4B5BA74265D--></OBCQL_QUERY_COLUMN>
+
+<!--8B623EFDB1244BBDA320EDEE47FB6C21--><OBCQL_QUERY_COLUMN>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[8B623EFDB1244BBDA320EDEE47FB6C21]]></OBCQL_QUERY_COLUMN_ID>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[F5DEE669DD8047FB831A12064BB277BE]]></OBCQL_WIDGET_QUERY_ID>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21-->  <DISPLAY_EXPRESSION><![CDATA[productname]]></DISPLAY_EXPRESSION>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21-->  <NAME><![CDATA[Product]]></NAME>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21-->  <WIDTH><![CDATA[15]]></WIDTH>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--8B623EFDB1244BBDA320EDEE47FB6C21--></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>
@@ -272,6 +347,36 @@
 <!--9FC7E75A21F34920AA2695261935FD06-->  <AD_TAB_ID><![CDATA[F7A52FDAAA0346EFA07D53C125B40404]]></AD_TAB_ID>
 <!--9FC7E75A21F34920AA2695261935FD06--></OBCQL_QUERY_COLUMN>
 
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06--><OBCQL_QUERY_COLUMN>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[B1C95647F5AC45A3A3B4EC6BBFE8CD06]]></OBCQL_QUERY_COLUMN_ID>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[F5DEE669DD8047FB831A12064BB277BE]]></OBCQL_WIDGET_QUERY_ID>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06-->  <DISPLAY_EXPRESSION><![CDATA[qtyReceived]]></DISPLAY_EXPRESSION>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06-->  <NAME><![CDATA[Received]]></NAME>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06-->  <WIDTH><![CDATA[10]]></WIDTH>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06-->  <SEQNO><![CDATA[90]]></SEQNO>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06-->  <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--B1C95647F5AC45A3A3B4EC6BBFE8CD06--></OBCQL_QUERY_COLUMN>
+
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B--><OBCQL_QUERY_COLUMN>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[B1CA7F1719964CD2B9F2ECD4B7BD162B]]></OBCQL_QUERY_COLUMN_ID>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[F5DEE669DD8047FB831A12064BB277BE]]></OBCQL_WIDGET_QUERY_ID>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B-->  <DISPLAY_EXPRESSION><![CDATA[qtyPending]]></DISPLAY_EXPRESSION>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B-->  <NAME><![CDATA[Pending]]></NAME>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B-->  <WIDTH><![CDATA[10]]></WIDTH>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B-->  <SEQNO><![CDATA[100]]></SEQNO>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B-->  <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B-->  <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--B1CA7F1719964CD2B9F2ECD4B7BD162B--></OBCQL_QUERY_COLUMN>
+
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1--><OBCQL_QUERY_COLUMN>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[BBBF2F44391C43F98B4FDEAF62BE81D1]]></OBCQL_QUERY_COLUMN_ID>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -287,6 +392,38 @@
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1--></OBCQL_QUERY_COLUMN>
 
+<!--C13ADACEAEC74C1FA77151F5DA0D3965--><OBCQL_QUERY_COLUMN>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[C13ADACEAEC74C1FA77151F5DA0D3965]]></OBCQL_QUERY_COLUMN_ID>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[F5DEE669DD8047FB831A12064BB277BE]]></OBCQL_WIDGET_QUERY_ID>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965-->  <DISPLAY_EXPRESSION><![CDATA[totalqty]]></DISPLAY_EXPRESSION>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965-->  <NAME><![CDATA[Total]]></NAME>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965-->  <WIDTH><![CDATA[10]]></WIDTH>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965-->  <SEQNO><![CDATA[80]]></SEQNO>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965-->  <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--C13ADACEAEC74C1FA77151F5DA0D3965--></OBCQL_QUERY_COLUMN>
+
+<!--C31C48F4A17D43B291BA6762D05E75B4--><OBCQL_QUERY_COLUMN>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[C31C48F4A17D43B291BA6762D05E75B4]]></OBCQL_QUERY_COLUMN_ID>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[F5DEE669DD8047FB831A12064BB277BE]]></OBCQL_WIDGET_QUERY_ID>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <DISPLAY_EXPRESSION><![CDATA[salesorder]]></DISPLAY_EXPRESSION>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <NAME><![CDATA[Document]]></NAME>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <WIDTH><![CDATA[10]]></WIDTH>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <LINK_EXPRESSION><![CDATA[orderId]]></LINK_EXPRESSION>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
+<!--C31C48F4A17D43B291BA6762D05E75B4-->  <AD_TAB_ID><![CDATA[294]]></AD_TAB_ID>
+<!--C31C48F4A17D43B291BA6762D05E75B4--></OBCQL_QUERY_COLUMN>
+
 <!--CDC05CE5642E4327BA12FEA50597A8A3--><OBCQL_QUERY_COLUMN>
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[CDC05CE5642E4327BA12FEA50597A8A3]]></OBCQL_QUERY_COLUMN_ID>
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -318,6 +455,21 @@
 <!--D8C77A2A8B934351ACF38542FD807183-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--D8C77A2A8B934351ACF38542FD807183--></OBCQL_QUERY_COLUMN>
 
+<!--DFFE8FF0D0D8414796B134FA89E07F43--><OBCQL_QUERY_COLUMN>
+<!--DFFE8FF0D0D8414796B134FA89E07F43-->  <OBCQL_QUERY_COLUMN_ID><![CDATA[DFFE8FF0D0D8414796B134FA89E07F43]]></OBCQL_QUERY_COLUMN_ID>
+<!--DFFE8FF0D0D8414796B134FA89E07F43-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--DFFE8FF0D0D8414796B134FA89E07F43-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--DFFE8FF0D0D8414796B134FA89E07F43-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--DFFE8FF0D0D8414796B134FA89E07F43-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[F5DEE669DD8047FB831A12064BB277BE]]></OBCQL_WIDGET_QUERY_ID>
+<!--DFFE8FF0D0D8414796B134FA89E07F43-->  <DISPLAY_EXPRESSION><![CDATA[dateordered]]></DISPLAY_EXPRESSION>
+<!--DFFE8FF0D0D8414796B134FA89E07F43-->  <NAME><![CDATA[Order date]]></NAME>
+<!--DFFE8FF0D0D8414796B134FA89E07F43-->  <WIDTH><![CDATA[10]]></WIDTH>
+<!--DFFE8FF0D0D8414796B134FA89E07F43-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--DFFE8FF0D0D8414796B134FA89E07F43-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
+<!--DFFE8FF0D0D8414796B134FA89E07F43-->  <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN>
+<!--DFFE8FF0D0D8414796B134FA89E07F43-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
+<!--DFFE8FF0D0D8414796B134FA89E07F43--></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>
--- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Thu Dec 30 18:00:48 2010 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Thu Dec 30 18:06:38 2010 +0100
@@ -61,6 +61,37 @@
 order by p.paymentDate]]></HQL>
 <!--E5A0DC8536134185AC8B1897F15DB816--></OBCQL_WIDGET_QUERY>
 
+<!--F5DEE669DD8047FB831A12064BB277BE--><OBCQL_WIDGET_QUERY>
+<!--F5DEE669DD8047FB831A12064BB277BE-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[F5DEE669DD8047FB831A12064BB277BE]]></OBCQL_WIDGET_QUERY_ID>
+<!--F5DEE669DD8047FB831A12064BB277BE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F5DEE669DD8047FB831A12064BB277BE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F5DEE669DD8047FB831A12064BB277BE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F5DEE669DD8047FB831A12064BB277BE-->  <OBKMO_WIDGET_CLASS_ID><![CDATA[8267FB3F59D7401980DDDEFF51FE55C3]]></OBKMO_WIDGET_CLASS_ID>
+<!--F5DEE669DD8047FB831A12064BB277BE-->  <HQL><![CDATA[select ol.salesOrder.id as orderId, ol.salesOrder.orderDate as dateordered,  ol.salesOrder.scheduledDeliveryDate as plannedDeliveryDate,
+ol.salesOrder.documentNo as salesorder, ol.salesOrder.businessPartner.name as bpartner,
+ol.product.name as productname, ol.attributeSetValue.description as attribute, ol.uOM.name as uom,
+ol.orderedQuantity as totalqty, 
+   (select coalesce(sum(po.quantity),0) 
+    from ProcurementPOInvoiceMatch po
+    where po.goodsShipmentLine is not null
+    and po.salesOrderLine = ol) as qtyReceived, 
+   (select ol.orderedQuantity-coalesce(sum(po2.quantity),0) from ProcurementPOInvoiceMatch po2
+    where po2.goodsShipmentLine is not null
+    and po2.salesOrderLine = ol) as qtyPending
+from OrderLine as ol left join ol.attributeSetValue
+where ol.client.id =:client
+and ol.salesOrder.documentStatus='CO'
+and ol.orderedQuantity <> (select coalesce(sum(po3.quantity),0) 
+                            from ProcurementPOInvoiceMatch po3
+                            where po3.goodsShipmentLine is not null
+                            and po3.salesOrderLine = ol)
+and ol.salesOrder.scheduledDeliveryDate<=now()
+and ol.product.name like :productname
+and ol.salesOrder.businessPartner.name like :suppliername
+and ol.salesOrder.documentNo like :documentno
+order by ol.salesOrder.scheduledDeliveryDate, ol.salesOrder.documentNo]]></HQL>
+<!--F5DEE669DD8047FB831A12064BB277BE--></OBCQL_WIDGET_QUERY>
+
 <!--F94AEB4680AD4AD48255071903000A43--><OBCQL_WIDGET_QUERY>
 <!--F94AEB4680AD4AD48255071903000A43-->  <OBCQL_WIDGET_QUERY_ID><![CDATA[F94AEB4680AD4AD48255071903000A43]]></OBCQL_WIDGET_QUERY_ID>
 <!--F94AEB4680AD4AD48255071903000A43-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml	Thu Dec 30 18:00:48 2010 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml	Thu Dec 30 18:06:38 2010 +0100
@@ -59,6 +59,21 @@
 <!--34F279BBB85945519DC38F21573106C0-->  <CAN_MAXIMIZE><![CDATA[N]]></CAN_MAXIMIZE>
 <!--34F279BBB85945519DC38F21573106C0--></OBKMO_WIDGET_CLASS>
 
+<!--8267FB3F59D7401980DDDEFF51FE55C3--><OBKMO_WIDGET_CLASS>
+<!--8267FB3F59D7401980DDDEFF51FE55C3-->  <OBKMO_WIDGET_CLASS_ID><![CDATA[8267FB3F59D7401980DDDEFF51FE55C3]]></OBKMO_WIDGET_CLASS_ID>
+<!--8267FB3F59D7401980DDDEFF51FE55C3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--8267FB3F59D7401980DDDEFF51FE55C3-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--8267FB3F59D7401980DDDEFF51FE55C3-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--8267FB3F59D7401980DDDEFF51FE55C3-->  <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID>
+<!--8267FB3F59D7401980DDDEFF51FE55C3-->  <TITLE><![CDATA[Pending goods receipt]]></TITLE>
+<!--8267FB3F59D7401980DDDEFF51FE55C3-->  <HEIGHT><![CDATA[300]]></HEIGHT>
+<!--8267FB3F59D7401980DDDEFF51FE55C3-->  <DESCRIPTION><![CDATA[This widget shows you all the Purchase orders that are pending to be delivered by the supplier once the planned delivery date is later than the current date]]></DESCRIPTION>
+<!--8267FB3F59D7401980DDDEFF51FE55C3-->  <ALLOW_ANONYMOUS_ACCESS><![CDATA[Y]]></ALLOW_ANONYMOUS_ACCESS>
+<!--8267FB3F59D7401980DDDEFF51FE55C3-->  <ISSUPERCLASS><![CDATA[N]]></ISSUPERCLASS>
+<!--8267FB3F59D7401980DDDEFF51FE55C3-->  <WIDGET_SUPERCLASS_ID><![CDATA[2A32CF26F3F64FE39C7F94E9D82497D1]]></WIDGET_SUPERCLASS_ID>
+<!--8267FB3F59D7401980DDDEFF51FE55C3-->  <CAN_MAXIMIZE><![CDATA[N]]></CAN_MAXIMIZE>
+<!--8267FB3F59D7401980DDDEFF51FE55C3--></OBKMO_WIDGET_CLASS>
+
 <!--F8E4F382BCFB441CADBB4AC693C41C93--><OBKMO_WIDGET_CLASS>
 <!--F8E4F382BCFB441CADBB4AC693C41C93-->  <OBKMO_WIDGET_CLASS_ID><![CDATA[F8E4F382BCFB441CADBB4AC693C41C93]]></OBKMO_WIDGET_CLASS_ID>
 <!--F8E4F382BCFB441CADBB4AC693C41C93-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml	Thu Dec 30 18:00:48 2010 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml	Thu Dec 30 18:06:38 2010 +0100
@@ -113,6 +113,25 @@
 <!--3A93E12C289149CCB2CD1ECA2643469C-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[2A32CF26F3F64FE39C7F94E9D82497D1]]></EM_OBKMO_WIDGET_CLASS_ID>
 <!--3A93E12C289149CCB2CD1ECA2643469C--></OBUIAPP_PARAMETER>
 
+<!--49F3E4DE139D429997B272E51459F782--><OBUIAPP_PARAMETER>
+<!--49F3E4DE139D429997B272E51459F782-->  <OBUIAPP_PARAMETER_ID><![CDATA[49F3E4DE139D429997B272E51459F782]]></OBUIAPP_PARAMETER_ID>
+<!--49F3E4DE139D429997B272E51459F782-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--49F3E4DE139D429997B272E51459F782-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--49F3E4DE139D429997B272E51459F782-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--49F3E4DE139D429997B272E51459F782-->  <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID>
+<!--49F3E4DE139D429997B272E51459F782-->  <NAME><![CDATA[Document no]]></NAME>
+<!--49F3E4DE139D429997B272E51459F782-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--49F3E4DE139D429997B272E51459F782-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--49F3E4DE139D429997B272E51459F782-->  <COLUMNNAME><![CDATA[documentno]]></COLUMNNAME>
+<!--49F3E4DE139D429997B272E51459F782-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--49F3E4DE139D429997B272E51459F782-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
+<!--49F3E4DE139D429997B272E51459F782-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--49F3E4DE139D429997B272E51459F782-->  <DEFAULTVALUE><![CDATA[%]]></DEFAULTVALUE>
+<!--49F3E4DE139D429997B272E51459F782-->  <ISFIXED><![CDATA[N]]></ISFIXED>
+<!--49F3E4DE139D429997B272E51459F782-->  <EVALUATEFIXEDVALUE><![CDATA[N]]></EVALUATEFIXEDVALUE>
+<!--49F3E4DE139D429997B272E51459F782-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[8267FB3F59D7401980DDDEFF51FE55C3]]></EM_OBKMO_WIDGET_CLASS_ID>
+<!--49F3E4DE139D429997B272E51459F782--></OBUIAPP_PARAMETER>
+
 <!--4FD80623A37C42478E5F71570F98DD05--><OBUIAPP_PARAMETER>
 <!--4FD80623A37C42478E5F71570F98DD05-->  <OBUIAPP_PARAMETER_ID><![CDATA[4FD80623A37C42478E5F71570F98DD05]]></OBUIAPP_PARAMETER_ID>
 <!--4FD80623A37C42478E5F71570F98DD05-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -151,6 +170,25 @@
 <!--5BC2F2EC1140442CA332446CFB9B84BE-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[2662490B7D3B4F80AF308C88F6DB68C0]]></EM_OBKMO_WIDGET_CLASS_ID>
 <!--5BC2F2EC1140442CA332446CFB9B84BE--></OBUIAPP_PARAMETER>
 
+<!--7DC0751F8EA64F738DCD618B244407B7--><OBUIAPP_PARAMETER>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <OBUIAPP_PARAMETER_ID><![CDATA[7DC0751F8EA64F738DCD618B244407B7]]></OBUIAPP_PARAMETER_ID>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <NAME><![CDATA[Supplier]]></NAME>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <SEQNO><![CDATA[40]]></SEQNO>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <COLUMNNAME><![CDATA[suppliername]]></COLUMNNAME>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <FIELDLENGTH><![CDATA[30]]></FIELDLENGTH>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <DEFAULTVALUE><![CDATA[%]]></DEFAULTVALUE>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <ISFIXED><![CDATA[N]]></ISFIXED>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <EVALUATEFIXEDVALUE><![CDATA[N]]></EVALUATEFIXEDVALUE>
+<!--7DC0751F8EA64F738DCD618B244407B7-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[8267FB3F59D7401980DDDEFF51FE55C3]]></EM_OBKMO_WIDGET_CLASS_ID>
+<!--7DC0751F8EA64F738DCD618B244407B7--></OBUIAPP_PARAMETER>
+
 <!--7DF9ECB3B365453AB0F18978049477C1--><OBUIAPP_PARAMETER>
 <!--7DF9ECB3B365453AB0F18978049477C1-->  <OBUIAPP_PARAMETER_ID><![CDATA[7DF9ECB3B365453AB0F18978049477C1]]></OBUIAPP_PARAMETER_ID>
 <!--7DF9ECB3B365453AB0F18978049477C1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -208,6 +246,25 @@
 <!--85337BACFD654FB682935663BAFE067A-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[147D825456D54D0486C3D7072531C5C9]]></EM_OBKMO_WIDGET_CLASS_ID>
 <!--85337BACFD654FB682935663BAFE067A--></OBUIAPP_PARAMETER>
 
+<!--9049BDED6A664F93B2A4EA9084C96A55--><OBUIAPP_PARAMETER>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <OBUIAPP_PARAMETER_ID><![CDATA[9049BDED6A664F93B2A4EA9084C96A55]]></OBUIAPP_PARAMETER_ID>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <NAME><![CDATA[Show all data]]></NAME>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <COLUMNNAME><![CDATA[showAll]]></COLUMNNAME>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <DEFAULTVALUE><![CDATA[false]]></DEFAULTVALUE>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <ISFIXED><![CDATA[N]]></ISFIXED>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <EVALUATEFIXEDVALUE><![CDATA[N]]></EVALUATEFIXEDVALUE>
+<!--9049BDED6A664F93B2A4EA9084C96A55-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[8267FB3F59D7401980DDDEFF51FE55C3]]></EM_OBKMO_WIDGET_CLASS_ID>
+<!--9049BDED6A664F93B2A4EA9084C96A55--></OBUIAPP_PARAMETER>
+
 <!--915CDEE8D7954D17A01328E33F28FE88--><OBUIAPP_PARAMETER>
 <!--915CDEE8D7954D17A01328E33F28FE88-->  <OBUIAPP_PARAMETER_ID><![CDATA[915CDEE8D7954D17A01328E33F28FE88]]></OBUIAPP_PARAMETER_ID>
 <!--915CDEE8D7954D17A01328E33F28FE88-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -246,6 +303,25 @@
 <!--986388F09F4F4465A3CC3D6A4E381F57-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[34F279BBB85945519DC38F21573106C0]]></EM_OBKMO_WIDGET_CLASS_ID>
 <!--986388F09F4F4465A3CC3D6A4E381F57--></OBUIAPP_PARAMETER>
 
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52--><OBUIAPP_PARAMETER>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <OBUIAPP_PARAMETER_ID><![CDATA[9A19936CAFDB4198BB5D3F1EA9D9BF52]]></OBUIAPP_PARAMETER_ID>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <NAME><![CDATA[Client]]></NAME>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <COLUMNNAME><![CDATA[client]]></COLUMNNAME>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <FIELDLENGTH><![CDATA[40]]></FIELDLENGTH>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <ISFIXED><![CDATA[Y]]></ISFIXED>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <FIXEDVALUE><![CDATA[OB.getContext().getCurrentClient().id]]></FIXEDVALUE>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <EVALUATEFIXEDVALUE><![CDATA[Y]]></EVALUATEFIXEDVALUE>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[8267FB3F59D7401980DDDEFF51FE55C3]]></EM_OBKMO_WIDGET_CLASS_ID>
+<!--9A19936CAFDB4198BB5D3F1EA9D9BF52--></OBUIAPP_PARAMETER>
+
 <!--A0A9C9C09E3E4B3FB139B336B142318C--><OBUIAPP_PARAMETER>
 <!--A0A9C9C09E3E4B3FB139B336B142318C-->  <OBUIAPP_PARAMETER_ID><![CDATA[A0A9C9C09E3E4B3FB139B336B142318C]]></OBUIAPP_PARAMETER_ID>
 <!--A0A9C9C09E3E4B3FB139B336B142318C-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -322,6 +398,24 @@
 <!--B69521B5EEF14B578FB69FF5B353530E-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[2662490B7D3B4F80AF308C88F6DB68C0]]></EM_OBKMO_WIDGET_CLASS_ID>
 <!--B69521B5EEF14B578FB69FF5B353530E--></OBUIAPP_PARAMETER>
 
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35--><OBUIAPP_PARAMETER>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <OBUIAPP_PARAMETER_ID><![CDATA[B9096C5B26D54130B7DD5E6DC2FFCE35]]></OBUIAPP_PARAMETER_ID>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <NAME><![CDATA[Number of Rows]]></NAME>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <SEQNO><![CDATA[0]]></SEQNO>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <COLUMNNAME><![CDATA[RowsNumber]]></COLUMNNAME>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <ISFIXED><![CDATA[N]]></ISFIXED>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <EVALUATEFIXEDVALUE><![CDATA[N]]></EVALUATEFIXEDVALUE>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[8267FB3F59D7401980DDDEFF51FE55C3]]></EM_OBKMO_WIDGET_CLASS_ID>
+<!--B9096C5B26D54130B7DD5E6DC2FFCE35--></OBUIAPP_PARAMETER>
+
 <!--CE2B1B71E2C24E70825601B9D32EE75E--><OBUIAPP_PARAMETER>
 <!--CE2B1B71E2C24E70825601B9D32EE75E-->  <OBUIAPP_PARAMETER_ID><![CDATA[CE2B1B71E2C24E70825601B9D32EE75E]]></OBUIAPP_PARAMETER_ID>
 <!--CE2B1B71E2C24E70825601B9D32EE75E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -341,6 +435,25 @@
 <!--CE2B1B71E2C24E70825601B9D32EE75E-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[2662490B7D3B4F80AF308C88F6DB68C0]]></EM_OBKMO_WIDGET_CLASS_ID>
 <!--CE2B1B71E2C24E70825601B9D32EE75E--></OBUIAPP_PARAMETER>
 
+<!--D0335F9B1A45470A990020CE2ADA3286--><OBUIAPP_PARAMETER>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <OBUIAPP_PARAMETER_ID><![CDATA[D0335F9B1A45470A990020CE2ADA3286]]></OBUIAPP_PARAMETER_ID>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <NAME><![CDATA[Product]]></NAME>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <COLUMNNAME><![CDATA[productname]]></COLUMNNAME>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <FIELDLENGTH><![CDATA[30]]></FIELDLENGTH>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <DEFAULTVALUE><![CDATA[%]]></DEFAULTVALUE>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <ISFIXED><![CDATA[N]]></ISFIXED>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <EVALUATEFIXEDVALUE><![CDATA[N]]></EVALUATEFIXEDVALUE>
+<!--D0335F9B1A45470A990020CE2ADA3286-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[8267FB3F59D7401980DDDEFF51FE55C3]]></EM_OBKMO_WIDGET_CLASS_ID>
+<!--D0335F9B1A45470A990020CE2ADA3286--></OBUIAPP_PARAMETER>
+
 <!--D5DE165821F24FCC85707DDEA592BB27--><OBUIAPP_PARAMETER>
 <!--D5DE165821F24FCC85707DDEA592BB27-->  <OBUIAPP_PARAMETER_ID><![CDATA[D5DE165821F24FCC85707DDEA592BB27]]></OBUIAPP_PARAMETER_ID>
 <!--D5DE165821F24FCC85707DDEA592BB27-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>