modif compute pricelist

2 files changed, 876 insertions, 618 deletions

diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr
index d0e2ceb..f3798dd 100644
--- a/calculate_price_after_disc.ktr
+++ b/calculate_price_after_disc.ktr
@@ -430,7 +430,7 @@
     <created_date>2023/08/22 11:11:06.045</created_date>
     <modified_user>-</modified_user>
     <modified_date>2023/08/22 11:11:06.045</modified_date>
-    <key_for_session_key/>
+    <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>
     <is_key_private>N</is_key_private>
   </info>
   <notepads>
@@ -504,6 +504,821 @@
     </hop>
   </order>
   <step>
+    <name>Calculator</name>
+    <type>Calculator</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <failIfNoFile>Y</failIfNoFile>
+    <calculation>
+      <field_name>price_after_disc_1</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_std1</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_after_disc_2</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_std2</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_after_disc_3</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_std3</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_after_disc_4</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_std4</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_after_disc_5</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_std5</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>384</xloc>
+      <yloc>64</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>Calculator 2</name>
+    <type>Calculator</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <failIfNoFile>Y</failIfNoFile>
+    <calculation>
+      <field_name>price_before_disc1</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>price_after_disc_1</field_a>
+      <field_b>markup_group1</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_before_disc2</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>price_after_disc_2</field_a>
+      <field_b>markup_group2</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_before_disc3</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>price_after_disc_3</field_a>
+      <field_b>markup_group3</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_before_disc4</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>price_after_disc_4</field_a>
+      <field_b>markup_group4</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_before_disc5</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>price_after_disc_5</field_a>
+      <field_b>markup_group5</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier2_1</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier2_1</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier2_2</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier2_2</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier2_3</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier2_3</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier2_4</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier2_4</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier2_5</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier2_5</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier3_1</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier3_1</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier3_2</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier3_2</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier3_3</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier3_3</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier3_4</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier3_4</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier3_5</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier3_5</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier4_1</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier4_1</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier4_2</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier4_2</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier4_3</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier4_3</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier4_4</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier4_4</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier4_5</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier4_5</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier5_1</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier5_1</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier5_2</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier5_2</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier5_3</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier5_3</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier5_4</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier5_4</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>price_tier5_5</field_name>
+      <calc_type>PERCENT_3</calc_type>
+      <field_a>purchase_price</field_a>
+      <field_b>markup_tier5_5</field_b>
+      <field_c/>
+      <value_type>Number</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>544</xloc>
+      <yloc>64</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>Insert / update</name>
+    <type>InsertUpdate</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>dw bi indoteknik</connection>
+    <commit>100</commit>
+    <update_bypassed>N</update_bypassed>
+    <lookup>
+      <schema>public</schema>
+      <table>pricelist_compute</table>
+      <key>
+        <name>product_id</name>
+        <field>product_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <value>
+        <name>product_id</name>
+        <rename>product_id</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>item_code</name>
+        <rename>item_code</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>name</name>
+        <rename>name</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>purchase_price</name>
+        <rename>purchase_price</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>pricing_group</name>
+        <rename>pricing_group</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_std1</name>
+        <rename>markup_std1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_std2</name>
+        <rename>markup_std2</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_std3</name>
+        <rename>markup_std3</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_std4</name>
+        <rename>markup_std4</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_std5</name>
+        <rename>markup_std5</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_group1</name>
+        <rename>markup_group1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_group2</name>
+        <rename>markup_group2</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_group3</name>
+        <rename>markup_group3</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_group4</name>
+        <rename>markup_group4</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_group5</name>
+        <rename>markup_group5</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier2_1</name>
+        <rename>markup_tier2_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier2_2</name>
+        <rename>markup_tier2_2</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier2_3</name>
+        <rename>markup_tier2_3</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier2_4</name>
+        <rename>markup_tier2_4</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier2_5</name>
+        <rename>markup_tier2_5</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier3_1</name>
+        <rename>markup_tier3_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier3_2</name>
+        <rename>markup_tier3_2</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier3_3</name>
+        <rename>markup_tier3_3</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier3_4</name>
+        <rename>markup_tier3_4</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier3_5</name>
+        <rename>markup_tier3_5</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_after_disc_1</name>
+        <rename>price_after_disc_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_after_disc_2</name>
+        <rename>price_after_disc_2</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_after_disc_3</name>
+        <rename>price_after_disc_3</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_after_disc_4</name>
+        <rename>price_after_disc_4</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_after_disc_5</name>
+        <rename>price_after_disc_5</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_before_disc1</name>
+        <rename>price_before_disc1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_before_disc2</name>
+        <rename>price_before_disc2</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_before_disc3</name>
+        <rename>price_before_disc3</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_before_disc4</name>
+        <rename>price_before_disc4</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_before_disc5</name>
+        <rename>price_before_disc5</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier2_1</name>
+        <rename>price_tier2_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier2_2</name>
+        <rename>price_tier2_2</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier2_3</name>
+        <rename>price_tier2_3</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier2_4</name>
+        <rename>price_tier2_4</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier2_5</name>
+        <rename>price_tier2_5</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier3_1</name>
+        <rename>price_tier3_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier3_2</name>
+        <rename>price_tier3_2</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier3_3</name>
+        <rename>price_tier3_3</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier3_4</name>
+        <rename>price_tier3_4</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier3_5</name>
+        <rename>price_tier3_5</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier4_1</name>
+        <rename>price_tier4_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier4_2</name>
+        <rename>price_tier4_2</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier4_3</name>
+        <rename>price_tier4_3</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier4_4</name>
+        <rename>price_tier4_4</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier4_5</name>
+        <rename>price_tier4_5</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier5_1</name>
+        <rename>price_tier5_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier5_2</name>
+        <rename>price_tier5_2</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier5_3</name>
+        <rename>price_tier5_3</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier5_4</name>
+        <rename>price_tier5_4</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier5_5</name>
+        <rename>price_tier5_5</rename>
+        <update>Y</update>
+      </value>
+    </lookup>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>720</xloc>
+      <yloc>64</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
     <name>Table input</name>
     <type>TableInput</type>
     <description/>
@@ -535,11 +1350,21 @@
 (select group2 from price_group_dw pgd where id = 4) as markup_tier3_2,
 (select group3 from price_group_dw pgd where id = 4) as markup_tier3_3,
 (select group4 from price_group_dw pgd where id = 4) as markup_tier3_4,
-(select group5 from price_group_dw pgd where id = 4) as markup_tier3_5
+(select group5 from price_group_dw pgd where id = 4) as markup_tier3_5,
+(select group1 from price_group_dw pgd where id = 5) as markup_tier4_1,
+(select group2 from price_group_dw pgd where id = 5) as markup_tier4_2,
+(select group3 from price_group_dw pgd where id = 5) as markup_tier4_3,
+(select group4 from price_group_dw pgd where id = 5) as markup_tier4_4,
+(select group5 from price_group_dw pgd where id = 5) as markup_tier4_5,
+(select group1 from price_group_dw pgd where id = 6) as markup_tier5_1,
+(select group2 from price_group_dw pgd where id = 6) as markup_tier5_2,
+(select group3 from price_group_dw pgd where id = 6) as markup_tier5_3,
+(select group4 from price_group_dw pgd where id = 6) as markup_tier5_4,
+(select group5 from price_group_dw pgd where id = 6) as markup_tier5_5
 from mv_purchase_pricelist mpp
 join product p on p.product_id = mpp.product_id
 left join brand b on b.id = p.brand_id
---where b.id in(10, 122, 89)</sql>
+where b.id in(10, 122, 89)</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
@@ -1137,621 +1962,6 @@ left join brand b on b.id = p.brand_id
       <draw>Y</draw>
     </GUI>
   </step>
-  <step>
-    <name>Calculator</name>
-    <type>Calculator</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <failIfNoFile>Y</failIfNoFile>
-    <calculation>
-      <field_name>price_after_disc_1</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_std1</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_after_disc_2</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_std2</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_after_disc_3</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_std3</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_after_disc_4</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_std4</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_after_disc_5</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_std5</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>384</xloc>
-      <yloc>64</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Calculator 2</name>
-    <type>Calculator</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <failIfNoFile>Y</failIfNoFile>
-    <calculation>
-      <field_name>price_before_disc1</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>price_after_disc_1</field_a>
-      <field_b>markup_group1</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_before_disc2</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>price_after_disc_2</field_a>
-      <field_b>markup_group2</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_before_disc3</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>price_after_disc_3</field_a>
-      <field_b>markup_group3</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_before_disc4</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>price_after_disc_4</field_a>
-      <field_b>markup_group4</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_before_disc5</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>price_after_disc_5</field_a>
-      <field_b>markup_group5</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_tier2_1</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_tier2_1</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_tier2_2</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_tier2_2</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_tier2_3</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_tier2_3</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_tier2_4</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_tier2_4</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_tier2_5</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_tier2_5</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_tier3_1</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_tier3_1</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_tier3_2</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_tier3_2</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_tier3_3</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_tier3_3</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_tier3_4</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_tier3_4</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>price_tier3_5</field_name>
-      <calc_type>PERCENT_3</calc_type>
-      <field_a>purchase_price</field_a>
-      <field_b>markup_tier3_5</field_b>
-      <field_c/>
-      <value_type>Number</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>544</xloc>
-      <yloc>64</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Insert / update</name>
-    <type>InsertUpdate</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <connection>dw bi indoteknik</connection>
-    <commit>100</commit>
-    <update_bypassed>N</update_bypassed>
-    <lookup>
-      <schema>public</schema>
-      <table>pricelist_compute</table>
-      <key>
-        <name>product_id</name>
-        <field>product_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <value>
-        <name>product_id</name>
-        <rename>product_id</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>item_code</name>
-        <rename>item_code</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>name</name>
-        <rename>name</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>purchase_price</name>
-        <rename>purchase_price</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>pricing_group</name>
-        <rename>pricing_group</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_std1</name>
-        <rename>markup_std1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_std2</name>
-        <rename>markup_std2</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_std3</name>
-        <rename>markup_std3</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_std4</name>
-        <rename>markup_std4</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_std5</name>
-        <rename>markup_std5</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_group1</name>
-        <rename>markup_group1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_group2</name>
-        <rename>markup_group2</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_group3</name>
-        <rename>markup_group3</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_group4</name>
-        <rename>markup_group4</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_group5</name>
-        <rename>markup_group5</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_tier2_1</name>
-        <rename>markup_tier2_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_tier2_2</name>
-        <rename>markup_tier2_2</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_tier2_3</name>
-        <rename>markup_tier2_3</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_tier2_4</name>
-        <rename>markup_tier2_4</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_tier2_5</name>
-        <rename>markup_tier2_5</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_tier3_1</name>
-        <rename>markup_tier3_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_tier3_2</name>
-        <rename>markup_tier3_2</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_tier3_3</name>
-        <rename>markup_tier3_3</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_tier3_4</name>
-        <rename>markup_tier3_4</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>markup_tier3_5</name>
-        <rename>markup_tier3_5</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_after_disc_1</name>
-        <rename>price_after_disc_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_after_disc_2</name>
-        <rename>price_after_disc_2</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_after_disc_3</name>
-        <rename>price_after_disc_3</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_after_disc_4</name>
-        <rename>price_after_disc_4</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_after_disc_5</name>
-        <rename>price_after_disc_5</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_before_disc1</name>
-        <rename>price_before_disc1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_before_disc2</name>
-        <rename>price_before_disc2</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_before_disc3</name>
-        <rename>price_before_disc3</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_before_disc4</name>
-        <rename>price_before_disc4</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_before_disc5</name>
-        <rename>price_before_disc5</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_tier2_1</name>
-        <rename>price_tier2_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_tier2_2</name>
-        <rename>price_tier2_2</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_tier2_3</name>
-        <rename>price_tier2_3</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_tier2_4</name>
-        <rename>price_tier2_4</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_tier2_5</name>
-        <rename>price_tier2_5</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_tier3_1</name>
-        <rename>price_tier3_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_tier3_2</name>
-        <rename>price_tier3_2</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_tier3_3</name>
-        <rename>price_tier3_3</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_tier3_4</name>
-        <rename>price_tier3_4</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_tier3_5</name>
-        <rename>price_tier3_5</rename>
-        <update>Y</update>
-      </value>
-    </lookup>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>720</xloc>
-      <yloc>64</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
   <step_error_handling>
   </step_error_handling>
   <slave-step-copy-partition-distribution>
diff --git a/import_all_data_bi_indoteknik.kjb b/import_all_data_bi_indoteknik.kjb
index 728cd69..eef86bc 100644
--- a/import_all_data_bi_indoteknik.kjb
+++ b/import_all_data_bi_indoteknik.kjb
@@ -995,6 +995,45 @@
       <yloc>560</yloc>
       <attributes_kjc/>
     </entry>
+    <entry>
+      <name>import price group</name>
+      <description/>
+      <type>TRANS</type>
+      <attributes/>
+      <specification_method>filename</specification_method>
+      <trans_object_id/>
+      <filename>/home/stephan/transformation-job-bi/import_price_group.ktr</filename>
+      <transname/>
+      <arg_from_previous>N</arg_from_previous>
+      <params_from_previous>N</params_from_previous>
+      <exec_per_row>N</exec_per_row>
+      <clear_rows>N</clear_rows>
+      <clear_files>N</clear_files>
+      <set_logfile>N</set_logfile>
+      <logfile/>
+      <logext/>
+      <add_date>N</add_date>
+      <add_time>N</add_time>
+      <loglevel>Basic</loglevel>
+      <cluster>N</cluster>
+      <slave_server_name/>
+      <set_append_logfile>N</set_append_logfile>
+      <wait_until_finished>Y</wait_until_finished>
+      <follow_abort_remote>N</follow_abort_remote>
+      <create_parent_folder>N</create_parent_folder>
+      <logging_remote_work>N</logging_remote_work>
+      <run_configuration>Pentaho local</run_configuration>
+      <suppress_result_data>N</suppress_result_data>
+      <parameters>
+        <pass_all_parameters>Y</pass_all_parameters>
+      </parameters>
+      <parallel>N</parallel>
+      <draw>Y</draw>
+      <nr>0</nr>
+      <xloc>480</xloc>
+      <yloc>560</yloc>
+      <attributes_kjc/>
+    </entry>
   </entries>
   <hops>
     <hop>
@@ -1159,6 +1198,15 @@
       <evaluation>Y</evaluation>
       <unconditional>N</unconditional>
     </hop>
+    <hop>
+      <from>import purchase pricelist</from>
+      <to>import price group</to>
+      <from_nr>0</from_nr>
+      <to_nr>0</to_nr>
+      <enabled>Y</enabled>
+      <evaluation>Y</evaluation>
+      <unconditional>N</unconditional>
+    </hop>
   </hops>
   <notepads>
   </notepads>