From 37e1415cee670b36e819e6c0d648d2cae4733b9f Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 19 Sep 2023 14:37:51 +0700 Subject: calculate price 6 to 8 --- calculate_price_after_disc.ktr | 1756 ++++++++++++++++++++++++++++++++++------ 1 file changed, 1493 insertions(+), 263 deletions(-) diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr index b3ae58c..da4eb5e 100644 --- a/calculate_price_after_disc.ktr +++ b/calculate_price_after_disc.ktr @@ -635,53 +635,208 @@ - product_id - product_id - N + disc1_1 + disc1_1 + Y - item_code - item_code + disc1_2 + disc1_2 Y - name - name + disc1_3 + disc1_3 Y - pricing_group - pricing_group + disc1_4 + disc1_4 Y - purchase_price - purchase_price + disc1_5 + disc1_5 Y - markup_std1 - markup_std1 + disc1_6 + disc1_6 Y - markup_std2 - markup_std2 + disc1_7 + disc1_7 Y - markup_std3 - markup_std3 + disc1_8 + disc1_8 Y - markup_std4 - markup_std4 + disc2_1 + disc2_1 Y - markup_std5 - markup_std5 + disc2_2 + disc2_2 + Y + + + disc2_3 + disc2_3 + Y + + + disc2_4 + disc2_4 + Y + + + disc2_5 + disc2_5 + Y + + + disc2_6 + disc2_6 + Y + + + disc2_7 + disc2_7 + Y + + + disc2_8 + disc2_8 + Y + + + disc3_1 + disc3_1 + Y + + + disc3_2 + disc3_2 + Y + + + disc3_3 + disc3_3 + Y + + + disc3_4 + disc3_4 + Y + + + disc3_5 + disc3_5 + Y + + + disc3_6 + disc3_6 + Y + + + disc3_7 + disc3_7 + Y + + + disc3_8 + disc3_8 + Y + + + disc4_1 + disc4_1 + Y + + + disc4_2 + disc4_2 + Y + + + disc4_3 + disc4_3 + Y + + + disc4_4 + disc4_4 + Y + + + disc4_5 + disc4_5 + Y + + + disc4_6 + disc4_6 + Y + + + disc4_7 + disc4_7 + Y + + + disc4_8 + disc4_8 + Y + + + disc5_1 + disc5_1 + Y + + + disc5_2 + disc5_2 + Y + + + disc5_3 + disc5_3 + Y + + + disc5_4 + disc5_4 + Y + + + disc5_5 + disc5_5 + Y + + + disc5_6 + disc5_6 + Y + + + disc5_7 + disc5_7 + Y + + + disc5_8 + disc5_8 + Y + + + item_code + item_code Y @@ -709,6 +864,61 @@ markup_group5 Y + + markup_group6 + markup_group6 + Y + + + markup_group7 + markup_group7 + Y + + + markup_group8 + markup_group8 + Y + + + markup_std1 + markup_std1 + Y + + + markup_std2 + markup_std2 + Y + + + markup_std3 + markup_std3 + Y + + + markup_std4 + markup_std4 + Y + + + markup_std5 + markup_std5 + Y + + + markup_std6 + markup_std6 + Y + + + markup_std7 + markup_std7 + Y + + + markup_std8 + markup_std8 + Y + markup_tier2_1 markup_tier2_1 @@ -734,6 +944,21 @@ markup_tier2_5 Y + + markup_tier2_6 + markup_tier2_6 + Y + + + markup_tier2_7 + markup_tier2_7 + Y + + + markup_tier2_8 + markup_tier2_8 + Y + markup_tier3_1 markup_tier3_1 @@ -759,6 +984,21 @@ markup_tier3_5 Y + + markup_tier3_6 + markup_tier3_6 + Y + + + markup_tier3_7 + markup_tier3_7 + Y + + + markup_tier3_8 + markup_tier3_8 + Y + markup_tier4_1 markup_tier4_1 @@ -784,6 +1024,21 @@ markup_tier4_5 Y + + markup_tier4_6 + markup_tier4_6 + Y + + + markup_tier4_7 + markup_tier4_7 + Y + + + markup_tier4_8 + markup_tier4_8 + Y + markup_tier5_1 markup_tier5_1 @@ -809,6 +1064,26 @@ markup_tier5_5 Y + + markup_tier5_6 + markup_tier5_6 + Y + + + markup_tier5_7 + markup_tier5_7 + Y + + + markup_tier5_8 + markup_tier5_8 + Y + + + name + name + Y + price_after_disc_1 price_after_disc_1 @@ -834,6 +1109,21 @@ price_after_disc_5 Y + + price_after_disc_6 + price_after_disc_6 + Y + + + price_after_disc_7 + price_after_disc_7 + Y + + + price_after_disc_8 + price_after_disc_8 + Y + price_before_disc1 price_before_disc1 @@ -859,6 +1149,21 @@ price_before_disc5 Y + + price_before_disc6 + price_before_disc6 + Y + + + price_before_disc7 + price_before_disc7 + Y + + + price_before_disc8 + price_before_disc8 + Y + price_tier2_1 price_tier2_1 @@ -884,6 +1189,21 @@ price_tier2_5 Y + + price_tier2_6 + price_tier2_6 + Y + + + price_tier2_7 + price_tier2_7 + Y + + + price_tier2_8 + price_tier2_8 + Y + price_tier3_1 price_tier3_1 @@ -909,6 +1229,21 @@ price_tier3_5 Y + + price_tier3_6 + price_tier3_6 + Y + + + price_tier3_7 + price_tier3_7 + Y + + + price_tier3_8 + price_tier3_8 + Y + price_tier4_1 price_tier4_1 @@ -925,225 +1260,365 @@ Y - price_tier4_4 - price_tier4_4 + price_tier4_4 + price_tier4_4 + Y + + + price_tier4_5 + price_tier4_5 + Y + + + price_tier4_6 + price_tier4_6 + Y + + + price_tier4_7 + price_tier4_7 + Y + + + price_tier4_8 + price_tier4_8 + 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 + + + price_tier5_6 + price_tier5_6 + Y + + + price_tier5_7 + price_tier5_7 + Y + + + price_tier5_8 + price_tier5_8 + Y + + + pricing_group + pricing_group + Y + + + product_id + product_id + N + + + purchase_price + purchase_price + Y + + + + + + + + + + + + 736 + 192 + Y + + + + Insert / update 2 + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + pricelist_compute
+ + product_id + product_id + = + + + + disc1_1 + zero + Y + + + disc1_2 + zero + Y + + + disc1_3 + zero + Y + + + disc1_4 + zero + Y + + + disc1_5 + zero + Y + + + disc1_6 + zero + Y + + + disc1_7 + zero + Y + + + disc1_8 + zero + Y + + + disc2_1 + zero + Y + + + disc2_2 + zero + Y + + + disc2_3 + zero + Y + + + disc2_4 + zero + Y + + + disc2_5 + zero Y - price_tier4_5 - price_tier4_5 + disc2_6 + zero Y - price_tier5_1 - price_tier5_1 + disc2_7 + zero Y - price_tier5_2 - price_tier5_2 + disc2_8 + zero Y - price_tier5_3 - price_tier5_3 + disc3_1 + zero Y - price_tier5_4 - price_tier5_4 + disc3_2 + zero Y - price_tier5_5 - price_tier5_5 + disc3_3 + zero Y - disc1_1 - disc1_1 + disc3_4 + zero Y - disc1_2 - disc1_2 + disc3_5 + zero Y - disc1_3 - disc1_3 + disc3_6 + zero Y - disc1_4 - disc1_4 + disc3_7 + zero Y - disc1_5 - disc1_5 + disc3_8 + zero Y - disc2_1 - disc2_1 + disc4_1 + zero Y - disc2_2 - disc2_2 + disc4_2 + zero Y - disc2_3 - disc2_3 + disc4_3 + zero Y - disc2_4 - disc2_4 + disc4_4 + zero Y - disc2_5 - disc2_5 + disc4_5 + zero Y - disc3_1 - disc3_1 + disc4_6 + zero Y - disc3_2 - disc3_2 + disc4_7 + zero Y - disc3_3 - disc3_3 + disc4_8 + zero Y - disc3_4 - disc3_4 + disc5_1 + zero Y - disc3_5 - disc3_5 + disc5_2 + zero Y - disc4_1 - disc4_1 + disc5_3 + zero Y - disc4_2 - disc4_2 + disc5_4 + zero Y - disc4_3 - disc4_3 + disc5_5 + zero Y - disc4_4 - disc4_4 + disc5_6 + zero Y - disc4_5 - disc4_5 + disc5_7 + zero Y - disc5_1 - disc5_1 + disc5_8 + zero Y - disc5_2 - disc5_2 + item_code + item_code Y - disc5_3 - disc5_3 + markup_group1 + zero Y - disc5_4 - disc5_4 + markup_group2 + zero Y - disc5_5 - disc5_5 + markup_group3 + zero Y - - - - - - - - - - - 736 - 192 - Y - - - - Insert / update 2 - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - 100 - N - - public - pricelist_compute
- - product_id - product_id - = - - - product_id - product_id - N + markup_group4 + zero + Y - item_code - item_code + markup_group5 + zero Y - name - name + markup_group6 + zero Y - pricing_group - pricing_group + markup_group7 + zero Y - purchase_price + markup_group8 zero Y @@ -1173,52 +1648,57 @@ Y - markup_group1 + markup_std6 zero Y - markup_group2 + markup_std7 zero Y - markup_group3 + markup_std8 zero Y - markup_group4 + markup_tier2_1 zero Y - markup_group5 + markup_tier2_2 zero Y - markup_tier2_1 + markup_tier2_3 zero Y - markup_tier2_2 + markup_tier2_4 zero Y - markup_tier2_3 + markup_tier2_5 zero Y - markup_tier2_4 + markup_tier2_6 zero Y - markup_tier2_5 + markup_tier2_7 + zero + Y + + + markup_tier2_8 zero Y @@ -1247,6 +1727,21 @@ zero Y + + markup_tier3_6 + zero + Y + + + markup_tier3_7 + zero + Y + + + markup_tier3_8 + zero + Y + markup_tier4_1 zero @@ -1273,302 +1768,317 @@ Y - markup_tier5_1 + markup_tier4_6 zero Y - markup_tier5_2 + markup_tier4_7 zero Y - markup_tier5_3 + markup_tier4_8 zero Y - markup_tier5_4 + markup_tier5_1 zero Y - markup_tier5_5 + markup_tier5_2 zero Y - price_after_disc_1 + markup_tier5_3 zero Y - price_after_disc_2 + markup_tier5_4 zero Y - price_after_disc_3 + markup_tier5_5 zero Y - price_after_disc_4 + markup_tier5_6 zero Y - price_after_disc_5 + markup_tier5_7 zero Y - price_before_disc1 + markup_tier5_8 zero Y - price_before_disc2 + name + name + Y + + + price_after_disc_1 zero Y - price_before_disc3 + price_after_disc_2 zero Y - price_before_disc4 + price_after_disc_3 zero Y - price_before_disc5 + price_after_disc_4 zero Y - price_tier2_1 + price_after_disc_5 zero Y - price_tier2_2 + price_after_disc_6 zero Y - price_tier2_3 + price_after_disc_7 zero Y - price_tier2_4 + price_after_disc_8 zero Y - price_tier2_5 + price_before_disc1 zero Y - price_tier3_1 + price_before_disc2 zero Y - price_tier3_2 + price_before_disc3 zero Y - price_tier3_3 + price_before_disc4 zero Y - price_tier3_4 + price_before_disc5 zero Y - price_tier3_5 + price_before_disc6 zero Y - price_tier4_1 + price_before_disc7 zero Y - price_tier4_2 + price_before_disc8 zero Y - price_tier4_3 + price_tier2_1 + zero + Y + + + price_tier2_2 zero Y - price_tier4_4 + price_tier2_3 zero Y - price_tier4_5 + price_tier2_4 zero Y - price_tier5_1 + price_tier2_5 zero Y - price_tier5_2 + price_tier2_6 zero Y - price_tier5_3 + price_tier2_7 zero Y - price_tier5_4 + price_tier2_8 zero Y - price_tier5_5 + price_tier3_1 zero Y - disc1_1 + price_tier3_2 zero Y - disc1_2 + price_tier3_3 zero Y - disc1_3 + price_tier3_4 zero Y - disc1_4 + price_tier3_5 zero Y - disc1_5 + price_tier3_6 zero Y - disc2_1 + price_tier3_7 zero Y - disc2_2 + price_tier3_8 zero Y - disc2_3 + price_tier4_1 zero Y - disc2_4 + price_tier4_2 zero Y - disc2_5 + price_tier4_3 zero Y - disc3_1 + price_tier4_4 zero Y - disc3_2 + price_tier4_5 zero Y - disc3_3 + price_tier4_6 zero Y - disc3_4 + price_tier4_7 zero Y - disc3_5 + price_tier4_8 zero Y - disc4_1 + price_tier5_1 zero Y - disc4_2 + price_tier5_2 zero Y - disc4_3 + price_tier5_3 zero Y - disc4_4 + price_tier5_4 zero Y - disc4_5 + price_tier5_5 zero Y - disc5_1 + price_tier5_6 zero Y - disc5_2 + price_tier5_7 zero Y - disc5_3 + price_tier5_8 zero Y - disc5_4 - zero + pricing_group + pricing_group Y - disc5_5 + product_id + product_id + N + + + purchase_price zero Y @@ -2577,6 +3087,51 @@ left join brand b on b.id = p.brand_id + + diff1_6 + SUBTRACT + price_before_disc6 + price_after_disc_6 + + None + -1 + -1 + N + + + + + + + diff1_7 + SUBTRACT + price_before_disc7 + price_after_disc7 + + None + -1 + -1 + N + + + + + + + diff1_8 + SUBTRACT + price_before_disc8 + price_after_disc8 + + None + -1 + -1 + N + + + + + diff2_1 SUBTRACT @@ -2652,6 +3207,51 @@ left join brand b on b.id = p.brand_id + + 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 @@ -2668,10 +3268,145 @@ left join brand b on b.id = p.brand_id - diff3_2 + 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_disc2 - price_tier3_2 + price_before_disc3 + price_tier4_3 None -1 @@ -2683,10 +3418,10 @@ left join brand b on b.id = p.brand_id - diff3_3 + diff4_4 SUBTRACT - price_before_disc3 - price_tier3_3 + price_before_disc4 + price_tier4_4 None -1 @@ -2698,10 +3433,10 @@ left join brand b on b.id = p.brand_id - diff3_4 + diff4_5 SUBTRACT - price_before_disc4 - price_tier3_4 + price_before_disc5 + price_tier4_5 None -1 @@ -2713,10 +3448,10 @@ left join brand b on b.id = p.brand_id - diff3_5 + diff4_6 SUBTRACT - price_before_disc5 - price_tier3_5 + price_before_disc6 + price_tier4_6 None -1 @@ -2728,10 +3463,10 @@ left join brand b on b.id = p.brand_id - diff4_1 + diff4_7 SUBTRACT - price_before_disc1 - price_tier4_1 + price_before_disc7 + price_tier4_7 None -1 @@ -2743,10 +3478,10 @@ left join brand b on b.id = p.brand_id - diff4_2 + diff4_8 SUBTRACT - price_before_disc2 - price_tier4_2 + price_before_disc8 + price_tier4_8 None -1 @@ -2758,10 +3493,10 @@ left join brand b on b.id = p.brand_id - diff4_3 + diff5_1 SUBTRACT - price_before_disc3 - price_tier4_3 + price_before_disc1 + price_tier5_1 None -1 @@ -2773,10 +3508,10 @@ left join brand b on b.id = p.brand_id - diff4_4 + diff5_2 SUBTRACT - price_before_disc4 - price_tier4_4 + price_before_disc2 + price_tier5_2 None -1 @@ -2788,10 +3523,10 @@ left join brand b on b.id = p.brand_id - diff4_5 + diff5_3 SUBTRACT - price_before_disc5 - price_tier4_5 + price_before_disc3 + price_tier5_3 None -1 @@ -2803,10 +3538,10 @@ left join brand b on b.id = p.brand_id - diff5_1 + diff5_4 SUBTRACT - price_before_disc1 - price_tier5_1 + price_before_disc4 + price_tier5_4 None -1 @@ -2818,10 +3553,10 @@ left join brand b on b.id = p.brand_id - diff5_2 + diff5_5 SUBTRACT - price_before_disc2 - price_tier5_2 + price_before_disc5 + price_tier5_5 None -1 @@ -2833,10 +3568,10 @@ left join brand b on b.id = p.brand_id - diff5_3 + diff5_6 SUBTRACT - price_before_disc3 - price_tier5_3 + price_before_disc6 + price_tier5_6 None -1 @@ -2848,10 +3583,10 @@ left join brand b on b.id = p.brand_id - diff5_4 + diff5_7 SUBTRACT - price_before_disc4 - price_tier5_4 + price_before_disc7 + price_tier5_7 None -1 @@ -2863,10 +3598,10 @@ left join brand b on b.id = p.brand_id - diff5_5 + diff5_8 SUBTRACT - price_before_disc5 - price_tier5_5 + price_before_disc8 + price_tier5_8 None -1 @@ -2978,6 +3713,51 @@ left join brand b on b.id = p.brand_id + + 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 @@ -3053,6 +3833,51 @@ left join brand b on b.id = p.brand_id + + 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 @@ -3128,6 +3953,51 @@ left join brand b on b.id = p.brand_id + + 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 @@ -3191,8 +4061,98 @@ left join brand b on b.id = p.brand_id disc4_5 PERCENT_1 - diff4_5 - price_before_disc5 + 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 @@ -3204,10 +4164,10 @@ left join brand b on b.id = p.brand_id - disc5_1 + disc5_4 PERCENT_1 - diff5_1 - price_before_disc1 + diff5_4 + price_before_disc4 Number -1 @@ -3219,10 +4179,10 @@ left join brand b on b.id = p.brand_id - disc5_2 + disc5_5 PERCENT_1 - diff5_2 - price_before_disc2 + diff5_5 + price_before_disc5 Number -1 @@ -3234,10 +4194,10 @@ left join brand b on b.id = p.brand_id - disc5_3 + disc5_6 PERCENT_1 - diff5_3 - price_before_disc3 + diff5_6 + price_before_disc6 Number -1 @@ -3249,10 +4209,10 @@ left join brand b on b.id = p.brand_id - disc5_4 + disc5_7 PERCENT_1 - diff5_4 - price_before_disc4 + diff5_7 + price_before_disc7 Number -1 @@ -3264,10 +4224,10 @@ left join brand b on b.id = p.brand_id - disc5_5 + disc5_8 PERCENT_1 - diff5_5 - price_before_disc5 + diff5_8 + price_before_disc8 Number -1 @@ -3379,6 +4339,51 @@ left join brand b on b.id = p.brand_id + + 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 + + + + + @@ -3480,6 +4485,51 @@ left join brand b on b.id = p.brand_id + + price_before_disc6 + PERCENT_3 + price_after_disc_6 + markup_group6 + + Number + -1 + -1 + N + + + + + + + price_before_disc7 + PERCENT_3 + price_after_disc_7 + markup_group7 + + Number + -1 + -1 + N + + + + + + + price_before_disc8 + PERCENT_3 + price_after_disc_8 + markup_group8 + + Number + -1 + -1 + N + + + + + price_tier2_1 PERCENT_3 @@ -3555,6 +4605,51 @@ left join brand b on b.id = p.brand_id + + 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 @@ -3630,6 +4725,51 @@ left join brand b on b.id = p.brand_id + + 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 @@ -3705,6 +4845,51 @@ left join brand b on b.id = p.brand_id + + 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 @@ -3780,6 +4965,51 @@ left join brand b on b.id = p.brand_id + + 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 + + + + + -- cgit v1.2.3