From 1b48e721cdebe0d1b963cd21de81161149e39fd3 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 22 Aug 2023 13:53:48 +0700 Subject: calculate price --- calculate_price_after_disc.ktr | 1493 ++++++++++++++++++++++++++ import_all_data_bi_indoteknik.kjb | 6 +- import_brand.ktr | 148 +-- import_price_group.ktr | 850 +++++++++++++++ refresh_materialized_view_purchase_price.ktr | 2 +- 5 files changed, 2435 insertions(+), 64 deletions(-) create mode 100644 calculate_price_after_disc.ktr create mode 100644 import_price_group.ktr diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr new file mode 100644 index 0000000..76f4d65 --- /dev/null +++ b/calculate_price_after_disc.ktr @@ -0,0 +1,1493 @@ + + + + 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 + + N + + + + + dw bi indoteknik + 192.168.23.5 + POSTGRESQL + Native + dw_bi_indoteknik + 5432 + odoo + Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + + + + + + 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 + Y + + + USE_POOLING + N + + + + + + Table input + Calculator + Y + + + Calculator + Calculator 2 + Y + + + + Table input + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select mpp.product_id, p.item_code, p."name", mpp.purchase_price, b.pricing_group, +(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 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 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 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 +from mv_purchase_pricelist mpp +join product p on p.product_id = mpp.product_id +left join brand b on b.id = p.brand_id +--where b.id in(10, 122, 89) + 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 + + + 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 + pricing_group + 2147483647 + -1 + Table input + pricing_group + + . + , + + 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_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_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_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 + + + + + + + + + + + + 240 + 64 + Y + + + + Calculator + Calculator + + Y + + 1 + + none + + + Y + + 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 + + + + + + + + + + + + + + + 384 + 64 + Y + + + + Calculator 2 + Calculator + + Y + + 1 + + none + + + Y + + price_before_disc1 + PERCENT_3 + price_after_disc_1 + markup_group1 + + Number + -1 + -1 + N + + + + + + + price_before_disc2 + PERCENT_3 + price_after_disc_2 + markup_group2 + + Number + -1 + -1 + N + + + + + + + price_before_disc3 + PERCENT_3 + price_after_disc_3 + markup_group3 + + Number + -1 + -1 + N + + + + + + + price_before_disc4 + PERCENT_3 + price_after_disc_4 + markup_group4 + + Number + -1 + -1 + N + + + + + + + price_before_disc5 + PERCENT_3 + price_after_disc_5 + markup_group5 + + 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_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 + + + + + + + + + + + + + + + 544 + 64 + Y + + + + + + + N + + diff --git a/import_all_data_bi_indoteknik.kjb b/import_all_data_bi_indoteknik.kjb index 0318ba5..0d3a865 100644 --- a/import_all_data_bi_indoteknik.kjb +++ b/import_all_data_bi_indoteknik.kjb @@ -1080,7 +1080,7 @@ filename - /home/superman/runapps/refresh_materialized_view_purchase_price + /home/superman/runapps/refresh_materialized_view_purchase_price.ktr N N @@ -1108,8 +1108,8 @@ N Y 0 - 96 - 560 + 256 + 704 diff --git a/import_brand.ktr b/import_brand.ktr index 88e2be7..cc956af 100644 --- a/import_brand.ktr +++ b/import_brand.ktr @@ -430,7 +430,7 @@ 2023/08/09 15:22:50.719 - 2023/08/09 15:22:50.719 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N @@ -544,6 +544,69 @@ Y + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik + 100 + N + + public +
brand
+ + id + id + = + + + + id + id + N + + + name + x_name + Y + + + type + x_manufacture_level + Y + + + parent + parent + Y + + + pricing_group + pricing_group + Y + + + + + + + + + + + + 272 + 96 + Y + + Table input TableInput @@ -557,7 +620,7 @@ erp indoteknik production select id, x_name, x_manufacture_level, -(select x_name from x_manufactures xm2 where xm2.id = xm.parent_id) as parent +(select x_name from x_manufactures xm2 where xm2.id = xm.parent_id) as parent, pricing_group from x_manufactures xm where xm.write_date >= (now() - '15 days'::interval) 0 @@ -659,6 +722,29 @@ where xm.write_date >= (now() - '15 days'::interval) 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 + @@ -674,64 +760,6 @@ where xm.write_date >= (now() - '15 days'::interval) Y - - Insert / update - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik - 100 - N - - public - brand
- - id - id - = - - - - id - id - N - - - name - x_name - Y - - - type - x_manufacture_level - Y - - - parent - parent - Y - - - - - - - - - - - - 272 - 96 - Y - - diff --git a/import_price_group.ktr b/import_price_group.ktr new file mode 100644 index 0000000..648237d --- /dev/null +++ b/import_price_group.ktr @@ -0,0 +1,850 @@ + + + + import_price_group + + + + 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 09:00:32.267 + - + 2023/08/22 09:00:32.267 + + N + + + + + dw bi indoteknik + 192.168.23.5 + POSTGRESQL + Native + dw_bi_indoteknik + 5432 + odoo + Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + + + + + + 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 + Y + + + USE_POOLING + N + + + + + erp indoteknik local + localhost + POSTGRESQL + Native + indoteknik_20230821 + 5432 + odoo + Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + + + + + + 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 + Y + + + USE_POOLING + N + + + + + + Table input + Insert / update + Y + + + + Table input + TableInput + + Y + + 1 + + none + + + erp indoteknik local + select id, name, pricelist_id, group1, group2, group3, group4, group5 from price_group pg + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + Table input + id + ####0;-####0 + . + , + + 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 + + + Integer + normal + pricelist_id + 9 + 0 + Table input + pricelist_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Number + normal + group1 + -1 + -1 + Table input + group1 + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Number + normal + group2 + -1 + -1 + Table input + group2 + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Number + normal + group3 + -1 + -1 + Table input + group3 + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Number + normal + group4 + -1 + -1 + Table input + group4 + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Number + normal + group5 + -1 + -1 + Table input + group5 + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 304 + 112 + Y + + + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik + 100 + N + + public +
price_group_dw
+ + id + id + = + + + + id + id + N + + + name + name + Y + + + pricelist_id + pricelist_id + Y + + + group1 + group1 + Y + + + group2 + group2 + Y + + + group3 + group3 + Y + + + group4 + group4 + Y + + + group5 + group5 + Y + + + + + + + + + + + + 480 + 112 + Y + + + + + + + N + + diff --git a/refresh_materialized_view_purchase_price.ktr b/refresh_materialized_view_purchase_price.ktr index 61fcde4..ca13705 100644 --- a/refresh_materialized_view_purchase_price.ktr +++ b/refresh_materialized_view_purchase_price.ktr @@ -430,7 +430,7 @@ 2023/08/21 13:31:33.332 - 2023/08/21 13:31:33.332 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N -- cgit v1.2.3