From 21cbbf984faf05679bbc73af50d3e02a7128800b Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Sat, 31 Jan 2026 10:28:12 +0700 Subject: bf error diff2_10 on calculation --- update_override_vendor_pricelist.ktr | 3146 +++++++++++++++++----------------- 1 file changed, 1573 insertions(+), 1573 deletions(-) (limited to 'update_override_vendor_pricelist.ktr') diff --git a/update_override_vendor_pricelist.ktr b/update_override_vendor_pricelist.ktr index 6264815..d08bc52 100644 --- a/update_override_vendor_pricelist.ktr +++ b/update_override_vendor_pricelist.ktr @@ -1914,785 +1914,8 @@ where b.purchase_price_exist = 'Y' - filter override vendor purchase price = 0 - WriteToLog - - Y - - 1 - - none - - - log_level_basic - Y - N - 0 - - - - - - - - - - - - - 352 - 256 - Y - - - - update purchase pricelist override vendor - Update - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - N - 100 - N - N - - - public - pricelist_compute
- - product_id - product_id - = - - - - item_code - item_code - - - name - name - - - pricing_group - pricing_group - - - purchase_price - purchase_price - - - vendor - vendor - - - markup_std1 - markup_std1 - - - markup_std2 - markup_std2 - - - markup_std3 - markup_std3 - - - markup_std4 - markup_std4 - - - markup_std5 - markup_std5 - - - markup_std6 - markup_std6 - - - markup_std7 - markup_std7 - - - markup_std8 - markup_std8 - - - markup_std9 - markup_std9 - - - markup_std10 - markup_std10 - - - markup_group1 - markup_group1 - - - markup_group2 - markup_group2 - - - markup_group3 - markup_group3 - - - markup_group4 - markup_group4 - - - markup_group5 - markup_group5 - - - markup_group6 - markup_group6 - - - markup_group7 - markup_group7 - - - markup_group8 - markup_group8 - - - markup_group9 - markup_group9 - - - markup_group10 - markup_group10 - - - markup_tier2_1 - markup_tier2_1 - - - markup_tier2_2 - markup_tier2_2 - - - markup_tier2_3 - markup_tier2_3 - - - markup_tier2_4 - markup_tier2_4 - - - markup_tier2_5 - markup_tier2_5 - - - markup_tier2_6 - markup_tier2_6 - - - markup_tier2_7 - markup_tier2_7 - - - markup_tier2_8 - markup_tier2_8 - - - markup_tier2_9 - markup_tier2_9 - - - markup_tier2_10 - markup_tier2_10 - - - markup_tier3_1 - markup_tier3_1 - - - markup_tier3_2 - markup_tier3_2 - - - markup_tier3_3 - markup_tier3_3 - - - markup_tier3_4 - markup_tier3_4 - - - markup_tier3_5 - markup_tier3_5 - - - markup_tier3_6 - markup_tier3_6 - - - markup_tier3_7 - markup_tier3_7 - - - markup_tier3_8 - markup_tier3_8 - - - markup_tier3_9 - markup_tier3_9 - - - markup_tier3_10 - markup_tier3_10 - - - markup_tier4_1 - markup_tier4_1 - - - markup_tier4_2 - markup_tier4_2 - - - markup_tier4_3 - markup_tier4_3 - - - markup_tier4_4 - markup_tier4_4 - - - markup_tier4_5 - markup_tier4_5 - - - markup_tier4_6 - markup_tier4_6 - - - markup_tier4_7 - markup_tier4_7 - - - markup_tier4_8 - markup_tier4_8 - - - markup_tier4_9 - markup_tier4_9 - - - markup_tier4_10 - markup_tier4_10 - - - markup_tier5_1 - markup_tier5_1 - - - markup_tier5_2 - markup_tier5_2 - - - markup_tier5_3 - markup_tier5_3 - - - markup_tier5_4 - markup_tier5_4 - - - markup_tier5_5 - markup_tier5_5 - - - markup_tier5_6 - markup_tier5_6 - - - markup_tier5_7 - markup_tier5_7 - - - markup_tier5_8 - markup_tier5_8 - - - markup_tier5_9 - markup_tier5_9 - - - markup_tier5_10 - markup_tier5_10 - - - price_before_disc1 - price_before_disc1 - - - price_before_disc2 - price_before_disc2 - - - price_before_disc3 - price_before_disc3 - - - price_before_disc4 - price_before_disc4 - - - price_before_disc5 - price_before_disc5 - - - price_before_disc6 - price_before_disc6 - - - price_before_disc7 - price_before_disc7 - - - 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 - - - price_after_disc_2 - price_after_disc_2 - - - price_after_disc_3 - price_after_disc_3 - - - price_after_disc_4 - price_after_disc_4 - - - price_after_disc_5 - price_after_disc_5 - - - price_after_disc_6 - price_after_disc_6 - - - price_after_disc_7 - price_after_disc_7 - - - 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 - - - price_tier2_2 - price_tier2_2 - - - price_tier2_3 - price_tier2_3 - - - price_tier2_4 - price_tier2_4 - - - price_tier2_5 - price_tier2_5 - - - price_tier2_6 - price_tier2_6 - - - price_tier2_7 - price_tier2_7 - - - price_tier2_8 - price_tier2_8 - - - price_tier2_9 - price_tier2_9 - - - price_tier2_10 - price_tier2_10 - - - price_tier3_1 - price_tier3_1 - - - price_tier3_2 - price_tier3_2 - - - price_tier3_3 - price_tier3_3 - - - price_tier3_4 - price_tier3_4 - - - price_tier3_5 - price_tier3_5 - - - price_tier3_6 - price_tier3_6 - - - price_tier3_7 - price_tier3_7 - - - price_tier3_8 - price_tier3_8 - - - price_tier3_9 - price_tier3_9 - - - price_tier3_10 - price_tier3_10 - - - price_tier4_1 - price_tier4_1 - - - price_tier4_2 - price_tier4_2 - - - price_tier4_3 - price_tier4_3 - - - price_tier4_4 - price_tier4_4 - - - price_tier4_5 - price_tier4_5 - - - price_tier4_6 - price_tier4_6 - - - price_tier4_7 - price_tier4_7 - - - price_tier4_8 - price_tier4_8 - - - price_tier4_9 - price_tier4_9 - - - price_tier4_10 - price_tier4_10 - - - price_tier5_1 - price_tier5_1 - - - price_tier5_2 - price_tier5_2 - - - price_tier5_3 - price_tier5_3 - - - price_tier5_4 - price_tier5_4 - - - price_tier5_5 - price_tier5_5 - - - price_tier5_6 - price_tier5_6 - - - price_tier5_7 - price_tier5_7 - - - price_tier5_8 - price_tier5_8 - - - price_tier5_9 - price_tier5_9 - - - price_tier5_10 - price_tier5_10 - - - disc1_1 - disc1_1 - - - disc1_2 - disc1_2 - - - disc1_3 - disc1_3 - - - disc1_4 - disc1_4 - - - disc1_5 - disc1_5 - - - disc1_6 - disc1_6 - - - disc1_7 - disc1_7 - - - disc1_8 - disc1_8 - - - disc1_9 - disc1_9 - - - disc1_10 - disc1_10 - - - disc2_1 - disc2_1 - - - disc2_2 - disc2_2 - - - disc2_3 - disc2_3 - - - disc2_4 - disc2_4 - - - disc2_5 - disc2_5 - - - disc2_6 - disc2_6 - - - disc2_7 - disc2_7 - - - disc2_8 - disc2_8 - - - disc2_9 - disc2_9 - - - disc2_10 - disc2_10 - - - disc3_1 - disc3_1 - - - disc3_2 - disc3_2 - - - disc3_3 - disc3_3 - - - disc3_4 - disc3_4 - - - disc3_5 - disc3_5 - - - disc3_6 - disc3_6 - - - disc3_7 - disc3_7 - - - disc3_8 - disc3_8 - - - disc3_9 - disc3_9 - - - disc3_10 - disc3_10 - - - disc4_1 - disc4_1 - - - disc4_2 - disc4_2 - - - disc4_3 - disc4_3 - - - disc4_4 - disc4_4 - - - disc4_5 - disc4_5 - - - disc4_6 - disc4_6 - - - disc4_7 - disc4_7 - - - disc4_8 - disc4_8 - - - disc4_9 - disc4_9 - - - disc4_10 - disc4_10 - - - disc5_1 - disc5_1 - - - disc5_2 - disc5_2 - - - disc5_3 - disc5_3 - - - disc5_4 - disc5_4 - - - disc5_5 - disc5_5 - - - disc5_6 - disc5_6 - - - disc5_7 - disc5_7 - - - disc5_8 - disc5_8 - - - disc5_9 - disc5_9 - - - disc5_10 - disc5_10 - - - vendor_id - vendor_id - - - - - - - - - - - - 1168 - 352 - Y - - - - calculate price tier override vendor - Calculator + calculate diff override vendor + Calculator Y @@ -2703,12 +1926,12 @@ where b.purchase_price_exist = 'Y' Y - price_before_disc1 - PERCENT_3 - purchase_price - markup_group1 + diff1_1 + SUBTRACT + price_before_disc1 + price_after_disc_1 - Number + None -1 -1 N @@ -2718,12 +1941,12 @@ where b.purchase_price_exist = 'Y' - price_before_disc2 - PERCENT_3 - purchase_price - markup_group2 + diff1_10 + SUBTRACT + price_before_disc10 + price_after_disc_10 - Number + None -1 -1 N @@ -2733,12 +1956,12 @@ where b.purchase_price_exist = 'Y' - price_before_disc3 - PERCENT_3 - purchase_price - markup_group3 + diff1_2 + SUBTRACT + price_before_disc2 + price_after_disc_2 - Number + None -1 -1 N @@ -2748,12 +1971,12 @@ where b.purchase_price_exist = 'Y' - price_before_disc4 - PERCENT_3 - purchase_price - markup_group4 + diff1_3 + SUBTRACT + price_before_disc3 + price_after_disc_3 - Number + None -1 -1 N @@ -2763,12 +1986,12 @@ where b.purchase_price_exist = 'Y' - price_before_disc5 - PERCENT_3 - purchase_price - markup_group5 + diff1_4 + SUBTRACT + price_before_disc4 + price_after_disc_4 - Number + None -1 -1 N @@ -2778,12 +2001,12 @@ where b.purchase_price_exist = 'Y' - price_before_disc6 - PERCENT_3 - purchase_price - markup_group6 + diff1_5 + SUBTRACT + price_before_disc5 + price_after_disc_5 - Number + None -1 -1 N @@ -2793,12 +2016,12 @@ where b.purchase_price_exist = 'Y' - price_before_disc7 - PERCENT_3 - purchase_price - markup_group7 + diff1_6 + SUBTRACT + price_before_disc6 + price_after_disc_6 - Number + None -1 -1 N @@ -2808,12 +2031,12 @@ where b.purchase_price_exist = 'Y' - price_before_disc8 - PERCENT_3 - purchase_price - markup_group8 + diff1_7 + SUBTRACT + price_before_disc7 + price_after_disc_7 - Number + None -1 -1 N @@ -2823,12 +2046,12 @@ where b.purchase_price_exist = 'Y' - price_before_disc9 - PERCENT_3 - purchase_price - markup_group9 + diff1_8 + SUBTRACT + price_before_disc8 + price_after_disc_8 - Number + None -1 -1 N @@ -2838,12 +2061,12 @@ where b.purchase_price_exist = 'Y' - price_before_disc10 - PERCENT_3 - purchase_price - markup_group10 + diff1_9 + SUBTRACT + price_before_disc9 + price_after_disc_9 - Number + None -1 -1 N @@ -2853,12 +2076,12 @@ where b.purchase_price_exist = 'Y' - price_after_disc_1 - PERCENT_3 - purchase_price - markup_std1 + diff2_1 + SUBTRACT + price_before_disc1 + price_tier2_1 - Number + None -1 -1 N @@ -2868,12 +2091,12 @@ where b.purchase_price_exist = 'Y' - price_after_disc_2 - PERCENT_3 - purchase_price - markup_std2 + diff2_2 + SUBTRACT + price_before_disc2 + price_tier2_2 - Number + None -1 -1 N @@ -2883,12 +2106,12 @@ where b.purchase_price_exist = 'Y' - price_after_disc_3 - PERCENT_3 - purchase_price - markup_std3 + diff2_3 + SUBTRACT + price_before_disc3 + price_tier2_3 - Number + None -1 -1 N @@ -2898,12 +2121,12 @@ where b.purchase_price_exist = 'Y' - price_after_disc_4 - PERCENT_3 - purchase_price - markup_std4 + diff2_4 + SUBTRACT + price_before_disc4 + price_tier2_4 - Number + None -1 -1 N @@ -2913,12 +2136,12 @@ where b.purchase_price_exist = 'Y' - price_after_disc_5 - PERCENT_3 - purchase_price - markup_std5 + diff2_5 + SUBTRACT + price_before_disc5 + price_tier2_5 - Number + None -1 -1 N @@ -2928,12 +2151,12 @@ where b.purchase_price_exist = 'Y' - price_after_disc_6 - PERCENT_3 - purchase_price - markup_std6 + diff2_6 + SUBTRACT + price_before_disc6 + price_tier2_6 - Number + None -1 -1 N @@ -2943,12 +2166,12 @@ where b.purchase_price_exist = 'Y' - price_after_disc_7 - PERCENT_3 - purchase_price - markup_std7 + diff2_7 + SUBTRACT + price_before_disc7 + price_tier2_7 - Number + None -1 -1 N @@ -2958,12 +2181,12 @@ where b.purchase_price_exist = 'Y' - price_after_disc_8 - PERCENT_3 - purchase_price - markup_std8 + diff2_8 + SUBTRACT + price_before_disc8 + price_tier2_8 - Number + None -1 -1 N @@ -2973,12 +2196,12 @@ where b.purchase_price_exist = 'Y' - price_after_disc_9 - PERCENT_3 - purchase_price - markup_std9 + diff2_9 + SUBTRACT + price_before_disc9 + price_tier2_9 - Number + None -1 -1 N @@ -2988,12 +2211,12 @@ where b.purchase_price_exist = 'Y' - price_after_disc_10 - PERCENT_3 - purchase_price - markup_std10 + diff3_1 + SUBTRACT + price_before_disc1 + price_tier3_1 - Number + None -1 -1 N @@ -3003,12 +2226,12 @@ where b.purchase_price_exist = 'Y' - price_tier2_1 - PERCENT_3 - purchase_price - markup_tier2_1 + diff2_10 + SUBTRACT + price_before_disc10 + price_tier2_10 - Number + None -1 -1 N @@ -3018,12 +2241,12 @@ where b.purchase_price_exist = 'Y' - price_tier2_2 - PERCENT_3 - purchase_price - markup_tier2_2 + diff3_10 + SUBTRACT + price_before_disc10 + price_tier3_10 - Number + None -1 -1 N @@ -3033,12 +2256,12 @@ where b.purchase_price_exist = 'Y' - price_tier2_3 - PERCENT_3 - purchase_price - markup_tier2_3 + diff3_2 + SUBTRACT + price_before_disc2 + price_tier3_2 - Number + None -1 -1 N @@ -3048,12 +2271,12 @@ where b.purchase_price_exist = 'Y' - price_tier2_4 - PERCENT_3 - purchase_price - markup_tier2_4 + diff3_3 + SUBTRACT + price_before_disc3 + price_tier3_3 - Number + None -1 -1 N @@ -3063,12 +2286,12 @@ where b.purchase_price_exist = 'Y' - price_tier2_5 - PERCENT_3 - purchase_price - markup_tier2_5 + diff3_4 + SUBTRACT + price_before_disc4 + price_tier3_4 - Number + None -1 -1 N @@ -3078,12 +2301,12 @@ where b.purchase_price_exist = 'Y' - price_tier2_6 - PERCENT_3 - purchase_price - markup_tier2_6 + diff3_5 + SUBTRACT + price_before_disc5 + price_tier3_5 - Number + None -1 -1 N @@ -3093,12 +2316,12 @@ where b.purchase_price_exist = 'Y' - price_tier2_7 - PERCENT_3 - purchase_price - markup_tier2_7 + diff3_6 + SUBTRACT + price_before_disc6 + price_tier3_6 - Number + None -1 -1 N @@ -3108,12 +2331,12 @@ where b.purchase_price_exist = 'Y' - price_tier2_8 - PERCENT_3 - purchase_price - markup_tier2_8 + diff3_7 + SUBTRACT + price_before_disc7 + price_tier3_7 - Number + None -1 -1 N @@ -3123,12 +2346,12 @@ where b.purchase_price_exist = 'Y' - price_tier2_9 - PERCENT_3 - purchase_price - markup_tier2_9 + diff3_8 + SUBTRACT + price_before_disc8 + price_tier3_8 - Number + None -1 -1 N @@ -3138,12 +2361,12 @@ where b.purchase_price_exist = 'Y' - price_tier2_10 - PERCENT_3 - purchase_price - markup_tier2_10 + diff3_9 + SUBTRACT + price_before_disc9 + price_tier3_9 - Number + None -1 -1 N @@ -3153,12 +2376,12 @@ where b.purchase_price_exist = 'Y' - price_tier3_1 - PERCENT_3 - purchase_price - markup_tier3_1 + diff4_1 + SUBTRACT + price_before_disc1 + price_tier4_1 - Number + None -1 -1 N @@ -3168,12 +2391,12 @@ where b.purchase_price_exist = 'Y' - price_tier3_2 - PERCENT_3 - purchase_price - markup_tier3_2 + diff4_10 + SUBTRACT + price_before_disc10 + price_tier4_10 - Number + None -1 -1 N @@ -3183,12 +2406,12 @@ where b.purchase_price_exist = 'Y' - price_tier3_3 - PERCENT_3 - purchase_price - markup_tier3_3 + diff4_2 + SUBTRACT + price_before_disc2 + price_tier4_2 - Number + None -1 -1 N @@ -3198,12 +2421,12 @@ where b.purchase_price_exist = 'Y' - price_tier3_4 - PERCENT_3 - purchase_price - markup_tier3_4 + diff4_3 + SUBTRACT + price_before_disc3 + price_tier4_3 - Number + None -1 -1 N @@ -3213,12 +2436,12 @@ where b.purchase_price_exist = 'Y' - price_tier3_5 - PERCENT_3 - purchase_price - markup_tier3_5 + diff4_4 + SUBTRACT + price_before_disc4 + price_tier4_4 - Number + None -1 -1 N @@ -3228,12 +2451,12 @@ where b.purchase_price_exist = 'Y' - price_tier3_6 - PERCENT_3 - purchase_price - markup_tier3_6 + diff4_5 + SUBTRACT + price_before_disc5 + price_tier4_5 - Number + None -1 -1 N @@ -3243,12 +2466,12 @@ where b.purchase_price_exist = 'Y' - price_tier3_7 - PERCENT_3 - purchase_price - markup_tier3_7 + diff4_6 + SUBTRACT + price_before_disc6 + price_tier4_6 - Number + None -1 -1 N @@ -3258,12 +2481,12 @@ where b.purchase_price_exist = 'Y' - price_tier3_8 - PERCENT_3 - purchase_price - markup_tier3_8 + diff4_7 + SUBTRACT + price_before_disc7 + price_tier4_7 - Number + None -1 -1 N @@ -3273,12 +2496,12 @@ where b.purchase_price_exist = 'Y' - price_tier3_9 - PERCENT_3 - purchase_price - markup_tier3_9 + diff4_8 + SUBTRACT + price_before_disc8 + price_tier4_8 - Number + None -1 -1 N @@ -3288,12 +2511,12 @@ where b.purchase_price_exist = 'Y' - price_tier3_10 - PERCENT_3 - purchase_price - markup_tier3_10 + diff4_9 + SUBTRACT + price_before_disc9 + price_tier4_9 - Number + None -1 -1 N @@ -3303,12 +2526,12 @@ where b.purchase_price_exist = 'Y' - price_tier4_1 - PERCENT_3 - purchase_price - markup_tier4_1 + diff5_1 + SUBTRACT + price_before_disc1 + price_tier5_1 - Number + None -1 -1 N @@ -3318,12 +2541,12 @@ where b.purchase_price_exist = 'Y' - price_tier4_2 - PERCENT_3 - purchase_price - markup_tier4_2 + diff5_10 + SUBTRACT + price_before_disc10 + price_tier5_10 - Number + None -1 -1 N @@ -3333,12 +2556,12 @@ where b.purchase_price_exist = 'Y' - price_tier4_3 - PERCENT_3 - purchase_price - markup_tier4_3 + diff5_2 + SUBTRACT + price_before_disc2 + price_tier5_2 - Number + None -1 -1 N @@ -3348,12 +2571,12 @@ where b.purchase_price_exist = 'Y' - price_tier4_4 - PERCENT_3 - purchase_price - markup_tier4_4 + diff5_3 + SUBTRACT + price_before_disc3 + price_tier5_3 - Number + None -1 -1 N @@ -3363,12 +2586,12 @@ where b.purchase_price_exist = 'Y' - price_tier4_5 - PERCENT_3 - purchase_price - markup_tier4_5 + diff5_4 + SUBTRACT + price_before_disc4 + price_tier5_4 - Number + None -1 -1 N @@ -3378,12 +2601,12 @@ where b.purchase_price_exist = 'Y' - price_tier4_6 - PERCENT_3 - purchase_price - markup_tier4_6 + diff5_5 + SUBTRACT + price_before_disc5 + price_tier5_5 - Number + None -1 -1 N @@ -3393,12 +2616,12 @@ where b.purchase_price_exist = 'Y' - price_tier4_7 - PERCENT_3 - purchase_price - markup_tier4_7 + diff5_6 + SUBTRACT + price_before_disc6 + price_tier5_6 - Number + None -1 -1 N @@ -3408,12 +2631,12 @@ where b.purchase_price_exist = 'Y' - price_tier4_8 - PERCENT_3 - purchase_price - markup_tier4_8 + diff5_7 + SUBTRACT + price_before_disc7 + price_tier5_7 - Number + None -1 -1 N @@ -3423,12 +2646,12 @@ where b.purchase_price_exist = 'Y' - price_tier4_9 - PERCENT_3 - purchase_price - markup_tier4_9 + diff5_8 + SUBTRACT + price_before_disc8 + price_tier5_8 - Number + None -1 -1 N @@ -3438,12 +2661,12 @@ where b.purchase_price_exist = 'Y' - price_tier4_10 - PERCENT_3 - purchase_price - markup_tier4_10 + diff5_9 + SUBTRACT + price_before_disc9 + price_tier5_9 - Number + None -1 -1 N @@ -3452,11 +2675,37 @@ where b.purchase_price_exist = 'Y' + + + + + + + + + + 576 + 352 + Y + + + + calculate discount override vendor + Calculator + + Y + + 1 + + none + + + Y - price_tier5_1 - PERCENT_3 - purchase_price - markup_tier5_1 + disc1_1 + PERCENT_1 + diff1_1 + price_before_disc1 Number -1 @@ -3468,10 +2717,10 @@ where b.purchase_price_exist = 'Y' - price_tier5_2 - PERCENT_3 - purchase_price - markup_tier5_2 + disc1_2 + PERCENT_1 + diff1_2 + price_before_disc2 Number -1 @@ -3483,10 +2732,10 @@ where b.purchase_price_exist = 'Y' - price_tier5_3 - PERCENT_3 - purchase_price - markup_tier5_3 + disc1_3 + PERCENT_1 + diff1_3 + price_before_disc3 Number -1 @@ -3498,10 +2747,10 @@ where b.purchase_price_exist = 'Y' - price_tier5_4 - PERCENT_3 - purchase_price - markup_tier5_4 + disc1_4 + PERCENT_1 + diff1_4 + price_before_disc4 Number -1 @@ -3513,10 +2762,10 @@ where b.purchase_price_exist = 'Y' - price_tier5_5 - PERCENT_3 - purchase_price - markup_tier5_5 + disc1_5 + PERCENT_1 + diff1_5 + price_before_disc5 Number -1 @@ -3528,10 +2777,10 @@ where b.purchase_price_exist = 'Y' - price_tier5_6 - PERCENT_3 - purchase_price - markup_tier5_6 + disc1_6 + PERCENT_1 + diff1_6 + price_before_disc6 Number -1 @@ -3543,10 +2792,10 @@ where b.purchase_price_exist = 'Y' - price_tier5_7 - PERCENT_3 - purchase_price - markup_tier5_7 + disc1_7 + PERCENT_1 + diff1_7 + price_before_disc7 Number -1 @@ -3558,10 +2807,10 @@ where b.purchase_price_exist = 'Y' - price_tier5_8 - PERCENT_3 - purchase_price - markup_tier5_8 + disc1_8 + PERCENT_1 + diff1_8 + price_before_disc8 Number -1 @@ -3573,10 +2822,10 @@ where b.purchase_price_exist = 'Y' - price_tier5_9 - PERCENT_3 - purchase_price - markup_tier5_9 + disc1_9 + PERCENT_1 + diff1_9 + price_before_disc9 Number -1 @@ -3588,10 +2837,10 @@ where b.purchase_price_exist = 'Y' - price_tier5_10 - PERCENT_3 - purchase_price - markup_tier5_10 + disc1_10 + PERCENT_1 + diff1_10 + price_before_disc10 Number -1 @@ -3602,39 +2851,13 @@ where b.purchase_price_exist = 'Y' - - - - - - - - - - 576 - 128 - Y - - - - calculate diff override vendor - Calculator - - Y - - 1 - - none - - - Y - diff1_1 - SUBTRACT - price_before_disc1 - price_after_disc_1 + disc2_1 + PERCENT_1 + diff2_1 + price_before_disc1 - None + Number -1 -1 N @@ -3644,12 +2867,12 @@ where b.purchase_price_exist = 'Y' - diff1_2 - SUBTRACT - price_before_disc2 - price_after_disc_2 + disc2_2 + PERCENT_1 + diff2_2 + price_before_disc2 - None + Number -1 -1 N @@ -3659,12 +2882,12 @@ where b.purchase_price_exist = 'Y' - diff1_3 - SUBTRACT - price_before_disc3 - price_after_disc_3 + disc2_3 + PERCENT_1 + diff2_3 + price_before_disc3 - None + Number -1 -1 N @@ -3674,12 +2897,12 @@ where b.purchase_price_exist = 'Y' - diff1_4 - SUBTRACT - price_before_disc4 - price_after_disc_4 + disc2_4 + PERCENT_1 + diff2_4 + price_before_disc4 - None + Number -1 -1 N @@ -3689,12 +2912,12 @@ where b.purchase_price_exist = 'Y' - diff1_5 - SUBTRACT - price_before_disc5 - price_after_disc_5 + disc2_5 + PERCENT_1 + diff2_5 + price_before_disc5 - None + Number -1 -1 N @@ -3704,12 +2927,12 @@ where b.purchase_price_exist = 'Y' - diff1_6 - SUBTRACT - price_before_disc6 - price_after_disc_6 + disc2_6 + PERCENT_1 + diff2_6 + price_before_disc6 - None + Number -1 -1 N @@ -3719,12 +2942,12 @@ where b.purchase_price_exist = 'Y' - diff1_7 - SUBTRACT - price_before_disc7 - price_after_disc_7 + disc2_7 + PERCENT_1 + diff2_7 + price_before_disc7 - None + Number -1 -1 N @@ -3734,12 +2957,12 @@ where b.purchase_price_exist = 'Y' - diff1_8 - SUBTRACT - price_before_disc8 - price_after_disc_8 + disc2_8 + PERCENT_1 + diff2_8 + price_before_disc8 - None + Number -1 -1 N @@ -3749,12 +2972,12 @@ where b.purchase_price_exist = 'Y' - diff1_9 - SUBTRACT - price_before_disc9 - price_after_disc_9 + disc2_9 + PERCENT_1 + diff2_9 + price_before_disc9 - None + Number -1 -1 N @@ -3764,12 +2987,12 @@ where b.purchase_price_exist = 'Y' - diff1_10 - SUBTRACT - price_before_disc10 - price_after_disc_10 + disc2_10 + PERCENT_1 + diff2_10 + price_before_disc10 - None + Number -1 -1 N @@ -3779,12 +3002,12 @@ where b.purchase_price_exist = 'Y' - diff2_1 - SUBTRACT - price_before_disc1 - price_tier2_1 + disc3_1 + PERCENT_1 + diff3_1 + price_before_disc1 - None + Number -1 -1 N @@ -3794,12 +3017,12 @@ where b.purchase_price_exist = 'Y' - diff2_2 - SUBTRACT - price_before_disc2 - price_tier2_2 + disc3_2 + PERCENT_1 + diff3_2 + price_before_disc2 - None + Number -1 -1 N @@ -3809,12 +3032,12 @@ where b.purchase_price_exist = 'Y' - diff2_3 - SUBTRACT - price_before_disc3 - price_tier2_3 + disc3_3 + PERCENT_1 + diff3_3 + price_before_disc3 - None + Number -1 -1 N @@ -3824,12 +3047,12 @@ where b.purchase_price_exist = 'Y' - diff2_4 - SUBTRACT - price_before_disc4 - price_tier2_4 + disc3_4 + PERCENT_1 + diff3_4 + price_before_disc4 - None + Number -1 -1 N @@ -3839,12 +3062,12 @@ where b.purchase_price_exist = 'Y' - diff2_5 - SUBTRACT - price_before_disc5 - price_tier2_5 + disc3_5 + PERCENT_1 + diff3_5 + price_before_disc5 - None + Number -1 -1 N @@ -3854,12 +3077,12 @@ where b.purchase_price_exist = 'Y' - diff2_6 - SUBTRACT - price_before_disc6 - price_tier2_6 + disc3_6 + PERCENT_1 + diff3_6 + price_before_disc6 - None + Number -1 -1 N @@ -3869,12 +3092,12 @@ where b.purchase_price_exist = 'Y' - diff2_7 - SUBTRACT - price_before_disc7 - price_tier2_7 + disc3_7 + PERCENT_1 + diff3_7 + price_before_disc7 - None + Number -1 -1 N @@ -3884,12 +3107,12 @@ where b.purchase_price_exist = 'Y' - diff2_8 - SUBTRACT - price_before_disc8 - price_tier2_8 + disc3_8 + PERCENT_1 + diff3_8 + price_before_disc8 - None + Number -1 -1 N @@ -3899,12 +3122,12 @@ where b.purchase_price_exist = 'Y' - diff2_9 - SUBTRACT - price_before_disc9 - price_tier2_9 + disc3_9 + PERCENT_1 + diff3_9 + price_before_disc9 - None + Number -1 -1 N @@ -3914,12 +3137,12 @@ where b.purchase_price_exist = 'Y' - diff3_10 - SUBTRACT - price_before_disc10 - price_tier2_10 + disc3_10 + PERCENT_1 + diff3_10 + price_before_disc10 - None + Number -1 -1 N @@ -3929,12 +3152,12 @@ where b.purchase_price_exist = 'Y' - diff3_1 - SUBTRACT - price_before_disc1 - price_tier3_1 + disc4_1 + PERCENT_1 + diff4_1 + price_before_disc1 - None + Number -1 -1 N @@ -3944,12 +3167,12 @@ where b.purchase_price_exist = 'Y' - diff3_2 - SUBTRACT - price_before_disc2 - price_tier3_2 + disc4_2 + PERCENT_1 + diff4_2 + price_before_disc2 - None + Number -1 -1 N @@ -3959,12 +3182,12 @@ where b.purchase_price_exist = 'Y' - diff3_3 - SUBTRACT - price_before_disc3 - price_tier3_3 + disc4_3 + PERCENT_1 + diff4_3 + price_before_disc3 - None + Number -1 -1 N @@ -3974,12 +3197,12 @@ where b.purchase_price_exist = 'Y' - diff3_4 - SUBTRACT - price_before_disc4 - price_tier3_4 + disc4_4 + PERCENT_1 + diff4_4 + price_before_disc4 - None + Number -1 -1 N @@ -3989,12 +3212,12 @@ where b.purchase_price_exist = 'Y' - diff3_5 - SUBTRACT - price_before_disc5 - price_tier3_5 + disc4_5 + PERCENT_1 + diff4_5 + price_before_disc5 - None + Number -1 -1 N @@ -4004,12 +3227,12 @@ where b.purchase_price_exist = 'Y' - diff3_6 - SUBTRACT - price_before_disc6 - price_tier3_6 + disc4_6 + PERCENT_1 + diff4_6 + price_before_disc6 - None + Number -1 -1 N @@ -4019,12 +3242,12 @@ where b.purchase_price_exist = 'Y' - diff3_7 - SUBTRACT - price_before_disc7 - price_tier3_7 + disc4_7 + PERCENT_1 + diff4_7 + price_before_disc7 - None + Number -1 -1 N @@ -4034,12 +3257,12 @@ where b.purchase_price_exist = 'Y' - diff3_8 - SUBTRACT - price_before_disc8 - price_tier3_8 + disc4_8 + PERCENT_1 + diff4_8 + price_before_disc8 - None + Number -1 -1 N @@ -4049,12 +3272,12 @@ where b.purchase_price_exist = 'Y' - diff3_9 - SUBTRACT - price_before_disc9 - price_tier3_9 + disc4_9 + PERCENT_1 + diff4_9 + price_before_disc9 - None + Number -1 -1 N @@ -4064,12 +3287,12 @@ where b.purchase_price_exist = 'Y' - diff3_10 - SUBTRACT - price_before_disc10 - price_tier3_10 + disc4_10 + PERCENT_1 + diff4_10 + price_before_disc10 - None + Number -1 -1 N @@ -4079,12 +3302,12 @@ where b.purchase_price_exist = 'Y' - diff4_1 - SUBTRACT - price_before_disc1 - price_tier4_1 + disc5_1 + PERCENT_1 + diff5_1 + price_before_disc1 - None + Number -1 -1 N @@ -4094,12 +3317,12 @@ where b.purchase_price_exist = 'Y' - diff4_2 - SUBTRACT - price_before_disc2 - price_tier4_2 + disc5_2 + PERCENT_1 + diff5_2 + price_before_disc2 - None + Number -1 -1 N @@ -4109,12 +3332,12 @@ where b.purchase_price_exist = 'Y' - diff4_3 - SUBTRACT - price_before_disc3 - price_tier4_3 + disc5_3 + PERCENT_1 + diff5_3 + price_before_disc3 - None + Number -1 -1 N @@ -4124,12 +3347,12 @@ where b.purchase_price_exist = 'Y' - diff4_4 - SUBTRACT - price_before_disc4 - price_tier4_4 + disc5_4 + PERCENT_1 + diff5_4 + price_before_disc4 - None + Number -1 -1 N @@ -4139,12 +3362,12 @@ where b.purchase_price_exist = 'Y' - diff4_5 - SUBTRACT - price_before_disc5 - price_tier4_5 + disc5_5 + PERCENT_1 + diff5_5 + price_before_disc5 - None + Number -1 -1 N @@ -4154,12 +3377,12 @@ where b.purchase_price_exist = 'Y' - diff4_6 - SUBTRACT - price_before_disc6 - price_tier4_6 + disc5_6 + PERCENT_1 + diff5_6 + price_before_disc6 - None + Number -1 -1 N @@ -4169,12 +3392,12 @@ where b.purchase_price_exist = 'Y' - diff4_7 - SUBTRACT - price_before_disc7 - price_tier4_7 + disc5_7 + PERCENT_1 + diff5_7 + price_before_disc7 - None + Number -1 -1 N @@ -4184,12 +3407,12 @@ where b.purchase_price_exist = 'Y' - diff4_8 - SUBTRACT - price_before_disc8 - price_tier4_8 + disc5_8 + PERCENT_1 + diff5_8 + price_before_disc8 - None + Number -1 -1 N @@ -4199,12 +3422,12 @@ where b.purchase_price_exist = 'Y' - diff4_9 - SUBTRACT - price_before_disc9 - price_tier4_9 + disc5_9 + PERCENT_1 + diff5_9 + price_before_disc9 - None + Number -1 -1 N @@ -4214,12 +3437,12 @@ where b.purchase_price_exist = 'Y' - diff4_10 - SUBTRACT - price_before_disc10 - price_tier4_10 + disc5_10 + PERCENT_1 + diff5_10 + price_before_disc10 - None + Number -1 -1 N @@ -4228,13 +3451,39 @@ where b.purchase_price_exist = 'Y' + + + + + + + + + + 832 + 352 + Y + + + + calculate price tier override vendor + Calculator + + Y + + 1 + + none + + + Y - diff5_1 - SUBTRACT - price_before_disc1 - price_tier5_1 + price_before_disc1 + PERCENT_3 + purchase_price + markup_group1 - None + Number -1 -1 N @@ -4244,12 +3493,12 @@ where b.purchase_price_exist = 'Y' - diff5_2 - SUBTRACT - price_before_disc2 - price_tier5_2 + price_before_disc2 + PERCENT_3 + purchase_price + markup_group2 - None + Number -1 -1 N @@ -4259,12 +3508,12 @@ where b.purchase_price_exist = 'Y' - diff5_3 - SUBTRACT - price_before_disc3 - price_tier5_3 + price_before_disc3 + PERCENT_3 + purchase_price + markup_group3 - None + Number -1 -1 N @@ -4274,12 +3523,12 @@ where b.purchase_price_exist = 'Y' - diff5_4 - SUBTRACT - price_before_disc4 - price_tier5_4 + price_before_disc4 + PERCENT_3 + purchase_price + markup_group4 - None + Number -1 -1 N @@ -4289,12 +3538,12 @@ where b.purchase_price_exist = 'Y' - diff5_5 - SUBTRACT - price_before_disc5 - price_tier5_5 + price_before_disc5 + PERCENT_3 + purchase_price + markup_group5 - None + Number -1 -1 N @@ -4304,12 +3553,12 @@ where b.purchase_price_exist = 'Y' - diff5_6 - SUBTRACT - price_before_disc6 - price_tier5_6 + price_before_disc6 + PERCENT_3 + purchase_price + markup_group6 - None + Number -1 -1 N @@ -4319,12 +3568,12 @@ where b.purchase_price_exist = 'Y' - diff5_7 - SUBTRACT - price_before_disc7 - price_tier5_7 + price_before_disc7 + PERCENT_3 + purchase_price + markup_group7 - None + Number -1 -1 N @@ -4334,12 +3583,12 @@ where b.purchase_price_exist = 'Y' - diff5_8 - SUBTRACT - price_before_disc8 - price_tier5_8 + price_before_disc8 + PERCENT_3 + purchase_price + markup_group8 - None + Number -1 -1 N @@ -4349,12 +3598,12 @@ where b.purchase_price_exist = 'Y' - diff5_9 - SUBTRACT - price_before_disc9 - price_tier5_9 + price_before_disc9 + PERCENT_3 + purchase_price + markup_group9 - None + Number -1 -1 N @@ -4364,12 +3613,12 @@ where b.purchase_price_exist = 'Y' - diff5_10 - SUBTRACT - price_before_disc10 - price_tier5_10 + price_before_disc10 + PERCENT_3 + purchase_price + markup_group10 - None + Number -1 -1 N @@ -4378,37 +3627,11 @@ where b.purchase_price_exist = 'Y' - - - - - - - - - - 576 - 352 - Y - - - - calculate discount override vendor - Calculator - - Y - - 1 - - none - - - Y - disc1_1 - PERCENT_1 - diff1_1 - price_before_disc1 + price_after_disc_1 + PERCENT_3 + purchase_price + markup_std1 Number -1 @@ -4420,10 +3643,10 @@ where b.purchase_price_exist = 'Y' - disc1_2 - PERCENT_1 - diff1_2 - price_before_disc2 + price_after_disc_2 + PERCENT_3 + purchase_price + markup_std2 Number -1 @@ -4435,10 +3658,10 @@ where b.purchase_price_exist = 'Y' - disc1_3 - PERCENT_1 - diff1_3 - price_before_disc3 + price_after_disc_3 + PERCENT_3 + purchase_price + markup_std3 Number -1 @@ -4450,10 +3673,10 @@ where b.purchase_price_exist = 'Y' - disc1_4 - PERCENT_1 - diff1_4 - price_before_disc4 + price_after_disc_4 + PERCENT_3 + purchase_price + markup_std4 Number -1 @@ -4465,10 +3688,10 @@ where b.purchase_price_exist = 'Y' - disc1_5 - PERCENT_1 - diff1_5 - price_before_disc5 + price_after_disc_5 + PERCENT_3 + purchase_price + markup_std5 Number -1 @@ -4480,10 +3703,10 @@ where b.purchase_price_exist = 'Y' - disc1_6 - PERCENT_1 - diff1_6 - price_before_disc6 + price_after_disc_6 + PERCENT_3 + purchase_price + markup_std6 Number -1 @@ -4495,10 +3718,10 @@ where b.purchase_price_exist = 'Y' - disc1_7 - PERCENT_1 - diff1_7 - price_before_disc7 + price_after_disc_7 + PERCENT_3 + purchase_price + markup_std7 Number -1 @@ -4510,10 +3733,10 @@ where b.purchase_price_exist = 'Y' - disc1_8 - PERCENT_1 - diff1_8 - price_before_disc8 + price_after_disc_8 + PERCENT_3 + purchase_price + markup_std8 Number -1 @@ -4525,10 +3748,10 @@ where b.purchase_price_exist = 'Y' - disc1_9 - PERCENT_1 - diff1_9 - price_before_disc9 + price_after_disc_9 + PERCENT_3 + purchase_price + markup_std9 Number -1 @@ -4540,10 +3763,10 @@ where b.purchase_price_exist = 'Y' - disc1_10 - PERCENT_1 - diff1_10 - price_before_disc10 + price_after_disc_10 + PERCENT_3 + purchase_price + markup_std10 Number -1 @@ -4555,10 +3778,10 @@ where b.purchase_price_exist = 'Y' - disc2_1 - PERCENT_1 - diff2_1 - price_before_disc1 + price_tier2_1 + PERCENT_3 + purchase_price + markup_tier2_1 Number -1 @@ -4570,10 +3793,10 @@ where b.purchase_price_exist = 'Y' - disc2_2 - PERCENT_1 - diff2_2 - price_before_disc2 + price_tier2_2 + PERCENT_3 + purchase_price + markup_tier2_2 Number -1 @@ -4585,10 +3808,10 @@ where b.purchase_price_exist = 'Y' - disc2_3 - PERCENT_1 - diff2_3 - price_before_disc3 + price_tier2_3 + PERCENT_3 + purchase_price + markup_tier2_3 Number -1 @@ -4600,10 +3823,10 @@ where b.purchase_price_exist = 'Y' - disc2_4 - PERCENT_1 - diff2_4 - price_before_disc4 + price_tier2_4 + PERCENT_3 + purchase_price + markup_tier2_4 Number -1 @@ -4615,10 +3838,10 @@ where b.purchase_price_exist = 'Y' - disc2_5 - PERCENT_1 - diff2_5 - price_before_disc5 + price_tier2_5 + PERCENT_3 + purchase_price + markup_tier2_5 Number -1 @@ -4630,10 +3853,10 @@ where b.purchase_price_exist = 'Y' - disc2_6 - PERCENT_1 - diff2_6 - price_before_disc6 + price_tier2_6 + PERCENT_3 + purchase_price + markup_tier2_6 Number -1 @@ -4645,10 +3868,10 @@ where b.purchase_price_exist = 'Y' - disc2_7 - PERCENT_1 - diff2_7 - price_before_disc7 + price_tier2_7 + PERCENT_3 + purchase_price + markup_tier2_7 Number -1 @@ -4660,10 +3883,10 @@ where b.purchase_price_exist = 'Y' - disc2_8 - PERCENT_1 - diff2_8 - price_before_disc8 + price_tier2_8 + PERCENT_3 + purchase_price + markup_tier2_8 Number -1 @@ -4675,10 +3898,10 @@ where b.purchase_price_exist = 'Y' - disc2_9 - PERCENT_1 - diff2_9 - price_before_disc9 + price_tier2_9 + PERCENT_3 + purchase_price + markup_tier2_9 Number -1 @@ -4689,11 +3912,11 @@ where b.purchase_price_exist = 'Y' - - disc2_10 - PERCENT_1 - diff2_10 - price_before_disc10 + + price_tier2_10 + PERCENT_3 + purchase_price + markup_tier2_10 Number -1 @@ -4705,10 +3928,10 @@ where b.purchase_price_exist = 'Y' - disc3_1 - PERCENT_1 - diff3_1 - price_before_disc1 + price_tier3_1 + PERCENT_3 + purchase_price + markup_tier3_1 Number -1 @@ -4720,10 +3943,10 @@ where b.purchase_price_exist = 'Y' - disc3_2 - PERCENT_1 - diff3_2 - price_before_disc2 + price_tier3_2 + PERCENT_3 + purchase_price + markup_tier3_2 Number -1 @@ -4735,10 +3958,10 @@ where b.purchase_price_exist = 'Y' - disc3_3 - PERCENT_1 - diff3_3 - price_before_disc3 + price_tier3_3 + PERCENT_3 + purchase_price + markup_tier3_3 Number -1 @@ -4750,10 +3973,10 @@ where b.purchase_price_exist = 'Y' - disc3_4 - PERCENT_1 - diff3_4 - price_before_disc4 + price_tier3_4 + PERCENT_3 + purchase_price + markup_tier3_4 Number -1 @@ -4765,10 +3988,10 @@ where b.purchase_price_exist = 'Y' - disc3_5 - PERCENT_1 - diff3_5 - price_before_disc5 + price_tier3_5 + PERCENT_3 + purchase_price + markup_tier3_5 Number -1 @@ -4780,10 +4003,10 @@ where b.purchase_price_exist = 'Y' - disc3_6 - PERCENT_1 - diff3_6 - price_before_disc6 + price_tier3_6 + PERCENT_3 + purchase_price + markup_tier3_6 Number -1 @@ -4795,10 +4018,10 @@ where b.purchase_price_exist = 'Y' - disc3_7 - PERCENT_1 - diff3_7 - price_before_disc7 + price_tier3_7 + PERCENT_3 + purchase_price + markup_tier3_7 Number -1 @@ -4810,10 +4033,10 @@ where b.purchase_price_exist = 'Y' - disc3_8 - PERCENT_1 - diff3_8 - price_before_disc8 + price_tier3_8 + PERCENT_3 + purchase_price + markup_tier3_8 Number -1 @@ -4825,10 +4048,10 @@ where b.purchase_price_exist = 'Y' - disc3_9 - PERCENT_1 - diff3_9 - price_before_disc9 + price_tier3_9 + PERCENT_3 + purchase_price + markup_tier3_9 Number -1 @@ -4840,10 +4063,10 @@ where b.purchase_price_exist = 'Y' - disc3_10 - PERCENT_1 - diff3_10 - price_before_disc10 + price_tier3_10 + PERCENT_3 + purchase_price + markup_tier3_10 Number -1 @@ -4855,10 +4078,10 @@ where b.purchase_price_exist = 'Y' - disc4_1 - PERCENT_1 - diff4_1 - price_before_disc1 + price_tier4_1 + PERCENT_3 + purchase_price + markup_tier4_1 Number -1 @@ -4870,10 +4093,10 @@ where b.purchase_price_exist = 'Y' - disc4_2 - PERCENT_1 - diff4_2 - price_before_disc2 + price_tier4_2 + PERCENT_3 + purchase_price + markup_tier4_2 Number -1 @@ -4885,10 +4108,10 @@ where b.purchase_price_exist = 'Y' - disc4_3 - PERCENT_1 - diff4_3 - price_before_disc3 + price_tier4_3 + PERCENT_3 + purchase_price + markup_tier4_3 Number -1 @@ -4900,10 +4123,10 @@ where b.purchase_price_exist = 'Y' - disc4_4 - PERCENT_1 - diff4_4 - price_before_disc4 + price_tier4_4 + PERCENT_3 + purchase_price + markup_tier4_4 Number -1 @@ -4915,10 +4138,10 @@ where b.purchase_price_exist = 'Y' - disc4_5 - PERCENT_1 - diff4_5 - price_before_disc5 + price_tier4_5 + PERCENT_3 + purchase_price + markup_tier4_5 Number -1 @@ -4930,10 +4153,10 @@ where b.purchase_price_exist = 'Y' - disc4_6 - PERCENT_1 - diff4_6 - price_before_disc6 + price_tier4_6 + PERCENT_3 + purchase_price + markup_tier4_6 Number -1 @@ -4945,10 +4168,10 @@ where b.purchase_price_exist = 'Y' - disc4_7 - PERCENT_1 - diff4_7 - price_before_disc7 + price_tier4_7 + PERCENT_3 + purchase_price + markup_tier4_7 Number -1 @@ -4960,10 +4183,10 @@ where b.purchase_price_exist = 'Y' - disc4_8 - PERCENT_1 - diff4_8 - price_before_disc8 + price_tier4_8 + PERCENT_3 + purchase_price + markup_tier4_8 Number -1 @@ -4975,10 +4198,10 @@ where b.purchase_price_exist = 'Y' - disc4_9 - PERCENT_1 - diff4_9 - price_before_disc9 + price_tier4_9 + PERCENT_3 + purchase_price + markup_tier4_9 Number -1 @@ -4990,10 +4213,10 @@ where b.purchase_price_exist = 'Y' - disc4_10 - PERCENT_1 - diff4_10 - price_before_disc10 + price_tier4_10 + PERCENT_3 + purchase_price + markup_tier4_10 Number -1 @@ -5005,10 +4228,10 @@ where b.purchase_price_exist = 'Y' - disc5_1 - PERCENT_1 - diff5_1 - price_before_disc1 + price_tier5_1 + PERCENT_3 + purchase_price + markup_tier5_1 Number -1 @@ -5020,10 +4243,10 @@ where b.purchase_price_exist = 'Y' - disc5_2 - PERCENT_1 - diff5_2 - price_before_disc2 + price_tier5_2 + PERCENT_3 + purchase_price + markup_tier5_2 Number -1 @@ -5035,10 +4258,10 @@ where b.purchase_price_exist = 'Y' - disc5_3 - PERCENT_1 - diff5_3 - price_before_disc3 + price_tier5_3 + PERCENT_3 + purchase_price + markup_tier5_3 Number -1 @@ -5050,10 +4273,10 @@ where b.purchase_price_exist = 'Y' - disc5_4 - PERCENT_1 - diff5_4 - price_before_disc4 + price_tier5_4 + PERCENT_3 + purchase_price + markup_tier5_4 Number -1 @@ -5065,10 +4288,10 @@ where b.purchase_price_exist = 'Y' - disc5_5 - PERCENT_1 - diff5_5 - price_before_disc5 + price_tier5_5 + PERCENT_3 + purchase_price + markup_tier5_5 Number -1 @@ -5080,10 +4303,10 @@ where b.purchase_price_exist = 'Y' - disc5_6 - PERCENT_1 - diff5_6 - price_before_disc6 + price_tier5_6 + PERCENT_3 + purchase_price + markup_tier5_6 Number -1 @@ -5095,10 +4318,10 @@ where b.purchase_price_exist = 'Y' - disc5_7 - PERCENT_1 - diff5_7 - price_before_disc7 + price_tier5_7 + PERCENT_3 + purchase_price + markup_tier5_7 Number -1 @@ -5110,10 +4333,10 @@ where b.purchase_price_exist = 'Y' - disc5_8 - PERCENT_1 - diff5_8 - price_before_disc8 + price_tier5_8 + PERCENT_3 + purchase_price + markup_tier5_8 Number -1 @@ -5125,10 +4348,10 @@ where b.purchase_price_exist = 'Y' - disc5_9 - PERCENT_1 - diff5_9 - price_before_disc9 + price_tier5_9 + PERCENT_3 + purchase_price + markup_tier5_9 Number -1 @@ -5140,10 +4363,10 @@ where b.purchase_price_exist = 'Y' - disc5_10 - PERCENT_1 - diff5_10 - price_before_disc10 + price_tier5_10 + PERCENT_3 + purchase_price + markup_tier5_10 Number -1 @@ -5163,7 +4386,784 @@ where b.purchase_price_exist = 'Y' - 832 + 576 + 128 + Y + + + + filter override vendor purchase price = 0 + WriteToLog + + Y + + 1 + + none + + + log_level_basic + Y + N + 0 + + + + + + + + + + + + + 352 + 256 + Y + + + + update purchase pricelist override vendor + Update + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + N + 100 + N + N + + + public + pricelist_compute
+ + product_id + product_id + = + + + + item_code + item_code + + + name + name + + + pricing_group + pricing_group + + + purchase_price + purchase_price + + + vendor + vendor + + + markup_std1 + markup_std1 + + + markup_std2 + markup_std2 + + + markup_std3 + markup_std3 + + + markup_std4 + markup_std4 + + + markup_std5 + markup_std5 + + + markup_std6 + markup_std6 + + + markup_std7 + markup_std7 + + + markup_std8 + markup_std8 + + + markup_std9 + markup_std9 + + + markup_std10 + markup_std10 + + + markup_group1 + markup_group1 + + + markup_group2 + markup_group2 + + + markup_group3 + markup_group3 + + + markup_group4 + markup_group4 + + + markup_group5 + markup_group5 + + + markup_group6 + markup_group6 + + + markup_group7 + markup_group7 + + + markup_group8 + markup_group8 + + + markup_group9 + markup_group9 + + + markup_group10 + markup_group10 + + + markup_tier2_1 + markup_tier2_1 + + + markup_tier2_2 + markup_tier2_2 + + + markup_tier2_3 + markup_tier2_3 + + + markup_tier2_4 + markup_tier2_4 + + + markup_tier2_5 + markup_tier2_5 + + + markup_tier2_6 + markup_tier2_6 + + + markup_tier2_7 + markup_tier2_7 + + + markup_tier2_8 + markup_tier2_8 + + + markup_tier2_9 + markup_tier2_9 + + + markup_tier2_10 + markup_tier2_10 + + + markup_tier3_1 + markup_tier3_1 + + + markup_tier3_2 + markup_tier3_2 + + + markup_tier3_3 + markup_tier3_3 + + + markup_tier3_4 + markup_tier3_4 + + + markup_tier3_5 + markup_tier3_5 + + + markup_tier3_6 + markup_tier3_6 + + + markup_tier3_7 + markup_tier3_7 + + + markup_tier3_8 + markup_tier3_8 + + + markup_tier3_9 + markup_tier3_9 + + + markup_tier3_10 + markup_tier3_10 + + + markup_tier4_1 + markup_tier4_1 + + + markup_tier4_2 + markup_tier4_2 + + + markup_tier4_3 + markup_tier4_3 + + + markup_tier4_4 + markup_tier4_4 + + + markup_tier4_5 + markup_tier4_5 + + + markup_tier4_6 + markup_tier4_6 + + + markup_tier4_7 + markup_tier4_7 + + + markup_tier4_8 + markup_tier4_8 + + + markup_tier4_9 + markup_tier4_9 + + + markup_tier4_10 + markup_tier4_10 + + + markup_tier5_1 + markup_tier5_1 + + + markup_tier5_2 + markup_tier5_2 + + + markup_tier5_3 + markup_tier5_3 + + + markup_tier5_4 + markup_tier5_4 + + + markup_tier5_5 + markup_tier5_5 + + + markup_tier5_6 + markup_tier5_6 + + + markup_tier5_7 + markup_tier5_7 + + + markup_tier5_8 + markup_tier5_8 + + + markup_tier5_9 + markup_tier5_9 + + + markup_tier5_10 + markup_tier5_10 + + + price_before_disc1 + price_before_disc1 + + + price_before_disc2 + price_before_disc2 + + + price_before_disc3 + price_before_disc3 + + + price_before_disc4 + price_before_disc4 + + + price_before_disc5 + price_before_disc5 + + + price_before_disc6 + price_before_disc6 + + + price_before_disc7 + price_before_disc7 + + + 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 + + + price_after_disc_2 + price_after_disc_2 + + + price_after_disc_3 + price_after_disc_3 + + + price_after_disc_4 + price_after_disc_4 + + + price_after_disc_5 + price_after_disc_5 + + + price_after_disc_6 + price_after_disc_6 + + + price_after_disc_7 + price_after_disc_7 + + + 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 + + + price_tier2_2 + price_tier2_2 + + + price_tier2_3 + price_tier2_3 + + + price_tier2_4 + price_tier2_4 + + + price_tier2_5 + price_tier2_5 + + + price_tier2_6 + price_tier2_6 + + + price_tier2_7 + price_tier2_7 + + + price_tier2_8 + price_tier2_8 + + + price_tier2_9 + price_tier2_9 + + + price_tier2_10 + price_tier2_10 + + + price_tier3_1 + price_tier3_1 + + + price_tier3_2 + price_tier3_2 + + + price_tier3_3 + price_tier3_3 + + + price_tier3_4 + price_tier3_4 + + + price_tier3_5 + price_tier3_5 + + + price_tier3_6 + price_tier3_6 + + + price_tier3_7 + price_tier3_7 + + + price_tier3_8 + price_tier3_8 + + + price_tier3_9 + price_tier3_9 + + + price_tier3_10 + price_tier3_10 + + + price_tier4_1 + price_tier4_1 + + + price_tier4_2 + price_tier4_2 + + + price_tier4_3 + price_tier4_3 + + + price_tier4_4 + price_tier4_4 + + + price_tier4_5 + price_tier4_5 + + + price_tier4_6 + price_tier4_6 + + + price_tier4_7 + price_tier4_7 + + + price_tier4_8 + price_tier4_8 + + + price_tier4_9 + price_tier4_9 + + + price_tier4_10 + price_tier4_10 + + + price_tier5_1 + price_tier5_1 + + + price_tier5_2 + price_tier5_2 + + + price_tier5_3 + price_tier5_3 + + + price_tier5_4 + price_tier5_4 + + + price_tier5_5 + price_tier5_5 + + + price_tier5_6 + price_tier5_6 + + + price_tier5_7 + price_tier5_7 + + + price_tier5_8 + price_tier5_8 + + + price_tier5_9 + price_tier5_9 + + + price_tier5_10 + price_tier5_10 + + + disc1_1 + disc1_1 + + + disc1_2 + disc1_2 + + + disc1_3 + disc1_3 + + + disc1_4 + disc1_4 + + + disc1_5 + disc1_5 + + + disc1_6 + disc1_6 + + + disc1_7 + disc1_7 + + + disc1_8 + disc1_8 + + + disc1_9 + disc1_9 + + + disc1_10 + disc1_10 + + + disc2_1 + disc2_1 + + + disc2_2 + disc2_2 + + + disc2_3 + disc2_3 + + + disc2_4 + disc2_4 + + + disc2_5 + disc2_5 + + + disc2_6 + disc2_6 + + + disc2_7 + disc2_7 + + + disc2_8 + disc2_8 + + + disc2_9 + disc2_9 + + + disc2_10 + disc2_10 + + + disc3_1 + disc3_1 + + + disc3_2 + disc3_2 + + + disc3_3 + disc3_3 + + + disc3_4 + disc3_4 + + + disc3_5 + disc3_5 + + + disc3_6 + disc3_6 + + + disc3_7 + disc3_7 + + + disc3_8 + disc3_8 + + + disc3_9 + disc3_9 + + + disc3_10 + disc3_10 + + + disc4_1 + disc4_1 + + + disc4_2 + disc4_2 + + + disc4_3 + disc4_3 + + + disc4_4 + disc4_4 + + + disc4_5 + disc4_5 + + + disc4_6 + disc4_6 + + + disc4_7 + disc4_7 + + + disc4_8 + disc4_8 + + + disc4_9 + disc4_9 + + + disc4_10 + disc4_10 + + + disc5_1 + disc5_1 + + + disc5_2 + disc5_2 + + + disc5_3 + disc5_3 + + + disc5_4 + disc5_4 + + + disc5_5 + disc5_5 + + + disc5_6 + disc5_6 + + + disc5_7 + disc5_7 + + + disc5_8 + disc5_8 + + + disc5_9 + disc5_9 + + + disc5_10 + disc5_10 + + + vendor_id + vendor_id + + + + + + + + + + + + 1168 352 Y -- cgit v1.2.3