From 9514604fe0636bb953071a8ac52ae79ed3d8f17c Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Mon, 28 Jul 2025 16:44:01 +0700 Subject: add calculate leadtime po to mr --- import_leadtime_job.kjb | 100 +++++++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 98 insertions(+), 2 deletions(-) (limited to 'import_leadtime_job.kjb') diff --git a/import_leadtime_job.kjb b/import_leadtime_job.kjb index ad27f35..ce61814 100644 --- a/import_leadtime_job.kjb +++ b/import_leadtime_job.kjb @@ -472,8 +472,86 @@ N Y 0 - 1040 - 304 + 544 + 416 + + + + calculate lead time so to po working hour + + TRANS + + filename + + /home/stephan/transformation-job-bi/calculate_leadtime_so_to_delivered.ktr + + N + N + N + N + N + N + + + N + N + Basic + N + + N + Y + N + N + N + Pentaho local + N + + Y + + N + Y + 0 + 832 + 368 + + + + calculate lead time po to arrival working hour + + TRANS + + filename + + /home/stephan/transformation-job-bi/calculate_leadtime_po_to_mr.ktr + + N + N + N + N + N + N + + + N + N + Basic + N + + N + Y + N + N + N + Pentaho local + N + + Y + + N + Y + 0 + 816 + 480 @@ -516,6 +594,24 @@ import leadtime detail so to send + calculate lead time so to po working hour + 0 + 0 + Y + Y + N + + + calculate lead time so to po working hour + calculate lead time po to arrival working hour + 0 + 0 + Y + Y + N + + + calculate lead time po to arrival working hour Success 0 0 -- cgit v1.2.3