[Koha-devel] Doubt in Koha Database Schema

[Michael Hafen]

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
column) then add the difference to both the amount and amountoutstanding
columns. (Since we can't guarantee that the script is run once, and only
once, a day.)

On Thu, Jun 20, 2019 at 3:05 AM RAGHAV ARORA <
f20171016 at pilani.bits-pilani.ac.in> wrote:

> 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 amount debited/credited. What exactly is the
> 'amountlines.amount'?
> In my database, there is an accountlines row which has 3 account_offsets
> rows linked, 2 of them credit $5, and 1 debits $10, making the
> amountoutstanding=0, which is expected. But accountlines.amount stores 10.
> Why is that so?
>
> Thanks in advance
> Regards
> *Raghav Arora*
> Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering
> Contact : (+91) 8474975691
> Personal Email <raghavarora999 at yahoo.in> | University Email
> <f20171016 at pilani.bits-pilani.ac.in>
> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> |  GitHub
> <https://github.com/RAraghavarora/>
>
> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
> *Birla Institute of Technology and Science, Pilani*
> Pilani campus,
> Rajasthan-333031
>
>
> On Wed, Jun 19, 2019 at 10:25 PM Michael Hafen <michael.hafen at washk12.org>
> wrote:
>
>> 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
>> you wanted to know.
>>
>> On Wed, Jun 19, 2019 at 5:13 AM RAGHAV ARORA <
>> f20171016 at pilani.bits-pilani.ac.in> wrote:
>>
>>> Hello everyone,
>>>
>>> I am currently working on a project on Reports Management and Decision
>>> Support System for my institute library that uses Koha as it's ILS. I have
>>> a doubt in understanding what is the difference between the fields
>>> 'accountlines.amount' and 'accountlines.amountoutstanding'?
>>>
>>> Could someone help me out with this?
>>>
>>> Thanks in advance.
>>>
>>> Regards
>>> *Raghav Arora*
>>> Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics
>>> Engineering
>>> Contact : (+91) 9897597761
>>> Personal Email <raghavarora999 at yahoo.in> | University Email
>>> <f20171016 at pilani.bits-pilani.ac.in>
>>> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> |  GitHub
>>> <https://github.com/RAraghavarora/>
>>>
>>> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
>>> *Birla Institute of Technology and Science, Pilani*
>>> Pilani campus,
>>> Rajasthan-333031
>>> _______________________________________________
>>> Koha-devel mailing list
>>> Koha-devel at lists.koha-community.org
>>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>>> website : http://www.koha-community.org/
>>> git : http://git.koha-community.org/
>>> bugs : http://bugs.koha-community.org/
>>
>>
>>
>> --
>> Michael Hafen
>> Washington County School District Technology Department
>> Systems Analyst
>>
>>

-- 
Michael Hafen
Washington County School District Technology Department
Systems Analyst
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20190620/7b2cb388/attachment.html>