From a93d47cdbb383b9c17c44f676ea7bca813a3eb5a Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 11 Jun 2024 13:26:28 +0700 Subject: change source purchase order dw --- import_purchase_order.ktr | 53 +---------------------------------------------- 1 file changed, 1 insertion(+), 52 deletions(-) diff --git a/import_purchase_order.ktr b/import_purchase_order.ktr index 7262513..d68ab6b 100644 --- a/import_purchase_order.ktr +++ b/import_purchase_order.ktr @@ -486,57 +486,6 @@ - - erp indoteknik production (localhost) - 10.148.0.3 - POSTGRESQL - Native - erp_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 - - - Table input @@ -555,7 +504,7 @@ none - erp indoteknik production (localhost) + dw bi indoteknik (localhost) select po.write_date as po_date, pol.write_date as line_date, po.name as documentno, po.state, po.partner_id, rp.name as vendor, pol.product_id, pol.product_uom_qty as qty, pol.price_unit, pol.price_subtotal, pol.id as line_id, -- cgit v1.2.3