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_leadtime_so_send_detail.ktr | 1660 ++++++++++++++++++------------------ 1 file changed, 814 insertions(+), 846 deletions(-) (limited to 'import_leadtime_so_send_detail.ktr') 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 -- cgit v1.2.3