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_sale_order.ktr | 324 +++++++++++++++++++++++++------------------------- 1 file changed, 162 insertions(+), 162 deletions(-) (limited to 'import_sale_order.ktr') 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 - - -- cgit v1.2.3