Schema

[Dave Peticolas]

"Phillip Shelton" writes:
> 
> 
> > -----Original Message-----
> > > > > cleared_balance                 money           "
> > > > > reconciled_balance              money           "
> > > > > share_balance                   money           "
> > > > > share_cleared_balance           money           "
> > > > > share_reconciled_balance        money           "
> [snip]
> > Then I will remove these fields from my schema. Storing the running
> > balance this way just won't work for very large data sets.
> >
> > This does bring up an issue, though. Will I need to keep three running
> > balances, like here?
> 
> possibly, but I will let others arbitrate.
> 
> > > Transactions aren't entered in the ledger.  In fact,
> > > there's no global
> > > way to get a list of transactions at all.
> 
> First, an apology for airing just how much I don't know about accounting and
> databases.
> 
> Question: Is the non-appearance of a list of transactions a gnucash
> limitation or a financial data limitation?

GnuCash does not keep an explicit list of transactions around.
However, it does provide an api to traverse over each one, hitting
each transaction only once.

In the db, I would imagine that the transactions will almost certainly
have their own table, so there will be an 'explicit' list of them.

dave