From: | Ian Harding <iharding(at)pakrat(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Accounting Schema |
Date: | 2001-05-05 23:35:52 |
Message-ID: | 3AF48E58.395806D5@pakrat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Credits are positive, debits are negative. I have never seen an accounting
package that did not follow this basic rule.
Dave Cramer wrote:
> Hi all,
>
> Can anyone out there with more experience than me give me some hints as to
> how to do accounting tables in a db. The problem I am wrestling with is how
> to represent credits, and debits.
> One way is to identify credits and debits with a transactiontype, and keep
> all of the numbers positive which models the way accountants do it. This
> makes things liking calculating the balance difficult with a sql statement.
>
> Any hints would be appreciated.
>
> Dave
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | GH | 2001-05-05 23:48:27 | Re: Accounting Schema |
Previous Message | Ludwig Meyerhoff | 2001-05-05 23:13:36 | Re: Would you do this? |