diff options
| -rw-r--r-- | import_match_payment_invoice.ktr | 4 | ||||
| -rw-r--r-- | import_payment_term.ktr | 198 |
2 files changed, 102 insertions, 100 deletions
diff --git a/import_match_payment_invoice.ktr b/import_match_payment_invoice.ktr index 11e4155..7074623 100644 --- a/import_match_payment_invoice.ktr +++ b/import_match_payment_invoice.ktr @@ -556,7 +556,9 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select * from v_match_payment_invoice</sql> + <sql>select * from v_match_payment_invoice v +join account_payment ap on ap.id = v.payment_id +where ap.write_date >= (now() - '15 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> diff --git a/import_payment_term.ktr b/import_payment_term.ktr index fe74f64..28460e0 100644 --- a/import_payment_term.ktr +++ b/import_payment_term.ktr @@ -638,6 +638,104 @@ </GUI> </step> <step> + <name>Insert / update 2</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_line</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>value</name> + <rename>value</rename> + <update>Y</update> + </value> + <value> + <name>value_amount</name> + <rename>value_amount</rename> + <update>Y</update> + </value> + <value> + <name>days</name> + <rename>days</rename> + <update>Y</update> + </value> + <value> + <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> + <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>272</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -916,7 +1014,7 @@ where write_date >= (now() - '3 days'::interval)</sql> </partitioning> <connection>erp indoteknik production (localhost)</connection> <sql>select * from account_payment_term_line ---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> @@ -938,104 +1036,6 @@ where write_date >= (now() - '3 days'::interval)</sql> <draw>Y</draw> </GUI> </step> - <step> - <name>Insert / update 2</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_line</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>value</name> - <rename>value</rename> - <update>Y</update> - </value> - <value> - <name>value_amount</name> - <rename>value_amount</rename> - <update>Y</update> - </value> - <value> - <name>days</name> - <rename>days</rename> - <update>Y</update> - </value> - <value> - <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> - <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>272</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |