From 906e9d752d0d075037d30b0d4f9de4b90f87d2d2 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 13 May 2025 10:14:06 +0700 Subject: add capture available minus --- capture_available_minus.ktr | 2234 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 2234 insertions(+) create mode 100644 capture_available_minus.ktr (limited to 'capture_available_minus.ktr') diff --git a/capture_available_minus.ktr b/capture_available_minus.ktr new file mode 100644 index 0000000..2bcb431 --- /dev/null +++ b/capture_available_minus.ktr @@ -0,0 +1,2234 @@ + + + + capture_available_minus + + + + Normal + / + + + + + + + + + + + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + TRANSNAME + Y + TRANSNAME + + + STATUS + Y + STATUS + + + LINES_READ + Y + LINES_READ + + + + LINES_WRITTEN + Y + LINES_WRITTEN + + + + LINES_UPDATED + Y + LINES_UPDATED + + + + LINES_INPUT + Y + LINES_INPUT + + + + LINES_OUTPUT + Y + LINES_OUTPUT + + + + LINES_REJECTED + Y + LINES_REJECTED + + + + ERRORS + Y + ERRORS + + + STARTDATE + Y + STARTDATE + + + ENDDATE + Y + ENDDATE + + + LOGDATE + Y + LOGDATE + + + DEPDATE + Y + DEPDATE + + + REPLAYDATE + Y + REPLAYDATE + + + LOG_FIELD + Y + LOG_FIELD + + + EXECUTING_SERVER + N + EXECUTING_SERVER + + + EXECUTING_USER + N + EXECUTING_USER + + + CLIENT + N + CLIENT + + + + + +
+ + + + ID_BATCH + Y + ID_BATCH + + + SEQ_NR + Y + SEQ_NR + + + LOGDATE + Y + LOGDATE + + + TRANSNAME + Y + TRANSNAME + + + STEPNAME + Y + STEPNAME + + + STEP_COPY + Y + STEP_COPY + + + LINES_READ + Y + LINES_READ + + + LINES_WRITTEN + Y + LINES_WRITTEN + + + LINES_UPDATED + Y + LINES_UPDATED + + + LINES_INPUT + Y + LINES_INPUT + + + LINES_OUTPUT + Y + LINES_OUTPUT + + + LINES_REJECTED + Y + LINES_REJECTED + + + ERRORS + Y + ERRORS + + + INPUT_BUFFER_ROWS + Y + INPUT_BUFFER_ROWS + + + OUTPUT_BUFFER_ROWS + Y + OUTPUT_BUFFER_ROWS + + + + + +
+ + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + LOG_DATE + Y + LOG_DATE + + + LOGGING_OBJECT_TYPE + Y + LOGGING_OBJECT_TYPE + + + OBJECT_NAME + Y + OBJECT_NAME + + + OBJECT_COPY + Y + OBJECT_COPY + + + REPOSITORY_DIRECTORY + Y + REPOSITORY_DIRECTORY + + + FILENAME + Y + FILENAME + + + OBJECT_ID + Y + OBJECT_ID + + + OBJECT_REVISION + Y + OBJECT_REVISION + + + PARENT_CHANNEL_ID + Y + PARENT_CHANNEL_ID + + + ROOT_CHANNEL_ID + Y + ROOT_CHANNEL_ID + + + + + +
+ + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + LOG_DATE + Y + LOG_DATE + + + TRANSNAME + Y + TRANSNAME + + + STEPNAME + Y + STEPNAME + + + STEP_COPY + Y + STEP_COPY + + + LINES_READ + Y + LINES_READ + + + LINES_WRITTEN + Y + LINES_WRITTEN + + + LINES_UPDATED + Y + LINES_UPDATED + + + LINES_INPUT + Y + LINES_INPUT + + + LINES_OUTPUT + Y + LINES_OUTPUT + + + LINES_REJECTED + Y + LINES_REJECTED + + + ERRORS + Y + ERRORS + + + LOG_FIELD + N + LOG_FIELD + + + + + +
+ + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + LOG_DATE + Y + LOG_DATE + + + METRICS_DATE + Y + METRICS_DATE + + + METRICS_CODE + Y + METRICS_CODE + + + METRICS_DESCRIPTION + Y + METRICS_DESCRIPTION + + + METRICS_SUBJECT + Y + METRICS_SUBJECT + + + METRICS_TYPE + Y + METRICS_TYPE + + + METRICS_VALUE + Y + METRICS_VALUE + + + + + +
+ + 0.0 + 0.0 + + 10000 + 50 + 50 + N + Y + 50000 + Y + + N + 1000 + 100 + + + + + + + + + - + 2025/05/09 15:31:07.054 + - + 2025/05/09 15:31:07.054 + H4sIAAAAAAAAAAMAAAAAAAAAAAA= + N + + + + + dw bi indoteknik (localhost) + localhost + POSTGRESQL + Native + dw_bi_indoteknik + 5432 + odoo + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 + + + + + + FORCE_IDENTIFIERS_TO_LOWERCASE + N + + + FORCE_IDENTIFIERS_TO_UPPERCASE + N + + + IS_CLUSTERED + N + + + PORT_NUMBER + 5432 + + + PRESERVE_RESERVED_WORD_CASE + Y + + + QUOTE_ALL_FIELDS + N + + + SUPPORTS_BOOLEAN_DATA_TYPE + Y + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + + + + + erp indoteknik production (localhost) + 10.148.0.3 + POSTGRESQL + Native + erp_indoteknik + 5432 + pdi + Encrypted 2be989bb20084ca95810197629d9ea18e + + + + + + FORCE_IDENTIFIERS_TO_LOWERCASE + N + + + FORCE_IDENTIFIERS_TO_UPPERCASE + N + + + IS_CLUSTERED + N + + + PORT_NUMBER + 5432 + + + PRESERVE_RESERVED_WORD_CASE + Y + + + QUOTE_ALL_FIELDS + N + + + SUPPORTS_BOOLEAN_DATA_TYPE + Y + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + + + + + + select stock quant + Merge join + Y + + + select outgoing + Merge join + Y + + + Merge join + stock+outgoing + Y + + + Select values 2 + qty outgoing + Y + + + qty outgoing + Sort rows + Y + + + Sort rows + select outgoing + Y + + + Sort rows 2 + select stock quant + Y + + + stock quant + Select values 2 + Y + + + stock quant + Sort rows 2 + Y + + + Select values 2 + qty incoming + Y + + + qty incoming + Sort rows 3 + Y + + + Sort rows 3 + select incoming + Y + + + stock+outgoing + Merge join 2 + Y + + + select incoming + Merge join 2 + Y + + + Merge join 2 + stock+outgoing+incoming + Y + + + stock+outgoing+incoming + Calculator available + Y + + + Calculator available + available + Y + + + reordering + Sort rows 4 + Y + + + Sort rows 4 + Merge join 3 + Y + + + available + Merge join 3 + Y + + + Merge join 3 + Select values + Y + + + max plafon + Select values 3 + Y + + + Select values + If field value is null + Y + + + If field value is null + max plafon + Y + + + Select values 3 + Insert / update + Y + + + + Calculator available + Calculator + + Y + + 1 + + none + + + Y + + incoming_plus_onhand + ADD + qty_incoming + qty_onhand + + None + -1 + -1 + N + + + + + + + qty_available + SUBTRACT + incoming_plus_onhand + qty_outgoing + + None + -1 + -1 + N + + + + + + + + + + + + + + + 944 + 144 + Y + + + + If field value is null + IfNull + + Y + + 1 + + none + + + 0 + + Y + N + N + + + + + product_max_qty + 0 + + N + + + + + + + + + + + + 928 + 352 + Y + + + + Merge join + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + select stock quant + select outgoing + + product_id + + + product_id_3 + + + + + + + + + + + 480 + 256 + Y + + + + Merge join 2 + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + stock+outgoing + select incoming + + product_id + + + product_id + + + + + + + + + + + 656 + 144 + Y + + + + Merge join 3 + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + available + Sort rows 4 + + product_id + + + product_id + + + + + + + + + + + 1088 + 256 + Y + + + + Select values + SelectValues + + N + + 1 + + none + + + + + product_id + + + + product_id2 + + + + location_id + + + + qty_onhand + + + + reserved_quantity + + + + item_code + + + + product_name + + + + current_date + + + + product_id_3 + + + + qty_outgoing + + + + product_id_1 + + + + qty_incoming + + + + incoming_plus_onhand + + + + qty_available + + + + product_id_2 + + + + product_max_qty + + + N + + product_max_qty + product_max_qty + Number + -2 + -2 + + false + + + false + + + + + + + + + + + + + + + + + 1088 + 352 + Y + + + + Select values 2 + SelectValues + + N + + 1 + + none + + + + + product_id + + + product_id2 + + N + + + + + + + + + + + 256 + 48 + Y + + + + Select values 3 + SelectValues + + Y + + 1 + + none + + + + + product_id + + + + location_id + + + + qty_onhand + + + + reserved_quantity + + + + item_code + + + + product_name + + + + current_date + history_date + + + qty_outgoing + + + + qty_incoming + + + + qty_available + + + + product_max_qty + + + + plafon_qty + + + N + + product_max_qty + product_max_qty + Number + -2 + -2 + + false + + + false + + + + + + + + plafon_qty + plafon_qty + Number + -2 + -2 + + false + + + false + + + + + + + + + + + + + + + + + 656 + 352 + Y + + + + Sort rows + SortRows + + Y + + 1 + + none + + + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + product_id + Y + N + N + 0 + N + + + + + + + + + + + + 368 + 144 + Y + + + + Sort rows 2 + SortRows + + Y + + 1 + + none + + + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + product_id + Y + N + N + 0 + N + + + + + + + + + + + + 112 + 144 + Y + + + + Sort rows 3 + SortRows + + Y + + 1 + + none + + + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + product_id + Y + N + N + 0 + N + + + + + + + + + + + + 480 + 48 + Y + + + + Sort rows 4 + SortRows + + Y + + 1 + + none + + + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + product_id + Y + N + N + 0 + N + + + + + + + + + + + + 1088 + 144 + Y + + + + available + SelectValues + + Y + + 1 + + none + + + + + product_id + + + + product_id2 + + + + location_id + + + + qty_onhand + + + + reserved_quantity + + + + item_code + + + + product_name + + + + current_date + + + + product_id_3 + + + + qty_outgoing + + + + product_id_1 + + + + qty_incoming + + + + incoming_plus_onhand + + + + qty_available + + + N + + + + + + + + + + + 944 + 256 + Y + + + + max plafon + Calculator + + Y + + 1 + + none + + + Y + + plafon_qty + SUBTRACT + product_max_qty + qty_available + + Number + -1 + -1 + N + + + + + + + + + + + + + + + 800 + 352 + Y + + + + qty incoming + TableInput + + Y + + 1 + + none + + + erp indoteknik production (localhost) + select ? as product_id, get_qty_incoming(?) as qty_incoming + 0 + Select values 2 + Y + Y + N + N + + + String + normal + product_id + 2147483647 + -1 + qty incoming + product_id + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + qty_incoming + -1 + -1 + qty incoming + qty_incoming + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 368 + 48 + Y + + + + qty outgoing + TableInput + + Y + + 1 + + none + + + erp indoteknik production (localhost) + select ? as product_id, get_qty_outgoing(?) as qty_outgoing + 0 + Select values 2 + Y + Y + N + N + + + String + normal + product_id + 2147483647 + -1 + qty outgoing + product_id + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + qty_outgoing + -1 + -1 + qty outgoing + qty_outgoing + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 256 + 144 + Y + + + + reordering + TableInput + + Y + + 1 + + none + + + erp indoteknik production (localhost) + select product_id, product_max_qty from stock_warehouse_orderpoint + 0 + + N + N + N + N + + + Integer + normal + product_id + 9 + 0 + reordering + product_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + product_max_qty + -1 + -1 + reordering + product_max_qty + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 1088 + 48 + Y + + + + select incoming + SelectValues + + Y + + 1 + + none + + + + + product_id + + + qty_incoming + + N + + + + + + + + + + + 656 + 48 + Y + + + + select outgoing + SelectValues + + Y + + 1 + + none + + + + + product_id + product_id_3 + + + qty_outgoing + + N + + + + + + + + + + + 480 + 144 + Y + + + + select stock quant + SelectValues + + Y + + 1 + + none + + + + + product_id + + + + product_id2 + + + + location_id + + + + quantity + + + + reserved_quantity + + + + item_code + + + + product_name + + + + current_date + + + N + + + + + + + + + + + 112 + 256 + Y + + + + stock quant + TableInput + + N + + 1 + + none + + + erp indoteknik production (localhost) + select sq.product_id, sq.product_id as product_id2, sq.location_id, sq.quantity, sq.reserved_quantity, +coalesce(pp.default_code, pt.default_code) as item_code, pt.name as product_name, +now()::timestamp-'7 hours'::interval as current_date +from stock_quant sq +join product_product pp on pp.id = sq.product_id +join product_template pt on pt.id = pp.product_tmpl_id +where sq.location_id = 57 and sq.quantity > 0 +order by sq.product_id + 0 + + N + N + N + N + + + Integer + normal + product_id + 9 + 0 + stock quant + product_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + product_id2 + 9 + 0 + stock quant + product_id2 + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + location_id + 9 + 0 + stock quant + location_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Number + normal + quantity + -1 + -1 + stock quant + quantity + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Number + normal + reserved_quantity + -1 + -1 + stock quant + reserved_quantity + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal + item_code + 2147483647 + -1 + stock quant + item_code + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal + product_name + 2147483647 + -1 + stock quant + product_name + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 112 + 48 + Y + + + + stock+outgoing + SelectValues + + Y + + 1 + + none + + + + + product_id + + + + product_id2 + + + + location_id + + + + quantity + + + + reserved_quantity + + + + item_code + + + + product_name + + + + current_date + + + + product_id_3 + + + + qty_outgoing + + + N + + + + + + + + + + + 656 + 256 + Y + + + + stock+outgoing+incoming + SelectValues + + Y + + 1 + + none + + + + + product_id + + + + product_id2 + + + + location_id + + + + quantity + qty_onhand + + + reserved_quantity + + + + item_code + + + + product_name + + + + current_date + + + + product_id_3 + + + + qty_outgoing + + + + product_id_1 + + + + qty_incoming + + + N + + + + + + + + + + + 784 + 144 + Y + + + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + Y + + public +
stock_quant_history
+ + product_id + product_id + = + + + + product_id + product_id + Y + + + location_id + location_id + Y + + + qty_onhand + qty_onhand + Y + + + reserved_quantity + reserved_quantity + Y + + + item_code + item_code + Y + + + product_name + product_name + Y + + + history_date + history_date + Y + + + qty_outgoing + qty_outgoing + Y + + + qty_incoming + qty_incoming + Y + + + qty_available + qty_available + Y + + + product_max_qty + product_max_qty + Y + + + plafon_qty + plafon_qty + Y + + + + + + + + + + + + 528 + 352 + Y + + + + + + + N + + -- cgit v1.2.3