Re: accounting schema

On Feb 6, 2008 6:08 PM, Medi Montaseri <montaseri(at)gmail(dot)com> wrote:
> I am learning my way into Accounting and was wondering how Accounting
> applications are designed. perhaps you could point the way....

<SNIP>
> As a DBA, (and keeping it simple) I am thinking I need a table for every
> account which migh look like
>
> id, description, credit, debit, validated, created_on, created_by,
> modified_on, modified_by
>
> Is that pretty match it ?
> Please let me know if you have seen some accounting or DB book that
> addresses this problem domain.

Another codebase to look at is http://www.sql-ledger.org/. It uses postgresql.

Regards,
Tony