details: https://code.openbravo.com/erp/devel/pi/rev/e557ef28eb74 changeset: 33231:e557ef28eb74 user: Armaignac <collazoandy4 <at> gmail.com> date: Tue Jan 23 20:42:37 2018 -0500 summary: Fixes issue 37664:Perfomance issue in Invoice Line drop down of Landed Cost Cost
On a environment with huge number of invoices the drop down to select a invoice line in the Cost tab of Landed Cost window takes too much time to load. The where clause of the selector was wrong. It should filter out also the invoices that have been completely matched in the Matched Amount tab and are not in the Landed Cost Cost tab. Two new auxiliary input was added to compute the product and account ids defined in the landed cost type selected also a callout was added to clear the invoice line field when it's change. The where clause of the selector was updated to properly take into account the invoices details: https://code.openbravo.com/erp/devel/pi/rev/093957bbfa3a changeset: 33232:093957bbfa3a user: David Miguelez <david.miguelez <at> openbravo.com> date: Tue Jan 30 17:29:16 2018 +0100 summary: Related to Issue 33231. Code Review changes * Added another field to PopUp * Changed order in grid of fields * Added missing descriptions and help diffstat: src-db/database/model/tables/C_INVOICELINE.xml | 3 + src-db/database/sourcedata/AD_AUXILIARINPUT.xml | 22 ++ src-db/database/sourcedata/AD_CALLOUT.xml | 10 + src-db/database/sourcedata/AD_COLUMN.xml | 1 + src-db/database/sourcedata/AD_MODEL_OBJECT.xml | 12 + src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml | 10 + src-db/database/sourcedata/AD_REFERENCE.xml | 2 + src-db/database/sourcedata/OBUISEL_SELECTOR.xml | 4 +- src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml | 110 ++++++++++ src/org/openbravo/erpCommon/ad_callouts/SL_LandedCost_Cost_Type.java | 35 +++ 10 files changed, 208 insertions(+), 1 deletions(-) diffs (truncated from 340 to 300 lines): diff -r c05369b23139 -r 093957bbfa3a src-db/database/model/tables/C_INVOICELINE.xml --- a/src-db/database/model/tables/C_INVOICELINE.xml Mon Jan 29 11:38:22 2018 +0100 +++ b/src-db/database/model/tables/C_INVOICELINE.xml Tue Jan 30 17:29:16 2018 +0100 @@ -304,6 +304,9 @@ <foreign-key foreignTable="USER2" name="C_INVOICELINE_USER2"> <reference local="USER2_ID" foreign="USER2_ID"/> </foreign-key> + <index name="C_INVOICELINE_ACCOUNT" unique="false"> + <index-column name="ACCOUNT_ID"/> + </index> <index name="C_INVOICELINE_INOUTLINE" unique="false"> <index-column name="M_INOUTLINE_ID"/> <whereClause><![CDATA[M_INOUTLINE_ID IS NOT NULL]]></whereClause> diff -r c05369b23139 -r 093957bbfa3a src-db/database/sourcedata/AD_AUXILIARINPUT.xml --- a/src-db/database/sourcedata/AD_AUXILIARINPUT.xml Mon Jan 29 11:38:22 2018 +0100 +++ b/src-db/database/sourcedata/AD_AUXILIARINPUT.xml Tue Jan 30 17:29:16 2018 +0100 @@ -2899,6 +2899,17 @@ <!--873024A63FD6429D8B1A64F63E0CBA00--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--873024A63FD6429D8B1A64F63E0CBA00--></AD_AUXILIARINPUT> +<!--87B7050EA8FE4107A196292344363AB4--><AD_AUXILIARINPUT> +<!--87B7050EA8FE4107A196292344363AB4--> <AD_AUXILIARINPUT_ID><![CDATA[87B7050EA8FE4107A196292344363AB4]]></AD_AUXILIARINPUT_ID> +<!--87B7050EA8FE4107A196292344363AB4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--87B7050EA8FE4107A196292344363AB4--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--87B7050EA8FE4107A196292344363AB4--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--87B7050EA8FE4107A196292344363AB4--> <AD_TAB_ID><![CDATA[1C05058D61AC4B69A7E550F32F9F2873]]></AD_TAB_ID> +<!--87B7050EA8FE4107A196292344363AB4--> <NAME><![CDATA[LCC_Account_ID]]></NAME> +<!--87B7050EA8FE4107A196292344363AB4--> <CODE><![CDATA[@SQL=SELECT ACCOUNT_ID FROM M_LC_TYPE WHERE M_LC_TYPE_ID = @M_LC_TYPE_ID@]]></CODE> +<!--87B7050EA8FE4107A196292344363AB4--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--87B7050EA8FE4107A196292344363AB4--></AD_AUXILIARINPUT> + <!--87EA26BD00A04638B556D52621D46131--><AD_AUXILIARINPUT> <!--87EA26BD00A04638B556D52621D46131--> <AD_AUXILIARINPUT_ID><![CDATA[87EA26BD00A04638B556D52621D46131]]></AD_AUXILIARINPUT_ID> <!--87EA26BD00A04638B556D52621D46131--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -4009,6 +4020,17 @@ <!--D65958E069304E5F942AA839A6B457AD--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--D65958E069304E5F942AA839A6B457AD--></AD_AUXILIARINPUT> +<!--D6975C5C8F6B4F0F93C0ED903163D470--><AD_AUXILIARINPUT> +<!--D6975C5C8F6B4F0F93C0ED903163D470--> <AD_AUXILIARINPUT_ID><![CDATA[D6975C5C8F6B4F0F93C0ED903163D470]]></AD_AUXILIARINPUT_ID> +<!--D6975C5C8F6B4F0F93C0ED903163D470--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--D6975C5C8F6B4F0F93C0ED903163D470--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--D6975C5C8F6B4F0F93C0ED903163D470--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--D6975C5C8F6B4F0F93C0ED903163D470--> <AD_TAB_ID><![CDATA[1C05058D61AC4B69A7E550F32F9F2873]]></AD_TAB_ID> +<!--D6975C5C8F6B4F0F93C0ED903163D470--> <NAME><![CDATA[LCC_Product_ID]]></NAME> +<!--D6975C5C8F6B4F0F93C0ED903163D470--> <CODE><![CDATA[@SQL=SELECT M_PRODUCT_ID FROM M_LC_TYPE WHERE M_LC_TYPE_ID = @M_LC_TYPE_ID@]]></CODE> +<!--D6975C5C8F6B4F0F93C0ED903163D470--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--D6975C5C8F6B4F0F93C0ED903163D470--></AD_AUXILIARINPUT> + <!--D8E241A6762D4BB48CB3172F447D6306--><AD_AUXILIARINPUT> <!--D8E241A6762D4BB48CB3172F447D6306--> <AD_AUXILIARINPUT_ID><![CDATA[D8E241A6762D4BB48CB3172F447D6306]]></AD_AUXILIARINPUT_ID> <!--D8E241A6762D4BB48CB3172F447D6306--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r c05369b23139 -r 093957bbfa3a src-db/database/sourcedata/AD_CALLOUT.xml --- a/src-db/database/sourcedata/AD_CALLOUT.xml Mon Jan 29 11:38:22 2018 +0100 +++ b/src-db/database/sourcedata/AD_CALLOUT.xml Tue Jan 30 17:29:16 2018 +0100 @@ -1156,6 +1156,16 @@ <!--8D7D52080CF3467093DDE410B7BB0A2F--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--8D7D52080CF3467093DDE410B7BB0A2F--></AD_CALLOUT> +<!--945D318D80ED4920A789C5F5E402A648--><AD_CALLOUT> +<!--945D318D80ED4920A789C5F5E402A648--> <AD_CALLOUT_ID><![CDATA[945D318D80ED4920A789C5F5E402A648]]></AD_CALLOUT_ID> +<!--945D318D80ED4920A789C5F5E402A648--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--945D318D80ED4920A789C5F5E402A648--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--945D318D80ED4920A789C5F5E402A648--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--945D318D80ED4920A789C5F5E402A648--> <NAME><![CDATA[SL_LandedCost_Cost_Type]]></NAME> +<!--945D318D80ED4920A789C5F5E402A648--> <DESCRIPTION><![CDATA[This callout clear the invoice line value so the selector can be recalculated again ]]></DESCRIPTION> +<!--945D318D80ED4920A789C5F5E402A648--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--945D318D80ED4920A789C5F5E402A648--></AD_CALLOUT> + <!--A03EA0C76BB847E7AC3545168FDAF2E9--><AD_CALLOUT> <!--A03EA0C76BB847E7AC3545168FDAF2E9--> <AD_CALLOUT_ID><![CDATA[A03EA0C76BB847E7AC3545168FDAF2E9]]></AD_CALLOUT_ID> <!--A03EA0C76BB847E7AC3545168FDAF2E9--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r c05369b23139 -r 093957bbfa3a src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Mon Jan 29 11:38:22 2018 +0100 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Tue Jan 30 17:29:16 2018 +0100 @@ -240525,6 +240525,7 @@ <!--00568254CB698733E050007F01000513--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> <!--00568254CB698733E050007F01000513--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> <!--00568254CB698733E050007F01000513--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--00568254CB698733E050007F01000513--> <AD_CALLOUT_ID><![CDATA[945D318D80ED4920A789C5F5E402A648]]></AD_CALLOUT_ID> <!--00568254CB698733E050007F01000513--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> <!--00568254CB698733E050007F01000513--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--00568254CB698733E050007F01000513--> <POSITION><![CDATA[11]]></POSITION> diff -r c05369b23139 -r 093957bbfa3a src-db/database/sourcedata/AD_MODEL_OBJECT.xml --- a/src-db/database/sourcedata/AD_MODEL_OBJECT.xml Mon Jan 29 11:38:22 2018 +0100 +++ b/src-db/database/sourcedata/AD_MODEL_OBJECT.xml Tue Jan 30 17:29:16 2018 +0100 @@ -3296,6 +3296,18 @@ <!--36A67D2D76A5488491850AF14F83A6FF--> <SEQNO><![CDATA[10]]></SEQNO> <!--36A67D2D76A5488491850AF14F83A6FF--></AD_MODEL_OBJECT> +<!--3AC9D212955448D59DCBE53BD6F46C72--><AD_MODEL_OBJECT> +<!--3AC9D212955448D59DCBE53BD6F46C72--> <AD_MODEL_OBJECT_ID><![CDATA[3AC9D212955448D59DCBE53BD6F46C72]]></AD_MODEL_OBJECT_ID> +<!--3AC9D212955448D59DCBE53BD6F46C72--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--3AC9D212955448D59DCBE53BD6F46C72--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--3AC9D212955448D59DCBE53BD6F46C72--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--3AC9D212955448D59DCBE53BD6F46C72--> <ACTION><![CDATA[C]]></ACTION> +<!--3AC9D212955448D59DCBE53BD6F46C72--> <CLASSNAME><![CDATA[org.openbravo.erpCommon.ad_callouts.SL_LandedCost_Cost_Type]]></CLASSNAME> +<!--3AC9D212955448D59DCBE53BD6F46C72--> <ISDEFAULT><![CDATA[Y]]></ISDEFAULT> +<!--3AC9D212955448D59DCBE53BD6F46C72--> <AD_CALLOUT_ID><![CDATA[945D318D80ED4920A789C5F5E402A648]]></AD_CALLOUT_ID> +<!--3AC9D212955448D59DCBE53BD6F46C72--> <OBJECT_TYPE><![CDATA[S]]></OBJECT_TYPE> +<!--3AC9D212955448D59DCBE53BD6F46C72--></AD_MODEL_OBJECT> + <!--3AE4CBBFC86345AB8A21A0192F089559--><AD_MODEL_OBJECT> <!--3AE4CBBFC86345AB8A21A0192F089559--> <AD_MODEL_OBJECT_ID><![CDATA[3AE4CBBFC86345AB8A21A0192F089559]]></AD_MODEL_OBJECT_ID> <!--3AE4CBBFC86345AB8A21A0192F089559--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r c05369b23139 -r 093957bbfa3a src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml --- a/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml Mon Jan 29 11:38:22 2018 +0100 +++ b/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml Tue Jan 30 17:29:16 2018 +0100 @@ -4150,6 +4150,16 @@ <!--887A5D8C19464BCD805726641AD05CAD--> <ISDEFAULT><![CDATA[Y]]></ISDEFAULT> <!--887A5D8C19464BCD805726641AD05CAD--></AD_MODEL_OBJECT_MAPPING> +<!--8BDFFB29AB8A48FFAB177645E0C61BC4--><AD_MODEL_OBJECT_MAPPING> +<!--8BDFFB29AB8A48FFAB177645E0C61BC4--> <AD_MODEL_OBJECT_MAPPING_ID><![CDATA[8BDFFB29AB8A48FFAB177645E0C61BC4]]></AD_MODEL_OBJECT_MAPPING_ID> +<!--8BDFFB29AB8A48FFAB177645E0C61BC4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--8BDFFB29AB8A48FFAB177645E0C61BC4--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--8BDFFB29AB8A48FFAB177645E0C61BC4--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--8BDFFB29AB8A48FFAB177645E0C61BC4--> <AD_MODEL_OBJECT_ID><![CDATA[3AC9D212955448D59DCBE53BD6F46C72]]></AD_MODEL_OBJECT_ID> +<!--8BDFFB29AB8A48FFAB177645E0C61BC4--> <MAPPINGNAME><![CDATA[/ad_callouts/SL_LandedCost_Cost_Type.html]]></MAPPINGNAME> +<!--8BDFFB29AB8A48FFAB177645E0C61BC4--> <ISDEFAULT><![CDATA[Y]]></ISDEFAULT> +<!--8BDFFB29AB8A48FFAB177645E0C61BC4--></AD_MODEL_OBJECT_MAPPING> + <!--8E29104FB7F742429239BCE757554EDB--><AD_MODEL_OBJECT_MAPPING> <!--8E29104FB7F742429239BCE757554EDB--> <AD_MODEL_OBJECT_MAPPING_ID><![CDATA[8E29104FB7F742429239BCE757554EDB]]></AD_MODEL_OBJECT_MAPPING_ID> <!--8E29104FB7F742429239BCE757554EDB--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r c05369b23139 -r 093957bbfa3a src-db/database/sourcedata/AD_REFERENCE.xml --- a/src-db/database/sourcedata/AD_REFERENCE.xml Mon Jan 29 11:38:22 2018 +0100 +++ b/src-db/database/sourcedata/AD_REFERENCE.xml Tue Jan 30 17:29:16 2018 +0100 @@ -6860,6 +6860,8 @@ <!--E755FEC72FF74F7891EBC27B3094267B--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> <!--E755FEC72FF74F7891EBC27B3094267B--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--E755FEC72FF74F7891EBC27B3094267B--> <NAME><![CDATA[Invoice Line for Landed Cost Selector]]></NAME> +<!--E755FEC72FF74F7891EBC27B3094267B--> <DESCRIPTION><![CDATA[Invoice Lines that can be added to a Landed Cost]]></DESCRIPTION> +<!--E755FEC72FF74F7891EBC27B3094267B--> <HELP><![CDATA[A selector that proposes Invoice Lines that can be linked to a Landed Cost.]]></HELP> <!--E755FEC72FF74F7891EBC27B3094267B--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--E755FEC72FF74F7891EBC27B3094267B--> <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE> <!--E755FEC72FF74F7891EBC27B3094267B--> <PARENTREFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></PARENTREFERENCE_ID> diff -r c05369b23139 -r 093957bbfa3a src-db/database/sourcedata/OBUISEL_SELECTOR.xml --- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Mon Jan 29 11:38:22 2018 +0100 +++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Tue Jan 30 17:29:16 2018 +0100 @@ -58,9 +58,11 @@ <!--121CCCD7F670457A9FF815163F11A61F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> <!--121CCCD7F670457A9FF815163F11A61F--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--121CCCD7F670457A9FF815163F11A61F--> <NAME><![CDATA[Invoice Line Selector]]></NAME> +<!--121CCCD7F670457A9FF815163F11A61F--> <DESCRIPTION><![CDATA[Invoice Lines that can be added to a Landed Cost]]></DESCRIPTION> +<!--121CCCD7F670457A9FF815163F11A61F--> <HELP><![CDATA[A selector that proposes Invoice Lines that can be linked to a Landed Cost.]]></HELP> <!--121CCCD7F670457A9FF815163F11A61F--> <AD_REFERENCE_ID><![CDATA[E755FEC72FF74F7891EBC27B3094267B]]></AD_REFERENCE_ID> <!--121CCCD7F670457A9FF815163F11A61F--> <AD_TABLE_ID><![CDATA[333]]></AD_TABLE_ID> -<!--121CCCD7F670457A9FF815163F11A61F--> <WHERECLAUSE><![CDATA[exists (select 1 from LandedCostType lct where lct.id = @inpmLcTypeId@ and (e.product = lct.product or e.account = lct.account)) AND e.lineNetAmount <> (SELECT coalesce(SUM(lcc.amount),0) FROM LandedCostCost lcc WHERE lcc.invoiceLine = e)]]></WHERECLAUSE> +<!--121CCCD7F670457A9FF815163F11A61F--> <WHERECLAUSE><![CDATA[(e.product.id = @LCC_Product_ID@ or e.account.id = @LCC_Account_ID@) and e.lineNetAmount <> (SELECT coalesce(sum(lcm.amount), 0) from LandedCostMatched lcm where lcm.invoiceLine.id = e.id) and e.invoice.salesTransaction = 'N']]></WHERECLAUSE> <!--121CCCD7F670457A9FF815163F11A61F--> <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID> <!--121CCCD7F670457A9FF815163F11A61F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--121CCCD7F670457A9FF815163F11A61F--> <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE> diff -r c05369b23139 -r 093957bbfa3a src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml --- a/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml Mon Jan 29 11:38:22 2018 +0100 +++ b/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml Tue Jan 30 17:29:16 2018 +0100 @@ -347,6 +347,28 @@ <!--13CA3020FEB644D9AA51B4797181BB29--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> <!--13CA3020FEB644D9AA51B4797181BB29--></OBUISEL_SELECTOR_FIELD> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--><OBUISEL_SELECTOR_FIELD> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[16CFFFA19B074E96BE8B8B6F5F371BF2]]></OBUISEL_SELECTOR_FIELD_ID> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <OBUISEL_SELECTOR_ID><![CDATA[121CCCD7F670457A9FF815163F11A61F]]></OBUISEL_SELECTOR_ID> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <AD_COLUMN_ID><![CDATA[FD3A0DB0549845F29EDCA4FC514B52AD]]></AD_COLUMN_ID> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <NAME><![CDATA[Account]]></NAME> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <DESCRIPTION><![CDATA[The identification code used for accounting.]]></DESCRIPTION> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <HELP><![CDATA[The (natural) account used]]></HELP> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <PROPERTY><![CDATA[account]]></PROPERTY> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <SORT><![CDATA[Y]]></SORT> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <FILTER><![CDATA[Y]]></FILTER> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <SORTNO><![CDATA[50]]></SORTNO> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> +<!--16CFFFA19B074E96BE8B8B6F5F371BF2--></OBUISEL_SELECTOR_FIELD> + <!--190E45B61635477BBC0799229F889FD6--><OBUISEL_SELECTOR_FIELD> <!--190E45B61635477BBC0799229F889FD6--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[190E45B61635477BBC0799229F889FD6]]></OBUISEL_SELECTOR_FIELD_ID> <!--190E45B61635477BBC0799229F889FD6--> <OBUISEL_SELECTOR_ID><![CDATA[B748F356A65641D4974E5C349A16FB27]]></OBUISEL_SELECTOR_ID> @@ -866,6 +888,28 @@ <!--348E946313BF4336ABDA800BA68829CF--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> <!--348E946313BF4336ABDA800BA68829CF--></OBUISEL_SELECTOR_FIELD> +<!--3603768B6231449DB35BDA8578F329A1--><OBUISEL_SELECTOR_FIELD> +<!--3603768B6231449DB35BDA8578F329A1--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[3603768B6231449DB35BDA8578F329A1]]></OBUISEL_SELECTOR_FIELD_ID> +<!--3603768B6231449DB35BDA8578F329A1--> <OBUISEL_SELECTOR_ID><![CDATA[121CCCD7F670457A9FF815163F11A61F]]></OBUISEL_SELECTOR_ID> +<!--3603768B6231449DB35BDA8578F329A1--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--3603768B6231449DB35BDA8578F329A1--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--3603768B6231449DB35BDA8578F329A1--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--3603768B6231449DB35BDA8578F329A1--> <AD_COLUMN_ID><![CDATA[3844]]></AD_COLUMN_ID> +<!--3603768B6231449DB35BDA8578F329A1--> <NAME><![CDATA[Line Net Amount]]></NAME> +<!--3603768B6231449DB35BDA8578F329A1--> <DESCRIPTION><![CDATA[The final amount of a specified line, based only on quantities and prices.]]></DESCRIPTION> +<!--3603768B6231449DB35BDA8578F329A1--> <HELP><![CDATA[Indicates the line net amount based on the quantity and the actual price. Any additional charges or freight are not included.]]></HELP> +<!--3603768B6231449DB35BDA8578F329A1--> <PROPERTY><![CDATA[lineNetAmount]]></PROPERTY> +<!--3603768B6231449DB35BDA8578F329A1--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--3603768B6231449DB35BDA8578F329A1--> <SORT><![CDATA[Y]]></SORT> +<!--3603768B6231449DB35BDA8578F329A1--> <FILTER><![CDATA[Y]]></FILTER> +<!--3603768B6231449DB35BDA8578F329A1--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX> +<!--3603768B6231449DB35BDA8578F329A1--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID> +<!--3603768B6231449DB35BDA8578F329A1--> <SORTNO><![CDATA[30]]></SORTNO> +<!--3603768B6231449DB35BDA8578F329A1--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--3603768B6231449DB35BDA8578F329A1--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD> +<!--3603768B6231449DB35BDA8578F329A1--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> +<!--3603768B6231449DB35BDA8578F329A1--></OBUISEL_SELECTOR_FIELD> + <!--36B5DC1CD166494D8221B493042D7CCF--><OBUISEL_SELECTOR_FIELD> <!--36B5DC1CD166494D8221B493042D7CCF--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[36B5DC1CD166494D8221B493042D7CCF]]></OBUISEL_SELECTOR_FIELD_ID> <!--36B5DC1CD166494D8221B493042D7CCF--> <OBUISEL_SELECTOR_ID><![CDATA[F132874BE0954A9B8C1301BE20704730]]></OBUISEL_SELECTOR_ID> @@ -3065,6 +3109,28 @@ <!--970BAD3358774ED191B4DB1B08F5EA8F--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> <!--970BAD3358774ED191B4DB1B08F5EA8F--></OBUISEL_SELECTOR_FIELD> +<!--977BE27650AC482082A627F08BF1391D--><OBUISEL_SELECTOR_FIELD> +<!--977BE27650AC482082A627F08BF1391D--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[977BE27650AC482082A627F08BF1391D]]></OBUISEL_SELECTOR_FIELD_ID> +<!--977BE27650AC482082A627F08BF1391D--> <OBUISEL_SELECTOR_ID><![CDATA[121CCCD7F670457A9FF815163F11A61F]]></OBUISEL_SELECTOR_ID> +<!--977BE27650AC482082A627F08BF1391D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--977BE27650AC482082A627F08BF1391D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--977BE27650AC482082A627F08BF1391D--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--977BE27650AC482082A627F08BF1391D--> <AD_COLUMN_ID><![CDATA[3492]]></AD_COLUMN_ID> +<!--977BE27650AC482082A627F08BF1391D--> <NAME><![CDATA[Document No.]]></NAME> +<!--977BE27650AC482082A627F08BF1391D--> <DESCRIPTION><![CDATA[An often automatically generated identifier for all documents.]]></DESCRIPTION> +<!--977BE27650AC482082A627F08BF1391D--> <HELP><![CDATA[The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>". If the document type of your document has no automatic document sequence defined, the field will be empty when creating a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Document Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table inside the database (e.g. C_Order).]]></HELP> +<!--977BE27650AC482082A627F08BF1391D--> <PROPERTY><![CDATA[invoice.documentNo]]></PROPERTY> +<!--977BE27650AC482082A627F08BF1391D--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--977BE27650AC482082A627F08BF1391D--> <SORT><![CDATA[Y]]></SORT> +<!--977BE27650AC482082A627F08BF1391D--> <FILTER><![CDATA[Y]]></FILTER> +<!--977BE27650AC482082A627F08BF1391D--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX> +<!--977BE27650AC482082A627F08BF1391D--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID> +<!--977BE27650AC482082A627F08BF1391D--> <SORTNO><![CDATA[10]]></SORTNO> +<!--977BE27650AC482082A627F08BF1391D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--977BE27650AC482082A627F08BF1391D--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD> +<!--977BE27650AC482082A627F08BF1391D--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> +<!--977BE27650AC482082A627F08BF1391D--></OBUISEL_SELECTOR_FIELD> + <!--9835921A3AA54B8D8D0126B3696F8354--><OBUISEL_SELECTOR_FIELD> <!--9835921A3AA54B8D8D0126B3696F8354--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[9835921A3AA54B8D8D0126B3696F8354]]></OBUISEL_SELECTOR_FIELD_ID> <!--9835921A3AA54B8D8D0126B3696F8354--> <OBUISEL_SELECTOR_ID><![CDATA[862F54CB1B074513BD791C6789F4AA42]]></OBUISEL_SELECTOR_ID> @@ -3152,6 +3218,28 @@ <!--9AE36537ADC24CD48ABC2E80A2A4184F--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> <!--9AE36537ADC24CD48ABC2E80A2A4184F--></OBUISEL_SELECTOR_FIELD> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--><OBUISEL_SELECTOR_FIELD> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[9AE7DBE4D26C42E69397961BBE2A8B72]]></OBUISEL_SELECTOR_FIELD_ID> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <OBUISEL_SELECTOR_ID><![CDATA[121CCCD7F670457A9FF815163F11A61F]]></OBUISEL_SELECTOR_ID> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <AD_COLUMN_ID><![CDATA[3840]]></AD_COLUMN_ID> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <NAME><![CDATA[Product]]></NAME> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <DESCRIPTION><![CDATA[Product of the Invoice Line]]></DESCRIPTION> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <HELP><![CDATA[Product associated to the Invoice Line]]></HELP> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <PROPERTY><![CDATA[product]]></PROPERTY> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <SORT><![CDATA[Y]]></SORT> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <FILTER><![CDATA[Y]]></FILTER> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <SORTNO><![CDATA[40]]></SORTNO> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> +<!--9AE7DBE4D26C42E69397961BBE2A8B72--></OBUISEL_SELECTOR_FIELD> + <!--9D6E3675118E40B58CAB482C575CDEAA--><OBUISEL_SELECTOR_FIELD> <!--9D6E3675118E40B58CAB482C575CDEAA--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[9D6E3675118E40B58CAB482C575CDEAA]]></OBUISEL_SELECTOR_FIELD_ID> <!--9D6E3675118E40B58CAB482C575CDEAA--> <OBUISEL_SELECTOR_ID><![CDATA[D47A3616483E46C18A09794B9B276B37]]></OBUISEL_SELECTOR_ID> @@ -4553,6 +4641,28 @@ <!--E83867D90F8140CE86ABFA6DE1E565C8--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> <!--E83867D90F8140CE86ABFA6DE1E565C8--></OBUISEL_SELECTOR_FIELD> +<!--E92F2FD9736849EE80C551DF2914C67E--><OBUISEL_SELECTOR_FIELD> +<!--E92F2FD9736849EE80C551DF2914C67E--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[E92F2FD9736849EE80C551DF2914C67E]]></OBUISEL_SELECTOR_FIELD_ID> +<!--E92F2FD9736849EE80C551DF2914C67E--> <OBUISEL_SELECTOR_ID><![CDATA[121CCCD7F670457A9FF815163F11A61F]]></OBUISEL_SELECTOR_ID> +<!--E92F2FD9736849EE80C551DF2914C67E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--E92F2FD9736849EE80C551DF2914C67E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--E92F2FD9736849EE80C551DF2914C67E--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--E92F2FD9736849EE80C551DF2914C67E--> <AD_COLUMN_ID><![CDATA[3783]]></AD_COLUMN_ID> +<!--E92F2FD9736849EE80C551DF2914C67E--> <NAME><![CDATA[Invoice Date]]></NAME> +<!--E92F2FD9736849EE80C551DF2914C67E--> <DESCRIPTION><![CDATA[The time listed on the invoice.]]></DESCRIPTION> +<!--E92F2FD9736849EE80C551DF2914C67E--> <HELP><![CDATA[The Date Invoice indicates the date printed on the invoice.]]></HELP> +<!--E92F2FD9736849EE80C551DF2914C67E--> <PROPERTY><![CDATA[invoice.invoiceDate]]></PROPERTY> +<!--E92F2FD9736849EE80C551DF2914C67E--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--E92F2FD9736849EE80C551DF2914C67E--> <SORT><![CDATA[Y]]></SORT> +<!--E92F2FD9736849EE80C551DF2914C67E--> <FILTER><![CDATA[Y]]></FILTER> +<!--E92F2FD9736849EE80C551DF2914C67E--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX> +<!--E92F2FD9736849EE80C551DF2914C67E--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID> +<!--E92F2FD9736849EE80C551DF2914C67E--> <SORTNO><![CDATA[20]]></SORTNO> +<!--E92F2FD9736849EE80C551DF2914C67E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--E92F2FD9736849EE80C551DF2914C67E--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD> +<!--E92F2FD9736849EE80C551DF2914C67E--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> +<!--E92F2FD9736849EE80C551DF2914C67E--></OBUISEL_SELECTOR_FIELD> + <!--EB0A95320BF845DD8146274BE02DABBC--><OBUISEL_SELECTOR_FIELD> <!--EB0A95320BF845DD8146274BE02DABBC--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[EB0A95320BF845DD8146274BE02DABBC]]></OBUISEL_SELECTOR_FIELD_ID> ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
