import_stock_picking 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 09:58:08.186 - 2023/10/20 09:58:08.186 H4sIAAAAAAAAAAMAAAAAAAAAAAA= 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 Insert / update InsertUpdate Y 1 none dw bi indoteknik (localhost) 100 N public stock_picking id id = id id N name name Y origin origin Y note note Y backorder_id backorder_id Y move_type move_type Y state state Y group_id group_id Y priority priority Y scheduled_date scheduled_date Y date_deadline date_deadline Y has_deadline_issue has_deadline_issue Y date date Y date_done date_done Y location_id location_id Y location_dest_id location_dest_id Y picking_type_id picking_type_id Y partner_id partner_id Y company_id company_id Y user_id user_id Y owner_id owner_id Y printed printed Y is_locked is_locked Y immediate_transfer immediate_transfer Y message_main_attachment_id message_main_attachment_id Y create_uid create_uid Y create_date create_date Y write_uid write_uid Y write_date write_date Y sale_id sale_id Y website_id website_id Y carrier_price carrier_price Y carrier_id carrier_id Y weight weight Y carrier_tracking_ref carrier_tracking_ref Y is_internal_use is_internal_use Y account_id account_id Y efaktur_id efaktur_id Y is_efaktur_exported is_efaktur_exported Y date_efaktur_exported date_efaktur_exported Y driver_departure_date driver_departure_date Y driver_arrival_date driver_arrival_date Y delivery_tracking_no delivery_tracking_no Y driver_id driver_id Y picking_code picking_code Y approval_status approval_status Y real_shipping_id real_shipping_id Y approval_return_status approval_return_status Y date_doc_kirim date_doc_kirim Y note_logistic note_logistic Y approval_receipt_status approval_receipt_status Y date_reserved date_reserved Y arrival_time arrival_time Y

360 64 Y Table input TableInput Y 1 none erp indoteknik production (localhost) select * from stock_picking where 1=1 and write_date >= (now() - '3 days'::interval) --and arrival_time is not null 0 N N N N Integer normal id 9 0 Table input id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal name 2147483647 -1 Table input name . , none N Y 0 N N N en_ID Asia/Bangkok N String normal origin 2147483647 -1 Table input origin . , none N Y 0 N N N en_ID Asia/Bangkok N String normal note 2147483647 -1 Table input note . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal backorder_id 9 0 Table input backorder_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal move_type 2147483647 -1 Table input move_type . , none N Y 0 N N N en_ID Asia/Bangkok N String normal state 2147483647 -1 Table input state . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal group_id 9 0 Table input group_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal priority 2147483647 -1 Table input priority . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal scheduled_date 6 -1 Table input scheduled_date . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_deadline 6 -1 Table input date_deadline . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal has_deadline_issue -1 -1 Table input has_deadline_issue . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date 6 -1 Table input date . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_done 6 -1 Table input date_done . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal location_id 9 0 Table input location_id ####0;-####0 . , none N Y 0 N N N en_ID 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_ID 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_ID Asia/Bangkok N Integer normal partner_id 9 0 Table input partner_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal company_id 9 0 Table input company_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal user_id 9 0 Table input user_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal owner_id 9 0 Table input owner_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal printed -1 -1 Table input printed . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal is_locked -1 -1 Table input is_locked . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal immediate_transfer -1 -1 Table input immediate_transfer . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal message_main_attachment_id 9 0 Table input message_main_attachment_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal create_uid 9 0 Table input create_uid ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal create_date 6 -1 Table input create_date . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal write_uid 9 0 Table input write_uid ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal write_date 6 -1 Table input write_date . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal sale_id 9 0 Table input sale_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal website_id 9 0 Table input website_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Number normal carrier_price -1 -1 Table input carrier_price ####0.0#########;-####0.0######### . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal carrier_id 9 0 Table input carrier_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal weight -1 -1 Table input weight ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N String normal carrier_tracking_ref 2147483647 -1 Table input carrier_tracking_ref . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal is_internal_use -1 -1 Table input is_internal_use . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal account_id 9 0 Table input account_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal efaktur_id 9 0 Table input efaktur_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal is_efaktur_exported -1 -1 Table input is_efaktur_exported . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_efaktur_exported 6 -1 Table input date_efaktur_exported . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal driver_departure_date 6 -1 Table input driver_departure_date . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal driver_arrival_date 6 -1 Table input driver_arrival_date . , none N Y 0 N N N en_ID Asia/Bangkok N String normal delivery_tracking_no 2147483647 -1 Table input delivery_tracking_no . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal driver_id 9 0 Table input driver_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal picking_code 2147483647 -1 Table input picking_code . , none N Y 0 N N N en_ID Asia/Bangkok N String normal approval_status 2147483647 -1 Table input approval_status . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal real_shipping_id 9 0 Table input real_shipping_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal approval_return_status 2147483647 -1 Table input approval_return_status . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_doc_kirim 6 -1 Table input date_doc_kirim . , none N Y 0 N N N en_ID Asia/Bangkok N String normal note_logistic 2147483647 -1 Table input note_logistic . , none N Y 0 N N N en_ID Asia/Bangkok N String normal approval_receipt_status 2147483647 -1 Table input approval_receipt_status . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_reserved 6 -1 Table input date_reserved . , none N Y 0 N N N en_ID Asia/Bangkok N String normal status_printed 2147483647 -1 Table input status_printed . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_unreserve 6 -1 Table input date_unreserve . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_availability 6 -1 Table input date_availability . , none N Y 0 N N N en_ID Asia/Bangkok N String normal sale_order 2147483647 -1 Table input sale_order . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_printed_sj 6 -1 Table input date_printed_sj . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_printed_list 6 -1 Table input date_printed_list . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal printed_sj -1 -1 Table input printed_sj . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal arrival_time 6 -1 Table input arrival_time . , none N Y 0 N N N en_ID Asia/Bangkok N

160 64 Y N