From 22188a7899a54b48142e9ab45c1a31b3c0290a1f Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 26 Mar 2024 09:05:45 +0700 Subject: add override vendor pricelist compute --- import_purchase_pricelist.ktr | 7 +- run_calculate_pricelist_odoo.kjb | 154 +- update_override_vendor_id.ktr | 725 ++++++ update_override_vendor_pricelist.ktr | 4544 ++++++++++++++++++++++++++++++++++ 4 files changed, 5400 insertions(+), 30 deletions(-) create mode 100644 update_override_vendor_id.ktr create mode 100644 update_override_vendor_pricelist.ktr diff --git a/import_purchase_pricelist.ktr b/import_purchase_pricelist.ktr index bf19d39..13decff 100644 --- a/import_purchase_pricelist.ktr +++ b/import_purchase_pricelist.ktr @@ -557,7 +557,7 @@ erp indoteknik production (localhost) select pp.id, pp.product_id, pp.vendor_id, rp.name as vendor, pp.product_price, pp.write_date, -pp.system_price, pp.system_last_update, pp.human_last_update, pp.include_price +pp.system_price, pp.system_last_update, pp.human_last_update, pp.include_price, pp.brand_id from purchase_pricelist pp join res_partner rp on rp.id = pp.vendor_id where pp.write_date >= (now() - '10 days'::interval) @@ -863,6 +863,11 @@ where pp.write_date >= (now() - '10 days'::interval) include_price Y + + brand_id + brand_id + Y + diff --git a/run_calculate_pricelist_odoo.kjb b/run_calculate_pricelist_odoo.kjb index a02052c..4dc2e2f 100644 --- a/run_calculate_pricelist_odoo.kjb +++ b/run_calculate_pricelist_odoo.kjb @@ -499,7 +499,7 @@ N Y 0 - 1248 + 1328 96 @@ -538,7 +538,7 @@ N Y 0 - 1072 + 1168 240 @@ -577,7 +577,7 @@ N Y 0 - 928 + 1056 240 @@ -655,7 +655,7 @@ N Y 0 - 592 + 432 240 @@ -694,7 +694,7 @@ N Y 0 - 384 + 272 240 @@ -733,7 +733,7 @@ N Y 0 - 192 + 112 240 @@ -772,7 +772,7 @@ N Y 0 - 192 + 112 384 @@ -811,7 +811,7 @@ N Y 0 - 384 + 272 384 @@ -850,7 +850,7 @@ N Y 0 - 544 + 432 384 @@ -928,7 +928,7 @@ N Y 0 - 704 + 608 384 @@ -1006,7 +1006,7 @@ N Y 0 - 1248 + 1328 240 @@ -1049,6 +1049,84 @@ 96 + + update override vendor id + + TRANS + + filename + + /home/stephan/transformation-job-bi/update_override_vendor_id.ktr + + N + N + N + N + N + N + + + N + N + Basic + N + + N + Y + N + N + N + Pentaho local + N + + Y + + N + Y + 0 + 912 + 240 + + + + calculate pricelist override vendor + + TRANS + + filename + + /home/stephan/transformation-job-bi/update_override_vendor_pricelist.ktr + + N + N + N + N + N + N + + + N + N + Basic + N + + N + Y + N + N + N + Pentaho local + N + + Y + + N + Y + 0 + 608 + 240 + + @@ -1078,24 +1156,6 @@ Y N - - count vendor - calculate pricelist - 0 - 0 - Y - Y - N - - - calculate pricelist - insert update base pricelist - 0 - 0 - Y - Y - N - insert update base pricelist insert update pricelist1 @@ -1222,6 +1282,42 @@ Y N + + count vendor + update override vendor id + 0 + 0 + Y + Y + N + + + update override vendor id + calculate pricelist + 0 + 0 + Y + Y + N + + + calculate pricelist + calculate pricelist override vendor + 0 + 0 + Y + Y + N + + + calculate pricelist override vendor + insert update base pricelist + 0 + 0 + Y + Y + N + diff --git a/update_override_vendor_id.ktr b/update_override_vendor_id.ktr new file mode 100644 index 0000000..ccb6559 --- /dev/null +++ b/update_override_vendor_id.ktr @@ -0,0 +1,725 @@ + + + + update_override_vendor_id + + + + 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/25 15:00:01.913 + - + 2024/03/25 15:00:01.913 + 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 + + + + + + Table input + Update override vendor id purchase pricelist + Y + + + Update override vendor id purchase pricelist + Add constants + Y + + + Add constants + Update exist purchase price in brand + Y + + + + Add constants + Constant + + Y + + 1 + + none + + + + + purchase_price_exist + String + + + + + Y + -1 + -1 + N + + + + + + + + + + + + 688 + 96 + Y + + + + Table input + TableInput + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + select distinct ppd.brand_id, b.override_vendor_id +from purchase_pricelist_dw ppd +join brand b on b.id = ppd.brand_id +where ppd.vendor_id = b.override_vendor_id + 0 + + N + N + N + N + + + Integer + normal + brand_id + 9 + 0 + Table input + brand_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + override_vendor_id + 9 + 0 + Table input + override_vendor_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 176 + 96 + Y + + + + Update exist purchase price in brand + Update + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + N + 100 + N + N + + + public +
brand
+ + brand_id + id + = + + + + purchase_price_exist + purchase_price_exist + + + + + + + + + + + + 944 + 96 + Y + + + + Update override vendor id purchase pricelist + Update + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + N + 100 + N + N + + + public + purchase_pricelist_dw
+ + brand_id + brand_id + = + + + + override_vendor_id + override_vendor_id + + + + + + + + + + + + 448 + 96 + Y + + + + + + + N + + diff --git a/update_override_vendor_pricelist.ktr b/update_override_vendor_pricelist.ktr new file mode 100644 index 0000000..f8d9d06 --- /dev/null +++ b/update_override_vendor_pricelist.ktr @@ -0,0 +1,4544 @@ + + + + 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 + + -- cgit v1.2.3