import_account_move_onetime Normal 0 / 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/09/25 16:36:39.046 - 2023/09/25 16:36:39.046 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 account_move id id = id id N name name Y date date Y ref ref Y narration narration Y state state Y posted_before posted_before Y move_type move_type Y to_check to_check Y journal_id journal_id Y company_id company_id Y currency_id currency_id Y partner_id partner_id Y commercial_partner_id commercial_partner_id Y is_move_sent is_move_sent Y partner_bank_id partner_bank_id Y payment_reference payment_reference Y payment_id payment_id Y statement_line_id statement_line_id Y amount_untaxed amount_untaxed Y amount_tax amount_tax Y amount_total amount_total Y amount_residual amount_residual Y amount_untaxed_signed amount_untaxed_signed Y amount_tax_signed amount_tax_signed Y amount_total_signed amount_total_signed Y amount_residual_signed amount_residual_signed Y payment_state payment_state Y tax_cash_basis_rec_id tax_cash_basis_rec_id Y tax_cash_basis_move_id tax_cash_basis_move_id Y auto_post auto_post Y reversed_entry_id reversed_entry_id Y fiscal_position_id fiscal_position_id Y invoice_user_id invoice_user_id Y invoice_date invoice_date Y invoice_date_due invoice_date_due Y invoice_origin invoice_origin Y invoice_payment_term_id invoice_payment_term_id Y invoice_incoterm_id invoice_incoterm_id Y qr_code_method qr_code_method Y invoice_source_email invoice_source_email Y invoice_partner_display_name invoice_partner_display_name Y invoice_cash_rounding_id invoice_cash_rounding_id Y secure_sequence_number secure_sequence_number Y inalterable_hash inalterable_hash Y access_token access_token Y message_main_attachment_id message_main_attachment_id Y sequence_prefix sequence_prefix Y sequence_number sequence_number Y create_uid create_uid Y create_date create_date Y write_uid write_uid Y write_date write_date Y edi_state edi_state Y stock_move_id stock_move_id Y team_id team_id Y partner_shipping_id partner_shipping_id Y campaign_id campaign_id Y source_id source_id Y medium_id medium_id Y preferred_payment_method_id preferred_payment_method_id Y has_due has_due Y is_warning is_warning Y recurring_ref recurring_ref Y website_id website_id Y efaktur_id efaktur_id Y is_efaktur_exported is_efaktur_exported Y date_efaktur_exported date_efaktur_exported Y masa_pajak masa_pajak Y tahun_pajak tahun_pajak Y efaktur_masukan efaktur_masukan Y period_id period_id Y date_send_fp date_send_fp Y last_log_fp last_log_fp Y date_kirim_tukar_faktur date_kirim_tukar_faktur Y resi_tukar_faktur resi_tukar_faktur Y date_terima_tukar_faktur date_terima_tukar_faktur Y shipper_faktur_id shipper_faktur_id Y due_extension due_extension Y new_due_date new_due_date Y counter counter Y payment_schedule payment_schedule Y cost_centre_id cost_centre_id Y date_completed date_completed Y date_efaktur_upload date_efaktur_upload Y

256 48 Y Table input TableInput Y 1 none erp indoteknik production (localhost) select am.* from account_move am where 1=1 and am.write_date between '2024-06-01' and '2024-06-30' --and to_char(am.date, 'YYYY') = '2023' --and (am.move_type = 'out_invoice' or journal_id = 3) --and am.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 Date normal date -1 -1 Table input date . , none N Y 0 N N N en_US Asia/Bangkok N String normal ref 2147483647 -1 Table input ref . , none N Y 0 N N N en_US Asia/Bangkok N String normal narration 2147483647 -1 Table input narration . , 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 Boolean normal posted_before -1 -1 Table input posted_before . , none N Y 0 N N N en_US Asia/Bangkok N String normal move_type 2147483647 -1 Table input move_type . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal to_check -1 -1 Table input to_check . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal journal_id 9 0 Table input journal_id ####0;-####0 . , 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 currency_id 9 0 Table input currency_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 commercial_partner_id 9 0 Table input commercial_partner_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_move_sent -1 -1 Table input is_move_sent . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal partner_bank_id 9 0 Table input partner_bank_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal payment_reference 2147483647 -1 Table input payment_reference . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal payment_id 9 0 Table input payment_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal statement_line_id 9 0 Table input statement_line_id ####0;-####0 . , none N Y 0 N N N en_US 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_US 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_US 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_US Asia/Bangkok N BigNumber normal amount_residual -1 -1 Table input amount_residual ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_untaxed_signed -1 -1 Table input amount_untaxed_signed ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_tax_signed -1 -1 Table input amount_tax_signed ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_total_signed -1 -1 Table input amount_total_signed ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_residual_signed -1 -1 Table input amount_residual_signed ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N String normal payment_state 2147483647 -1 Table input payment_state . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_cash_basis_rec_id 9 0 Table input tax_cash_basis_rec_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_cash_basis_move_id 9 0 Table input tax_cash_basis_move_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal auto_post -1 -1 Table input auto_post . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal reversed_entry_id 9 0 Table input reversed_entry_id ####0;-####0 . , none N Y 0 N N N en_US 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_US Asia/Bangkok N Integer normal invoice_user_id 9 0 Table input invoice_user_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal invoice_date -1 -1 Table input invoice_date . , none N Y 0 N N N en_US Asia/Bangkok N Date normal invoice_date_due -1 -1 Table input invoice_date_due . , none N Y 0 N N N en_US Asia/Bangkok N String normal invoice_origin 2147483647 -1 Table input invoice_origin . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal invoice_payment_term_id 9 0 Table input invoice_payment_term_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal invoice_incoterm_id 9 0 Table input invoice_incoterm_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal qr_code_method 2147483647 -1 Table input qr_code_method . , none N Y 0 N N N en_US Asia/Bangkok N String normal invoice_source_email 2147483647 -1 Table input invoice_source_email . , none N Y 0 N N N en_US Asia/Bangkok N String normal invoice_partner_display_name 2147483647 -1 Table input invoice_partner_display_name . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal invoice_cash_rounding_id 9 0 Table input invoice_cash_rounding_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal secure_sequence_number 9 0 Table input secure_sequence_number ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal inalterable_hash 2147483647 -1 Table input inalterable_hash . , none N Y 0 N N N en_US Asia/Bangkok N String normal access_token 2147483647 -1 Table input access_token . , none N Y 0 N N N en_US 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_US Asia/Bangkok N String normal sequence_prefix 2147483647 -1 Table input sequence_prefix . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal sequence_number 9 0 Table input sequence_number ####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 Timestamp normal create_date 6 -1 Table input create_date . , 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 String normal edi_state 2147483647 -1 Table input edi_state . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal stock_move_id 9 0 Table input stock_move_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal team_id 9 0 Table input team_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal partner_shipping_id 9 0 Table input partner_shipping_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal campaign_id 9 0 Table input campaign_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal source_id 9 0 Table input source_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal medium_id 9 0 Table input medium_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal preferred_payment_method_id 9 0 Table input preferred_payment_method_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal has_due -1 -1 Table input has_due . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_warning -1 -1 Table input is_warning . , none N Y 0 N N N en_US Asia/Bangkok N String normal recurring_ref 2147483647 -1 Table input recurring_ref . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal website_id 9 0 Table input website_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal efaktur_id 9 0 Table input efaktur_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_efaktur_exported -1 -1 Table input is_efaktur_exported . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal date_efaktur_exported 6 -1 Table input date_efaktur_exported . , none N Y 0 N N N en_US Asia/Bangkok N String normal masa_pajak 2147483647 -1 Table input masa_pajak . , none N Y 0 N N N en_US Asia/Bangkok N String normal tahun_pajak 2147483647 -1 Table input tahun_pajak . , none N Y 0 N N N en_US Asia/Bangkok N String normal efaktur_masukan 2147483647 -1 Table input efaktur_masukan . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal period_id 9 0 Table input period_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal date_send_fp 6 -1 Table input date_send_fp . , none N Y 0 N N N en_US Asia/Bangkok N String normal last_log_fp 2147483647 -1 Table input last_log_fp . , none N Y 0 N N N en_US Asia/Bangkok N Date normal date_kirim_tukar_faktur -1 -1 Table input date_kirim_tukar_faktur . , none N Y 0 N N N en_US Asia/Bangkok N String normal resi_tukar_faktur 2147483647 -1 Table input resi_tukar_faktur . , none N Y 0 N N N en_US Asia/Bangkok N Date normal date_terima_tukar_faktur -1 -1 Table input date_terima_tukar_faktur . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal shipper_faktur_id 9 0 Table input shipper_faktur_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal due_extension 9 0 Table input due_extension ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal new_due_date -1 -1 Table input new_due_date . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal counter 9 0 Table input counter ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal payment_schedule -1 -1 Table input payment_schedule . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal cost_centre_id 9 0 Table input cost_centre_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N

112 48 Y N