LP1174498: Add a Payments by Billing Type Reporting View
authorblake <blake@mobiusconsortium.org>
Thu, 3 Sep 2020 14:46:15 +0000 (10:46 -0400)
committerJason Boyer <JBoyer@equinoxinitiative.org>
Thu, 3 Sep 2020 14:46:15 +0000 (10:46 -0400)
commitafa5f839f73800eb366db4c95be6609d08d4a7e9
treef60e41f1779c07a50bd4cafa8d2749bbe6e0ffe0
parent3c40650424ee9d7a5a79c288f617f39e8b6587fa
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>
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]