LP#1793802 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>
Fri, 6 Sep 2019 21:38:40 +0000 (17:38 -0400)
commit33c46ab6c830b58932b4fa7b707f95edcf698db2
treeed9771d0b287fbae8ceca959b42e1cfd89dee273
parent46c8e3a876bdf34222429dc9d98954ff84ef20c1
LP#1793802 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>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
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]