LP#793802 Aged billings and payments
authorBill Erickson <berickxx@gmail.com>
Fri, 21 Sep 2018 18:53:33 +0000 (14:53 -0400)
committerChris Sharp <csharp@georgialibraries.org>
Fri, 9 Aug 2019 13:25:41 +0000 (09:25 -0400)
commit86c2c56bf40413cfde60aae84787ae9e6176a2f3
tree4c975aea2a8296533ebc47840beade4722b0ddde
parent5ff1dfd9ee084fef3ab0cf733566b885cc76f337
LP#793802 Aged billings and payments

Creates tables money.aged_billing and money.aged_payment.  When a
circulation is aged, billings/payments linked to the circ are migrated
to the aged_* table.

Upgrade script includes a migration script for migrating existing
billings and payments.

Includes IDL entries for reporting and pcrud access just in case it's
needed.  Note the 'xact' column on these new tables links directly to
the aged circulation instead of the non-existent money.billable_xact.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/sql/Pg/080.schema.money.sql
Open-ILS/src/sql/Pg/090.schema.action.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.aged-billing-payment.sql [new file with mode: 0644]