diff options
Diffstat (limited to 'import_payment_term.ktr')
| -rw-r--r-- | import_payment_term.ktr | 164 |
1 files changed, 151 insertions, 13 deletions
diff --git a/import_payment_term.ktr b/import_payment_term.ktr index 4da70b8..fe74f64 100644 --- a/import_payment_term.ktr +++ b/import_payment_term.ktr @@ -430,7 +430,7 @@ <created_date>2023/11/17 09:24:28.339</created_date> <modified_user>-</modified_user> <modified_date>2023/11/17 09:24:28.339</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> @@ -543,8 +543,101 @@ <to>Insert / update</to> <enabled>Y</enabled> </hop> + <hop> + <from>Table input 2</from> + <to>Insert / update 2</to> + <enabled>Y</enabled> + </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>account_payment_term</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>active</name> + <rename>active</rename> + <update>Y</update> + </value> + <value> + <name>note</name> + <rename>note</rename> + <update>Y</update> + </value> + <value> + <name>company_id</name> + <rename>company_id</rename> + <update>Y</update> + </value> + <value> + <name>sequence</name> + <rename>sequence</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> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>368</xloc> + <yloc>128</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -557,7 +650,7 @@ </partitioning> <connection>erp indoteknik production (localhost)</connection> <sql>select * from account_payment_term -where write_date >= (now() - '5 days'::interval)</sql> +where write_date >= (now() - '3 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -811,7 +904,42 @@ where write_date >= (now() - '5 days'::interval)</sql> </GUI> </step> <step> - <name>Insert / update</name> + <name>Table input 2</name> + <type>TableInput</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik production (localhost)</connection> + <sql>select * from account_payment_term_line +--where write_date >= (now() - '5 days'::interval)</sql> + <limit>0</limit> + <lookup/> + <execute_each_row>N</execute_each_row> + <variables_active>N</variables_active> + <lazy_conversion_active>N</lazy_conversion_active> + <cached_row_meta_active>N</cached_row_meta_active> + <row-meta/> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>224</xloc> + <yloc>272</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Insert / update 2</name> <type>InsertUpdate</type> <description/> <distribute>Y</distribute> @@ -826,7 +954,7 @@ where write_date >= (now() - '5 days'::interval)</sql> <update_bypassed>N</update_bypassed> <lookup> <schema>public</schema> - <table>account_payment_term</table> + <table>account_payment_term_line</table> <key> <name>id</name> <field>id</field> @@ -839,23 +967,33 @@ where write_date >= (now() - '5 days'::interval)</sql> <update>N</update> </value> <value> - <name>name</name> - <rename>name</rename> + <name>value</name> + <rename>value</rename> <update>Y</update> </value> <value> - <name>active</name> - <rename>active</rename> + <name>value_amount</name> + <rename>value_amount</rename> <update>Y</update> </value> <value> - <name>note</name> - <rename>note</rename> + <name>days</name> + <rename>days</rename> <update>Y</update> </value> <value> - <name>company_id</name> - <rename>company_id</rename> + <name>day_of_the_month</name> + <rename>day_of_the_month</rename> + <update>Y</update> + </value> + <value> + <name>option</name> + <rename>option</rename> + <update>Y</update> + </value> + <value> + <name>payment_id</name> + <rename>payment_id</rename> <update>Y</update> </value> <value> @@ -894,7 +1032,7 @@ where write_date >= (now() - '5 days'::interval)</sql> </remotesteps> <GUI> <xloc>368</xloc> - <yloc>128</yloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> |