Materialized View: transactions.trial_balance_view

 CREATE MATERIALIZED VIEW transactions.trial_balance_view
 AS
 SELECT core.get_account_name(verified_transaction_view.account_id) AS get_account_name,
    sum(
        CASE verified_transaction_view.tran_type
            WHEN 'Dr'::bpchar THEN verified_transaction_view.amount_in_local_currency::numeric
            ELSE NULL::numeric
        END) AS debit,
    sum(
        CASE verified_transaction_view.tran_type
            WHEN 'Cr'::bpchar THEN verified_transaction_view.amount_in_local_currency::numeric
            ELSE NULL::numeric
        END) AS credit
   FROM transactions.verified_transaction_view
  GROUP BY verified_transaction_view.account_id;