Subject RE: [firebird-support] Best table structure for Debit/Credit
Author Alan McDonald
> Hi Group,
> I have a table that stores debit and credit transactions. At the
> moment, a positive value in the amount field means a deposit and a
> negative value in the amount field means a withdrawal.
> I need to display the total deposits, total withdrawals and balances,
> but using the current table structure that requires three subselects.
> This is obviously not an unusual problem, Is the way I have done it
> the best way to do it, or would it be better to have separate fields
> for debits and credits?
> Adam

I always have a debit and a credit column. You can have -tive credits
and -tive debits unfortunately.
Closing periods is matter of posting an opposing balance - not a -tive
amount in the same column.