From c54a584c08f11ae73f05973defd1899ba9740557 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Fri, 7 Jun 2024 11:34:21 +0700 Subject: import match payment invoice --- import_match_payment_invoice.ktr | 4 +- 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 @@ erp indoteknik production (localhost) - select * from v_match_payment_invoice + 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) 0 N 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 @@ -637,6 +637,104 @@ Y + + Insert / update 2 + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + account_payment_term_line
+ + id + id + = + + + + id + id + N + + + value + value + Y + + + value_amount + value_amount + Y + + + days + days + Y + + + day_of_the_month + day_of_the_month + Y + + + option + option + Y + + + payment_id + payment_id + Y + + + sequence + sequence + Y + + + create_uid + create_uid + Y + + + create_date + create_date + Y + + + write_uid + write_uid + Y + + + write_date + write_date + Y + + + + + + + + + + + + 368 + 272 + Y + + Table input TableInput @@ -916,7 +1014,7 @@ where write_date >= (now() - '3 days'::interval) erp indoteknik production (localhost) select * from account_payment_term_line ---where write_date >= (now() - '5 days'::interval) +where write_date >= (now() - '3 days'::interval) 0 N @@ -938,104 +1036,6 @@ where write_date >= (now() - '3 days'::interval) Y - - Insert / update 2 - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - 100 - N - - public - account_payment_term_line
- - id - id - = - - - - id - id - N - - - value - value - Y - - - value_amount - value_amount - Y - - - days - days - Y - - - day_of_the_month - day_of_the_month - Y - - - option - option - Y - - - payment_id - payment_id - Y - - - sequence - sequence - Y - - - create_uid - create_uid - Y - - - create_date - create_date - Y - - - write_uid - write_uid - Y - - - write_date - write_date - Y - - - - - - - - - - - - 368 - 272 - Y - - -- cgit v1.2.3