From 378be935ef27121019d2e648212e34b05e02fe3b Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Wed, 20 Sep 2023 10:49:12 +0700 Subject: migrate to gcp (test) --- import_accurate_fixco_to_data_warehouse.ktr | 8 +- import_accurate_to_data_warehouse.ktr | 24 +- import_adempiere_to_data_warehouse.ktr | 68 +- import_data_bi.sh | 2 +- import_leadtime_po_to_received.ktr | 373 +++--- import_leadtime_po_to_received_detail.ktr | 268 ++--- import_leadtime_so_send.ktr | 39 +- import_leadtime_so_send_detail.ktr | 1660 +++++++++++++-------------- import_margin.ktr | 18 +- import_odoo_14_to_data_warehouse.ktr | 18 +- import_sale_order.ktr | 324 +++--- refresh_materialized_view_fixco.ktr | 18 +- refresh_materialized_view_pricelist.ktr | 12 +- 13 files changed, 1389 insertions(+), 1443 deletions(-) diff --git a/import_accurate_fixco_to_data_warehouse.ktr b/import_accurate_fixco_to_data_warehouse.ktr index e30b7b6..f92adc0 100644 --- a/import_accurate_fixco_to_data_warehouse.ktr +++ b/import_accurate_fixco_to_data_warehouse.ktr @@ -436,14 +436,14 @@ - dw bi fixco - 192.168.23.5 + dw bi fixco (localhost) + localhost POSTGRESQL Native dw_bi_fixco 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -598,7 +598,7 @@ none - dw bi fixco + dw bi fixco (localhost) 100 N diff --git a/import_accurate_to_data_warehouse.ktr b/import_accurate_to_data_warehouse.ktr index 778b90c..5f0fad1 100644 --- a/import_accurate_to_data_warehouse.ktr +++ b/import_accurate_to_data_warehouse.ktr @@ -436,14 +436,14 @@ - dw bi fixco - 192.168.23.5 + dw bi fixco (localhost) + localhost POSTGRESQL Native dw_bi_fixco 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -487,14 +487,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -529,7 +529,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -659,7 +659,7 @@ none - dw bi fixco + dw bi fixco (localhost) 100 N @@ -727,7 +727,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) 100 N @@ -1041,27 +1041,21 @@ invoice - date_invoice - customer - total - subtotal - salesperson - N diff --git a/import_adempiere_to_data_warehouse.ktr b/import_adempiere_to_data_warehouse.ktr index 46f7ec7..7da86fc 100644 --- a/import_adempiere_to_data_warehouse.ktr +++ b/import_adempiere_to_data_warehouse.ktr @@ -486,6 +486,57 @@ + + dw bi indoteknik (localhost) + localhost + POSTGRESQL + Native + dw_bi_indoteknik + 5432 + odoo + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 + + + + + + FORCE_IDENTIFIERS_TO_LOWERCASE + N + + + FORCE_IDENTIFIERS_TO_UPPERCASE + N + + + IS_CLUSTERED + N + + + PORT_NUMBER + 5432 + + + PRESERVE_RESERVED_WORD_CASE + Y + + + QUOTE_ALL_FIELDS + N + + + SUPPORTS_BOOLEAN_DATA_TYPE + Y + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + + + erp indoteknik production 34.101.171.249 @@ -1160,51 +1211,39 @@ customer - invoice_date - price_subtotal - invoice - quantity - product - brand - salesperson - name - value - odoo_partner_name - industry - N @@ -1833,7 +1872,7 @@ where reference_number is not null none - dw bi indoteknik + dw bi indoteknik (localhost) 100 N @@ -1935,15 +1974,12 @@ where reference_number is not null name - reference_number - industry - N diff --git a/import_data_bi.sh b/import_data_bi.sh index 082f487..4075cbb 100644 --- a/import_data_bi.sh +++ b/import_data_bi.sh @@ -1 +1 @@ -sh /opt/data-integration/kitchen.sh -file="/home/stephan/transformation-job-bi/import_all_data_bi_indoteknik.kjb" > "/home/stephan/transformation-job-bi/log/import.log" +sh /home/stephan/data-integration/kitchen.sh -level="Debug" -file="/home/stephan/transformation-job-bi/import_all_data_bi_indoteknik.kjb" > "/home/stephan/transformation-job-bi/log/import.log" diff --git a/import_leadtime_po_to_received.ktr b/import_leadtime_po_to_received.ktr index 2a59cb7..b538184 100644 --- a/import_leadtime_po_to_received.ktr +++ b/import_leadtime_po_to_received.ktr @@ -430,20 +430,20 @@ 2023/03/15 11:47:24.742 - 2023/03/15 11:47:24.742 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -478,7 +478,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -487,8 +487,8 @@ - erp indoteknik production - 34.101.171.249 + erp indoteknik production (localhost) + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -529,7 +529,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -549,6 +549,176 @@ Y + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + leadtime_po_to_received
+ + id + id + = + + + + id + id + N + + + vendor + vendor + Y + + + name + name + Y + + + year_month + year_month + Y + + + year + year + Y + + + month + month + Y + + + day + day + Y + + + date_po + date_po + Y + + + date_last_received + date_last_received + Y + + + difference + difference + Y + + + diff_in_day + diff_in_day + Y + + + diff_in_hour + diff_in_hour + Y + + + login + login + Y + + + + + + + + + + + + 704 + 144 + Y + + + + Select values + SelectValues + + Y + + 1 + + none + + + + + id + + + vendor + + + name + + + year_month + + + year + + + month + + + day + + + date_po + + + date_last_received + + + difference + + + diff_in_day + + + diff_in_hour + + + login + + N + + + + + + + + + + + 560 + 144 + Y + + Table input TableInput @@ -560,7 +730,7 @@ none - erp indoteknik production + erp indoteknik production (localhost) select * from v_leadtime_po_to_received 0 @@ -804,7 +974,7 @@ normal difference -1 - 6 + -1 Table input difference @@ -883,189 +1053,6 @@ Y - - Select values - SelectValues - - Y - - 1 - - none - - - - - id - - - - vendor - - - - name - - - - year_month - - - - year - - - - month - - - - day - - - - date_po - - - - date_last_received - - - - difference - - - - diff_in_day - - - - diff_in_hour - - - - login - - - N - - - - - - - - - - - 560 - 144 - Y - - - - Insert / update - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik - 100 - N - - public - leadtime_po_to_received
- - id - id - = - - - - id - id - N - - - vendor - vendor - Y - - - name - name - Y - - - year_month - year_month - Y - - - year - year - Y - - - month - month - Y - - - day - day - Y - - - date_po - date_po - Y - - - date_last_received - date_last_received - Y - - - difference - difference - Y - - - diff_in_day - diff_in_day - Y - - - diff_in_hour - diff_in_hour - Y - - - login - login - Y - - - - - - - - - - - - 704 - 144 - Y - - diff --git a/import_leadtime_po_to_received_detail.ktr b/import_leadtime_po_to_received_detail.ktr index bdff8af..fe0b34c 100644 --- a/import_leadtime_po_to_received_detail.ktr +++ b/import_leadtime_po_to_received_detail.ktr @@ -430,20 +430,20 @@ 2023/03/16 13:25:37.713 - 2023/03/16 13:25:37.713 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -478,7 +478,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -487,8 +487,8 @@ - erp indoteknik production - 34.101.171.249 + erp indoteknik production (localhost) + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -529,7 +529,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -549,140 +549,6 @@ Y - - Table input - TableInput - - Y - - 1 - - none - - - erp indoteknik production - select * from v_leadtime_po_to_received_detail - 0 - - N - N - N - N - - - - - - - - - - - 272 - 64 - Y - - - - Select values - SelectValues - - Y - - 1 - - none - - - - - line_id - - - - header_id - - - - vendor - - - - name - - - - year_month - - - - year - - - - month - - - - day - - - - date_po - - - - date_last_received - - - - login - - - - brand - - - - product - - - - item_code - - - - product_uom_qty - - - - qty_received - - - - price_unit - - - - price_subtotal - - - N - - - - - - - - - - - 416 - 64 - Y - - Insert / update InsertUpdate @@ -694,7 +560,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) 100 N @@ -811,6 +677,122 @@ Y + + Select values + SelectValues + + Y + + 1 + + none + + + + + line_id + + + header_id + + + vendor + + + name + + + year_month + + + year + + + month + + + day + + + date_po + + + date_last_received + + + login + + + brand + + + product + + + item_code + + + product_uom_qty + + + qty_received + + + price_unit + + + price_subtotal + + N + + + + + + + + + + + 416 + 64 + Y + + + + Table input + TableInput + + Y + + 1 + + none + + + erp indoteknik production (localhost) + select * from v_leadtime_po_to_received_detail + 0 + + N + N + N + N + + + + + + + + + + + 272 + 64 + Y + + diff --git a/import_leadtime_so_send.ktr b/import_leadtime_so_send.ktr index c34183d..a82b9b8 100644 --- a/import_leadtime_so_send.ktr +++ b/import_leadtime_so_send.ktr @@ -436,14 +436,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -478,7 +478,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -487,8 +487,8 @@ - erp indoteknik production - 34.101.171.249 + erp indoteknik production (localhost) + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -529,7 +529,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -560,7 +560,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) 100 N @@ -706,87 +706,66 @@ id - so_number - customer - date_so_approved - date_po_approved - date_last_received - date_last_send - diff_po_so - diff_po_so_in_hour - diff_received_po - diff_received_po_in_day - diff_received_send - diff_received_send_in_hour - diff_received_send_in_day - diff_so_send - diff_so_send_in_day - year_month - year - month - day - diff_po_so_in_day - N @@ -815,7 +794,7 @@ none - erp indoteknik production + erp indoteknik production (localhost) select * from v_leadtime_so_to_send_wf 0 diff --git a/import_leadtime_so_send_detail.ktr b/import_leadtime_so_send_detail.ktr index 7f15068..8c7b72a 100644 --- a/import_leadtime_so_send_detail.ktr +++ b/import_leadtime_so_send_detail.ktr @@ -430,20 +430,20 @@ 2023/03/16 14:05:50.350 - 2023/03/16 14:05:50.350 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -478,7 +478,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -487,8 +487,8 @@ - erp indoteknik production - 34.101.171.249 + erp indoteknik production (localhost) + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -529,7 +529,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -550,8 +550,8 @@ - Table input - TableInput + Insert / update + InsertUpdate Y @@ -560,345 +560,345 @@ none - erp indoteknik production - select * from v_leadtime_so_to_send_detail_wf - 0 - - N - N - N - N - - - Integer - normal + dw bi indoteknik (localhost) + 100 + N + + public + leadtime_so_to_send_detail
+ line_id - 9 - 0 - Table input - line_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + line_id + = + + + + line_id + line_id + N + + header_id - 9 - 0 - Table input - header_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + header_id + Y + + so_number - 2147483647 - -1 - Table input - so_number - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + so_number + Y + + customer - 2147483647 - -1 - Table input - customer - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Timestamp - normal + customer + Y + + date_so_approved - 6 - -1 - Table input - date_so_approved - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Timestamp - normal + date_so_approved + Y + + date_po_approved - 6 - -1 - Table input - date_po_approved - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Timestamp - normal + date_po_approved + Y + + date_last_received - 6 - -1 - Table input - date_last_received - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Timestamp - normal + date_last_received + Y + + date_last_send - 6 - -1 - Table input - date_last_send - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + date_last_send + Y + + diff_po_so - -1 - 6 - Table input - diff_po_so - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + diff_po_so + Y + + diff_po_so_in_hour - 9 - 0 - Table input - diff_po_so_in_hour - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + diff_po_so_in_hour + Y + + diff_received_po - -1 - 6 - Table input - diff_received_po - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + diff_received_po + Y + + diff_received_po_in_day - 9 - 0 - Table input - diff_received_po_in_day - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + diff_received_po_in_day + Y + + diff_received_send - -1 - 6 - Table input - diff_received_send - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + diff_received_send + Y + + diff_received_send_in_hour - 9 - 0 - Table input - diff_received_send_in_hour - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - + diff_received_send_in_hour + Y + + + diff_received_send_in_day + diff_received_send_in_day + Y + + + diff_so_send + diff_so_send + Y + + + diff_so_send_in_day + diff_so_send_in_day + Y + + + year_month + year_month + Y + + + year + year + Y + + + month + month + Y + + + day + day + Y + + + diff_po_so_in_day + diff_po_so_in_day + Y + + + salesperson + salesperson + Y + + + brand + brand + Y + + + product + product + Y + + + item_code + item_code + Y + + + product_uom_qty + product_uom_qty + Y + + + qty_delivered + qty_delivered + Y + + + qty_invoiced + qty_invoiced + Y + + + price_unit + price_unit + Y + + + price_subtotal + price_subtotal + Y + + + price_total + price_total + Y + + + + + + + + + + + + 528 + 144 + Y + + + + Select values + SelectValues + + Y + + 1 + + none + + + + + line_id + + + header_id + + + so_number + + + customer + + + date_so_approved + + + date_po_approved + + + date_last_received + + + date_last_send + + + diff_po_so + + + diff_po_so_in_hour + + + diff_received_po + + + diff_received_po_in_day + + + diff_received_send + + + diff_received_send_in_hour + + + diff_received_send_in_day + + + diff_so_send + + + diff_so_send_in_day + + + year_month + + + year + + + month + + + day + + + diff_po_so_in_day + + + salesperson + + + brand + + + product + + + item_code + + + product_uom_qty + + + qty_delivered + + + qty_invoiced + + + price_unit + + + price_subtotal + + + price_total + + N + + + + + + + + + + + 400 + 144 + Y + + + + Table input + TableInput + + Y + + 1 + + none + + + erp indoteknik production (localhost) + select * from v_leadtime_so_to_send_detail_wf + 0 + + N + N + N + N + Integer normal - diff_received_send_in_day + line_id 9 0 Table input - diff_received_send_in_day + line_id ####0;-####0 . , @@ -914,37 +914,14 @@ Asia/Bangkok N - - String - normal - diff_so_send - -1 - 6 - Table input - diff_so_send - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - Integer normal - diff_so_send_in_day + header_id 9 0 Table input - diff_so_send_in_day + header_id ####0;-####0 . , @@ -963,11 +940,11 @@ String normal - year_month + so_number 2147483647 -1 Table input - year_month + so_number . , @@ -986,11 +963,11 @@ String normal - year + customer 2147483647 -1 Table input - year + customer . , @@ -1007,13 +984,13 @@ N - String + Timestamp normal - month - 2147483647 + date_so_approved + 6 -1 Table input - month + date_so_approved . , @@ -1030,13 +1007,13 @@ N - String + Timestamp normal - day - 2147483647 + date_po_approved + 6 -1 Table input - day + date_po_approved . , @@ -1053,36 +1030,13 @@ N - Integer - normal - diff_po_so_in_day - 9 - 0 - Table input - diff_po_so_in_day - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String + Timestamp normal - salesperson - 2147483647 + date_last_received + 6 -1 Table input - salesperson + date_last_received . , @@ -1099,13 +1053,13 @@ N - String + Timestamp normal - brand - 2147483647 + date_last_send + 6 -1 Table input - brand + date_last_send . , @@ -1124,11 +1078,11 @@ String normal - product - 2147483647 + diff_po_so + -1 -1 Table input - product + diff_po_so . , @@ -1145,14 +1099,14 @@ N - String + Integer normal - item_code - 2147483647 - -1 + diff_po_so_in_hour + 9 + 0 Table input - item_code - + diff_po_so_in_hour + ####0;-####0 . , @@ -1168,108 +1122,16 @@ N - BigNumber - normal - product_uom_qty - -1 - -1 - Table input - product_uom_qty - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - qty_delivered - -1 - -1 - Table input - qty_delivered - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - qty_invoiced - -1 - -1 - Table input - qty_invoiced - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - price_unit - -1 - -1 - Table input - price_unit - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber + String normal - price_subtotal + diff_received_po -1 -1 Table input - price_subtotal - ######0.0###################;-######0.0################### + diff_received_po + . - + , none N @@ -1283,16 +1145,16 @@ N - BigNumber + Integer normal - price_total - -1 - -1 + diff_received_po_in_day + 9 + 0 Table input - price_total - ######0.0###################;-######0.0################### + diff_received_po_in_day + ####0;-####0 . - + , none N @@ -1305,361 +1167,467 @@ Asia/Bangkok N - - - - - - - - - - - 240 - 144 - Y - - - - Select values - SelectValues - - Y - - 1 - - none - - - - - line_id - - - - header_id - - - - so_number - - - - customer - - - - date_so_approved - - - - date_po_approved - - - - date_last_received - - - - date_last_send - - - - diff_po_so - - - - diff_po_so_in_hour - - - - diff_received_po - - - - diff_received_po_in_day - - - - diff_received_send - - - - diff_received_send_in_hour - - - - diff_received_send_in_day - - - - diff_so_send - - - - diff_so_send_in_day - - - - year_month - - - - year - - - - month - - - - day - - - - diff_po_so_in_day - - - - salesperson - - - - brand - - - - product - - - - item_code - - - - product_uom_qty - - - - qty_delivered - - - - qty_invoiced - - - - price_unit - - - - price_subtotal - - - - price_total - - - N - - - - - - - - - - - 400 - 144 - Y - - - - Insert / update - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik - 100 - N - - public - leadtime_so_to_send_detail
- - line_id - line_id - = - - - - line_id - line_id - N - - - header_id - header_id - Y - - - so_number - so_number - Y - - - customer - customer - Y - - - date_so_approved - date_so_approved - Y - - - date_po_approved - date_po_approved - Y - - - date_last_received - date_last_received - Y - - - date_last_send - date_last_send - Y - - - diff_po_so - diff_po_so - Y - - - diff_po_so_in_hour - diff_po_so_in_hour - Y - - - diff_received_po - diff_received_po - Y - - - diff_received_po_in_day - diff_received_po_in_day - Y - - + + String + normal diff_received_send - diff_received_send - Y - - + -1 + -1 + Table input + diff_received_send + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal diff_received_send_in_hour - diff_received_send_in_hour - Y - - + 9 + 0 + Table input + diff_received_send_in_hour + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal diff_received_send_in_day - diff_received_send_in_day - Y - - + 9 + 0 + Table input + diff_received_send_in_day + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal diff_so_send - diff_so_send - Y - - + -1 + -1 + Table input + diff_so_send + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal diff_so_send_in_day - diff_so_send_in_day - Y - - + 9 + 0 + Table input + diff_so_send_in_day + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal year_month - year_month - Y - - + 2147483647 + -1 + Table input + year_month + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal year - year - Y - - + 2147483647 + -1 + Table input + year + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal month - month - Y - - + 2147483647 + -1 + Table input + month + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal day - day - Y - - + 2147483647 + -1 + Table input + day + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal diff_po_so_in_day - diff_po_so_in_day - Y - - + 9 + 0 + Table input + diff_po_so_in_day + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal salesperson - salesperson - Y - - + 2147483647 + -1 + Table input + salesperson + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal brand - brand - Y - - + 2147483647 + -1 + Table input + brand + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal product - product - Y - - + 2147483647 + -1 + Table input + product + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal item_code - item_code - Y - - + 2147483647 + -1 + Table input + item_code + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal product_uom_qty - product_uom_qty - Y - - + -1 + -1 + Table input + product_uom_qty + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal qty_delivered - qty_delivered - Y - - + -1 + -1 + Table input + qty_delivered + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal qty_invoiced - qty_invoiced - Y - - + -1 + -1 + Table input + qty_invoiced + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal price_unit - price_unit - Y - - + -1 + -1 + Table input + price_unit + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal price_subtotal - price_subtotal - Y - - + -1 + -1 + Table input + price_subtotal + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal price_total - price_total - Y - - + -1 + -1 + Table input + price_total + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + @@ -1669,7 +1637,7 @@ - 528 + 240 144 Y diff --git a/import_margin.ktr b/import_margin.ktr index 21e61b8..bef710a 100644 --- a/import_margin.ktr +++ b/import_margin.ktr @@ -436,14 +436,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -478,7 +478,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -487,8 +487,8 @@ - erp indoteknik production - 34.101.171.249 + erp indoteknik production (localhost) + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -529,7 +529,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -555,7 +555,7 @@ none - erp indoteknik production + erp indoteknik production (localhost) select * from v_margin_sale_order 0 @@ -843,7 +843,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) 100 N diff --git a/import_odoo_14_to_data_warehouse.ktr b/import_odoo_14_to_data_warehouse.ktr index c12bd7b..3791db9 100644 --- a/import_odoo_14_to_data_warehouse.ktr +++ b/import_odoo_14_to_data_warehouse.ktr @@ -436,14 +436,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -478,7 +478,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -487,8 +487,8 @@ - erp indoteknik production - 34.101.171.249 + erp indoteknik production (localhost) + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -529,7 +529,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -560,7 +560,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) 100 N @@ -771,7 +771,7 @@ none - erp indoteknik production + erp indoteknik production (localhost) select * from v_total_omzet_by_invoice 0 diff --git a/import_sale_order.ktr b/import_sale_order.ktr index 360cf8a..f165134 100644 --- a/import_sale_order.ktr +++ b/import_sale_order.ktr @@ -430,20 +430,20 @@ 2023/08/09 14:54:40.577 - 2023/08/09 14:54:40.577 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -478,7 +478,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -487,8 +487,8 @@ - erp indoteknik production - 34.101.171.249 + erp indoteknik production (localhost) + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -529,7 +529,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -544,6 +544,159 @@ Y + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + sale_order
+ + orderline_id + orderline_id + = + + + + orderline_id + orderline_id + N + + + order_id + order_id + Y + + + documentno + documentno + Y + + + industry + industry + Y + + + customer + customer + Y + + + date_order + date_order + Y + + + write_date + write_date + Y + + + brand + brand + Y + + + product + product + Y + + + item_code + item_code + Y + + + qty + qty + Y + + + price_unit + price_unit + Y + + + discount + discount + Y + + + price_subtotal + price_subtotal + Y + + + price_total + price_total + Y + + + state + state + Y + + + salesperson + salesperson + Y + + + year_month_invoice_date + year_month_invoice_date + Y + + + year + year + Y + + + month + month + Y + + + quarter + quarter + Y + + + product_id + product_id + Y + + + brand_id + brand_id + Y + + + + + + + + + + + + 400 + 112 + Y + + Table input TableInput @@ -555,7 +708,7 @@ none - erp indoteknik production + erp indoteknik production (localhost) select * from v_sale_order 0 @@ -1062,159 +1215,6 @@ Y - - Insert / update - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik - 100 - N - - public - sale_order
- - orderline_id - orderline_id - = - - - - orderline_id - orderline_id - N - - - order_id - order_id - Y - - - documentno - documentno - Y - - - industry - industry - Y - - - customer - customer - Y - - - date_order - date_order - Y - - - write_date - write_date - Y - - - brand - brand - Y - - - product - product - Y - - - item_code - item_code - Y - - - qty - qty - Y - - - price_unit - price_unit - Y - - - discount - discount - Y - - - price_subtotal - price_subtotal - Y - - - price_total - price_total - Y - - - state - state - Y - - - salesperson - salesperson - Y - - - year_month_invoice_date - year_month_invoice_date - Y - - - year - year - Y - - - month - month - Y - - - quarter - quarter - Y - - - product_id - product_id - Y - - - brand_id - brand_id - Y - - - - - - - - - - - - 400 - 112 - Y - - diff --git a/refresh_materialized_view_fixco.ktr b/refresh_materialized_view_fixco.ktr index af911f3..eaf94a6 100644 --- a/refresh_materialized_view_fixco.ktr +++ b/refresh_materialized_view_fixco.ktr @@ -436,14 +436,14 @@ - dw bi fixco - 192.168.23.5 + dw bi fixco (localhost) + localhost POSTGRESQL Native dw_bi_fixco 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -524,7 +524,7 @@ none - dw bi fixco + dw bi fixco (localhost) N N N @@ -562,7 +562,7 @@ none - dw bi fixco + dw bi fixco (localhost) N N N @@ -600,7 +600,7 @@ none - dw bi fixco + dw bi fixco (localhost) N N N @@ -638,7 +638,7 @@ none - dw bi fixco + dw bi fixco (localhost) N N N @@ -676,7 +676,7 @@ none - dw bi fixco + dw bi fixco (localhost) N N N @@ -714,7 +714,7 @@ none - dw bi fixco + dw bi fixco (localhost) N N N diff --git a/refresh_materialized_view_pricelist.ktr b/refresh_materialized_view_pricelist.ktr index ba3da1d..4f65ce0 100644 --- a/refresh_materialized_view_pricelist.ktr +++ b/refresh_materialized_view_pricelist.ktr @@ -430,20 +430,20 @@ 2023/08/22 14:26:27.126 - 2023/08/22 14:26:27.126 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -478,7 +478,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -499,7 +499,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) N N N -- cgit v1.2.3