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 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 erp indoteknik production localhost POSTGRESQL Native erp_indoteknik 5901 odoo Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER 5901 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y 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 select am.* from account_move am where 1=1 and am.write_date > '2025-01-01' 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 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

String normal no_faktur_pajak 2147483647 -1 Table input no_faktur_pajak . , none N Y 0 N N N en_US Asia/Bangkok N

Timestamp normal date_completed 6 -1 Table input date_completed . , none N Y 0 N N N en_US Asia/Bangkok N

Boolean normal is_customer_commision -1 -1 Table input is_customer_commision . , none N Y 0 N N N en_US Asia/Bangkok N

Integer normal sale_id 9 0 Table input sale_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N

Integer normal reklas_id 9 0 Table input reklas_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N

Timestamp normal date_efaktur_upload 6 -1 Table input date_efaktur_upload . , none N Y 0 N N N en_US Asia/Bangkok N

Integer normal real_invoice_id 9 0 Table input real_invoice_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N

Integer normal bills_efaktur_exporter 9 0 Table input bills_efaktur_exporter ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N

Timestamp normal bills_date_efaktur 6 -1 Table input bills_date_efaktur . , none N Y 0 N N N en_US Asia/Bangkok N

Integer normal bills_invoice_exporter 9 0 Table input bills_invoice_exporter ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N

Timestamp normal bills_date_invoice 6 -1 Table input bills_date_invoice . , none N Y 0 N N N en_US Asia/Bangkok N

Boolean normal is_invoice_uploaded -1 -1 Table input is_invoice_uploaded . , none N Y 0 N N N en_US Asia/Bangkok N

Boolean normal is_efaktur_uploaded -1 -1 Table input is_efaktur_uploaded . , none N Y 0 N N N en_US Asia/Bangkok N

Boolean normal already_paid -1 -1 Table input already_paid . , none N Y 0 N N N en_US Asia/Bangkok N

String normal nomor_kwitansi 2147483647 -1 Table input nomor_kwitansi . , none N Y 0 N N N en_US Asia/Bangkok N

Boolean normal is_hr -1 -1 Table input is_hr . , none N Y 0 N N N en_US Asia/Bangkok N

Integer normal purchase_order_id 9 0 Table input purchase_order_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N

Integer normal reklas_misc_id 9 0 Table input reklas_misc_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N

Integer normal bill_id 9 0 Table input bill_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N

Boolean normal down_payment -1 -1 Table input down_payment . , none N Y 0 N N N en_US Asia/Bangkok N

Integer normal refund_id 9 0 Table input refund_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N

Date normal reminder_sent_date -1 -1 Table input reminder_sent_date . , none N Y 0 N N N en_US Asia/Bangkok N

Date normal customer_promise_date -1 -1 Table input 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 select am.* from account_move am where 1=1 and am.write_date > '2025-01-01' order by am.id 0 N N N N