insert update price

1 files changed, 268 insertions, 0 deletions

diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr
index 76f4d65..d0e2ceb 100644
--- a/calculate_price_after_disc.ktr
+++ b/calculate_price_after_disc.ktr
@@ -497,6 +497,11 @@
       <to>Calculator 2</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>Calculator 2</from>
+      <to>Insert / update</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Table input</name>
@@ -1484,6 +1489,269 @@ left join brand b on b.id = p.brand_id
       <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>