Could someone please lead me to a sample database for a financial accounting system?
From stackoverflow
-
I think you can find some interresting thing on Sourceforge
Kaveh Shahbazian : Thanks; I have looked into some - like jgnash - and they do not use sql based (relational database) backends.Hugues Van Landeghem : @Kaveh : take a look at turbocash, it know it use Firebird -
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.
Kaveh Shahbazian : 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. -
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
0 comments:
Post a Comment