details: https://code.openbravo.com/erp/devel/pi/rev/37c5b07cf5e7 changeset: 30596:37c5b07cf5e7 user: David Miguelez <david.miguelez <at> openbravo.com> date: Mon Sep 26 19:57:27 2016 +0200 summary: Fixes issue 33411: Bad performance in Costing Background with all adjustments
- Add M_TRANSACTION_TRXPROCDATE index same as M_TRANSACTION_MOVEMENTDATE - Modify M_TRANSACTION_CALCULATED index, by adding movementdate column in order to improve CostingUtils.getMaxTransactionDate query. - Add new M_LASTTRX table to store last transaction movementdate and improve CostAdjustmentUtils.isNeededBackdatedCostAdjustment query. details: https://code.openbravo.com/erp/devel/pi/rev/b818f7ffec53 changeset: 30597:b818f7ffec53 user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> date: Tue Sep 27 12:38:06 2016 +0200 summary: Related to issue 33411: Code review improvements - Remove unnecessary M_LASTTRX_PRODUCT_IDX and M_LASTTRX_WAREHOUSE_IDX indexes and create M_LASTTRX_PRODUCT_ORG_WH index with m_product_id, ad_org_id and m_warehouse_id columns. - Remove unnecessary M_TRX_CALCULATED_MOVEMENTDATE and M_TRX_CALCULATED_PRODUCT_DATES indexes. - Remove unneeded parameters in CostingServer.updateLastTransaction method, and make it private and non static. - Remove unnecessary flush() after calling to updateLastTransaction, as flush() is already done in finally statement. - Move getLastTransaction method from CostingServer to CostAdjustmentUtils class. - Remove unneeded startingDate parameter in CostAdjustmentUtils.getLastTransaction method. - Merge isBeforeLastTransaction and isAfterLastTransaction methods into CostAdjustmentUtils.compareToLastTransaction new method. details: https://code.openbravo.com/erp/devel/pi/rev/98b01a2f62a8 changeset: 30598:98b01a2f62a8 user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> date: Tue Sep 27 19:29:56 2016 +0200 summary: Related to issue 33411: Rename table from M_LASTTRX to M_TRANSACTION_LAST Rename table from M_LASTTRX to M_TRANSACTION_LAST and remove unneeded movementdate, trxprocessdate, movementtype and qty columns. details: https://code.openbravo.com/erp/devel/pi/rev/e6b0b8ee69c8 changeset: 30599:e6b0b8ee69c8 user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> date: Tue Oct 11 18:50:35 2016 +0200 summary: Related to issue 33411: Run Synchronize Terminology details: https://code.openbravo.com/erp/devel/pi/rev/201031bd9a93 changeset: 30600:201031bd9a93 user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> date: Tue Sep 27 19:34:57 2016 +0200 summary: Related to issue 33411: Delete TransactionLast when validating new Costing Rule Delete M_Transaction_Last when validating a new Costing Rule and exists a previous rule. details: https://code.openbravo.com/erp/devel/pi/rev/4d8e7bd1a1c1 changeset: 30601:4d8e7bd1a1c1 user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> date: Thu Nov 03 13:57:43 2016 +0100 summary: Related to issue 33411: Initialize TransactionLast table In case TransactionLast has not been initialized yet, it will be done by CostAdjustmentUtils.insertLastTransaction method when calling CostAdjustmentUtils.isNeededBackdatedCostAdjustment. diffstat: src-db/database/model/tables/M_TRANSACTION.xml | 3 + src-db/database/model/tables/M_TRANSACTION_LAST.xml | 73 +++ src-db/database/sourcedata/AD_COLUMN.xml | 423 ++++++++++++++++++++ src-db/database/sourcedata/AD_ELEMENT.xml | 12 + src-db/database/sourcedata/AD_TABLE.xml | 22 + src/org/openbravo/costing/CostAdjustmentUtils.java | 168 +++++-- src/org/openbravo/costing/CostingRuleProcess.java | 12 + src/org/openbravo/costing/CostingServer.java | 25 + 8 files changed, 681 insertions(+), 57 deletions(-) diffs (truncated from 933 to 300 lines): diff -r 119536751051 -r 4d8e7bd1a1c1 src-db/database/model/tables/M_TRANSACTION.xml --- a/src-db/database/model/tables/M_TRANSACTION.xml Thu Nov 03 14:35:24 2016 +0100 +++ b/src-db/database/model/tables/M_TRANSACTION.xml Thu Nov 03 13:57:43 2016 +0100 @@ -206,6 +206,9 @@ <index name="M_TRANSACTION_PRODUCTIONLINE" unique="false"> <index-column name="M_PRODUCTIONLINE_ID"/> </index> + <index name="M_TRANSACTION_TRXPROCDATE" unique="false"> + <index-column name="TRXPROCESSDATE"/> + </index> <index name="M_TRANSSACTION_PRODUCT" unique="false"> <index-column name="M_PRODUCT_ID"/> </index> diff -r 119536751051 -r 4d8e7bd1a1c1 src-db/database/model/tables/M_TRANSACTION_LAST.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src-db/database/model/tables/M_TRANSACTION_LAST.xml Thu Nov 03 13:57:43 2016 +0100 @@ -0,0 +1,73 @@ +<?xml version="1.0"?> + <database name="TABLE M_TRANSACTION_LAST"> + <table name="M_TRANSACTION_LAST" primaryKey="M_TRANSACTION_LAST_KEY"> + <column name="M_TRANSACTION_LAST_ID" primaryKey="true" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="AD_CLIENT_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="AD_ORG_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="CREATED" primaryKey="false" required="true" type="TIMESTAMP" size="7" autoIncrement="false"> + <default><![CDATA[SYSDATE]]></default> + <onCreateDefault/> + </column> + <column name="CREATEDBY" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="UPDATED" primaryKey="false" required="true" type="TIMESTAMP" size="7" autoIncrement="false"> + <default><![CDATA[SYSDATE]]></default> + <onCreateDefault/> + </column> + <column name="UPDATEDBY" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="ISACTIVE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false"> + <default><![CDATA[Y]]></default> + <onCreateDefault/> + </column> + <column name="M_TRANSACTION_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="M_PRODUCT_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="M_WAREHOUSE_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <foreign-key foreignTable="AD_CLIENT" name="M_TRANSACTION_LAST_AD_CLIENT"> + <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/> + </foreign-key> + <foreign-key foreignTable="AD_ORG" name="M_TRANSACTION_LAST_AD_ORG"> + <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/> + </foreign-key> + <foreign-key foreignTable="M_PRODUCT" name="M_TRANSACTION_LAST_M_PRODUCT"> + <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/> + </foreign-key> + <foreign-key foreignTable="M_TRANSACTION" name="M_TRANSACTION_LAST_M_TRX"> + <reference local="M_TRANSACTION_ID" foreign="M_TRANSACTION_ID"/> + </foreign-key> + <foreign-key foreignTable="M_WAREHOUSE" name="M_TRANSACTION_LAST_M_WAREHOUSE"> + <reference local="M_WAREHOUSE_ID" foreign="M_WAREHOUSE_ID"/> + </foreign-key> + <index name="M_TRX_LAST_PRODUCT_ORG_WH" unique="false"> + <index-column name="M_PRODUCT_ID"/> + <index-column name="AD_ORG_ID"/> + <index-column name="M_WAREHOUSE_ID"/> + </index> + <index name="M_TRX_LAST_TRX" unique="false"> + <index-column name="M_TRANSACTION_ID"/> + </index> + <check name="M_TRANSACTION_LAST_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check> + </table> + </database> diff -r 119536751051 -r 4d8e7bd1a1c1 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Thu Nov 03 14:35:24 2016 +0100 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Thu Nov 03 13:57:43 2016 +0100 @@ -249628,6 +249628,44 @@ <!--174E582A1EC411DEA7ADDFB2CB2977ED--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> <!--174E582A1EC411DEA7ADDFB2CB2977ED--></AD_COLUMN> +<!--17738BA927A94FE8A38DDFFF664EB572--><AD_COLUMN> +<!--17738BA927A94FE8A38DDFFF664EB572--> <AD_COLUMN_ID><![CDATA[17738BA927A94FE8A38DDFFF664EB572]]></AD_COLUMN_ID> +<!--17738BA927A94FE8A38DDFFF664EB572--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--17738BA927A94FE8A38DDFFF664EB572--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--17738BA927A94FE8A38DDFFF664EB572--> <NAME><![CDATA[Warehouse]]></NAME> +<!--17738BA927A94FE8A38DDFFF664EB572--> <DESCRIPTION><![CDATA[The location where products arrive to or are sent from.]]></DESCRIPTION> +<!--17738BA927A94FE8A38DDFFF664EB572--> <HELP><![CDATA[The Warehouse identifies a unique Warehouse where products are stored or Services are provided.]]></HELP> +<!--17738BA927A94FE8A38DDFFF664EB572--> <COLUMNNAME><![CDATA[M_Warehouse_ID]]></COLUMNNAME> +<!--17738BA927A94FE8A38DDFFF664EB572--> <AD_TABLE_ID><![CDATA[8D568B85F2A142E68911FC49AE3B3F57]]></AD_TABLE_ID> +<!--17738BA927A94FE8A38DDFFF664EB572--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> +<!--17738BA927A94FE8A38DDFFF664EB572--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISKEY><![CDATA[N]]></ISKEY> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--17738BA927A94FE8A38DDFFF664EB572--> <SEQNO><![CDATA[110]]></SEQNO> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--17738BA927A94FE8A38DDFFF664EB572--> <AD_ELEMENT_ID><![CDATA[459]]></AD_ELEMENT_ID> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--17738BA927A94FE8A38DDFFF664EB572--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--17738BA927A94FE8A38DDFFF664EB572--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--17738BA927A94FE8A38DDFFF664EB572--> <POSITION><![CDATA[11]]></POSITION> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--17738BA927A94FE8A38DDFFF664EB572--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--17738BA927A94FE8A38DDFFF664EB572--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> +<!--17738BA927A94FE8A38DDFFF664EB572--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +<!--17738BA927A94FE8A38DDFFF664EB572--></AD_COLUMN> + <!--17BB8FE0016640D89F1C95F0D65A74E2--><AD_COLUMN> <!--17BB8FE0016640D89F1C95F0D65A74E2--> <AD_COLUMN_ID><![CDATA[17BB8FE0016640D89F1C95F0D65A74E2]]></AD_COLUMN_ID> <!--17BB8FE0016640D89F1C95F0D65A74E2--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -256163,6 +256201,45 @@ <!--2CA46C14D66F4B7AA6550531F6D329E7--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> <!--2CA46C14D66F4B7AA6550531F6D329E7--></AD_COLUMN> +<!--2CC98C761A3F460BB9D88F4E43DD3588--><AD_COLUMN> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <AD_COLUMN_ID><![CDATA[2CC98C761A3F460BB9D88F4E43DD3588]]></AD_COLUMN_ID> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <NAME><![CDATA[Creation Date]]></NAME> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <DESCRIPTION><![CDATA[The date that this record is completed.]]></DESCRIPTION> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <HELP><![CDATA[The Created field indicates the date that this record was created.]]></HELP> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <COLUMNNAME><![CDATA[Created]]></COLUMNNAME> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <AD_TABLE_ID><![CDATA[8D568B85F2A142E68911FC49AE3B3F57]]></AD_TABLE_ID> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <DEFAULTVALUE><![CDATA[@#Date@]]></DEFAULTVALUE> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISKEY><![CDATA[N]]></ISKEY> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <SEQNO><![CDATA[40]]></SEQNO> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <AD_ELEMENT_ID><![CDATA[245]]></AD_ELEMENT_ID> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <POSITION><![CDATA[4]]></POSITION> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> +<!--2CC98C761A3F460BB9D88F4E43DD3588--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +<!--2CC98C761A3F460BB9D88F4E43DD3588--></AD_COLUMN> + <!--2CE15055000B485AA55F72E3649C27F1--><AD_COLUMN> <!--2CE15055000B485AA55F72E3649C27F1--> <AD_COLUMN_ID><![CDATA[2CE15055000B485AA55F72E3649C27F1]]></AD_COLUMN_ID> <!--2CE15055000B485AA55F72E3649C27F1--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -282127,6 +282204,45 @@ <!--5B7528BF68E748B8B0AFCD93F3335C30--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> <!--5B7528BF68E748B8B0AFCD93F3335C30--></AD_COLUMN> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--><AD_COLUMN> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <AD_COLUMN_ID><![CDATA[5B8D8263DFFC44E38CF08FA6867B66A8]]></AD_COLUMN_ID> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <NAME><![CDATA[Client]]></NAME> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <DESCRIPTION><![CDATA[Client for this installation.]]></DESCRIPTION> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <HELP><![CDATA[A Client is a company or a legal entity. You cannot share data between Clients.]]></HELP> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <COLUMNNAME><![CDATA[AD_Client_ID]]></COLUMNNAME> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <AD_TABLE_ID><![CDATA[8D568B85F2A142E68911FC49AE3B3F57]]></AD_TABLE_ID> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <DEFAULTVALUE><![CDATA[@AD_CLIENT_ID@]]></DEFAULTVALUE> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISKEY><![CDATA[N]]></ISKEY> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <SEQNO><![CDATA[20]]></SEQNO> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <AD_ELEMENT_ID><![CDATA[102]]></AD_ELEMENT_ID> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <POSITION><![CDATA[2]]></POSITION> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +<!--5B8D8263DFFC44E38CF08FA6867B66A8--></AD_COLUMN> + <!--5BA7B941BEFB9257E040007F01017D15--><AD_COLUMN> <!--5BA7B941BEFB9257E040007F01017D15--> <AD_COLUMN_ID><![CDATA[5BA7B941BEFB9257E040007F01017D15]]></AD_COLUMN_ID> <!--5BA7B941BEFB9257E040007F01017D15--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -283945,6 +284061,45 @@ <!--5C7FEB5FDD3D1EA1E040007F01002676--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> <!--5C7FEB5FDD3D1EA1E040007F01002676--></AD_COLUMN> +<!--5C81AA8ACB054BD98A1230E038714277--><AD_COLUMN> +<!--5C81AA8ACB054BD98A1230E038714277--> <AD_COLUMN_ID><![CDATA[5C81AA8ACB054BD98A1230E038714277]]></AD_COLUMN_ID> +<!--5C81AA8ACB054BD98A1230E038714277--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--5C81AA8ACB054BD98A1230E038714277--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--5C81AA8ACB054BD98A1230E038714277--> <NAME><![CDATA[Updated]]></NAME> +<!--5C81AA8ACB054BD98A1230E038714277--> <DESCRIPTION><![CDATA[The date that this record was last updated]]></DESCRIPTION> +<!--5C81AA8ACB054BD98A1230E038714277--> <HELP><![CDATA[The Updated field indicates the date that this record was updated.]]></HELP> +<!--5C81AA8ACB054BD98A1230E038714277--> <COLUMNNAME><![CDATA[Updated]]></COLUMNNAME> +<!--5C81AA8ACB054BD98A1230E038714277--> <AD_TABLE_ID><![CDATA[8D568B85F2A142E68911FC49AE3B3F57]]></AD_TABLE_ID> +<!--5C81AA8ACB054BD98A1230E038714277--> <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID> +<!--5C81AA8ACB054BD98A1230E038714277--> <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH> +<!--5C81AA8ACB054BD98A1230E038714277--> <DEFAULTVALUE><![CDATA[@#Date@]]></DEFAULTVALUE> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISKEY><![CDATA[N]]></ISKEY> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--5C81AA8ACB054BD98A1230E038714277--> <SEQNO><![CDATA[60]]></SEQNO> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--5C81AA8ACB054BD98A1230E038714277--> <AD_ELEMENT_ID><![CDATA[607]]></AD_ELEMENT_ID> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--5C81AA8ACB054BD98A1230E038714277--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--5C81AA8ACB054BD98A1230E038714277--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--5C81AA8ACB054BD98A1230E038714277--> <POSITION><![CDATA[6]]></POSITION> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--5C81AA8ACB054BD98A1230E038714277--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--5C81AA8ACB054BD98A1230E038714277--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--5C81AA8ACB054BD98A1230E038714277--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--5C81AA8ACB054BD98A1230E038714277--> <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> +<!--5C81AA8ACB054BD98A1230E038714277--> <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> +<!--5C81AA8ACB054BD98A1230E038714277--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +<!--5C81AA8ACB054BD98A1230E038714277--></AD_COLUMN> + <!--5C8773B1F56F4B13A8F2FD7A3D2A514F--><AD_COLUMN> <!--5C8773B1F56F4B13A8F2FD7A3D2A514F--> <AD_COLUMN_ID><![CDATA[5C8773B1F56F4B13A8F2FD7A3D2A514F]]></AD_COLUMN_ID> <!--5C8773B1F56F4B13A8F2FD7A3D2A514F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -291550,6 +291705,44 @@ <!--69ACEFACF1054DE0A9F9440C78D9FC0C--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> <!--69ACEFACF1054DE0A9F9440C78D9FC0C--></AD_COLUMN> +<!--69B3805AD7764FE99394FC976CB02426--><AD_COLUMN> +<!--69B3805AD7764FE99394FC976CB02426--> <AD_COLUMN_ID><![CDATA[69B3805AD7764FE99394FC976CB02426]]></AD_COLUMN_ID> +<!--69B3805AD7764FE99394FC976CB02426--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--69B3805AD7764FE99394FC976CB02426--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--69B3805AD7764FE99394FC976CB02426--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--69B3805AD7764FE99394FC976CB02426--> <NAME><![CDATA[Updated By]]></NAME> +<!--69B3805AD7764FE99394FC976CB02426--> <DESCRIPTION><![CDATA[User who updated this records]]></DESCRIPTION> +<!--69B3805AD7764FE99394FC976CB02426--> <HELP><![CDATA[The Updated By field indicates the user who updated this record.]]></HELP> +<!--69B3805AD7764FE99394FC976CB02426--> <COLUMNNAME><![CDATA[Updatedby]]></COLUMNNAME> +<!--69B3805AD7764FE99394FC976CB02426--> <AD_TABLE_ID><![CDATA[8D568B85F2A142E68911FC49AE3B3F57]]></AD_TABLE_ID> +<!--69B3805AD7764FE99394FC976CB02426--> <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID> +<!--69B3805AD7764FE99394FC976CB02426--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--69B3805AD7764FE99394FC976CB02426--> <ISKEY><![CDATA[N]]></ISKEY> +<!--69B3805AD7764FE99394FC976CB02426--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--69B3805AD7764FE99394FC976CB02426--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--69B3805AD7764FE99394FC976CB02426--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> +<!--69B3805AD7764FE99394FC976CB02426--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--69B3805AD7764FE99394FC976CB02426--> <SEQNO><![CDATA[70]]></SEQNO> +<!--69B3805AD7764FE99394FC976CB02426--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--69B3805AD7764FE99394FC976CB02426--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
