Re: [Koha-devel] Doubt in Koha Database Schema

Okay, Thank you Sir Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email | University Email LinkedIn | GitHub

Re: [Koha-devel] Doubt in Koha Database Schema

My guess is that code was looking for outstanding fines rather than account balance. On Thu, Jun 20, 2019 at 9:57 PM RAGHAV ARORA < f20171...@pilani.bits-pilani.ac.in> wrote: > Ok sir, thanks for the clarification. > > One last thing, if I need to see the total fine of a patron, I will take > sum

Re: [Koha-devel] Doubt in Koha Database Schema

Ok sir, thanks for the clarification. One last thing, if I need to see the total fine of a patron, I will take sum of all the amountoutstanding for that borrowernumber, right? At some place I found someone to be taking sum of only the positive amountoutstanding, and ignoring the negative amountout

Re: [Koha-devel] Doubt in Koha Database Schema

So that you know what the original amount of the fine is/was. This is especially useful in an ongoing overdue fine, for example. The patron may have some, but still has the book. So the script can look at what the fine is supposed to be, and what it was last time the script ran (the amount colum

Re: [Koha-devel] Doubt in Koha Database Schema

Thank you sir, Can you please help me understand these tables? What is the purpose of the 2 tables 'accountlines' and 'account_offsets'? account_offsets is a child of accountlines, which allows 1 accountlines row to have multiple account_offsets, and the 'account_offsets.amount' is the total amou

Re: [Koha-devel] Doubt in Koha Database Schema

Amount is the original amount of the fine/invoice, and amountoutstanding is the remaining amount after receiving / sending some sort of payment. There should be another row in that table, and a link in the accountoffsets table, of those two columns aren't the same, but that's probably more than yo