LP1174498: Add a Payments by Billing Type Reporting View
authorblake <blake@mobiusconsortium.org>
Thu, 3 Sep 2020 14:46:15 +0000 (10:46 -0400)
committerKyle Huckins <khuckins@catalyte.io>
Fri, 19 Mar 2021 00:32:29 +0000 (00:32 +0000)
commit498c1c51e56df11ba08723260d8a471cc17e9a08
treec581e91aa992c50de9950c8a1d646b9c3a69849f
parentae5b6a1a94a19338fd0de34b8227bbd655884d8c
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]