- JOIN account_account on (account_account.id=account_move_line.account_id)
- JOIN account_period on (account_period.id=account_move_line.period_id)
- JOIN account_fiscalyear on (account_fiscalyear.id=account_period.fiscalyear_id)
- JOIN account_journal on (account_journal.id = account_move_line.journal_id)
- LEFT JOIN res_currency on (res_currency.id=account_move_line.currency_id)
- LEFT JOIN account_move_reconcile on (account_move_reconcile.id = account_move_line.reconcile_id)
- LEFT JOIN res_partner on (res_partner.id=account_move_line.partner_id)
- LEFT JOIN account_move on (account_move.id=account_move_line.move_id)
- LEFT JOIN account_tax on (account_tax.id=account_move_line.account_tax_id)
- LEFT JOIN account_tax_code on (account_tax_code.id=account_move_line.tax_code_id)
- LEFT JOIN account_analytic_account on (account_analytic_account.id=account_move_line.analytic_account_id)
+ JOIN account_account on
+ (account_account.id=account_move_line.account_id)
+ JOIN account_period on
+ (account_period.id=account_move_line.period_id)
+ JOIN account_fiscalyear on
+ (account_fiscalyear.id=account_period.fiscalyear_id)
+ JOIN account_journal on
+ (account_journal.id = account_move_line.journal_id)
+ LEFT JOIN res_currency on
+ (res_currency.id=account_move_line.currency_id)
+ LEFT JOIN account_move_reconcile on
+ (account_move_reconcile.id = account_move_line.reconcile_id)
+ LEFT JOIN res_partner on
+ (res_partner.id=account_move_line.partner_id)
+ LEFT JOIN account_move on
+ (account_move.id=account_move_line.move_id)
+ LEFT JOIN account_tax on
+ (account_tax.id=account_move_line.account_tax_id)
+ LEFT JOIN account_tax_code on
+ (account_tax_code.id=account_move_line.tax_code_id)
+ LEFT JOIN account_analytic_account on
+ (account_analytic_account.id=account_move_line.analytic_account_id)
+ LEFT JOIN account_bank_statement on
+ (account_bank_statement.id=account_move_line.statement_id)