LP#1206936 - Fix wrong billing info in money.transaction_billing_summary user/csharp/lp1206936_correct_last_billing_info_mtbs
authorChris Sharp <csharp@georgialibraries.org>
Mon, 30 Nov 2015 14:48:26 +0000 (09:48 -0500)
committerChris Sharp <csharp@georgialibraries.org>
Mon, 30 Nov 2015 14:48:26 +0000 (09:48 -0500)
commita56a373579062bd54b7bb3ccd9d6dc681dc46b8b
treef7c6fe9997feaf0ea0dfa1ddc645f0bb86848552
parentd3dd07c63e90a79be88213a540a35861e939d524
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>
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]