accounting Database design

[nemaroller]

If anyone has a relationship entity diagram for an accounting database they have made or administer, I would appreciate an email of a WORD or JPEG or whatever of the relationship diagram.

Thanks...

I'm beginning the preliminary steps of the accounting part of our database system...


As far as tables... this is what I have so far...


Account
AccountID - primary key
AccountTitle - name of account
AccountType - income or expense
AccountBalance - balance of the account
AccountCreationDate



AccountTypes - a lookup table for assigning an account type
AccountNumberID - primary key
AccountTypeName - Accounts recievable, accts payable, etc


Transactions
TransactionID - primary key
AccountID - (foreign key)account transaction belongs to or posts to
Amount
DebitCredit - true or false
DateOfTransaction
EnteredBy - employeeID

[jim mcnamara]

Define accounting.

Do you mean a simple bookkeeping proggie? Or General Ledger & AP & AR? Order Entry and AR?

In any instance, it is far cheaper to buy outside. There are COM compliant (means you can automate them from inside VB) database solutions that are basic bookeeping on up to actual accounting.

To make an accounting or bookeeping system means that you have to incorporate GAAP (or whatever applies your country) to have meaningful data and processes. I've written all three types of apps and they are pretty big undertakings to get something decent.

Tell your boss - you can save thousands of dollars in development costs and ongoing maintenance costs by going outside.

[dcartford]

The diagram you have come out is basically covering your general ledger transactions. You still need to branch out some connecting tables for your sub-modules, like AR, AP, Banking, etc. Try reading up the book on accounting database design by author derek liew, it covers most of the table design and sql reporting needs.

[Help321]

After 8 years I hope they're still not drawing the diagram

[sapator]

MEGA LOL!
But the question is how did you manage to dig up an article from 2003?
If i do a search it will let me find posts 1 year long