import_stock_move 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 - 2023/10/20 10:04:27.949 - 2023/10/20 10:04:27.949 N dw bi indoteknik (localhost) localhost POSTGRESQL Native dw_bi_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 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 Table input Insert / update Y Table input TableInput Y 1 none erp indoteknik production (localhost) select * from stock_move where write_date >= (now() - '5 days'::interval) 0 N N N N Integer normal id 9 0 Table input id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal name 2147483647 -1 Table input name . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal sequence 9 0 Table input sequence ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal priority 2147483647 -1 Table input priority . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal create_date 6 -1 Table input create_date . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal date 6 -1 Table input date . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal date_deadline 6 -1 Table input date_deadline . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal company_id 9 0 Table input company_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal product_id 9 0 Table input product_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal description_picking 2147483647 -1 Table input description_picking . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal product_qty -1 -1 Table input product_qty ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal product_uom_qty -1 -1 Table input product_uom_qty ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N Integer normal product_uom 9 0 Table input product_uom ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal location_id 9 0 Table input location_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal location_dest_id 9 0 Table input location_dest_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal partner_id 9 0 Table input partner_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal picking_id 9 0 Table input picking_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal note 2147483647 -1 Table input note . , none N Y 0 N N N en_US Asia/Bangkok N String normal state 2147483647 -1 Table input state . , none N Y 0 N N N en_US Asia/Bangkok N Number normal price_unit -1 -1 Table input price_unit ####0.0#########;-####0.0######### . , none N Y 0 N N N en_US Asia/Bangkok N String normal origin 2147483647 -1 Table input origin . , none N Y 0 N N N en_US Asia/Bangkok N String normal procure_method 2147483647 -1 Table input procure_method . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal scrapped -1 -1 Table input scrapped . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal group_id 9 0 Table input group_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal rule_id 9 0 Table input rule_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal propagate_cancel -1 -1 Table input propagate_cancel . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal delay_alert_date 6 -1 Table input delay_alert_date . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal picking_type_id 9 0 Table input picking_type_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal inventory_id 9 0 Table input inventory_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal origin_returned_move_id 9 0 Table input origin_returned_move_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal restrict_partner_id 9 0 Table input restrict_partner_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal warehouse_id 9 0 Table input warehouse_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal additional -1 -1 Table input additional . , none N Y 0 N N N en_US Asia/Bangkok N String normal reference 2147483647 -1 Table input reference . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal package_level_id 9 0 Table input package_level_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal next_serial 2147483647 -1 Table input next_serial . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal next_serial_count 9 0 Table input next_serial_count ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal orderpoint_id 9 0 Table input orderpoint_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal create_uid 9 0 Table input create_uid ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal write_uid 9 0 Table input write_uid ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal write_date 6 -1 Table input write_date . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal to_refund -1 -1 Table input to_refund . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal sale_line_id 9 0 Table input sale_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal purchase_line_id 9 0 Table input purchase_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal created_purchase_line_id 9 0 Table input created_purchase_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal weight -1 -1 Table input weight ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N Integer normal line_no 9 0 Table input line_no ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_done -1 -1 Table input is_done . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal created_production_id 9 0 Table input created_production_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal production_id 9 0 Table input production_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal raw_material_production_id 9 0 Table input raw_material_production_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal unbuild_id 9 0 Table input unbuild_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal consume_unbuild_id 9 0 Table input consume_unbuild_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal operation_id 9 0 Table input operation_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal workorder_id 9 0 Table input workorder_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal bom_line_id 9 0 Table input bom_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal byproduct_id 9 0 Table input byproduct_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Number normal unit_factor -1 -1 Table input unit_factor ####0.0#########;-####0.0######### . , none N Y 0 N N N en_US Asia/Bangkok N

160 64 Y Insert / update InsertUpdate Y 1 none dw bi indoteknik (localhost) 100 N public stock_move id id = id id N name name Y sequence sequence Y priority priority Y create_date create_date Y date date Y date_deadline date_deadline Y company_id company_id Y product_id product_id Y description_picking description_picking Y product_qty product_qty Y product_uom_qty product_uom_qty Y product_uom product_uom Y location_id location_id Y location_dest_id location_dest_id Y partner_id partner_id Y picking_id picking_id Y note note Y state state Y price_unit price_unit Y origin origin Y procure_method procure_method Y scrapped scrapped Y group_id group_id Y rule_id rule_id Y propagate_cancel propagate_cancel Y delay_alert_date delay_alert_date Y picking_type_id picking_type_id Y inventory_id inventory_id Y origin_returned_move_id origin_returned_move_id Y restrict_partner_id restrict_partner_id Y warehouse_id warehouse_id Y additional additional Y reference reference Y package_level_id package_level_id Y next_serial next_serial Y next_serial_count next_serial_count Y orderpoint_id orderpoint_id Y create_uid create_uid Y write_uid write_uid Y write_date write_date Y to_refund to_refund Y sale_line_id sale_line_id Y purchase_line_id purchase_line_id Y created_purchase_line_id created_purchase_line_id Y weight weight Y line_no line_no Y is_done is_done Y created_production_id created_production_id Y production_id production_id Y raw_material_production_id raw_material_production_id Y unbuild_id unbuild_id Y consume_unbuild_id consume_unbuild_id Y operation_id operation_id Y workorder_id workorder_id Y bom_line_id bom_line_id Y byproduct_id byproduct_id Y unit_factor unit_factor Y

304 64 Y N