import_purchase_order_v2 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 - 2024/06/11 11:58:56.696 - 2024/06/11 11:58:56.696 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 2 Insert / update 2 Y Table input TableInput Y 1 none erp indoteknik production (localhost) select * from purchase_order po where po.write_date >= (now() - '3 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_ID Asia/Bangkok N String normal access_token 2147483647 -1 Table input access_token . , 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 priority 2147483647 -1 Table input priority . , 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 partner_ref 2147483647 -1 Table input partner_ref . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_order 6 -1 Table input date_order . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_approve 6 -1 Table input date_approve . , 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 dest_address_id 9 0 Table input dest_address_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal currency_id 9 0 Table input currency_id ####0;-####0 . , 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 String normal notes 2147483647 -1 Table input notes . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal invoice_count 9 0 Table input invoice_count ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal invoice_status 2147483647 -1 Table input invoice_status . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_planned 6 -1 Table input date_planned . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_calendar_start 6 -1 Table input date_calendar_start . , none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal amount_untaxed -1 -1 Table input amount_untaxed ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal amount_tax -1 -1 Table input amount_tax ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal amount_total -1 -1 Table input amount_total ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N Integer normal fiscal_position_id 9 0 Table input fiscal_position_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal payment_term_id 9 0 Table input payment_term_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal incoterm_id 9 0 Table input incoterm_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 company_id 9 0 Table input company_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Number normal currency_rate -1 -1 Table input currency_rate ####0.0#########;-####0.0######### . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal mail_reminder_confirmed -1 -1 Table input mail_reminder_confirmed . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal mail_reception_confirmed -1 -1 Table input mail_reception_confirmed . , 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 picking_count 9 0 Table input picking_count ####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 group_id 9 0 Table input group_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal effective_date 6 -1 Table input effective_date . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal sale_order_id 9 0 Table input sale_order_id ####0;-####0 . , 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 String normal po_status 2147483647 -1 Table input po_status . , none N Y 0 N N N en_ID Asia/Bangkok N String normal note_description 2147483647 -1 Table input note_description . , none N Y 0 N N N en_ID Asia/Bangkok N String normal description 2147483647 -1 Table input description . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal status_paid_cbd -1 -1 Table input status_paid_cbd . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal revisi_po -1 -1 Table input revisi_po . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal from_apo -1 -1 Table input from_apo . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal approval_edit_line -1 -1 Table input approval_edit_line . , 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

368 96 Y Table input 2 TableInput Y 1 none erp indoteknik production (localhost) select * from purchase_order_line po where po.write_date >= (now() - '3 days'::interval) 0 N N N N Integer normal id 9 0 Table input 2 id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal name 2147483647 -1 Table input 2 name . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal sequence 9 0 Table input 2 sequence ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal product_qty -1 -1 Table input 2 product_qty ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N Number normal product_uom_qty -1 -1 Table input 2 product_uom_qty ####0.0#########;-####0.0######### . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_planned 6 -1 Table input 2 date_planned . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal product_uom 9 0 Table input 2 product_uom ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal product_id 9 0 Table input 2 product_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal price_unit -1 -1 Table input 2 price_unit ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal price_subtotal -1 -1 Table input 2 price_subtotal ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal price_total -1 -1 Table input 2 price_total ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N Number normal price_tax -1 -1 Table input 2 price_tax ####0.0#########;-####0.0######### . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal order_id 9 0 Table input 2 order_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal account_analytic_id 9 0 Table input 2 account_analytic_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal company_id 9 0 Table input 2 company_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal state 2147483647 -1 Table input 2 state . , none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal qty_invoiced -1 -1 Table input 2 qty_invoiced ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N String normal qty_received_method 2147483647 -1 Table input 2 qty_received_method . , none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal qty_received -1 -1 Table input 2 qty_received ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal qty_received_manual -1 -1 Table input 2 qty_received_manual ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal qty_to_invoice -1 -1 Table input 2 qty_to_invoice ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N Integer normal partner_id 9 0 Table input 2 partner_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal currency_id 9 0 Table input 2 currency_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal display_type 2147483647 -1 Table input 2 display_type . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal create_uid 9 0 Table input 2 create_uid ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal create_date 6 -1 Table input 2 create_date . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal write_uid 9 0 Table input 2 write_uid ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal write_date 6 -1 Table input 2 write_date . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal orderpoint_id 9 0 Table input 2 orderpoint_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal product_description_variants 2147483647 -1 Table input 2 product_description_variants . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal propagate_cancel -1 -1 Table input 2 propagate_cancel . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal sale_order_id 9 0 Table input 2 sale_order_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal sale_line_id 9 0 Table input 2 sale_line_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal line_no 9 0 Table input 2 line_no ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Number normal qty_available_store -1 -1 Table input 2 qty_available_store ####0.0#########;-####0.0######### . , none N Y 0 N N N en_ID Asia/Bangkok N String normal suggest 2147483647 -1 Table input 2 suggest . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal so_line_id 9 0 Table input 2 so_line_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal indent -1 -1 Table input 2 indent . , none N Y 0 N N N en_ID Asia/Bangkok N String normal note 2147483647 -1 Table input 2 note . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal is_ltc -1 -1 Table input 2 is_ltc . , none N Y 0 N N N en_ID Asia/Bangkok N Boolean normal delete_line -1 -1 Table input 2 delete_line . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal sale_automatic_id 9 0 Table input 2 sale_automatic_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal so_id 9 0 Table input 2 so_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N

368 224 Y Insert / update InsertUpdate Y 1 none dw bi indoteknik (localhost) 100 N public purchase_order id id = id id N access_token access_token Y name name Y priority priority Y origin origin Y partner_ref partner_ref Y date_order date_order Y date_approve date_approve Y partner_id partner_id Y dest_address_id dest_address_id Y currency_id currency_id Y state state Y notes notes Y invoice_count invoice_count Y invoice_status invoice_status Y date_planned date_planned Y date_calendar_start date_calendar_start Y amount_untaxed amount_untaxed Y amount_tax amount_tax Y amount_total amount_total Y fiscal_position_id fiscal_position_id Y payment_term_id payment_term_id Y incoterm_id incoterm_id Y user_id user_id Y company_id company_id Y currency_rate currency_rate Y mail_reminder_confirmed mail_reminder_confirmed Y mail_reception_confirmed mail_reception_confirmed 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 picking_count picking_count Y picking_type_id picking_type_id Y group_id group_id Y effective_date effective_date Y sale_order_id sale_order_id Y approval_status approval_status Y po_status po_status Y note_description note_description Y description description Y status_paid_cbd status_paid_cbd Y revisi_po revisi_po Y from_apo from_apo Y approval_edit_line approval_edit_line Y sale_order sale_order Y

560 96 Y Insert / update 2 InsertUpdate Y 1 none dw bi indoteknik (localhost) 100 N public purchase_order_line id id = id id N name name Y sequence sequence Y product_qty product_qty Y product_uom_qty product_uom_qty Y date_planned date_planned Y product_uom product_uom Y product_id product_id Y price_unit price_unit Y price_subtotal price_subtotal Y price_total price_total Y price_tax price_tax Y order_id order_id Y account_analytic_id account_analytic_id Y company_id company_id Y state state Y qty_invoiced qty_invoiced Y qty_received_method qty_received_method Y qty_received qty_received Y qty_received_manual qty_received_manual Y qty_to_invoice qty_to_invoice Y partner_id partner_id Y currency_id currency_id Y display_type display_type Y create_uid create_uid Y create_date create_date Y write_uid write_uid Y write_date write_date Y orderpoint_id orderpoint_id Y product_description_variants product_description_variants Y propagate_cancel propagate_cancel Y sale_order_id sale_order_id Y sale_line_id sale_line_id Y line_no line_no Y qty_available_store qty_available_store Y suggest suggest Y so_line_id so_line_id Y indent indent Y note note Y is_ltc is_ltc Y delete_line delete_line Y sale_automatic_id sale_automatic_id Y so_id so_id Y

560 224 Y N