From e3fe71fe0267470987ffa185cc4abbbf69776263 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Mon, 10 Jun 2024 07:54:35 +0700 Subject: fix error import account payment --- import_account_payment.ktr | 342 ++++++++++++++++++++++----------------------- 1 file changed, 171 insertions(+), 171 deletions(-) diff --git a/import_account_payment.ktr b/import_account_payment.ktr index a8f9adb..5bb207f 100644 --- a/import_account_payment.ktr +++ b/import_account_payment.ktr @@ -430,7 +430,7 @@ 2024/06/06 13:55:23.489 - 2024/06/06 13:55:23.489 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N @@ -544,6 +544,174 @@ Y + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + account_payment
+ + id + id + = + + + + id + id + N + + + move_id + move_id + Y + + + is_reconciled + is_reconciled + Y + + + is_matched + is_matched + Y + + + partner_bank_id + partner_bank_id + Y + + + is_internal_transfer + is_internal_transfer + Y + + + payment_method_id + payment_method_id + Y + + + amount + amount + Y + + + payment_type + payment_type + Y + + + partner_type + partner_type + Y + + + payment_reference + payment_reference + Y + + + currency_id + currency_id + Y + + + partner_id + partner_id + Y + + + destination_account_id + destination_account_id + Y + + + message_main_attachment_id + message_main_attachment_id + Y + + + create_uid + create_uid + Y + + + create_date + create_date + Y + + + write_uid + write_uid + Y + + + write_date + write_date + Y + + + payment_transaction_id + payment_transaction_id + Y + + + payment_token_id + payment_token_id + Y + + + check_amount_in_words + check_amount_in_words + Y + + + check_number + check_number + Y + + + bank_reference + bank_reference + Y + + + cheque_reference + cheque_reference + Y + + + effective_date + effective_date + Y + + + + + + + + + + + + 400 + 96 + Y + + Table input TableInput @@ -556,9 +724,9 @@ erp indoteknik production (localhost) - select * from account_payment + select * from account_payment ap where 1=1 -and am.write_date >= (now() - '3 days'::interval) +and ap.write_date >= (now() - '3 days'::interval) 0 N @@ -1179,174 +1347,6 @@ and am.write_date >= (now() - '3 days'::interval) Y - - Insert / update - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - 100 - N - - public - account_payment
- - id - id - = - - - - id - id - N - - - move_id - move_id - Y - - - is_reconciled - is_reconciled - Y - - - is_matched - is_matched - Y - - - partner_bank_id - partner_bank_id - Y - - - is_internal_transfer - is_internal_transfer - Y - - - payment_method_id - payment_method_id - Y - - - amount - amount - Y - - - payment_type - payment_type - Y - - - partner_type - partner_type - Y - - - payment_reference - payment_reference - Y - - - currency_id - currency_id - Y - - - partner_id - partner_id - Y - - - destination_account_id - destination_account_id - Y - - - message_main_attachment_id - message_main_attachment_id - Y - - - create_uid - create_uid - Y - - - create_date - create_date - Y - - - write_uid - write_uid - Y - - - write_date - write_date - Y - - - payment_transaction_id - payment_transaction_id - Y - - - payment_token_id - payment_token_id - Y - - - check_amount_in_words - check_amount_in_words - Y - - - check_number - check_number - Y - - - bank_reference - bank_reference - Y - - - cheque_reference - cheque_reference - Y - - - effective_date - effective_date - Y - - - - - - - - - - - - 400 - 96 - Y - - -- cgit v1.2.3