> 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]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>