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_discount.ktr | 1888 --------------------------------------- insert_update_pricelist.ktr | 210 ++++- insert_update_pricelist1.ktr | 2031 ++++++++++++++++++++++++++++++++++++++++++ insert_update_pricelist2.ktr | 2031 ++++++++++++++++++++++++++++++++++++++++++ insert_update_pricelist3.ktr | 2031 ++++++++++++++++++++++++++++++++++++++++++ insert_update_pricelist4.ktr | 2031 ++++++++++++++++++++++++++++++++++++++++++ insert_update_pricelist5.ktr | 2031 ++++++++++++++++++++++++++++++++++++++++++ insert_update_tier2.ktr | 1934 ---------------------------------------- insert_update_tier3.ktr | 1934 ---------------------------------------- insert_update_tier4.ktr | 1935 ---------------------------------------- insert_update_tier5.ktr | 1935 ---------------------------------------- 11 files changed, 10334 insertions(+), 9657 deletions(-) delete mode 100644 insert_update_discount.ktr create mode 100644 insert_update_pricelist1.ktr create mode 100644 insert_update_pricelist2.ktr create mode 100644 insert_update_pricelist3.ktr create mode 100644 insert_update_pricelist4.ktr create mode 100644 insert_update_pricelist5.ktr delete mode 100644 insert_update_tier2.ktr delete mode 100644 insert_update_tier3.ktr delete mode 100644 insert_update_tier4.ktr delete mode 100644 insert_update_tier5.ktr diff --git a/insert_update_discount.ktr b/insert_update_discount.ktr deleted file mode 100644 index acc84c7..0000000 --- a/insert_update_discount.ktr +++ /dev/null @@ -1,1888 +0,0 @@ - - - - insert_update_discount - - - - 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:35:29.262 - - - 2023/08/22 15:35:29.262 - 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_20230913 - 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 - - - - - 4 - -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 - - - - - - - - - - - - 560 - 272 - Y - - - - Filter rows - FilterRows - - Y - - 1 - - none - - - Add constants - Write to log - - - N - disc_tier1 - <> - price_discount - - - - - - - - - - - - 432 - 272 - 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_tier1 - Y - - - - - - - - - - - - 704 - 272 - Y - - - - Insert / update 2 - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik local - 100 - N - - public - product_template
- - template_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 864 - 272 - Y - - - - Insert / update 3 - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik local - 100 - N - - public - product_product
- - product_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 992 - 272 - Y - - - - Merge join - MergeJoin - - Y - - 1 - - none - - - LEFT OUTER - price compute - price erp - - product_id - - - product_id - - - - - - - - - - - 288 - 272 - Y - - - - Write to log - WriteToLog - - Y - - 1 - - none - - - log_level_basic - Y - N - 0 - - - - - - - - - - - - - 432 - 400 - 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 - - - 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_web_tier1 - -1 - -1 - price compute - disc_web_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 - - - Integer - normal - template_id - 9 - 0 - price compute - template_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - - - - - - - - - - 192 - 128 - Y - - - - price erp - TableInput - - Y - - 1 - - none - - - erp indoteknik local - select * from product_pricelist_item where pricelist_id = 4 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 - - - - - - - - - - - - 384 - 128 - Y - - - - - - - N - - diff --git a/insert_update_pricelist.ktr b/insert_update_pricelist.ktr index 02d665a..f14e7f6 100644 --- a/insert_update_pricelist.ktr +++ b/insert_update_pricelist.ktr @@ -6,6 +6,7 @@ Normal + 0 / @@ -491,7 +492,7 @@ localhost POSTGRESQL Native - indoteknik_20230913 + indoteknik_20230914 5432 odoo Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 @@ -603,18 +604,6 @@ -1 N - - base - String - - - - - list_price - -1 - -1 - N - pricelist_id Integer @@ -622,7 +611,7 @@ - 1 + 17022 -1 -1 N @@ -824,11 +813,6 @@ applied_on_1 Y - - base - base_1 - Y - pricelist_id pricelist_id_1 @@ -1053,8 +1037,11 @@ dw bi indoteknik - select pc.product_id, p.template_id, price_before_disc, disc_tier1, -disc_tier2, disc_tier3, disc_tier4, disc_tier5 + select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, +disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, +round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, +round(price_tier3) as price_tier3, round(price_tier4) as price_tier4, +round(price_tier5) as price_tier5 from v_pricelist_compute pc join product p on p.product_id = pc.product_id order by product_id @@ -1088,6 +1075,29 @@ order by product_id 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 @@ -1114,11 +1124,11 @@ order by product_id BigNumber normal - disc_web_tier1 + disc_tier1 -1 -1 price compute - disc_web_tier1 + disc_tier1 ######0.0###################;-######0.0################### . @@ -1181,16 +1191,154 @@ order by product_id N - Integer + BigNumber normal - template_id - 9 - 0 + disc_tier4 + -1 + -1 price compute - template_id - ####0;-####0 + 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 + + + BigNumber + normal + price_tier1 + -1 + -1 + price compute + price_tier1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier2 + -1 + -1 + price compute + price_tier2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier3 + -1 + -1 + price compute + price_tier3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier4 + -1 + -1 + price compute + price_tier4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier5 + -1 + -1 + price compute + price_tier5 + ######0.0###################;-######0.0################### + . + none N @@ -1230,7 +1378,7 @@ order by product_id erp indoteknik local - select * from product_pricelist_item where pricelist_id = 1 order by product_id + select * from product_pricelist_item where pricelist_id = 17022 order by product_id 0 N diff --git a/insert_update_pricelist1.ktr b/insert_update_pricelist1.ktr new file mode 100644 index 0000000..77dc10f --- /dev/null +++ b/insert_update_pricelist1.ktr @@ -0,0 +1,2031 @@ + + + + insert_update_pricelist1 + + + + Normal + 0 + / + + + + + + + + + + + + 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:08:34.331 + - + 2023/08/22 15:08:34.331 + 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_20230914 + 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 + Insert / update 2 + Y + + + Insert / update 2 + Insert / update 3 + Y + + + + Add constants + Constant + + Y + + 1 + + none + + + + + applied_on + String + + + + + 0_product_variant + -1 + -1 + N + + + pricelist_id + Integer + + + + + 17023 + -1 + -1 + N + + + price_discount + Number + + + + + 0 + -1 + -1 + N + + + currency_id + Integer + + + + + 12 + -1 + -1 + N + + + active + Boolean + + + + + true + -1 + -1 + N + + + compute_price + String + + + + + fixed + -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 + + + solr_flag + Integer + + + + + 1 + -1 + -1 + N + + + + + + + + + + + + 592 + 272 + Y + + + + Filter rows + FilterRows + + Y + + 1 + + none + + + Add constants + Write to log + + + N + price_tier1 + <> + fixed_price + + + + + + + + + + + + 464 + 272 + Y + + + + Insert / update + InsertUpdate + + N + + 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 + + + pricelist_id + pricelist_id_1 + N + + + currency_id + currency_id_1 + Y + + + active + active_1 + Y + + + compute_price + compute_price_1 + Y + + + fixed_price + price_tier1 + 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 + + + + + + + + + + + + 736 + 272 + Y + + + + Insert / update 2 + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik local + 100 + N + + public + product_template
+ + template_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 864 + 272 + Y + + + + Insert / update 3 + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik local + 100 + N + + public + product_product
+ + product_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 992 + 272 + Y + + + + Merge join + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + price compute + price erp + + product_id + + + product_id + + + + + + + + + + + 320 + 272 + Y + + + + Write to log + WriteToLog + + Y + + 1 + + none + + + log_level_basic + Y + N + 0 + + + + + + + + + + + + + 464 + 400 + Y + + + + price compute + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, +disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, +round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, +round(price_tier3) as price_tier3, round(price_tier4) as price_tier4, +round(price_tier5) as price_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 + + + BigNumber + normal + price_tier1 + -1 + -1 + price compute + price_tier1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier2 + -1 + -1 + price compute + price_tier2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier3 + -1 + -1 + price compute + price_tier3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier4 + -1 + -1 + price compute + price_tier4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier5 + -1 + -1 + price compute + price_tier5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 224 + 128 + Y + + + + price erp + TableInput + + Y + + 1 + + none + + + erp indoteknik local + select * from product_pricelist_item where pricelist_id = 17023 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 + + + + + + + + + + + + 416 + 128 + Y + + + + + + + N + + diff --git a/insert_update_pricelist2.ktr b/insert_update_pricelist2.ktr new file mode 100644 index 0000000..dd0f6ea --- /dev/null +++ b/insert_update_pricelist2.ktr @@ -0,0 +1,2031 @@ + + + + insert_update_pricelist2 + + + + Normal + 0 + / + + + + + + + + + + + + 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:08:34.331 + - + 2023/08/22 15:08:34.331 + 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_20230914 + 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 + Insert / update 2 + Y + + + Insert / update 2 + Insert / update 3 + Y + + + + Add constants + Constant + + Y + + 1 + + none + + + + + applied_on + String + + + + + 0_product_variant + -1 + -1 + N + + + pricelist_id + Integer + + + + + 17024 + -1 + -1 + N + + + price_discount + Number + + + + + 0 + -1 + -1 + N + + + currency_id + Integer + + + + + 12 + -1 + -1 + N + + + active + Boolean + + + + + true + -1 + -1 + N + + + compute_price + String + + + + + fixed + -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 + + + solr_flag + Integer + + + + + 1 + -1 + -1 + N + + + + + + + + + + + + 592 + 272 + Y + + + + Filter rows + FilterRows + + Y + + 1 + + none + + + Add constants + Write to log + + + N + price_tier2 + <> + fixed_price + + + + + + + + + + + + 464 + 272 + Y + + + + Insert / update + InsertUpdate + + N + + 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 + + + pricelist_id + pricelist_id_1 + N + + + currency_id + currency_id_1 + Y + + + active + active_1 + Y + + + compute_price + compute_price_1 + Y + + + fixed_price + price_tier2 + 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 + + + + + + + + + + + + 736 + 272 + Y + + + + Insert / update 2 + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik local + 100 + N + + public + product_template
+ + template_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 864 + 272 + Y + + + + Insert / update 3 + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik local + 100 + N + + public + product_product
+ + product_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 992 + 272 + Y + + + + Merge join + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + price compute + price erp + + product_id + + + product_id + + + + + + + + + + + 320 + 272 + Y + + + + Write to log + WriteToLog + + Y + + 1 + + none + + + log_level_basic + Y + N + 0 + + + + + + + + + + + + + 464 + 400 + Y + + + + price compute + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, +disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, +round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, +round(price_tier3) as price_tier3, round(price_tier4) as price_tier4, +round(price_tier5) as price_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 + + + BigNumber + normal + price_tier1 + -1 + -1 + price compute + price_tier1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier2 + -1 + -1 + price compute + price_tier2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier3 + -1 + -1 + price compute + price_tier3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier4 + -1 + -1 + price compute + price_tier4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier5 + -1 + -1 + price compute + price_tier5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 224 + 128 + Y + + + + price erp + TableInput + + Y + + 1 + + none + + + erp indoteknik local + select * from product_pricelist_item where pricelist_id = 17024 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 + + + + + + + + + + + + 416 + 128 + Y + + + + + + + N + + diff --git a/insert_update_pricelist3.ktr b/insert_update_pricelist3.ktr new file mode 100644 index 0000000..357db0b --- /dev/null +++ b/insert_update_pricelist3.ktr @@ -0,0 +1,2031 @@ + + + + insert_update_pricelist3 + + + + Normal + 0 + / + + + + + + + + + + + + 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:08:34.331 + - + 2023/08/22 15:08:34.331 + 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_20230914 + 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 + Insert / update 2 + Y + + + Insert / update 2 + Insert / update 3 + Y + + + + Add constants + Constant + + Y + + 1 + + none + + + + + applied_on + String + + + + + 0_product_variant + -1 + -1 + N + + + pricelist_id + Integer + + + + + 17025 + -1 + -1 + N + + + price_discount + Number + + + + + 0 + -1 + -1 + N + + + currency_id + Integer + + + + + 12 + -1 + -1 + N + + + active + Boolean + + + + + true + -1 + -1 + N + + + compute_price + String + + + + + fixed + -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 + + + solr_flag + Integer + + + + + 1 + -1 + -1 + N + + + + + + + + + + + + 592 + 272 + Y + + + + Filter rows + FilterRows + + Y + + 1 + + none + + + Add constants + Write to log + + + N + price_tier3 + <> + fixed_price + + + + + + + + + + + + 464 + 272 + Y + + + + Insert / update + InsertUpdate + + N + + 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 + + + pricelist_id + pricelist_id_1 + N + + + currency_id + currency_id_1 + Y + + + active + active_1 + Y + + + compute_price + compute_price_1 + Y + + + fixed_price + price_tier3 + 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 + + + + + + + + + + + + 736 + 272 + Y + + + + Insert / update 2 + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik local + 100 + N + + public + product_template
+ + template_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 864 + 272 + Y + + + + Insert / update 3 + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik local + 100 + N + + public + product_product
+ + product_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 992 + 272 + Y + + + + Merge join + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + price compute + price erp + + product_id + + + product_id + + + + + + + + + + + 320 + 272 + Y + + + + Write to log + WriteToLog + + Y + + 1 + + none + + + log_level_basic + Y + N + 0 + + + + + + + + + + + + + 464 + 400 + Y + + + + price compute + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, +disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, +round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, +round(price_tier3) as price_tier3, round(price_tier4) as price_tier4, +round(price_tier5) as price_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 + + + BigNumber + normal + price_tier1 + -1 + -1 + price compute + price_tier1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier2 + -1 + -1 + price compute + price_tier2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier3 + -1 + -1 + price compute + price_tier3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier4 + -1 + -1 + price compute + price_tier4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier5 + -1 + -1 + price compute + price_tier5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 224 + 128 + Y + + + + price erp + TableInput + + Y + + 1 + + none + + + erp indoteknik local + select * from product_pricelist_item where pricelist_id = 17025 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 + + + + + + + + + + + + 416 + 128 + Y + + + + + + + N + + diff --git a/insert_update_pricelist4.ktr b/insert_update_pricelist4.ktr new file mode 100644 index 0000000..c8feb72 --- /dev/null +++ b/insert_update_pricelist4.ktr @@ -0,0 +1,2031 @@ + + + + insert_update_pricelist4 + + + + Normal + 0 + / + + + + + + + + + + + + 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:08:34.331 + - + 2023/08/22 15:08:34.331 + 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_20230914 + 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 + Insert / update 2 + Y + + + Insert / update 2 + Insert / update 3 + Y + + + + Add constants + Constant + + Y + + 1 + + none + + + + + applied_on + String + + + + + 0_product_variant + -1 + -1 + N + + + pricelist_id + Integer + + + + + 17026 + -1 + -1 + N + + + price_discount + Number + + + + + 0 + -1 + -1 + N + + + currency_id + Integer + + + + + 12 + -1 + -1 + N + + + active + Boolean + + + + + true + -1 + -1 + N + + + compute_price + String + + + + + fixed + -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 + + + solr_flag + Integer + + + + + 1 + -1 + -1 + N + + + + + + + + + + + + 592 + 272 + Y + + + + Filter rows + FilterRows + + Y + + 1 + + none + + + Add constants + Write to log + + + N + price_tier4 + <> + fixed_price + + + + + + + + + + + + 464 + 272 + Y + + + + Insert / update + InsertUpdate + + N + + 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 + + + pricelist_id + pricelist_id_1 + N + + + currency_id + currency_id_1 + Y + + + active + active_1 + Y + + + compute_price + compute_price_1 + Y + + + fixed_price + price_tier4 + 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 + + + + + + + + + + + + 736 + 272 + Y + + + + Insert / update 2 + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik local + 100 + N + + public + product_template
+ + template_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 864 + 272 + Y + + + + Insert / update 3 + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik local + 100 + N + + public + product_product
+ + product_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 992 + 272 + Y + + + + Merge join + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + price compute + price erp + + product_id + + + product_id + + + + + + + + + + + 320 + 272 + Y + + + + Write to log + WriteToLog + + Y + + 1 + + none + + + log_level_basic + Y + N + 0 + + + + + + + + + + + + + 464 + 400 + Y + + + + price compute + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, +disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, +round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, +round(price_tier3) as price_tier3, round(price_tier4) as price_tier4, +round(price_tier5) as price_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 + + + BigNumber + normal + price_tier1 + -1 + -1 + price compute + price_tier1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier2 + -1 + -1 + price compute + price_tier2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier3 + -1 + -1 + price compute + price_tier3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier4 + -1 + -1 + price compute + price_tier4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier5 + -1 + -1 + price compute + price_tier5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 224 + 128 + Y + + + + price erp + TableInput + + Y + + 1 + + none + + + erp indoteknik local + select * from product_pricelist_item where pricelist_id = 17026 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 + + + + + + + + + + + + 416 + 128 + Y + + + + + + + N + + diff --git a/insert_update_pricelist5.ktr b/insert_update_pricelist5.ktr new file mode 100644 index 0000000..e747546 --- /dev/null +++ b/insert_update_pricelist5.ktr @@ -0,0 +1,2031 @@ + + + + insert_update_pricelist5 + + + + Normal + 0 + / + + + + + + + + + + + + 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:08:34.331 + - + 2023/08/22 15:08:34.331 + 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_20230914 + 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 + Insert / update 2 + Y + + + Insert / update 2 + Insert / update 3 + Y + + + + Add constants + Constant + + Y + + 1 + + none + + + + + applied_on + String + + + + + 0_product_variant + -1 + -1 + N + + + pricelist_id + Integer + + + + + 17027 + -1 + -1 + N + + + price_discount + Number + + + + + 0 + -1 + -1 + N + + + currency_id + Integer + + + + + 12 + -1 + -1 + N + + + active + Boolean + + + + + true + -1 + -1 + N + + + compute_price + String + + + + + fixed + -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 + + + solr_flag + Integer + + + + + 1 + -1 + -1 + N + + + + + + + + + + + + 592 + 272 + Y + + + + Filter rows + FilterRows + + Y + + 1 + + none + + + Add constants + Write to log + + + N + price_tier5 + <> + fixed_price + + + + + + + + + + + + 464 + 272 + Y + + + + Insert / update + InsertUpdate + + N + + 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 + + + pricelist_id + pricelist_id_1 + N + + + currency_id + currency_id_1 + Y + + + active + active_1 + Y + + + compute_price + compute_price_1 + Y + + + fixed_price + price_tier5 + 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 + + + + + + + + + + + + 736 + 272 + Y + + + + Insert / update 2 + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik local + 100 + N + + public + product_template
+ + template_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 864 + 272 + Y + + + + Insert / update 3 + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik local + 100 + N + + public + product_product
+ + product_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 992 + 272 + Y + + + + Merge join + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + price compute + price erp + + product_id + + + product_id + + + + + + + + + + + 320 + 272 + Y + + + + Write to log + WriteToLog + + Y + + 1 + + none + + + log_level_basic + Y + N + 0 + + + + + + + + + + + + + 464 + 400 + Y + + + + price compute + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, +disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, +round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, +round(price_tier3) as price_tier3, round(price_tier4) as price_tier4, +round(price_tier5) as price_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 + + + BigNumber + normal + price_tier1 + -1 + -1 + price compute + price_tier1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier2 + -1 + -1 + price compute + price_tier2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier3 + -1 + -1 + price compute + price_tier3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier4 + -1 + -1 + price compute + price_tier4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + price_tier5 + -1 + -1 + price compute + price_tier5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 224 + 128 + Y + + + + price erp + TableInput + + Y + + 1 + + none + + + erp indoteknik local + select * from product_pricelist_item where pricelist_id = 17027 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 + + + + + + + + + + + + 416 + 128 + Y + + + + + + + N + + diff --git a/insert_update_tier2.ktr b/insert_update_tier2.ktr deleted file mode 100644 index e2bc45e..0000000 --- a/insert_update_tier2.ktr +++ /dev/null @@ -1,1934 +0,0 @@ - - - - insert_update_tier2 - - - - 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:45:10.930 - - - 2023/08/22 15:45:10.930 - 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 - - - - - 15037 - -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 - - - - - - - - - - - - 592 - 272 - Y - - - - Filter rows - FilterRows - - Y - - 1 - - none - - - Add constants - Write to log - - - N - disc_tier2 - <> - price_discount - - - - - - - - - - - - 464 - 272 - 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_tier2 - Y - - - - - - - - - - - - 736 - 272 - Y - - - - Insert / update 2 - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik local - 100 - N - - public - product_template
- - template_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 896 - 272 - Y - - - - Insert / update 3 - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik local - 100 - N - - public - product_product
- - product_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 1024 - 272 - Y - - - - Merge join - MergeJoin - - Y - - 1 - - none - - - LEFT OUTER - price compute - price erp - - product_id - - - product_id - - - - - - - - - - - 320 - 272 - Y - - - - Write to log - WriteToLog - - Y - - 1 - - none - - - log_level_basic - Y - N - 0 - - - - - - - - - - - - - 464 - 400 - 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 - - - - - - - - - - - - 224 - 128 - Y - - - - price erp - TableInput - - Y - - 1 - - none - - - erp indoteknik local - select * from product_pricelist_item where pricelist_id = 15037 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 - - - - - - - - - - - - 416 - 128 - Y - - - - - - - N - - 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 - - diff --git a/insert_update_tier4.ktr b/insert_update_tier4.ktr deleted file mode 100644 index fb774d8..0000000 --- a/insert_update_tier4.ktr +++ /dev/null @@ -1,1935 +0,0 @@ - - - - insert_update_tier4 - - - - Normal - 0 - / - - - - - - - - - - - - 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_20230913 - 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 - - - - - 15039 - -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_tier4 - <> - 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_tier4 - 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 = 15039 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 - - diff --git a/insert_update_tier5.ktr b/insert_update_tier5.ktr deleted file mode 100644 index d759ef5..0000000 --- a/insert_update_tier5.ktr +++ /dev/null @@ -1,1935 +0,0 @@ - - - - insert_update_tier5 - - - - Normal - 0 - / - - - - - - - - - - - - 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_20230913 - 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 - - - - - 15235 - -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_tier5 - <> - 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_tier5 - 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 = 15235 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