From c0d9208be808f5b26ddc5ddd84bfed9f286e4956 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Thu, 16 Mar 2023 13:29:07 +0700 Subject: add difference so to po in day --- import_leadtime_so_send.ktr | 511 ++++++++++++++++++++++---------------------- 1 file changed, 260 insertions(+), 251 deletions(-) (limited to 'import_leadtime_so_send.ktr') diff --git a/import_leadtime_so_send.ktr b/import_leadtime_so_send.ktr index 130c5f9..c34183d 100644 --- a/import_leadtime_so_send.ktr +++ b/import_leadtime_so_send.ktr @@ -430,7 +430,7 @@ 2023/03/15 16:34:19.382 - 2023/03/15 16:34:19.382 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N @@ -549,6 +549,261 @@ Y + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik + 100 + N + + public + leadtime_so_to_send
+ + id + id + = + + + + id + id + N + + + so_number + so_number + Y + + + customer + customer + Y + + + date_so_approved + date_so_approved + Y + + + date_po_approved + date_po_approved + Y + + + date_last_received + date_last_received + Y + + + date_last_send + date_last_send + Y + + + diff_po_so + diff_po_so + Y + + + diff_po_so_in_hour + diff_po_so_in_hour + Y + + + diff_received_po + diff_received_po + Y + + + diff_received_po_in_day + diff_received_po_in_day + Y + + + diff_received_send + diff_received_send + Y + + + diff_received_send_in_hour + diff_received_send_in_hour + Y + + + diff_received_send_in_day + diff_received_send_in_day + Y + + + diff_so_send + diff_so_send + Y + + + diff_so_send_in_day + diff_so_send_in_day + Y + + + year_month + year_month + Y + + + year + year + Y + + + month + month + Y + + + day + day + Y + + + diff_po_so_in_day + diff_po_so_in_day + Y + + + + + + + + + + + + 592 + 128 + Y + + + + Select values + SelectValues + + Y + + 1 + + none + + + + + id + + + + so_number + + + + customer + + + + date_so_approved + + + + date_po_approved + + + + date_last_received + + + + date_last_send + + + + diff_po_so + + + + diff_po_so_in_hour + + + + diff_received_po + + + + diff_received_po_in_day + + + + diff_received_send + + + + diff_received_send_in_hour + + + + diff_received_send_in_day + + + + diff_so_send + + + + diff_so_send_in_day + + + + year_month + + + + year + + + + month + + + + day + + + + diff_po_so_in_day + + + N + + + + + + + + + + + 432 + 128 + Y + + Table input TableInput @@ -735,7 +990,7 @@ normal diff_po_so -1 - 6 + -1 Table input diff_po_so @@ -781,7 +1036,7 @@ normal diff_received_po -1 - 6 + -1 Table input diff_received_po @@ -827,7 +1082,7 @@ normal diff_received_send -1 - 6 + -1 Table input diff_received_send @@ -896,7 +1151,7 @@ normal diff_so_send -1 - 6 + -1 Table input diff_so_send @@ -952,252 +1207,6 @@ Y - - Select values - SelectValues - - Y - - 1 - - none - - - - - id - - - - so_number - - - - customer - - - - date_so_approved - - - - date_po_approved - - - - date_last_received - - - - date_last_send - - - - diff_po_so - - - - diff_po_so_in_hour - - - - diff_received_po - - - - diff_received_po_in_day - - - - diff_received_send - - - - diff_received_send_in_hour - - - - diff_received_send_in_day - - - - diff_so_send - - - - diff_so_send_in_day - - - - year_month - - - - year - - - - month - - - - day - - - N - - - - - - - - - - - 432 - 128 - Y - - - - Insert / update - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik - 100 - N - - public - leadtime_so_to_send
- - id - id - = - - - - id - id - N - - - so_number - so_number - Y - - - customer - customer - Y - - - date_so_approved - date_so_approved - Y - - - date_po_approved - date_po_approved - Y - - - date_last_received - date_last_received - Y - - - date_last_send - date_last_send - Y - - - diff_po_so - diff_po_so - Y - - - diff_po_so_in_hour - diff_po_so_in_hour - Y - - - diff_received_po - diff_received_po - Y - - - diff_received_po_in_day - diff_received_po_in_day - Y - - - diff_received_send - diff_received_send - Y - - - diff_received_send_in_hour - diff_received_send_in_hour - Y - - - diff_received_send_in_day - diff_received_send_in_day - Y - - - diff_so_send - diff_so_send - Y - - - diff_so_send_in_day - diff_so_send_in_day - Y - - - year_month - year_month - Y - - - year - year - Y - - - month - month - Y - - - day - day - Y - - - - - - - - - - - - 592 - 128 - Y - - -- cgit v1.2.3