calculate_price_after_disc Normal / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2023/08/22 11:11:06.045 - 2023/08/22 11:11:06.045 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N dw bi indoteknik (localhost) localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER 5432 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE N USE_POOLING N calculate price tier calculate diff Y Table input Filter rows Y Filter rows Add constants Y Add constants dw Insert / update zero Y Filter rows calculate price tier Y calculate diff calculate discount Y calculate discount dw Insert / update calc pl Y Add constants Constant Y 1 none zero Number 0 -1 -1 N

240 192 Y Filter rows FilterRows Y 1 none calculate price tier Add constants N purchase_price > constant BigNumber 0.0 -1 -1 N ######0.0###################;-######0.0###################

240 64 Y Table input TableInput Y 1 none dw bi indoteknik (localhost) select p.product_id, p.item_code, p.name, b.pricing_group, coalesce(( select ppd.include_price as purchase_price from purchase_pricelist_dw ppd join product p2 on p2.product_id = ppd.product_id where ppd.product_id = p.product_id and (system_last_update >= (now() - '365 days'::interval) or human_last_update >= (now() - '365 days'::interval) or p2.qty_available > 0) order by ppd.count_brand_vendor desc, ppd.count_trx_po desc, ppd.count_trx_po_vendor desc limit 1 ),0) as purchase_price, coalesce(( select rp.name as vendor from purchase_pricelist_dw ppd join product p2 on p2.product_id = ppd.product_id join res_partner rp on rp.id = ppd.vendor_id where ppd.product_id = p.product_id and (system_last_update >= (now() - '365 days'::interval) or human_last_update >= (now() - '365 days'::interval) or p2.qty_available > 0) order by ppd.count_brand_vendor desc, ppd.count_trx_po desc, ppd.count_trx_po_vendor desc limit 1 ),'-') as vendor, coalesce(( select ppd.vendor_id as vendor_id from purchase_pricelist_dw ppd join product p2 on p2.product_id = ppd.product_id where ppd.product_id = p.product_id and (system_last_update >= (now() - '365 days'::interval) or human_last_update >= (now() - '365 days'::interval) or p2.qty_available > 0) order by ppd.count_brand_vendor desc, ppd.count_trx_po desc, ppd.count_trx_po_vendor desc limit 1 ),0) as vendor_id, (select group1 from price_group_dw pgd where id = 2) as markup_std1, (select group2 from price_group_dw pgd where id = 2) as markup_std2, (select group3 from price_group_dw pgd where id = 2) as markup_std3, (select group4 from price_group_dw pgd where id = 2) as markup_std4, (select group5 from price_group_dw pgd where id = 2) as markup_std5, (select group6 from price_group_dw pgd where id = 2) as markup_std6, (select group7 from price_group_dw pgd where id = 2) as markup_std7, (select group8 from price_group_dw pgd where id = 2) as markup_std8, (select group9 from price_group_dw pgd where id = 2) as markup_std9,--new (select group10 from price_group_dw pgd where id = 2) as markup_std10,--new (select group1 from price_group_dw pgd where id = 1) as markup_group1, (select group2 from price_group_dw pgd where id = 1) as markup_group2, (select group3 from price_group_dw pgd where id = 1) as markup_group3, (select group4 from price_group_dw pgd where id = 1) as markup_group4, (select group5 from price_group_dw pgd where id = 1) as markup_group5, (select group6 from price_group_dw pgd where id = 1) as markup_group6, (select group7 from price_group_dw pgd where id = 1) as markup_group7, (select group8 from price_group_dw pgd where id = 1) as markup_group8, (select group9 from price_group_dw pgd where id = 1) as markup_group9,--new (select group10 from price_group_dw pgd where id = 1) as markup_group10,--new (select group1 from price_group_dw pgd where id = 3) as markup_tier2_1, (select group2 from price_group_dw pgd where id = 3) as markup_tier2_2, (select group3 from price_group_dw pgd where id = 3) as markup_tier2_3, (select group4 from price_group_dw pgd where id = 3) as markup_tier2_4, (select group5 from price_group_dw pgd where id = 3) as markup_tier2_5, (select group6 from price_group_dw pgd where id = 3) as markup_tier2_6, (select group7 from price_group_dw pgd where id = 3) as markup_tier2_7, (select group8 from price_group_dw pgd where id = 3) as markup_tier2_8, (select group9 from price_group_dw pgd where id = 3) as markup_tier2_9,--new (select group10 from price_group_dw pgd where id = 3) as markup_tier2_10,--new (select group1 from price_group_dw pgd where id = 4) as markup_tier3_1, (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 group6 from price_group_dw pgd where id = 4) as markup_tier3_6, (select group7 from price_group_dw pgd where id = 4) as markup_tier3_7, (select group8 from price_group_dw pgd where id = 4) as markup_tier3_8, (select group9 from price_group_dw pgd where id = 4) as markup_tier3_9,--new (select group10 from price_group_dw pgd where id = 4) as markup_tier3_10,--new (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 group6 from price_group_dw pgd where id = 5) as markup_tier4_6, (select group7 from price_group_dw pgd where id = 5) as markup_tier4_7, (select group8 from price_group_dw pgd where id = 5) as markup_tier4_8, (select group9 from price_group_dw pgd where id = 5) as markup_tier4_9,--new (select group10 from price_group_dw pgd where id = 5) as markup_tier4_10,--new (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, (select group6 from price_group_dw pgd where id = 6) as markup_tier5_6, (select group7 from price_group_dw pgd where id = 6) as markup_tier5_7, (select group8 from price_group_dw pgd where id = 6) as markup_tier5_8, (select group9 from price_group_dw pgd where id = 6) as markup_tier5_9,--new (select group10 from price_group_dw pgd where id = 6) as markup_tier5_10--new from product p left join brand b on b.id = p.brand_id 0 N N N N Integer normal product_id 9 0 Table input product_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal item_code 2147483647 -1 Table input item_code . , none N Y 0 N N N en_US Asia/Bangkok N String normal name 2147483647 -1 Table input name . , none N Y 0 N N N en_US Asia/Bangkok N String normal pricing_group 2147483647 -1 Table input pricing_group . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal purchase_price -1 -1 Table input purchase_price ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N String normal vendor 2147483647 -1 Table input vendor . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal vendor_id 9 0 Table input vendor_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std1 -1 -1 Table input markup_std1 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std2 -1 -1 Table input markup_std2 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std3 -1 -1 Table input markup_std3 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std4 -1 -1 Table input markup_std4 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std5 -1 -1 Table input markup_std5 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std6 -1 -1 Table input markup_std6 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std7 -1 -1 Table input markup_std7 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std8 -1 -1 Table input markup_std8 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std9 -1 -1 Table input markup_std9 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std10 -1 -1 Table input markup_std10 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group1 -1 -1 Table input markup_group1 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group2 -1 -1 Table input markup_group2 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group3 -1 -1 Table input markup_group3 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group4 -1 -1 Table input markup_group4 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group5 -1 -1 Table input markup_group5 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group6 -1 -1 Table input markup_group6 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group7 -1 -1 Table input markup_group7 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group8 -1 -1 Table input markup_group8 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group9 -1 -1 Table input markup_group9 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group10 -1 -1 Table input markup_group10 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_1 -1 -1 Table input markup_tier2_1 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_2 -1 -1 Table input markup_tier2_2 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_3 -1 -1 Table input markup_tier2_3 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_4 -1 -1 Table input markup_tier2_4 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_5 -1 -1 Table input markup_tier2_5 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_6 -1 -1 Table input markup_tier2_6 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_7 -1 -1 Table input markup_tier2_7 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_8 -1 -1 Table input markup_tier2_8 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_9 -1 -1 Table input markup_tier2_9 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_10 -1 -1 Table input markup_tier2_10 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_1 -1 -1 Table input markup_tier3_1 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_2 -1 -1 Table input markup_tier3_2 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_3 -1 -1 Table input markup_tier3_3 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_4 -1 -1 Table input markup_tier3_4 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_5 -1 -1 Table input markup_tier3_5 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_6 -1 -1 Table input markup_tier3_6 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_7 -1 -1 Table input markup_tier3_7 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_8 -1 -1 Table input markup_tier3_8 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_9 -1 -1 Table input markup_tier3_9 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_10 -1 -1 Table input markup_tier3_10 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier4_1 -1 -1 Table input markup_tier4_1 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier4_2 -1 -1 Table input markup_tier4_2 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier4_3 -1 -1 Table input markup_tier4_3 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier4_4 -1 -1 Table input markup_tier4_4 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier4_5 -1 -1 Table input markup_tier4_5 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier4_6 -1 -1 Table input markup_tier4_6 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier4_7 -1 -1 Table input markup_tier4_7 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier4_8 -1 -1 Table input markup_tier4_8 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier4_9 -1 -1 Table input markup_tier4_9 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier4_10 -1 -1 Table input markup_tier4_10 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier5_1 -1 -1 Table input markup_tier5_1 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier5_2 -1 -1 Table input markup_tier5_2 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier5_3 -1 -1 Table input markup_tier5_3 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier5_4 -1 -1 Table input markup_tier5_4 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier5_5 -1 -1 Table input markup_tier5_5 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier5_6 -1 -1 Table input markup_tier5_6 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier5_7 -1 -1 Table input markup_tier5_7 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier5_8 -1 -1 Table input markup_tier5_8 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier5_9 -1 -1 Table input markup_tier5_9 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier5_10 -1 -1 Table input markup_tier5_10 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N

112 64 Y calculate diff Calculator Y 1 none Y diff1_1 SUBTRACT price_before_disc1 price_after_disc_1 None -1 -1 N diff1_10 SUBTRACT price_before_disc10 price_after_disc_10 None -1 -1 N diff1_2 SUBTRACT price_before_disc2 price_after_disc_2 None -1 -1 N diff1_3 SUBTRACT price_before_disc3 price_after_disc_3 None -1 -1 N diff1_4 SUBTRACT price_before_disc4 price_after_disc_4 None -1 -1 N diff1_5 SUBTRACT price_before_disc5 price_after_disc_5 None -1 -1 N diff1_6 SUBTRACT price_before_disc6 price_after_disc_6 None -1 -1 N diff1_7 SUBTRACT price_before_disc7 price_after_disc_7 None -1 -1 N diff1_8 SUBTRACT price_before_disc8 price_after_disc_8 None -1 -1 N diff1_9 SUBTRACT price_before_disc9 price_after_disc_9 None -1 -1 N diff2_1 SUBTRACT price_before_disc1 price_tier2_1 None -1 -1 N diff2_10 SUBTRACT price_before_disc10 price_tier2_10 None -1 -1 N diff2_2 SUBTRACT price_before_disc2 price_tier2_2 None -1 -1 N diff2_3 SUBTRACT price_before_disc3 price_tier2_3 None -1 -1 N diff2_4 SUBTRACT price_before_disc4 price_tier2_4 None -1 -1 N diff2_5 SUBTRACT price_before_disc5 price_tier2_5 None -1 -1 N diff2_6 SUBTRACT price_before_disc6 price_tier2_6 None -1 -1 N diff2_7 SUBTRACT price_before_disc7 price_tier2_7 None -1 -1 N diff2_8 SUBTRACT price_before_disc8 price_tier2_8 None -1 -1 N diff2_9 SUBTRACT price_before_disc9 price_tier2_9 None -1 -1 N diff3_1 SUBTRACT price_before_disc1 price_tier3_1 None -1 -1 N diff3_10 SUBTRACT price_before_disc10 price_tier3_10 None -1 -1 N diff3_2 SUBTRACT price_before_disc2 price_tier3_2 None -1 -1 N diff3_3 SUBTRACT price_before_disc3 price_tier3_3 None -1 -1 N diff3_4 SUBTRACT price_before_disc4 price_tier3_4 None -1 -1 N diff3_5 SUBTRACT price_before_disc5 price_tier3_5 None -1 -1 N diff3_6 SUBTRACT price_before_disc6 price_tier3_6 None -1 -1 N diff3_7 SUBTRACT price_before_disc7 price_tier3_7 None -1 -1 N diff3_8 SUBTRACT price_before_disc8 price_tier3_8 None -1 -1 N diff3_9 SUBTRACT price_before_disc9 price_tier3_9 None -1 -1 N diff4_1 SUBTRACT price_before_disc1 price_tier4_1 None -1 -1 N diff4_10 SUBTRACT price_before_disc10 price_tier4_10 None -1 -1 N diff4_2 SUBTRACT price_before_disc2 price_tier4_2 None -1 -1 N diff4_3 SUBTRACT price_before_disc3 price_tier4_3 None -1 -1 N diff4_4 SUBTRACT price_before_disc4 price_tier4_4 None -1 -1 N diff4_5 SUBTRACT price_before_disc5 price_tier4_5 None -1 -1 N diff4_6 SUBTRACT price_before_disc6 price_tier4_6 None -1 -1 N diff4_7 SUBTRACT price_before_disc7 price_tier4_7 None -1 -1 N diff4_8 SUBTRACT price_before_disc8 price_tier4_8 None -1 -1 N diff4_9 SUBTRACT price_before_disc9 price_tier4_9 None -1 -1 N diff5_1 SUBTRACT price_before_disc1 price_tier5_1 None -1 -1 N diff5_10 SUBTRACT price_before_disc10 price_tier5_10 None -1 -1 N diff5_2 SUBTRACT price_before_disc2 price_tier5_2 None -1 -1 N diff5_3 SUBTRACT price_before_disc3 price_tier5_3 None -1 -1 N diff5_4 SUBTRACT price_before_disc4 price_tier5_4 None -1 -1 N diff5_5 SUBTRACT price_before_disc5 price_tier5_5 None -1 -1 N diff5_6 SUBTRACT price_before_disc6 price_tier5_6 None -1 -1 N diff5_7 SUBTRACT price_before_disc7 price_tier5_7 None -1 -1 N diff5_8 SUBTRACT price_before_disc8 price_tier5_8 None -1 -1 N diff5_9 SUBTRACT price_before_disc9 price_tier5_9 None -1 -1 N

384 192 Y calculate discount Calculator Y 1 none Y disc1_1 PERCENT_1 diff1_1 price_before_disc1 Number -1 -1 N disc1_2 PERCENT_1 diff1_2 price_before_disc2 Number -1 -1 N disc1_3 PERCENT_1 diff1_3 price_before_disc3 Number -1 -1 N disc1_4 PERCENT_1 diff1_4 price_before_disc4 Number -1 -1 N disc1_5 PERCENT_1 diff1_5 price_before_disc5 Number -1 -1 N disc1_6 PERCENT_1 diff1_6 price_before_disc6 Number -1 -1 N disc1_7 PERCENT_1 diff1_7 price_before_disc7 Number -1 -1 N disc1_8 PERCENT_1 diff1_8 price_before_disc8 Number -1 -1 N disc1_9 PERCENT_1 diff1_9 price_before_disc9 Number -1 -1 N disc1_10 PERCENT_1 diff1_10 price_before_disc10 Number -1 -1 N disc2_1 PERCENT_1 diff2_1 price_before_disc1 Number -1 -1 N disc2_2 PERCENT_1 diff2_2 price_before_disc2 Number -1 -1 N disc2_3 PERCENT_1 diff2_3 price_before_disc3 Number -1 -1 N disc2_4 PERCENT_1 diff2_4 price_before_disc4 Number -1 -1 N disc2_5 PERCENT_1 diff2_5 price_before_disc5 Number -1 -1 N disc2_6 PERCENT_1 diff2_6 price_before_disc6 Number -1 -1 N disc2_7 PERCENT_1 diff2_7 price_before_disc7 Number -1 -1 N disc2_8 PERCENT_1 diff2_8 price_before_disc8 Number -1 -1 N disc2_9 PERCENT_1 diff2_9 price_before_disc9 Number -1 -1 N disc2_10 PERCENT_1 diff2_10 price_before_disc10 Number -1 -1 N disc3_1 PERCENT_1 diff3_1 price_before_disc1 Number -1 -1 N disc3_2 PERCENT_1 diff3_2 price_before_disc2 Number -1 -1 N disc3_3 PERCENT_1 diff3_3 price_before_disc3 Number -1 -1 N disc3_4 PERCENT_1 diff3_4 price_before_disc4 Number -1 -1 N disc3_5 PERCENT_1 diff3_5 price_before_disc5 Number -1 -1 N disc3_6 PERCENT_1 diff3_6 price_before_disc6 Number -1 -1 N disc3_7 PERCENT_1 diff3_7 price_before_disc7 Number -1 -1 N disc3_8 PERCENT_1 diff3_8 price_before_disc8 Number -1 -1 N disc3_9 PERCENT_1 diff3_9 price_before_disc9 Number -1 -1 N disc3_10 PERCENT_1 diff3_10 price_before_disc10 Number -1 -1 N disc4_1 PERCENT_1 diff4_1 price_before_disc1 Number -1 -1 N disc4_2 PERCENT_1 diff4_2 price_before_disc2 Number -1 -1 N disc4_3 PERCENT_1 diff4_3 price_before_disc3 Number -1 -1 N disc4_4 PERCENT_1 diff4_4 price_before_disc4 Number -1 -1 N disc4_5 PERCENT_1 diff4_5 price_before_disc5 Number -1 -1 N disc4_6 PERCENT_1 diff4_6 price_before_disc6 Number -1 -1 N disc4_7 PERCENT_1 diff4_7 price_before_disc7 Number -1 -1 N disc4_8 PERCENT_1 diff4_8 price_before_disc8 Number -1 -1 N disc4_9 PERCENT_1 diff4_9 price_before_disc9 Number -1 -1 N disc4_10 PERCENT_1 diff4_10 price_before_disc10 Number -1 -1 N disc5_1 PERCENT_1 diff5_1 price_before_disc1 Number -1 -1 N disc5_2 PERCENT_1 diff5_2 price_before_disc2 Number -1 -1 N disc5_3 PERCENT_1 diff5_3 price_before_disc3 Number -1 -1 N disc5_4 PERCENT_1 diff5_4 price_before_disc4 Number -1 -1 N disc5_5 PERCENT_1 diff5_5 price_before_disc5 Number -1 -1 N disc5_6 PERCENT_1 diff5_6 price_before_disc6 Number -1 -1 N disc5_7 PERCENT_1 diff5_7 price_before_disc7 Number -1 -1 N disc5_8 PERCENT_1 diff5_8 price_before_disc8 Number -1 -1 N disc5_9 PERCENT_1 diff5_9 price_before_disc9 Number -1 -1 N disc5_10 PERCENT_1 diff5_10 price_before_disc10 Number -1 -1 N

544 192 Y calculate price tier Calculator Y 1 none Y price_before_disc1 PERCENT_3 purchase_price markup_group1 Number -1 -1 N price_before_disc2 PERCENT_3 purchase_price markup_group2 Number -1 -1 N price_before_disc3 PERCENT_3 purchase_price markup_group3 Number -1 -1 N price_before_disc4 PERCENT_3 purchase_price markup_group4 Number -1 -1 N price_before_disc5 PERCENT_3 purchase_price markup_group5 Number -1 -1 N price_before_disc6 PERCENT_3 purchase_price markup_group6 Number -1 -1 N price_before_disc7 PERCENT_3 purchase_price markup_group7 Number -1 -1 N price_before_disc8 PERCENT_3 purchase_price markup_group8 Number -1 -1 N price_before_disc9 PERCENT_3 purchase_price markup_group9 Number -1 -1 N price_before_disc10 PERCENT_3 purchase_price markup_group10 Number -1 -1 N price_after_disc_1 PERCENT_3 purchase_price markup_std1 Number -1 -1 N price_after_disc_2 PERCENT_3 purchase_price markup_std2 Number -1 -1 N price_after_disc_3 PERCENT_3 purchase_price markup_std3 Number -1 -1 N price_after_disc_4 PERCENT_3 purchase_price markup_std4 Number -1 -1 N price_after_disc_5 PERCENT_3 purchase_price markup_std5 Number -1 -1 N price_after_disc_6 PERCENT_3 purchase_price markup_std6 Number -1 -1 N price_after_disc_7 PERCENT_3 purchase_price markup_std7 Number -1 -1 N price_after_disc_8 PERCENT_3 purchase_price markup_std8 Number -1 -1 N price_after_disc_9 PERCENT_3 purchase_price markup_std9 Number -1 -1 N price_after_disc_10 PERCENT_3 purchase_price markup_std10 Number -1 -1 N price_tier2_1 PERCENT_3 purchase_price markup_tier2_1 Number -1 -1 N price_tier2_2 PERCENT_3 purchase_price markup_tier2_2 Number -1 -1 N price_tier2_3 PERCENT_3 purchase_price markup_tier2_3 Number -1 -1 N price_tier2_4 PERCENT_3 purchase_price markup_tier2_4 Number -1 -1 N price_tier2_5 PERCENT_3 purchase_price markup_tier2_5 Number -1 -1 N price_tier2_6 PERCENT_3 purchase_price markup_tier2_6 Number -1 -1 N price_tier2_7 PERCENT_3 purchase_price markup_tier2_7 Number -1 -1 N price_tier2_8 PERCENT_3 purchase_price markup_tier2_8 Number -1 -1 N price_tier2_9 PERCENT_3 purchase_price markup_tier2_9 Number -1 -1 N price_tier2_10 PERCENT_3 purchase_price markup_tier2_10 Number -1 -1 N price_tier3_1 PERCENT_3 purchase_price markup_tier3_1 Number -1 -1 N price_tier3_2 PERCENT_3 purchase_price markup_tier3_2 Number -1 -1 N price_tier3_3 PERCENT_3 purchase_price markup_tier3_3 Number -1 -1 N price_tier3_4 PERCENT_3 purchase_price markup_tier3_4 Number -1 -1 N price_tier3_5 PERCENT_3 purchase_price markup_tier3_5 Number -1 -1 N price_tier3_6 PERCENT_3 purchase_price markup_tier3_6 Number -1 -1 N price_tier3_7 PERCENT_3 purchase_price markup_tier3_7 Number -1 -1 N price_tier3_8 PERCENT_3 purchase_price markup_tier3_8 Number -1 -1 N price_tier3_9 PERCENT_3 purchase_price markup_tier3_9 Number -1 -1 N price_tier3_10 PERCENT_3 purchase_price markup_tier3_10 Number -1 -1 N price_tier4_1 PERCENT_3 purchase_price markup_tier4_1 Number -1 -1 N price_tier4_2 PERCENT_3 purchase_price markup_tier4_2 Number -1 -1 N price_tier4_3 PERCENT_3 purchase_price markup_tier4_3 Number -1 -1 N price_tier4_4 PERCENT_3 purchase_price markup_tier4_4 Number -1 -1 N price_tier4_5 PERCENT_3 purchase_price markup_tier4_5 Number -1 -1 N price_tier4_6 PERCENT_3 purchase_price markup_tier4_6 Number -1 -1 N price_tier4_7 PERCENT_3 purchase_price markup_tier4_7 Number -1 -1 N price_tier4_8 PERCENT_3 purchase_price markup_tier4_8 Number -1 -1 N price_tier4_9 PERCENT_3 purchase_price markup_tier4_9 Number -1 -1 N price_tier4_10 PERCENT_3 purchase_price markup_tier4_10 Number -1 -1 N price_tier5_1 PERCENT_3 purchase_price markup_tier5_1 Number -1 -1 N price_tier5_2 PERCENT_3 purchase_price markup_tier5_2 Number -1 -1 N price_tier5_3 PERCENT_3 purchase_price markup_tier5_3 Number -1 -1 N price_tier5_4 PERCENT_3 purchase_price markup_tier5_4 Number -1 -1 N price_tier5_5 PERCENT_3 purchase_price markup_tier5_5 Number -1 -1 N price_tier5_6 PERCENT_3 purchase_price markup_tier5_6 Number -1 -1 N price_tier5_7 PERCENT_3 purchase_price markup_tier5_7 Number -1 -1 N price_tier5_8 PERCENT_3 purchase_price markup_tier5_8 Number -1 -1 N price_tier5_9 PERCENT_3 purchase_price markup_tier5_9 Number -1 -1 N price_tier5_10 PERCENT_3 purchase_price markup_tier5_10 Number -1 -1 N

384 64 Y dw Insert / update calc pl InsertUpdate Y 1 none dw bi indoteknik (localhost) 100 N public pricelist_compute product_id product_id = disc1_1 disc1_1 Y disc1_2 disc1_2 Y disc1_3 disc1_3 Y disc1_4 disc1_4 Y disc1_5 disc1_5 Y disc1_6 disc1_6 Y disc1_7 disc1_7 Y disc1_8 disc1_8 Y disc1_9 disc1_9 Y disc1_10 disc1_10 Y disc2_1 disc2_1 Y disc2_2 disc2_2 Y disc2_3 disc2_3 Y disc2_4 disc2_4 Y disc2_5 disc2_5 Y disc2_6 disc2_6 Y disc2_7 disc2_7 Y disc2_8 disc2_8 Y disc2_9 disc2_9 Y disc2_10 disc2_10 Y disc3_1 disc3_1 Y disc3_2 disc3_2 Y disc3_3 disc3_3 Y disc3_4 disc3_4 Y disc3_5 disc3_5 Y disc3_6 disc3_6 Y disc3_7 disc3_7 Y disc3_8 disc3_8 Y disc3_9 disc3_9 Y disc3_10 disc3_10 Y disc4_1 disc4_1 Y disc4_2 disc4_2 Y disc4_3 disc4_3 Y disc4_4 disc4_4 Y disc4_5 disc4_5 Y disc4_6 disc4_6 Y disc4_7 disc4_7 Y disc4_8 disc4_8 Y disc4_9 disc4_9 Y disc4_10 disc4_10 Y disc5_1 disc5_1 Y disc5_2 disc5_2 Y disc5_3 disc5_3 Y disc5_4 disc5_4 Y disc5_5 disc5_5 Y disc5_6 disc5_6 Y disc5_7 disc5_7 Y disc5_8 disc5_8 Y disc5_9 disc5_9 Y disc5_10 disc5_10 Y item_code item_code Y markup_group1 markup_group1 Y markup_group2 markup_group2 Y markup_group3 markup_group3 Y markup_group4 markup_group4 Y markup_group5 markup_group5 Y markup_group6 markup_group6 Y markup_group7 markup_group7 Y markup_group8 markup_group8 Y markup_group9 markup_group9 Y markup_group10 markup_group10 Y markup_std1 markup_std1 Y markup_std2 markup_std2 Y markup_std3 markup_std3 Y markup_std4 markup_std4 Y markup_std5 markup_std5 Y markup_std6 markup_std6 Y markup_std7 markup_std7 Y markup_std8 markup_std8 Y markup_std9 markup_std9 Y markup_std10 markup_std10 Y markup_tier2_1 markup_tier2_1 Y markup_tier2_2 markup_tier2_2 Y markup_tier2_3 markup_tier2_3 Y markup_tier2_4 markup_tier2_4 Y markup_tier2_5 markup_tier2_5 Y markup_tier2_6 markup_tier2_6 Y markup_tier2_7 markup_tier2_7 Y markup_tier2_8 markup_tier2_8 Y markup_tier2_9 markup_tier2_9 Y markup_tier2_10 markup_tier2_10 Y markup_tier3_1 markup_tier3_1 Y markup_tier3_2 markup_tier3_2 Y markup_tier3_3 markup_tier3_3 Y markup_tier3_4 markup_tier3_4 Y markup_tier3_5 markup_tier3_5 Y markup_tier3_6 markup_tier3_6 Y markup_tier3_7 markup_tier3_7 Y markup_tier3_8 markup_tier3_8 Y markup_tier3_9 markup_tier3_9 Y markup_tier3_10 markup_tier3_10 Y markup_tier4_1 markup_tier4_1 Y markup_tier4_2 markup_tier4_2 Y markup_tier4_3 markup_tier4_3 Y markup_tier4_4 markup_tier4_4 Y markup_tier4_5 markup_tier4_5 Y markup_tier4_6 markup_tier4_6 Y markup_tier4_7 markup_tier4_7 Y markup_tier4_8 markup_tier4_8 Y markup_tier4_9 markup_tier4_9 Y markup_tier4_10 markup_tier4_10 Y markup_tier5_1 markup_tier5_1 Y markup_tier5_2 markup_tier5_2 Y markup_tier5_3 markup_tier5_3 Y markup_tier5_4 markup_tier5_4 Y markup_tier5_5 markup_tier5_5 Y markup_tier5_6 markup_tier5_6 Y markup_tier5_7 markup_tier5_7 Y markup_tier5_8 markup_tier5_8 Y markup_tier5_9 markup_tier5_9 Y markup_tier5_10 markup_tier5_10 Y name name Y price_after_disc_1 price_after_disc_1 Y price_after_disc_2 price_after_disc_2 Y price_after_disc_3 price_after_disc_3 Y price_after_disc_4 price_after_disc_4 Y price_after_disc_5 price_after_disc_5 Y price_after_disc_6 price_after_disc_6 Y price_after_disc_7 price_after_disc_7 Y price_after_disc_8 price_after_disc_8 Y price_after_disc_9 price_after_disc_9 Y price_after_disc_10 price_after_disc_10 Y price_before_disc1 price_before_disc1 Y price_before_disc2 price_before_disc2 Y price_before_disc3 price_before_disc3 Y price_before_disc4 price_before_disc4 Y price_before_disc5 price_before_disc5 Y price_before_disc6 price_before_disc6 Y price_before_disc7 price_before_disc7 Y price_before_disc8 price_before_disc8 Y price_before_disc9 price_before_disc9 Y price_before_disc10 price_before_disc10 Y price_tier2_1 price_tier2_1 Y price_tier2_2 price_tier2_2 Y price_tier2_3 price_tier2_3 Y price_tier2_4 price_tier2_4 Y price_tier2_5 price_tier2_5 Y price_tier2_6 price_tier2_6 Y price_tier2_7 price_tier2_7 Y price_tier2_8 price_tier2_8 Y price_tier2_9 price_tier2_9 Y price_tier2_10 price_tier2_10 Y price_tier3_1 price_tier3_1 Y price_tier3_2 price_tier3_2 Y price_tier3_3 price_tier3_3 Y price_tier3_4 price_tier3_4 Y price_tier3_5 price_tier3_5 Y price_tier3_6 price_tier3_6 Y price_tier3_7 price_tier3_7 Y price_tier3_8 price_tier3_8 Y price_tier3_9 price_tier3_9 Y price_tier3_10 price_tier3_10 Y price_tier4_1 price_tier4_1 Y price_tier4_2 price_tier4_2 Y price_tier4_3 price_tier4_3 Y price_tier4_4 price_tier4_4 Y price_tier4_5 price_tier4_5 Y price_tier4_6 price_tier4_6 Y price_tier4_7 price_tier4_7 Y price_tier4_8 price_tier4_8 Y price_tier4_9 price_tier4_9 Y price_tier4_10 price_tier4_10 Y price_tier5_1 price_tier5_1 Y price_tier5_2 price_tier5_2 Y price_tier5_3 price_tier5_3 Y price_tier5_4 price_tier5_4 Y price_tier5_5 price_tier5_5 Y price_tier5_6 price_tier5_6 Y price_tier5_7 price_tier5_7 Y price_tier5_8 price_tier5_8 Y price_tier5_9 price_tier5_9 Y price_tier5_10 price_tier5_10 Y pricing_group pricing_group Y product_id product_id N purchase_price purchase_price Y vendor vendor Y vendor_id vendor_id Y

736 192 Y dw Insert / update zero InsertUpdate Y 1 none dw bi indoteknik (localhost) 100 N public pricelist_compute product_id product_id = disc1_1 zero Y disc1_2 zero Y disc1_3 zero Y disc1_4 zero Y disc1_5 zero Y disc1_6 zero Y disc1_7 zero Y disc1_8 zero Y disc1_9 zero Y disc1_10 zero Y disc2_1 zero Y disc2_2 zero Y disc2_3 zero Y disc2_4 zero Y disc2_5 zero Y disc2_6 zero Y disc2_7 zero Y disc2_8 zero Y disc2_9 zero Y disc2_10 zero Y disc3_1 zero Y disc3_2 zero Y disc3_3 zero Y disc3_4 zero Y disc3_5 zero Y disc3_6 zero Y disc3_7 zero Y disc3_8 zero Y disc3_9 zero Y disc3_10 zero Y disc4_1 zero Y disc4_2 zero Y disc4_3 zero Y disc4_4 zero Y disc4_5 zero Y disc4_6 zero Y disc4_7 zero Y disc4_8 zero Y disc4_9 zero Y disc4_10 zero Y disc5_1 zero Y disc5_2 zero Y disc5_3 zero Y disc5_4 zero Y disc5_5 zero Y disc5_6 zero Y disc5_7 zero Y disc5_8 zero Y disc5_9 zero Y disc5_10 zero Y item_code item_code Y markup_group1 zero Y markup_group2 zero Y markup_group3 zero Y markup_group4 zero Y markup_group5 zero Y markup_group6 zero Y markup_group7 zero Y markup_group8 zero Y markup_group9 zero Y markup_group10 zero Y markup_std1 zero Y markup_std2 zero Y markup_std3 zero Y markup_std4 zero Y markup_std5 zero Y markup_std6 zero Y markup_std7 zero Y markup_std8 zero Y markup_std9 zero Y markup_std10 zero Y markup_tier2_1 zero Y markup_tier2_2 zero Y markup_tier2_3 zero Y markup_tier2_4 zero Y markup_tier2_5 zero Y markup_tier2_6 zero Y markup_tier2_7 zero Y markup_tier2_8 zero Y markup_tier2_9 zero Y markup_tier2_10 zero Y markup_tier3_1 zero Y markup_tier3_2 zero Y markup_tier3_3 zero Y markup_tier3_4 zero Y markup_tier3_5 zero Y markup_tier3_6 zero Y markup_tier3_7 zero Y markup_tier3_8 zero Y markup_tier3_9 zero Y markup_tier3_10 zero Y markup_tier4_1 zero Y markup_tier4_2 zero Y markup_tier4_3 zero Y markup_tier4_4 zero Y markup_tier4_5 zero Y markup_tier4_6 zero Y markup_tier4_7 zero Y markup_tier4_8 zero Y markup_tier4_9 zero Y markup_tier4_10 zero Y markup_tier5_1 zero Y markup_tier5_2 zero Y markup_tier5_3 zero Y markup_tier5_4 zero Y markup_tier5_5 zero Y markup_tier5_6 zero Y markup_tier5_7 zero Y markup_tier5_8 zero Y markup_tier5_9 zero Y markup_tier5_10 zero Y name name Y price_after_disc_1 zero Y price_after_disc_2 zero Y price_after_disc_3 zero Y price_after_disc_4 zero Y price_after_disc_5 zero Y price_after_disc_6 zero Y price_after_disc_7 zero Y price_after_disc_8 zero Y price_after_disc_9 zero Y price_after_disc_10 zero Y price_before_disc1 zero Y price_before_disc2 zero Y price_before_disc3 zero Y price_before_disc4 zero Y price_before_disc5 zero Y price_before_disc6 zero Y price_before_disc7 zero Y price_before_disc8 zero Y price_before_disc9 zero Y price_before_disc10 zero Y price_tier2_1 zero Y price_tier2_2 zero Y price_tier2_3 zero Y price_tier2_4 zero Y price_tier2_5 zero Y price_tier2_6 zero Y price_tier2_7 zero Y price_tier2_8 zero Y price_tier2_9 zero Y price_tier2_10 zero Y price_tier3_1 zero Y price_tier3_2 zero Y price_tier3_3 zero Y price_tier3_4 zero Y price_tier3_5 zero Y price_tier3_6 zero Y price_tier3_7 zero Y price_tier3_8 zero Y price_tier3_9 zero Y price_tier3_10 zero Y price_tier4_1 zero Y price_tier4_2 zero Y price_tier4_3 zero Y price_tier4_4 zero Y price_tier4_5 zero Y price_tier4_6 zero Y price_tier4_7 zero Y price_tier4_8 zero Y price_tier4_9 zero Y price_tier4_10 zero Y price_tier5_1 zero Y price_tier5_2 zero Y price_tier5_3 zero Y price_tier5_4 zero Y price_tier5_5 zero Y price_tier5_6 zero Y price_tier5_7 zero Y price_tier5_8 zero Y price_tier5_9 zero Y price_tier5_10 zero Y pricing_group pricing_group Y product_id product_id N purchase_price zero Y

240 304 Y N