]> 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:29:23 +0000 (14:29 -0500)
commitab29e9f89dd9443905008b228950376460fbd1df
tree2371332afe4874e2116a5d6ddbabc81e1b042d5d
parent7066a3200f96c0863445cf196e933f71df04f94e
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]