diff options
Diffstat (limited to 'import_stock_location.ktr')
| -rw-r--r-- | import_stock_location.ktr | 298 |
1 files changed, 149 insertions, 149 deletions
diff --git a/import_stock_location.ktr b/import_stock_location.ktr index 84bfc09..8e21351 100644 --- a/import_stock_location.ktr +++ b/import_stock_location.ktr @@ -430,7 +430,7 @@ <created_date>2023/10/20 10:43:20.923</created_date> <modified_user>-</modified_user> <modified_date>2023/10/20 10:43:20.923</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> @@ -545,6 +545,154 @@ </hop> </order> <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>stock_location</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>name</name> + <rename>name</rename> + <update>Y</update> + </value> + <value> + <name>complete_name</name> + <rename>complete_name</rename> + <update>Y</update> + </value> + <value> + <name>active</name> + <rename>active</rename> + <update>Y</update> + </value> + <value> + <name>usage</name> + <rename>usage</rename> + <update>Y</update> + </value> + <value> + <name>location_id</name> + <rename>location_id</rename> + <update>Y</update> + </value> + <value> + <name>comment</name> + <rename>comment</rename> + <update>Y</update> + </value> + <value> + <name>posx</name> + <rename>posx</rename> + <update>Y</update> + </value> + <value> + <name>posy</name> + <rename>posy</rename> + <update>Y</update> + </value> + <value> + <name>posz</name> + <rename>posz</rename> + <update>Y</update> + </value> + <value> + <name>parent_path</name> + <rename>parent_path</rename> + <update>Y</update> + </value> + <value> + <name>company_id</name> + <rename>company_id</rename> + <update>Y</update> + </value> + <value> + <name>scrap_location</name> + <rename>scrap_location</rename> + <update>Y</update> + </value> + <value> + <name>return_location</name> + <rename>return_location</rename> + <update>Y</update> + </value> + <value> + <name>removal_strategy_id</name> + <rename>removal_strategy_id</rename> + <update>Y</update> + </value> + <value> + <name>barcode</name> + <rename>barcode</rename> + <update>Y</update> + </value> + <value> + <name>create_uid</name> + <rename>create_uid</rename> + <update>Y</update> + </value> + <value> + <name>create_date</name> + <rename>create_date</rename> + <update>Y</update> + </value> + <value> + <name>write_uid</name> + <rename>write_uid</rename> + <update>Y</update> + </value> + <value> + <name>write_date</name> + <rename>write_date</rename> + <update>Y</update> + </value> + <value> + <name>valuation_in_account_id</name> + <rename>valuation_in_account_id</rename> + <update>Y</update> + </value> + <value> + <name>valuation_out_account_id</name> + <rename>valuation_out_account_id</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>320</xloc> + <yloc>48</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -1085,154 +1233,6 @@ <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>stock_location</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>name</name> - <rename>name</rename> - <update>Y</update> - </value> - <value> - <name>complete_name</name> - <rename>complete_name</rename> - <update>Y</update> - </value> - <value> - <name>active</name> - <rename>active</rename> - <update>Y</update> - </value> - <value> - <name>usage</name> - <rename>usage</rename> - <update>Y</update> - </value> - <value> - <name>location_id</name> - <rename>location_id</rename> - <update>Y</update> - </value> - <value> - <name>comment</name> - <rename>comment</rename> - <update>Y</update> - </value> - <value> - <name>posx</name> - <rename>posx</rename> - <update>Y</update> - </value> - <value> - <name>posy</name> - <rename>posy</rename> - <update>Y</update> - </value> - <value> - <name>posz</name> - <rename>posz</rename> - <update>Y</update> - </value> - <value> - <name>parent_path</name> - <rename>parent_path</rename> - <update>Y</update> - </value> - <value> - <name>company_id</name> - <rename>company_id</rename> - <update>Y</update> - </value> - <value> - <name>scrap_location</name> - <rename>scrap_location</rename> - <update>Y</update> - </value> - <value> - <name>return_location</name> - <rename>return_location</rename> - <update>Y</update> - </value> - <value> - <name>removal_strategy_id</name> - <rename>removal_strategy_id</rename> - <update>Y</update> - </value> - <value> - <name>barcode</name> - <rename>barcode</rename> - <update>Y</update> - </value> - <value> - <name>create_uid</name> - <rename>create_uid</rename> - <update>Y</update> - </value> - <value> - <name>create_date</name> - <rename>create_date</rename> - <update>Y</update> - </value> - <value> - <name>write_uid</name> - <rename>write_uid</rename> - <update>Y</update> - </value> - <value> - <name>write_date</name> - <rename>write_date</rename> - <update>Y</update> - </value> - <value> - <name>valuation_in_account_id</name> - <rename>valuation_in_account_id</rename> - <update>Y</update> - </value> - <value> - <name>valuation_out_account_id</name> - <rename>valuation_out_account_id</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>320</xloc> - <yloc>48</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |