diff options
Diffstat (limited to 'calculate_price_after_disc.ktr')
| -rw-r--r-- | calculate_price_after_disc.ktr | 1446 |
1 files changed, 828 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> |