LP1174498: Add a Payments by Billing Type Reporting View
authorblake <blake@mobiusconsortium.org>
Thu, 3 Sep 2020 14:46:15 +0000 (10:46 -0400)
committerGalen Charlton <gmc@equinoxinitiative.org>
Mon, 15 Mar 2021 15:59:58 +0000 (11:59 -0400)
commitdf4c2fa5d8645d7833b37683064cf69234f2dad4
treecbf4cb3e6beebc9e7d26666a95009e670ee75257
parent912d9338d778a0d7197b07b5c0b6bbc1e5f79a7d
LP1174498: Add a Payments by Billing Type Reporting View

This is an updated version of the initial concept by Mike
Rylander with input from Jeff Godin. This view connects
payments to specific billings and allows reports to be
written to determine how accepted payments were distributed
by billing type.

Signed-off-by: blake <blake@mobiusconsortium.org>
Signed-off-by: Jason Boyer <JBoyer@equinoxinitiative.org>
Signed-off-by: Katie Greenleaf Martin <bcl@blaircountylibraries.org>
Signed-off-by: Elizabeth Davis <edavis@albright.org>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Open-ILS/src/sql/Pg/080.schema.money.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.money.materialized_payment_by_billing_type.sql [new file with mode: 0644]