From 76b9336048c4b5dc913e86c82f97cde07bbf04e8 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Fri, 20 Oct 2023 10:47:35 +0700
Subject: typo

---
 import_stock_location.ktr | 316 +++++++++++++++++++++++++++++++++++++++-------
 1 file changed, 270 insertions(+), 46 deletions(-)

(limited to 'import_stock_location.ktr')

diff --git a/import_stock_location.ktr b/import_stock_location.ktr
index 7e01b64..0136248 100644
--- a/import_stock_location.ktr
+++ b/import_stock_location.ktr
@@ -556,7 +556,7 @@
       <schema_name/>
     </partitioning>
     <connection>erp indoteknik production (localhost)</connection>
-    <sql>select * from stock_quant where write_date >= (now() - '5 days'::interval)</sql>
+    <sql>select * from stock_location --where write_date >= (now() - '5 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
@@ -588,14 +588,83 @@
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
       <value-meta>
-        <type>Integer</type>
+        <type>String</type>
         <storagetype>normal</storagetype>
-        <name>product_id</name>
-        <length>9</length>
-        <precision>0</precision>
+        <name>name</name>
+        <length>2147483647</length>
+        <precision>-1</precision>
         <origin>Table input</origin>
-        <comments>product_id</comments>
-        <conversion_Mask>####0;-####0</conversion_Mask>
+        <comments>name</comments>
+        <conversion_Mask/>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol>,</grouping_symbol>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>String</type>
+        <storagetype>normal</storagetype>
+        <name>complete_name</name>
+        <length>2147483647</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>complete_name</comments>
+        <conversion_Mask/>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol>,</grouping_symbol>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>Boolean</type>
+        <storagetype>normal</storagetype>
+        <name>active</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>active</comments>
+        <conversion_Mask/>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol>,</grouping_symbol>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>String</type>
+        <storagetype>normal</storagetype>
+        <name>usage</name>
+        <length>2147483647</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>usage</comments>
+        <conversion_Mask/>
         <decimal_symbol>.</decimal_symbol>
         <grouping_symbol>,</grouping_symbol>
         <currency_symbol/>
@@ -613,11 +682,11 @@
       <value-meta>
         <type>Integer</type>
         <storagetype>normal</storagetype>
-        <name>company_id</name>
+        <name>location_id</name>
         <length>9</length>
         <precision>0</precision>
         <origin>Table input</origin>
-        <comments>company_id</comments>
+        <comments>location_id</comments>
         <conversion_Mask>####0;-####0</conversion_Mask>
         <decimal_symbol>.</decimal_symbol>
         <grouping_symbol>,</grouping_symbol>
@@ -633,14 +702,37 @@
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
+      <value-meta>
+        <type>String</type>
+        <storagetype>normal</storagetype>
+        <name>comment</name>
+        <length>2147483647</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>comment</comments>
+        <conversion_Mask/>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol>,</grouping_symbol>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
       <value-meta>
         <type>Integer</type>
         <storagetype>normal</storagetype>
-        <name>location_id</name>
+        <name>posx</name>
         <length>9</length>
         <precision>0</precision>
         <origin>Table input</origin>
-        <comments>location_id</comments>
+        <comments>posx</comments>
         <conversion_Mask>####0;-####0</conversion_Mask>
         <decimal_symbol>.</decimal_symbol>
         <grouping_symbol>,</grouping_symbol>
@@ -659,11 +751,11 @@
       <value-meta>
         <type>Integer</type>
         <storagetype>normal</storagetype>
-        <name>lot_id</name>
+        <name>posy</name>
         <length>9</length>
         <precision>0</precision>
         <origin>Table input</origin>
-        <comments>lot_id</comments>
+        <comments>posy</comments>
         <conversion_Mask>####0;-####0</conversion_Mask>
         <decimal_symbol>.</decimal_symbol>
         <grouping_symbol>,</grouping_symbol>
@@ -682,11 +774,11 @@
       <value-meta>
         <type>Integer</type>
         <storagetype>normal</storagetype>
-        <name>package_id</name>
+        <name>posz</name>
         <length>9</length>
         <precision>0</precision>
         <origin>Table input</origin>
-        <comments>package_id</comments>
+        <comments>posz</comments>
         <conversion_Mask>####0;-####0</conversion_Mask>
         <decimal_symbol>.</decimal_symbol>
         <grouping_symbol>,</grouping_symbol>
@@ -702,14 +794,37 @@
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
+      <value-meta>
+        <type>String</type>
+        <storagetype>normal</storagetype>
+        <name>parent_path</name>
+        <length>2147483647</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>parent_path</comments>
+        <conversion_Mask/>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol>,</grouping_symbol>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
       <value-meta>
         <type>Integer</type>
         <storagetype>normal</storagetype>
-        <name>owner_id</name>
+        <name>company_id</name>
         <length>9</length>
         <precision>0</precision>
         <origin>Table input</origin>
-        <comments>owner_id</comments>
+        <comments>company_id</comments>
         <conversion_Mask>####0;-####0</conversion_Mask>
         <decimal_symbol>.</decimal_symbol>
         <grouping_symbol>,</grouping_symbol>
@@ -726,14 +841,14 @@
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
       <value-meta>
-        <type>Number</type>
+        <type>Boolean</type>
         <storagetype>normal</storagetype>
-        <name>quantity</name>
+        <name>scrap_location</name>
         <length>-1</length>
         <precision>-1</precision>
         <origin>Table input</origin>
-        <comments>quantity</comments>
-        <conversion_Mask>####0.0#########;-####0.0#########</conversion_Mask>
+        <comments>scrap_location</comments>
+        <conversion_Mask/>
         <decimal_symbol>.</decimal_symbol>
         <grouping_symbol>,</grouping_symbol>
         <currency_symbol/>
@@ -749,14 +864,14 @@
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
       <value-meta>
-        <type>Number</type>
+        <type>Boolean</type>
         <storagetype>normal</storagetype>
-        <name>reserved_quantity</name>
+        <name>return_location</name>
         <length>-1</length>
         <precision>-1</precision>
         <origin>Table input</origin>
-        <comments>reserved_quantity</comments>
-        <conversion_Mask>####0.0#########;-####0.0#########</conversion_Mask>
+        <comments>return_location</comments>
+        <conversion_Mask/>
         <decimal_symbol>.</decimal_symbol>
         <grouping_symbol>,</grouping_symbol>
         <currency_symbol/>
@@ -772,13 +887,36 @@
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
       <value-meta>
-        <type>Timestamp</type>
+        <type>Integer</type>
         <storagetype>normal</storagetype>
-        <name>in_date</name>
-        <length>6</length>
+        <name>removal_strategy_id</name>
+        <length>9</length>
+        <precision>0</precision>
+        <origin>Table input</origin>
+        <comments>removal_strategy_id</comments>
+        <conversion_Mask>####0;-####0</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol>,</grouping_symbol>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>String</type>
+        <storagetype>normal</storagetype>
+        <name>barcode</name>
+        <length>2147483647</length>
         <precision>-1</precision>
         <origin>Table input</origin>
-        <comments>in_date</comments>
+        <comments>barcode</comments>
         <conversion_Mask/>
         <decimal_symbol>.</decimal_symbol>
         <grouping_symbol>,</grouping_symbol>
@@ -886,6 +1024,52 @@
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
+      <value-meta>
+        <type>Integer</type>
+        <storagetype>normal</storagetype>
+        <name>valuation_in_account_id</name>
+        <length>9</length>
+        <precision>0</precision>
+        <origin>Table input</origin>
+        <comments>valuation_in_account_id</comments>
+        <conversion_Mask>####0;-####0</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol>,</grouping_symbol>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>Integer</type>
+        <storagetype>normal</storagetype>
+        <name>valuation_out_account_id</name>
+        <length>9</length>
+        <precision>0</precision>
+        <origin>Table input</origin>
+        <comments>valuation_out_account_id</comments>
+        <conversion_Mask>####0;-####0</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol>,</grouping_symbol>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
     </row-meta>
     <attributes/>
     <cluster_schema/>
@@ -896,7 +1080,7 @@
       </output>
     </remotesteps>
     <GUI>
-      <xloc>144</xloc>
+      <xloc>128</xloc>
       <yloc>48</yloc>
       <draw>Y</draw>
     </GUI>
@@ -930,13 +1114,23 @@
         <update>N</update>
       </value>
       <value>
-        <name>product_id</name>
-        <rename>product_id</rename>
+        <name>name</name>
+        <rename>name</rename>
         <update>Y</update>
       </value>
       <value>
-        <name>company_id</name>
-        <rename>company_id</rename>
+        <name>complete_name</name>
+        <rename>complete_name</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>active</name>
+        <rename>active</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>usage</name>
+        <rename>usage</rename>
         <update>Y</update>
       </value>
       <value>
@@ -945,33 +1139,53 @@
         <update>Y</update>
       </value>
       <value>
-        <name>lot_id</name>
-        <rename>lot_id</rename>
+        <name>comment</name>
+        <rename>comment</rename>
         <update>Y</update>
       </value>
       <value>
-        <name>package_id</name>
-        <rename>package_id</rename>
+        <name>posx</name>
+        <rename>posx</rename>
         <update>Y</update>
       </value>
       <value>
-        <name>owner_id</name>
-        <rename>owner_id</rename>
+        <name>posy</name>
+        <rename>posy</rename>
         <update>Y</update>
       </value>
       <value>
-        <name>quantity</name>
-        <rename>quantity</rename>
+        <name>posz</name>
+        <rename>posz</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>parent_path</name>
+        <rename>parent_path</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>company_id</name>
+        <rename>company_id</rename>
         <update>Y</update>
       </value>
       <value>
-        <name>reserved_quantity</name>
-        <rename>reserved_quantity</rename>
+        <name>scrap_location</name>
+        <rename>scrap_location</rename>
         <update>Y</update>
       </value>
       <value>
-        <name>in_date</name>
-        <rename>in_date</rename>
+        <name>return_location</name>
+        <rename>return_location</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>removal_strategy_id</name>
+        <rename>removal_strategy_id</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>barcode</name>
+        <rename>barcode</rename>
         <update>Y</update>
       </value>
       <value>
@@ -994,6 +1208,16 @@
         <rename>write_date</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>valuation_in_account_id</name>
+        <rename>valuation_in_account_id</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>valuation_out_account_id</name>
+        <rename>valuation_out_account_id</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
-- 
cgit v1.2.3