diff options
Diffstat (limited to 'calculate_price_after_disc.ktr')
| -rw-r--r-- | calculate_price_after_disc.ktr | 1974 |
1 files changed, 987 insertions, 987 deletions
diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr index d96c01e..7b13e71 100644 --- a/calculate_price_after_disc.ktr +++ b/calculate_price_after_disc.ktr @@ -529,8 +529,8 @@ </hop> </order> <step> - <name>calculate price after disc</name> - <type>Calculator</type> + <name>Add constants</name> + <type>Constant</type> <description/> <distribute>Y</distribute> <custom_distribution/> @@ -539,82 +539,20 @@ <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> + <fields> + <field> + <name>zero</name> + <type>Number</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>0</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + </fields> <attributes/> <cluster_schema/> <remotesteps> @@ -624,14 +562,14 @@ </output> </remotesteps> <GUI> - <xloc>384</xloc> - <yloc>64</yloc> + <xloc>240</xloc> + <yloc>192</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>calculate price tier</name> - <type>Calculator</type> + <name>Filter rows</name> + <type>FilterRows</type> <description/> <distribute>Y</distribute> <custom_distribution/> @@ -640,382 +578,25 @@ <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> + <send_true_to>calculate price after disc</send_true_to> + <send_false_to>Add constants</send_false_to> + <compare> + <condition> + <negated>N</negated> + <leftvalue>purchase_price</leftvalue> + <function>></function> + <rightvalue/> + <value> + <name>constant</name> + <type>BigNumber</type> + <text>0.0</text> + <length>-1</length> + <precision>-1</precision> + <isnull>N</isnull> + <mask>######0.0###################;-######0.0###################</mask> + </value> + </condition> + </compare> <attributes/> <cluster_schema/> <remotesteps> @@ -1025,7 +606,7 @@ </output> </remotesteps> <GUI> - <xloc>544</xloc> + <xloc>240</xloc> <yloc>64</yloc> <draw>Y</draw> </GUI> @@ -1519,6 +1100,494 @@ </GUI> </step> <step> + <name>Insert / update 2</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>pricing_group</name> + <rename>pricing_group</rename> + <update>Y</update> + </value> + <value> + <name>purchase_price</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_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_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_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_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_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>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_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_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_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_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_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>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>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>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>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>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> + </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/> @@ -3206,8 +3275,8 @@ left join brand b on b.id = p.brand_id</sql> </GUI> </step> <step> - <name>Filter rows</name> - <type>FilterRows</type> + <name>calculate price after disc</name> + <type>Calculator</type> <description/> <distribute>Y</distribute> <custom_distribution/> @@ -3216,25 +3285,82 @@ left join brand b on b.id = p.brand_id</sql> <method>none</method> <schema_name/> </partitioning> - <send_true_to>calculate price after disc</send_true_to> - <send_false_to>Add constants</send_false_to> - <compare> - <condition> - <negated>N</negated> - <leftvalue>purchase_price</leftvalue> - <function>></function> - <rightvalue/> - <value> - <name>constant</name> - <type>BigNumber</type> - <text>0.0</text> - <length>-1</length> - <precision>-1</precision> - <isnull>N</isnull> - <mask>######0.0###################;-######0.0###################</mask> - </value> - </condition> - </compare> + <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> @@ -3244,53 +3370,14 @@ left join brand b on b.id = p.brand_id</sql> </output> </remotesteps> <GUI> - <xloc>240</xloc> + <xloc>384</xloc> <yloc>64</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>Add constants</name> - <type>Constant</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>zero</name> - <type>Number</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>0</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>240</xloc> - <yloc>192</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Insert / update 2</name> - <type>InsertUpdate</type> + <name>calculate price tier</name> + <type>Calculator</type> <description/> <distribute>Y</distribute> <custom_distribution/> @@ -3299,469 +3386,382 @@ left join brand b on b.id = p.brand_id</sql> <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>pricing_group</name> - <rename>pricing_group</rename> - <update>Y</update> - </value> - <value> - <name>purchase_price</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_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_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_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_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_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>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_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_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_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_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_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>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>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>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>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>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> - </lookup> + <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> @@ -3771,8 +3771,8 @@ left join brand b on b.id = p.brand_id</sql> </output> </remotesteps> <GUI> - <xloc>240</xloc> - <yloc>304</yloc> + <xloc>544</xloc> + <yloc>64</yloc> <draw>Y</draw> </GUI> </step> |