update_override_vendor_pricelist 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 - 2024/03/26 08:32:53.103 - 2024/03/26 08:32:53.103 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 Table input Filter rows Y Filter rows filter override vendor purchase price = 0 Y calculate diff calculate discount Y calculate price tier calculate diff Y Filter rows calculate price tier Y calculate discount update purchase pricelist override vendor 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 coalesce(ppd.include_price,0) from purchase_pricelist_dw ppd where ppd.product_id = p.product_id and ppd.vendor_id = b.override_vendor_id and ((system_last_update >= (now() - '365 days'::interval) or human_last_update >= (now() - '365 days'::interval) or p.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, rp.name as vendor, (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 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 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 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 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 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 from product p join brand b on b.id = p.brand_id join res_partner rp on rp.id = b.override_vendor_id where b.purchase_price_exist = 'Y' 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_ID Asia/Bangkok N String normal item_code 2147483647 -1 Table input item_code . , none N Y 0 N N N en_ID Asia/Bangkok N String normal name 2147483647 -1 Table input name . , none N Y 0 N N N en_ID Asia/Bangkok N String normal pricing_group 2147483647 -1 Table input pricing_group . , none N Y 0 N N N en_ID 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_ID Asia/Bangkok N String normal vendor 2147483647 -1 Table input vendor . , none N Y 0 N N N en_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID 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_ID Asia/Bangkok N

208 128 Y update purchase pricelist override vendor Update Y 1 none dw bi indoteknik (localhost) N 100 N N public pricelist_compute product_id product_id = item_code item_code name name pricing_group pricing_group purchase_price purchase_price vendor vendor markup_std1 markup_std1 markup_std2 markup_std2 markup_std3 markup_std3 markup_std4 markup_std4 markup_std5 markup_std5 markup_std6 markup_std6 markup_std7 markup_std7 markup_std8 markup_std8 markup_group1 markup_group1 markup_group2 markup_group2 markup_group3 markup_group3 markup_group4 markup_group4 markup_group5 markup_group5 markup_group6 markup_group6 markup_group7 markup_group7 markup_group8 markup_group8 markup_tier2_1 markup_tier2_1 markup_tier2_2 markup_tier2_2 markup_tier2_3 markup_tier2_3 markup_tier2_4 markup_tier2_4 markup_tier2_5 markup_tier2_5 markup_tier2_6 markup_tier2_6 markup_tier2_7 markup_tier2_7 markup_tier2_8 markup_tier2_8 markup_tier3_1 markup_tier3_1 markup_tier3_2 markup_tier3_2 markup_tier3_3 markup_tier3_3 markup_tier3_4 markup_tier3_4 markup_tier3_5 markup_tier3_5 markup_tier3_6 markup_tier3_6 markup_tier3_7 markup_tier3_7 markup_tier3_8 markup_tier3_8 markup_tier4_1 markup_tier4_1 markup_tier4_2 markup_tier4_2 markup_tier4_3 markup_tier4_3 markup_tier4_4 markup_tier4_4 markup_tier4_5 markup_tier4_5 markup_tier4_6 markup_tier4_6 markup_tier4_7 markup_tier4_7 markup_tier4_8 markup_tier4_8 markup_tier5_1 markup_tier5_1 markup_tier5_2 markup_tier5_2 markup_tier5_3 markup_tier5_3 markup_tier5_4 markup_tier5_4 markup_tier5_5 markup_tier5_5 markup_tier5_6 markup_tier5_6 markup_tier5_7 markup_tier5_7 markup_tier5_8 markup_tier5_8 price_before_disc1 price_before_disc1 price_before_disc2 price_before_disc2 price_before_disc3 price_before_disc3 price_before_disc4 price_before_disc4 price_before_disc5 price_before_disc5 price_before_disc6 price_before_disc6 price_before_disc7 price_before_disc7 price_before_disc8 price_before_disc8 price_after_disc_1 price_after_disc_1 price_after_disc_2 price_after_disc_2 price_after_disc_3 price_after_disc_3 price_after_disc_4 price_after_disc_4 price_after_disc_5 price_after_disc_5 price_after_disc_6 price_after_disc_6 price_after_disc_7 price_after_disc_7 price_after_disc_8 price_after_disc_8 price_tier2_1 price_tier2_1 price_tier2_2 price_tier2_2 price_tier2_3 price_tier2_3 price_tier2_4 price_tier2_4 price_tier2_5 price_tier2_5 price_tier2_6 price_tier2_6 price_tier2_7 price_tier2_7 price_tier2_8 price_tier2_8 price_tier3_1 price_tier3_1 price_tier3_2 price_tier3_2 price_tier3_3 price_tier3_3 price_tier3_4 price_tier3_4 price_tier3_5 price_tier3_5 price_tier3_6 price_tier3_6 price_tier3_7 price_tier3_7 price_tier3_8 price_tier3_8 price_tier4_1 price_tier4_1 price_tier4_2 price_tier4_2 price_tier4_3 price_tier4_3 price_tier4_4 price_tier4_4 price_tier4_5 price_tier4_5 price_tier4_6 price_tier4_6 price_tier4_7 price_tier4_7 price_tier4_8 price_tier4_8 price_tier5_1 price_tier5_1 price_tier5_2 price_tier5_2 price_tier5_3 price_tier5_3 price_tier5_4 price_tier5_4 price_tier5_5 price_tier5_5 price_tier5_6 price_tier5_6 price_tier5_7 price_tier5_7 price_tier5_8 price_tier5_8 disc1_1 disc1_1 disc1_2 disc1_2 disc1_3 disc1_3 disc1_4 disc1_4 disc1_5 disc1_5 disc1_6 disc1_6 disc1_7 disc1_7 disc1_8 disc1_8 disc2_1 disc2_1 disc2_2 disc2_2 disc2_3 disc2_3 disc2_4 disc2_4 disc2_5 disc2_5 disc2_6 disc2_6 disc2_7 disc2_7 disc2_8 disc2_8 disc3_1 disc3_1 disc3_2 disc3_2 disc3_3 disc3_3 disc3_4 disc3_4 disc3_5 disc3_5 disc3_6 disc3_6 disc3_7 disc3_7 disc3_8 disc3_8 disc4_1 disc4_1 disc4_2 disc4_2 disc4_3 disc4_3 disc4_4 disc4_4 disc4_5 disc4_5 disc4_6 disc4_6 disc4_7 disc4_7 disc4_8 disc4_8 disc5_1 disc5_1 disc5_2 disc5_2 disc5_3 disc5_3 disc5_4 disc5_4 disc5_5 disc5_5 disc5_6 disc5_6 disc5_7 disc5_7 disc5_8 disc5_8

928 256 Y Filter rows FilterRows Y 1 none calculate price tier filter override vendor purchase price = 0 N purchase_price > constant BigNumber 0.0 -1 -1 N ######0.0###################;-######0.0###################

352 128 Y filter override vendor purchase price = 0 WriteToLog Y 1 none log_level_basic Y N 0

352 256 Y calculate diff Calculator Y 1 none Y diff1_1 SUBTRACT price_before_disc1 price_after_disc_1 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 diff2_1 SUBTRACT price_before_disc1 price_tier2_1 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 diff3_1 SUBTRACT price_before_disc1 price_tier3_1 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 diff4_1 SUBTRACT price_before_disc1 price_tier4_1 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 diff5_1 SUBTRACT price_before_disc1 price_tier5_1 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

576 256 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 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 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 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 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

736 256 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_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_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_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_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_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

576 128 Y N