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 Insert / update InsertUpdate Y 1 none dw bi indoteknik (localhost) 100 Y public stock_quant_history history_date history_date = 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 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 N