details: https://code.openbravo.com/erp/devel/pi/rev/ec460f26664c changeset: 25575:ec460f26664c user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> date: Thu Dec 18 14:18:27 2014 +0100 summary: [Costing]Related to issue 28333 Data needed in demodata for CostAdjustment test
Enable M_LandedCost, M_LC_Cost and M_LC_Type tables in sampledata dataset details: https://code.openbravo.com/erp/devel/pi/rev/499bbc8b3728 changeset: 25576:499bbc8b3728 user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> date: Thu Dec 18 14:33:34 2014 +0100 summary: [Costing]Related to issue 28333 Data needed in demodata for CostAdjustment test diffstat: referencedata/sampledata/QA_Testing/AD_SEQUENCE.xml | 2 +- referencedata/sampledata/QA_Testing/M_LANDEDCOST.xml | 23 ++++++++++ referencedata/sampledata/QA_Testing/M_LC_COST.xml | 29 +++++++++++++ src-db/database/sourcedata/AD_DATASET_TABLE.xml | 42 ++++++++++++++++++++ 4 files changed, 95 insertions(+), 1 deletions(-) diffs (138 lines): diff -r 0310a892cf74 -r 499bbc8b3728 referencedata/sampledata/QA_Testing/AD_SEQUENCE.xml --- a/referencedata/sampledata/QA_Testing/AD_SEQUENCE.xml Thu Nov 20 17:27:26 2014 +0530 +++ b/referencedata/sampledata/QA_Testing/AD_SEQUENCE.xml Thu Dec 18 14:33:34 2014 +0100 @@ -1313,7 +1313,7 @@ <ISAUTOSEQUENCE><![CDATA[Y]]></ISAUTOSEQUENCE> <INCREMENTNO><![CDATA[1]]></INCREMENTNO> <STARTNO><![CDATA[1000000]]></STARTNO> - <CURRENTNEXT><![CDATA[1000000]]></CURRENTNEXT> + <CURRENTNEXT><![CDATA[1000001]]></CURRENTNEXT> <CURRENTNEXTSYS><![CDATA[100]]></CURRENTNEXTSYS> <ISTABLEID><![CDATA[N]]></ISTABLEID> <STARTNEWYEAR><![CDATA[N]]></STARTNEWYEAR> diff -r 0310a892cf74 -r 499bbc8b3728 referencedata/sampledata/QA_Testing/M_LANDEDCOST.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/referencedata/sampledata/QA_Testing/M_LANDEDCOST.xml Thu Dec 18 14:33:34 2014 +0100 @@ -0,0 +1,23 @@ +<?xml version='1.0' encoding='UTF-8'?> +<data> +<M_LANDEDCOST> + <M_LANDEDCOST_ID><![CDATA[B3C8267DA9D8419DA98D6922B83BA2D5]]></M_LANDEDCOST_ID> + <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[357947E87C284935AD1D783CF6F099A1]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2014-12-18 12:30:17.456]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2014-12-18 12:30:17.456]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <REFERENCEDATE><![CDATA[2014-12-18 00:00:00.0]]></REFERENCEDATE> + <C_DOCTYPE_ID><![CDATA[38E131FE95F949CA97C95A9B03B3D6A8]]></C_DOCTYPE_ID> + <DOCUMENTNO><![CDATA[1000000]]></DOCUMENTNO> + <PROCESS><![CDATA[N]]></PROCESS> + <DOCSTATUS><![CDATA[DR]]></DOCSTATUS> + <POSTED><![CDATA[N]]></POSTED> + <PROCESSING><![CDATA[N]]></PROCESSING> + <PROCESSED><![CDATA[N]]></PROCESSED> + <REACTIVATE><![CDATA[N]]></REACTIVATE> +</M_LANDEDCOST> + +</data> diff -r 0310a892cf74 -r 499bbc8b3728 referencedata/sampledata/QA_Testing/M_LC_COST.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/referencedata/sampledata/QA_Testing/M_LC_COST.xml Thu Dec 18 14:33:34 2014 +0100 @@ -0,0 +1,29 @@ +<?xml version='1.0' encoding='UTF-8'?> +<data> +<M_LC_COST> + <M_LC_COST_ID><![CDATA[FB764059D85745BE927AD300FC549E51]]></M_LC_COST_ID> + <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[357947E87C284935AD1D783CF6F099A1]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2014-12-18 12:30:34.33]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2014-12-18 12:30:34.33]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <M_LANDEDCOST_ID><![CDATA[B3C8267DA9D8419DA98D6922B83BA2D5]]></M_LANDEDCOST_ID> + <M_LC_TYPE_ID><![CDATA[CFC6A31296F2479EADF55F813F53E15E]]></M_LC_TYPE_ID> + <AMOUNT><![CDATA[100]]></AMOUNT> + <M_LC_DISTRIBUTION_ALG_ID><![CDATA[CF9B55BD159B474A9F79849C48715540]]></M_LC_DISTRIBUTION_ALG_ID> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> + <ISMATCHED><![CDATA[N]]></ISMATCHED> + <ISMATCHINGADJUSTED><![CDATA[N]]></ISMATCHINGADJUSTED> + <POSTED><![CDATA[N]]></POSTED> + <PROCESSING><![CDATA[N]]></PROCESSING> + <DATEACCT><![CDATA[2014-12-18 00:00:00.0]]></DATEACCT> + <LINE><![CDATA[10]]></LINE> + <C_DOCTYPE_ID><![CDATA[F66B960D26C64215B1F4A09C3417FB16]]></C_DOCTYPE_ID> + <PROCESS_MATCHING><![CDATA[N]]></PROCESS_MATCHING> + <PROCESSED><![CDATA[N]]></PROCESSED> + <CANCEL_MATCHING><![CDATA[N]]></CANCEL_MATCHING> +</M_LC_COST> + +</data> diff -r 0310a892cf74 -r 499bbc8b3728 src-db/database/sourcedata/AD_DATASET_TABLE.xml --- a/src-db/database/sourcedata/AD_DATASET_TABLE.xml Thu Nov 20 17:27:26 2014 +0530 +++ b/src-db/database/sourcedata/AD_DATASET_TABLE.xml Thu Dec 18 14:33:34 2014 +0100 @@ -685,6 +685,20 @@ <!--3AC55F3B279244788DA9900731B5E6B0--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--3AC55F3B279244788DA9900731B5E6B0--></AD_DATASET_TABLE> +<!--3BF09FB88290451CA6D7BC309DCE8848--><AD_DATASET_TABLE> +<!--3BF09FB88290451CA6D7BC309DCE8848--> <AD_DATASET_TABLE_ID><![CDATA[3BF09FB88290451CA6D7BC309DCE8848]]></AD_DATASET_TABLE_ID> +<!--3BF09FB88290451CA6D7BC309DCE8848--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--3BF09FB88290451CA6D7BC309DCE8848--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--3BF09FB88290451CA6D7BC309DCE8848--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--3BF09FB88290451CA6D7BC309DCE8848--> <AD_DATASET_ID><![CDATA[D81C5C810AEF47C690E4F688ABC8AAC8]]></AD_DATASET_ID> +<!--3BF09FB88290451CA6D7BC309DCE8848--> <AD_TABLE_ID><![CDATA[082F967CDF7245EB9A150941F326C45C]]></AD_TABLE_ID> +<!--3BF09FB88290451CA6D7BC309DCE8848--> <INCLUDEALLCOLUMNS><![CDATA[Y]]></INCLUDEALLCOLUMNS> +<!--3BF09FB88290451CA6D7BC309DCE8848--> <WHERECLAUSE><![CDATA[client.id=:ClientID]]></WHERECLAUSE> +<!--3BF09FB88290451CA6D7BC309DCE8848--> <EXCLUDEAUDITINFO><![CDATA[N]]></EXCLUDEAUDITINFO> +<!--3BF09FB88290451CA6D7BC309DCE8848--> <ISBUSINESSOBJECT><![CDATA[N]]></ISBUSINESSOBJECT> +<!--3BF09FB88290451CA6D7BC309DCE8848--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--3BF09FB88290451CA6D7BC309DCE8848--></AD_DATASET_TABLE> + <!--402880E92E28C8A6012E28CD317A000F--><AD_DATASET_TABLE> <!--402880E92E28C8A6012E28CD317A000F--> <AD_DATASET_TABLE_ID><![CDATA[402880E92E28C8A6012E28CD317A000F]]></AD_DATASET_TABLE_ID> <!--402880E92E28C8A6012E28CD317A000F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -6074,6 +6088,20 @@ <!--BA24D5C296E011DD936F001B388C61A4--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--BA24D5C296E011DD936F001B388C61A4--></AD_DATASET_TABLE> +<!--BB7CD3530866434FA431DEBB1C46DF8D--><AD_DATASET_TABLE> +<!--BB7CD3530866434FA431DEBB1C46DF8D--> <AD_DATASET_TABLE_ID><![CDATA[BB7CD3530866434FA431DEBB1C46DF8D]]></AD_DATASET_TABLE_ID> +<!--BB7CD3530866434FA431DEBB1C46DF8D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--BB7CD3530866434FA431DEBB1C46DF8D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--BB7CD3530866434FA431DEBB1C46DF8D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--BB7CD3530866434FA431DEBB1C46DF8D--> <AD_DATASET_ID><![CDATA[D81C5C810AEF47C690E4F688ABC8AAC8]]></AD_DATASET_ID> +<!--BB7CD3530866434FA431DEBB1C46DF8D--> <AD_TABLE_ID><![CDATA[55A984C314FD4C4FB5E7C32DE36BB07B]]></AD_TABLE_ID> +<!--BB7CD3530866434FA431DEBB1C46DF8D--> <INCLUDEALLCOLUMNS><![CDATA[Y]]></INCLUDEALLCOLUMNS> +<!--BB7CD3530866434FA431DEBB1C46DF8D--> <WHERECLAUSE><![CDATA[client.id=:ClientID]]></WHERECLAUSE> +<!--BB7CD3530866434FA431DEBB1C46DF8D--> <EXCLUDEAUDITINFO><![CDATA[N]]></EXCLUDEAUDITINFO> +<!--BB7CD3530866434FA431DEBB1C46DF8D--> <ISBUSINESSOBJECT><![CDATA[N]]></ISBUSINESSOBJECT> +<!--BB7CD3530866434FA431DEBB1C46DF8D--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--BB7CD3530866434FA431DEBB1C46DF8D--></AD_DATASET_TABLE> + <!--BF1902C896E111DDB89F001B388C61A4--><AD_DATASET_TABLE> <!--BF1902C896E111DDB89F001B388C61A4--> <AD_DATASET_TABLE_ID><![CDATA[BF1902C896E111DDB89F001B388C61A4]]></AD_DATASET_TABLE_ID> <!--BF1902C896E111DDB89F001B388C61A4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -6215,6 +6243,20 @@ <!--CDAC10B183BA4D66A12668319F7C02C6--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--CDAC10B183BA4D66A12668319F7C02C6--></AD_DATASET_TABLE> +<!--D167F320AA4C49B1A564C18EBAF20289--><AD_DATASET_TABLE> +<!--D167F320AA4C49B1A564C18EBAF20289--> <AD_DATASET_TABLE_ID><![CDATA[D167F320AA4C49B1A564C18EBAF20289]]></AD_DATASET_TABLE_ID> +<!--D167F320AA4C49B1A564C18EBAF20289--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--D167F320AA4C49B1A564C18EBAF20289--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--D167F320AA4C49B1A564C18EBAF20289--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--D167F320AA4C49B1A564C18EBAF20289--> <AD_DATASET_ID><![CDATA[D81C5C810AEF47C690E4F688ABC8AAC8]]></AD_DATASET_ID> +<!--D167F320AA4C49B1A564C18EBAF20289--> <AD_TABLE_ID><![CDATA[BAFE429F04854EBEBD63A450DD714C89]]></AD_TABLE_ID> +<!--D167F320AA4C49B1A564C18EBAF20289--> <INCLUDEALLCOLUMNS><![CDATA[Y]]></INCLUDEALLCOLUMNS> +<!--D167F320AA4C49B1A564C18EBAF20289--> <WHERECLAUSE><![CDATA[client.id=:ClientID]]></WHERECLAUSE> +<!--D167F320AA4C49B1A564C18EBAF20289--> <EXCLUDEAUDITINFO><![CDATA[N]]></EXCLUDEAUDITINFO> +<!--D167F320AA4C49B1A564C18EBAF20289--> <ISBUSINESSOBJECT><![CDATA[N]]></ISBUSINESSOBJECT> +<!--D167F320AA4C49B1A564C18EBAF20289--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--D167F320AA4C49B1A564C18EBAF20289--></AD_DATASET_TABLE> + <!--D18052EEFDFB42F9B549AB3B9BB027FA--><AD_DATASET_TABLE> <!--D18052EEFDFB42F9B549AB3B9BB027FA--> <AD_DATASET_TABLE_ID><![CDATA[D18052EEFDFB42F9B549AB3B9BB027FA]]></AD_DATASET_TABLE_ID> <!--D18052EEFDFB42F9B549AB3B9BB027FA--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
