diff options
| -rw-r--r-- | run_calculate_pricelist_odoo.kjb | 22 | ||||
| -rw-r--r-- | run_single_ktr.sh | 2 | ||||
| -rw-r--r-- | update_override_vendor_pricelist.ktr | 1369 |
3 files changed, 699 insertions, 694 deletions
diff --git a/run_calculate_pricelist_odoo.kjb b/run_calculate_pricelist_odoo.kjb index 4dc2e2f..7bcfca7 100644 --- a/run_calculate_pricelist_odoo.kjb +++ b/run_calculate_pricelist_odoo.kjb @@ -539,7 +539,7 @@ <draw>Y</draw> <nr>0</nr> <xloc>1168</xloc> - <yloc>240</yloc> + <yloc>192</yloc> <attributes_kjc/> </entry> <entry> @@ -616,8 +616,8 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>768</xloc> - <yloc>240</yloc> + <xloc>752</xloc> + <yloc>288</yloc> <attributes_kjc/> </entry> <entry> @@ -655,8 +655,8 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>432</xloc> - <yloc>240</yloc> + <xloc>448</xloc> + <yloc>288</yloc> <attributes_kjc/> </entry> <entry> @@ -695,7 +695,7 @@ <draw>Y</draw> <nr>0</nr> <xloc>272</xloc> - <yloc>240</yloc> + <yloc>192</yloc> <attributes_kjc/> </entry> <entry> @@ -1046,7 +1046,7 @@ <draw>Y</draw> <nr>0</nr> <xloc>320</xloc> - <yloc>96</yloc> + <yloc>48</yloc> <attributes_kjc/> </entry> <entry> @@ -1084,8 +1084,8 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>912</xloc> - <yloc>240</yloc> + <xloc>896</xloc> + <yloc>192</yloc> <attributes_kjc/> </entry> <entry> @@ -1123,8 +1123,8 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>608</xloc> - <yloc>240</yloc> + <xloc>624</xloc> + <yloc>192</yloc> <attributes_kjc/> </entry> </entries> diff --git a/run_single_ktr.sh b/run_single_ktr.sh index 385e637..0ff3957 100644 --- a/run_single_ktr.sh +++ b/run_single_ktr.sh @@ -1 +1 @@ -sh /home/stephan/data-integration/pan.sh -level="Debug" -file="/home/stephan/transformation-job-bi/calculate_price_after_disc.ktr" > "/home/stephan/transformation-job-bi/log/run_single_ktr.log" +sh /home/stephan/data-integration/pan.sh -level="Debug" -file="/home/stephan/transformation-job-bi/update_override_vendor_id.ktr" > "/home/stephan/transformation-job-bi/log/run_single_ktr.log" diff --git a/update_override_vendor_pricelist.ktr b/update_override_vendor_pricelist.ktr index f8d9d06..0972162 100644 --- a/update_override_vendor_pricelist.ktr +++ b/update_override_vendor_pricelist.ktr @@ -430,7 +430,7 @@ <created_date>2024/03/26 08:32:53.103</created_date> <modified_user>-</modified_user> <modified_date>2024/03/26 08:32:53.103</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> @@ -519,6 +519,50 @@ </hop> </order> <step> + <name>Filter rows</name> + <type>FilterRows</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <send_true_to>calculate price tier</send_true_to> + <send_false_to>filter override vendor purchase price = 0</send_false_to> + <compare> + <condition> + <negated>N</negated> + <leftvalue>purchase_price</leftvalue> + <function>></function> + <rightvalue/> + <value> + <name>constant</name> + <type>BigNumber</type> + <text>0.0</text> + <length>-1</length> + <precision>-1</precision> + <isnull>N</isnull> + <mask>######0.0###################;-######0.0###################</mask> + </value> + </condition> + </compare> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>352</xloc> + <yloc>128</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -540,6 +584,7 @@ coalesce(( select coalesce(ppd.include_price,0) limit 1 ),0) as purchase_price, rp.name as vendor, +b.override_vendor_id as vendor_id, (select group1 from price_group_dw pgd where id = 2) as markup_std1, (select group2 from price_group_dw pgd where id = 2) as markup_std2, (select group3 from price_group_dw pgd where id = 2) as markup_std3, @@ -1857,687 +1902,6 @@ where b.purchase_price_exist = 'Y'</sql> </GUI> </step> <step> - <name>update purchase pricelist override vendor</name> - <type>Update</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>dw bi indoteknik (localhost)</connection> - <skip_lookup>N</skip_lookup> - <commit>100</commit> - <use_batch>N</use_batch> - <error_ignored>N</error_ignored> - <ignore_flag_field/> - <lookup> - <schema>public</schema> - <table>pricelist_compute</table> - <key> - <name>product_id</name> - <field>product_id</field> - <condition>=</condition> - <name2/> - </key> - <value> - <name>item_code</name> - <rename>item_code</rename> - </value> - <value> - <name>name</name> - <rename>name</rename> - </value> - <value> - <name>pricing_group</name> - <rename>pricing_group</rename> - </value> - <value> - <name>purchase_price</name> - <rename>purchase_price</rename> - </value> - <value> - <name>vendor</name> - <rename>vendor</rename> - </value> - <value> - <name>markup_std1</name> - <rename>markup_std1</rename> - </value> - <value> - <name>markup_std2</name> - <rename>markup_std2</rename> - </value> - <value> - <name>markup_std3</name> - <rename>markup_std3</rename> - </value> - <value> - <name>markup_std4</name> - <rename>markup_std4</rename> - </value> - <value> - <name>markup_std5</name> - <rename>markup_std5</rename> - </value> - <value> - <name>markup_std6</name> - <rename>markup_std6</rename> - </value> - <value> - <name>markup_std7</name> - <rename>markup_std7</rename> - </value> - <value> - <name>markup_std8</name> - <rename>markup_std8</rename> - </value> - <value> - <name>markup_group1</name> - <rename>markup_group1</rename> - </value> - <value> - <name>markup_group2</name> - <rename>markup_group2</rename> - </value> - <value> - <name>markup_group3</name> - <rename>markup_group3</rename> - </value> - <value> - <name>markup_group4</name> - <rename>markup_group4</rename> - </value> - <value> - <name>markup_group5</name> - <rename>markup_group5</rename> - </value> - <value> - <name>markup_group6</name> - <rename>markup_group6</rename> - </value> - <value> - <name>markup_group7</name> - <rename>markup_group7</rename> - </value> - <value> - <name>markup_group8</name> - <rename>markup_group8</rename> - </value> - <value> - <name>markup_tier2_1</name> - <rename>markup_tier2_1</rename> - </value> - <value> - <name>markup_tier2_2</name> - <rename>markup_tier2_2</rename> - </value> - <value> - <name>markup_tier2_3</name> - <rename>markup_tier2_3</rename> - </value> - <value> - <name>markup_tier2_4</name> - <rename>markup_tier2_4</rename> - </value> - <value> - <name>markup_tier2_5</name> - <rename>markup_tier2_5</rename> - </value> - <value> - <name>markup_tier2_6</name> - <rename>markup_tier2_6</rename> - </value> - <value> - <name>markup_tier2_7</name> - <rename>markup_tier2_7</rename> - </value> - <value> - <name>markup_tier2_8</name> - <rename>markup_tier2_8</rename> - </value> - <value> - <name>markup_tier3_1</name> - <rename>markup_tier3_1</rename> - </value> - <value> - <name>markup_tier3_2</name> - <rename>markup_tier3_2</rename> - </value> - <value> - <name>markup_tier3_3</name> - <rename>markup_tier3_3</rename> - </value> - <value> - <name>markup_tier3_4</name> - <rename>markup_tier3_4</rename> - </value> - <value> - <name>markup_tier3_5</name> - <rename>markup_tier3_5</rename> - </value> - <value> - <name>markup_tier3_6</name> - <rename>markup_tier3_6</rename> - </value> - <value> - <name>markup_tier3_7</name> - <rename>markup_tier3_7</rename> - </value> - <value> - <name>markup_tier3_8</name> - <rename>markup_tier3_8</rename> - </value> - <value> - <name>markup_tier4_1</name> - <rename>markup_tier4_1</rename> - </value> - <value> - <name>markup_tier4_2</name> - <rename>markup_tier4_2</rename> - </value> - <value> - <name>markup_tier4_3</name> - <rename>markup_tier4_3</rename> - </value> - <value> - <name>markup_tier4_4</name> - <rename>markup_tier4_4</rename> - </value> - <value> - <name>markup_tier4_5</name> - <rename>markup_tier4_5</rename> - </value> - <value> - <name>markup_tier4_6</name> - <rename>markup_tier4_6</rename> - </value> - <value> - <name>markup_tier4_7</name> - <rename>markup_tier4_7</rename> - </value> - <value> - <name>markup_tier4_8</name> - <rename>markup_tier4_8</rename> - </value> - <value> - <name>markup_tier5_1</name> - <rename>markup_tier5_1</rename> - </value> - <value> - <name>markup_tier5_2</name> - <rename>markup_tier5_2</rename> - </value> - <value> - <name>markup_tier5_3</name> - <rename>markup_tier5_3</rename> - </value> - <value> - <name>markup_tier5_4</name> - <rename>markup_tier5_4</rename> - </value> - <value> - <name>markup_tier5_5</name> - <rename>markup_tier5_5</rename> - </value> - <value> - <name>markup_tier5_6</name> - <rename>markup_tier5_6</rename> - </value> - <value> - <name>markup_tier5_7</name> - <rename>markup_tier5_7</rename> - </value> - <value> - <name>markup_tier5_8</name> - <rename>markup_tier5_8</rename> - </value> - <value> - <name>price_before_disc1</name> - <rename>price_before_disc1</rename> - </value> - <value> - <name>price_before_disc2</name> - <rename>price_before_disc2</rename> - </value> - <value> - <name>price_before_disc3</name> - <rename>price_before_disc3</rename> - </value> - <value> - <name>price_before_disc4</name> - <rename>price_before_disc4</rename> - </value> - <value> - <name>price_before_disc5</name> - <rename>price_before_disc5</rename> - </value> - <value> - <name>price_before_disc6</name> - <rename>price_before_disc6</rename> - </value> - <value> - <name>price_before_disc7</name> - <rename>price_before_disc7</rename> - </value> - <value> - <name>price_before_disc8</name> - <rename>price_before_disc8</rename> - </value> - <value> - <name>price_after_disc_1</name> - <rename>price_after_disc_1</rename> - </value> - <value> - <name>price_after_disc_2</name> - <rename>price_after_disc_2</rename> - </value> - <value> - <name>price_after_disc_3</name> - <rename>price_after_disc_3</rename> - </value> - <value> - <name>price_after_disc_4</name> - <rename>price_after_disc_4</rename> - </value> - <value> - <name>price_after_disc_5</name> - <rename>price_after_disc_5</rename> - </value> - <value> - <name>price_after_disc_6</name> - <rename>price_after_disc_6</rename> - </value> - <value> - <name>price_after_disc_7</name> - <rename>price_after_disc_7</rename> - </value> - <value> - <name>price_after_disc_8</name> - <rename>price_after_disc_8</rename> - </value> - <value> - <name>price_tier2_1</name> - <rename>price_tier2_1</rename> - </value> - <value> - <name>price_tier2_2</name> - <rename>price_tier2_2</rename> - </value> - <value> - <name>price_tier2_3</name> - <rename>price_tier2_3</rename> - </value> - <value> - <name>price_tier2_4</name> - <rename>price_tier2_4</rename> - </value> - <value> - <name>price_tier2_5</name> - <rename>price_tier2_5</rename> - </value> - <value> - <name>price_tier2_6</name> - <rename>price_tier2_6</rename> - </value> - <value> - <name>price_tier2_7</name> - <rename>price_tier2_7</rename> - </value> - <value> - <name>price_tier2_8</name> - <rename>price_tier2_8</rename> - </value> - <value> - <name>price_tier3_1</name> - <rename>price_tier3_1</rename> - </value> - <value> - <name>price_tier3_2</name> - <rename>price_tier3_2</rename> - </value> - <value> - <name>price_tier3_3</name> - <rename>price_tier3_3</rename> - </value> - <value> - <name>price_tier3_4</name> - <rename>price_tier3_4</rename> - </value> - <value> - <name>price_tier3_5</name> - <rename>price_tier3_5</rename> - </value> - <value> - <name>price_tier3_6</name> - <rename>price_tier3_6</rename> - </value> - <value> - <name>price_tier3_7</name> - <rename>price_tier3_7</rename> - </value> - <value> - <name>price_tier3_8</name> - <rename>price_tier3_8</rename> - </value> - <value> - <name>price_tier4_1</name> - <rename>price_tier4_1</rename> - </value> - <value> - <name>price_tier4_2</name> - <rename>price_tier4_2</rename> - </value> - <value> - <name>price_tier4_3</name> - <rename>price_tier4_3</rename> - </value> - <value> - <name>price_tier4_4</name> - <rename>price_tier4_4</rename> - </value> - <value> - <name>price_tier4_5</name> - <rename>price_tier4_5</rename> - </value> - <value> - <name>price_tier4_6</name> - <rename>price_tier4_6</rename> - </value> - <value> - <name>price_tier4_7</name> - <rename>price_tier4_7</rename> - </value> - <value> - <name>price_tier4_8</name> - <rename>price_tier4_8</rename> - </value> - <value> - <name>price_tier5_1</name> - <rename>price_tier5_1</rename> - </value> - <value> - <name>price_tier5_2</name> - <rename>price_tier5_2</rename> - </value> - <value> - <name>price_tier5_3</name> - <rename>price_tier5_3</rename> - </value> - <value> - <name>price_tier5_4</name> - <rename>price_tier5_4</rename> - </value> - <value> - <name>price_tier5_5</name> - <rename>price_tier5_5</rename> - </value> - <value> - <name>price_tier5_6</name> - <rename>price_tier5_6</rename> - </value> - <value> - <name>price_tier5_7</name> - <rename>price_tier5_7</rename> - </value> - <value> - <name>price_tier5_8</name> - <rename>price_tier5_8</rename> - </value> - <value> - <name>disc1_1</name> - <rename>disc1_1</rename> - </value> - <value> - <name>disc1_2</name> - <rename>disc1_2</rename> - </value> - <value> - <name>disc1_3</name> - <rename>disc1_3</rename> - </value> - <value> - <name>disc1_4</name> - <rename>disc1_4</rename> - </value> - <value> - <name>disc1_5</name> - <rename>disc1_5</rename> - </value> - <value> - <name>disc1_6</name> - <rename>disc1_6</rename> - </value> - <value> - <name>disc1_7</name> - <rename>disc1_7</rename> - </value> - <value> - <name>disc1_8</name> - <rename>disc1_8</rename> - </value> - <value> - <name>disc2_1</name> - <rename>disc2_1</rename> - </value> - <value> - <name>disc2_2</name> - <rename>disc2_2</rename> - </value> - <value> - <name>disc2_3</name> - <rename>disc2_3</rename> - </value> - <value> - <name>disc2_4</name> - <rename>disc2_4</rename> - </value> - <value> - <name>disc2_5</name> - <rename>disc2_5</rename> - </value> - <value> - <name>disc2_6</name> - <rename>disc2_6</rename> - </value> - <value> - <name>disc2_7</name> - <rename>disc2_7</rename> - </value> - <value> - <name>disc2_8</name> - <rename>disc2_8</rename> - </value> - <value> - <name>disc3_1</name> - <rename>disc3_1</rename> - </value> - <value> - <name>disc3_2</name> - <rename>disc3_2</rename> - </value> - <value> - <name>disc3_3</name> - <rename>disc3_3</rename> - </value> - <value> - <name>disc3_4</name> - <rename>disc3_4</rename> - </value> - <value> - <name>disc3_5</name> - <rename>disc3_5</rename> - </value> - <value> - <name>disc3_6</name> - <rename>disc3_6</rename> - </value> - <value> - <name>disc3_7</name> - <rename>disc3_7</rename> - </value> - <value> - <name>disc3_8</name> - <rename>disc3_8</rename> - </value> - <value> - <name>disc4_1</name> - <rename>disc4_1</rename> - </value> - <value> - <name>disc4_2</name> - <rename>disc4_2</rename> - </value> - <value> - <name>disc4_3</name> - <rename>disc4_3</rename> - </value> - <value> - <name>disc4_4</name> - <rename>disc4_4</rename> - </value> - <value> - <name>disc4_5</name> - <rename>disc4_5</rename> - </value> - <value> - <name>disc4_6</name> - <rename>disc4_6</rename> - </value> - <value> - <name>disc4_7</name> - <rename>disc4_7</rename> - </value> - <value> - <name>disc4_8</name> - <rename>disc4_8</rename> - </value> - <value> - <name>disc5_1</name> - <rename>disc5_1</rename> - </value> - <value> - <name>disc5_2</name> - <rename>disc5_2</rename> - </value> - <value> - <name>disc5_3</name> - <rename>disc5_3</rename> - </value> - <value> - <name>disc5_4</name> - <rename>disc5_4</rename> - </value> - <value> - <name>disc5_5</name> - <rename>disc5_5</rename> - </value> - <value> - <name>disc5_6</name> - <rename>disc5_6</rename> - </value> - <value> - <name>disc5_7</name> - <rename>disc5_7</rename> - </value> - <value> - <name>disc5_8</name> - <rename>disc5_8</rename> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>928</xloc> - <yloc>256</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Filter rows</name> - <type>FilterRows</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <send_true_to>calculate price tier</send_true_to> - <send_false_to>filter override vendor purchase price = 0</send_false_to> - <compare> - <condition> - <negated>N</negated> - <leftvalue>purchase_price</leftvalue> - <function>></function> - <rightvalue/> - <value> - <name>constant</name> - <type>BigNumber</type> - <text>0.0</text> - <length>-1</length> - <precision>-1</precision> - <isnull>N</isnull> - <mask>######0.0###################;-######0.0###################</mask> - </value> - </condition> - </compare> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>352</xloc> - <yloc>128</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>filter override vendor purchase price = 0</name> - <type>WriteToLog</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <loglevel>log_level_basic</loglevel> - <displayHeader>Y</displayHeader> - <limitRows>N</limitRows> - <limitRowsNumber>0</limitRowsNumber> - <logmessage/> - <fields> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>352</xloc> - <yloc>256</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> <name>calculate diff</name> <type>Calculator</type> <description/> @@ -4535,6 +3899,647 @@ where b.purchase_price_exist = 'Y'</sql> <draw>Y</draw> </GUI> </step> + <step> + <name>filter override vendor purchase price = 0</name> + <type>WriteToLog</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <loglevel>log_level_basic</loglevel> + <displayHeader>Y</displayHeader> + <limitRows>N</limitRows> + <limitRowsNumber>0</limitRowsNumber> + <logmessage/> + <fields> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>352</xloc> + <yloc>256</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>update purchase pricelist override vendor</name> + <type>Update</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</connection> + <skip_lookup>N</skip_lookup> + <commit>100</commit> + <use_batch>N</use_batch> + <error_ignored>N</error_ignored> + <ignore_flag_field/> + <lookup> + <schema>public</schema> + <table>pricelist_compute</table> + <key> + <name>product_id</name> + <field>product_id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>item_code</name> + <rename>item_code</rename> + </value> + <value> + <name>name</name> + <rename>name</rename> + </value> + <value> + <name>pricing_group</name> + <rename>pricing_group</rename> + </value> + <value> + <name>purchase_price</name> + <rename>purchase_price</rename> + </value> + <value> + <name>vendor</name> + <rename>vendor</rename> + </value> + <value> + <name>markup_std1</name> + <rename>markup_std1</rename> + </value> + <value> + <name>markup_std2</name> + <rename>markup_std2</rename> + </value> + <value> + <name>markup_std3</name> + <rename>markup_std3</rename> + </value> + <value> + <name>markup_std4</name> + <rename>markup_std4</rename> + </value> + <value> + <name>markup_std5</name> + <rename>markup_std5</rename> + </value> + <value> + <name>markup_std6</name> + <rename>markup_std6</rename> + </value> + <value> + <name>markup_std7</name> + <rename>markup_std7</rename> + </value> + <value> + <name>markup_std8</name> + <rename>markup_std8</rename> + </value> + <value> + <name>markup_group1</name> + <rename>markup_group1</rename> + </value> + <value> + <name>markup_group2</name> + <rename>markup_group2</rename> + </value> + <value> + <name>markup_group3</name> + <rename>markup_group3</rename> + </value> + <value> + <name>markup_group4</name> + <rename>markup_group4</rename> + </value> + <value> + <name>markup_group5</name> + <rename>markup_group5</rename> + </value> + <value> + <name>markup_group6</name> + <rename>markup_group6</rename> + </value> + <value> + <name>markup_group7</name> + <rename>markup_group7</rename> + </value> + <value> + <name>markup_group8</name> + <rename>markup_group8</rename> + </value> + <value> + <name>markup_tier2_1</name> + <rename>markup_tier2_1</rename> + </value> + <value> + <name>markup_tier2_2</name> + <rename>markup_tier2_2</rename> + </value> + <value> + <name>markup_tier2_3</name> + <rename>markup_tier2_3</rename> + </value> + <value> + <name>markup_tier2_4</name> + <rename>markup_tier2_4</rename> + </value> + <value> + <name>markup_tier2_5</name> + <rename>markup_tier2_5</rename> + </value> + <value> + <name>markup_tier2_6</name> + <rename>markup_tier2_6</rename> + </value> + <value> + <name>markup_tier2_7</name> + <rename>markup_tier2_7</rename> + </value> + <value> + <name>markup_tier2_8</name> + <rename>markup_tier2_8</rename> + </value> + <value> + <name>markup_tier3_1</name> + <rename>markup_tier3_1</rename> + </value> + <value> + <name>markup_tier3_2</name> + <rename>markup_tier3_2</rename> + </value> + <value> + <name>markup_tier3_3</name> + <rename>markup_tier3_3</rename> + </value> + <value> + <name>markup_tier3_4</name> + <rename>markup_tier3_4</rename> + </value> + <value> + <name>markup_tier3_5</name> + <rename>markup_tier3_5</rename> + </value> + <value> + <name>markup_tier3_6</name> + <rename>markup_tier3_6</rename> + </value> + <value> + <name>markup_tier3_7</name> + <rename>markup_tier3_7</rename> + </value> + <value> + <name>markup_tier3_8</name> + <rename>markup_tier3_8</rename> + </value> + <value> + <name>markup_tier4_1</name> + <rename>markup_tier4_1</rename> + </value> + <value> + <name>markup_tier4_2</name> + <rename>markup_tier4_2</rename> + </value> + <value> + <name>markup_tier4_3</name> + <rename>markup_tier4_3</rename> + </value> + <value> + <name>markup_tier4_4</name> + <rename>markup_tier4_4</rename> + </value> + <value> + <name>markup_tier4_5</name> + <rename>markup_tier4_5</rename> + </value> + <value> + <name>markup_tier4_6</name> + <rename>markup_tier4_6</rename> + </value> + <value> + <name>markup_tier4_7</name> + <rename>markup_tier4_7</rename> + </value> + <value> + <name>markup_tier4_8</name> + <rename>markup_tier4_8</rename> + </value> + <value> + <name>markup_tier5_1</name> + <rename>markup_tier5_1</rename> + </value> + <value> + <name>markup_tier5_2</name> + <rename>markup_tier5_2</rename> + </value> + <value> + <name>markup_tier5_3</name> + <rename>markup_tier5_3</rename> + </value> + <value> + <name>markup_tier5_4</name> + <rename>markup_tier5_4</rename> + </value> + <value> + <name>markup_tier5_5</name> + <rename>markup_tier5_5</rename> + </value> + <value> + <name>markup_tier5_6</name> + <rename>markup_tier5_6</rename> + </value> + <value> + <name>markup_tier5_7</name> + <rename>markup_tier5_7</rename> + </value> + <value> + <name>markup_tier5_8</name> + <rename>markup_tier5_8</rename> + </value> + <value> + <name>price_before_disc1</name> + <rename>price_before_disc1</rename> + </value> + <value> + <name>price_before_disc2</name> + <rename>price_before_disc2</rename> + </value> + <value> + <name>price_before_disc3</name> + <rename>price_before_disc3</rename> + </value> + <value> + <name>price_before_disc4</name> + <rename>price_before_disc4</rename> + </value> + <value> + <name>price_before_disc5</name> + <rename>price_before_disc5</rename> + </value> + <value> + <name>price_before_disc6</name> + <rename>price_before_disc6</rename> + </value> + <value> + <name>price_before_disc7</name> + <rename>price_before_disc7</rename> + </value> + <value> + <name>price_before_disc8</name> + <rename>price_before_disc8</rename> + </value> + <value> + <name>price_after_disc_1</name> + <rename>price_after_disc_1</rename> + </value> + <value> + <name>price_after_disc_2</name> + <rename>price_after_disc_2</rename> + </value> + <value> + <name>price_after_disc_3</name> + <rename>price_after_disc_3</rename> + </value> + <value> + <name>price_after_disc_4</name> + <rename>price_after_disc_4</rename> + </value> + <value> + <name>price_after_disc_5</name> + <rename>price_after_disc_5</rename> + </value> + <value> + <name>price_after_disc_6</name> + <rename>price_after_disc_6</rename> + </value> + <value> + <name>price_after_disc_7</name> + <rename>price_after_disc_7</rename> + </value> + <value> + <name>price_after_disc_8</name> + <rename>price_after_disc_8</rename> + </value> + <value> + <name>price_tier2_1</name> + <rename>price_tier2_1</rename> + </value> + <value> + <name>price_tier2_2</name> + <rename>price_tier2_2</rename> + </value> + <value> + <name>price_tier2_3</name> + <rename>price_tier2_3</rename> + </value> + <value> + <name>price_tier2_4</name> + <rename>price_tier2_4</rename> + </value> + <value> + <name>price_tier2_5</name> + <rename>price_tier2_5</rename> + </value> + <value> + <name>price_tier2_6</name> + <rename>price_tier2_6</rename> + </value> + <value> + <name>price_tier2_7</name> + <rename>price_tier2_7</rename> + </value> + <value> + <name>price_tier2_8</name> + <rename>price_tier2_8</rename> + </value> + <value> + <name>price_tier3_1</name> + <rename>price_tier3_1</rename> + </value> + <value> + <name>price_tier3_2</name> + <rename>price_tier3_2</rename> + </value> + <value> + <name>price_tier3_3</name> + <rename>price_tier3_3</rename> + </value> + <value> + <name>price_tier3_4</name> + <rename>price_tier3_4</rename> + </value> + <value> + <name>price_tier3_5</name> + <rename>price_tier3_5</rename> + </value> + <value> + <name>price_tier3_6</name> + <rename>price_tier3_6</rename> + </value> + <value> + <name>price_tier3_7</name> + <rename>price_tier3_7</rename> + </value> + <value> + <name>price_tier3_8</name> + <rename>price_tier3_8</rename> + </value> + <value> + <name>price_tier4_1</name> + <rename>price_tier4_1</rename> + </value> + <value> + <name>price_tier4_2</name> + <rename>price_tier4_2</rename> + </value> + <value> + <name>price_tier4_3</name> + <rename>price_tier4_3</rename> + </value> + <value> + <name>price_tier4_4</name> + <rename>price_tier4_4</rename> + </value> + <value> + <name>price_tier4_5</name> + <rename>price_tier4_5</rename> + </value> + <value> + <name>price_tier4_6</name> + <rename>price_tier4_6</rename> + </value> + <value> + <name>price_tier4_7</name> + <rename>price_tier4_7</rename> + </value> + <value> + <name>price_tier4_8</name> + <rename>price_tier4_8</rename> + </value> + <value> + <name>price_tier5_1</name> + <rename>price_tier5_1</rename> + </value> + <value> + <name>price_tier5_2</name> + <rename>price_tier5_2</rename> + </value> + <value> + <name>price_tier5_3</name> + <rename>price_tier5_3</rename> + </value> + <value> + <name>price_tier5_4</name> + <rename>price_tier5_4</rename> + </value> + <value> + <name>price_tier5_5</name> + <rename>price_tier5_5</rename> + </value> + <value> + <name>price_tier5_6</name> + <rename>price_tier5_6</rename> + </value> + <value> + <name>price_tier5_7</name> + <rename>price_tier5_7</rename> + </value> + <value> + <name>price_tier5_8</name> + <rename>price_tier5_8</rename> + </value> + <value> + <name>disc1_1</name> + <rename>disc1_1</rename> + </value> + <value> + <name>disc1_2</name> + <rename>disc1_2</rename> + </value> + <value> + <name>disc1_3</name> + <rename>disc1_3</rename> + </value> + <value> + <name>disc1_4</name> + <rename>disc1_4</rename> + </value> + <value> + <name>disc1_5</name> + <rename>disc1_5</rename> + </value> + <value> + <name>disc1_6</name> + <rename>disc1_6</rename> + </value> + <value> + <name>disc1_7</name> + <rename>disc1_7</rename> + </value> + <value> + <name>disc1_8</name> + <rename>disc1_8</rename> + </value> + <value> + <name>disc2_1</name> + <rename>disc2_1</rename> + </value> + <value> + <name>disc2_2</name> + <rename>disc2_2</rename> + </value> + <value> + <name>disc2_3</name> + <rename>disc2_3</rename> + </value> + <value> + <name>disc2_4</name> + <rename>disc2_4</rename> + </value> + <value> + <name>disc2_5</name> + <rename>disc2_5</rename> + </value> + <value> + <name>disc2_6</name> + <rename>disc2_6</rename> + </value> + <value> + <name>disc2_7</name> + <rename>disc2_7</rename> + </value> + <value> + <name>disc2_8</name> + <rename>disc2_8</rename> + </value> + <value> + <name>disc3_1</name> + <rename>disc3_1</rename> + </value> + <value> + <name>disc3_2</name> + <rename>disc3_2</rename> + </value> + <value> + <name>disc3_3</name> + <rename>disc3_3</rename> + </value> + <value> + <name>disc3_4</name> + <rename>disc3_4</rename> + </value> + <value> + <name>disc3_5</name> + <rename>disc3_5</rename> + </value> + <value> + <name>disc3_6</name> + <rename>disc3_6</rename> + </value> + <value> + <name>disc3_7</name> + <rename>disc3_7</rename> + </value> + <value> + <name>disc3_8</name> + <rename>disc3_8</rename> + </value> + <value> + <name>disc4_1</name> + <rename>disc4_1</rename> + </value> + <value> + <name>disc4_2</name> + <rename>disc4_2</rename> + </value> + <value> + <name>disc4_3</name> + <rename>disc4_3</rename> + </value> + <value> + <name>disc4_4</name> + <rename>disc4_4</rename> + </value> + <value> + <name>disc4_5</name> + <rename>disc4_5</rename> + </value> + <value> + <name>disc4_6</name> + <rename>disc4_6</rename> + </value> + <value> + <name>disc4_7</name> + <rename>disc4_7</rename> + </value> + <value> + <name>disc4_8</name> + <rename>disc4_8</rename> + </value> + <value> + <name>disc5_1</name> + <rename>disc5_1</rename> + </value> + <value> + <name>disc5_2</name> + <rename>disc5_2</rename> + </value> + <value> + <name>disc5_3</name> + <rename>disc5_3</rename> + </value> + <value> + <name>disc5_4</name> + <rename>disc5_4</rename> + </value> + <value> + <name>disc5_5</name> + <rename>disc5_5</rename> + </value> + <value> + <name>disc5_6</name> + <rename>disc5_6</rename> + </value> + <value> + <name>disc5_7</name> + <rename>disc5_7</rename> + </value> + <value> + <name>disc5_8</name> + <rename>disc5_8</rename> + </value> + <value> + <name>vendor_id</name> + <rename>vendor_id</rename> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>1024</xloc> + <yloc>256</yloc> + <draw>Y</draw> + </GUI> + </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |