财务会计的样本数据库设计

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

能不能给我一个财务会计系统的数据库样本?

5 个解决方案

#1

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

如果您有一些时间和金钱可以投资，请查看Len Silverston的“数据模型资源书”系列，该系列有通用业务数据模型的设计和模板。你也可以从这里找到适合自己的东西。

#2

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
通用分类帐的OMG Corba模型
SQL Ledger, an open source implementation
SQL分类帐，一个开源实现
A presentation telling something about how Oracle models it
一个关于Oracle如何建模的演示

Google is your friend.

谷歌是你的朋友。

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

如果你粗略地看一下这些，你就会发现这不是一个简单的任务。

#3

I think you can find some interresting thing on Sourceforge

我想你可以在Sourceforge上找到一些相互交织的东西

#4

Here is a way to do it. But you need to work for 5-6 days to as a newbie to install.

这是一种方法。但是作为一个新手，你需要工作5-6天才能安装。

Download and Install EBS from Oracle, which comes with a fictitious company, Vision and its database
从Oracle下载并安装EBS，它附带一个虚构的公司、远景和它的数据库。
Install & Run BI Apps Financials on it.
在上面安装和运行BI应用程序财务。
It will populate general ledger,AP,AR reports for you to analyze.
它将填充总账、AP、AR报告供您分析。

Have fun :-)

玩得开心:-)

#5

"Whenever I've had to build a database for fiscal reports by fiscal quarter, month, or year or whatever, I've found it convenient to borrow a concept from star schema design and data warehousing, even if I'm not really building a DW."

“每当我不得不按季度、月、年或其他时间建立一个财务报告数据库时，我就会发现从星型模式设计和数据仓库中借用一个概念是很方便的，即使我并没有真正构建一个DW。”

Please see this answer.

请参阅这个答案。

#1

#2