From 1eebb8c2cbd3b79e4a9385653fb82433168d032e Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Wed, 21 Jan 2026 10:18:30 +0700 Subject: add calculate price group to 10 --- calculate_price_after_disc.ktr | 668 ++++- import_price_group.ktr | 202 +- run_calculate_pricelist_odoo.kjb | 2 +- update_override_vendor_pricelist.ktr | 4654 +++++++++++++++++++--------------- 4 files changed, 3413 insertions(+), 2113 deletions(-) diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr index 426b744..eac6ff3 100644 --- a/calculate_price_after_disc.ktr +++ b/calculate_price_after_disc.ktr @@ -442,8 +442,8 @@ Native dw_bi_indoteknik 5432 - pdi - Encrypted 2be989bb20084ca95810197629d9ea18e + odoo + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -658,6 +658,8 @@ coalesce(( (select group6 from price_group_dw pgd where id = 2) as markup_std6, (select group7 from price_group_dw pgd where id = 2) as markup_std7, (select group8 from price_group_dw pgd where id = 2) as markup_std8, +(select group9 from price_group_dw pgd where id = 2) as markup_std9,--new +(select group10 from price_group_dw pgd where id = 2) as markup_std10,--new (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, @@ -666,6 +668,8 @@ coalesce(( (select group6 from price_group_dw pgd where id = 1) as markup_group6, (select group7 from price_group_dw pgd where id = 1) as markup_group7, (select group8 from price_group_dw pgd where id = 1) as markup_group8, +(select group9 from price_group_dw pgd where id = 1) as markup_group9,--new +(select group10 from price_group_dw pgd where id = 1) as markup_group10,--new (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, @@ -674,6 +678,8 @@ coalesce(( (select group6 from price_group_dw pgd where id = 3) as markup_tier2_6, (select group7 from price_group_dw pgd where id = 3) as markup_tier2_7, (select group8 from price_group_dw pgd where id = 3) as markup_tier2_8, +(select group9 from price_group_dw pgd where id = 3) as markup_tier2_9,--new +(select group10 from price_group_dw pgd where id = 3) as markup_tier2_10,--new (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, @@ -682,6 +688,8 @@ coalesce(( (select group6 from price_group_dw pgd where id = 4) as markup_tier3_6, (select group7 from price_group_dw pgd where id = 4) as markup_tier3_7, (select group8 from price_group_dw pgd where id = 4) as markup_tier3_8, +(select group9 from price_group_dw pgd where id = 4) as markup_tier3_9,--new +(select group10 from price_group_dw pgd where id = 4) as markup_tier3_10,--new (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, @@ -690,6 +698,8 @@ coalesce(( (select group6 from price_group_dw pgd where id = 5) as markup_tier4_6, (select group7 from price_group_dw pgd where id = 5) as markup_tier4_7, (select group8 from price_group_dw pgd where id = 5) as markup_tier4_8, +(select group9 from price_group_dw pgd where id = 5) as markup_tier4_9,--new +(select group10 from price_group_dw pgd where id = 5) as markup_tier4_10,--new (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, @@ -697,7 +707,9 @@ coalesce(( (select group5 from price_group_dw pgd where id = 6) as markup_tier5_5, (select group6 from price_group_dw pgd where id = 6) as markup_tier5_6, (select group7 from price_group_dw pgd where id = 6) as markup_tier5_7, -(select group8 from price_group_dw pgd where id = 6) as markup_tier5_8 +(select group8 from price_group_dw pgd where id = 6) as markup_tier5_8, +(select group9 from price_group_dw pgd where id = 6) as markup_tier5_9,--new +(select group10 from price_group_dw pgd where id = 6) as markup_tier5_10--new from product p left join brand b on b.id = p.brand_id 0 @@ -2119,6 +2131,36 @@ left join brand b on b.id = p.brand_id + + diff1_9 + SUBTRACT + price_before_disc9 + price_after_disc_9 + + None + -1 + -1 + N + + + + + + + diff1_10 + SUBTRACT + price_before_disc10 + price_after_disc_10 + + None + -1 + -1 + N + + + + + diff2_1 SUBTRACT @@ -2239,6 +2281,36 @@ left join brand b on b.id = p.brand_id + + diff2_9 + SUBTRACT + price_before_disc9 + price_tier2_9 + + None + -1 + -1 + N + + + + + + + diff3_10 + SUBTRACT + price_before_disc10 + price_tier2_10 + + None + -1 + -1 + N + + + + + diff3_1 SUBTRACT @@ -2359,6 +2431,36 @@ left join brand b on b.id = p.brand_id + + diff3_9 + SUBTRACT + price_before_disc9 + price_tier3_9 + + None + -1 + -1 + N + + + + + + + diff3_10 + SUBTRACT + price_before_disc10 + price_tier3_10 + + None + -1 + -1 + N + + + + + diff4_1 SUBTRACT @@ -2479,6 +2581,36 @@ left join brand b on b.id = p.brand_id + + diff4_9 + SUBTRACT + price_before_disc9 + price_tier4_9 + + None + -1 + -1 + N + + + + + + + diff4_10 + SUBTRACT + price_before_disc10 + price_tier4_10 + + None + -1 + -1 + N + + + + + diff5_1 SUBTRACT @@ -2599,6 +2731,36 @@ left join brand b on b.id = p.brand_id + + diff5_9 + SUBTRACT + price_before_disc9 + price_tier5_9 + + None + -1 + -1 + N + + + + + + + diff5_10 + SUBTRACT + price_before_disc10 + price_tier5_10 + + None + -1 + -1 + N + + + + + @@ -2745,6 +2907,36 @@ left join brand b on b.id = p.brand_id + + disc1_9 + PERCENT_1 + diff1_9 + price_before_disc9 + + Number + -1 + -1 + N + + + + + + + disc1_10 + PERCENT_1 + diff1_10 + price_before_disc10 + + Number + -1 + -1 + N + + + + + disc2_1 PERCENT_1 @@ -2865,6 +3057,36 @@ left join brand b on b.id = p.brand_id + + disc2_9 + PERCENT_1 + diff2_9 + price_before_disc9 + + Number + -1 + -1 + N + + + + + + + disc2_10 + PERCENT_1 + diff2_10 + price_before_disc10 + + Number + -1 + -1 + N + + + + + disc3_1 PERCENT_1 @@ -2985,6 +3207,36 @@ left join brand b on b.id = p.brand_id + + disc3_9 + PERCENT_1 + diff3_9 + price_before_disc9 + + Number + -1 + -1 + N + + + + + + + disc3_10 + PERCENT_1 + diff3_10 + price_before_disc10 + + Number + -1 + -1 + N + + + + + disc4_1 PERCENT_1 @@ -3105,6 +3357,36 @@ left join brand b on b.id = p.brand_id + + disc4_9 + PERCENT_1 + diff4_9 + price_before_disc9 + + Number + -1 + -1 + N + + + + + + + disc4_10 + PERCENT_1 + diff4_10 + price_before_disc10 + + Number + -1 + -1 + N + + + + + disc5_1 PERCENT_1 @@ -3225,6 +3507,36 @@ left join brand b on b.id = p.brand_id + + disc5_9 + PERCENT_1 + diff5_9 + price_before_disc9 + + Number + -1 + -1 + N + + + + + + + disc5_10 + PERCENT_1 + diff5_10 + price_before_disc10 + + Number + -1 + -1 + N + + + + + @@ -3371,6 +3683,36 @@ left join brand b on b.id = p.brand_id + + price_before_disc9 + PERCENT_3 + purchase_price + markup_group9 + + Number + -1 + -1 + N + + + + + + + price_before_disc10 + PERCENT_3 + purchase_price + markup_group10 + + Number + -1 + -1 + N + + + + + price_after_disc_1 PERCENT_3 @@ -3491,6 +3833,36 @@ left join brand b on b.id = p.brand_id + + price_after_disc_9 + PERCENT_3 + purchase_price + markup_std9 + + Number + -1 + -1 + N + + + + + + + price_after_disc_10 + PERCENT_3 + purchase_price + markup_std10 + + Number + -1 + -1 + N + + + + + price_tier2_1 PERCENT_3 @@ -3611,6 +3983,36 @@ left join brand b on b.id = p.brand_id + + price_tier2_9 + PERCENT_3 + purchase_price + markup_tier2_9 + + Number + -1 + -1 + N + + + + + + + price_tier2_10 + PERCENT_3 + purchase_price + markup_tier2_10 + + Number + -1 + -1 + N + + + + + price_tier3_1 PERCENT_3 @@ -3731,6 +4133,36 @@ left join brand b on b.id = p.brand_id + + price_tier3_9 + PERCENT_3 + purchase_price + markup_tier3_9 + + Number + -1 + -1 + N + + + + + + + price_tier3_10 + PERCENT_3 + purchase_price + markup_tier3_10 + + Number + -1 + -1 + N + + + + + price_tier4_1 PERCENT_3 @@ -3851,6 +4283,36 @@ left join brand b on b.id = p.brand_id + + price_tier4_9 + PERCENT_3 + purchase_price + markup_tier4_9 + + Number + -1 + -1 + N + + + + + + + price_tier4_10 + PERCENT_3 + purchase_price + markup_tier4_10 + + Number + -1 + -1 + N + + + + + price_tier5_1 PERCENT_3 @@ -3971,6 +4433,36 @@ left join brand b on b.id = p.brand_id + + price_tier5_9 + PERCENT_3 + purchase_price + markup_tier5_9 + + Number + -1 + -1 + N + + + + + + + price_tier5_10 + PERCENT_3 + purchase_price + markup_tier5_10 + + Number + -1 + -1 + N + + + + + @@ -4048,6 +4540,16 @@ left join brand b on b.id = p.brand_id disc1_8 Y + + disc1_9 + disc1_9 + Y + + + disc1_10 + disc1_10 + Y + disc2_1 disc2_1 @@ -4088,6 +4590,16 @@ left join brand b on b.id = p.brand_id disc2_8 Y + + disc2_9 + disc2_9 + Y + + + disc2_10 + disc2_10 + Y + disc3_1 disc3_1 @@ -4128,6 +4640,16 @@ left join brand b on b.id = p.brand_id disc3_8 Y + + disc3_9 + disc3_9 + Y + + + disc3_10 + disc3_10 + Y + disc4_1 disc4_1 @@ -4168,6 +4690,16 @@ left join brand b on b.id = p.brand_id disc4_8 Y + + disc4_9 + disc4_9 + Y + + + disc4_10 + disc4_10 + Y + disc5_1 disc5_1 @@ -4208,6 +4740,16 @@ left join brand b on b.id = p.brand_id disc5_8 Y + + disc5_9 + disc5_9 + Y + + + disc5_10 + disc5_10 + Y + item_code item_code @@ -4253,6 +4795,16 @@ left join brand b on b.id = p.brand_id markup_group8 Y + + markup_group9 + markup_group9 + Y + + + markup_group10 + markup_group10 + Y + markup_std1 markup_std1 @@ -4293,6 +4845,16 @@ left join brand b on b.id = p.brand_id markup_std8 Y + + markup_std9 + markup_std9 + Y + + + markup_std10 + markup_std10 + Y + markup_tier2_1 markup_tier2_1 @@ -4333,6 +4895,16 @@ left join brand b on b.id = p.brand_id markup_tier2_8 Y + + markup_tier2_9 + markup_tier2_9 + Y + + + markup_tier2_10 + markup_tier2_10 + Y + markup_tier3_1 markup_tier3_1 @@ -4373,6 +4945,16 @@ left join brand b on b.id = p.brand_id markup_tier3_8 Y + + markup_tier3_9 + markup_tier3_9 + Y + + + markup_tier3_10 + markup_tier3_10 + Y + markup_tier4_1 markup_tier4_1 @@ -4413,6 +4995,16 @@ left join brand b on b.id = p.brand_id markup_tier4_8 Y + + markup_tier4_9 + markup_tier4_9 + Y + + + markup_tier4_10 + markup_tier4_10 + Y + markup_tier5_1 markup_tier5_1 @@ -4453,6 +5045,16 @@ left join brand b on b.id = p.brand_id markup_tier5_8 Y + + markup_tier5_9 + markup_tier5_9 + Y + + + markup_tier5_10 + markup_tier5_10 + Y + name name @@ -4498,6 +5100,16 @@ left join brand b on b.id = p.brand_id price_after_disc_8 Y + + price_after_disc_9 + price_after_disc_9 + Y + + + price_after_disc_10 + price_after_disc_10 + Y + price_before_disc1 price_before_disc1 @@ -4538,6 +5150,16 @@ left join brand b on b.id = p.brand_id price_before_disc8 Y + + price_before_disc9 + price_before_disc9 + Y + + + price_before_disc10 + price_before_disc10 + Y + price_tier2_1 price_tier2_1 @@ -4578,6 +5200,16 @@ left join brand b on b.id = p.brand_id price_tier2_8 Y + + price_tier2_9 + price_tier2_9 + Y + + + price_tier2_10 + price_tier2_10 + Y + price_tier3_1 price_tier3_1 @@ -4618,6 +5250,16 @@ left join brand b on b.id = p.brand_id price_tier3_8 Y + + price_tier3_9 + price_tier3_9 + Y + + + price_tier3_10 + price_tier3_10 + Y + price_tier4_1 price_tier4_1 @@ -4658,6 +5300,16 @@ left join brand b on b.id = p.brand_id price_tier4_8 Y + + price_tier4_9 + price_tier4_9 + Y + + + price_tier4_10 + price_tier4_10 + Y + price_tier5_1 price_tier5_1 @@ -4698,6 +5350,16 @@ left join brand b on b.id = p.brand_id price_tier5_8 Y + + price_tier5_9 + price_tier5_9 + Y + + + price_tier5_10 + price_tier5_10 + Y + pricing_group pricing_group diff --git a/import_price_group.ktr b/import_price_group.ktr index 459c61c..8eebead 100644 --- a/import_price_group.ktr +++ b/import_price_group.ktr @@ -442,8 +442,8 @@ Native dw_bi_indoteknik 5432 - pdi - Encrypted 2be989bb20084ca95810197629d9ea18e + odoo + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -544,99 +544,6 @@ Y - - dw Insert / update group - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - 100 - N - - public - price_group_dw
- - id - id - = - - - - id - id - N - - - name - name - Y - - - pricelist_id - pricelist_id - Y - - - group1 - group1 - Y - - - group2 - group2 - Y - - - group3 - group3 - Y - - - group4 - group4 - Y - - - group5 - group5 - Y - - - group6 - group6 - Y - - - group7 - group7 - Y - - - group8 - group8 - Y - - - - - - - - - - - - 480 - 112 - Y - - Table input TableInput @@ -649,7 +556,7 @@ erp indoteknik production (localhost) - select id, name, pricelist_id, group1, group2, group3, group4, group5, group6, group7, group8 from price_group pg + select id, name, pricelist_id, group1, group2, group3, group4, group5, group6, group7, group8, group9, group10 from price_group pg 0 N @@ -856,6 +763,109 @@ Y + + dw Insert / update group + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + price_group_dw
+ + id + id + = + + + + id + id + N + + + name + name + Y + + + pricelist_id + pricelist_id + Y + + + group1 + group1 + Y + + + group2 + group2 + Y + + + group3 + group3 + Y + + + group4 + group4 + Y + + + group5 + group5 + Y + + + group6 + group6 + Y + + + group7 + group7 + Y + + + group8 + group8 + Y + + + group9 + group9 + Y + + + group10 + group10 + Y + + + + + + + + + + + + 480 + 112 + Y + + diff --git a/run_calculate_pricelist_odoo.kjb b/run_calculate_pricelist_odoo.kjb index b7e0d00..1f23dd0 100644 --- a/run_calculate_pricelist_odoo.kjb +++ b/run_calculate_pricelist_odoo.kjb @@ -460,7 +460,7 @@ N Y 0 - 1072 + 1056 96 diff --git a/update_override_vendor_pricelist.ktr b/update_override_vendor_pricelist.ktr index 2f8bbee..6264815 100644 --- a/update_override_vendor_pricelist.ktr +++ b/update_override_vendor_pricelist.ktr @@ -442,8 +442,8 @@ Native dw_bi_indoteknik 5432 - pdi - Encrypted 2be989bb20084ca95810197629d9ea18e + odoo + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -498,22 +498,22 @@ Y - calculate diff - calculate discount + Filter rows + calculate price tier override vendor Y - calculate price tier - calculate diff + calculate price tier override vendor + calculate diff override vendor Y - Filter rows - calculate price tier + calculate diff override vendor + calculate discount override vendor Y - calculate discount + calculate discount override vendor update purchase pricelist override vendor Y @@ -529,7 +529,7 @@ none - calculate price tier + calculate price tier override vendor filter override vendor purchase price = 0 @@ -593,6 +593,8 @@ b.override_vendor_id as vendor_id, (select group6 from price_group_dw pgd where id = 2) as markup_std6, (select group7 from price_group_dw pgd where id = 2) as markup_std7, (select group8 from price_group_dw pgd where id = 2) as markup_std8, +(select group9 from price_group_dw pgd where id = 2) as markup_std9,--new +(select group10 from price_group_dw pgd where id = 2) as markup_std10,--new (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, @@ -601,6 +603,8 @@ b.override_vendor_id as vendor_id, (select group6 from price_group_dw pgd where id = 1) as markup_group6, (select group7 from price_group_dw pgd where id = 1) as markup_group7, (select group8 from price_group_dw pgd where id = 1) as markup_group8, +(select group9 from price_group_dw pgd where id = 1) as markup_group9,--new +(select group10 from price_group_dw pgd where id = 1) as markup_group10,--new (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, @@ -609,6 +613,8 @@ b.override_vendor_id as vendor_id, (select group6 from price_group_dw pgd where id = 3) as markup_tier2_6, (select group7 from price_group_dw pgd where id = 3) as markup_tier2_7, (select group8 from price_group_dw pgd where id = 3) as markup_tier2_8, +(select group9 from price_group_dw pgd where id = 3) as markup_tier2_9,--new +(select group10 from price_group_dw pgd where id = 3) as markup_tier2_10,--new (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, @@ -617,6 +623,8 @@ b.override_vendor_id as vendor_id, (select group6 from price_group_dw pgd where id = 4) as markup_tier3_6, (select group7 from price_group_dw pgd where id = 4) as markup_tier3_7, (select group8 from price_group_dw pgd where id = 4) as markup_tier3_8, +(select group9 from price_group_dw pgd where id = 4) as markup_tier3_9,--new +(select group10 from price_group_dw pgd where id = 4) as markup_tier3_10,--new (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, @@ -625,6 +633,8 @@ b.override_vendor_id as vendor_id, (select group6 from price_group_dw pgd where id = 5) as markup_tier4_6, (select group7 from price_group_dw pgd where id = 5) as markup_tier4_7, (select group8 from price_group_dw pgd where id = 5) as markup_tier4_8, +(select group9 from price_group_dw pgd where id = 5) as markup_tier4_9,--new +(select group10 from price_group_dw pgd where id = 5) as markup_tier4_10,--new (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, @@ -632,7 +642,9 @@ b.override_vendor_id as vendor_id, (select group5 from price_group_dw pgd where id = 6) as markup_tier5_5, (select group6 from price_group_dw pgd where id = 6) as markup_tier5_6, (select group7 from price_group_dw pgd where id = 6) as markup_tier5_7, -(select group8 from price_group_dw pgd where id = 6) as markup_tier5_8 +(select group8 from price_group_dw pgd where id = 6) as markup_tier5_8, +(select group9 from price_group_dw pgd where id = 6) as markup_tier5_9,--new +(select group10 from price_group_dw pgd where id = 6) as markup_tier5_10--new from product p join brand b on b.id = p.brand_id join res_partner rp on rp.id = b.override_vendor_id @@ -1902,2006 +1914,8 @@ where b.purchase_price_exist = 'Y' - calculate diff - Calculator - - Y - - 1 - - none - - - Y - - diff1_1 - SUBTRACT - price_before_disc1 - price_after_disc_1 - - None - -1 - -1 - N - - - - - - - diff1_2 - SUBTRACT - price_before_disc2 - price_after_disc_2 - - None - -1 - -1 - N - - - - - - - diff1_3 - SUBTRACT - price_before_disc3 - price_after_disc_3 - - None - -1 - -1 - N - - - - - - - diff1_4 - SUBTRACT - price_before_disc4 - price_after_disc_4 - - None - -1 - -1 - N - - - - - - - diff1_5 - SUBTRACT - price_before_disc5 - price_after_disc_5 - - None - -1 - -1 - N - - - - - - - diff1_6 - SUBTRACT - price_before_disc6 - price_after_disc_6 - - None - -1 - -1 - N - - - - - - - diff1_7 - SUBTRACT - price_before_disc7 - price_after_disc_7 - - None - -1 - -1 - N - - - - - - - diff1_8 - SUBTRACT - price_before_disc8 - price_after_disc_8 - - None - -1 - -1 - N - - - - - - - diff2_1 - SUBTRACT - price_before_disc1 - price_tier2_1 - - None - -1 - -1 - N - - - - - - - diff2_2 - SUBTRACT - price_before_disc2 - price_tier2_2 - - None - -1 - -1 - N - - - - - - - diff2_3 - SUBTRACT - price_before_disc3 - price_tier2_3 - - None - -1 - -1 - N - - - - - - - diff2_4 - SUBTRACT - price_before_disc4 - price_tier2_4 - - None - -1 - -1 - N - - - - - - - diff2_5 - SUBTRACT - price_before_disc5 - price_tier2_5 - - None - -1 - -1 - N - - - - - - - diff2_6 - SUBTRACT - price_before_disc6 - price_tier2_6 - - None - -1 - -1 - N - - - - - - - diff2_7 - SUBTRACT - price_before_disc7 - price_tier2_7 - - None - -1 - -1 - N - - - - - - - diff2_8 - SUBTRACT - price_before_disc8 - price_tier2_8 - - None - -1 - -1 - N - - - - - - - diff3_1 - SUBTRACT - price_before_disc1 - price_tier3_1 - - None - -1 - -1 - N - - - - - - - diff3_2 - SUBTRACT - price_before_disc2 - price_tier3_2 - - None - -1 - -1 - N - - - - - - - diff3_3 - SUBTRACT - price_before_disc3 - price_tier3_3 - - None - -1 - -1 - N - - - - - - - diff3_4 - SUBTRACT - price_before_disc4 - price_tier3_4 - - None - -1 - -1 - N - - - - - - - diff3_5 - SUBTRACT - price_before_disc5 - price_tier3_5 - - None - -1 - -1 - N - - - - - - - diff3_6 - SUBTRACT - price_before_disc6 - price_tier3_6 - - None - -1 - -1 - N - - - - - - - diff3_7 - SUBTRACT - price_before_disc7 - price_tier3_7 - - None - -1 - -1 - N - - - - - - - diff3_8 - SUBTRACT - price_before_disc8 - price_tier3_8 - - None - -1 - -1 - N - - - - - - - diff4_1 - SUBTRACT - price_before_disc1 - price_tier4_1 - - None - -1 - -1 - N - - - - - - - diff4_2 - SUBTRACT - price_before_disc2 - price_tier4_2 - - None - -1 - -1 - N - - - - - - - diff4_3 - SUBTRACT - price_before_disc3 - price_tier4_3 - - None - -1 - -1 - N - - - - - - - diff4_4 - SUBTRACT - price_before_disc4 - price_tier4_4 - - None - -1 - -1 - N - - - - - - - diff4_5 - SUBTRACT - price_before_disc5 - price_tier4_5 - - None - -1 - -1 - N - - - - - - - diff4_6 - SUBTRACT - price_before_disc6 - price_tier4_6 - - None - -1 - -1 - N - - - - - - - diff4_7 - SUBTRACT - price_before_disc7 - price_tier4_7 - - None - -1 - -1 - N - - - - - - - diff4_8 - SUBTRACT - price_before_disc8 - price_tier4_8 - - None - -1 - -1 - N - - - - - - - diff5_1 - SUBTRACT - price_before_disc1 - price_tier5_1 - - None - -1 - -1 - N - - - - - - - diff5_2 - SUBTRACT - price_before_disc2 - price_tier5_2 - - None - -1 - -1 - N - - - - - - - diff5_3 - SUBTRACT - price_before_disc3 - price_tier5_3 - - None - -1 - -1 - N - - - - - - - diff5_4 - SUBTRACT - price_before_disc4 - price_tier5_4 - - None - -1 - -1 - N - - - - - - - diff5_5 - SUBTRACT - price_before_disc5 - price_tier5_5 - - None - -1 - -1 - N - - - - - - - diff5_6 - SUBTRACT - price_before_disc6 - price_tier5_6 - - None - -1 - -1 - N - - - - - - - diff5_7 - SUBTRACT - price_before_disc7 - price_tier5_7 - - None - -1 - -1 - N - - - - - - - diff5_8 - SUBTRACT - price_before_disc8 - price_tier5_8 - - None - -1 - -1 - N - - - - - - - - - - - - - - - 576 - 256 - Y - - - - calculate discount - Calculator - - Y - - 1 - - none - - - Y - - disc1_1 - PERCENT_1 - diff1_1 - price_before_disc1 - - Number - -1 - -1 - N - - - - - - - disc1_2 - PERCENT_1 - diff1_2 - price_before_disc2 - - Number - -1 - -1 - N - - - - - - - disc1_3 - PERCENT_1 - diff1_3 - price_before_disc3 - - Number - -1 - -1 - N - - - - - - - disc1_4 - PERCENT_1 - diff1_4 - price_before_disc4 - - Number - -1 - -1 - N - - - - - - - disc1_5 - PERCENT_1 - diff1_5 - price_before_disc5 - - Number - -1 - -1 - N - - - - - - - disc1_6 - PERCENT_1 - diff1_6 - price_before_disc6 - - Number - -1 - -1 - N - - - - - - - disc1_7 - PERCENT_1 - diff1_7 - price_before_disc7 - - Number - -1 - -1 - N - - - - - - - disc1_8 - PERCENT_1 - diff1_8 - price_before_disc8 - - Number - -1 - -1 - N - - - - - - - disc2_1 - PERCENT_1 - diff2_1 - price_before_disc1 - - Number - -1 - -1 - N - - - - - - - disc2_2 - PERCENT_1 - diff2_2 - price_before_disc2 - - Number - -1 - -1 - N - - - - - - - disc2_3 - PERCENT_1 - diff2_3 - price_before_disc3 - - Number - -1 - -1 - N - - - - - - - disc2_4 - PERCENT_1 - diff2_4 - price_before_disc4 - - Number - -1 - -1 - N - - - - - - - disc2_5 - PERCENT_1 - diff2_5 - price_before_disc5 - - Number - -1 - -1 - N - - - - - - - disc2_6 - PERCENT_1 - diff2_6 - price_before_disc6 - - Number - -1 - -1 - N - - - - - - - disc2_7 - PERCENT_1 - diff2_7 - price_before_disc7 - - Number - -1 - -1 - N - - - - - - - disc2_8 - PERCENT_1 - diff2_8 - price_before_disc8 - - Number - -1 - -1 - N - - - - - - - disc3_1 - PERCENT_1 - diff3_1 - price_before_disc1 - - Number - -1 - -1 - N - - - - - - - disc3_2 - PERCENT_1 - diff3_2 - price_before_disc2 - - Number - -1 - -1 - N - - - - - - - disc3_3 - PERCENT_1 - diff3_3 - price_before_disc3 - - Number - -1 - -1 - N - - - - - - - disc3_4 - PERCENT_1 - diff3_4 - price_before_disc4 - - Number - -1 - -1 - N - - - - - - - disc3_5 - PERCENT_1 - diff3_5 - price_before_disc5 - - Number - -1 - -1 - N - - - - - - - disc3_6 - PERCENT_1 - diff3_6 - price_before_disc6 - - Number - -1 - -1 - N - - - - - - - disc3_7 - PERCENT_1 - diff3_7 - price_before_disc7 - - Number - -1 - -1 - N - - - - - - - disc3_8 - PERCENT_1 - diff3_8 - price_before_disc8 - - Number - -1 - -1 - N - - - - - - - disc4_1 - PERCENT_1 - diff4_1 - price_before_disc1 - - Number - -1 - -1 - N - - - - - - - disc4_2 - PERCENT_1 - diff4_2 - price_before_disc2 - - Number - -1 - -1 - N - - - - - - - disc4_3 - PERCENT_1 - diff4_3 - price_before_disc3 - - Number - -1 - -1 - N - - - - - - - disc4_4 - PERCENT_1 - diff4_4 - price_before_disc4 - - Number - -1 - -1 - N - - - - - - - disc4_5 - PERCENT_1 - diff4_5 - price_before_disc5 - - Number - -1 - -1 - N - - - - - - - disc4_6 - PERCENT_1 - diff4_6 - price_before_disc6 - - Number - -1 - -1 - N - - - - - - - disc4_7 - PERCENT_1 - diff4_7 - price_before_disc7 - - Number - -1 - -1 - N - - - - - - - disc4_8 - PERCENT_1 - diff4_8 - price_before_disc8 - - Number - -1 - -1 - N - - - - - - - disc5_1 - PERCENT_1 - diff5_1 - price_before_disc1 - - Number - -1 - -1 - N - - - - - - - disc5_2 - PERCENT_1 - diff5_2 - price_before_disc2 - - Number - -1 - -1 - N - - - - - - - disc5_3 - PERCENT_1 - diff5_3 - price_before_disc3 - - Number - -1 - -1 - N - - - - - - - disc5_4 - PERCENT_1 - diff5_4 - price_before_disc4 - - Number - -1 - -1 - N - - - - - - - disc5_5 - PERCENT_1 - diff5_5 - price_before_disc5 - - Number - -1 - -1 - N - - - - - - - disc5_6 - PERCENT_1 - diff5_6 - price_before_disc6 - - Number - -1 - -1 - N - - - - - - - disc5_7 - PERCENT_1 - diff5_7 - price_before_disc7 - - Number - -1 - -1 - N - - - - - - - disc5_8 - PERCENT_1 - diff5_8 - price_before_disc8 - - Number - -1 - -1 - N - - - - - - - - - - - - - - - 736 - 256 - Y - - - - calculate price tier - Calculator - - Y - - 1 - - none - - - Y - - price_before_disc1 - PERCENT_3 - purchase_price - markup_group1 - - Number - -1 - -1 - N - - - - - - - price_before_disc2 - PERCENT_3 - purchase_price - markup_group2 - - Number - -1 - -1 - N - - - - - - - price_before_disc3 - PERCENT_3 - purchase_price - markup_group3 - - Number - -1 - -1 - N - - - - - - - price_before_disc4 - PERCENT_3 - purchase_price - markup_group4 - - Number - -1 - -1 - N - - - - - - - price_before_disc5 - PERCENT_3 - purchase_price - markup_group5 - - Number - -1 - -1 - N - - - - - - - price_before_disc6 - PERCENT_3 - purchase_price - markup_group6 - - Number - -1 - -1 - N - - - - - - - price_before_disc7 - PERCENT_3 - purchase_price - markup_group7 - - Number - -1 - -1 - N - - - - - - - price_before_disc8 - PERCENT_3 - purchase_price - markup_group8 - - Number - -1 - -1 - N - - - - - - - price_after_disc_1 - PERCENT_3 - purchase_price - markup_std1 - - Number - -1 - -1 - N - - - - - - - price_after_disc_2 - PERCENT_3 - purchase_price - markup_std2 - - Number - -1 - -1 - N - - - - - - - price_after_disc_3 - PERCENT_3 - purchase_price - markup_std3 - - Number - -1 - -1 - N - - - - - - - price_after_disc_4 - PERCENT_3 - purchase_price - markup_std4 - - Number - -1 - -1 - N - - - - - - - price_after_disc_5 - PERCENT_3 - purchase_price - markup_std5 - - Number - -1 - -1 - N - - - - - - - price_after_disc_6 - PERCENT_3 - purchase_price - markup_std6 - - Number - -1 - -1 - N - - - - - - - price_after_disc_7 - PERCENT_3 - purchase_price - markup_std7 - - Number - -1 - -1 - N - - - - - - - price_after_disc_8 - PERCENT_3 - purchase_price - markup_std8 - - Number - -1 - -1 - N - - - - - - - price_tier2_1 - PERCENT_3 - purchase_price - markup_tier2_1 - - Number - -1 - -1 - N - - - - - - - price_tier2_2 - PERCENT_3 - purchase_price - markup_tier2_2 - - Number - -1 - -1 - N - - - - - - - price_tier2_3 - PERCENT_3 - purchase_price - markup_tier2_3 - - Number - -1 - -1 - N - - - - - - - price_tier2_4 - PERCENT_3 - purchase_price - markup_tier2_4 - - Number - -1 - -1 - N - - - - - - - price_tier2_5 - PERCENT_3 - purchase_price - markup_tier2_5 - - Number - -1 - -1 - N - - - - - - - price_tier2_6 - PERCENT_3 - purchase_price - markup_tier2_6 - - Number - -1 - -1 - N - - - - - - - price_tier2_7 - PERCENT_3 - purchase_price - markup_tier2_7 - - Number - -1 - -1 - N - - - - - - - price_tier2_8 - PERCENT_3 - purchase_price - markup_tier2_8 - - Number - -1 - -1 - N - - - - - - - price_tier3_1 - PERCENT_3 - purchase_price - markup_tier3_1 - - Number - -1 - -1 - N - - - - - - - price_tier3_2 - PERCENT_3 - purchase_price - markup_tier3_2 - - Number - -1 - -1 - N - - - - - - - price_tier3_3 - PERCENT_3 - purchase_price - markup_tier3_3 - - Number - -1 - -1 - N - - - - - - - price_tier3_4 - PERCENT_3 - purchase_price - markup_tier3_4 - - Number - -1 - -1 - N - - - - - - - price_tier3_5 - PERCENT_3 - purchase_price - markup_tier3_5 - - Number - -1 - -1 - N - - - - - - - price_tier3_6 - PERCENT_3 - purchase_price - markup_tier3_6 - - Number - -1 - -1 - N - - - - - - - price_tier3_7 - PERCENT_3 - purchase_price - markup_tier3_7 - - Number - -1 - -1 - N - - - - - - - price_tier3_8 - PERCENT_3 - purchase_price - markup_tier3_8 - - Number - -1 - -1 - N - - - - - - - price_tier4_1 - PERCENT_3 - purchase_price - markup_tier4_1 - - Number - -1 - -1 - N - - - - - - - price_tier4_2 - PERCENT_3 - purchase_price - markup_tier4_2 - - Number - -1 - -1 - N - - - - - - - price_tier4_3 - PERCENT_3 - purchase_price - markup_tier4_3 - - Number - -1 - -1 - N - - - - - - - price_tier4_4 - PERCENT_3 - purchase_price - markup_tier4_4 - - Number - -1 - -1 - N - - - - - - - price_tier4_5 - PERCENT_3 - purchase_price - markup_tier4_5 - - Number - -1 - -1 - N - - - - - - - price_tier4_6 - PERCENT_3 - purchase_price - markup_tier4_6 - - Number - -1 - -1 - N - - - - - - - price_tier4_7 - PERCENT_3 - purchase_price - markup_tier4_7 - - Number - -1 - -1 - N - - - - - - - price_tier4_8 - PERCENT_3 - purchase_price - markup_tier4_8 - - Number - -1 - -1 - N - - - - - - - price_tier5_1 - PERCENT_3 - purchase_price - markup_tier5_1 - - Number - -1 - -1 - N - - - - - - - price_tier5_2 - PERCENT_3 - purchase_price - markup_tier5_2 - - Number - -1 - -1 - N - - - - - - - price_tier5_3 - PERCENT_3 - purchase_price - markup_tier5_3 - - Number - -1 - -1 - N - - - - - - - price_tier5_4 - PERCENT_3 - purchase_price - markup_tier5_4 - - Number - -1 - -1 - N - - - - - - - price_tier5_5 - PERCENT_3 - purchase_price - markup_tier5_5 - - Number - -1 - -1 - N - - - - - - - price_tier5_6 - PERCENT_3 - purchase_price - markup_tier5_6 - - Number - -1 - -1 - N - - - - - - - price_tier5_7 - PERCENT_3 - purchase_price - markup_tier5_7 - - Number - -1 - -1 - N - - - - - - - price_tier5_8 - PERCENT_3 - purchase_price - markup_tier5_8 - - Number - -1 - -1 - N - - - - - - - - - - - - - - - 576 - 128 - Y - - - - filter override vendor purchase price = 0 - WriteToLog + filter override vendor purchase price = 0 + WriteToLog Y @@ -4009,6 +2023,14 @@ where b.purchase_price_exist = 'Y' markup_std8 markup_std8 + + markup_std9 + markup_std9 + + + markup_std10 + markup_std10 + markup_group1 markup_group1 @@ -4041,6 +2063,14 @@ where b.purchase_price_exist = 'Y' markup_group8 markup_group8 + + markup_group9 + markup_group9 + + + markup_group10 + markup_group10 + markup_tier2_1 markup_tier2_1 @@ -4073,6 +2103,14 @@ where b.purchase_price_exist = 'Y' markup_tier2_8 markup_tier2_8 + + markup_tier2_9 + markup_tier2_9 + + + markup_tier2_10 + markup_tier2_10 + markup_tier3_1 markup_tier3_1 @@ -4105,6 +2143,14 @@ where b.purchase_price_exist = 'Y' markup_tier3_8 markup_tier3_8 + + markup_tier3_9 + markup_tier3_9 + + + markup_tier3_10 + markup_tier3_10 + markup_tier4_1 markup_tier4_1 @@ -4137,6 +2183,14 @@ where b.purchase_price_exist = 'Y' markup_tier4_8 markup_tier4_8 + + markup_tier4_9 + markup_tier4_9 + + + markup_tier4_10 + markup_tier4_10 + markup_tier5_1 markup_tier5_1 @@ -4169,6 +2223,14 @@ where b.purchase_price_exist = 'Y' markup_tier5_8 markup_tier5_8 + + markup_tier5_9 + markup_tier5_9 + + + markup_tier5_10 + markup_tier5_10 + price_before_disc1 price_before_disc1 @@ -4201,6 +2263,14 @@ where b.purchase_price_exist = 'Y' price_before_disc8 price_before_disc8 + + price_before_disc9 + price_before_disc9 + + + price_before_disc10 + price_before_disc10 + price_after_disc_1 price_after_disc_1 @@ -4233,6 +2303,14 @@ where b.purchase_price_exist = 'Y' price_after_disc_8 price_after_disc_8 + + price_after_disc_9 + price_after_disc_9 + + + price_after_disc_10 + price_after_disc_10 + price_tier2_1 price_tier2_1 @@ -4265,6 +2343,14 @@ where b.purchase_price_exist = 'Y' price_tier2_8 price_tier2_8 + + price_tier2_9 + price_tier2_9 + + + price_tier2_10 + price_tier2_10 + price_tier3_1 price_tier3_1 @@ -4297,6 +2383,14 @@ where b.purchase_price_exist = 'Y' price_tier3_8 price_tier3_8 + + price_tier3_9 + price_tier3_9 + + + price_tier3_10 + price_tier3_10 + price_tier4_1 price_tier4_1 @@ -4329,6 +2423,14 @@ where b.purchase_price_exist = 'Y' price_tier4_8 price_tier4_8 + + price_tier4_9 + price_tier4_9 + + + price_tier4_10 + price_tier4_10 + price_tier5_1 price_tier5_1 @@ -4361,6 +2463,14 @@ where b.purchase_price_exist = 'Y' price_tier5_8 price_tier5_8 + + price_tier5_9 + price_tier5_9 + + + price_tier5_10 + price_tier5_10 + disc1_1 disc1_1 @@ -4393,6 +2503,14 @@ where b.purchase_price_exist = 'Y' disc1_8 disc1_8 + + disc1_9 + disc1_9 + + + disc1_10 + disc1_10 + disc2_1 disc2_1 @@ -4425,6 +2543,14 @@ where b.purchase_price_exist = 'Y' disc2_8 disc2_8 + + disc2_9 + disc2_9 + + + disc2_10 + disc2_10 + disc3_1 disc3_1 @@ -4457,6 +2583,14 @@ where b.purchase_price_exist = 'Y' disc3_8 disc3_8 + + disc3_9 + disc3_9 + + + disc3_10 + disc3_10 + disc4_1 disc4_1 @@ -4489,6 +2623,14 @@ where b.purchase_price_exist = 'Y' disc4_8 disc4_8 + + disc4_9 + disc4_9 + + + disc4_10 + disc4_10 + disc5_1 disc5_1 @@ -4521,6 +2663,14 @@ where b.purchase_price_exist = 'Y' disc5_8 disc5_8 + + disc5_9 + disc5_9 + + + disc5_10 + disc5_10 + vendor_id vendor_id @@ -4535,8 +2685,2486 @@ where b.purchase_price_exist = 'Y' - 1024 - 256 + 1168 + 352 + Y + + + + calculate price tier override vendor + Calculator + + Y + + 1 + + none + + + Y + + price_before_disc1 + PERCENT_3 + purchase_price + markup_group1 + + Number + -1 + -1 + N + + + + + + + price_before_disc2 + PERCENT_3 + purchase_price + markup_group2 + + Number + -1 + -1 + N + + + + + + + price_before_disc3 + PERCENT_3 + purchase_price + markup_group3 + + Number + -1 + -1 + N + + + + + + + price_before_disc4 + PERCENT_3 + purchase_price + markup_group4 + + Number + -1 + -1 + N + + + + + + + price_before_disc5 + PERCENT_3 + purchase_price + markup_group5 + + Number + -1 + -1 + N + + + + + + + price_before_disc6 + PERCENT_3 + purchase_price + markup_group6 + + Number + -1 + -1 + N + + + + + + + price_before_disc7 + PERCENT_3 + purchase_price + markup_group7 + + Number + -1 + -1 + N + + + + + + + price_before_disc8 + PERCENT_3 + purchase_price + markup_group8 + + Number + -1 + -1 + N + + + + + + + price_before_disc9 + PERCENT_3 + purchase_price + markup_group9 + + Number + -1 + -1 + N + + + + + + + price_before_disc10 + PERCENT_3 + purchase_price + markup_group10 + + Number + -1 + -1 + N + + + + + + + price_after_disc_1 + PERCENT_3 + purchase_price + markup_std1 + + Number + -1 + -1 + N + + + + + + + price_after_disc_2 + PERCENT_3 + purchase_price + markup_std2 + + Number + -1 + -1 + N + + + + + + + price_after_disc_3 + PERCENT_3 + purchase_price + markup_std3 + + Number + -1 + -1 + N + + + + + + + price_after_disc_4 + PERCENT_3 + purchase_price + markup_std4 + + Number + -1 + -1 + N + + + + + + + price_after_disc_5 + PERCENT_3 + purchase_price + markup_std5 + + Number + -1 + -1 + N + + + + + + + price_after_disc_6 + PERCENT_3 + purchase_price + markup_std6 + + Number + -1 + -1 + N + + + + + + + price_after_disc_7 + PERCENT_3 + purchase_price + markup_std7 + + Number + -1 + -1 + N + + + + + + + price_after_disc_8 + PERCENT_3 + purchase_price + markup_std8 + + Number + -1 + -1 + N + + + + + + + price_after_disc_9 + PERCENT_3 + purchase_price + markup_std9 + + Number + -1 + -1 + N + + + + + + + price_after_disc_10 + PERCENT_3 + purchase_price + markup_std10 + + Number + -1 + -1 + N + + + + + + + price_tier2_1 + PERCENT_3 + purchase_price + markup_tier2_1 + + Number + -1 + -1 + N + + + + + + + price_tier2_2 + PERCENT_3 + purchase_price + markup_tier2_2 + + Number + -1 + -1 + N + + + + + + + price_tier2_3 + PERCENT_3 + purchase_price + markup_tier2_3 + + Number + -1 + -1 + N + + + + + + + price_tier2_4 + PERCENT_3 + purchase_price + markup_tier2_4 + + Number + -1 + -1 + N + + + + + + + price_tier2_5 + PERCENT_3 + purchase_price + markup_tier2_5 + + Number + -1 + -1 + N + + + + + + + price_tier2_6 + PERCENT_3 + purchase_price + markup_tier2_6 + + Number + -1 + -1 + N + + + + + + + price_tier2_7 + PERCENT_3 + purchase_price + markup_tier2_7 + + Number + -1 + -1 + N + + + + + + + price_tier2_8 + PERCENT_3 + purchase_price + markup_tier2_8 + + Number + -1 + -1 + N + + + + + + + price_tier2_9 + PERCENT_3 + purchase_price + markup_tier2_9 + + Number + -1 + -1 + N + + + + + + + price_tier2_10 + PERCENT_3 + purchase_price + markup_tier2_10 + + Number + -1 + -1 + N + + + + + + + price_tier3_1 + PERCENT_3 + purchase_price + markup_tier3_1 + + Number + -1 + -1 + N + + + + + + + price_tier3_2 + PERCENT_3 + purchase_price + markup_tier3_2 + + Number + -1 + -1 + N + + + + + + + price_tier3_3 + PERCENT_3 + purchase_price + markup_tier3_3 + + Number + -1 + -1 + N + + + + + + + price_tier3_4 + PERCENT_3 + purchase_price + markup_tier3_4 + + Number + -1 + -1 + N + + + + + + + price_tier3_5 + PERCENT_3 + purchase_price + markup_tier3_5 + + Number + -1 + -1 + N + + + + + + + price_tier3_6 + PERCENT_3 + purchase_price + markup_tier3_6 + + Number + -1 + -1 + N + + + + + + + price_tier3_7 + PERCENT_3 + purchase_price + markup_tier3_7 + + Number + -1 + -1 + N + + + + + + + price_tier3_8 + PERCENT_3 + purchase_price + markup_tier3_8 + + Number + -1 + -1 + N + + + + + + + price_tier3_9 + PERCENT_3 + purchase_price + markup_tier3_9 + + Number + -1 + -1 + N + + + + + + + price_tier3_10 + PERCENT_3 + purchase_price + markup_tier3_10 + + Number + -1 + -1 + N + + + + + + + price_tier4_1 + PERCENT_3 + purchase_price + markup_tier4_1 + + Number + -1 + -1 + N + + + + + + + price_tier4_2 + PERCENT_3 + purchase_price + markup_tier4_2 + + Number + -1 + -1 + N + + + + + + + price_tier4_3 + PERCENT_3 + purchase_price + markup_tier4_3 + + Number + -1 + -1 + N + + + + + + + price_tier4_4 + PERCENT_3 + purchase_price + markup_tier4_4 + + Number + -1 + -1 + N + + + + + + + price_tier4_5 + PERCENT_3 + purchase_price + markup_tier4_5 + + Number + -1 + -1 + N + + + + + + + price_tier4_6 + PERCENT_3 + purchase_price + markup_tier4_6 + + Number + -1 + -1 + N + + + + + + + price_tier4_7 + PERCENT_3 + purchase_price + markup_tier4_7 + + Number + -1 + -1 + N + + + + + + + price_tier4_8 + PERCENT_3 + purchase_price + markup_tier4_8 + + Number + -1 + -1 + N + + + + + + + price_tier4_9 + PERCENT_3 + purchase_price + markup_tier4_9 + + Number + -1 + -1 + N + + + + + + + price_tier4_10 + PERCENT_3 + purchase_price + markup_tier4_10 + + Number + -1 + -1 + N + + + + + + + price_tier5_1 + PERCENT_3 + purchase_price + markup_tier5_1 + + Number + -1 + -1 + N + + + + + + + price_tier5_2 + PERCENT_3 + purchase_price + markup_tier5_2 + + Number + -1 + -1 + N + + + + + + + price_tier5_3 + PERCENT_3 + purchase_price + markup_tier5_3 + + Number + -1 + -1 + N + + + + + + + price_tier5_4 + PERCENT_3 + purchase_price + markup_tier5_4 + + Number + -1 + -1 + N + + + + + + + price_tier5_5 + PERCENT_3 + purchase_price + markup_tier5_5 + + Number + -1 + -1 + N + + + + + + + price_tier5_6 + PERCENT_3 + purchase_price + markup_tier5_6 + + Number + -1 + -1 + N + + + + + + + price_tier5_7 + PERCENT_3 + purchase_price + markup_tier5_7 + + Number + -1 + -1 + N + + + + + + + price_tier5_8 + PERCENT_3 + purchase_price + markup_tier5_8 + + Number + -1 + -1 + N + + + + + + + price_tier5_9 + PERCENT_3 + purchase_price + markup_tier5_9 + + Number + -1 + -1 + N + + + + + + + price_tier5_10 + PERCENT_3 + purchase_price + markup_tier5_10 + + Number + -1 + -1 + N + + + + + + + + + + + + + + + 576 + 128 + Y + + + + calculate diff override vendor + Calculator + + Y + + 1 + + none + + + Y + + diff1_1 + SUBTRACT + price_before_disc1 + price_after_disc_1 + + None + -1 + -1 + N + + + + + + + diff1_2 + SUBTRACT + price_before_disc2 + price_after_disc_2 + + None + -1 + -1 + N + + + + + + + diff1_3 + SUBTRACT + price_before_disc3 + price_after_disc_3 + + None + -1 + -1 + N + + + + + + + diff1_4 + SUBTRACT + price_before_disc4 + price_after_disc_4 + + None + -1 + -1 + N + + + + + + + diff1_5 + SUBTRACT + price_before_disc5 + price_after_disc_5 + + None + -1 + -1 + N + + + + + + + diff1_6 + SUBTRACT + price_before_disc6 + price_after_disc_6 + + None + -1 + -1 + N + + + + + + + diff1_7 + SUBTRACT + price_before_disc7 + price_after_disc_7 + + None + -1 + -1 + N + + + + + + + diff1_8 + SUBTRACT + price_before_disc8 + price_after_disc_8 + + None + -1 + -1 + N + + + + + + + diff1_9 + SUBTRACT + price_before_disc9 + price_after_disc_9 + + None + -1 + -1 + N + + + + + + + diff1_10 + SUBTRACT + price_before_disc10 + price_after_disc_10 + + None + -1 + -1 + N + + + + + + + diff2_1 + SUBTRACT + price_before_disc1 + price_tier2_1 + + None + -1 + -1 + N + + + + + + + diff2_2 + SUBTRACT + price_before_disc2 + price_tier2_2 + + None + -1 + -1 + N + + + + + + + diff2_3 + SUBTRACT + price_before_disc3 + price_tier2_3 + + None + -1 + -1 + N + + + + + + + diff2_4 + SUBTRACT + price_before_disc4 + price_tier2_4 + + None + -1 + -1 + N + + + + + + + diff2_5 + SUBTRACT + price_before_disc5 + price_tier2_5 + + None + -1 + -1 + N + + + + + + + diff2_6 + SUBTRACT + price_before_disc6 + price_tier2_6 + + None + -1 + -1 + N + + + + + + + diff2_7 + SUBTRACT + price_before_disc7 + price_tier2_7 + + None + -1 + -1 + N + + + + + + + diff2_8 + SUBTRACT + price_before_disc8 + price_tier2_8 + + None + -1 + -1 + N + + + + + + + diff2_9 + SUBTRACT + price_before_disc9 + price_tier2_9 + + None + -1 + -1 + N + + + + + + + diff3_10 + SUBTRACT + price_before_disc10 + price_tier2_10 + + None + -1 + -1 + N + + + + + + + diff3_1 + SUBTRACT + price_before_disc1 + price_tier3_1 + + None + -1 + -1 + N + + + + + + + diff3_2 + SUBTRACT + price_before_disc2 + price_tier3_2 + + None + -1 + -1 + N + + + + + + + diff3_3 + SUBTRACT + price_before_disc3 + price_tier3_3 + + None + -1 + -1 + N + + + + + + + diff3_4 + SUBTRACT + price_before_disc4 + price_tier3_4 + + None + -1 + -1 + N + + + + + + + diff3_5 + SUBTRACT + price_before_disc5 + price_tier3_5 + + None + -1 + -1 + N + + + + + + + diff3_6 + SUBTRACT + price_before_disc6 + price_tier3_6 + + None + -1 + -1 + N + + + + + + + diff3_7 + SUBTRACT + price_before_disc7 + price_tier3_7 + + None + -1 + -1 + N + + + + + + + diff3_8 + SUBTRACT + price_before_disc8 + price_tier3_8 + + None + -1 + -1 + N + + + + + + + diff3_9 + SUBTRACT + price_before_disc9 + price_tier3_9 + + None + -1 + -1 + N + + + + + + + diff3_10 + SUBTRACT + price_before_disc10 + price_tier3_10 + + None + -1 + -1 + N + + + + + + + diff4_1 + SUBTRACT + price_before_disc1 + price_tier4_1 + + None + -1 + -1 + N + + + + + + + diff4_2 + SUBTRACT + price_before_disc2 + price_tier4_2 + + None + -1 + -1 + N + + + + + + + diff4_3 + SUBTRACT + price_before_disc3 + price_tier4_3 + + None + -1 + -1 + N + + + + + + + diff4_4 + SUBTRACT + price_before_disc4 + price_tier4_4 + + None + -1 + -1 + N + + + + + + + diff4_5 + SUBTRACT + price_before_disc5 + price_tier4_5 + + None + -1 + -1 + N + + + + + + + diff4_6 + SUBTRACT + price_before_disc6 + price_tier4_6 + + None + -1 + -1 + N + + + + + + + diff4_7 + SUBTRACT + price_before_disc7 + price_tier4_7 + + None + -1 + -1 + N + + + + + + + diff4_8 + SUBTRACT + price_before_disc8 + price_tier4_8 + + None + -1 + -1 + N + + + + + + + diff4_9 + SUBTRACT + price_before_disc9 + price_tier4_9 + + None + -1 + -1 + N + + + + + + + diff4_10 + SUBTRACT + price_before_disc10 + price_tier4_10 + + None + -1 + -1 + N + + + + + + + diff5_1 + SUBTRACT + price_before_disc1 + price_tier5_1 + + None + -1 + -1 + N + + + + + + + diff5_2 + SUBTRACT + price_before_disc2 + price_tier5_2 + + None + -1 + -1 + N + + + + + + + diff5_3 + SUBTRACT + price_before_disc3 + price_tier5_3 + + None + -1 + -1 + N + + + + + + + diff5_4 + SUBTRACT + price_before_disc4 + price_tier5_4 + + None + -1 + -1 + N + + + + + + + diff5_5 + SUBTRACT + price_before_disc5 + price_tier5_5 + + None + -1 + -1 + N + + + + + + + diff5_6 + SUBTRACT + price_before_disc6 + price_tier5_6 + + None + -1 + -1 + N + + + + + + + diff5_7 + SUBTRACT + price_before_disc7 + price_tier5_7 + + None + -1 + -1 + N + + + + + + + diff5_8 + SUBTRACT + price_before_disc8 + price_tier5_8 + + None + -1 + -1 + N + + + + + + + diff5_9 + SUBTRACT + price_before_disc9 + price_tier5_9 + + None + -1 + -1 + N + + + + + + + diff5_10 + SUBTRACT + price_before_disc10 + price_tier5_10 + + None + -1 + -1 + N + + + + + + + + + + + + + + + 576 + 352 + Y + + + + calculate discount override vendor + Calculator + + Y + + 1 + + none + + + Y + + disc1_1 + PERCENT_1 + diff1_1 + price_before_disc1 + + Number + -1 + -1 + N + + + + + + + disc1_2 + PERCENT_1 + diff1_2 + price_before_disc2 + + Number + -1 + -1 + N + + + + + + + disc1_3 + PERCENT_1 + diff1_3 + price_before_disc3 + + Number + -1 + -1 + N + + + + + + + disc1_4 + PERCENT_1 + diff1_4 + price_before_disc4 + + Number + -1 + -1 + N + + + + + + + disc1_5 + PERCENT_1 + diff1_5 + price_before_disc5 + + Number + -1 + -1 + N + + + + + + + disc1_6 + PERCENT_1 + diff1_6 + price_before_disc6 + + Number + -1 + -1 + N + + + + + + + disc1_7 + PERCENT_1 + diff1_7 + price_before_disc7 + + Number + -1 + -1 + N + + + + + + + disc1_8 + PERCENT_1 + diff1_8 + price_before_disc8 + + Number + -1 + -1 + N + + + + + + + disc1_9 + PERCENT_1 + diff1_9 + price_before_disc9 + + Number + -1 + -1 + N + + + + + + + disc1_10 + PERCENT_1 + diff1_10 + price_before_disc10 + + Number + -1 + -1 + N + + + + + + + disc2_1 + PERCENT_1 + diff2_1 + price_before_disc1 + + Number + -1 + -1 + N + + + + + + + disc2_2 + PERCENT_1 + diff2_2 + price_before_disc2 + + Number + -1 + -1 + N + + + + + + + disc2_3 + PERCENT_1 + diff2_3 + price_before_disc3 + + Number + -1 + -1 + N + + + + + + + disc2_4 + PERCENT_1 + diff2_4 + price_before_disc4 + + Number + -1 + -1 + N + + + + + + + disc2_5 + PERCENT_1 + diff2_5 + price_before_disc5 + + Number + -1 + -1 + N + + + + + + + disc2_6 + PERCENT_1 + diff2_6 + price_before_disc6 + + Number + -1 + -1 + N + + + + + + + disc2_7 + PERCENT_1 + diff2_7 + price_before_disc7 + + Number + -1 + -1 + N + + + + + + + disc2_8 + PERCENT_1 + diff2_8 + price_before_disc8 + + Number + -1 + -1 + N + + + + + + + disc2_9 + PERCENT_1 + diff2_9 + price_before_disc9 + + Number + -1 + -1 + N + + + + + + + disc2_10 + PERCENT_1 + diff2_10 + price_before_disc10 + + Number + -1 + -1 + N + + + + + + + disc3_1 + PERCENT_1 + diff3_1 + price_before_disc1 + + Number + -1 + -1 + N + + + + + + + disc3_2 + PERCENT_1 + diff3_2 + price_before_disc2 + + Number + -1 + -1 + N + + + + + + + disc3_3 + PERCENT_1 + diff3_3 + price_before_disc3 + + Number + -1 + -1 + N + + + + + + + disc3_4 + PERCENT_1 + diff3_4 + price_before_disc4 + + Number + -1 + -1 + N + + + + + + + disc3_5 + PERCENT_1 + diff3_5 + price_before_disc5 + + Number + -1 + -1 + N + + + + + + + disc3_6 + PERCENT_1 + diff3_6 + price_before_disc6 + + Number + -1 + -1 + N + + + + + + + disc3_7 + PERCENT_1 + diff3_7 + price_before_disc7 + + Number + -1 + -1 + N + + + + + + + disc3_8 + PERCENT_1 + diff3_8 + price_before_disc8 + + Number + -1 + -1 + N + + + + + + + disc3_9 + PERCENT_1 + diff3_9 + price_before_disc9 + + Number + -1 + -1 + N + + + + + + + disc3_10 + PERCENT_1 + diff3_10 + price_before_disc10 + + Number + -1 + -1 + N + + + + + + + disc4_1 + PERCENT_1 + diff4_1 + price_before_disc1 + + Number + -1 + -1 + N + + + + + + + disc4_2 + PERCENT_1 + diff4_2 + price_before_disc2 + + Number + -1 + -1 + N + + + + + + + disc4_3 + PERCENT_1 + diff4_3 + price_before_disc3 + + Number + -1 + -1 + N + + + + + + + disc4_4 + PERCENT_1 + diff4_4 + price_before_disc4 + + Number + -1 + -1 + N + + + + + + + disc4_5 + PERCENT_1 + diff4_5 + price_before_disc5 + + Number + -1 + -1 + N + + + + + + + disc4_6 + PERCENT_1 + diff4_6 + price_before_disc6 + + Number + -1 + -1 + N + + + + + + + disc4_7 + PERCENT_1 + diff4_7 + price_before_disc7 + + Number + -1 + -1 + N + + + + + + + disc4_8 + PERCENT_1 + diff4_8 + price_before_disc8 + + Number + -1 + -1 + N + + + + + + + disc4_9 + PERCENT_1 + diff4_9 + price_before_disc9 + + Number + -1 + -1 + N + + + + + + + disc4_10 + PERCENT_1 + diff4_10 + price_before_disc10 + + Number + -1 + -1 + N + + + + + + + disc5_1 + PERCENT_1 + diff5_1 + price_before_disc1 + + Number + -1 + -1 + N + + + + + + + disc5_2 + PERCENT_1 + diff5_2 + price_before_disc2 + + Number + -1 + -1 + N + + + + + + + disc5_3 + PERCENT_1 + diff5_3 + price_before_disc3 + + Number + -1 + -1 + N + + + + + + + disc5_4 + PERCENT_1 + diff5_4 + price_before_disc4 + + Number + -1 + -1 + N + + + + + + + disc5_5 + PERCENT_1 + diff5_5 + price_before_disc5 + + Number + -1 + -1 + N + + + + + + + disc5_6 + PERCENT_1 + diff5_6 + price_before_disc6 + + Number + -1 + -1 + N + + + + + + + disc5_7 + PERCENT_1 + diff5_7 + price_before_disc7 + + Number + -1 + -1 + N + + + + + + + disc5_8 + PERCENT_1 + diff5_8 + price_before_disc8 + + Number + -1 + -1 + N + + + + + + + disc5_9 + PERCENT_1 + diff5_9 + price_before_disc9 + + Number + -1 + -1 + N + + + + + + + disc5_10 + PERCENT_1 + diff5_10 + price_before_disc10 + + Number + -1 + -1 + N + + + + + + + + + + + + + + + 832 + 352 Y -- cgit v1.2.3