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

\there a very good accounting system writtne in Delphi (you buy the cource
if you want) for redistribution. The trial version may give you an insight
into table design, the data is DBISAM tables.
Alan

>
> _____
>
> 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
>
>
>
>