Thanks Alan. Was there another message though? This was the first reply
received.


_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Alan McDonald
Sent: Thursday, December 07, 2006 4:30 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Accounting System DB Design

> Could someone point me to an example of table design for an accounting
> related system?
>
> I want to implement standard T-Account style accounting in my system.
> Should I have a table for each account(CASH, AR, WRITEOFF, DISCOUNT,
> REVENUE, et. al.)? Or should I have a single "LEDGER" table and an
> "ACCOUNTTYPE" lookup table?
>
> To link the debit/credit side of a transaction can I have a
> foreign key on a
> field in the same table? An example (or some advice) would be most
> appreciated.
>
> Thanks,
>
> Anthony

sorry - forgot the link
http://www.dbsonlin <http://www.dbsonline.com/> e.com/
Alan







[Non-text portions of this message have been removed]