From 9828160c003af8915fd837f2ae4d3271387ea8e3 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Mon, 18 Sep 2023 11:12:39 +0700 Subject: refactor insert update pricelist --- insert_update_tier3.ktr | 1934 ----------------------------------------------- 1 file changed, 1934 deletions(-) delete mode 100644 insert_update_tier3.ktr (limited to 'insert_update_tier3.ktr') diff --git a/insert_update_tier3.ktr b/insert_update_tier3.ktr deleted file mode 100644 index d050afc..0000000 --- a/insert_update_tier3.ktr +++ /dev/null @@ -1,1934 +0,0 @@ - - - - insert_update_tier3 - - - - 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 15:47:24.260 - - - 2023/08/22 15:47:24.260 - H4sIAAAAAAAAAAMAAAAAAAAAAAA= - 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_20230912 - 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 - - - - - - price compute - Merge join - Y - - - price erp - Merge join - Y - - - Merge join - Filter rows - Y - - - Filter rows - Write to log - Y - - - Filter rows - Add constants - Y - - - Add constants - Insert / update - Y - - - Insert / update 2 - Insert / update 3 - Y - - - Insert / update - Insert / update 2 - Y - - - - Add constants - Constant - - Y - - 1 - - none - - - - - applied_on - String - - - - - 0_product_variant - -1 - -1 - N - - - base - String - - - - - pricelist - -1 - -1 - N - - - pricelist_id - Integer - - - - - 15038 - -1 - -1 - N - - - currency_id - Integer - - - - - 12 - -1 - -1 - N - - - active - Boolean - - - - - true - -1 - -1 - N - - - compute_price - String - - - - - formula - -1 - -1 - N - - - create_uid - Integer - - - - - 28 - -1 - -1 - N - - - create_date - Timestamp - yyyy-MM-dd - - - - 2023-03-29 08:15:57.651 - -1 - -1 - N - - - write_uid - Integer - - - - - 28 - -1 - -1 - N - - - write_date - Timestamp - yyyy-MM-dd - - - - 2023-03-29 08:15:57.651 - -1 - -1 - N - - - base_pricelist_id - Integer - - - - - 1 - -1 - -1 - N - - - solr_flag - Integer - - - - - 1 - -1 - -1 - N - - - - - - - - - - - - 624 - 240 - Y - - - - Filter rows - FilterRows - - Y - - 1 - - none - - - Add constants - Write to log - - - N - disc_tier3 - <> - price_discount - - - - - - - - - - - - 496 - 240 - Y - - - - Insert / update - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik local - 100 - N - - public -
product_pricelist_item
- - product_id - product_id - = - - - - pricelist_id_1 - pricelist_id - = - - - - product_id - product_id - N - - - applied_on - applied_on_1 - Y - - - base - base_1 - Y - - - pricelist_id - pricelist_id_1 - N - - - currency_id - currency_id_1 - Y - - - active - active_1 - Y - - - compute_price - compute_price_1 - Y - - - create_uid - create_uid_1 - Y - - - create_date - create_date_1 - Y - - - write_uid - write_uid_1 - Y - - - write_date - write_date_1 - Y - - - base_pricelist_id - base_pricelist_id_1 - Y - - - price_discount - disc_tier3 - Y - - - - - - - - - - - - 768 - 240 - Y - - - - Insert / update 2 - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik local - 100 - N - - public - product_template
- - template_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 912 - 240 - Y - - - - Insert / update 3 - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik local - 100 - N - - public - product_product
- - product_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 1040 - 240 - Y - - - - Merge join - MergeJoin - - Y - - 1 - - none - - - LEFT OUTER - price compute - price erp - - product_id - - - product_id - - - - - - - - - - - 352 - 240 - Y - - - - Write to log - WriteToLog - - Y - - 1 - - none - - - log_level_basic - Y - N - 0 - - - - - - - - - - - - - 496 - 368 - Y - - - - price compute - TableInput - - Y - - 1 - - none - - - dw bi indoteknik - select pc.product_id, p.template_id, price_before_disc, disc_tier1, -disc_tier2, disc_tier3, disc_tier4, disc_tier5 -from v_pricelist_compute pc -join product p on p.product_id = pc.product_id -order by product_id - 0 - - N - N - N - N - - - Integer - normal - product_id - 9 - 0 - price compute - product_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - template_id - 9 - 0 - price compute - template_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - price_before_disc - -1 - -1 - price compute - price_before_disc - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - disc_tier1 - -1 - -1 - price compute - disc_tier1 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - disc_tier2 - -1 - -1 - price compute - disc_tier2 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - disc_tier3 - -1 - -1 - price compute - disc_tier3 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - disc_tier4 - -1 - -1 - price compute - disc_tier4 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - disc_tier5 - -1 - -1 - price compute - disc_tier5 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - - - - - - - - - - 256 - 96 - Y - - - - price erp - TableInput - - Y - - 1 - - none - - - erp indoteknik local - select * from product_pricelist_item where pricelist_id = 15038 order by product_id - 0 - - N - N - N - N - - - Integer - normal - id - 9 - 0 - price erp - id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - product_tmpl_id - 9 - 0 - price erp - product_tmpl_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - product_id - 9 - 0 - price erp - product_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - categ_id - 9 - 0 - price erp - categ_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - min_quantity - -1 - -1 - price erp - min_quantity - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - applied_on - 2147483647 - -1 - price erp - applied_on - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - base - 2147483647 - -1 - price erp - base - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - base_pricelist_id - 9 - 0 - price erp - base_pricelist_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - pricelist_id - 9 - 0 - price erp - pricelist_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - price_surcharge - -1 - -1 - price erp - price_surcharge - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - price_discount - -1 - -1 - price erp - price_discount - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - price_round - -1 - -1 - price erp - price_round - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - price_min_margin - -1 - -1 - price erp - price_min_margin - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - price_max_margin - -1 - -1 - price erp - price_max_margin - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - company_id - 9 - 0 - price erp - company_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - currency_id - 9 - 0 - price erp - currency_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Boolean - normal - active - -1 - -1 - price erp - active - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Timestamp - normal - date_start - 6 - -1 - price erp - date_start - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Timestamp - normal - date_end - 6 - -1 - price erp - date_end - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - compute_price - 2147483647 - -1 - price erp - compute_price - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - fixed_price - -1 - -1 - price erp - fixed_price - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Number - normal - percent_price - -1 - -1 - price erp - percent_price - ####0.0#########;-####0.0######### - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - create_uid - 9 - 0 - price erp - create_uid - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Timestamp - normal - create_date - 6 - -1 - price erp - create_date - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - write_uid - 9 - 0 - price erp - write_uid - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Timestamp - normal - write_date - 6 - -1 - price erp - write_date - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - manufacture_id - 9 - 0 - price erp - manufacture_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - - - - - - - - - - 448 - 96 - Y - - - - - - - N - - -- cgit v1.2.3