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, 16 Nov 2018 01:18:37 +0000 (20:18 -0500)
commit197f021603e0db33672f7af2f8bf07c3e1730d0c
tree4ecb0be62452179363205f4b7d31f4455b2e7cd2
parentc88cb5ed67bd49f3453359b9a57033c435b65fe9
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]