Sample Database Design for Financial Accounting

views:

3062

answers:

+4 Q:

Sample Database Design for Financial Accounting

Could someone please lead me to a sample database for a financial accounting system?

+1 A:

I think you can find some interresting thing on Sourceforge

Hugues Van Landeghem 2009-09-27 21:00:20

Thanks; I have looked into some - like jgnash - and they do not use sql based (relational database) backends.

Kaveh Shahbazian 2009-09-27 23:09:57

@Kaveh : take a look at turbocash, it know it use Firebird

Hugues Van Landeghem 2009-09-28 16:24:51

+3 A:

This is a big topic. I think you should start by doing some research on "general ledger" and double entry accounting.

There are lots of schemas out there. Google found these that might be of interest:

An OMG Corba model for general ledger
SQL Ledger, an open source implementation
A presentation telling something about how Oracle models it

Google is your friend.

If you give a cursory glance to any of these, you'll realize that it's not a trivial task.

duffymo 2009-09-27 21:15:00

You are totally right it is not a trivial task, even if it seems so. Because of this I want to look into database design of some 'double entry' financial accounting systems, to avoid already known issues in such systems.

Kaveh Shahbazian 2009-09-28 09:55:09

+6 A:

If you have some time and money to invest, look into the "The Data Model Resource Book" series by Len Silverston, which has designs and templates for generic business data models. You also might be able to find something that fits from here

dpbradley 2009-09-28 15:00:05

ansaurus

tags:

views:

answers:

Sample Database Design for Financial Accounting

related questions