Re: accounting schema - Mailing list pgsql-sql

From johnf
Subject Re: accounting schema
Date
Msg-id 200802070809.46895.jfabiani@yolo.com
Whole thread Raw
In response to Re: accounting schema  ("Medi Montaseri" <montaseri@gmail.com>)
List pgsql-sql
On Wednesday 06 February 2008 06:54:36 pm Medi Montaseri wrote:
> I suppose instead of AR and AP tables, I can just have one table called
> Entry (thanks Joe....) with an attribute indicating AR vs AP.

I recommend you not do have only one table for transaction.  AR and AP are 
different animals and each can get very complex quickly.   Adding a field 
that only applies to AP and not AR is a very simple example of what goes 
wrong.

-- 
John Fabiani


pgsql-sql by date:

Previous
From: "Tony Wasson"
Date:
Subject: Re: accounting schema
Next
From: Tiziano Slack
Date:
Subject: Re: TG_TABLE_NAME as identifier