diff options
Diffstat (limited to 'capture_available_minus.ktr')
| -rw-r--r-- | capture_available_minus.ktr | 272 |
1 files changed, 104 insertions, 168 deletions
diff --git a/capture_available_minus.ktr b/capture_available_minus.ktr index 2bcb431..e717bf7 100644 --- a/capture_available_minus.ktr +++ b/capture_available_minus.ktr @@ -761,6 +761,110 @@ </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>Y</update_bypassed> + <lookup> + <schema>public</schema> + <table>stock_quant_history</table> + <key> + <name>history_date</name> + <field>history_date</field> + <condition>=</condition> + <name2/> + </key> + <key> + <name>product_id</name> + <field>product_id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>product_id</name> + <rename>product_id</rename> + <update>Y</update> + </value> + <value> + <name>location_id</name> + <rename>location_id</rename> + <update>Y</update> + </value> + <value> + <name>qty_onhand</name> + <rename>qty_onhand</rename> + <update>Y</update> + </value> + <value> + <name>reserved_quantity</name> + <rename>reserved_quantity</rename> + <update>Y</update> + </value> + <value> + <name>item_code</name> + <rename>item_code</rename> + <update>Y</update> + </value> + <value> + <name>product_name</name> + <rename>product_name</rename> + <update>Y</update> + </value> + <value> + <name>history_date</name> + <rename>history_date</rename> + <update>Y</update> + </value> + <value> + <name>qty_outgoing</name> + <rename>qty_outgoing</rename> + <update>Y</update> + </value> + <value> + <name>qty_incoming</name> + <rename>qty_incoming</rename> + <update>Y</update> + </value> + <value> + <name>qty_available</name> + <rename>qty_available</rename> + <update>Y</update> + </value> + <value> + <name>product_max_qty</name> + <rename>product_max_qty</rename> + <update>Y</update> + </value> + <value> + <name>plafon_qty</name> + <rename>plafon_qty</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>528</xloc> + <yloc>352</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Merge join</name> <type>MergeJoin</type> <description/> @@ -876,67 +980,51 @@ <fields> <field> <name>product_id</name> - <rename/> </field> <field> <name>product_id2</name> - <rename/> </field> <field> <name>location_id</name> - <rename/> </field> <field> <name>qty_onhand</name> - <rename/> </field> <field> <name>reserved_quantity</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product_name</name> - <rename/> </field> <field> <name>current_date</name> - <rename/> </field> <field> <name>product_id_3</name> - <rename/> </field> <field> <name>qty_outgoing</name> - <rename/> </field> <field> <name>product_id_1</name> - <rename/> </field> <field> <name>qty_incoming</name> - <rename/> </field> <field> <name>incoming_plus_onhand</name> - <rename/> </field> <field> <name>qty_available</name> - <rename/> </field> <field> <name>product_id_2</name> - <rename/> </field> <field> <name>product_max_qty</name> - <rename/> </field> <select_unspecified>N</select_unspecified> <meta> @@ -1019,27 +1107,21 @@ <fields> <field> <name>product_id</name> - <rename/> </field> <field> <name>location_id</name> - <rename/> </field> <field> <name>qty_onhand</name> - <rename/> </field> <field> <name>reserved_quantity</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product_name</name> - <rename/> </field> <field> <name>current_date</name> @@ -1047,23 +1129,18 @@ </field> <field> <name>qty_outgoing</name> - <rename/> </field> <field> <name>qty_incoming</name> - <rename/> </field> <field> <name>qty_available</name> - <rename/> </field> <field> <name>product_max_qty</name> - <rename/> </field> <field> <name>plafon_qty</name> - <rename/> </field> <select_unspecified>N</select_unspecified> <meta> @@ -1297,59 +1374,45 @@ <fields> <field> <name>product_id</name> - <rename/> </field> <field> <name>product_id2</name> - <rename/> </field> <field> <name>location_id</name> - <rename/> </field> <field> <name>qty_onhand</name> - <rename/> </field> <field> <name>reserved_quantity</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product_name</name> - <rename/> </field> <field> <name>current_date</name> - <rename/> </field> <field> <name>product_id_3</name> - <rename/> </field> <field> <name>qty_outgoing</name> - <rename/> </field> <field> <name>product_id_1</name> - <rename/> </field> <field> <name>qty_incoming</name> - <rename/> </field> <field> <name>incoming_plus_onhand</name> - <rename/> </field> <field> <name>qty_available</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -1734,35 +1797,27 @@ <fields> <field> <name>product_id</name> - <rename/> </field> <field> <name>product_id2</name> - <rename/> </field> <field> <name>location_id</name> - <rename/> </field> <field> <name>quantity</name> - <rename/> </field> <field> <name>reserved_quantity</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product_name</name> - <rename/> </field> <field> <name>current_date</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -1997,43 +2052,33 @@ order by sq.product_id</sql> <fields> <field> <name>product_id</name> - <rename/> </field> <field> <name>product_id2</name> - <rename/> </field> <field> <name>location_id</name> - <rename/> </field> <field> <name>quantity</name> - <rename/> </field> <field> <name>reserved_quantity</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product_name</name> - <rename/> </field> <field> <name>current_date</name> - <rename/> </field> <field> <name>product_id_3</name> - <rename/> </field> <field> <name>qty_outgoing</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -2065,15 +2110,12 @@ order by sq.product_id</sql> <fields> <field> <name>product_id</name> - <rename/> </field> <field> <name>product_id2</name> - <rename/> </field> <field> <name>location_id</name> - <rename/> </field> <field> <name>quantity</name> @@ -2081,35 +2123,27 @@ order by sq.product_id</sql> </field> <field> <name>reserved_quantity</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product_name</name> - <rename/> </field> <field> <name>current_date</name> - <rename/> </field> <field> <name>product_id_3</name> - <rename/> </field> <field> <name>qty_outgoing</name> - <rename/> </field> <field> <name>product_id_1</name> - <rename/> </field> <field> <name>qty_incoming</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -2127,104 +2161,6 @@ order by sq.product_id</sql> <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>Y</update_bypassed> - <lookup> - <schema>public</schema> - <table>stock_quant_history</table> - <key> - <name>product_id</name> - <field>product_id</field> - <condition>=</condition> - <name2/> - </key> - <value> - <name>product_id</name> - <rename>product_id</rename> - <update>Y</update> - </value> - <value> - <name>location_id</name> - <rename>location_id</rename> - <update>Y</update> - </value> - <value> - <name>qty_onhand</name> - <rename>qty_onhand</rename> - <update>Y</update> - </value> - <value> - <name>reserved_quantity</name> - <rename>reserved_quantity</rename> - <update>Y</update> - </value> - <value> - <name>item_code</name> - <rename>item_code</rename> - <update>Y</update> - </value> - <value> - <name>product_name</name> - <rename>product_name</rename> - <update>Y</update> - </value> - <value> - <name>history_date</name> - <rename>history_date</rename> - <update>Y</update> - </value> - <value> - <name>qty_outgoing</name> - <rename>qty_outgoing</rename> - <update>Y</update> - </value> - <value> - <name>qty_incoming</name> - <rename>qty_incoming</rename> - <update>Y</update> - </value> - <value> - <name>qty_available</name> - <rename>qty_available</rename> - <update>Y</update> - </value> - <value> - <name>product_max_qty</name> - <rename>product_max_qty</rename> - <update>Y</update> - </value> - <value> - <name>plafon_qty</name> - <rename>plafon_qty</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>528</xloc> - <yloc>352</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |