Add an auditor table for acq.fund_debit

[Tiffany Little]

I would like to see an edit_time column added to the acq.fund_debit table.

Currently there is only one column in the acqfd table that gives you any date information--create_time. However, fund debits change all the time. Consider:

1. They change from encumbrance true to false.
2. Amount and origin_amount are (probably) the same when the fund debit is first created, but amount can be changed when an invoice entry is attached.
3. You might delete the invoice entry that it's attached to, and/or change it to a different one.
4. They're deleted*

*For the sake of this bug I'm not proposing to keep deleted fund debits around, but that is a change that's made.

There may be some other circumstances I'm not thinking of right now, too.

Our libraries frequently run recurring fund reports. If I need to track down what's going on with a fund balance difference between two reports, the shifting sands of what's encumbered and what's not and when that change happened, etc. is really tough to pin down.

[Jeff Davis (jdavis-sitka)]

Based on the change to the bug title, it sounds like an auditor table fits the bill? If so, working branch user/jeffdavis/lp1920210-audit-fund-debit should take care of that:

https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/jeffdavis/lp1920210-audit-fund-debit

[Galen Charlton (gmc)]

I've pushed a signoff branch and a release notes entry to working/user/gmcharlt/lp1920210_signoff

[Galen Charlton (gmc)]

As a month has passed without comment, I have pushed this to master for inclusion in 3.8. Thanks, Jeff!