accounting schema - Mailing list pgsql-sql

From Medi Montaseri
Subject accounting schema
Date
Msg-id 8078a1730802061708q17c72234xe61be822459a24a8@mail.gmail.com
Whole thread Raw
Responses Re: accounting schema  (Robert Edwards <bob@cs.anu.edu.au>)
Re: accounting schema  (John Hasler <john@dhh.gt.org>)
Re: accounting schema  ("Tony Wasson" <ajwasson@gmail.com>)
List pgsql-sql
Hi,<br /><br />I am learning my way into Accounting and was wondering how Accounting applications are designed. perhaps
youcould point the way....<br /><br />On one hand, accountants talk about a sacret equation A = L + OE (Asset =
Libility+ Owner Equity) and then under each categories there are one or many account. On the other hand a DBA thinks in
termsof tables and relations. Instead of getting theoritical, allow me to setup an example<br /><br />Say you have have
constructionproject (like a room addition) or one of those flip this house deals<br /><br />Owner brings the land
(equity)of say worth $100K<br />Expenses begin to mount ( that is a minus against OE)<br /> Account Payble begins to
mount(that is a liability)<br />And one day you experience a sale <br /><br />As a DBA, (and keeping it simple) I am
thinkingI need a table for every account which migh look like<br /><br />id, description, credit, debit, validated,
created_on,created_by, modified_on, modified_by<br /><br />Is that pretty match it ?<br />Please let me know if you
haveseen some accounting or DB book that addresses this problem domain.<br /><br />Thanks<br />Medi<br /><br /> 

pgsql-sql by date:

Previous
From: "TJ O'Donnell"
Date:
Subject: Re: Create Table xtest (like xtype)
Next
From: johnf
Date:
Subject: Re: Information schema permissions