details: https://code.openbravo.com/erp/devel/pi/rev/92a8e3505111 changeset: 34848:92a8e3505111 user: Sandra Huguet <sandra.huguet <at> openbravo.com> date: Mon Oct 15 21:29:18 2018 +0200 summary: Fixed issue 39284 new returnline column to improve performance
New returnline column to improve performance in M_RM_RECEIPT_PICK_EDIT view testCostingR10 modified to use a copy of return from customer document instead a copy of order document. details: https://code.openbravo.com/erp/devel/pi/rev/33a73969f588 changeset: 34849:33a73969f588 user: Sandra Huguet <sandra.huguet <at> openbravo.com> date: Mon Oct 15 21:49:50 2018 +0200 summary: related to issue 39284 sampletada changes related to testCostingR10 changes details: https://code.openbravo.com/erp/devel/pi/rev/329f562353f5 changeset: 34850:329f562353f5 user: Sandra Huguet <sandra.huguet <at> openbravo.com> date: Wed Oct 17 10:30:06 2018 +0200 summary: related to issue 39284 modulescript to fill new returnline column diffstat: referencedata/sampledata/QA_Testing/AD_PINSTANCE.xml | 32 + referencedata/sampledata/QA_Testing/AD_PROCESS_REQUEST.xml | 36 + referencedata/sampledata/QA_Testing/AD_SEQUENCE.xml | 2 +- referencedata/sampledata/QA_Testing/C_ORDER.xml | 65 + referencedata/sampledata/QA_Testing/C_ORDERLINE.xml | 48 + referencedata/sampledata/QA_Testing/C_ORDERLINETAX.xml | 17 + referencedata/sampledata/QA_Testing/C_ORDERTAX.xml | 16 + referencedata/sampledata/QA_Testing/M_PRODUCT.xml | 4 +- referencedata/sampledata/QA_Testing/M_STORAGE_PENDING.xml | 17 + src-db/database/model/tables/C_ORDERLINE.xml | 9 + src-db/database/model/triggers/C_DOCTYPE_TRG.xml | 14 + src-db/database/model/triggers/C_ORDERLINE_TRG.xml | 13 + src-db/database/model/triggers/C_ORDERLINE_TRG2.xml | 5 +- src-db/database/model/triggers/C_ORDER_TRG.xml | 26 +- src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml | 2 +- src-db/database/sourcedata/AD_COLUMN.xml | 38 + src-db/database/sourcedata/AD_ELEMENT.xml | 14 + src-test/src/org/openbravo/test/costing/utils/TestCostingConstants.java | 2 + src-test/src/org/openbravo/test/costing/utils/TestCostingUtils.java | 1978 ++++----- src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateReturnLineInOrderLine.class | Bin src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateReturnLineInOrderLineData.class | Bin src-util/modulescript/src/org/openbravo/modulescript/UpdateReturnLineInOrderLine.java | 55 + src-util/modulescript/src/org/openbravo/modulescript/UpdateReturnLineInOrderLine_data.xsql | 39 + 23 files changed, 1382 insertions(+), 1050 deletions(-) diffs (truncated from 3980 to 300 lines): diff -r 9f9a22f6dd90 -r 329f562353f5 referencedata/sampledata/QA_Testing/AD_PINSTANCE.xml --- a/referencedata/sampledata/QA_Testing/AD_PINSTANCE.xml Wed Oct 17 13:12:31 2018 +0200 +++ b/referencedata/sampledata/QA_Testing/AD_PINSTANCE.xml Wed Oct 17 10:30:06 2018 +0200 @@ -68,6 +68,22 @@ </AD_PINSTANCE> <AD_PINSTANCE> + <AD_PINSTANCE_ID><![CDATA[0B6C4D7C648941078351B79C5A002E4D]]></AD_PINSTANCE_ID> + <AD_PROCESS_ID><![CDATA[104]]></AD_PROCESS_ID> + <RECORD_ID><![CDATA[C4CD2F1E708B44CB8796521C73D925CB]]></RECORD_ID> + <ISPROCESSING><![CDATA[N]]></ISPROCESSING> + <CREATED><![CDATA[2018-10-15 21:39:48.0]]></CREATED> + <AD_USER_ID><![CDATA[100]]></AD_USER_ID> + <UPDATED><![CDATA[2018-10-15 21:39:48.0]]></UPDATED> + <RESULT><![CDATA[1]]></RESULT> + <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> +</AD_PINSTANCE> + +<AD_PINSTANCE> <AD_PINSTANCE_ID><![CDATA[0F5B0E132E3044ED8DA5C133E7951671]]></AD_PINSTANCE_ID> <AD_PROCESS_ID><![CDATA[167]]></AD_PROCESS_ID> <RECORD_ID><![CDATA[5B0862FE46E34063A62C82FCC7BCF2A8]]></RECORD_ID> @@ -558,6 +574,22 @@ </AD_PINSTANCE> <AD_PINSTANCE> + <AD_PINSTANCE_ID><![CDATA[60A99EF08EA4499DA69287EEF0A82033]]></AD_PINSTANCE_ID> + <AD_PROCESS_ID><![CDATA[104]]></AD_PROCESS_ID> + <RECORD_ID><![CDATA[C4CD2F1E708B44CB8796521C73D925CB]]></RECORD_ID> + <ISPROCESSING><![CDATA[N]]></ISPROCESSING> + <CREATED><![CDATA[2018-10-15 21:39:42.0]]></CREATED> + <AD_USER_ID><![CDATA[100]]></AD_USER_ID> + <UPDATED><![CDATA[2018-10-15 21:39:43.0]]></UPDATED> + <RESULT><![CDATA[1]]></RESULT> + <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> +</AD_PINSTANCE> + +<AD_PINSTANCE> <AD_PINSTANCE_ID><![CDATA[60BE8271BC4640C9B8179FDE43226119]]></AD_PINSTANCE_ID> <AD_PROCESS_ID><![CDATA[100]]></AD_PROCESS_ID> <RECORD_ID><![CDATA[7D25AAA6427F496D9DA7C6539AD73477]]></RECORD_ID> diff -r 9f9a22f6dd90 -r 329f562353f5 referencedata/sampledata/QA_Testing/AD_PROCESS_REQUEST.xml --- a/referencedata/sampledata/QA_Testing/AD_PROCESS_REQUEST.xml Wed Oct 17 13:12:31 2018 +0200 +++ b/referencedata/sampledata/QA_Testing/AD_PROCESS_REQUEST.xml Wed Oct 17 10:30:06 2018 +0200 @@ -55,6 +55,24 @@ </AD_PROCESS_REQUEST> <AD_PROCESS_REQUEST> + <AD_PROCESS_REQUEST_ID><![CDATA[2D4FE13F82EC47BA8D82D0903C39A553]]></AD_PROCESS_REQUEST_ID> + <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2018-10-15 21:39:48.0]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2018-10-15 21:39:48.0]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <AD_PROCESS_ID><![CDATA[104]]></AD_PROCESS_ID> + <AD_USER_ID><![CDATA[100]]></AD_USER_ID> + <ISROLESECURITY><![CDATA[Y]]></ISROLESECURITY> + <OB_CONTEXT><![CDATA[{"org.openbravo.scheduling.ProcessContext":{"user":100,"role":"4028E6C72959682B01295A071429011E","language":"en_US","theme":"ltr\/org.openbravo.userinterface.skin.250to300Comp\/250to300Comp","client":"4028E6C72959682B01295A070852010D","organization":0,"warehouse":"4D7B97565A024DB7B4C61650FA2B9560","command":"SAVE_BUTTONDocAction104","userClient":"'4028E6C72959682B01295A070852010D'","userOrganization":"'5EFF95EB540740A3B10510D9814EFAD5','0','43D590B4814049C6B85C6545E8264E37','357947E87C284935AD1D783CF6F099A1'","dbSessionID":"B107487A44B94D2EAD4B82CD782B553F","javaDateFormat":"dd-MM-yyyy","javaDateTimeFormat":"dd-MM-yyyy HH:mm:ss","jsDateFormat":"%d-%m-%Y","sqlDateFormat":"DD-MM-YYYY","accessLevel":1,"roleSecurity":true}}]]></OB_CONTEXT> + <STATUS><![CDATA[COM]]></STATUS> + <CHANNEL><![CDATA[Direct]]></CHANNEL> + <ISGROUP><![CDATA[N]]></ISGROUP> +</AD_PROCESS_REQUEST> + +<AD_PROCESS_REQUEST> <AD_PROCESS_REQUEST_ID><![CDATA[30A62F89023A4876A588D84470BE4C8A]]></AD_PROCESS_REQUEST_ID> <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> @@ -91,6 +109,24 @@ </AD_PROCESS_REQUEST> <AD_PROCESS_REQUEST> + <AD_PROCESS_REQUEST_ID><![CDATA[39DF671018D74D1BAD0E19EFF771991F]]></AD_PROCESS_REQUEST_ID> + <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2018-10-15 21:39:42.0]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2018-10-15 21:39:43.0]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <AD_PROCESS_ID><![CDATA[104]]></AD_PROCESS_ID> + <AD_USER_ID><![CDATA[100]]></AD_USER_ID> + <ISROLESECURITY><![CDATA[Y]]></ISROLESECURITY> + <OB_CONTEXT><![CDATA[{"org.openbravo.scheduling.ProcessContext":{"user":100,"role":"4028E6C72959682B01295A071429011E","language":"en_US","theme":"ltr\/org.openbravo.userinterface.skin.250to300Comp\/250to300Comp","client":"4028E6C72959682B01295A070852010D","organization":0,"warehouse":"4D7B97565A024DB7B4C61650FA2B9560","command":"SAVE_BUTTONDocAction104","userClient":"'4028E6C72959682B01295A070852010D'","userOrganization":"'5EFF95EB540740A3B10510D9814EFAD5','0','43D590B4814049C6B85C6545E8264E37','357947E87C284935AD1D783CF6F099A1'","dbSessionID":"B107487A44B94D2EAD4B82CD782B553F","javaDateFormat":"dd-MM-yyyy","javaDateTimeFormat":"dd-MM-yyyy HH:mm:ss","jsDateFormat":"%d-%m-%Y","sqlDateFormat":"DD-MM-YYYY","accessLevel":1,"roleSecurity":true}}]]></OB_CONTEXT> + <STATUS><![CDATA[COM]]></STATUS> + <CHANNEL><![CDATA[Direct]]></CHANNEL> + <ISGROUP><![CDATA[N]]></ISGROUP> +</AD_PROCESS_REQUEST> + +<AD_PROCESS_REQUEST> <AD_PROCESS_REQUEST_ID><![CDATA[502EF7AF73264B9B8F76A1AAA4BE8887]]></AD_PROCESS_REQUEST_ID> <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> diff -r 9f9a22f6dd90 -r 329f562353f5 referencedata/sampledata/QA_Testing/AD_SEQUENCE.xml --- a/referencedata/sampledata/QA_Testing/AD_SEQUENCE.xml Wed Oct 17 13:12:31 2018 +0200 +++ b/referencedata/sampledata/QA_Testing/AD_SEQUENCE.xml Wed Oct 17 10:30:06 2018 +0200 @@ -1991,7 +1991,7 @@ <ISAUTOSEQUENCE><![CDATA[Y]]></ISAUTOSEQUENCE> <INCREMENTNO><![CDATA[1]]></INCREMENTNO> <STARTNO><![CDATA[1000000]]></STARTNO> - <CURRENTNEXT><![CDATA[2]]></CURRENTNEXT> + <CURRENTNEXT><![CDATA[3]]></CURRENTNEXT> <CURRENTNEXTSYS><![CDATA[100]]></CURRENTNEXTSYS> <ISTABLEID><![CDATA[N]]></ISTABLEID> <PREFIX><![CDATA[RFC/]]></PREFIX> diff -r 9f9a22f6dd90 -r 329f562353f5 referencedata/sampledata/QA_Testing/C_ORDER.xml --- a/referencedata/sampledata/QA_Testing/C_ORDER.xml Wed Oct 17 13:12:31 2018 +0200 +++ b/referencedata/sampledata/QA_Testing/C_ORDER.xml Wed Oct 17 10:30:06 2018 +0200 @@ -1360,6 +1360,71 @@ </C_ORDER> <C_ORDER> + <C_ORDER_ID><![CDATA[C4CD2F1E708B44CB8796521C73D925CB]]></C_ORDER_ID> + <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[357947E87C284935AD1D783CF6F099A1]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2018-10-15 21:39:04.0]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2018-10-15 21:39:48.0]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <ISSOTRX><![CDATA[Y]]></ISSOTRX> + <DOCUMENTNO><![CDATA[RFC/2]]></DOCUMENTNO> + <DOCSTATUS><![CDATA[DR]]></DOCSTATUS> + <DOCACTION><![CDATA[CO]]></DOCACTION> + <PROCESSING><![CDATA[N]]></PROCESSING> + <PROCESSED><![CDATA[N]]></PROCESSED> + <C_DOCTYPE_ID><![CDATA[C789FE062AA8480BAD91543A0C6B41AB]]></C_DOCTYPE_ID> + <C_DOCTYPETARGET_ID><![CDATA[C789FE062AA8480BAD91543A0C6B41AB]]></C_DOCTYPETARGET_ID> + <ISDELIVERED><![CDATA[N]]></ISDELIVERED> + <ISINVOICED><![CDATA[N]]></ISINVOICED> + <ISPRINTED><![CDATA[N]]></ISPRINTED> + <ISSELECTED><![CDATA[N]]></ISSELECTED> + <DATEORDERED><![CDATA[2018-10-15 00:00:00.0]]></DATEORDERED> + <DATEPROMISED><![CDATA[2018-10-15 00:00:00.0]]></DATEPROMISED> + <DATEACCT><![CDATA[2018-10-15 00:00:00.0]]></DATEACCT> + <C_BPARTNER_ID><![CDATA[4028E6C72959682B01295F40C3CB02EC]]></C_BPARTNER_ID> + <BILLTO_ID><![CDATA[4028E6C72959682B01295F40C43802EE]]></BILLTO_ID> + <C_BPARTNER_LOCATION_ID><![CDATA[4028E6C72959682B01295F40C43802EE]]></C_BPARTNER_LOCATION_ID> + <ISDISCOUNTPRINTED><![CDATA[N]]></ISDISCOUNTPRINTED> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> + <PAYMENTRULE><![CDATA[4]]></PAYMENTRULE> + <C_PAYMENTTERM_ID><![CDATA[7B308C5CB9674BB3A56E63D85887058A]]></C_PAYMENTTERM_ID> + <INVOICERULE><![CDATA[S]]></INVOICERULE> + <DELIVERYRULE><![CDATA[A]]></DELIVERYRULE> + <FREIGHTCOSTRULE><![CDATA[I]]></FREIGHTCOSTRULE> + <FREIGHTAMT><![CDATA[0]]></FREIGHTAMT> + <DELIVERYVIARULE><![CDATA[P]]></DELIVERYVIARULE> + <CHARGEAMT><![CDATA[0]]></CHARGEAMT> + <PRIORITYRULE><![CDATA[5]]></PRIORITYRULE> + <TOTALLINES><![CDATA[-35]]></TOTALLINES> + <GRANDTOTAL><![CDATA[-38.5]]></GRANDTOTAL> + <M_WAREHOUSE_ID><![CDATA[4D7B97565A024DB7B4C61650FA2B9560]]></M_WAREHOUSE_ID> + <M_PRICELIST_ID><![CDATA[4028E6C72959682B01295B03CE480243]]></M_PRICELIST_ID> + <ISTAXINCLUDED><![CDATA[N]]></ISTAXINCLUDED> + <POSTED><![CDATA[N]]></POSTED> + <AD_USER_ID><![CDATA[4028E6C72959682B01295F40C43802EF]]></AD_USER_ID> + <COPYFROM><![CDATA[N]]></COPYFROM> + <ISSELFSERVICE><![CDATA[N]]></ISSELFSERVICE> + <GENERATETEMPLATE><![CDATA[N]]></GENERATETEMPLATE> + <COPYFROMPO><![CDATA[N]]></COPYFROMPO> + <FIN_PAYMENTMETHOD_ID><![CDATA[42E87E97974E4B35849A430B8F6F2884]]></FIN_PAYMENTMETHOD_ID> + <RM_PICKFROMSHIPMENT><![CDATA[N]]></RM_PICKFROMSHIPMENT> + <RM_RECEIVEMATERIALS><![CDATA[N]]></RM_RECEIVEMATERIALS> + <RM_CREATEINVOICE><![CDATA[N]]></RM_CREATEINVOICE> + <RM_ADDORPHANLINE><![CDATA[N]]></RM_ADDORPHANLINE> + <CALCULATE_PROMOTIONS><![CDATA[N]]></CALCULATE_PROMOTIONS> + <CONVERTQUOTATION><![CDATA[N]]></CONVERTQUOTATION> + <CREATE_POLINES><![CDATA[N]]></CREATE_POLINES> + <ISCASHVAT><![CDATA[N]]></ISCASHVAT> + <RM_PICKFROMRECEIPT><![CDATA[N]]></RM_PICKFROMRECEIPT> + <CANCELANDREPLACE><![CDATA[N]]></CANCELANDREPLACE> + <CONFIRMCANCELANDREPLACE><![CDATA[N]]></CONFIRMCANCELANDREPLACE> + <ISCANCELLED><![CDATA[N]]></ISCANCELLED> + <EM_APRM_ADDPAYMENT><![CDATA[N]]></EM_APRM_ADDPAYMENT> +</C_ORDER> + +<C_ORDER> <C_ORDER_ID><![CDATA[C7B155F988D94156911D6622816FCACD]]></C_ORDER_ID> <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[357947E87C284935AD1D783CF6F099A1]]></AD_ORG_ID> diff -r 9f9a22f6dd90 -r 329f562353f5 referencedata/sampledata/QA_Testing/C_ORDERLINE.xml --- a/referencedata/sampledata/QA_Testing/C_ORDERLINE.xml Wed Oct 17 13:12:31 2018 +0200 +++ b/referencedata/sampledata/QA_Testing/C_ORDERLINE.xml Wed Oct 17 10:30:06 2018 +0200 @@ -1902,6 +1902,54 @@ </C_ORDERLINE> <C_ORDERLINE> + <C_ORDERLINE_ID><![CDATA[71CEDD4203FF4DC58000752BA9A0F8E7]]></C_ORDERLINE_ID> + <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[357947E87C284935AD1D783CF6F099A1]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2018-10-15 21:39:33.0]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2018-10-15 21:39:48.0]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <C_ORDER_ID><![CDATA[C4CD2F1E708B44CB8796521C73D925CB]]></C_ORDER_ID> + <LINE><![CDATA[10]]></LINE> + <DATEORDERED><![CDATA[2018-10-15 00:00:00.0]]></DATEORDERED> + <M_PRODUCT_ID><![CDATA[EBCD272DC37B4ABBB12B96139E5837BF]]></M_PRODUCT_ID> + <M_WAREHOUSE_ID><![CDATA[4D7B97565A024DB7B4C61650FA2B9560]]></M_WAREHOUSE_ID> + <DIRECTSHIP><![CDATA[N]]></DIRECTSHIP> + <C_UOM_ID><![CDATA[100]]></C_UOM_ID> + <QTYORDERED><![CDATA[-1]]></QTYORDERED> + <QTYRESERVED><![CDATA[0]]></QTYRESERVED> + <QTYDELIVERED><![CDATA[0]]></QTYDELIVERED> + <QTYINVOICED><![CDATA[0]]></QTYINVOICED> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> + <PRICELIST><![CDATA[35]]></PRICELIST> + <PRICEACTUAL><![CDATA[35]]></PRICEACTUAL> + <PRICELIMIT><![CDATA[0]]></PRICELIMIT> + <LINENETAMT><![CDATA[-35]]></LINENETAMT> + <DISCOUNT><![CDATA[0]]></DISCOUNT> + <FREIGHTAMT><![CDATA[0]]></FREIGHTAMT> + <CHARGEAMT><![CDATA[0]]></CHARGEAMT> + <C_TAX_ID><![CDATA[F9D9AF81F4FA459C9CE7A2D9697DF1E4]]></C_TAX_ID> + <M_ATTRIBUTESETINSTANCE_ID><![CDATA[BC4F469EE90445AA8D6F41DE8523FA63]]></M_ATTRIBUTESETINSTANCE_ID> + <ISDESCRIPTION><![CDATA[N]]></ISDESCRIPTION> + <PRICESTD><![CDATA[35]]></PRICESTD> + <CANCELPRICEAD><![CDATA[N]]></CANCELPRICEAD> + <ISEDITLINENETAMT><![CDATA[N]]></ISEDITLINENETAMT> + <M_INOUTLINE_ID><![CDATA[4AE8806312034CB4919848F849CEB9A2]]></M_INOUTLINE_ID> + <GROSS_UNIT_PRICE><![CDATA[0]]></GROSS_UNIT_PRICE> + <LINE_GROSS_AMOUNT><![CDATA[0]]></LINE_GROSS_AMOUNT> + <GROSSPRICELIST><![CDATA[0]]></GROSSPRICELIST> + <GROSSPRICESTD><![CDATA[0]]></GROSSPRICESTD> + <MANAGE_RESERVATION><![CDATA[N]]></MANAGE_RESERVATION> + <MANAGE_PRERESERVATION><![CDATA[N]]></MANAGE_PRERESERVATION> + <EXPLODE><![CDATA[N]]></EXPLODE> + <PRINT_DESCRIPTION><![CDATA[N]]></PRINT_DESCRIPTION> + <RELATE_ORDERLINE><![CDATA[N]]></RELATE_ORDERLINE> + <AUMQTY><![CDATA[0]]></AUMQTY> + <RETURNLINE><![CDATA[Y]]></RETURNLINE> +</C_ORDERLINE> + +<C_ORDERLINE> <C_ORDERLINE_ID><![CDATA[786F7031239A485B94D806A9830BF700]]></C_ORDERLINE_ID> <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[357947E87C284935AD1D783CF6F099A1]]></AD_ORG_ID> diff -r 9f9a22f6dd90 -r 329f562353f5 referencedata/sampledata/QA_Testing/C_ORDERLINETAX.xml --- a/referencedata/sampledata/QA_Testing/C_ORDERLINETAX.xml Wed Oct 17 13:12:31 2018 +0200 +++ b/referencedata/sampledata/QA_Testing/C_ORDERLINETAX.xml Wed Oct 17 10:30:06 2018 +0200 @@ -749,6 +749,23 @@ </C_ORDERLINETAX> <C_ORDERLINETAX> + <C_ORDERLINETAX_ID><![CDATA[784A9571F12B7009E0530100007F00AC]]></C_ORDERLINETAX_ID> + <C_ORDERLINE_ID><![CDATA[71CEDD4203FF4DC58000752BA9A0F8E7]]></C_ORDERLINE_ID> + <C_TAX_ID><![CDATA[F9D9AF81F4FA459C9CE7A2D9697DF1E4]]></C_TAX_ID> + <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[357947E87C284935AD1D783CF6F099A1]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2018-10-15 21:39:33.0]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2018-10-15 21:39:33.0]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <TAXBASEAMT><![CDATA[-35]]></TAXBASEAMT> + <TAXAMT><![CDATA[-3.5]]></TAXAMT> + <LINE><![CDATA[10]]></LINE> + <C_ORDER_ID><![CDATA[C4CD2F1E708B44CB8796521C73D925CB]]></C_ORDER_ID> +</C_ORDERLINETAX> + +<C_ORDERLINETAX> <C_ORDERLINETAX_ID><![CDATA[799D71E867014FCDAE27B514CA9C7B1E]]></C_ORDERLINETAX_ID> <C_ORDERLINE_ID><![CDATA[2828250559314E42AD6EE007F4CD1E1A]]></C_ORDERLINE_ID> <C_TAX_ID><![CDATA[F9D9AF81F4FA459C9CE7A2D9697DF1E4]]></C_TAX_ID> diff -r 9f9a22f6dd90 -r 329f562353f5 referencedata/sampledata/QA_Testing/C_ORDERTAX.xml --- a/referencedata/sampledata/QA_Testing/C_ORDERTAX.xml Wed Oct 17 13:12:31 2018 +0200 +++ b/referencedata/sampledata/QA_Testing/C_ORDERTAX.xml Wed Oct 17 10:30:06 2018 +0200 @@ -449,6 +449,22 @@ </C_ORDERTAX> <C_ORDERTAX> + <C_ORDERTAX_ID><![CDATA[784A9571F12C7009E0530100007F00AC]]></C_ORDERTAX_ID> + <C_ORDER_ID><![CDATA[C4CD2F1E708B44CB8796521C73D925CB]]></C_ORDER_ID> + <C_TAX_ID><![CDATA[F9D9AF81F4FA459C9CE7A2D9697DF1E4]]></C_TAX_ID> + <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[357947E87C284935AD1D783CF6F099A1]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2018-10-15 21:39:33.0]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2018-10-15 21:39:33.0]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <TAXBASEAMT><![CDATA[-35]]></TAXBASEAMT> + <TAXAMT><![CDATA[-3.5]]></TAXAMT> + <LINE><![CDATA[10]]></LINE> +</C_ORDERTAX> + +<C_ORDERTAX> <C_ORDERTAX_ID><![CDATA[7BFBB04C78EB4E79AAE803AF36BC5827]]></C_ORDERTAX_ID> <C_ORDER_ID><![CDATA[FF808081329052F301329089D7DE00C7]]></C_ORDER_ID> <C_TAX_ID><![CDATA[3271411A5AFB490A91FB618B6B789C24]]></C_TAX_ID> _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
