On Tue, Oct 14, 2008 at 5:07 PM, justin <justin@xxxxxxxxxxxxxxx> wrote: > because a credit account is a liability account aka a negative account so > credit a credit account causes it to go UP not down. As you say, "a negative account". Our liability accounts go further down when credited. I work with accountants all day, and this is what they expect. Of course either approach works, but I've come to prefer the single-column one. > Isak Hansen wrote: > > On Mon, Oct 13, 2008 at 2:57 AM, justin <justin@xxxxxxxxxxxxxxx> wrote: > > [...] Also you want to split out the debit and credits instead of > using one column. Example one column accounting table to track values > entered how do you handle Crediting a Credit Account Type. is it a negative > or positive entry??? > > > How is crediting a credit account different from crediting any other > account? > > YMMV, but I think a single amount column makes for a more consistent design. > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
