From f4542c9dde09eb9bfb7a532a244b1913dc1f18fd Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Fri, 29 Sep 2023 17:22:37 +0700
Subject: update solr flag

---
 insert_update_pricelist.ktr  | 232 +++++++++++++++++++++--------------------
 insert_update_pricelist1.ktr | 240 ++++++++++++++++++++++--------------------
 insert_update_pricelist2.ktr | 242 ++++++++++++++++++++++---------------------
 insert_update_pricelist3.ktr | 242 ++++++++++++++++++++++---------------------
 insert_update_pricelist4.ktr | 242 ++++++++++++++++++++++---------------------
 insert_update_pricelist5.ktr | 242 ++++++++++++++++++++++---------------------
 6 files changed, 750 insertions(+), 690 deletions(-)

diff --git a/insert_update_pricelist.ktr b/insert_update_pricelist.ktr
index e047371..330a5d0 100644
--- a/insert_update_pricelist.ktr
+++ b/insert_update_pricelist.ktr
@@ -569,6 +569,16 @@
       <to>p Insert / update base pl</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>p Insert / update base pl</from>
+      <to>base solr flag pt</to>
+      <enabled>Y</enabled>
+    </hop>
+    <hop>
+      <from>base solr flag pt</from>
+      <to>base solr flag pp</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -709,7 +719,7 @@
         <currency/>
         <decimal/>
         <group/>
-        <nullif>1</nullif>
+        <nullif>2</nullif>
         <length>-1</length>
         <precision>-1</precision>
         <set_empty_string>N</set_empty_string>
@@ -777,111 +787,7 @@
     </GUI>
   </step>
   <step>
-    <name>p Insert / update base pl</name>
-    <type>InsertUpdate</type>
-    <description/>
-    <distribute>N</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <connection>erp indoteknik production (localhost)</connection>
-    <commit>100</commit>
-    <update_bypassed>N</update_bypassed>
-    <lookup>
-      <schema>public</schema>
-      <table>product_pricelist_item</table>
-      <key>
-        <name>product_id</name>
-        <field>product_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <key>
-        <name>pricelist_id_1</name>
-        <field>pricelist_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <value>
-        <name>product_id</name>
-        <rename>product_id</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>applied_on</name>
-        <rename>applied_on_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>pricelist_id</name>
-        <rename>pricelist_id_1</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>currency_id</name>
-        <rename>currency_id_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>compute_price</name>
-        <rename>compute_price_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>fixed_price</name>
-        <rename>price_before_disc</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>create_uid</name>
-        <rename>create_uid_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>create_date</name>
-        <rename>create_date_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>write_uid</name>
-        <rename>write_uid_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>write_date</name>
-        <rename>write_date_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>base</name>
-        <rename>base_const</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>active</name>
-        <rename>active_const</rename>
-        <update>Y</update>
-      </value>
-    </lookup>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>736</xloc>
-      <yloc>272</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Insert / update 2</name>
+    <name>base solr flag pt</name>
     <type>InsertUpdate</type>
     <description/>
     <distribute>Y</distribute>
@@ -918,13 +824,13 @@
       </output>
     </remotesteps>
     <GUI>
-      <xloc>864</xloc>
-      <yloc>112</yloc>
+      <xloc>912</xloc>
+      <yloc>272</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
   <step>
-    <name>Insert / update 3</name>
+    <name>base solr flag pp</name>
     <type>InsertUpdate</type>
     <description/>
     <distribute>Y</distribute>
@@ -961,8 +867,8 @@
       </output>
     </remotesteps>
     <GUI>
-      <xloc>1024</xloc>
-      <yloc>112</yloc>
+      <xloc>1056</xloc>
+      <yloc>272</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
@@ -1032,6 +938,110 @@
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>p Insert / update base pl</name>
+    <type>InsertUpdate</type>
+    <description/>
+    <distribute>N</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>erp indoteknik production (localhost)</connection>
+    <commit>100</commit>
+    <update_bypassed>N</update_bypassed>
+    <lookup>
+      <schema>public</schema>
+      <table>product_pricelist_item</table>
+      <key>
+        <name>product_id</name>
+        <field>product_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <key>
+        <name>pricelist_id_1</name>
+        <field>pricelist_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <value>
+        <name>product_id</name>
+        <rename>product_id</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>applied_on</name>
+        <rename>applied_on_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>pricelist_id</name>
+        <rename>pricelist_id_1</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>currency_id</name>
+        <rename>currency_id_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>compute_price</name>
+        <rename>compute_price_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>fixed_price</name>
+        <rename>price_before_disc</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>create_uid</name>
+        <rename>create_uid_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>create_date</name>
+        <rename>create_date_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>write_uid</name>
+        <rename>write_uid_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>write_date</name>
+        <rename>write_date_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>base</name>
+        <rename>base_const</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>active</name>
+        <rename>active_const</rename>
+        <update>Y</update>
+      </value>
+    </lookup>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>736</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step>
     <name>price compute</name>
     <type>TableInput</type>
diff --git a/insert_update_pricelist1.ktr b/insert_update_pricelist1.ktr
index fdfc5c5..d7ab991 100644
--- a/insert_update_pricelist1.ktr
+++ b/insert_update_pricelist1.ktr
@@ -569,6 +569,16 @@
       <to>p Insert / update tier1</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>p Insert / update tier1</from>
+      <to>pl1 solr flag pt</to>
+      <enabled>Y</enabled>
+    </hop>
+    <hop>
+      <from>pl1 solr flag pt</from>
+      <to>pl1 solr flag pp</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -709,7 +719,7 @@
         <currency/>
         <decimal/>
         <group/>
-        <nullif>1</nullif>
+        <nullif>2</nullif>
         <length>-1</length>
         <precision>-1</precision>
         <set_empty_string>N</set_empty_string>
@@ -789,116 +799,7 @@
     </GUI>
   </step>
   <step>
-    <name>p Insert / update tier1</name>
-    <type>InsertUpdate</type>
-    <description/>
-    <distribute>N</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <connection>erp indoteknik production (localhost)</connection>
-    <commit>100</commit>
-    <update_bypassed>N</update_bypassed>
-    <lookup>
-      <schema>public</schema>
-      <table>product_pricelist_item</table>
-      <key>
-        <name>product_id</name>
-        <field>product_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <key>
-        <name>pricelist_id_1</name>
-        <field>pricelist_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <value>
-        <name>product_id</name>
-        <rename>product_id</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>applied_on</name>
-        <rename>applied_on_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>pricelist_id</name>
-        <rename>pricelist_id_1</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>currency_id</name>
-        <rename>currency_id_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>active</name>
-        <rename>active_const</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>compute_price</name>
-        <rename>compute_price_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_discount</name>
-        <rename>disc_tier1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>create_uid</name>
-        <rename>create_uid_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>create_date</name>
-        <rename>create_date_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>write_uid</name>
-        <rename>write_uid_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>write_date</name>
-        <rename>write_date_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>base</name>
-        <rename>base_const</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>base_pricelist_id</name>
-        <rename>base_pricelist_const</rename>
-        <update>Y</update>
-      </value>
-    </lookup>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>736</xloc>
-      <yloc>272</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Insert / update 2</name>
+    <name>pl1 solr flag pt</name>
     <type>InsertUpdate</type>
     <description/>
     <distribute>Y</distribute>
@@ -936,12 +837,12 @@
     </remotesteps>
     <GUI>
       <xloc>928</xloc>
-      <yloc>112</yloc>
+      <yloc>272</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
   <step>
-    <name>Insert / update 3</name>
+    <name>pl1 solr flag pp</name>
     <type>InsertUpdate</type>
     <description/>
     <distribute>Y</distribute>
@@ -978,8 +879,8 @@
       </output>
     </remotesteps>
     <GUI>
-      <xloc>1088</xloc>
-      <yloc>112</yloc>
+      <xloc>1120</xloc>
+      <yloc>272</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
@@ -1049,6 +950,115 @@
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>p Insert / update tier1</name>
+    <type>InsertUpdate</type>
+    <description/>
+    <distribute>N</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>erp indoteknik production (localhost)</connection>
+    <commit>100</commit>
+    <update_bypassed>N</update_bypassed>
+    <lookup>
+      <schema>public</schema>
+      <table>product_pricelist_item</table>
+      <key>
+        <name>product_id</name>
+        <field>product_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <key>
+        <name>pricelist_id_1</name>
+        <field>pricelist_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <value>
+        <name>product_id</name>
+        <rename>product_id</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>applied_on</name>
+        <rename>applied_on_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>pricelist_id</name>
+        <rename>pricelist_id_1</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>currency_id</name>
+        <rename>currency_id_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>active</name>
+        <rename>active_const</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>compute_price</name>
+        <rename>compute_price_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_discount</name>
+        <rename>disc_tier1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>create_uid</name>
+        <rename>create_uid_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>create_date</name>
+        <rename>create_date_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>write_uid</name>
+        <rename>write_uid_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>write_date</name>
+        <rename>write_date_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>base</name>
+        <rename>base_const</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>base_pricelist_id</name>
+        <rename>base_pricelist_const</rename>
+        <update>Y</update>
+      </value>
+    </lookup>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>736</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step>
     <name>price compute</name>
     <type>TableInput</type>
diff --git a/insert_update_pricelist2.ktr b/insert_update_pricelist2.ktr
index d8b0184..10bf73c 100644
--- a/insert_update_pricelist2.ktr
+++ b/insert_update_pricelist2.ktr
@@ -569,6 +569,16 @@
       <to>p Insert / update tier2</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>p Insert / update tier2</from>
+      <to>pl2 solr flag pt</to>
+      <enabled>Y</enabled>
+    </hop>
+    <hop>
+      <from>pl2 solr flag pt</from>
+      <to>pl2 solr flag pp</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -709,7 +719,7 @@
         <currency/>
         <decimal/>
         <group/>
-        <nullif>1</nullif>
+        <nullif>2</nullif>
         <length>-1</length>
         <precision>-1</precision>
         <set_empty_string>N</set_empty_string>
@@ -789,116 +799,7 @@
     </GUI>
   </step>
   <step>
-    <name>p Insert / update tier2</name>
-    <type>InsertUpdate</type>
-    <description/>
-    <distribute>N</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <connection>erp indoteknik production (localhost)</connection>
-    <commit>100</commit>
-    <update_bypassed>N</update_bypassed>
-    <lookup>
-      <schema>public</schema>
-      <table>product_pricelist_item</table>
-      <key>
-        <name>product_id</name>
-        <field>product_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <key>
-        <name>pricelist_id_1</name>
-        <field>pricelist_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <value>
-        <name>product_id</name>
-        <rename>product_id</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>applied_on</name>
-        <rename>applied_on_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>pricelist_id</name>
-        <rename>pricelist_id_1</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>currency_id</name>
-        <rename>currency_id_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>active</name>
-        <rename>active_const</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>compute_price</name>
-        <rename>compute_price_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_discount</name>
-        <rename>disc_tier2</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>create_uid</name>
-        <rename>create_uid_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>create_date</name>
-        <rename>create_date_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>write_uid</name>
-        <rename>write_uid_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>write_date</name>
-        <rename>write_date_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>base</name>
-        <rename>base_const</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>base_pricelist_id</name>
-        <rename>base_pricelist_const</rename>
-        <update>Y</update>
-      </value>
-    </lookup>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>736</xloc>
-      <yloc>272</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Insert / update 2</name>
+    <name>pl2 solr flag pt</name>
     <type>InsertUpdate</type>
     <description/>
     <distribute>Y</distribute>
@@ -935,13 +836,13 @@
       </output>
     </remotesteps>
     <GUI>
-      <xloc>960</xloc>
-      <yloc>160</yloc>
+      <xloc>912</xloc>
+      <yloc>272</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
   <step>
-    <name>Insert / update 3</name>
+    <name>pl2 solr flag pp</name>
     <type>InsertUpdate</type>
     <description/>
     <distribute>Y</distribute>
@@ -978,8 +879,8 @@
       </output>
     </remotesteps>
     <GUI>
-      <xloc>1120</xloc>
-      <yloc>160</yloc>
+      <xloc>1088</xloc>
+      <yloc>272</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
@@ -1049,6 +950,115 @@
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>p Insert / update tier2</name>
+    <type>InsertUpdate</type>
+    <description/>
+    <distribute>N</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>erp indoteknik production (localhost)</connection>
+    <commit>100</commit>
+    <update_bypassed>N</update_bypassed>
+    <lookup>
+      <schema>public</schema>
+      <table>product_pricelist_item</table>
+      <key>
+        <name>product_id</name>
+        <field>product_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <key>
+        <name>pricelist_id_1</name>
+        <field>pricelist_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <value>
+        <name>product_id</name>
+        <rename>product_id</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>applied_on</name>
+        <rename>applied_on_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>pricelist_id</name>
+        <rename>pricelist_id_1</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>currency_id</name>
+        <rename>currency_id_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>active</name>
+        <rename>active_const</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>compute_price</name>
+        <rename>compute_price_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_discount</name>
+        <rename>disc_tier2</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>create_uid</name>
+        <rename>create_uid_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>create_date</name>
+        <rename>create_date_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>write_uid</name>
+        <rename>write_uid_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>write_date</name>
+        <rename>write_date_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>base</name>
+        <rename>base_const</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>base_pricelist_id</name>
+        <rename>base_pricelist_const</rename>
+        <update>Y</update>
+      </value>
+    </lookup>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>736</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step>
     <name>price compute</name>
     <type>TableInput</type>
diff --git a/insert_update_pricelist3.ktr b/insert_update_pricelist3.ktr
index c35866d..ec3e954 100644
--- a/insert_update_pricelist3.ktr
+++ b/insert_update_pricelist3.ktr
@@ -569,6 +569,16 @@
       <to>p Insert / update tier3</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>p Insert / update tier3</from>
+      <to>pl3 solr flag pt</to>
+      <enabled>Y</enabled>
+    </hop>
+    <hop>
+      <from>pl3 solr flag pt</from>
+      <to>pl3 solr flag pp</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -709,7 +719,7 @@
         <currency/>
         <decimal/>
         <group/>
-        <nullif>1</nullif>
+        <nullif>2</nullif>
         <length>-1</length>
         <precision>-1</precision>
         <set_empty_string>N</set_empty_string>
@@ -789,116 +799,7 @@
     </GUI>
   </step>
   <step>
-    <name>p Insert / update tier3</name>
-    <type>InsertUpdate</type>
-    <description/>
-    <distribute>N</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <connection>erp indoteknik production (localhost)</connection>
-    <commit>100</commit>
-    <update_bypassed>N</update_bypassed>
-    <lookup>
-      <schema>public</schema>
-      <table>product_pricelist_item</table>
-      <key>
-        <name>product_id</name>
-        <field>product_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <key>
-        <name>pricelist_id_1</name>
-        <field>pricelist_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <value>
-        <name>product_id</name>
-        <rename>product_id</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>applied_on</name>
-        <rename>applied_on_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>pricelist_id</name>
-        <rename>pricelist_id_1</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>currency_id</name>
-        <rename>currency_id_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>active</name>
-        <rename>active_const</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>compute_price</name>
-        <rename>compute_price_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_discount</name>
-        <rename>disc_tier3</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>create_uid</name>
-        <rename>create_uid_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>create_date</name>
-        <rename>create_date_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>write_uid</name>
-        <rename>write_uid_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>write_date</name>
-        <rename>write_date_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>base</name>
-        <rename>base_const</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>base_pricelist_id</name>
-        <rename>base_pricelist_const</rename>
-        <update>Y</update>
-      </value>
-    </lookup>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>736</xloc>
-      <yloc>272</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Insert / update 2</name>
+    <name>pl3 solr flag pt</name>
     <type>InsertUpdate</type>
     <description/>
     <distribute>Y</distribute>
@@ -935,13 +836,13 @@
       </output>
     </remotesteps>
     <GUI>
-      <xloc>896</xloc>
-      <yloc>128</yloc>
+      <xloc>912</xloc>
+      <yloc>272</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
   <step>
-    <name>Insert / update 3</name>
+    <name>pl3 solr flag pp</name>
     <type>InsertUpdate</type>
     <description/>
     <distribute>Y</distribute>
@@ -978,8 +879,8 @@
       </output>
     </remotesteps>
     <GUI>
-      <xloc>1040</xloc>
-      <yloc>128</yloc>
+      <xloc>1088</xloc>
+      <yloc>272</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
@@ -1049,6 +950,115 @@
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>p Insert / update tier3</name>
+    <type>InsertUpdate</type>
+    <description/>
+    <distribute>N</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>erp indoteknik production (localhost)</connection>
+    <commit>100</commit>
+    <update_bypassed>N</update_bypassed>
+    <lookup>
+      <schema>public</schema>
+      <table>product_pricelist_item</table>
+      <key>
+        <name>product_id</name>
+        <field>product_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <key>
+        <name>pricelist_id_1</name>
+        <field>pricelist_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <value>
+        <name>product_id</name>
+        <rename>product_id</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>applied_on</name>
+        <rename>applied_on_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>pricelist_id</name>
+        <rename>pricelist_id_1</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>currency_id</name>
+        <rename>currency_id_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>active</name>
+        <rename>active_const</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>compute_price</name>
+        <rename>compute_price_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_discount</name>
+        <rename>disc_tier3</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>create_uid</name>
+        <rename>create_uid_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>create_date</name>
+        <rename>create_date_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>write_uid</name>
+        <rename>write_uid_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>write_date</name>
+        <rename>write_date_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>base</name>
+        <rename>base_const</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>base_pricelist_id</name>
+        <rename>base_pricelist_const</rename>
+        <update>Y</update>
+      </value>
+    </lookup>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>736</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step>
     <name>price compute</name>
     <type>TableInput</type>
diff --git a/insert_update_pricelist4.ktr b/insert_update_pricelist4.ktr
index 7082ca4..f8d75e6 100644
--- a/insert_update_pricelist4.ktr
+++ b/insert_update_pricelist4.ktr
@@ -569,6 +569,16 @@
       <to>p Insert / update tier4</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>p Insert / update tier4</from>
+      <to>pl4 solr flag pt</to>
+      <enabled>Y</enabled>
+    </hop>
+    <hop>
+      <from>pl4 solr flag pt</from>
+      <to>pl4 solr flag pp</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -709,7 +719,7 @@
         <currency/>
         <decimal/>
         <group/>
-        <nullif>1</nullif>
+        <nullif>2</nullif>
         <length>-1</length>
         <precision>-1</precision>
         <set_empty_string>N</set_empty_string>
@@ -789,116 +799,7 @@
     </GUI>
   </step>
   <step>
-    <name>p Insert / update tier4</name>
-    <type>InsertUpdate</type>
-    <description/>
-    <distribute>N</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <connection>erp indoteknik production (localhost)</connection>
-    <commit>100</commit>
-    <update_bypassed>N</update_bypassed>
-    <lookup>
-      <schema>public</schema>
-      <table>product_pricelist_item</table>
-      <key>
-        <name>product_id</name>
-        <field>product_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <key>
-        <name>pricelist_id_1</name>
-        <field>pricelist_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <value>
-        <name>product_id</name>
-        <rename>product_id</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>applied_on</name>
-        <rename>applied_on_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>pricelist_id</name>
-        <rename>pricelist_id_1</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>currency_id</name>
-        <rename>currency_id_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>active</name>
-        <rename>active_const</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>compute_price</name>
-        <rename>compute_price_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_discount</name>
-        <rename>disc_tier4</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>create_uid</name>
-        <rename>create_uid_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>create_date</name>
-        <rename>create_date_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>write_uid</name>
-        <rename>write_uid_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>write_date</name>
-        <rename>write_date_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>base</name>
-        <rename>base_const</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>base_pricelist_id</name>
-        <rename>base_pricelist_const</rename>
-        <update>Y</update>
-      </value>
-    </lookup>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>736</xloc>
-      <yloc>272</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Insert / update 2</name>
+    <name>pl4 solr flag pt</name>
     <type>InsertUpdate</type>
     <description/>
     <distribute>Y</distribute>
@@ -935,13 +836,13 @@
       </output>
     </remotesteps>
     <GUI>
-      <xloc>896</xloc>
-      <yloc>144</yloc>
+      <xloc>912</xloc>
+      <yloc>272</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
   <step>
-    <name>Insert / update 3</name>
+    <name>pl4 solr flag pp</name>
     <type>InsertUpdate</type>
     <description/>
     <distribute>Y</distribute>
@@ -978,8 +879,8 @@
       </output>
     </remotesteps>
     <GUI>
-      <xloc>1040</xloc>
-      <yloc>144</yloc>
+      <xloc>1088</xloc>
+      <yloc>272</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
@@ -1049,6 +950,115 @@
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>p Insert / update tier4</name>
+    <type>InsertUpdate</type>
+    <description/>
+    <distribute>N</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>erp indoteknik production (localhost)</connection>
+    <commit>100</commit>
+    <update_bypassed>N</update_bypassed>
+    <lookup>
+      <schema>public</schema>
+      <table>product_pricelist_item</table>
+      <key>
+        <name>product_id</name>
+        <field>product_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <key>
+        <name>pricelist_id_1</name>
+        <field>pricelist_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <value>
+        <name>product_id</name>
+        <rename>product_id</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>applied_on</name>
+        <rename>applied_on_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>pricelist_id</name>
+        <rename>pricelist_id_1</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>currency_id</name>
+        <rename>currency_id_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>active</name>
+        <rename>active_const</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>compute_price</name>
+        <rename>compute_price_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_discount</name>
+        <rename>disc_tier4</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>create_uid</name>
+        <rename>create_uid_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>create_date</name>
+        <rename>create_date_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>write_uid</name>
+        <rename>write_uid_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>write_date</name>
+        <rename>write_date_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>base</name>
+        <rename>base_const</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>base_pricelist_id</name>
+        <rename>base_pricelist_const</rename>
+        <update>Y</update>
+      </value>
+    </lookup>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>736</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step>
     <name>price compute</name>
     <type>TableInput</type>
diff --git a/insert_update_pricelist5.ktr b/insert_update_pricelist5.ktr
index b820ae4..d06bd59 100644
--- a/insert_update_pricelist5.ktr
+++ b/insert_update_pricelist5.ktr
@@ -569,6 +569,16 @@
       <to>p Insert / update tier5</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>p Insert / update tier5</from>
+      <to>pl5 solr flag pt</to>
+      <enabled>Y</enabled>
+    </hop>
+    <hop>
+      <from>pl5 solr flag pt</from>
+      <to>pl5 solr flag pp</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -709,7 +719,7 @@
         <currency/>
         <decimal/>
         <group/>
-        <nullif>1</nullif>
+        <nullif>2</nullif>
         <length>-1</length>
         <precision>-1</precision>
         <set_empty_string>N</set_empty_string>
@@ -789,116 +799,7 @@
     </GUI>
   </step>
   <step>
-    <name>p Insert / update tier5</name>
-    <type>InsertUpdate</type>
-    <description/>
-    <distribute>N</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <connection>erp indoteknik production (localhost)</connection>
-    <commit>100</commit>
-    <update_bypassed>N</update_bypassed>
-    <lookup>
-      <schema>public</schema>
-      <table>product_pricelist_item</table>
-      <key>
-        <name>product_id</name>
-        <field>product_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <key>
-        <name>pricelist_id_1</name>
-        <field>pricelist_id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <value>
-        <name>product_id</name>
-        <rename>product_id</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>applied_on</name>
-        <rename>applied_on_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>pricelist_id</name>
-        <rename>pricelist_id_1</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>currency_id</name>
-        <rename>currency_id_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>active</name>
-        <rename>active_const</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>compute_price</name>
-        <rename>compute_price_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_discount</name>
-        <rename>disc_tier5</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>create_uid</name>
-        <rename>create_uid_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>create_date</name>
-        <rename>create_date_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>write_uid</name>
-        <rename>write_uid_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>write_date</name>
-        <rename>write_date_1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>base</name>
-        <rename>base_const</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>base_pricelist_id</name>
-        <rename>base_pricelist_const</rename>
-        <update>Y</update>
-      </value>
-    </lookup>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>736</xloc>
-      <yloc>272</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Insert / update 2</name>
+    <name>pl5 solr flag pt</name>
     <type>InsertUpdate</type>
     <description/>
     <distribute>Y</distribute>
@@ -935,13 +836,13 @@
       </output>
     </remotesteps>
     <GUI>
-      <xloc>896</xloc>
-      <yloc>128</yloc>
+      <xloc>912</xloc>
+      <yloc>272</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
   <step>
-    <name>Insert / update 3</name>
+    <name>pl5 solr flag pp</name>
     <type>InsertUpdate</type>
     <description/>
     <distribute>Y</distribute>
@@ -978,8 +879,8 @@
       </output>
     </remotesteps>
     <GUI>
-      <xloc>1040</xloc>
-      <yloc>128</yloc>
+      <xloc>1088</xloc>
+      <yloc>272</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
@@ -1049,6 +950,115 @@
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>p Insert / update tier5</name>
+    <type>InsertUpdate</type>
+    <description/>
+    <distribute>N</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>erp indoteknik production (localhost)</connection>
+    <commit>100</commit>
+    <update_bypassed>N</update_bypassed>
+    <lookup>
+      <schema>public</schema>
+      <table>product_pricelist_item</table>
+      <key>
+        <name>product_id</name>
+        <field>product_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <key>
+        <name>pricelist_id_1</name>
+        <field>pricelist_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <value>
+        <name>product_id</name>
+        <rename>product_id</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>applied_on</name>
+        <rename>applied_on_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>pricelist_id</name>
+        <rename>pricelist_id_1</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>currency_id</name>
+        <rename>currency_id_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>active</name>
+        <rename>active_const</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>compute_price</name>
+        <rename>compute_price_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_discount</name>
+        <rename>disc_tier5</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>create_uid</name>
+        <rename>create_uid_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>create_date</name>
+        <rename>create_date_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>write_uid</name>
+        <rename>write_uid_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>write_date</name>
+        <rename>write_date_1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>base</name>
+        <rename>base_const</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>base_pricelist_id</name>
+        <rename>base_pricelist_const</rename>
+        <update>Y</update>
+      </value>
+    </lookup>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>736</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step>
     <name>price compute</name>
     <type>TableInput</type>
-- 
cgit v1.2.3