From b76065d255794323fb2f02afe723f63c0d57c7ad Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Wed, 22 Oct 2025 13:34:10 +0700 Subject: delete useless data and update diff data --- import_account_move_line_onetime.ktr | 1745 +++++++++++++++++++++++++++++++++- 1 file changed, 1738 insertions(+), 7 deletions(-) (limited to 'import_account_move_line_onetime.ktr') diff --git a/import_account_move_line_onetime.ktr b/import_account_move_line_onetime.ktr index fb7afb5..3251138 100644 --- a/import_account_move_line_onetime.ktr +++ b/import_account_move_line_onetime.ktr @@ -540,11 +540,71 @@ - Table input + 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 @@ -873,13 +933,1683 @@ - 288 - 80 + 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 + 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' +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 - Table input + production TableInput Y @@ -893,7 +2623,8 @@ 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 '2025-01-01' and '2025-03-30' +and aml.write_date > '2025-01-01' +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) @@ -2294,8 +4025,8 @@ and aml.write_date between '2025-01-01' and '2025-03-30' - 112 - 80 + 240 + 32 Y -- cgit v1.2.3