accounting schema

Поиск
Список
Период
Сортировка
От Medi Montaseri
Тема accounting schema
Дата
Msg-id 8078a1730802061708q17c72234xe61be822459a24a8@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "TJ O'Donnell"
Дата:
Сообщение: Re: Create Table xtest (like xtype)
Следующее
От: johnf
Дата:
Сообщение: Re: Information schema permissions