details: /erp/devel/pi/rev/87b7b9f1e388 changeset: 9333:87b7b9f1e388 user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Thu Dec 23 14:10:47 2010 +0100 summary: [OBCQL] Added two Widgets: Payment In - Out awaiting for execution
diffstat: modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml | 138 +++++++++ modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml | 38 ++ modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml | 30 + modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml | 152 ++++++++++ 4 files changed, 358 insertions(+), 0 deletions(-) diffs (truncated from 445 to 300 lines): diff -r 533322e2fd25 -r 87b7b9f1e388 modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml --- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml Thu Dec 23 13:30:45 2010 +0100 +++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml Thu Dec 23 14:10:47 2010 +0100 @@ -16,6 +16,23 @@ <!--12479D7FA3AC4C2E8C9011013A090376--> <HAS_LINK><![CDATA[N]]></HAS_LINK> <!--12479D7FA3AC4C2E8C9011013A090376--></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> +<!--15817E30D88A4E04ACA56D1E92D24FD7--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--15817E30D88A4E04ACA56D1E92D24FD7--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--15817E30D88A4E04ACA56D1E92D24FD7--> <OBCQL_WIDGET_QUERY_ID><![CDATA[F94AEB4680AD4AD48255071903000A43]]></OBCQL_WIDGET_QUERY_ID> +<!--15817E30D88A4E04ACA56D1E92D24FD7--> <DISPLAY_EXPRESSION><![CDATA[paymentDate]]></DISPLAY_EXPRESSION> +<!--15817E30D88A4E04ACA56D1E92D24FD7--> <NAME><![CDATA[Date]]></NAME> +<!--15817E30D88A4E04ACA56D1E92D24FD7--> <WIDTH><![CDATA[100]]></WIDTH> +<!--15817E30D88A4E04ACA56D1E92D24FD7--> <LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION> +<!--15817E30D88A4E04ACA56D1E92D24FD7--> <SEQNO><![CDATA[30]]></SEQNO> +<!--15817E30D88A4E04ACA56D1E92D24FD7--> <AD_REFERENCE_ID><![CDATA[10]]></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--></OBCQL_QUERY_COLUMN> + <!--1B0F7BAEABF54A8EAB2CAA5A04A107DB--><OBCQL_QUERY_COLUMN> <!--1B0F7BAEABF54A8EAB2CAA5A04A107DB--> <OBCQL_QUERY_COLUMN_ID><![CDATA[1B0F7BAEABF54A8EAB2CAA5A04A107DB]]></OBCQL_QUERY_COLUMN_ID> <!--1B0F7BAEABF54A8EAB2CAA5A04A107DB--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -99,6 +116,23 @@ <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <AD_TAB_ID><![CDATA[263]]></AD_TAB_ID> <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--></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> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <OBCQL_WIDGET_QUERY_ID><![CDATA[E5A0DC8536134185AC8B1897F15DB816]]></OBCQL_WIDGET_QUERY_ID> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <DISPLAY_EXPRESSION><![CDATA[documentNo]]></DISPLAY_EXPRESSION> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <NAME><![CDATA[Document Number]]></NAME> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <WIDTH><![CDATA[100]]></WIDTH> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <SEQNO><![CDATA[10]]></SEQNO> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <AD_TAB_ID><![CDATA[C4B6506838E14A349D6717D6856F1B56]]></AD_TAB_ID> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--></OBCQL_QUERY_COLUMN> + <!--51429339D294475986634D7E876F4A53--><OBCQL_QUERY_COLUMN> <!--51429339D294475986634D7E876F4A53--> <OBCQL_QUERY_COLUMN_ID><![CDATA[51429339D294475986634D7E876F4A53]]></OBCQL_QUERY_COLUMN_ID> <!--51429339D294475986634D7E876F4A53--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -131,6 +165,58 @@ <!--538673CEF1D04E71B0D27DF9A3C34594--> <HAS_LINK><![CDATA[N]]></HAS_LINK> <!--538673CEF1D04E71B0D27DF9A3C34594--></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> +<!--56DC401F52BF4BE593C782240AE4AB67--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--56DC401F52BF4BE593C782240AE4AB67--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--56DC401F52BF4BE593C782240AE4AB67--> <OBCQL_WIDGET_QUERY_ID><![CDATA[E5A0DC8536134185AC8B1897F15DB816]]></OBCQL_WIDGET_QUERY_ID> +<!--56DC401F52BF4BE593C782240AE4AB67--> <DISPLAY_EXPRESSION><![CDATA[amount]]></DISPLAY_EXPRESSION> +<!--56DC401F52BF4BE593C782240AE4AB67--> <NAME><![CDATA[Amount]]></NAME> +<!--56DC401F52BF4BE593C782240AE4AB67--> <SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE> +<!--56DC401F52BF4BE593C782240AE4AB67--> <WIDTH><![CDATA[100]]></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--></OBCQL_QUERY_COLUMN> + +<!--6B151041105E4DD0805AC2F709A7A81E--><OBCQL_QUERY_COLUMN> +<!--6B151041105E4DD0805AC2F709A7A81E--> <OBCQL_QUERY_COLUMN_ID><![CDATA[6B151041105E4DD0805AC2F709A7A81E]]></OBCQL_QUERY_COLUMN_ID> +<!--6B151041105E4DD0805AC2F709A7A81E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--6B151041105E4DD0805AC2F709A7A81E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--6B151041105E4DD0805AC2F709A7A81E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--6B151041105E4DD0805AC2F709A7A81E--> <OBCQL_WIDGET_QUERY_ID><![CDATA[E5A0DC8536134185AC8B1897F15DB816]]></OBCQL_WIDGET_QUERY_ID> +<!--6B151041105E4DD0805AC2F709A7A81E--> <DISPLAY_EXPRESSION><![CDATA[paymentDate]]></DISPLAY_EXPRESSION> +<!--6B151041105E4DD0805AC2F709A7A81E--> <NAME><![CDATA[Date]]></NAME> +<!--6B151041105E4DD0805AC2F709A7A81E--> <WIDTH><![CDATA[100]]></WIDTH> +<!--6B151041105E4DD0805AC2F709A7A81E--> <LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION> +<!--6B151041105E4DD0805AC2F709A7A81E--> <SEQNO><![CDATA[30]]></SEQNO> +<!--6B151041105E4DD0805AC2F709A7A81E--> <AD_REFERENCE_ID><![CDATA[10]]></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--></OBCQL_QUERY_COLUMN> + +<!--70CEB497CA254F3C892AE0B68920897D--><OBCQL_QUERY_COLUMN> +<!--70CEB497CA254F3C892AE0B68920897D--> <OBCQL_QUERY_COLUMN_ID><![CDATA[70CEB497CA254F3C892AE0B68920897D]]></OBCQL_QUERY_COLUMN_ID> +<!--70CEB497CA254F3C892AE0B68920897D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--70CEB497CA254F3C892AE0B68920897D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--70CEB497CA254F3C892AE0B68920897D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--70CEB497CA254F3C892AE0B68920897D--> <OBCQL_WIDGET_QUERY_ID><![CDATA[E5A0DC8536134185AC8B1897F15DB816]]></OBCQL_WIDGET_QUERY_ID> +<!--70CEB497CA254F3C892AE0B68920897D--> <DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION> +<!--70CEB497CA254F3C892AE0B68920897D--> <NAME><![CDATA[Business Partner]]></NAME> +<!--70CEB497CA254F3C892AE0B68920897D--> <WIDTH><![CDATA[100]]></WIDTH> +<!--70CEB497CA254F3C892AE0B68920897D--> <LINK_EXPRESSION><![CDATA[finpaymentId]]></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--></OBCQL_QUERY_COLUMN> + <!--742D993ADF7444318F8CAF38DDCB1997--><OBCQL_QUERY_COLUMN> <!--742D993ADF7444318F8CAF38DDCB1997--> <OBCQL_QUERY_COLUMN_ID><![CDATA[742D993ADF7444318F8CAF38DDCB1997]]></OBCQL_QUERY_COLUMN_ID> <!--742D993ADF7444318F8CAF38DDCB1997--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -148,6 +234,40 @@ <!--742D993ADF7444318F8CAF38DDCB1997--> <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID> <!--742D993ADF7444318F8CAF38DDCB1997--></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> +<!--94B1051270614629B02531C5F894BCF1--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--94B1051270614629B02531C5F894BCF1--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--94B1051270614629B02531C5F894BCF1--> <OBCQL_WIDGET_QUERY_ID><![CDATA[F94AEB4680AD4AD48255071903000A43]]></OBCQL_WIDGET_QUERY_ID> +<!--94B1051270614629B02531C5F894BCF1--> <DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION> +<!--94B1051270614629B02531C5F894BCF1--> <NAME><![CDATA[Business Partner]]></NAME> +<!--94B1051270614629B02531C5F894BCF1--> <WIDTH><![CDATA[100]]></WIDTH> +<!--94B1051270614629B02531C5F894BCF1--> <LINK_EXPRESSION><![CDATA[finpaymentId]]></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--></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> +<!--9FC7E75A21F34920AA2695261935FD06--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--9FC7E75A21F34920AA2695261935FD06--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--9FC7E75A21F34920AA2695261935FD06--> <OBCQL_WIDGET_QUERY_ID><![CDATA[F94AEB4680AD4AD48255071903000A43]]></OBCQL_WIDGET_QUERY_ID> +<!--9FC7E75A21F34920AA2695261935FD06--> <DISPLAY_EXPRESSION><![CDATA[documentNo]]></DISPLAY_EXPRESSION> +<!--9FC7E75A21F34920AA2695261935FD06--> <NAME><![CDATA[Document Number]]></NAME> +<!--9FC7E75A21F34920AA2695261935FD06--> <WIDTH><![CDATA[100]]></WIDTH> +<!--9FC7E75A21F34920AA2695261935FD06--> <LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION> +<!--9FC7E75A21F34920AA2695261935FD06--> <SEQNO><![CDATA[10]]></SEQNO> +<!--9FC7E75A21F34920AA2695261935FD06--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--9FC7E75A21F34920AA2695261935FD06--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--9FC7E75A21F34920AA2695261935FD06--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> +<!--9FC7E75A21F34920AA2695261935FD06--> <AD_TAB_ID><![CDATA[F7A52FDAAA0346EFA07D53C125B40404]]></AD_TAB_ID> +<!--9FC7E75A21F34920AA2695261935FD06--></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> @@ -201,4 +321,22 @@ <!--FAB0DB1A67D948DB85AD5918B7845ABF--> <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID> <!--FAB0DB1A67D948DB85AD5918B7845ABF--></OBCQL_QUERY_COLUMN> +<!--FE9812790C0943C584999CEAAD93E95D--><OBCQL_QUERY_COLUMN> +<!--FE9812790C0943C584999CEAAD93E95D--> <OBCQL_QUERY_COLUMN_ID><![CDATA[FE9812790C0943C584999CEAAD93E95D]]></OBCQL_QUERY_COLUMN_ID> +<!--FE9812790C0943C584999CEAAD93E95D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--FE9812790C0943C584999CEAAD93E95D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--FE9812790C0943C584999CEAAD93E95D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--FE9812790C0943C584999CEAAD93E95D--> <OBCQL_WIDGET_QUERY_ID><![CDATA[F94AEB4680AD4AD48255071903000A43]]></OBCQL_WIDGET_QUERY_ID> +<!--FE9812790C0943C584999CEAAD93E95D--> <DISPLAY_EXPRESSION><![CDATA[amount]]></DISPLAY_EXPRESSION> +<!--FE9812790C0943C584999CEAAD93E95D--> <NAME><![CDATA[Amount]]></NAME> +<!--FE9812790C0943C584999CEAAD93E95D--> <SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE> +<!--FE9812790C0943C584999CEAAD93E95D--> <WIDTH><![CDATA[100]]></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--></OBCQL_QUERY_COLUMN> + </data> diff -r 533322e2fd25 -r 87b7b9f1e388 modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml --- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml Thu Dec 23 13:30:45 2010 +0100 +++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml Thu Dec 23 14:10:47 2010 +0100 @@ -53,4 +53,42 @@ order by myWindow.name]]></HQL> <!--C0A8491CDB43466D9F2645018473588B--></OBCQL_WIDGET_QUERY> +<!--E5A0DC8536134185AC8B1897F15DB816--><OBCQL_WIDGET_QUERY> +<!--E5A0DC8536134185AC8B1897F15DB816--> <OBCQL_WIDGET_QUERY_ID><![CDATA[E5A0DC8536134185AC8B1897F15DB816]]></OBCQL_WIDGET_QUERY_ID> +<!--E5A0DC8536134185AC8B1897F15DB816--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--E5A0DC8536134185AC8B1897F15DB816--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--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.paymentDate as paymentDate, p.amount as amount +from FIN_Payment as p +where p.businessPartner.name like :businessPartnerName + and p.documentNo like :documentNo + and p.client.id = :client + and p.processed = true + and p.receipt = true + and p.status = 'RPAE' +order by p.paymentDate]]></HQL> +<!--E5A0DC8536134185AC8B1897F15DB816--></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> +<!--F94AEB4680AD4AD48255071903000A43--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--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.paymentDate as paymentDate, p.amount as amount +from FIN_Payment as p +where p.businessPartner.name like :businessPartnerName + and p.documentNo like :documentNo + and p.client.id = :client + and p.processed = true + and p.receipt = false + and p.status = 'RPAE' +order by p.paymentDate]]></HQL> +<!--F94AEB4680AD4AD48255071903000A43--></OBCQL_WIDGET_QUERY> + </data> diff -r 533322e2fd25 -r 87b7b9f1e388 modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml --- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml Thu Dec 23 13:30:45 2010 +0100 +++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml Thu Dec 23 14:10:47 2010 +0100 @@ -15,6 +15,21 @@ <!--147D825456D54D0486C3D7072531C5C9--> <CAN_MAXIMIZE><![CDATA[N]]></CAN_MAXIMIZE> <!--147D825456D54D0486C3D7072531C5C9--></OBKMO_WIDGET_CLASS> +<!--2662490B7D3B4F80AF308C88F6DB68C0--><OBKMO_WIDGET_CLASS> +<!--2662490B7D3B4F80AF308C88F6DB68C0--> <OBKMO_WIDGET_CLASS_ID><![CDATA[2662490B7D3B4F80AF308C88F6DB68C0]]></OBKMO_WIDGET_CLASS_ID> +<!--2662490B7D3B4F80AF308C88F6DB68C0--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--2662490B7D3B4F80AF308C88F6DB68C0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--2662490B7D3B4F80AF308C88F6DB68C0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--2662490B7D3B4F80AF308C88F6DB68C0--> <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID> +<!--2662490B7D3B4F80AF308C88F6DB68C0--> <TITLE><![CDATA[Payment In - awaiting for execution]]></TITLE> +<!--2662490B7D3B4F80AF308C88F6DB68C0--> <HEIGHT><![CDATA[300]]></HEIGHT> +<!--2662490B7D3B4F80AF308C88F6DB68C0--> <DESCRIPTION><![CDATA[Shows all the received payments in awaiting execution status.]]></DESCRIPTION> +<!--2662490B7D3B4F80AF308C88F6DB68C0--> <ALLOW_ANONYMOUS_ACCESS><![CDATA[Y]]></ALLOW_ANONYMOUS_ACCESS> +<!--2662490B7D3B4F80AF308C88F6DB68C0--> <ISSUPERCLASS><![CDATA[N]]></ISSUPERCLASS> +<!--2662490B7D3B4F80AF308C88F6DB68C0--> <WIDGET_SUPERCLASS_ID><![CDATA[2A32CF26F3F64FE39C7F94E9D82497D1]]></WIDGET_SUPERCLASS_ID> +<!--2662490B7D3B4F80AF308C88F6DB68C0--> <CAN_MAXIMIZE><![CDATA[N]]></CAN_MAXIMIZE> +<!--2662490B7D3B4F80AF308C88F6DB68C0--></OBKMO_WIDGET_CLASS> + <!--2A32CF26F3F64FE39C7F94E9D82497D1--><OBKMO_WIDGET_CLASS> <!--2A32CF26F3F64FE39C7F94E9D82497D1--> <OBKMO_WIDGET_CLASS_ID><![CDATA[2A32CF26F3F64FE39C7F94E9D82497D1]]></OBKMO_WIDGET_CLASS_ID> <!--2A32CF26F3F64FE39C7F94E9D82497D1--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -58,4 +73,19 @@ <!--D1E4261099AE4095B2F2DAEE0F7E7784--> <CAN_MAXIMIZE><![CDATA[N]]></CAN_MAXIMIZE> <!--D1E4261099AE4095B2F2DAEE0F7E7784--></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> +<!--F8E4F382BCFB441CADBB4AC693C41C93--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--F8E4F382BCFB441CADBB4AC693C41C93--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--F8E4F382BCFB441CADBB4AC693C41C93--> <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID> +<!--F8E4F382BCFB441CADBB4AC693C41C93--> <TITLE><![CDATA[Payment Out - awaiting for execution]]></TITLE> +<!--F8E4F382BCFB441CADBB4AC693C41C93--> <HEIGHT><![CDATA[300]]></HEIGHT> +<!--F8E4F382BCFB441CADBB4AC693C41C93--> <DESCRIPTION><![CDATA[Shows all the made payments in awaiting execution status.]]></DESCRIPTION> +<!--F8E4F382BCFB441CADBB4AC693C41C93--> <ALLOW_ANONYMOUS_ACCESS><![CDATA[Y]]></ALLOW_ANONYMOUS_ACCESS> +<!--F8E4F382BCFB441CADBB4AC693C41C93--> <ISSUPERCLASS><![CDATA[N]]></ISSUPERCLASS> +<!--F8E4F382BCFB441CADBB4AC693C41C93--> <WIDGET_SUPERCLASS_ID><![CDATA[2A32CF26F3F64FE39C7F94E9D82497D1]]></WIDGET_SUPERCLASS_ID> +<!--F8E4F382BCFB441CADBB4AC693C41C93--> <CAN_MAXIMIZE><![CDATA[N]]></CAN_MAXIMIZE> +<!--F8E4F382BCFB441CADBB4AC693C41C93--></OBKMO_WIDGET_CLASS> + </data> diff -r 533322e2fd25 -r 87b7b9f1e388 modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml --- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml Thu Dec 23 13:30:45 2010 +0100 +++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml Thu Dec 23 14:10:47 2010 +0100 @@ -1,5 +1,43 @@ <?xml version='1.0' encoding='UTF-8'?> <data> +<!--055B5973EDE34DE9B30F3F735A2C86F4--><OBUIAPP_PARAMETER> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <OBUIAPP_PARAMETER_ID><![CDATA[055B5973EDE34DE9B30F3F735A2C86F4]]></OBUIAPP_PARAMETER_ID> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <NAME><![CDATA[Business Partner]]></NAME> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <SEQNO><![CDATA[20]]></SEQNO> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <COLUMNNAME><![CDATA[businessPartnerName]]></COLUMNNAME> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <DEFAULTVALUE><![CDATA[%]]></DEFAULTVALUE> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <ISFIXED><![CDATA[N]]></ISFIXED> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <EVALUATEFIXEDVALUE><![CDATA[N]]></EVALUATEFIXEDVALUE> +<!--055B5973EDE34DE9B30F3F735A2C86F4--> <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[F8E4F382BCFB441CADBB4AC693C41C93]]></EM_OBKMO_WIDGET_CLASS_ID> +<!--055B5973EDE34DE9B30F3F735A2C86F4--></OBUIAPP_PARAMETER> + +<!--13CD381B3DBA4898BC4542408BB2D414--><OBUIAPP_PARAMETER> +<!--13CD381B3DBA4898BC4542408BB2D414--> <OBUIAPP_PARAMETER_ID><![CDATA[13CD381B3DBA4898BC4542408BB2D414]]></OBUIAPP_PARAMETER_ID> +<!--13CD381B3DBA4898BC4542408BB2D414--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--13CD381B3DBA4898BC4542408BB2D414--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--13CD381B3DBA4898BC4542408BB2D414--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--13CD381B3DBA4898BC4542408BB2D414--> <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID> +<!--13CD381B3DBA4898BC4542408BB2D414--> <NAME><![CDATA[Client]]></NAME> +<!--13CD381B3DBA4898BC4542408BB2D414--> <SEQNO><![CDATA[30]]></SEQNO> +<!--13CD381B3DBA4898BC4542408BB2D414--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--13CD381B3DBA4898BC4542408BB2D414--> <COLUMNNAME><![CDATA[client]]></COLUMNNAME> ------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
