LP#1206936 - Fix wrong billing info in money.transaction_billing_summary
authorChris Sharp <csharp@georgialibraries.org>
Mon, 30 Nov 2015 14:48:26 +0000 (09:48 -0500)
committerBill Erickson <berickxx@gmail.com>
Thu, 25 Feb 2016 02:48:07 +0000 (21:48 -0500)
commit9ceb8bc5fa004689f967f212a2c190e534d40320
tree4c88ec6408b5d7747d934c2ef1119406547076ba
parent2b160f30e456d70369e2e4e949726b6e37c0b7e7
LP#1206936 - Fix wrong billing info in money.transaction_billing_summary

The money.transaction_billing_summary view was showing the wrong
last billing type and last billing note for certain transactions.
This fix, from Dan Scott, in turn from Mike Rylander, recreates
that view so that it depends on the speedier and more accurate
money.materialized_billable_xact_summary view.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Signed-off-by: Dan Wells <dbw2@calvin.edu>
Open-ILS/src/sql/Pg/080.schema.money.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.correct_mtbs_view.sql [new file with mode: 0644]