import_account_move_line_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 17:01:19.768 - 2023/09/25 17:01:19.768 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_line id id = id id N move_id move_id Y move_name move_name Y date date Y ref ref Y parent_state parent_state Y journal_id journal_id Y company_id company_id Y company_currency_id company_currency_id Y account_id account_id Y account_root_id account_root_id Y sequence sequence Y name name Y quantity quantity Y price_unit price_unit Y discount discount Y debit debit Y credit credit Y balance balance Y amount_currency amount_currency Y price_subtotal price_subtotal Y price_total price_total Y reconciled reconciled Y blocked blocked Y date_maturity date_maturity Y currency_id currency_id Y partner_id partner_id Y product_uom_id product_uom_id Y product_id product_id Y reconcile_model_id reconcile_model_id Y payment_id payment_id Y statement_line_id statement_line_id Y statement_id statement_id Y tax_line_id tax_line_id Y tax_group_id tax_group_id Y tax_base_amount tax_base_amount Y tax_exigible tax_exigible Y tax_repartition_line_id tax_repartition_line_id Y tax_audit tax_audit Y amount_residual amount_residual Y amount_residual_currency amount_residual_currency Y full_reconcile_id full_reconcile_id Y matching_number matching_number Y analytic_account_id analytic_account_id Y display_type display_type Y is_rounding_line is_rounding_line Y exclude_from_invoice_tab exclude_from_invoice_tab Y create_uid create_uid Y create_date create_date Y write_uid write_uid Y write_date write_date Y is_anglo_saxon_line is_anglo_saxon_line Y purchase_line_id purchase_line_id Y asset_category_id asset_category_id Y asset_start_date asset_start_date Y asset_end_date asset_end_date Y asset_mrr asset_mrr Y is_landed_costs_line is_landed_costs_line Y cost_centre_id cost_centre_id Y

288 80 Y Table input TableInput Y 1 none erp indoteknik production (localhost) select aml.* from account_move_line aml join account_move am on am.id = aml.move_id where 1=1 and aml.write_date between '2024-06-01' and '2024-06-30' --and to_char(am.date, 'YYYY') = '2023' --and (am.move_type = 'out_invoice' or am.journal_id = 3) --and aml.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 Integer normal move_id 9 0 Table input move_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal move_name 2147483647 -1 Table input move_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 parent_state 2147483647 -1 Table input parent_state . , 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 company_currency_id 9 0 Table input company_currency_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal account_id 9 0 Table input account_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal account_root_id 9 0 Table input account_root_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal sequence 9 0 Table input sequence ####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 BigNumber normal quantity -1 -1 Table input quantity ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal price_unit -1 -1 Table input price_unit ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal discount -1 -1 Table input discount ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal debit -1 -1 Table input debit ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal credit -1 -1 Table input credit ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal balance -1 -1 Table input balance ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_currency -1 -1 Table input amount_currency ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal price_subtotal -1 -1 Table input price_subtotal ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal price_total -1 -1 Table input price_total ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N Boolean normal reconciled -1 -1 Table input reconciled . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal blocked -1 -1 Table input blocked . , none N Y 0 N N N en_US Asia/Bangkok N Date normal date_maturity -1 -1 Table input date_maturity . , 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 product_uom_id 9 0 Table input product_uom_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal product_id 9 0 Table input product_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal reconcile_model_id 9 0 Table input reconcile_model_id ####0;-####0 . , 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 Integer normal statement_id 9 0 Table input statement_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_line_id 9 0 Table input tax_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_group_id 9 0 Table input tax_group_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal tax_base_amount -1 -1 Table input tax_base_amount ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N Boolean normal tax_exigible -1 -1 Table input tax_exigible . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_repartition_line_id 9 0 Table input tax_repartition_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal tax_audit 2147483647 -1 Table input tax_audit . , 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_residual_currency -1 -1 Table input amount_residual_currency ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N Integer normal full_reconcile_id 9 0 Table input full_reconcile_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal matching_number 2147483647 -1 Table input matching_number . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal analytic_account_id 9 0 Table input analytic_account_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal display_type 2147483647 -1 Table input display_type . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_rounding_line -1 -1 Table input is_rounding_line . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal exclude_from_invoice_tab -1 -1 Table input exclude_from_invoice_tab . , 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 Boolean normal is_anglo_saxon_line -1 -1 Table input is_anglo_saxon_line . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal purchase_line_id 9 0 Table input purchase_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal asset_category_id 9 0 Table input asset_category_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal asset_start_date -1 -1 Table input asset_start_date . , none N Y 0 N N N en_US Asia/Bangkok N Date normal asset_end_date -1 -1 Table input asset_end_date . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal asset_mrr -1 -1 Table input asset_mrr ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_landed_costs_line -1 -1 Table input is_landed_costs_line . , 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 80 Y N