Schema Changes: 3.5.3

Upgrade: 3.5.2 → 3.5.3

This release applied 1 migration(s) to the database schema.

ID Type Description

1246

schema

open with balance usr summary

Migration Details

1246 — open with balance usr summary

Type: schema

View SQL
CREATE OR REPLACE VIEW money.open_with_balance_usr_summary AS
    SELECT
        usr,
        sum(total_paid) AS total_paid,
        sum(total_owed) AS total_owed,
        sum(balance_owed) AS balance_owed
    FROM money.materialized_billable_xact_summary
    WHERE xact_finish IS NULL AND balance_owed <> 0.0
    GROUP BY usr;