]> git.evergreen-ils.org Git - Evergreen.git/commit
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)
committerDan Wells <dbw2@calvin.edu>
Wed, 24 Feb 2016 19:30:53 +0000 (14:30 -0500)
commit5af5faaf3d890c449549bb41183e7a3fc03b5439
tree8b32785424680804f31bc1591a62734823f7a331
parent3b30c886bdcfb126750ed780783660680e846f69
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]