On 10/27/22 09:41, Lindsay Stratton via Evergreen-general wrote:
Hi all -
Kind of a random nitpicky question about Evergreen data tables...
In the database, I'm looking at money schema, specifically the various
billable/billing summary tables and wondering if the transactions
included that do not have last billing anything or total owed values
were returned before accruing any fines, or circ transactions that would
never have accrued fines because of non-fine bearing circ rules?
Looking at xact_start and xact_finish dates for those records, it looks
like the former. But... I'm a little hesitant. Does anybody know?
Lindsay,
Yes, that is the reason. If you look at the action.circulation table, it
inherits from money.bibllable_xaxt. This means that every circulation
has a corresponding row in money.billable_xact, even if there is no
actual bill.
Hope that helps,
Jason
Lindsay
*Lindsay Stratton*
*Systems Librarian*
Westchester Library System
570 Taxter Rd., 4th Floor
Elmsford, NY 10523
[email protected] <mailto:[email protected]>
_______________________________________________
Evergreen-general mailing list
[email protected]
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
_______________________________________________
Evergreen-general mailing list
[email protected]
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
