From b3e01d0afff1fcb1297d4c59ae49fcc6b2205be2 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 19 Sep 2023 09:51:45 +0700 Subject: change to server dev --- import_brand.ktr | 34 ++++++++++++- import_price_group.ktr | 34 ++++++++++++- import_product_product.ktr | 34 ++++++++++++- import_purchase_order.ktr | 34 ++++++++++++- import_purchase_pricelist.ktr | 34 ++++++++++++- insert_update_pricelist.ktr | 110 +++++++++++++++++++++++++++--------------- insert_update_pricelist1.ktr | 110 +++++++++++++++++++++++++++--------------- insert_update_pricelist2.ktr | 110 +++++++++++++++++++++++++++--------------- insert_update_pricelist3.ktr | 110 +++++++++++++++++++++++++++--------------- insert_update_pricelist4.ktr | 110 +++++++++++++++++++++++++++--------------- insert_update_pricelist5.ktr | 110 +++++++++++++++++++++++++++--------------- 11 files changed, 591 insertions(+), 239 deletions(-) diff --git a/import_brand.ktr b/import_brand.ktr index 4bbf1a2..61d0430 100644 --- a/import_brand.ktr +++ b/import_brand.ktr @@ -488,7 +488,7 @@ erp indoteknik production (localhost) - localhost + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -499,10 +499,42 @@ + + 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 + N + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + diff --git a/import_price_group.ktr b/import_price_group.ktr index 8a2460d..9a7b65c 100644 --- a/import_price_group.ktr +++ b/import_price_group.ktr @@ -488,7 +488,7 @@ erp indoteknik production (localhost) - localhost + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -499,10 +499,42 @@ + + 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 + N + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + diff --git a/import_product_product.ktr b/import_product_product.ktr index e668a86..79735f9 100644 --- a/import_product_product.ktr +++ b/import_product_product.ktr @@ -488,7 +488,7 @@ erp indoteknik production (localhost) - localhost + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -499,10 +499,42 @@ + + 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 + N + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + diff --git a/import_purchase_order.ktr b/import_purchase_order.ktr index 3d798b4..fbf52ba 100644 --- a/import_purchase_order.ktr +++ b/import_purchase_order.ktr @@ -488,7 +488,7 @@ erp indoteknik production (localhost) - localhost + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -499,10 +499,42 @@ + + 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 + N + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + diff --git a/import_purchase_pricelist.ktr b/import_purchase_pricelist.ktr index 1de88f4..9913d22 100644 --- a/import_purchase_pricelist.ktr +++ b/import_purchase_pricelist.ktr @@ -488,7 +488,7 @@ erp indoteknik production (localhost) - localhost + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -499,10 +499,42 @@ + + 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 + N + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + diff --git a/insert_update_pricelist.ktr b/insert_update_pricelist.ktr index 63a255a..6010dd3 100644 --- a/insert_update_pricelist.ktr +++ b/insert_update_pricelist.ktr @@ -489,7 +489,7 @@ erp indoteknik production (localhost) - localhost + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -500,10 +500,42 @@ + + 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 + N + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + @@ -724,6 +756,44 @@ Y + + Execute SQL script + ExecSQL + + Y + + 1 + + none + + + erp indoteknik production (localhost) + N + N + N + N + update product_pricelist_item set active = 'true' where pricelist_id = 17022; + N + + + + + + + + + + + + + + + + 1120 + 272 + Y + + Filter rows FilterRows @@ -2007,44 +2077,6 @@ order by product_id Y - - Execute SQL script - ExecSQL - - Y - - 1 - - none - - - erp indoteknik production (localhost) - N - N - N - N - update product_pricelist_item set active = 'true' where pricelist_id = 17022; - N - - - - - - - - - - - - - - - - 1120 - 272 - Y - - diff --git a/insert_update_pricelist1.ktr b/insert_update_pricelist1.ktr index cb55534..45a5cbc 100644 --- a/insert_update_pricelist1.ktr +++ b/insert_update_pricelist1.ktr @@ -489,7 +489,7 @@ erp indoteknik production (localhost) - localhost + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -500,10 +500,42 @@ + + 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 + N + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + @@ -724,6 +756,44 @@ Y + + Execute SQL script + ExecSQL + + Y + + 1 + + none + + + erp indoteknik production (localhost) + N + N + N + N + update product_pricelist_item set active = 'true' where pricelist_id = 17023; + N + + + + + + + + + + + + + + + + 1120 + 272 + Y + + Filter rows FilterRows @@ -2012,44 +2082,6 @@ order by product_id Y - - Execute SQL script - ExecSQL - - Y - - 1 - - none - - - erp indoteknik production (localhost) - N - N - N - N - update product_pricelist_item set active = 'true' where pricelist_id = 17023; - N - - - - - - - - - - - - - - - - 1120 - 272 - Y - - diff --git a/insert_update_pricelist2.ktr b/insert_update_pricelist2.ktr index 2c8a66c..75dfa41 100644 --- a/insert_update_pricelist2.ktr +++ b/insert_update_pricelist2.ktr @@ -489,7 +489,7 @@ erp indoteknik production (localhost) - localhost + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -500,10 +500,42 @@ + + 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 + N + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + @@ -724,6 +756,44 @@ Y + + Execute SQL script + ExecSQL + + Y + + 1 + + none + + + erp indoteknik production (localhost) + N + N + N + N + update product_pricelist_item set active = 'true' where pricelist_id = 17024; + N + + + + + + + + + + + + + + + + 1152 + 272 + Y + + Filter rows FilterRows @@ -2012,44 +2082,6 @@ order by product_id Y - - Execute SQL script - ExecSQL - - Y - - 1 - - none - - - erp indoteknik production (localhost) - N - N - N - N - update product_pricelist_item set active = 'true' where pricelist_id = 17024; - N - - - - - - - - - - - - - - - - 1152 - 272 - Y - - diff --git a/insert_update_pricelist3.ktr b/insert_update_pricelist3.ktr index 7de2e7f..a81e151 100644 --- a/insert_update_pricelist3.ktr +++ b/insert_update_pricelist3.ktr @@ -489,7 +489,7 @@ erp indoteknik production (localhost) - localhost + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -500,10 +500,42 @@ + + 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 + N + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + @@ -724,6 +756,44 @@ Y + + Execute SQL script + ExecSQL + + Y + + 1 + + none + + + erp indoteknik production (localhost) + N + N + N + N + update product_pricelist_item set active = 'true' where pricelist_id = 17025; + N + + + + + + + + + + + + + + + + 1136 + 272 + Y + + Filter rows FilterRows @@ -2012,44 +2082,6 @@ order by product_id Y - - Execute SQL script - ExecSQL - - Y - - 1 - - none - - - erp indoteknik production (localhost) - N - N - N - N - update product_pricelist_item set active = 'true' where pricelist_id = 17025; - N - - - - - - - - - - - - - - - - 1136 - 272 - Y - - diff --git a/insert_update_pricelist4.ktr b/insert_update_pricelist4.ktr index 5914e97..cfd03ad 100644 --- a/insert_update_pricelist4.ktr +++ b/insert_update_pricelist4.ktr @@ -489,7 +489,7 @@ erp indoteknik production (localhost) - localhost + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -500,10 +500,42 @@ + + 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 + N + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + @@ -724,6 +756,44 @@ Y + + Execute SQL script + ExecSQL + + Y + + 1 + + none + + + erp indoteknik production (localhost) + N + N + N + N + update product_pricelist_item set active = 'true' where pricelist_id = 17026; + N + + + + + + + + + + + + + + + + 1152 + 272 + Y + + Filter rows FilterRows @@ -2012,44 +2082,6 @@ order by product_id Y - - Execute SQL script - ExecSQL - - Y - - 1 - - none - - - erp indoteknik production (localhost) - N - N - N - N - update product_pricelist_item set active = 'true' where pricelist_id = 17026; - N - - - - - - - - - - - - - - - - 1152 - 272 - Y - - diff --git a/insert_update_pricelist5.ktr b/insert_update_pricelist5.ktr index b6c99e3..0a4a6bf 100644 --- a/insert_update_pricelist5.ktr +++ b/insert_update_pricelist5.ktr @@ -489,7 +489,7 @@ erp indoteknik production (localhost) - localhost + 10.148.0.3 POSTGRESQL Native erp_indoteknik @@ -500,10 +500,42 @@ + + 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 + N + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + @@ -724,6 +756,44 @@ Y + + Execute SQL script + ExecSQL + + Y + + 1 + + none + + + erp indoteknik production (localhost) + N + N + N + N + update product_pricelist_item set active = 'true' where pricelist_id = 17027; + N + + + + + + + + + + + + + + + + 1152 + 272 + Y + + Filter rows FilterRows @@ -2012,44 +2082,6 @@ order by product_id Y - - Execute SQL script - ExecSQL - - Y - - 1 - - none - - - erp indoteknik production (localhost) - N - N - N - N - update product_pricelist_item set active = 'true' where pricelist_id = 17027; - N - - - - - - - - - - - - - - - - 1152 - 272 - Y - - -- cgit v1.2.3