details: https://code.openbravo.com/erp/devel/pi/rev/fc0fe0acca69 changeset: 27294:fc0fe0acca69 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Wed Apr 22 09:45:02 2015 +0200 summary: [prodcostexpl] Initial Load
details: https://code.openbravo.com/erp/devel/pi/rev/a1f04a650600 changeset: 27295:a1f04a650600 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Wed Apr 22 12:04:39 2015 +0200 summary: [prodcostexpl] Set proper org while calling getCostDimensionRule method details: https://code.openbravo.com/erp/devel/pi/rev/ae5686d56641 changeset: 27296:ae5686d56641 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Thu Apr 23 11:25:13 2015 +0200 summary: [prodcostexpl] Set legal entity org while calling getCostDimensionRule method details: https://code.openbravo.com/erp/devel/pi/rev/d272c6f37f3f changeset: 27297:d272c6f37f3f user: Unai Martirena <unai.martirena <at> openbravo.com> date: Thu Apr 23 19:17:25 2015 +0200 summary: [prodcostexpl] Not return any record when there is no transaction in selected costing record details: https://code.openbravo.com/erp/devel/pi/rev/61faa0479445 changeset: 27298:61faa0479445 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Fri Apr 24 10:31:18 2015 +0200 summary: [prodcostexpl] Few changes in Application Dictionary [1] Set flag Has Reference Data of the module to 'Y'. To take into account the dataset of the module during the installation. [2] Set flag Disable Parent Key Property of Costing Transactions tab to 'N', in order to be able to Link a column with parent tab. [3] Set flag Link to Parent Column of m_costing_id column to 'Y', in order to filter by parent record. details: https://code.openbravo.com/erp/devel/pi/rev/d2bd285ad926 changeset: 27299:d2bd285ad926 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Mon May 11 12:47:51 2015 +0200 summary: [prodcostexpl] Avoid IOB Expection when setting summary function. When setting summary function on a tab based on an HQL Query table, order by clause is empty in HQLDataSourceService, so this case has to be handled in CostingTransactionsHQLTransformer.java in order to not to fail. details: https://code.openbravo.com/erp/devel/pi/rev/493a798b7b93 changeset: 27300:493a798b7b93 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Mon May 11 13:17:37 2015 +0200 summary: [prodcostexpl] Display Net Unit Price and Transaction Cost for shipments details: https://code.openbravo.com/erp/devel/pi/rev/e3c9cceba108 changeset: 27301:e3c9cceba108 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Mon May 11 16:58:46 2015 +0200 summary: [prodcostexpl] Replace Order By clause of transformer with order by clause in tab details: https://code.openbravo.com/erp/devel/pi/rev/86cd1101efb4 changeset: 27302:86cd1101efb4 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Mon May 11 17:20:17 2015 +0200 summary: [prodcostexpl] Refactor of the code done. Javadoc added details: https://code.openbravo.com/erp/devel/pi/rev/7d79c782129e changeset: 27303:7d79c782129e user: Unai Martirena <unai.martirena <at> openbravo.com> date: Mon May 11 17:20:37 2015 +0200 summary: [prodcostexpl] Update module version to 1.0.1 details: https://code.openbravo.com/erp/devel/pi/rev/178dd81cffef changeset: 27304:178dd81cffef user: Unai Martirena <unai.martirena <at> openbravo.com> date: Thu May 14 09:46:55 2015 +0200 summary: [prodcostexpl] Modify module dependency to PR15Q1.3 details: https://code.openbravo.com/erp/devel/pi/rev/12db62c2ad86 changeset: 27305:12db62c2ad86 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Thu May 14 09:58:03 2015 +0200 summary: [prodcostexpl] Update Costing Transactions tab name details: https://code.openbravo.com/erp/devel/pi/rev/01e21a07a788 changeset: 27306:01e21a07a788 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Thu May 14 09:58:22 2015 +0200 summary: [prodcostexpl] Update module name and version details: https://code.openbravo.com/erp/devel/pi/rev/5f205e8c9f54 changeset: 27307:5f205e8c9f54 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Thu May 14 13:02:17 2015 +0200 summary: [prodcostexpl] Show results only for Costing records of type 'AVA' Also while getting previous costing record, if there is more than one with same movement date and trx process date, get the one with latest ending date, and if this is also equal, get the one with less movement qty, as costing background process processes the transactions in this order. details: https://code.openbravo.com/erp/devel/pi/rev/1a80a4ff99b6 changeset: 27308:1a80a4ff99b6 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Thu May 14 13:02:50 2015 +0200 summary: [prodcostexpl] Change module name, Update module version details: https://code.openbravo.com/erp/devel/pi/rev/7ef59dc62e20 changeset: 27309:7ef59dc62e20 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Thu Aug 06 14:36:55 2015 +0200 summary: [prodcostexpl] Inventory Average Cost Transactions module added to OB3 details: https://code.openbravo.com/erp/devel/pi/rev/e9c0183ce6fc changeset: 27310:e9c0183ce6fc user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Tue Aug 11 09:29:43 2015 +0200 summary: [prodcostexpl] Renamed m_costing_id to M_Costing_ID this situation was creating an error in the RuntimeModelTest.testIsParent4 test. Added product window to obcosta_costing_transactions table details: https://code.openbravo.com/erp/devel/pi/rev/eaa716f6b462 changeset: 27311:eaa716f6b462 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Tue Aug 11 13:07:27 2015 +0200 summary: [prodcostexpl] Module stuff integrated directly into Core details: https://code.openbravo.com/erp/devel/pi/rev/b10557a7c8ac changeset: 27312:b10557a7c8ac user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Wed Aug 12 14:58:41 2015 +0200 summary: [prodcostexpl] Rename table to M_Costing_Transactions_HQL details: https://code.openbravo.com/erp/devel/pi/rev/61060438d762 changeset: 27313:61060438d762 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Wed Aug 12 14:59:03 2015 +0200 summary: [prodcostexpl] Adapted IndexesTest OBBaseTest The query inside IndexesTest was failing after including the new tabs related to the [prodcostexpl] project, because a subquery was returning more than one record where only one record was possible. The reason was it was wrongly taken into account the new M_Costing_Transactions_HQL HQL table. Now the query only uses ad_table records defined as 'Table', which are the only ones that can have indexes diffstat: referencedata/standard/Costing_Transactions_not_sortable_and_not_filterable.xml | 17 + src-db/database/sourcedata/AD_COLUMN.xml | 441 ++++++ src-db/database/sourcedata/AD_DATASET.xml | 16 + src-db/database/sourcedata/AD_DATASET_TABLE.xml | 14 + src-db/database/sourcedata/AD_ELEMENT.xml | 48 + src-db/database/sourcedata/AD_FIELD.xml | 661 ++++++++++ src-db/database/sourcedata/AD_MODULE_MERGE.xml | 13 + src-db/database/sourcedata/AD_REFERENCE.xml | 12 + src-db/database/sourcedata/AD_REF_TABLE.xml | 11 + src-db/database/sourcedata/AD_TAB.xml | 60 + src-db/database/sourcedata/AD_TABLE.xml | 45 + src-test/src/org/openbravo/test/model/IndexesTest.java | 3 +- src/org/openbravo/common/datasource/CostingTransactionsHQLTransformer.java | 414 ++++++ 13 files changed, 1754 insertions(+), 1 deletions(-) diffs (truncated from 2148 to 300 lines): diff -r 66d1115c23d4 -r 61060438d762 referencedata/standard/Costing_Transactions_not_sortable_and_not_filterable.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/referencedata/standard/Costing_Transactions_not_sortable_and_not_filterable.xml Wed Aug 12 14:59:03 2015 +0200 @@ -0,0 +1,17 @@ +<?xml version="1.0" encoding="UTF-8"?> +<ob:Openbravo xmlns:ob="http://www.openbravo.com"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> + <OBUIAPP_GC_Tab id="4701BC23719C41FAA422305FCDBBAF85" identifier="Average Cost Transactions - Product"> + <id>4701BC23719C41FAA422305FCDBBAF85</id> + <active>true</active> + <tab id="9175CE3AFD764112BDB6E0647EB67FDF" entity-name="ADTab" identifier="Average Cost Transactions - Product"/> + <filterable>N</filterable> + <sortable>N</sortable> + <textFilterBehavior>D</textFilterBehavior> + <thresholdToFilter xsi:nil="true"/> + <isLazyFiltering>D</isLazyFiltering> + <filterOnChange>D</filterOnChange> + <allowFilterByIdentifier>D</allowFilterByIdentifier> + <isFkDropDownUnfiltered>D</isFkDropDownUnfiltered> + <disableFkCombo>D</disableFkCombo> + </OBUIAPP_GC_Tab> +</ob:Openbravo> diff -r 66d1115c23d4 -r 61060438d762 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Wed Aug 12 15:05:49 2015 +0200 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Wed Aug 12 14:59:03 2015 +0200 @@ -230257,6 +230257,38 @@ <!--1C7E0CA367DD4DFB8292D60F38729177--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--1C7E0CA367DD4DFB8292D60F38729177--></AD_COLUMN> +<!--1C8AED7760D64750A1BA17EA17C1ED77--><AD_COLUMN> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <AD_COLUMN_ID><![CDATA[1C8AED7760D64750A1BA17EA17C1ED77]]></AD_COLUMN_ID> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <NAME><![CDATA[cumQty]]></NAME> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <COLUMNNAME><![CDATA[cumQty]]></COLUMNNAME> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <AD_TABLE_ID><![CDATA[DFF0A9F7C26C457FA8735A09ACFD5971]]></AD_TABLE_ID> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISKEY><![CDATA[N]]></ISKEY> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <SEQNO><![CDATA[100]]></SEQNO> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <AD_ELEMENT_ID><![CDATA[8B4BBFAD2D65432BAFE284E519ED7583]]></AD_ELEMENT_ID> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--1C8AED7760D64750A1BA17EA17C1ED77--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--1C8AED7760D64750A1BA17EA17C1ED77--></AD_COLUMN> + <!--1C8B9FA82A7F45C285CE8367A6C7C80A--><AD_COLUMN> <!--1C8B9FA82A7F45C285CE8367A6C7C80A--> <AD_COLUMN_ID><![CDATA[1C8B9FA82A7F45C285CE8367A6C7C80A]]></AD_COLUMN_ID> <!--1C8B9FA82A7F45C285CE8367A6C7C80A--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -235242,6 +235274,39 @@ <!--302C35F17D2B427FBBE1D06A43C606ED--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--302C35F17D2B427FBBE1D06A43C606ED--></AD_COLUMN> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--><AD_COLUMN> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <AD_COLUMN_ID><![CDATA[30BCE4EE335E4EB6BD2CD237605ABC72]]></AD_COLUMN_ID> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <NAME><![CDATA[cumCost]]></NAME> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <COLUMNNAME><![CDATA[cumCost]]></COLUMNNAME> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <AD_TABLE_ID><![CDATA[DFF0A9F7C26C457FA8735A09ACFD5971]]></AD_TABLE_ID> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <AD_REFERENCE_ID><![CDATA[22]]></AD_REFERENCE_ID> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISKEY><![CDATA[N]]></ISKEY> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <SEQNO><![CDATA[120]]></SEQNO> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <AD_ELEMENT_ID><![CDATA[B6A12581B7AF40C79B78E8F147729702]]></AD_ELEMENT_ID> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--> <ENTITY_ALIAS><![CDATA[cost * cumQty]]></ENTITY_ALIAS> +<!--30BCE4EE335E4EB6BD2CD237605ABC72--></AD_COLUMN> + <!--30DC3756747E4BEEAC61CB44D646E1A2--><AD_COLUMN> <!--30DC3756747E4BEEAC61CB44D646E1A2--> <AD_COLUMN_ID><![CDATA[30DC3756747E4BEEAC61CB44D646E1A2]]></AD_COLUMN_ID> <!--30DC3756747E4BEEAC61CB44D646E1A2--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -236971,6 +237036,40 @@ <!--387FDEC05E73465C9C51BF68802C1EE9--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--387FDEC05E73465C9C51BF68802C1EE9--></AD_COLUMN> +<!--3883EBFE04154585B5B7C254F9B17569--><AD_COLUMN> +<!--3883EBFE04154585B5B7C254F9B17569--> <AD_COLUMN_ID><![CDATA[3883EBFE04154585B5B7C254F9B17569]]></AD_COLUMN_ID> +<!--3883EBFE04154585B5B7C254F9B17569--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--3883EBFE04154585B5B7C254F9B17569--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--3883EBFE04154585B5B7C254F9B17569--> <NAME><![CDATA[Transaction Cost]]></NAME> +<!--3883EBFE04154585B5B7C254F9B17569--> <HELP><![CDATA[Total amount of the transaction based on product cost.]]></HELP> +<!--3883EBFE04154585B5B7C254F9B17569--> <COLUMNNAME><![CDATA[transactionCost]]></COLUMNNAME> +<!--3883EBFE04154585B5B7C254F9B17569--> <AD_TABLE_ID><![CDATA[DFF0A9F7C26C457FA8735A09ACFD5971]]></AD_TABLE_ID> +<!--3883EBFE04154585B5B7C254F9B17569--> <AD_REFERENCE_ID><![CDATA[22]]></AD_REFERENCE_ID> +<!--3883EBFE04154585B5B7C254F9B17569--> <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISKEY><![CDATA[N]]></ISKEY> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--3883EBFE04154585B5B7C254F9B17569--> <SEQNO><![CDATA[90]]></SEQNO> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--3883EBFE04154585B5B7C254F9B17569--> <AD_ELEMENT_ID><![CDATA[B5B7ECCAA5E40789E040007F01003224]]></AD_ELEMENT_ID> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--3883EBFE04154585B5B7C254F9B17569--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--3883EBFE04154585B5B7C254F9B17569--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--3883EBFE04154585B5B7C254F9B17569--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--3883EBFE04154585B5B7C254F9B17569--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--3883EBFE04154585B5B7C254F9B17569--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--3883EBFE04154585B5B7C254F9B17569--> <ENTITY_ALIAS><![CDATA[trx.transactionCost]]></ENTITY_ALIAS> +<!--3883EBFE04154585B5B7C254F9B17569--></AD_COLUMN> + <!--388B7AE3A72344F697617991820394FC--><AD_COLUMN> <!--388B7AE3A72344F697617991820394FC--> <AD_COLUMN_ID><![CDATA[388B7AE3A72344F697617991820394FC]]></AD_COLUMN_ID> <!--388B7AE3A72344F697617991820394FC--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -259775,6 +259874,40 @@ <!--5E7C48B7AB0F46AEB4EDA3EA73871315--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--5E7C48B7AB0F46AEB4EDA3EA73871315--></AD_COLUMN> +<!--5EA7646DA48B45BDB69509885DBC4D0C--><AD_COLUMN> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <AD_COLUMN_ID><![CDATA[5EA7646DA48B45BDB69509885DBC4D0C]]></AD_COLUMN_ID> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <NAME><![CDATA[trxProcessDate]]></NAME> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <HELP><![CDATA[Indicates the date and time when the transaction was processed.]]></HELP> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <COLUMNNAME><![CDATA[trxProcessDate]]></COLUMNNAME> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <AD_TABLE_ID><![CDATA[DFF0A9F7C26C457FA8735A09ACFD5971]]></AD_TABLE_ID> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISKEY><![CDATA[N]]></ISKEY> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <SEQNO><![CDATA[50]]></SEQNO> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <AD_ELEMENT_ID><![CDATA[B80DC62676AE85DEE040007F01002BCA]]></AD_ELEMENT_ID> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--5EA7646DA48B45BDB69509885DBC4D0C--> <ENTITY_ALIAS><![CDATA[trx.transactionProcessDate]]></ENTITY_ALIAS> +<!--5EA7646DA48B45BDB69509885DBC4D0C--></AD_COLUMN> + <!--5F0553A1327C4BC595CB3C8381FC3524--><AD_COLUMN> <!--5F0553A1327C4BC595CB3C8381FC3524--> <AD_COLUMN_ID><![CDATA[5F0553A1327C4BC595CB3C8381FC3524]]></AD_COLUMN_ID> <!--5F0553A1327C4BC595CB3C8381FC3524--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -296832,6 +296965,41 @@ <!--917D53B89F6BE62DE040007F01006B57--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--917D53B89F6BE62DE040007F01006B57--></AD_COLUMN> +<!--917DA51E7781486382BDB2C633C1F5A3--><AD_COLUMN> +<!--917DA51E7781486382BDB2C633C1F5A3--> <AD_COLUMN_ID><![CDATA[917DA51E7781486382BDB2C633C1F5A3]]></AD_COLUMN_ID> +<!--917DA51E7781486382BDB2C633C1F5A3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--917DA51E7781486382BDB2C633C1F5A3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--917DA51E7781486382BDB2C633C1F5A3--> <NAME><![CDATA[Inventory Transaction]]></NAME> +<!--917DA51E7781486382BDB2C633C1F5A3--> <HELP><![CDATA[The ID identifies a unique record]]></HELP> +<!--917DA51E7781486382BDB2C633C1F5A3--> <COLUMNNAME><![CDATA[transaction]]></COLUMNNAME> +<!--917DA51E7781486382BDB2C633C1F5A3--> <AD_TABLE_ID><![CDATA[DFF0A9F7C26C457FA8735A09ACFD5971]]></AD_TABLE_ID> +<!--917DA51E7781486382BDB2C633C1F5A3--> <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID> +<!--917DA51E7781486382BDB2C633C1F5A3--> <AD_REFERENCE_VALUE_ID><![CDATA[DD84B8826E35450190C006EDE8B3D5F8]]></AD_REFERENCE_VALUE_ID> +<!--917DA51E7781486382BDB2C633C1F5A3--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISKEY><![CDATA[N]]></ISKEY> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER> +<!--917DA51E7781486382BDB2C633C1F5A3--> <SEQNO><![CDATA[30]]></SEQNO> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--917DA51E7781486382BDB2C633C1F5A3--> <AD_ELEMENT_ID><![CDATA[1035]]></AD_ELEMENT_ID> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--917DA51E7781486382BDB2C633C1F5A3--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--917DA51E7781486382BDB2C633C1F5A3--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--917DA51E7781486382BDB2C633C1F5A3--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--917DA51E7781486382BDB2C633C1F5A3--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--917DA51E7781486382BDB2C633C1F5A3--> <ENTITY_ALIAS><![CDATA[trx]]></ENTITY_ALIAS> +<!--917DA51E7781486382BDB2C633C1F5A3--></AD_COLUMN> + <!--919249865C132A93E040007F01004B67--><AD_COLUMN> <!--919249865C132A93E040007F01004B67--> <AD_COLUMN_ID><![CDATA[919249865C132A93E040007F01004B67]]></AD_COLUMN_ID> <!--919249865C132A93E040007F01004B67--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -300337,6 +300505,42 @@ <!--9A845866B8F441A8B30337D68EBF8FC5--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--9A845866B8F441A8B30337D68EBF8FC5--></AD_COLUMN> +<!--9AA75071CD5647A1A3209EE478ADC549--><AD_COLUMN> +<!--9AA75071CD5647A1A3209EE478ADC549--> <AD_COLUMN_ID><![CDATA[9AA75071CD5647A1A3209EE478ADC549]]></AD_COLUMN_ID> +<!--9AA75071CD5647A1A3209EE478ADC549--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--9AA75071CD5647A1A3209EE478ADC549--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--9AA75071CD5647A1A3209EE478ADC549--> <NAME><![CDATA[Movement Type]]></NAME> +<!--9AA75071CD5647A1A3209EE478ADC549--> <DESCRIPTION><![CDATA[The type of a certain item being moved from one location to another.]]></DESCRIPTION> +<!--9AA75071CD5647A1A3209EE478ADC549--> <HELP><![CDATA[The Movement Type indicates the type of movement (in, out, to production, etc)]]></HELP> +<!--9AA75071CD5647A1A3209EE478ADC549--> <COLUMNNAME><![CDATA[movementType]]></COLUMNNAME> +<!--9AA75071CD5647A1A3209EE478ADC549--> <AD_TABLE_ID><![CDATA[DFF0A9F7C26C457FA8735A09ACFD5971]]></AD_TABLE_ID> +<!--9AA75071CD5647A1A3209EE478ADC549--> <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID> +<!--9AA75071CD5647A1A3209EE478ADC549--> <AD_REFERENCE_VALUE_ID><![CDATA[189]]></AD_REFERENCE_VALUE_ID> +<!--9AA75071CD5647A1A3209EE478ADC549--> <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISKEY><![CDATA[N]]></ISKEY> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--9AA75071CD5647A1A3209EE478ADC549--> <SEQNO><![CDATA[20]]></SEQNO> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--9AA75071CD5647A1A3209EE478ADC549--> <AD_ELEMENT_ID><![CDATA[1039]]></AD_ELEMENT_ID> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--9AA75071CD5647A1A3209EE478ADC549--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--9AA75071CD5647A1A3209EE478ADC549--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--9AA75071CD5647A1A3209EE478ADC549--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--9AA75071CD5647A1A3209EE478ADC549--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--9AA75071CD5647A1A3209EE478ADC549--> <ENTITY_ALIAS><![CDATA[trx.movementType]]></ENTITY_ALIAS> +<!--9AA75071CD5647A1A3209EE478ADC549--></AD_COLUMN> + <!--9AAE43C1F49E4D449C60368E5AFE010D--><AD_COLUMN> <!--9AAE43C1F49E4D449C60368E5AFE010D--> <AD_COLUMN_ID><![CDATA[9AAE43C1F49E4D449C60368E5AFE010D]]></AD_COLUMN_ID> <!--9AAE43C1F49E4D449C60368E5AFE010D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -304215,6 +304419,39 @@ <!--A3F6D4F4BD9C44D7A2FCAEECDAA59F51--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--A3F6D4F4BD9C44D7A2FCAEECDAA59F51--></AD_COLUMN> +<!--A3F83656D5F945F8A1B99058F39DE1E3--><AD_COLUMN> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <AD_COLUMN_ID><![CDATA[A3F83656D5F945F8A1B99058F39DE1E3]]></AD_COLUMN_ID> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <NAME><![CDATA[movementQuantity]]></NAME> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <COLUMNNAME><![CDATA[movementQuantity]]></COLUMNNAME> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <AD_TABLE_ID><![CDATA[DFF0A9F7C26C457FA8735A09ACFD5971]]></AD_TABLE_ID> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISKEY><![CDATA[N]]></ISKEY> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <SEQNO><![CDATA[70]]></SEQNO> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <AD_ELEMENT_ID><![CDATA[EFCED7A4B2BA4FADBBFABF91D145CF45]]></AD_ELEMENT_ID> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--A3F83656D5F945F8A1B99058F39DE1E3--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> ------------------------------------------------------------------------------ _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
