diff options
Diffstat (limited to 'calculate_price_after_disc.ktr')
| -rw-r--r-- | calculate_price_after_disc.ktr | 1252 |
1 files changed, 281 insertions, 971 deletions
diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr index 86705b1..9268fa1 100644 --- a/calculate_price_after_disc.ktr +++ b/calculate_price_after_disc.ktr @@ -499,101 +499,6 @@ </hop> <hop> <from>Calculator 2</from> - <to>filter group1</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>filter group1</from> - <to>select group1</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>filter group1</from> - <to>filter group2</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>filter group2</from> - <to>select group2</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>filter group2</from> - <to>filter group3</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>filter group3</from> - <to>select group3</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>filter group3</from> - <to>filter group4</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>filter group4</from> - <to>select group4</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>filter group4</from> - <to>filter group5</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>filter group5</from> - <to>select group5</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>filter group5</from> - <to>Write to log</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>select group1</from> - <to>Append streams</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>select group2</from> - <to>Append streams</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>select group3</from> - <to>Append streams 2</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>Append streams</from> - <to>Append streams 2</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>select group4</from> - <to>Append streams 3</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>Append streams 2</from> - <to>Append streams 3</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>select group5</from> - <to>Append streams 4</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>Append streams 3</from> - <to>Append streams 4</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>Append streams 4</from> <to>Insert / update</to> <enabled>Y</enabled> </hop> @@ -1149,63 +1054,303 @@ <update>Y</update> </value> <value> - <name>markup_std</name> - <rename>markup_std</rename> + <name>markup_std1</name> + <rename>markup_std1</rename> + <update>Y</update> + </value> + <value> + <name>markup_std2</name> + <rename>markup_std2</rename> + <update>Y</update> + </value> + <value> + <name>markup_std3</name> + <rename>markup_std3</rename> <update>Y</update> </value> <value> - <name>markup_group</name> - <rename>markup_group</rename> + <name>markup_std4</name> + <rename>markup_std4</rename> <update>Y</update> </value> <value> - <name>markup_tier2</name> - <rename>markup_tier2</rename> + <name>markup_std5</name> + <rename>markup_std5</rename> <update>Y</update> </value> <value> - <name>markup_tier3</name> - <rename>markup_tier3</rename> + <name>markup_group1</name> + <rename>markup_group1</rename> <update>Y</update> </value> <value> - <name>markup_tier4</name> - <rename>markup_tier4</rename> + <name>markup_group2</name> + <rename>markup_group2</rename> <update>Y</update> </value> <value> - <name>markup_tier5</name> - <rename>markup_tier5</rename> + <name>markup_group3</name> + <rename>markup_group3</rename> <update>Y</update> </value> <value> - <name>price_after_disc</name> - <rename>price_after_disc</rename> + <name>markup_group4</name> + <rename>markup_group4</rename> <update>Y</update> </value> <value> - <name>price_before_disc</name> - <rename>price_before_disc</rename> + <name>markup_group5</name> + <rename>markup_group5</rename> <update>Y</update> </value> <value> - <name>price_tier2</name> - <rename>price_tier2</rename> + <name>markup_tier2_1</name> + <rename>markup_tier2_1</rename> <update>Y</update> </value> <value> - <name>price_tier3</name> - <rename>price_tier3</rename> + <name>markup_tier2_2</name> + <rename>markup_tier2_2</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier2_3</name> + <rename>markup_tier2_3</rename> <update>Y</update> </value> <value> - <name>price_tier4</name> - <rename>price_tier4</rename> + <name>markup_tier2_4</name> + <rename>markup_tier2_4</rename> <update>Y</update> </value> <value> - <name>price_tier5</name> - <rename>price_tier5</rename> + <name>markup_tier2_5</name> + <rename>markup_tier2_5</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_1</name> + <rename>markup_tier3_1</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_2</name> + <rename>markup_tier3_2</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_3</name> + <rename>markup_tier3_3</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_4</name> + <rename>markup_tier3_4</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_5</name> + <rename>markup_tier3_5</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_1</name> + <rename>markup_tier4_1</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_2</name> + <rename>markup_tier4_2</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_3</name> + <rename>markup_tier4_3</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_4</name> + <rename>markup_tier4_4</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_5</name> + <rename>markup_tier4_5</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_1</name> + <rename>markup_tier5_1</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_2</name> + <rename>markup_tier5_2</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_3</name> + <rename>markup_tier5_3</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_4</name> + <rename>markup_tier5_4</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_5</name> + <rename>markup_tier5_5</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_1</name> + <rename>price_after_disc_1</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_2</name> + <rename>price_after_disc_2</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_3</name> + <rename>price_after_disc_3</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_4</name> + <rename>price_after_disc_4</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_5</name> + <rename>price_after_disc_5</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc1</name> + <rename>price_before_disc1</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc2</name> + <rename>price_before_disc2</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc3</name> + <rename>price_before_disc3</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc4</name> + <rename>price_before_disc4</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc5</name> + <rename>price_before_disc5</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_1</name> + <rename>price_tier2_1</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_2</name> + <rename>price_tier2_2</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_3</name> + <rename>price_tier2_3</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_4</name> + <rename>price_tier2_4</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_5</name> + <rename>price_tier2_5</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_1</name> + <rename>price_tier3_1</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_2</name> + <rename>price_tier3_2</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_3</name> + <rename>price_tier3_3</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_4</name> + <rename>price_tier3_4</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_5</name> + <rename>price_tier3_5</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_1</name> + <rename>price_tier4_1</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_2</name> + <rename>price_tier4_2</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_3</name> + <rename>price_tier4_3</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_4</name> + <rename>price_tier4_4</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_5</name> + <rename>price_tier4_5</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_1</name> + <rename>price_tier5_1</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_2</name> + <rename>price_tier5_2</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_3</name> + <rename>price_tier5_3</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_4</name> + <rename>price_tier5_4</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_5</name> + <rename>price_tier5_5</rename> <update>Y</update> </value> </lookup> @@ -1218,8 +1363,8 @@ </output> </remotesteps> <GUI> - <xloc>1312</xloc> - <yloc>544</yloc> + <xloc>736</xloc> + <yloc>64</yloc> <draw>Y</draw> </GUI> </step> @@ -1235,14 +1380,20 @@ <schema_name/> </partitioning> <connection>dw bi indoteknik</connection> - <sql>select ppd.product_id, p.item_code, p.name, b.pricing_group, -case - when human_last_update is null then coalesce(system_price, 0) - when system_last_update is null then coalesce(product_price, 0) - when system_last_update >= human_last_update then coalesce(system_price, 0) - when b.pricing_group is null then 0 - else coalesce(product_price, 0) -end as purchase_price, + <sql>select p.product_id, p.item_code, p.name, b.pricing_group, +coalesce((select + case + when human_last_update is null then coalesce(system_price, 0) + when system_last_update is null then coalesce(product_price, 0) + when system_last_update >= human_last_update then coalesce(system_price, 0) + --when b.pricing_group is null then 0 + else coalesce(product_price, 0) + end as purchase_price + from purchase_pricelist_dw ppd + where ppd.product_id = p.product_id + order by ppd.count_trx_po desc, ppd.count_trx_po_vendor desc + limit 1 +),0) as purchase_price, (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, @@ -1273,8 +1424,7 @@ end as purchase_price, (select group3 from price_group_dw pgd where id = 6) as markup_tier5_3, (select group4 from price_group_dw pgd where id = 6) as markup_tier5_4, (select group5 from price_group_dw pgd where id = 6) as markup_tier5_5 -from purchase_pricelist_dw ppd -join product p on ppd.product_id = p.product_id +from product p left join brand b on b.id = p.brand_id</sql> <limit>0</limit> <lookup/> @@ -2103,846 +2253,6 @@ left join brand b on b.id = p.brand_id</sql> <draw>Y</draw> </GUI> </step> - <step> - <name>filter group1</name> - <type>FilterRows</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <send_true_to>select group1</send_true_to> - <send_false_to>filter group2</send_false_to> - <compare> - <condition> - <negated>N</negated> - <leftvalue>pricing_group</leftvalue> - <function>=</function> - <rightvalue/> - <value> - <name>constant</name> - <type>String</type> - <text>group1</text> - <length>-1</length> - <precision>-1</precision> - <isnull>N</isnull> - <mask/> - </value> - </condition> - </compare> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>704</xloc> - <yloc>64</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>select group1</name> - <type>SelectValues</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>product_id</name> - <rename/> - </field> - <field> - <name>item_code</name> - <rename/> - </field> - <field> - <name>name</name> - <rename/> - </field> - <field> - <name>pricing_group</name> - <rename/> - </field> - <field> - <name>purchase_price</name> - <rename/> - </field> - <field> - <name>markup_std1</name> - <rename>markup_std</rename> - </field> - <field> - <name>markup_group1</name> - <rename>markup_group</rename> - </field> - <field> - <name>markup_tier2_1</name> - <rename>markup_tier2</rename> - </field> - <field> - <name>markup_tier3_1</name> - <rename>markup_tier3</rename> - </field> - <field> - <name>markup_tier4_1</name> - <rename>markup_tier4</rename> - </field> - <field> - <name>markup_tier5_1</name> - <rename>markup_tier5</rename> - </field> - <field> - <name>price_after_disc_1</name> - <rename>price_after_disc</rename> - </field> - <field> - <name>price_before_disc1</name> - <rename>price_before_disc</rename> - </field> - <field> - <name>price_tier2_1</name> - <rename>price_tier2</rename> - </field> - <field> - <name>price_tier3_1</name> - <rename>price_tier3</rename> - </field> - <field> - <name>price_tier4_1</name> - <rename>price_tier4</rename> - </field> - <field> - <name>price_tier5_1</name> - <rename>price_tier5</rename> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>864</xloc> - <yloc>64</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>filter group2</name> - <type>FilterRows</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <send_true_to>select group2</send_true_to> - <send_false_to>filter group3</send_false_to> - <compare> - <condition> - <negated>N</negated> - <leftvalue>pricing_group</leftvalue> - <function>=</function> - <rightvalue/> - <value> - <name>constant</name> - <type>String</type> - <text>group2</text> - <length>-1</length> - <precision>-1</precision> - <isnull>N</isnull> - <mask/> - </value> - </condition> - </compare> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>704</xloc> - <yloc>176</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>select group2</name> - <type>SelectValues</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>product_id</name> - <rename/> - </field> - <field> - <name>item_code</name> - <rename/> - </field> - <field> - <name>name</name> - <rename/> - </field> - <field> - <name>pricing_group</name> - <rename/> - </field> - <field> - <name>purchase_price</name> - <rename/> - </field> - <field> - <name>markup_std2</name> - <rename>markup_std</rename> - </field> - <field> - <name>markup_group2</name> - <rename>markup_group</rename> - </field> - <field> - <name>markup_tier2_2</name> - <rename>markup_tier2</rename> - </field> - <field> - <name>markup_tier3_2</name> - <rename>markup_tier3</rename> - </field> - <field> - <name>markup_tier4_2</name> - <rename>markup_tier4</rename> - </field> - <field> - <name>markup_tier5_2</name> - <rename>markup_tier5</rename> - </field> - <field> - <name>price_after_disc_2</name> - <rename>price_after_disc</rename> - </field> - <field> - <name>price_before_disc2</name> - <rename>price_before_disc</rename> - </field> - <field> - <name>price_tier2_2</name> - <rename>price_tier2</rename> - </field> - <field> - <name>price_tier3_2</name> - <rename>price_tier3</rename> - </field> - <field> - <name>price_tier4_2</name> - <rename>price_tier4</rename> - </field> - <field> - <name>price_tier5_2</name> - <rename>price_tier5</rename> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>864</xloc> - <yloc>176</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>filter group3</name> - <type>FilterRows</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <send_true_to>select group3</send_true_to> - <send_false_to>filter group4</send_false_to> - <compare> - <condition> - <negated>N</negated> - <leftvalue>pricing_group</leftvalue> - <function>=</function> - <rightvalue/> - <value> - <name>constant</name> - <type>String</type> - <text>group3</text> - <length>-1</length> - <precision>-1</precision> - <isnull>N</isnull> - <mask/> - </value> - </condition> - </compare> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>704</xloc> - <yloc>320</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>select group3</name> - <type>SelectValues</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>product_id</name> - <rename/> - </field> - <field> - <name>item_code</name> - <rename/> - </field> - <field> - <name>name</name> - <rename/> - </field> - <field> - <name>pricing_group</name> - <rename/> - </field> - <field> - <name>purchase_price</name> - <rename/> - </field> - <field> - <name>markup_std3</name> - <rename>markup_std</rename> - </field> - <field> - <name>markup_group3</name> - <rename>markup_group</rename> - </field> - <field> - <name>markup_tier2_3</name> - <rename>markup_tier2</rename> - </field> - <field> - <name>markup_tier3_3</name> - <rename>markup_tier3</rename> - </field> - <field> - <name>markup_tier4_3</name> - <rename>markup_tier4</rename> - </field> - <field> - <name>markup_tier5_3</name> - <rename>markup_tier5</rename> - </field> - <field> - <name>price_after_disc_3</name> - <rename>price_after_disc</rename> - </field> - <field> - <name>price_before_disc3</name> - <rename>price_before_disc</rename> - </field> - <field> - <name>price_tier2_3</name> - <rename>price_tier2</rename> - </field> - <field> - <name>price_tier3_3</name> - <rename>price_tier3</rename> - </field> - <field> - <name>price_tier4_3</name> - <rename>price_tier4</rename> - </field> - <field> - <name>price_tier5_3</name> - <rename>price_tier5</rename> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>864</xloc> - <yloc>320</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>filter group4</name> - <type>FilterRows</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <send_true_to>select group4</send_true_to> - <send_false_to>filter group5</send_false_to> - <compare> - <condition> - <negated>N</negated> - <leftvalue>pricing_group</leftvalue> - <function>=</function> - <rightvalue/> - <value> - <name>constant</name> - <type>String</type> - <text>group4</text> - <length>-1</length> - <precision>-1</precision> - <isnull>N</isnull> - <mask/> - </value> - </condition> - </compare> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>704</xloc> - <yloc>432</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>select group4</name> - <type>SelectValues</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>product_id</name> - <rename/> - </field> - <field> - <name>item_code</name> - <rename/> - </field> - <field> - <name>name</name> - <rename/> - </field> - <field> - <name>pricing_group</name> - <rename/> - </field> - <field> - <name>purchase_price</name> - <rename/> - </field> - <field> - <name>markup_std4</name> - <rename>markup_std</rename> - </field> - <field> - <name>markup_group4</name> - <rename>markup_group</rename> - </field> - <field> - <name>markup_tier2_4</name> - <rename>markup_tier2</rename> - </field> - <field> - <name>markup_tier3_4</name> - <rename>markup_tier3</rename> - </field> - <field> - <name>markup_tier4_4</name> - <rename>markup_tier4</rename> - </field> - <field> - <name>markup_tier5_4</name> - <rename>markup_tier5</rename> - </field> - <field> - <name>price_after_disc_4</name> - <rename>price_after_disc</rename> - </field> - <field> - <name>price_before_disc4</name> - <rename>price_before_disc</rename> - </field> - <field> - <name>price_tier2_4</name> - <rename>price_tier2</rename> - </field> - <field> - <name>price_tier3_4</name> - <rename>price_tier3</rename> - </field> - <field> - <name>price_tier4_4</name> - <rename>price_tier4</rename> - </field> - <field> - <name>price_tier5_4</name> - <rename>price_tier5</rename> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>864</xloc> - <yloc>432</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>filter group5</name> - <type>FilterRows</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <send_true_to>select group5</send_true_to> - <send_false_to>Write to log</send_false_to> - <compare> - <condition> - <negated>N</negated> - <leftvalue>pricing_group</leftvalue> - <function>=</function> - <rightvalue/> - <value> - <name>constant</name> - <type>String</type> - <text>group5</text> - <length>-1</length> - <precision>-1</precision> - <isnull>N</isnull> - <mask/> - </value> - </condition> - </compare> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>704</xloc> - <yloc>544</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>select group5</name> - <type>SelectValues</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>product_id</name> - <rename/> - </field> - <field> - <name>item_code</name> - <rename/> - </field> - <field> - <name>name</name> - <rename/> - </field> - <field> - <name>pricing_group</name> - <rename/> - </field> - <field> - <name>purchase_price</name> - <rename/> - </field> - <field> - <name>markup_std5</name> - <rename>markup_std</rename> - </field> - <field> - <name>markup_group5</name> - <rename>markup_group</rename> - </field> - <field> - <name>markup_tier2_5</name> - <rename>markup_tier2</rename> - </field> - <field> - <name>markup_tier3_5</name> - <rename>markup_tier3</rename> - </field> - <field> - <name>markup_tier4_5</name> - <rename>markup_tier4</rename> - </field> - <field> - <name>markup_tier5_5</name> - <rename>markup_tier5</rename> - </field> - <field> - <name>price_after_disc_5</name> - <rename>price_after_disc</rename> - </field> - <field> - <name>price_before_disc5</name> - <rename>price_before_disc</rename> - </field> - <field> - <name>price_tier2_5</name> - <rename>price_tier2</rename> - </field> - <field> - <name>price_tier3_5</name> - <rename>price_tier3</rename> - </field> - <field> - <name>price_tier4_5</name> - <rename>price_tier4</rename> - </field> - <field> - <name>price_tier5_5</name> - <rename>price_tier5</rename> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>864</xloc> - <yloc>544</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Write to log</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>544</xloc> - <yloc>544</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Append streams</name> - <type>Append</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <head_name>select group1</head_name> - <tail_name>select group2</tail_name> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>1104</xloc> - <yloc>176</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Append streams 2</name> - <type>Append</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <head_name>Append streams</head_name> - <tail_name>select group3</tail_name> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>1104</xloc> - <yloc>320</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Append streams 3</name> - <type>Append</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <head_name>Append streams 2</head_name> - <tail_name>select group4</tail_name> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>1104</xloc> - <yloc>432</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Append streams 4</name> - <type>Append</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <head_name>Append streams 3</head_name> - <tail_name>select group5</tail_name> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>1104</xloc> - <yloc>544</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |