changes database calculate margin inv v3

1 files changed, 670 insertions, 738 deletions

diff --git a/calculate_margin_invoice_v3.ktr b/calculate_margin_invoice_v3.ktr
index fa17fbb..a11ee0d 100644
--- a/calculate_margin_invoice_v3.ktr
+++ b/calculate_margin_invoice_v3.ktr
@@ -430,7 +430,7 @@
     <created_date>2025/08/13 09:47:28.228</created_date>
     <modified_user>-</modified_user>
     <modified_date>2025/08/13 09:47:28.228</modified_date>
-    <key_for_session_key/>
+    <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>
     <is_key_private>N</is_key_private>
   </info>
   <notepads>
@@ -579,6 +579,601 @@
     </hop>
   </order>
   <step>
+    <name>Add constants</name>
+    <type>Constant</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <fields>
+      <field>
+        <name>one_hundred</name>
+        <type>BigNumber</type>
+        <format/>
+        <currency/>
+        <decimal/>
+        <group/>
+        <nullif>100</nullif>
+        <length>-1</length>
+        <precision>-1</precision>
+        <set_empty_string>N</set_empty_string>
+      </field>
+    </fields>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>960</xloc>
+      <yloc>400</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>Calculator</name>
+    <type>Calculator</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <failIfNoFile>Y</failIfNoFile>
+    <calculation>
+      <field_name>margin</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>penjualan</field_a>
+      <field_b>hpp</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>div_margin</field_name>
+      <calc_type>DIVIDE</calc_type>
+      <field_a>margin</field_a>
+      <field_b>penjualan</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>percent_margin</field_name>
+      <calc_type>MULTIPLY</calc_type>
+      <field_a>div_margin</field_a>
+      <field_b>one_hundred</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>1104</xloc>
+      <yloc>400</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>Filter rows</name>
+    <type>FilterRows</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <send_true_to>select all</send_true_to>
+    <send_false_to>Write to log</send_false_to>
+    <compare>
+      <condition>
+        <negated>N</negated>
+        <conditions>
+          <condition>
+            <negated>N</negated>
+            <leftvalue>penjualan</leftvalue>
+            <function>&gt;</function>
+            <rightvalue/>
+            <value>
+              <name>constant</name>
+              <type>BigNumber</type>
+              <text>0.0</text>
+              <length>-1</length>
+              <precision>-1</precision>
+              <isnull>N</isnull>
+              <mask>######0.0###################;-######0.0###################</mask>
+            </value>
+          </condition>
+          <condition>
+            <negated>N</negated>
+            <operator>AND</operator>
+            <leftvalue>hpp</leftvalue>
+            <function>&gt;</function>
+            <rightvalue/>
+            <value>
+              <name>constant</name>
+              <type>BigNumber</type>
+              <text>0.0</text>
+              <length>-1</length>
+              <precision>-1</precision>
+              <isnull>N</isnull>
+              <mask>######0.0###################;-######0.0###################</mask>
+            </value>
+          </condition>
+        </conditions>
+      </condition>
+    </compare>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>416</xloc>
+      <yloc>288</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>Insert / update</name>
+    <type>InsertUpdate</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>dw bi indoteknik (localhost)</connection>
+    <commit>100</commit>
+    <update_bypassed>N</update_bypassed>
+    <lookup>
+      <schema>public</schema>
+      <table>margin_invoice_v3</table>
+      <key>
+        <name>id</name>
+        <field>id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <value>
+        <name>id</name>
+        <rename>id</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>move_id</name>
+        <rename>move_id</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>date</name>
+        <rename>date</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>invoice_origin</name>
+        <rename>invoice_origin</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>invoice</name>
+        <rename>invoice</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>customer</name>
+        <rename>customer</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>lob</name>
+        <rename>lob</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>brand</name>
+        <rename>brand</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>product_id</name>
+        <rename>product_id</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>item_code</name>
+        <rename>item_code</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>product</name>
+        <rename>product</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>salesperson</name>
+        <rename>salesperson</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>quantity</name>
+        <rename>quantity</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_unit</name>
+        <rename>price_unit</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_subtotal</name>
+        <rename>price_subtotal</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_total</name>
+        <rename>price_total</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>penjualan</name>
+        <rename>penjualan</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>hpp</name>
+        <rename>hpp</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>sale_order</name>
+        <rename>sale_order</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>sale_product_id</name>
+        <rename>sale_product_id</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>vendor_id</name>
+        <rename>vendor_id</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>vendor</name>
+        <rename>vendor</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>margin</name>
+        <rename>margin</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>div_margin</name>
+        <rename>div_margin</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>percent_margin</name>
+        <rename>percent_margin</rename>
+        <update>Y</update>
+      </value>
+    </lookup>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>1104</xloc>
+      <yloc>80</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>Merge join</name>
+    <type>MergeJoin</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <join_type>LEFT OUTER</join_type>
+    <step1>penjualan</step1>
+    <step2>hpp</step2>
+    <keys_1>
+      <key>move_id</key>
+      <key>product_id</key>
+    </keys_1>
+    <keys_2>
+      <key>move_id</key>
+      <key>product_id</key>
+    </keys_2>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>240</xloc>
+      <yloc>288</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>Merge join 2</name>
+    <type>MergeJoin</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <join_type>LEFT OUTER</join_type>
+    <step1>Sort rows</step1>
+    <step2>Sort rows 2</step2>
+    <keys_1>
+      <key>id</key>
+    </keys_1>
+    <keys_2>
+      <key>id</key>
+    </keys_2>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>832</xloc>
+      <yloc>400</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>Select values</name>
+    <type>SelectValues</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <fields>
+      <field>
+        <name>id</name>
+      </field>
+      <field>
+        <name>move_id</name>
+      </field>
+      <field>
+        <name>date</name>
+      </field>
+      <field>
+        <name>invoice_origin</name>
+      </field>
+      <field>
+        <name>invoice</name>
+      </field>
+      <field>
+        <name>customer</name>
+      </field>
+      <field>
+        <name>lob</name>
+      </field>
+      <field>
+        <name>brand</name>
+      </field>
+      <field>
+        <name>product_id</name>
+      </field>
+      <field>
+        <name>item_code</name>
+      </field>
+      <field>
+        <name>product</name>
+      </field>
+      <field>
+        <name>salesperson</name>
+      </field>
+      <field>
+        <name>quantity</name>
+      </field>
+      <field>
+        <name>price_unit</name>
+      </field>
+      <field>
+        <name>price_subtotal</name>
+      </field>
+      <field>
+        <name>price_total</name>
+      </field>
+      <field>
+        <name>penjualan</name>
+      </field>
+      <field>
+        <name>hpp</name>
+      </field>
+      <field>
+        <name>sale_order</name>
+      </field>
+      <field>
+        <name>sale_product_id</name>
+      </field>
+      <field>
+        <name>vendor_id</name>
+      </field>
+      <field>
+        <name>vendor</name>
+      </field>
+      <field>
+        <name>margin</name>
+      </field>
+      <field>
+        <name>div_margin</name>
+      </field>
+      <field>
+        <name>percent_margin</name>
+      </field>
+      <select_unspecified>N</select_unspecified>
+    </fields>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>1104</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>Sort rows</name>
+    <type>SortRows</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <directory>%%java.io.tmpdir%%</directory>
+    <prefix>out</prefix>
+    <sort_size>1000000</sort_size>
+    <free_memory/>
+    <compress>N</compress>
+    <compress_variable/>
+    <unique_rows>N</unique_rows>
+    <fields>
+      <field>
+        <name>id</name>
+        <ascending>Y</ascending>
+        <case_sensitive>N</case_sensitive>
+        <collator_enabled>N</collator_enabled>
+        <collator_strength>0</collator_strength>
+        <presorted>N</presorted>
+      </field>
+    </fields>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>688</xloc>
+      <yloc>400</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>Sort rows 2</name>
+    <type>SortRows</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <directory>%%java.io.tmpdir%%</directory>
+    <prefix>out</prefix>
+    <sort_size>1000000</sort_size>
+    <free_memory/>
+    <compress>N</compress>
+    <compress_variable/>
+    <unique_rows>N</unique_rows>
+    <fields>
+      <field>
+        <name>id</name>
+        <ascending>Y</ascending>
+        <case_sensitive>N</case_sensitive>
+        <collator_enabled>N</collator_enabled>
+        <collator_strength>0</collator_strength>
+        <presorted>N</presorted>
+      </field>
+    </fields>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>832</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
     <name>Table input</name>
     <type>TableInput</type>
     <description/>
@@ -607,6 +1202,7 @@ left join brand b on b.id = p.brand_id
 where 1=1
 and aml.account_id = 462
 and am.state = 'posted'
+--and aml.date >= '2025-08-20'
 and aml.date >= '2024-06-01'
 --and aml.write_date >= (now() - '3 days'::interval)</sql>
     <limit>0</limit>
@@ -1023,48 +1619,6 @@ and aml.date >= '2024-06-01'
     </GUI>
   </step>
   <step>
-    <name>penjualan</name>
-    <type>SortRows</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <directory>%%java.io.tmpdir%%</directory>
-    <prefix>out</prefix>
-    <sort_size>1000000</sort_size>
-    <free_memory/>
-    <compress>N</compress>
-    <compress_variable/>
-    <unique_rows>N</unique_rows>
-    <fields>
-      <field>
-        <name>id</name>
-        <ascending>Y</ascending>
-        <case_sensitive>N</case_sensitive>
-        <collator_enabled>N</collator_enabled>
-        <collator_strength>0</collator_strength>
-        <presorted>N</presorted>
-      </field>
-    </fields>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>144</xloc>
-      <yloc>176</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
     <name>Table input 2</name>
     <type>TableInput</type>
     <description/>
@@ -1090,6 +1644,7 @@ join account_move am on am.id = aml.move_id
 where 1=1
 and aml.account_id = 466
 and am.state = 'posted'
+--and aml.date >= '2025-08-20'
 and aml.date >= '2024-06-01'
 --and aml.write_date >= (now() - '3 days'::interval)</sql>
     <limit>0</limit>
@@ -1207,333 +1762,6 @@ and aml.date >= '2024-06-01'
     </GUI>
   </step>
   <step>
-    <name>hpp</name>
-    <type>SortRows</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <directory>%%java.io.tmpdir%%</directory>
-    <prefix>out</prefix>
-    <sort_size>1000000</sort_size>
-    <free_memory/>
-    <compress>N</compress>
-    <compress_variable/>
-    <unique_rows>N</unique_rows>
-    <fields>
-      <field>
-        <name>id</name>
-        <ascending>Y</ascending>
-        <case_sensitive>N</case_sensitive>
-        <collator_enabled>N</collator_enabled>
-        <collator_strength>0</collator_strength>
-        <presorted>N</presorted>
-      </field>
-    </fields>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>320</xloc>
-      <yloc>176</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Merge join</name>
-    <type>MergeJoin</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <join_type>LEFT OUTER</join_type>
-    <step1>penjualan</step1>
-    <step2>hpp</step2>
-    <keys_1>
-      <key>move_id</key>
-      <key>product_id</key>
-    </keys_1>
-    <keys_2>
-      <key>move_id</key>
-      <key>product_id</key>
-    </keys_2>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>240</xloc>
-      <yloc>288</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Filter rows</name>
-    <type>FilterRows</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <send_true_to>select all</send_true_to>
-    <send_false_to>Write to log</send_false_to>
-    <compare>
-      <condition>
-        <negated>N</negated>
-        <conditions>
-          <condition>
-            <negated>N</negated>
-            <leftvalue>penjualan</leftvalue>
-            <function>&gt;</function>
-            <rightvalue/>
-            <value>
-              <name>constant</name>
-              <type>BigNumber</type>
-              <text>0.0</text>
-              <length>-1</length>
-              <precision>-1</precision>
-              <isnull>N</isnull>
-              <mask>######0.0###################;-######0.0###################</mask>
-            </value>
-          </condition>
-          <condition>
-            <negated>N</negated>
-            <operator>AND</operator>
-            <leftvalue>hpp</leftvalue>
-            <function>&gt;</function>
-            <rightvalue/>
-            <value>
-              <name>constant</name>
-              <type>BigNumber</type>
-              <text>0.0</text>
-              <length>-1</length>
-              <precision>-1</precision>
-              <isnull>N</isnull>
-              <mask>######0.0###################;-######0.0###################</mask>
-            </value>
-          </condition>
-        </conditions>
-      </condition>
-    </compare>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>416</xloc>
-      <yloc>288</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Write to log</name>
-    <type>WriteToLog</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <loglevel>log_level_basic</loglevel>
-    <displayHeader>Y</displayHeader>
-    <limitRows>N</limitRows>
-    <limitRowsNumber>0</limitRowsNumber>
-    <logmessage/>
-    <fields>
-      </fields>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>416</xloc>
-      <yloc>400</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>select all</name>
-    <type>SelectValues</type>
-    <description/>
-    <distribute>N</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <fields>
-      <field>
-        <name>id</name>
-        <rename/>
-      </field>
-      <field>
-        <name>move_id</name>
-        <rename/>
-      </field>
-      <field>
-        <name>date</name>
-        <rename/>
-      </field>
-      <field>
-        <name>invoice_origin</name>
-        <rename/>
-      </field>
-      <field>
-        <name>invoice</name>
-        <rename/>
-      </field>
-      <field>
-        <name>customer</name>
-        <rename/>
-      </field>
-      <field>
-        <name>lob</name>
-        <rename/>
-      </field>
-      <field>
-        <name>brand</name>
-        <rename/>
-      </field>
-      <field>
-        <name>product_id</name>
-        <rename/>
-      </field>
-      <field>
-        <name>item_code</name>
-        <rename/>
-      </field>
-      <field>
-        <name>product</name>
-        <rename/>
-      </field>
-      <field>
-        <name>salesperson</name>
-        <rename/>
-      </field>
-      <field>
-        <name>quantity</name>
-        <rename/>
-      </field>
-      <field>
-        <name>price_unit</name>
-        <rename/>
-      </field>
-      <field>
-        <name>price_subtotal</name>
-        <rename/>
-      </field>
-      <field>
-        <name>price_total</name>
-        <rename/>
-      </field>
-      <field>
-        <name>penjualan</name>
-        <rename/>
-      </field>
-      <field>
-        <name>id_1</name>
-        <rename/>
-      </field>
-      <field>
-        <name>move_id_1</name>
-        <rename/>
-      </field>
-      <field>
-        <name>product_id_1</name>
-        <rename/>
-      </field>
-      <field>
-        <name>hpp</name>
-        <rename/>
-      </field>
-      <select_unspecified>N</select_unspecified>
-    </fields>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>560</xloc>
-      <yloc>288</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>param only</name>
-    <type>SelectValues</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <fields>
-      <field>
-        <name>id</name>
-        <rename/>
-      </field>
-      <field>
-        <name>invoice_origin</name>
-        <rename/>
-      </field>
-      <field>
-        <name>product_id</name>
-        <rename/>
-      </field>
-      <select_unspecified>N</select_unspecified>
-    </fields>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>688</xloc>
-      <yloc>192</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
     <name>Table input 3</name>
     <type>TableInput</type>
     <description/>
@@ -1684,7 +1912,39 @@ and tso.name = ? and tsol.vendor_id = ?</sql>
     </remotesteps>
     <GUI>
       <xloc>832</xloc>
-      <yloc>192</yloc>
+      <yloc>80</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>Write to log</name>
+    <type>WriteToLog</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <loglevel>log_level_basic</loglevel>
+    <displayHeader>Y</displayHeader>
+    <limitRows>N</limitRows>
+    <limitRowsNumber>0</limitRowsNumber>
+    <logmessage/>
+    <fields>
+      </fields>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>416</xloc>
+      <yloc>400</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
@@ -1702,87 +1962,66 @@ and tso.name = ? and tsol.vendor_id = ?</sql>
     <fields>
       <field>
         <name>id</name>
-        <rename/>
       </field>
       <field>
         <name>move_id</name>
-        <rename/>
       </field>
       <field>
         <name>date</name>
-        <rename/>
       </field>
       <field>
         <name>invoice_origin</name>
-        <rename/>
       </field>
       <field>
         <name>invoice</name>
-        <rename/>
       </field>
       <field>
         <name>customer</name>
-        <rename/>
       </field>
       <field>
         <name>lob</name>
-        <rename/>
       </field>
       <field>
         <name>brand</name>
-        <rename/>
       </field>
       <field>
         <name>product_id</name>
-        <rename/>
       </field>
       <field>
         <name>item_code</name>
-        <rename/>
       </field>
       <field>
         <name>product</name>
-        <rename/>
       </field>
       <field>
         <name>salesperson</name>
-        <rename/>
       </field>
       <field>
         <name>quantity</name>
-        <rename/>
       </field>
       <field>
         <name>price_unit</name>
-        <rename/>
       </field>
       <field>
         <name>price_subtotal</name>
-        <rename/>
       </field>
       <field>
         <name>price_total</name>
-        <rename/>
       </field>
       <field>
         <name>penjualan</name>
-        <rename/>
       </field>
       <field>
         <name>id_1</name>
-        <rename/>
       </field>
       <field>
         <name>move_id_1</name>
-        <rename/>
       </field>
       <field>
         <name>product_id_1</name>
-        <rename/>
       </field>
       <field>
         <name>hpp</name>
-        <rename/>
       </field>
       <select_unspecified>N</select_unspecified>
     </fields>
@@ -1801,7 +2040,7 @@ and tso.name = ? and tsol.vendor_id = ?</sql>
     </GUI>
   </step>
   <step>
-    <name>Sort rows</name>
+    <name>hpp</name>
     <type>SortRows</type>
     <description/>
     <distribute>Y</distribute>
@@ -1837,14 +2076,14 @@ and tso.name = ? and tsol.vendor_id = ?</sql>
       </output>
     </remotesteps>
     <GUI>
-      <xloc>688</xloc>
-      <yloc>400</yloc>
+      <xloc>320</xloc>
+      <yloc>176</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
   <step>
-    <name>Sort rows 2</name>
-    <type>SortRows</type>
+    <name>param only</name>
+    <type>SelectValues</type>
     <description/>
     <distribute>Y</distribute>
     <custom_distribution/>
@@ -1853,22 +2092,17 @@ and tso.name = ? and tsol.vendor_id = ?</sql>
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <directory>%%java.io.tmpdir%%</directory>
-    <prefix>out</prefix>
-    <sort_size>1000000</sort_size>
-    <free_memory/>
-    <compress>N</compress>
-    <compress_variable/>
-    <unique_rows>N</unique_rows>
     <fields>
       <field>
         <name>id</name>
-        <ascending>Y</ascending>
-        <case_sensitive>N</case_sensitive>
-        <collator_enabled>N</collator_enabled>
-        <collator_strength>0</collator_strength>
-        <presorted>N</presorted>
       </field>
+      <field>
+        <name>invoice_origin</name>
+      </field>
+      <field>
+        <name>product_id</name>
+      </field>
+      <select_unspecified>N</select_unspecified>
     </fields>
     <attributes/>
     <cluster_schema/>
@@ -1879,119 +2113,14 @@ and tso.name = ? and tsol.vendor_id = ?</sql>
       </output>
     </remotesteps>
     <GUI>
-      <xloc>832</xloc>
-      <yloc>272</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Merge join 2</name>
-    <type>MergeJoin</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <join_type>LEFT OUTER</join_type>
-    <step1>Sort rows</step1>
-    <step2>Sort rows 2</step2>
-    <keys_1>
-      <key>id</key>
-    </keys_1>
-    <keys_2>
-      <key>id</key>
-    </keys_2>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>832</xloc>
-      <yloc>400</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Calculator</name>
-    <type>Calculator</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <failIfNoFile>Y</failIfNoFile>
-    <calculation>
-      <field_name>margin</field_name>
-      <calc_type>SUBTRACT</calc_type>
-      <field_a>penjualan</field_a>
-      <field_b>hpp</field_b>
-      <field_c/>
-      <value_type>None</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>div_margin</field_name>
-      <calc_type>DIVIDE</calc_type>
-      <field_a>margin</field_a>
-      <field_b>penjualan</field_b>
-      <field_c/>
-      <value_type>None</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <calculation>
-      <field_name>percent_margin</field_name>
-      <calc_type>MULTIPLY</calc_type>
-      <field_a>div_margin</field_a>
-      <field_b>one_hundred</field_b>
-      <field_c/>
-      <value_type>None</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>992</xloc>
-      <yloc>160</yloc>
+      <xloc>688</xloc>
+      <yloc>192</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
   <step>
-    <name>Add constants</name>
-    <type>Constant</type>
+    <name>penjualan</name>
+    <type>SortRows</type>
     <description/>
     <distribute>Y</distribute>
     <custom_distribution/>
@@ -2000,18 +2129,21 @@ and tso.name = ? and tsol.vendor_id = ?</sql>
       <method>none</method>
       <schema_name/>
     </partitioning>
+    <directory>%%java.io.tmpdir%%</directory>
+    <prefix>out</prefix>
+    <sort_size>1000000</sort_size>
+    <free_memory/>
+    <compress>N</compress>
+    <compress_variable/>
+    <unique_rows>N</unique_rows>
     <fields>
       <field>
-        <name>one_hundred</name>
-        <type>BigNumber</type>
-        <format/>
-        <currency/>
-        <decimal/>
-        <group/>
-        <nullif>100</nullif>
-        <length>-1</length>
-        <precision>-1</precision>
-        <set_empty_string>N</set_empty_string>
+        <name>id</name>
+        <ascending>Y</ascending>
+        <case_sensitive>N</case_sensitive>
+        <collator_enabled>N</collator_enabled>
+        <collator_strength>0</collator_strength>
+        <presorted>N</presorted>
       </field>
     </fields>
     <attributes/>
@@ -2023,16 +2155,16 @@ and tso.name = ? and tsol.vendor_id = ?</sql>
       </output>
     </remotesteps>
     <GUI>
-      <xloc>992</xloc>
-      <yloc>32</yloc>
+      <xloc>144</xloc>
+      <yloc>176</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
   <step>
-    <name>Select values</name>
+    <name>select all</name>
     <type>SelectValues</type>
     <description/>
-    <distribute>Y</distribute>
+    <distribute>N</distribute>
     <custom_distribution/>
     <copies>1</copies>
     <partitioning>
@@ -2042,103 +2174,66 @@ and tso.name = ? and tsol.vendor_id = ?</sql>
     <fields>
       <field>
         <name>id</name>
-        <rename/>
       </field>
       <field>
         <name>move_id</name>
-        <rename/>
       </field>
       <field>
         <name>date</name>
-        <rename/>
       </field>
       <field>
         <name>invoice_origin</name>
-        <rename/>
       </field>
       <field>
         <name>invoice</name>
-        <rename/>
       </field>
       <field>
         <name>customer</name>
-        <rename/>
       </field>
       <field>
         <name>lob</name>
-        <rename/>
       </field>
       <field>
         <name>brand</name>
-        <rename/>
       </field>
       <field>
         <name>product_id</name>
-        <rename/>
       </field>
       <field>
         <name>item_code</name>
-        <rename/>
       </field>
       <field>
         <name>product</name>
-        <rename/>
       </field>
       <field>
         <name>salesperson</name>
-        <rename/>
       </field>
       <field>
         <name>quantity</name>
-        <rename/>
       </field>
       <field>
         <name>price_unit</name>
-        <rename/>
       </field>
       <field>
         <name>price_subtotal</name>
-        <rename/>
       </field>
       <field>
         <name>price_total</name>
-        <rename/>
       </field>
       <field>
         <name>penjualan</name>
-        <rename/>
-      </field>
-      <field>
-        <name>hpp</name>
-        <rename/>
-      </field>
-      <field>
-        <name>sale_order</name>
-        <rename/>
-      </field>
-      <field>
-        <name>sale_product_id</name>
-        <rename/>
-      </field>
-      <field>
-        <name>vendor_id</name>
-        <rename/>
       </field>
       <field>
-        <name>vendor</name>
-        <rename/>
+        <name>id_1</name>
       </field>
       <field>
-        <name>margin</name>
-        <rename/>
+        <name>move_id_1</name>
       </field>
       <field>
-        <name>div_margin</name>
-        <rename/>
+        <name>product_id_1</name>
       </field>
       <field>
-        <name>percent_margin</name>
-        <rename/>
+        <name>hpp</name>
       </field>
       <select_unspecified>N</select_unspecified>
     </fields>
@@ -2151,171 +2246,8 @@ and tso.name = ? and tsol.vendor_id = ?</sql>
       </output>
     </remotesteps>
     <GUI>
-      <xloc>992</xloc>
-      <yloc>256</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Insert / update</name>
-    <type>InsertUpdate</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <connection>dw bi indoteknik (localhost)</connection>
-    <commit>100</commit>
-    <update_bypassed>N</update_bypassed>
-    <lookup>
-      <schema>public</schema>
-      <table>margin_invoice_v3</table>
-      <key>
-        <name/>
-        <field>id</field>
-        <condition/>
-        <name2/>
-      </key>
-      <value>
-        <name>id</name>
-        <rename>id</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>move_id</name>
-        <rename>move_id</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>date</name>
-        <rename>date</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>invoice_origin</name>
-        <rename>invoice_origin</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>invoice</name>
-        <rename>invoice</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>customer</name>
-        <rename>customer</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>lob</name>
-        <rename>lob</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>brand</name>
-        <rename>brand</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>product_id</name>
-        <rename>product_id</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>item_code</name>
-        <rename>item_code</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>product</name>
-        <rename>product</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>salesperson</name>
-        <rename>salesperson</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>quantity</name>
-        <rename>quantity</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_unit</name>
-        <rename>price_unit</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_subtotal</name>
-        <rename>price_subtotal</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>price_total</name>
-        <rename>price_total</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>penjualan</name>
-        <rename>penjualan</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>hpp</name>
-        <rename>hpp</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>sale_order</name>
-        <rename>sale_order</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>sale_product_id</name>
-        <rename>sale_product_id</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>vendor_id</name>
-        <rename>vendor_id</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>vendor</name>
-        <rename>vendor</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>margin</name>
-        <rename>margin</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>div_margin</name>
-        <rename>div_margin</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>percent_margin</name>
-        <rename>percent_margin</rename>
-        <update>Y</update>
-      </value>
-    </lookup>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>992</xloc>
-      <yloc>352</yloc>
+      <xloc>560</xloc>
+      <yloc>288</yloc>
       <draw>Y</draw>
     </GUI>
   </step>