From f55c13bfc7eb34f5e4a713d6d3d8331366b129f9 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Tue, 31 Oct 2023 13:09:47 +0700
Subject: add order line while import soo altama

---
 import_order_detail_altama.ktr | 52 ++++++++++++++++++++++++++++++++++--------
 1 file changed, 42 insertions(+), 10 deletions(-)

(limited to 'import_order_detail_altama.ktr')

diff --git a/import_order_detail_altama.ktr b/import_order_detail_altama.ktr
index ee2d2f3..273c45a 100644
--- a/import_order_detail_altama.ktr
+++ b/import_order_detail_altama.ktr
@@ -700,6 +700,18 @@
         <decimal/>
         <group/>
       </field>
+      <field>
+        <name>Order Line</name>
+        <type>String</type>
+        <length>-1</length>
+        <precision>-1</precision>
+        <trim_type>none</trim_type>
+        <repeat>N</repeat>
+        <format/>
+        <currency/>
+        <decimal/>
+        <group/>
+      </field>
     </fields>
     <sheets>
       <sheet>
@@ -809,7 +821,28 @@
         <name>Serial No</name>
         <rename>serial</rename>
       </field>
+      <field>
+        <name>Order Line</name>
+        <rename>c_orderline_id</rename>
+      </field>
       <select_unspecified>N</select_unspecified>
+      <meta>
+        <name>c_orderline_id</name>
+        <rename>c_orderline_id</rename>
+        <type>Integer</type>
+        <length>-2</length>
+        <precision>-2</precision>
+        <conversion_mask/>
+        <date_format_lenient>false</date_format_lenient>
+        <date_format_locale/>
+        <date_format_timezone/>
+        <lenient_string_to_number>false</lenient_string_to_number>
+        <encoding/>
+        <decimal_symbol/>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <storage_type/>
+      </meta>
     </fields>
     <attributes/>
     <cluster_schema/>
@@ -843,14 +876,8 @@
       <schema>public</schema>
       <table>soo_altama</table>
       <key>
-        <name>ref</name>
-        <field>ref</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <key>
-        <name>product</name>
-        <field>product</field>
+        <name>c_orderline_id</name>
+        <field>c_orderline_id</field>
         <condition>=</condition>
         <name2/>
       </key>
@@ -862,7 +889,7 @@
       <value>
         <name>ref</name>
         <rename>ref</rename>
-        <update>N</update>
+        <update>Y</update>
       </value>
       <value>
         <name>date_ordered</name>
@@ -882,7 +909,7 @@
       <value>
         <name>product</name>
         <rename>product</rename>
-        <update>N</update>
+        <update>Y</update>
       </value>
       <value>
         <name>price</name>
@@ -924,6 +951,11 @@
         <rename>serial</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>c_orderline_id</name>
+        <rename>c_orderline_id</rename>
+        <update>N</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
-- 
cgit v1.2.3