From: Medi Montaseri <montaseri@gmail.com>
To: pgsql-sql@postgresql.org
Subject: accounting schema
Date: Wed, 6 Feb 2008 17:08:54 -0800
Message-ID: <8078a1730802061708q17c72234xe61be822459a24a8@mail.gmail.com> (raw)
Hi,
I am learning my way into Accounting and was wondering how Accounting
applications are designed. perhaps you could point the way....
On one hand, accountants talk about a sacret equation A = L + OE (Asset =
Libility + Owner Equity) and then under each categories there are one or
many account. On the other hand a DBA thinks in terms of tables and
relations. Instead of getting theoritical, allow me to setup an example
Say you have have construction project (like a room addition) or one of
those flip this house deals
Owner brings the land (equity) of say worth $100K
Expenses begin to mount ( that is a minus against OE)
Account Payble begins to mount (that is a liability)
And one day you experience a sale
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.
Thanks
Medi
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: montaseri@gmail.com
Subject: Re: accounting schema
In-Reply-To: <8078a1730802061708q17c72234xe61be822459a24a8@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox