update_diff_account_move_line 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 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 Select values Y Select values Insert / update Y Filter rows Write to log Y Filter rows FilterRows Y 1 none Select values Write to log N balance <> balance_1 384 128 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 720 128 Y Merge join MergeJoin Y 1 none LEFT OUTER production dw id id 240 128 Y Select values SelectValues Y 1 none id move_id move_name date ref parent_state journal_id company_id company_currency_id account_id account_root_id sequence name quantity price_unit discount debit credit balance amount_currency price_subtotal price_total reconciled blocked date_maturity currency_id partner_id product_uom_id product_id reconcile_model_id payment_id statement_line_id statement_id tax_line_id tax_group_id tax_base_amount tax_exigible tax_repartition_line_id tax_audit amount_residual amount_residual_currency full_reconcile_id matching_number analytic_account_id display_type is_rounding_line exclude_from_invoice_tab create_uid create_date write_uid write_date is_anglo_saxon_line purchase_line_id asset_category_id asset_start_date asset_end_date asset_mrr is_landed_costs_line cost_centre_id line_no N 560 128 Y Write to log WriteToLog Y 1 none log_level_basic Y N 0 384 240 Y dw TableInput Y 1 none dw bi indoteknik (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 > '2025-01-01' and to_char(aml.write_date, 'YYYY') = get_now_year() order by aml.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 Integer normal move_id 9 0 dw move_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal move_name 2147483647 -1 dw move_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 parent_state 2147483647 -1 dw parent_state . , 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 company_currency_id 9 0 dw company_currency_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal account_id 9 0 dw account_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal account_root_id 9 0 dw account_root_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal sequence 9 0 dw sequence ####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 BigNumber normal quantity -1 -1 dw quantity ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal price_unit -1 -1 dw price_unit ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal discount -1 -1 dw discount ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal debit -1 -1 dw debit ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal credit -1 -1 dw credit ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal balance -1 -1 dw balance ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_currency -1 -1 dw amount_currency ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal price_subtotal -1 -1 dw price_subtotal ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal price_total -1 -1 dw price_total ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N Boolean normal reconciled -1 -1 dw reconciled . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal blocked -1 -1 dw blocked . , none N Y 0 N N N en_US Asia/Bangkok N Date normal date_maturity -1 -1 dw date_maturity . , 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 product_uom_id 9 0 dw product_uom_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal product_id 9 0 dw product_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal reconcile_model_id 9 0 dw reconcile_model_id ####0;-####0 . , 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 Integer normal statement_id 9 0 dw statement_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_line_id 9 0 dw tax_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_group_id 9 0 dw tax_group_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal tax_base_amount -1 -1 dw 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 dw tax_exigible . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_repartition_line_id 9 0 dw tax_repartition_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal tax_audit 2147483647 -1 dw tax_audit . , 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_residual_currency -1 -1 dw 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 dw full_reconcile_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal matching_number 2147483647 -1 dw matching_number . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal analytic_account_id 9 0 dw analytic_account_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal display_type 2147483647 -1 dw display_type . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_rounding_line -1 -1 dw is_rounding_line . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal exclude_from_invoice_tab -1 -1 dw exclude_from_invoice_tab . , 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 Boolean normal is_anglo_saxon_line -1 -1 dw is_anglo_saxon_line . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal purchase_line_id 9 0 dw purchase_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal asset_category_id 9 0 dw asset_category_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal asset_start_date -1 -1 dw asset_start_date . , none N Y 0 N N N en_US Asia/Bangkok N Date normal asset_end_date -1 -1 dw asset_end_date . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal asset_mrr -1 -1 dw 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 dw is_landed_costs_line . , 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 240 240 Y production 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 > '2025-01-01' and to_char(aml.write_date, 'YYYY') = get_now_year() order by aml.id --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 production id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal move_id 9 0 production move_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal move_name 2147483647 -1 production move_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 parent_state 2147483647 -1 production parent_state . , 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 company_currency_id 9 0 production company_currency_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal account_id 9 0 production account_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal account_root_id 9 0 production account_root_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal sequence 9 0 production sequence ####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 BigNumber normal quantity -1 -1 production quantity ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal price_unit -1 -1 production price_unit ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal discount -1 -1 production discount ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal debit -1 -1 production debit ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal credit -1 -1 production credit ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal balance -1 -1 production balance ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal amount_currency -1 -1 production amount_currency ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal price_subtotal -1 -1 production price_subtotal ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal price_total -1 -1 production price_total ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N Boolean normal reconciled -1 -1 production reconciled . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal blocked -1 -1 production blocked . , none N Y 0 N N N en_US Asia/Bangkok N Date normal date_maturity -1 -1 production date_maturity . , 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 product_uom_id 9 0 production product_uom_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal product_id 9 0 production product_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal reconcile_model_id 9 0 production reconcile_model_id ####0;-####0 . , 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 Integer normal statement_id 9 0 production statement_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_line_id 9 0 production tax_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_group_id 9 0 production tax_group_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal tax_base_amount -1 -1 production 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 production tax_exigible . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal tax_repartition_line_id 9 0 production tax_repartition_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal tax_audit 2147483647 -1 production tax_audit . , 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_residual_currency -1 -1 production 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 production full_reconcile_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal matching_number 2147483647 -1 production matching_number . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal analytic_account_id 9 0 production analytic_account_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal display_type 2147483647 -1 production display_type . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal is_rounding_line -1 -1 production is_rounding_line . , none N Y 0 N N N en_US Asia/Bangkok N Boolean normal exclude_from_invoice_tab -1 -1 production exclude_from_invoice_tab . , 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 Boolean normal is_anglo_saxon_line -1 -1 production is_anglo_saxon_line . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal purchase_line_id 9 0 production purchase_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal asset_category_id 9 0 production asset_category_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Date normal asset_start_date -1 -1 production asset_start_date . , none N Y 0 N N N en_US Asia/Bangkok N Date normal asset_end_date -1 -1 production asset_end_date . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal asset_mrr -1 -1 production 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 production is_landed_costs_line . , 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 Integer normal line_no 9 0 production line_no ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N 240 32 Y N