From 3cb5193b5e9fdbb38d387b99d88e51847aef34f7 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Thu, 16 Nov 2023 11:58:43 +0700
Subject: add import parent id in partner

---
 import_partner.ktr    | 7 ++++++-
 import_sale_order.ktr | 5 +++++
 2 files changed, 11 insertions(+), 1 deletion(-)

diff --git a/import_partner.ktr b/import_partner.ktr
index 1ecc7ea..3dfa132 100644
--- a/import_partner.ktr
+++ b/import_partner.ktr
@@ -622,6 +622,11 @@
         <rename>is_potential</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>parent_id</name>
+        <rename>parent_id</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
@@ -649,7 +654,7 @@
       <schema_name/>
     </partitioning>
     <connection>erp indoteknik production (localhost)</connection>
-    <sql>select id, name, display_name, active, email, industry_id, state_id, kota_id, kecamatan_id, kelurahan_id, is_potential
+    <sql>select id, name, display_name, active, email, industry_id, state_id, kota_id, kecamatan_id, kelurahan_id, is_potential, parent_id
 from res_partner where write_date >= (now() - '5 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
diff --git a/import_sale_order.ktr b/import_sale_order.ktr
index 3817cc5..2e9189f 100644
--- a/import_sale_order.ktr
+++ b/import_sale_order.ktr
@@ -687,6 +687,11 @@
         <rename>source_so</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>vendor</name>
+        <rename>vendor</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
-- 
cgit v1.2.3