diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-09-21 08:01:07 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-09-21 08:01:07 +0700 |
| commit | 71ecbb3fd30227a1e14d774a9ef3339f329fed35 (patch) | |
| tree | e75a7d2b15a9d888d9d0067f14bdba39a251e8d0 | |
| parent | e0d5649dc8577a9a46864cdd41f14da755f8dd1b (diff) | |
revise the formula of calculate price
| -rw-r--r-- | calculate_price_after_disc.ktr | 3099 |
1 files changed, 1534 insertions, 1565 deletions
diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr index 186971a..c3b3c2e 100644 --- a/calculate_price_after_disc.ktr +++ b/calculate_price_after_disc.ktr @@ -488,11 +488,6 @@ </connection> <order> <hop> - <from>calculate price after disc</from> - <to>calculate price tier</to> - <enabled>Y</enabled> - </hop> - <hop> <from>calculate price tier</from> <to>calculate diff</to> <enabled>Y</enabled> @@ -514,11 +509,6 @@ </hop> <hop> <from>Filter rows</from> - <to>calculate price after disc</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>Filter rows</from> <to>Add constants</to> <enabled>Y</enabled> </hop> @@ -527,6 +517,11 @@ <to>dw Insert / update zero</to> <enabled>Y</enabled> </hop> + <hop> + <from>Filter rows</from> + <to>calculate price tier</to> + <enabled>Y</enabled> + </hop> </order> <step> <name>Add constants</name> @@ -578,7 +573,7 @@ <method>none</method> <schema_name/> </partitioning> - <send_true_to>calculate price after disc</send_true_to> + <send_true_to>calculate price tier</send_true_to> <send_false_to>Add constants</send_false_to> <compare> <condition> @@ -612,1492 +607,6 @@ </GUI> </step> <step> - <name>dw Insert / update calc pl</name> - <type>InsertUpdate</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>dw bi indoteknik (localhost)</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>disc1_1</name> - <rename>disc1_1</rename> - <update>Y</update> - </value> - <value> - <name>disc1_2</name> - <rename>disc1_2</rename> - <update>Y</update> - </value> - <value> - <name>disc1_3</name> - <rename>disc1_3</rename> - <update>Y</update> - </value> - <value> - <name>disc1_4</name> - <rename>disc1_4</rename> - <update>Y</update> - </value> - <value> - <name>disc1_5</name> - <rename>disc1_5</rename> - <update>Y</update> - </value> - <value> - <name>disc1_6</name> - <rename>disc1_6</rename> - <update>Y</update> - </value> - <value> - <name>disc1_7</name> - <rename>disc1_7</rename> - <update>Y</update> - </value> - <value> - <name>disc1_8</name> - <rename>disc1_8</rename> - <update>Y</update> - </value> - <value> - <name>disc2_1</name> - <rename>disc2_1</rename> - <update>Y</update> - </value> - <value> - <name>disc2_2</name> - <rename>disc2_2</rename> - <update>Y</update> - </value> - <value> - <name>disc2_3</name> - <rename>disc2_3</rename> - <update>Y</update> - </value> - <value> - <name>disc2_4</name> - <rename>disc2_4</rename> - <update>Y</update> - </value> - <value> - <name>disc2_5</name> - <rename>disc2_5</rename> - <update>Y</update> - </value> - <value> - <name>disc2_6</name> - <rename>disc2_6</rename> - <update>Y</update> - </value> - <value> - <name>disc2_7</name> - <rename>disc2_7</rename> - <update>Y</update> - </value> - <value> - <name>disc2_8</name> - <rename>disc2_8</rename> - <update>Y</update> - </value> - <value> - <name>disc3_1</name> - <rename>disc3_1</rename> - <update>Y</update> - </value> - <value> - <name>disc3_2</name> - <rename>disc3_2</rename> - <update>Y</update> - </value> - <value> - <name>disc3_3</name> - <rename>disc3_3</rename> - <update>Y</update> - </value> - <value> - <name>disc3_4</name> - <rename>disc3_4</rename> - <update>Y</update> - </value> - <value> - <name>disc3_5</name> - <rename>disc3_5</rename> - <update>Y</update> - </value> - <value> - <name>disc3_6</name> - <rename>disc3_6</rename> - <update>Y</update> - </value> - <value> - <name>disc3_7</name> - <rename>disc3_7</rename> - <update>Y</update> - </value> - <value> - <name>disc3_8</name> - <rename>disc3_8</rename> - <update>Y</update> - </value> - <value> - <name>disc4_1</name> - <rename>disc4_1</rename> - <update>Y</update> - </value> - <value> - <name>disc4_2</name> - <rename>disc4_2</rename> - <update>Y</update> - </value> - <value> - <name>disc4_3</name> - <rename>disc4_3</rename> - <update>Y</update> - </value> - <value> - <name>disc4_4</name> - <rename>disc4_4</rename> - <update>Y</update> - </value> - <value> - <name>disc4_5</name> - <rename>disc4_5</rename> - <update>Y</update> - </value> - <value> - <name>disc4_6</name> - <rename>disc4_6</rename> - <update>Y</update> - </value> - <value> - <name>disc4_7</name> - <rename>disc4_7</rename> - <update>Y</update> - </value> - <value> - <name>disc4_8</name> - <rename>disc4_8</rename> - <update>Y</update> - </value> - <value> - <name>disc5_1</name> - <rename>disc5_1</rename> - <update>Y</update> - </value> - <value> - <name>disc5_2</name> - <rename>disc5_2</rename> - <update>Y</update> - </value> - <value> - <name>disc5_3</name> - <rename>disc5_3</rename> - <update>Y</update> - </value> - <value> - <name>disc5_4</name> - <rename>disc5_4</rename> - <update>Y</update> - </value> - <value> - <name>disc5_5</name> - <rename>disc5_5</rename> - <update>Y</update> - </value> - <value> - <name>disc5_6</name> - <rename>disc5_6</rename> - <update>Y</update> - </value> - <value> - <name>disc5_7</name> - <rename>disc5_7</rename> - <update>Y</update> - </value> - <value> - <name>disc5_8</name> - <rename>disc5_8</rename> - <update>Y</update> - </value> - <value> - <name>item_code</name> - <rename>item_code</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_group6</name> - <rename>markup_group6</rename> - <update>Y</update> - </value> - <value> - <name>markup_group7</name> - <rename>markup_group7</rename> - <update>Y</update> - </value> - <value> - <name>markup_group8</name> - <rename>markup_group8</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_std6</name> - <rename>markup_std6</rename> - <update>Y</update> - </value> - <value> - <name>markup_std7</name> - <rename>markup_std7</rename> - <update>Y</update> - </value> - <value> - <name>markup_std8</name> - <rename>markup_std8</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_tier2_6</name> - <rename>markup_tier2_6</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier2_7</name> - <rename>markup_tier2_7</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier2_8</name> - <rename>markup_tier2_8</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>markup_tier3_6</name> - <rename>markup_tier3_6</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier3_7</name> - <rename>markup_tier3_7</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier3_8</name> - <rename>markup_tier3_8</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_1</name> - <rename>markup_tier4_1</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_2</name> - <rename>markup_tier4_2</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_3</name> - <rename>markup_tier4_3</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_4</name> - <rename>markup_tier4_4</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_5</name> - <rename>markup_tier4_5</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_6</name> - <rename>markup_tier4_6</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_7</name> - <rename>markup_tier4_7</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_8</name> - <rename>markup_tier4_8</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_1</name> - <rename>markup_tier5_1</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_2</name> - <rename>markup_tier5_2</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_3</name> - <rename>markup_tier5_3</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_4</name> - <rename>markup_tier5_4</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_5</name> - <rename>markup_tier5_5</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_6</name> - <rename>markup_tier5_6</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_7</name> - <rename>markup_tier5_7</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_8</name> - <rename>markup_tier5_8</rename> - <update>Y</update> - </value> - <value> - <name>name</name> - <rename>name</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_after_disc_6</name> - <rename>price_after_disc_6</rename> - <update>Y</update> - </value> - <value> - <name>price_after_disc_7</name> - <rename>price_after_disc_7</rename> - <update>Y</update> - </value> - <value> - <name>price_after_disc_8</name> - <rename>price_after_disc_8</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_before_disc6</name> - <rename>price_before_disc6</rename> - <update>Y</update> - </value> - <value> - <name>price_before_disc7</name> - <rename>price_before_disc7</rename> - <update>Y</update> - </value> - <value> - <name>price_before_disc8</name> - <rename>price_before_disc8</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_tier2_6</name> - <rename>price_tier2_6</rename> - <update>Y</update> - </value> - <value> - <name>price_tier2_7</name> - <rename>price_tier2_7</rename> - <update>Y</update> - </value> - <value> - <name>price_tier2_8</name> - <rename>price_tier2_8</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_tier3_6</name> - <rename>price_tier3_6</rename> - <update>Y</update> - </value> - <value> - <name>price_tier3_7</name> - <rename>price_tier3_7</rename> - <update>Y</update> - </value> - <value> - <name>price_tier3_8</name> - <rename>price_tier3_8</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_tier4_6</name> - <rename>price_tier4_6</rename> - <update>Y</update> - </value> - <value> - <name>price_tier4_7</name> - <rename>price_tier4_7</rename> - <update>Y</update> - </value> - <value> - <name>price_tier4_8</name> - <rename>price_tier4_8</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> - <value> - <name>price_tier5_6</name> - <rename>price_tier5_6</rename> - <update>Y</update> - </value> - <value> - <name>price_tier5_7</name> - <rename>price_tier5_7</rename> - <update>Y</update> - </value> - <value> - <name>price_tier5_8</name> - <rename>price_tier5_8</rename> - <update>Y</update> - </value> - <value> - <name>pricing_group</name> - <rename>pricing_group</rename> - <update>Y</update> - </value> - <value> - <name>product_id</name> - <rename>product_id</rename> - <update>N</update> - </value> - <value> - <name>purchase_price</name> - <rename>purchase_price</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>736</xloc> - <yloc>192</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>dw Insert / update zero</name> - <type>InsertUpdate</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>dw bi indoteknik (localhost)</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>disc1_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc1_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc1_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc1_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc1_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc1_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc1_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc1_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc2_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc2_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc2_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc2_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc2_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc2_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc2_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc2_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc3_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc3_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc3_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc3_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc3_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc3_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc3_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc3_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc4_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc4_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc4_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc4_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc4_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc4_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc4_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc4_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc5_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc5_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc5_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc5_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc5_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc5_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc5_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>disc5_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>item_code</name> - <rename>item_code</rename> - <update>Y</update> - </value> - <value> - <name>markup_group1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_group2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_group3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_group4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_group5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_group6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_group7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_group8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_std1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_std2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_std3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_std4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_std5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_std6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_std7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_std8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier2_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier2_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier2_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier2_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier2_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier2_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier2_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier2_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier3_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier3_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier3_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier3_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier3_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier3_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier3_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier3_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier4_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>markup_tier5_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>name</name> - <rename>name</rename> - <update>Y</update> - </value> - <value> - <name>price_after_disc_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_after_disc_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_after_disc_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_after_disc_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_after_disc_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_after_disc_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_after_disc_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_after_disc_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_before_disc1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_before_disc2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_before_disc3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_before_disc4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_before_disc5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_before_disc6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_before_disc7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_before_disc8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier2_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier2_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier2_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier2_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier2_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier2_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier2_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier2_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier3_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier3_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier3_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier3_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier3_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier3_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier3_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier3_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier4_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier4_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier4_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier4_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier4_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier4_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier4_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier4_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier5_1</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier5_2</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier5_3</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier5_4</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier5_5</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier5_6</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier5_7</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>price_tier5_8</name> - <rename>zero</rename> - <update>Y</update> - </value> - <value> - <name>pricing_group</name> - <rename>pricing_group</rename> - <update>Y</update> - </value> - <value> - <name>product_id</name> - <rename>product_id</rename> - <update>N</update> - </value> - <value> - <name>purchase_price</name> - <rename>zero</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>240</xloc> - <yloc>304</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -4253,7 +2762,7 @@ left join brand b on b.id = p.brand_id</sql> </GUI> </step> <step> - <name>calculate price after disc</name> + <name>calculate price tier</name> <type>Calculator</type> <description/> <distribute>Y</distribute> @@ -4265,10 +2774,10 @@ left join brand b on b.id = p.brand_id</sql> </partitioning> <failIfNoFile>Y</failIfNoFile> <calculation> - <field_name>price_after_disc_1</field_name> + <field_name>price_before_disc1</field_name> <calc_type>PERCENT_3</calc_type> <field_a>purchase_price</field_a> - <field_b>markup_std1</field_b> + <field_b>markup_group1</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4280,10 +2789,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_after_disc_2</field_name> + <field_name>price_before_disc2</field_name> <calc_type>PERCENT_3</calc_type> <field_a>purchase_price</field_a> - <field_b>markup_std2</field_b> + <field_b>markup_group2</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4295,10 +2804,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_after_disc_3</field_name> + <field_name>price_before_disc3</field_name> <calc_type>PERCENT_3</calc_type> <field_a>purchase_price</field_a> - <field_b>markup_std3</field_b> + <field_b>markup_group3</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4310,10 +2819,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_after_disc_4</field_name> + <field_name>price_before_disc4</field_name> <calc_type>PERCENT_3</calc_type> <field_a>purchase_price</field_a> - <field_b>markup_std4</field_b> + <field_b>markup_group4</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4325,10 +2834,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_after_disc_5</field_name> + <field_name>price_before_disc5</field_name> <calc_type>PERCENT_3</calc_type> <field_a>purchase_price</field_a> - <field_b>markup_std5</field_b> + <field_b>markup_group5</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4340,10 +2849,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_after_disc_6</field_name> + <field_name>price_before_disc6</field_name> <calc_type>PERCENT_3</calc_type> <field_a>purchase_price</field_a> - <field_b>markup_std6</field_b> + <field_b>markup_group6</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4355,10 +2864,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_after_disc_7</field_name> + <field_name>price_before_disc7</field_name> <calc_type>PERCENT_3</calc_type> <field_a>purchase_price</field_a> - <field_b>markup_std7</field_b> + <field_b>markup_group7</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4370,10 +2879,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_after_disc_8</field_name> + <field_name>price_before_disc8</field_name> <calc_type>PERCENT_3</calc_type> <field_a>purchase_price</field_a> - <field_b>markup_std8</field_b> + <field_b>markup_group8</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4384,37 +2893,11 @@ left join brand b on b.id = p.brand_id</sql> <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>calculate price tier</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> + <field_name>price_after_disc_1</field_name> <calc_type>PERCENT_3</calc_type> - <field_a>price_after_disc_1</field_a> - <field_b>markup_group1</field_b> + <field_a>purchase_price</field_a> + <field_b>markup_std1</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4426,10 +2909,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_before_disc2</field_name> + <field_name>price_after_disc_2</field_name> <calc_type>PERCENT_3</calc_type> - <field_a>price_after_disc_2</field_a> - <field_b>markup_group2</field_b> + <field_a>purchase_price</field_a> + <field_b>markup_std2</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4441,10 +2924,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_before_disc3</field_name> + <field_name>price_after_disc_3</field_name> <calc_type>PERCENT_3</calc_type> - <field_a>price_after_disc_3</field_a> - <field_b>markup_group3</field_b> + <field_a>purchase_price</field_a> + <field_b>markup_std3</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4456,10 +2939,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_before_disc4</field_name> + <field_name>price_after_disc_4</field_name> <calc_type>PERCENT_3</calc_type> - <field_a>price_after_disc_4</field_a> - <field_b>markup_group4</field_b> + <field_a>purchase_price</field_a> + <field_b>markup_std4</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4471,10 +2954,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_before_disc5</field_name> + <field_name>price_after_disc_5</field_name> <calc_type>PERCENT_3</calc_type> - <field_a>price_after_disc_5</field_a> - <field_b>markup_group5</field_b> + <field_a>purchase_price</field_a> + <field_b>markup_std5</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4486,10 +2969,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_before_disc6</field_name> + <field_name>price_after_disc_6</field_name> <calc_type>PERCENT_3</calc_type> - <field_a>price_after_disc_6</field_a> - <field_b>markup_group6</field_b> + <field_a>purchase_price</field_a> + <field_b>markup_std6</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4501,10 +2984,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_before_disc7</field_name> + <field_name>price_after_disc_7</field_name> <calc_type>PERCENT_3</calc_type> - <field_a>price_after_disc_7</field_a> - <field_b>markup_group7</field_b> + <field_a>purchase_price</field_a> + <field_b>markup_std7</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -4516,10 +2999,10 @@ left join brand b on b.id = p.brand_id</sql> <currency_symbol/> </calculation> <calculation> - <field_name>price_before_disc8</field_name> + <field_name>price_after_disc_8</field_name> <calc_type>PERCENT_3</calc_type> - <field_a>price_after_disc_8</field_a> - <field_b>markup_group8</field_b> + <field_a>purchase_price</field_a> + <field_b>markup_std8</field_b> <field_c/> <value_type>Number</value_type> <value_length>-1</value_length> @@ -5019,11 +3502,1497 @@ left join brand b on b.id = p.brand_id</sql> </output> </remotesteps> <GUI> - <xloc>544</xloc> + <xloc>384</xloc> <yloc>64</yloc> <draw>Y</draw> </GUI> </step> + <step> + <name>dw Insert / update calc pl</name> + <type>InsertUpdate</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</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>disc1_1</name> + <rename>disc1_1</rename> + <update>Y</update> + </value> + <value> + <name>disc1_2</name> + <rename>disc1_2</rename> + <update>Y</update> + </value> + <value> + <name>disc1_3</name> + <rename>disc1_3</rename> + <update>Y</update> + </value> + <value> + <name>disc1_4</name> + <rename>disc1_4</rename> + <update>Y</update> + </value> + <value> + <name>disc1_5</name> + <rename>disc1_5</rename> + <update>Y</update> + </value> + <value> + <name>disc1_6</name> + <rename>disc1_6</rename> + <update>Y</update> + </value> + <value> + <name>disc1_7</name> + <rename>disc1_7</rename> + <update>Y</update> + </value> + <value> + <name>disc1_8</name> + <rename>disc1_8</rename> + <update>Y</update> + </value> + <value> + <name>disc2_1</name> + <rename>disc2_1</rename> + <update>Y</update> + </value> + <value> + <name>disc2_2</name> + <rename>disc2_2</rename> + <update>Y</update> + </value> + <value> + <name>disc2_3</name> + <rename>disc2_3</rename> + <update>Y</update> + </value> + <value> + <name>disc2_4</name> + <rename>disc2_4</rename> + <update>Y</update> + </value> + <value> + <name>disc2_5</name> + <rename>disc2_5</rename> + <update>Y</update> + </value> + <value> + <name>disc2_6</name> + <rename>disc2_6</rename> + <update>Y</update> + </value> + <value> + <name>disc2_7</name> + <rename>disc2_7</rename> + <update>Y</update> + </value> + <value> + <name>disc2_8</name> + <rename>disc2_8</rename> + <update>Y</update> + </value> + <value> + <name>disc3_1</name> + <rename>disc3_1</rename> + <update>Y</update> + </value> + <value> + <name>disc3_2</name> + <rename>disc3_2</rename> + <update>Y</update> + </value> + <value> + <name>disc3_3</name> + <rename>disc3_3</rename> + <update>Y</update> + </value> + <value> + <name>disc3_4</name> + <rename>disc3_4</rename> + <update>Y</update> + </value> + <value> + <name>disc3_5</name> + <rename>disc3_5</rename> + <update>Y</update> + </value> + <value> + <name>disc3_6</name> + <rename>disc3_6</rename> + <update>Y</update> + </value> + <value> + <name>disc3_7</name> + <rename>disc3_7</rename> + <update>Y</update> + </value> + <value> + <name>disc3_8</name> + <rename>disc3_8</rename> + <update>Y</update> + </value> + <value> + <name>disc4_1</name> + <rename>disc4_1</rename> + <update>Y</update> + </value> + <value> + <name>disc4_2</name> + <rename>disc4_2</rename> + <update>Y</update> + </value> + <value> + <name>disc4_3</name> + <rename>disc4_3</rename> + <update>Y</update> + </value> + <value> + <name>disc4_4</name> + <rename>disc4_4</rename> + <update>Y</update> + </value> + <value> + <name>disc4_5</name> + <rename>disc4_5</rename> + <update>Y</update> + </value> + <value> + <name>disc4_6</name> + <rename>disc4_6</rename> + <update>Y</update> + </value> + <value> + <name>disc4_7</name> + <rename>disc4_7</rename> + <update>Y</update> + </value> + <value> + <name>disc4_8</name> + <rename>disc4_8</rename> + <update>Y</update> + </value> + <value> + <name>disc5_1</name> + <rename>disc5_1</rename> + <update>Y</update> + </value> + <value> + <name>disc5_2</name> + <rename>disc5_2</rename> + <update>Y</update> + </value> + <value> + <name>disc5_3</name> + <rename>disc5_3</rename> + <update>Y</update> + </value> + <value> + <name>disc5_4</name> + <rename>disc5_4</rename> + <update>Y</update> + </value> + <value> + <name>disc5_5</name> + <rename>disc5_5</rename> + <update>Y</update> + </value> + <value> + <name>disc5_6</name> + <rename>disc5_6</rename> + <update>Y</update> + </value> + <value> + <name>disc5_7</name> + <rename>disc5_7</rename> + <update>Y</update> + </value> + <value> + <name>disc5_8</name> + <rename>disc5_8</rename> + <update>Y</update> + </value> + <value> + <name>item_code</name> + <rename>item_code</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_group6</name> + <rename>markup_group6</rename> + <update>Y</update> + </value> + <value> + <name>markup_group7</name> + <rename>markup_group7</rename> + <update>Y</update> + </value> + <value> + <name>markup_group8</name> + <rename>markup_group8</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_std6</name> + <rename>markup_std6</rename> + <update>Y</update> + </value> + <value> + <name>markup_std7</name> + <rename>markup_std7</rename> + <update>Y</update> + </value> + <value> + <name>markup_std8</name> + <rename>markup_std8</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_tier2_6</name> + <rename>markup_tier2_6</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier2_7</name> + <rename>markup_tier2_7</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier2_8</name> + <rename>markup_tier2_8</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>markup_tier3_6</name> + <rename>markup_tier3_6</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_7</name> + <rename>markup_tier3_7</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_8</name> + <rename>markup_tier3_8</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_1</name> + <rename>markup_tier4_1</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_2</name> + <rename>markup_tier4_2</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_3</name> + <rename>markup_tier4_3</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_4</name> + <rename>markup_tier4_4</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_5</name> + <rename>markup_tier4_5</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_6</name> + <rename>markup_tier4_6</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_7</name> + <rename>markup_tier4_7</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_8</name> + <rename>markup_tier4_8</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_1</name> + <rename>markup_tier5_1</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_2</name> + <rename>markup_tier5_2</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_3</name> + <rename>markup_tier5_3</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_4</name> + <rename>markup_tier5_4</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_5</name> + <rename>markup_tier5_5</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_6</name> + <rename>markup_tier5_6</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_7</name> + <rename>markup_tier5_7</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_8</name> + <rename>markup_tier5_8</rename> + <update>Y</update> + </value> + <value> + <name>name</name> + <rename>name</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_after_disc_6</name> + <rename>price_after_disc_6</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_7</name> + <rename>price_after_disc_7</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_8</name> + <rename>price_after_disc_8</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_before_disc6</name> + <rename>price_before_disc6</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc7</name> + <rename>price_before_disc7</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc8</name> + <rename>price_before_disc8</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_tier2_6</name> + <rename>price_tier2_6</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_7</name> + <rename>price_tier2_7</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_8</name> + <rename>price_tier2_8</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_tier3_6</name> + <rename>price_tier3_6</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_7</name> + <rename>price_tier3_7</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_8</name> + <rename>price_tier3_8</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_tier4_6</name> + <rename>price_tier4_6</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_7</name> + <rename>price_tier4_7</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_8</name> + <rename>price_tier4_8</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> + <value> + <name>price_tier5_6</name> + <rename>price_tier5_6</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_7</name> + <rename>price_tier5_7</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_8</name> + <rename>price_tier5_8</rename> + <update>Y</update> + </value> + <value> + <name>pricing_group</name> + <rename>pricing_group</rename> + <update>Y</update> + </value> + <value> + <name>product_id</name> + <rename>product_id</rename> + <update>N</update> + </value> + <value> + <name>purchase_price</name> + <rename>purchase_price</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>736</xloc> + <yloc>192</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>dw Insert / update zero</name> + <type>InsertUpdate</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</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>disc1_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc1_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc1_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc1_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc1_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc1_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc1_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc1_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc2_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc2_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc2_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc2_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc2_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc2_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc2_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc2_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc3_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc3_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc3_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc3_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc3_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc3_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc3_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc3_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc4_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc4_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc4_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc4_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc4_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc4_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc4_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc4_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc5_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc5_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc5_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc5_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc5_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc5_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc5_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>disc5_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>item_code</name> + <rename>item_code</rename> + <update>Y</update> + </value> + <value> + <name>markup_group1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_group2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_group3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_group4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_group5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_group6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_group7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_group8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_std1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_std2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_std3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_std4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_std5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_std6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_std7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_std8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier2_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier2_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier2_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier2_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier2_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier2_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier2_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier2_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier3_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier4_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>markup_tier5_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>name</name> + <rename>name</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_after_disc_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_before_disc8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier2_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier3_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier4_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_1</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_2</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_3</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_4</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_5</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_6</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_7</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>price_tier5_8</name> + <rename>zero</rename> + <update>Y</update> + </value> + <value> + <name>pricing_group</name> + <rename>pricing_group</rename> + <update>Y</update> + </value> + <value> + <name>product_id</name> + <rename>product_id</rename> + <update>N</update> + </value> + <value> + <name>purchase_price</name> + <rename>zero</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>240</xloc> + <yloc>304</yloc> + <draw>Y</draw> + </GUI> + </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |