LP#793802 Aged billings and payments
authorBill Erickson <berickxx@gmail.com>
Fri, 21 Sep 2018 18:53:33 +0000 (14:53 -0400)
committerGalen Charlton <gmc@equinoxinitiative.org>
Tue, 4 Jun 2019 21:32:47 +0000 (17:32 -0400)
commit33a7377dfaa4b74f210de017c35f392bc0c7e2e4
treea3d7bd80f9a6a171ee406c106e7475a33458edbf
parenta4815b858e2d9b3c8769e58f15402e5eb67da139
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]