update_diff_account_move 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 POSTGRESQL Native dw_bi_indoteknik 5703 metabase Encrypted 2be98dfba28d7bf86853c9f58cfc4f889 FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER 5703 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING 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 production Merge join Y dw Merge join Y Merge join Filter rows Y Filter rows Write to log Y Filter rows Select values Y Select values Insert / update Y Insert / update InsertUpdate Y 1 none dw bi indoteknik 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

512 144 Y production TableInput Y 1 none erp indoteknik production (localhost) select am.* from account_move am where 1=1 --and am.write_date > '2025-01-01' and to_char(am.write_date, 'YYYY') = get_now_year() order by am.id --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 production id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal name 2147483647 -1 production name . , none N Y 0 N N N en_US Asia/Bangkok N Date normal date -1 -1 production date . , none N Y 0 N N N en_US Asia/Bangkok N String normal ref 2147483647 -1 production ref . , none N Y 0 N N N en_US Asia/Bangkok N String normal narration 2147483647 -1 production narration . , none N Y 0 N N N en_US Asia/Bangkok N String normal state 2147483647 -1 production state . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal posted_before -1 -1 production posted_before . , none N Y 0 N N N en_US Asia/Bangkok N String normal move_type 2147483647 -1 production move_type . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal to_check -1 -1 production to_check . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal journal_id 9 0 production journal_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal company_id 9 0 production company_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal currency_id 9 0 production currency_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal partner_id 9 0 production partner_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal commercial_partner_id 9 0 production commercial_partner_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_move_sent -1 -1 production is_move_sent . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal partner_bank_id 9 0 production partner_bank_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal payment_reference 2147483647 -1 production payment_reference . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal payment_id 9 0 production payment_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal statement_line_id 9 0 production statement_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_untaxed -1 -1 production amount_untaxed ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_tax -1 -1 production amount_tax ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_total -1 -1 production amount_total ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_residual -1 -1 production 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 production 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 production 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 production 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 production 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 production payment_state . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_cash_basis_rec_id 9 0 production 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 production 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 production auto_post . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal reversed_entry_id 9 0 production reversed_entry_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal fiscal_position_id 9 0 production fiscal_position_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal invoice_user_id 9 0 production invoice_user_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal invoice_date -1 -1 production invoice_date . , none N Y 0 N N N en_US Asia/Bangkok N Date normal invoice_date_due -1 -1 production invoice_date_due . , none N Y 0 N N N en_US Asia/Bangkok N String normal invoice_origin 2147483647 -1 production invoice_origin . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal invoice_payment_term_id 9 0 production 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 production invoice_incoterm_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal qr_code_method 2147483647 -1 production qr_code_method . , none N Y 0 N N N en_US Asia/Bangkok N String normal invoice_source_email 2147483647 -1 production invoice_source_email . , none N Y 0 N N N en_US Asia/Bangkok N String normal invoice_partner_display_name 2147483647 -1 production invoice_partner_display_name . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal invoice_cash_rounding_id 9 0 production 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 production secure_sequence_number ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal inalterable_hash 2147483647 -1 production inalterable_hash . , none N Y 0 N N N en_US Asia/Bangkok N String normal access_token 2147483647 -1 production access_token . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal message_main_attachment_id 9 0 production message_main_attachment_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal sequence_prefix 2147483647 -1 production sequence_prefix . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal sequence_number 9 0 production sequence_number ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal create_uid 9 0 production create_uid ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal create_date 6 -1 production create_date . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal write_uid 9 0 production write_uid ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal write_date 6 -1 production write_date . , none N Y 0 N N N en_US Asia/Bangkok N String normal edi_state 2147483647 -1 production edi_state . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal stock_move_id 9 0 production stock_move_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal team_id 9 0 production team_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal partner_shipping_id 9 0 production partner_shipping_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal campaign_id 9 0 production campaign_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal source_id 9 0 production source_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal medium_id 9 0 production medium_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal preferred_payment_method_id 9 0 production preferred_payment_method_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal has_due -1 -1 production has_due . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_warning -1 -1 production is_warning . , none N Y 0 N N N en_US Asia/Bangkok N String normal recurring_ref 2147483647 -1 production recurring_ref . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal website_id 9 0 production website_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal efaktur_id 9 0 production efaktur_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_efaktur_exported -1 -1 production is_efaktur_exported . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal date_efaktur_exported 6 -1 production date_efaktur_exported . , none N Y 0 N N N en_US Asia/Bangkok N String normal masa_pajak 2147483647 -1 production masa_pajak . , none N Y 0 N N N en_US Asia/Bangkok N String normal tahun_pajak 2147483647 -1 production tahun_pajak . , none N Y 0 N N N en_US Asia/Bangkok N String normal efaktur_masukan 2147483647 -1 production efaktur_masukan . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal period_id 9 0 production period_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal date_send_fp 6 -1 production date_send_fp . , none N Y 0 N N N en_US Asia/Bangkok N String normal last_log_fp 2147483647 -1 production last_log_fp . , none N Y 0 N N N en_US Asia/Bangkok N Date normal date_kirim_tukar_faktur -1 -1 production date_kirim_tukar_faktur . , none N Y 0 N N N en_US Asia/Bangkok N String normal resi_tukar_faktur 2147483647 -1 production resi_tukar_faktur . , none N Y 0 N N N en_US Asia/Bangkok N Date normal date_terima_tukar_faktur -1 -1 production date_terima_tukar_faktur . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal shipper_faktur_id 9 0 production shipper_faktur_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal due_extension 9 0 production due_extension ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal new_due_date -1 -1 production new_due_date . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal counter 9 0 production counter ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal payment_schedule -1 -1 production payment_schedule . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal cost_centre_id 9 0 production cost_centre_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal no_faktur_pajak 2147483647 -1 production no_faktur_pajak . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal date_completed 6 -1 production date_completed . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_customer_commision -1 -1 production is_customer_commision . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal sale_id 9 0 production sale_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal reklas_id 9 0 production reklas_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal date_efaktur_upload 6 -1 production date_efaktur_upload . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal real_invoice_id 9 0 production real_invoice_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal bills_efaktur_exporter 9 0 production bills_efaktur_exporter ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal bills_date_efaktur 6 -1 production bills_date_efaktur . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal bills_invoice_exporter 9 0 production bills_invoice_exporter ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal bills_date_invoice 6 -1 production bills_date_invoice . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_invoice_uploaded -1 -1 production is_invoice_uploaded . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_efaktur_uploaded -1 -1 production is_efaktur_uploaded . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal already_paid -1 -1 production already_paid . , none N Y 0 N N N en_US Asia/Bangkok N String normal nomor_kwitansi 2147483647 -1 production nomor_kwitansi . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_hr -1 -1 production is_hr . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal purchase_order_id 9 0 production purchase_order_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal reklas_misc_id 9 0 production reklas_misc_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal bill_id 9 0 production bill_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal down_payment -1 -1 production down_payment . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal refund_id 9 0 production refund_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal reminder_sent_date -1 -1 production reminder_sent_date . , none N Y 0 N N N en_US Asia/Bangkok N Date normal customer_promise_date -1 -1 production customer_promise_date . , none N Y 0 N N N en_US Asia/Bangkok N

112 48 Y dw TableInput Y 1 none dw bi indoteknik (localhost) select am.* from account_move am where 1=1 --and am.write_date > '2025-01-01' and to_char(am.write_date, 'YYYY') = get_now_year() order by am.id 0 N N N N Integer normal id 9 0 dw id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal name 2147483647 -1 dw name . , none N Y 0 N N N en_US Asia/Bangkok N Date normal date -1 -1 dw date . , none N Y 0 N N N en_US Asia/Bangkok N String normal ref 2147483647 -1 dw ref . , none N Y 0 N N N en_US Asia/Bangkok N String normal narration 2147483647 -1 dw narration . , none N Y 0 N N N en_US Asia/Bangkok N String normal state 2147483647 -1 dw state . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal posted_before -1 -1 dw posted_before . , none N Y 0 N N N en_US Asia/Bangkok N String normal move_type 2147483647 -1 dw move_type . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal to_check -1 -1 dw to_check . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal journal_id 9 0 dw journal_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal company_id 9 0 dw company_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal currency_id 9 0 dw currency_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal partner_id 9 0 dw partner_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal commercial_partner_id 9 0 dw commercial_partner_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_move_sent -1 -1 dw is_move_sent . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal partner_bank_id 9 0 dw partner_bank_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal payment_reference 2147483647 -1 dw payment_reference . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal payment_id 9 0 dw payment_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal statement_line_id 9 0 dw statement_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_untaxed -1 -1 dw amount_untaxed ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_tax -1 -1 dw amount_tax ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_total -1 -1 dw amount_total ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_residual -1 -1 dw 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 dw 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 dw 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 dw 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 dw 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 dw payment_state . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_cash_basis_rec_id 9 0 dw 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 dw 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 dw auto_post . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal reversed_entry_id 9 0 dw reversed_entry_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal fiscal_position_id 9 0 dw fiscal_position_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal invoice_user_id 9 0 dw invoice_user_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal invoice_date -1 -1 dw invoice_date . , none N Y 0 N N N en_US Asia/Bangkok N Date normal invoice_date_due -1 -1 dw invoice_date_due . , none N Y 0 N N N en_US Asia/Bangkok N String normal invoice_origin 2147483647 -1 dw invoice_origin . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal invoice_payment_term_id 9 0 dw 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 dw invoice_incoterm_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal qr_code_method 2147483647 -1 dw qr_code_method . , none N Y 0 N N N en_US Asia/Bangkok N String normal invoice_source_email 2147483647 -1 dw invoice_source_email . , none N Y 0 N N N en_US Asia/Bangkok N String normal invoice_partner_display_name 2147483647 -1 dw invoice_partner_display_name . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal invoice_cash_rounding_id 9 0 dw 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 dw secure_sequence_number ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal inalterable_hash 2147483647 -1 dw inalterable_hash . , none N Y 0 N N N en_US Asia/Bangkok N String normal access_token 2147483647 -1 dw access_token . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal message_main_attachment_id 9 0 dw message_main_attachment_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal sequence_prefix 2147483647 -1 dw sequence_prefix . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal sequence_number 9 0 dw sequence_number ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal create_uid 9 0 dw create_uid ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal create_date 6 -1 dw create_date . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal write_uid 9 0 dw write_uid ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal write_date 6 -1 dw write_date . , none N Y 0 N N N en_US Asia/Bangkok N String normal edi_state 2147483647 -1 dw edi_state . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal stock_move_id 9 0 dw stock_move_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal team_id 9 0 dw team_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal partner_shipping_id 9 0 dw partner_shipping_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal campaign_id 9 0 dw campaign_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal source_id 9 0 dw source_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal medium_id 9 0 dw medium_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal preferred_payment_method_id 9 0 dw preferred_payment_method_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal has_due -1 -1 dw has_due . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_warning -1 -1 dw is_warning . , none N Y 0 N N N en_US Asia/Bangkok N String normal recurring_ref 2147483647 -1 dw recurring_ref . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal website_id 9 0 dw website_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal efaktur_id 9 0 dw efaktur_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_efaktur_exported -1 -1 dw is_efaktur_exported . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal date_efaktur_exported 6 -1 dw date_efaktur_exported . , none N Y 0 N N N en_US Asia/Bangkok N String normal masa_pajak 2147483647 -1 dw masa_pajak . , none N Y 0 N N N en_US Asia/Bangkok N String normal tahun_pajak 2147483647 -1 dw tahun_pajak . , none N Y 0 N N N en_US Asia/Bangkok N String normal efaktur_masukan 2147483647 -1 dw efaktur_masukan . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal period_id 9 0 dw period_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal date_send_fp 6 -1 dw date_send_fp . , none N Y 0 N N N en_US Asia/Bangkok N String normal last_log_fp 2147483647 -1 dw last_log_fp . , none N Y 0 N N N en_US Asia/Bangkok N Date normal date_kirim_tukar_faktur -1 -1 dw date_kirim_tukar_faktur . , none N Y 0 N N N en_US Asia/Bangkok N String normal resi_tukar_faktur 2147483647 -1 dw resi_tukar_faktur . , none N Y 0 N N N en_US Asia/Bangkok N Date normal date_terima_tukar_faktur -1 -1 dw date_terima_tukar_faktur . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal shipper_faktur_id 9 0 dw shipper_faktur_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal due_extension 9 0 dw due_extension ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal new_due_date -1 -1 dw new_due_date . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal counter 9 0 dw counter ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal payment_schedule -1 -1 dw payment_schedule . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal cost_centre_id 9 0 dw cost_centre_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal no_faktur_pajak 2147483647 -1 dw no_faktur_pajak . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal date_completed 6 -1 dw date_completed . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal date_efaktur_upload 6 -1 dw date_efaktur_upload . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_customer_commision -1 -1 dw is_customer_commision . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal sale_id 9 0 dw sale_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal reklas_id 9 0 dw reklas_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal real_invoice_id 9 0 dw real_invoice_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal bills_efaktur_exporter 9 0 dw bills_efaktur_exporter ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal bills_date_efaktur 6 -1 dw bills_date_efaktur . , none N Y 0 N N N en_US Asia/Bangkok N Timestamp normal bills_date_invoice 6 -1 dw bills_date_invoice . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal bills_invoice_exporter 9 0 dw bills_invoice_exporter ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_invoice_uploaded -1 -1 dw is_invoice_uploaded . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_efaktur_uploaded -1 -1 dw is_efaktur_uploaded . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal already_paid -1 -1 dw already_paid . , none N Y 0 N N N en_US Asia/Bangkok N String normal nomor_kwitansi 2147483647 -1 dw nomor_kwitansi . , none N Y 0 N N N en_US Asia/Bangkok N

112 256 Y Merge join MergeJoin Y 1 none LEFT OUTER production dw id id

112 144 Y Filter rows FilterRows Y 1 none Select values Write to log N amount_total_signed <> amount_total_signed

256 144 Y Write to log WriteToLog Y 1 none log_level_basic Y N 0

256 256 Y Select values SelectValues Y 1 none id name date ref narration state posted_before move_type to_check journal_id company_id currency_id partner_id commercial_partner_id is_move_sent partner_bank_id payment_reference payment_id statement_line_id amount_untaxed amount_tax amount_total amount_residual amount_untaxed_signed amount_tax_signed amount_total_signed amount_residual_signed payment_state tax_cash_basis_rec_id tax_cash_basis_move_id auto_post reversed_entry_id fiscal_position_id invoice_user_id invoice_date invoice_date_due invoice_origin invoice_payment_term_id invoice_incoterm_id qr_code_method invoice_source_email invoice_partner_display_name invoice_cash_rounding_id secure_sequence_number inalterable_hash access_token message_main_attachment_id sequence_prefix sequence_number create_uid create_date write_uid write_date edi_state stock_move_id team_id partner_shipping_id campaign_id source_id medium_id preferred_payment_method_id has_due is_warning recurring_ref website_id efaktur_id is_efaktur_exported date_efaktur_exported masa_pajak tahun_pajak efaktur_masukan period_id date_send_fp last_log_fp date_kirim_tukar_faktur resi_tukar_faktur date_terima_tukar_faktur shipper_faktur_id due_extension new_due_date counter payment_schedule cost_centre_id no_faktur_pajak date_completed is_customer_commision sale_id reklas_id date_efaktur_upload real_invoice_id bills_efaktur_exporter bills_date_efaktur bills_invoice_exporter bills_date_invoice is_invoice_uploaded is_efaktur_uploaded already_paid nomor_kwitansi is_hr purchase_order_id reklas_misc_id bill_id down_payment refund_id reminder_sent_date customer_promise_date N

384 144 Y N