From 07a3252bc16af013277871173e0b8e1270d3faab Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Wed, 13 Sep 2023 10:03:43 +0700 Subject: revise calculate price --- calculate_price_after_disc.ktr | 1968 +++++++++++++--------------------------- 1 file changed, 639 insertions(+), 1329 deletions(-) (limited to 'calculate_price_after_disc.ktr') 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 @@ Calculator 2 - filter group1 - Y - - - filter group1 - select group1 - Y - - - filter group1 - filter group2 - Y - - - filter group2 - select group2 - Y - - - filter group2 - filter group3 - Y - - - filter group3 - select group3 - Y - - - filter group3 - filter group4 - Y - - - filter group4 - select group4 - Y - - - filter group4 - filter group5 - Y - - - filter group5 - select group5 - Y - - - filter group5 - Write to log - Y - - - select group1 - Append streams - Y - - - select group2 - Append streams - Y - - - select group3 - Append streams 2 - Y - - - Append streams - Append streams 2 - Y - - - select group4 - Append streams 3 - Y - - - Append streams 2 - Append streams 3 - Y - - - select group5 - Append streams 4 - Y - - - Append streams 3 - Append streams 4 - Y - - - Append streams 4 Insert / update Y @@ -1149,381 +1054,396 @@ Y - markup_std - markup_std + markup_std1 + markup_std1 Y - markup_group - markup_group + markup_std2 + markup_std2 Y - markup_tier2 - markup_tier2 + markup_std3 + markup_std3 Y - markup_tier3 - markup_tier3 + markup_std4 + markup_std4 Y - markup_tier4 - markup_tier4 + markup_std5 + markup_std5 Y - markup_tier5 - markup_tier5 + markup_group1 + markup_group1 Y - price_after_disc - price_after_disc + markup_group2 + markup_group2 Y - price_before_disc - price_before_disc + markup_group3 + markup_group3 Y - price_tier2 - price_tier2 + markup_group4 + markup_group4 Y - price_tier3 - price_tier3 + markup_group5 + markup_group5 Y - price_tier4 - price_tier4 + markup_tier2_1 + markup_tier2_1 Y - price_tier5 - price_tier5 + markup_tier2_2 + markup_tier2_2 Y - - - - - - - - - - - 1312 - 544 - Y - - - - Table input - TableInput - - Y - - 1 - - none - - - dw bi indoteknik - 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, -(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, -(select group4 from price_group_dw pgd where id = 2) as markup_std4, -(select group5 from price_group_dw pgd where id = 2) as markup_std5, -(select group1 from price_group_dw pgd where id = 1) as markup_group1, -(select group2 from price_group_dw pgd where id = 1) as markup_group2, -(select group3 from price_group_dw pgd where id = 1) as markup_group3, -(select group4 from price_group_dw pgd where id = 1) as markup_group4, -(select group5 from price_group_dw pgd where id = 1) as markup_group5, -(select group1 from price_group_dw pgd where id = 3) as markup_tier2_1, -(select group2 from price_group_dw pgd where id = 3) as markup_tier2_2, -(select group3 from price_group_dw pgd where id = 3) as markup_tier2_3, -(select group4 from price_group_dw pgd where id = 3) as markup_tier2_4, -(select group5 from price_group_dw pgd where id = 3) as markup_tier2_5, -(select group1 from price_group_dw pgd where id = 4) as markup_tier3_1, -(select group2 from price_group_dw pgd where id = 4) as markup_tier3_2, -(select group3 from price_group_dw pgd where id = 4) as markup_tier3_3, -(select group4 from price_group_dw pgd where id = 4) as markup_tier3_4, -(select group5 from price_group_dw pgd where id = 4) as markup_tier3_5, -(select group1 from price_group_dw pgd where id = 5) as markup_tier4_1, -(select group2 from price_group_dw pgd where id = 5) as markup_tier4_2, -(select group3 from price_group_dw pgd where id = 5) as markup_tier4_3, -(select group4 from price_group_dw pgd where id = 5) as markup_tier4_4, -(select group5 from price_group_dw pgd where id = 5) as markup_tier4_5, -(select group1 from price_group_dw pgd where id = 6) as markup_tier5_1, -(select group2 from price_group_dw pgd where id = 6) as markup_tier5_2, -(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 -left join brand b on b.id = p.brand_id - 0 - - N - N - N - N - - - Integer - normal - product_id - 9 - 0 - Table input - product_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - item_code - 2147483647 - -1 - Table input - item_code - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - name - 2147483647 - -1 - Table input - name - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - pricing_group - 2147483647 - -1 - Table input - pricing_group - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - purchase_price - -1 - -1 - Table input - purchase_price - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_std1 - -1 - -1 - Table input - markup_std1 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_std2 - -1 - -1 - Table input - markup_std2 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_std3 - -1 - -1 - Table input - markup_std3 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_std4 - -1 - -1 - Table input - markup_std4 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_std5 - -1 - -1 - Table input - markup_std5 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - + + markup_tier2_3 + markup_tier2_3 + Y + + + markup_tier2_4 + markup_tier2_4 + Y + + + markup_tier2_5 + markup_tier2_5 + Y + + + markup_tier3_1 + markup_tier3_1 + Y + + + markup_tier3_2 + markup_tier3_2 + Y + + + markup_tier3_3 + markup_tier3_3 + Y + + + markup_tier3_4 + markup_tier3_4 + Y + + + markup_tier3_5 + markup_tier3_5 + Y + + + markup_tier4_1 + markup_tier4_1 + Y + + + markup_tier4_2 + markup_tier4_2 + Y + + + markup_tier4_3 + markup_tier4_3 + Y + + + markup_tier4_4 + markup_tier4_4 + Y + + + markup_tier4_5 + markup_tier4_5 + Y + + + markup_tier5_1 + markup_tier5_1 + Y + + + markup_tier5_2 + markup_tier5_2 + Y + + + markup_tier5_3 + markup_tier5_3 + Y + + + markup_tier5_4 + markup_tier5_4 + Y + + + markup_tier5_5 + markup_tier5_5 + Y + + + price_after_disc_1 + price_after_disc_1 + Y + + + price_after_disc_2 + price_after_disc_2 + Y + + + price_after_disc_3 + price_after_disc_3 + Y + + + price_after_disc_4 + price_after_disc_4 + Y + + + price_after_disc_5 + price_after_disc_5 + Y + + + price_before_disc1 + price_before_disc1 + Y + + + price_before_disc2 + price_before_disc2 + Y + + + price_before_disc3 + price_before_disc3 + Y + + + price_before_disc4 + price_before_disc4 + Y + + + price_before_disc5 + price_before_disc5 + Y + + + price_tier2_1 + price_tier2_1 + Y + + + price_tier2_2 + price_tier2_2 + Y + + + price_tier2_3 + price_tier2_3 + Y + + + price_tier2_4 + price_tier2_4 + Y + + + price_tier2_5 + price_tier2_5 + Y + + + price_tier3_1 + price_tier3_1 + Y + + + price_tier3_2 + price_tier3_2 + Y + + + price_tier3_3 + price_tier3_3 + Y + + + price_tier3_4 + price_tier3_4 + Y + + + price_tier3_5 + price_tier3_5 + Y + + + price_tier4_1 + price_tier4_1 + Y + + + price_tier4_2 + price_tier4_2 + Y + + + price_tier4_3 + price_tier4_3 + Y + + + price_tier4_4 + price_tier4_4 + Y + + + price_tier4_5 + price_tier4_5 + Y + + + price_tier5_1 + price_tier5_1 + Y + + + price_tier5_2 + price_tier5_2 + Y + + + price_tier5_3 + price_tier5_3 + Y + + + price_tier5_4 + price_tier5_4 + Y + + + price_tier5_5 + price_tier5_5 + Y + + + + + + + + + + + + 736 + 64 + Y + + + + Table input + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + 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, +(select group4 from price_group_dw pgd where id = 2) as markup_std4, +(select group5 from price_group_dw pgd where id = 2) as markup_std5, +(select group1 from price_group_dw pgd where id = 1) as markup_group1, +(select group2 from price_group_dw pgd where id = 1) as markup_group2, +(select group3 from price_group_dw pgd where id = 1) as markup_group3, +(select group4 from price_group_dw pgd where id = 1) as markup_group4, +(select group5 from price_group_dw pgd where id = 1) as markup_group5, +(select group1 from price_group_dw pgd where id = 3) as markup_tier2_1, +(select group2 from price_group_dw pgd where id = 3) as markup_tier2_2, +(select group3 from price_group_dw pgd where id = 3) as markup_tier2_3, +(select group4 from price_group_dw pgd where id = 3) as markup_tier2_4, +(select group5 from price_group_dw pgd where id = 3) as markup_tier2_5, +(select group1 from price_group_dw pgd where id = 4) as markup_tier3_1, +(select group2 from price_group_dw pgd where id = 4) as markup_tier3_2, +(select group3 from price_group_dw pgd where id = 4) as markup_tier3_3, +(select group4 from price_group_dw pgd where id = 4) as markup_tier3_4, +(select group5 from price_group_dw pgd where id = 4) as markup_tier3_5, +(select group1 from price_group_dw pgd where id = 5) as markup_tier4_1, +(select group2 from price_group_dw pgd where id = 5) as markup_tier4_2, +(select group3 from price_group_dw pgd where id = 5) as markup_tier4_3, +(select group4 from price_group_dw pgd where id = 5) as markup_tier4_4, +(select group5 from price_group_dw pgd where id = 5) as markup_tier4_5, +(select group1 from price_group_dw pgd where id = 6) as markup_tier5_1, +(select group2 from price_group_dw pgd where id = 6) as markup_tier5_2, +(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 product p +left join brand b on b.id = p.brand_id + 0 + + N + N + N + N + - BigNumber + Integer normal - markup_group1 - -1 - -1 + product_id + 9 + 0 Table input - markup_group1 - ######0.0###################;-######0.0################### + product_id + ####0;-####0 . - + , none N @@ -1537,16 +1457,16 @@ left join brand b on b.id = p.brand_id N - BigNumber + String normal - markup_group2 - -1 + item_code + 2147483647 -1 Table input - markup_group2 - ######0.0###################;-######0.0################### + item_code + . - + , none N @@ -1560,16 +1480,16 @@ left join brand b on b.id = p.brand_id N - BigNumber + String normal - markup_group3 - -1 + name + 2147483647 -1 Table input - markup_group3 - ######0.0###################;-######0.0################### + name + . - + , none N @@ -1583,16 +1503,16 @@ left join brand b on b.id = p.brand_id N - BigNumber + String normal - markup_group4 - -1 + pricing_group + 2147483647 -1 Table input - markup_group4 - ######0.0###################;-######0.0################### + pricing_group + . - + , none N @@ -1608,11 +1528,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_group5 + purchase_price -1 -1 Table input - markup_group5 + purchase_price ######0.0###################;-######0.0################### . @@ -1631,11 +1551,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier2_1 + markup_std1 -1 -1 Table input - markup_tier2_1 + markup_std1 ######0.0###################;-######0.0################### . @@ -1654,11 +1574,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier2_2 + markup_std2 -1 -1 Table input - markup_tier2_2 + markup_std2 ######0.0###################;-######0.0################### . @@ -1677,11 +1597,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier2_3 + markup_std3 -1 -1 Table input - markup_tier2_3 + markup_std3 ######0.0###################;-######0.0################### . @@ -1700,11 +1620,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier2_4 + markup_std4 -1 -1 Table input - markup_tier2_4 + markup_std4 ######0.0###################;-######0.0################### . @@ -1723,11 +1643,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier2_5 + markup_std5 -1 -1 Table input - markup_tier2_5 + markup_std5 ######0.0###################;-######0.0################### . @@ -1746,11 +1666,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier3_1 + markup_group1 -1 -1 Table input - markup_tier3_1 + markup_group1 ######0.0###################;-######0.0################### . @@ -1769,11 +1689,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier3_2 + markup_group2 -1 -1 Table input - markup_tier3_2 + markup_group2 ######0.0###################;-######0.0################### . @@ -1792,11 +1712,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier3_3 + markup_group3 -1 -1 Table input - markup_tier3_3 + markup_group3 ######0.0###################;-######0.0################### . @@ -1815,11 +1735,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier3_4 + markup_group4 -1 -1 Table input - markup_tier3_4 + markup_group4 ######0.0###################;-######0.0################### . @@ -1838,11 +1758,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier3_5 + markup_group5 -1 -1 Table input - markup_tier3_5 + markup_group5 ######0.0###################;-######0.0################### . @@ -1861,11 +1781,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier4_1 + markup_tier2_1 -1 -1 Table input - markup_tier4_1 + markup_tier2_1 ######0.0###################;-######0.0################### . @@ -1884,11 +1804,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier4_2 + markup_tier2_2 -1 -1 Table input - markup_tier4_2 + markup_tier2_2 ######0.0###################;-######0.0################### . @@ -1907,11 +1827,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier4_3 + markup_tier2_3 -1 -1 Table input - markup_tier4_3 + markup_tier2_3 ######0.0###################;-######0.0################### . @@ -1930,11 +1850,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier4_4 + markup_tier2_4 -1 -1 Table input - markup_tier4_4 + markup_tier2_4 ######0.0###################;-######0.0################### . @@ -1953,11 +1873,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier4_5 + markup_tier2_5 -1 -1 Table input - markup_tier4_5 + markup_tier2_5 ######0.0###################;-######0.0################### . @@ -1976,11 +1896,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier5_1 + markup_tier3_1 -1 -1 Table input - markup_tier5_1 + markup_tier3_1 ######0.0###################;-######0.0################### . @@ -1999,11 +1919,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier5_2 + markup_tier3_2 -1 -1 Table input - markup_tier5_2 + markup_tier3_2 ######0.0###################;-######0.0################### . @@ -2022,11 +1942,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier5_3 + markup_tier3_3 -1 -1 Table input - markup_tier5_3 + markup_tier3_3 ######0.0###################;-######0.0################### . @@ -2045,11 +1965,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier5_4 + markup_tier3_4 -1 -1 Table input - markup_tier5_4 + markup_tier3_4 ######0.0###################;-######0.0################### . @@ -2068,11 +1988,11 @@ left join brand b on b.id = p.brand_id BigNumber normal - markup_tier5_5 + markup_tier3_5 -1 -1 Table input - markup_tier5_5 + markup_tier3_5 ######0.0###################;-######0.0################### . @@ -2088,847 +2008,237 @@ left join brand b on b.id = p.brand_id Asia/Bangkok N - - - - - - - - - - - 240 - 64 - Y - - - - filter group1 - FilterRows - - Y - - 1 - - none - - - select group1 - filter group2 - - - N - pricing_group - = - - - constant - String - group1 - -1 - -1 - N - - - - - - - - - - - - - - 704 - 64 - Y - - - - select group1 - SelectValues - - Y - - 1 - - none - - - - - product_id - - - - item_code - - - - name - - - - pricing_group - - - - purchase_price - - - - markup_std1 - markup_std - - - markup_group1 - markup_group - - - markup_tier2_1 - markup_tier2 - - - markup_tier3_1 - markup_tier3 - - - markup_tier4_1 - markup_tier4 - - - markup_tier5_1 - markup_tier5 - - - price_after_disc_1 - price_after_disc - - - price_before_disc1 - price_before_disc - - - price_tier2_1 - price_tier2 - - - price_tier3_1 - price_tier3 - - - price_tier4_1 - price_tier4 - - - price_tier5_1 - price_tier5 - - N - - - - - - - - - - - 864 - 64 - Y - - - - filter group2 - FilterRows - - Y - - 1 - - none - - - select group2 - filter group3 - - - N - pricing_group - = - - - constant - String - group2 - -1 - -1 - N - - - - - - - - - - - - - - 704 - 176 - Y - - - - select group2 - SelectValues - - Y - - 1 - - none - - - - - product_id - - - - item_code - - - - name - - - - pricing_group - - - - purchase_price - - - - markup_std2 - markup_std - - - markup_group2 - markup_group - - - markup_tier2_2 - markup_tier2 - - - markup_tier3_2 - markup_tier3 - - + + BigNumber + normal + markup_tier4_1 + -1 + -1 + Table input + markup_tier4_1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal markup_tier4_2 - markup_tier4 - - - markup_tier5_2 - markup_tier5 - - - price_after_disc_2 - price_after_disc - - - price_before_disc2 - price_before_disc - - - price_tier2_2 - price_tier2 - - - price_tier3_2 - price_tier3 - - - price_tier4_2 - price_tier4 - - - price_tier5_2 - price_tier5 - - N - - - - - - - - - - - 864 - 176 - Y - - - - filter group3 - FilterRows - - Y - - 1 - - none - - - select group3 - filter group4 - - - N - pricing_group - = - - - constant - String - group3 - -1 - -1 - N - - - - - - - - - - - - - - 704 - 320 - Y - - - - select group3 - SelectValues - - Y - - 1 - - none - - - - - product_id - - - - item_code - - - - name - - - - pricing_group - - - - purchase_price - - - - markup_std3 - markup_std - - - markup_group3 - markup_group - - - markup_tier2_3 - markup_tier2 - - - markup_tier3_3 - markup_tier3 - - + -1 + -1 + Table input + markup_tier4_2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal markup_tier4_3 - markup_tier4 - - - markup_tier5_3 - markup_tier5 - - - price_after_disc_3 - price_after_disc - - - price_before_disc3 - price_before_disc - - - price_tier2_3 - price_tier2 - - - price_tier3_3 - price_tier3 - - - price_tier4_3 - price_tier4 - - - price_tier5_3 - price_tier5 - - N - - - - - - - - - - - 864 - 320 - Y - - - - filter group4 - FilterRows - - Y - - 1 - - none - - - select group4 - filter group5 - - - N - pricing_group - = - - - constant - String - group4 - -1 - -1 - N - - - - - - - - - - - - - - 704 - 432 - Y - - - - select group4 - SelectValues - - Y - - 1 - - none - - - - - product_id - - - - item_code - - - - name - - - - pricing_group - - - - purchase_price - - - - markup_std4 - markup_std - - - markup_group4 - markup_group - - - markup_tier2_4 - markup_tier2 - - - markup_tier3_4 - markup_tier3 - - + -1 + -1 + Table input + markup_tier4_3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal markup_tier4_4 - markup_tier4 - - - markup_tier5_4 - markup_tier5 - - - price_after_disc_4 - price_after_disc - - - price_before_disc4 - price_before_disc - - - price_tier2_4 - price_tier2 - - - price_tier3_4 - price_tier3 - - - price_tier4_4 - price_tier4 - - - price_tier5_4 - price_tier5 - - N - - - - - - - - - - - 864 - 432 - Y - - - - filter group5 - FilterRows - - Y - - 1 - - none - - - select group5 - Write to log - - - N - pricing_group - = - - - constant - String - group5 - -1 - -1 - N - - - - - - - - - - - - - - 704 - 544 - Y - - - - select group5 - SelectValues - - Y - - 1 - - none - - - - - product_id - - - - item_code - - - - name - - - - pricing_group - - - - purchase_price - - - - markup_std5 - markup_std - - - markup_group5 - markup_group - - - markup_tier2_5 - markup_tier2 - - - markup_tier3_5 - markup_tier3 - - + -1 + -1 + Table input + markup_tier4_4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal markup_tier4_5 - markup_tier4 - - + -1 + -1 + Table input + markup_tier4_5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier5_1 + -1 + -1 + Table input + markup_tier5_1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier5_2 + -1 + -1 + Table input + markup_tier5_2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier5_3 + -1 + -1 + Table input + markup_tier5_3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier5_4 + -1 + -1 + Table input + markup_tier5_4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal markup_tier5_5 - markup_tier5 - - - price_after_disc_5 - price_after_disc - - - price_before_disc5 - price_before_disc - - - price_tier2_5 - price_tier2 - - - price_tier3_5 - price_tier3 - - - price_tier4_5 - price_tier4 - - - price_tier5_5 - price_tier5 - - N - - - - - - - - - - - 864 - 544 - Y - - - - Write to log - WriteToLog - - Y - - 1 - - none - - - log_level_basic - Y - N - 0 - - - - - - - - - - - - - 544 - 544 - Y - - - - Append streams - Append - - Y - - 1 - - none - - - select group1 - select group2 - - - - - - - - - - 1104 - 176 - Y - - - - Append streams 2 - Append - - Y - - 1 - - none - - - Append streams - select group3 - - - - - - - - - - 1104 - 320 - Y - - - - Append streams 3 - Append - - Y - - 1 - - none - - - Append streams 2 - select group4 - - - - - - - - - - 1104 - 432 - Y - - - - Append streams 4 - Append - - Y - - 1 - - none - - - Append streams 3 - select group5 + -1 + -1 + Table input + markup_tier5_5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + @@ -2938,8 +2248,8 @@ left join brand b on b.id = p.brand_id - 1104 - 544 + 240 + 64 Y -- cgit v1.2.3