On Tue, Oct 14, 2008 at 3:50 PM, Isak Hansen <isak.hansen@xxxxxxxxx> 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. Absolutely. I worked on computer accounting systems many years ago, not exactly BC but BPC (Before PC) and such systems had a flag in the Chart of Accounts records to indicate how to display negative numbers. The assets and cost records were displayed as recorded and the revenue and liabilities were negated for display purposes. Naturally offsets such as credit notes against revenue displayed in the way that humans expected to read them without any difficulty. -- In a world without walls who needs Windows (or Gates)? Try Linux instead! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
