summaryrefslogtreecommitdiff
path: root/import_price_group.ktr
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2023-09-19 13:48:26 +0700
committerstephanchrst <stephanchrst@gmail.com>2023-09-19 13:48:26 +0700
commit0d1fc6cac475ae40d3f13f74cbaed953455311e2 (patch)
treefac378e3701f8eb52494b6217b758b6737ec5536 /import_price_group.ktr
parenta6cc1baf4f0786e76acb18bc9d21b60f73c49928 (diff)
change import price group
Diffstat (limited to 'import_price_group.ktr')
-rw-r--r--import_price_group.ktr17
1 files changed, 16 insertions, 1 deletions
diff --git a/import_price_group.ktr b/import_price_group.ktr
index ab567ae..ff969ce 100644
--- a/import_price_group.ktr
+++ b/import_price_group.ktr
@@ -607,6 +607,21 @@
<rename>group5</rename>
<update>Y</update>
</value>
+ <value>
+ <name>group6</name>
+ <rename>group6</rename>
+ <update>Y</update>
+ </value>
+ <value>
+ <name>group7</name>
+ <rename>group7</rename>
+ <update>Y</update>
+ </value>
+ <value>
+ <name>group8</name>
+ <rename>group8</rename>
+ <update>Y</update>
+ </value>
</lookup>
<attributes/>
<cluster_schema/>
@@ -634,7 +649,7 @@
<schema_name/>
</partitioning>
<connection>erp indoteknik production (localhost)</connection>
- <sql>select id, name, pricelist_id, group1, group2, group3, group4, group5 from price_group pg</sql>
+ <sql>select id, name, pricelist_id, group1, group2, group3, group4, group5, group6, group7, group8 from price_group pg</sql>
<limit>0</limit>
<lookup/>
<execute_each_row>N</execute_each_row>