If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
finding design examples for Invoices and Payments
I'm building an application that will need to track Invoices (Receivables)
and Payments, and rather than reinvent a widely-used wheel from scratch, I'm looking for design ideas that might be available. That is, I'm trying to find examples of the tables, fields and their relationships that others have used successfully. I've looked at the Time and Billing template on the MS web site, and it's got some useful design ideas, but it's Project-centered, instead of being Invoice-centered. I'm not yet sure which is best for my database, and I'd first like to find some other design examples before I try to make a decision. I don't even need the entire database - I'm primarily interested in the table relationships showing the tables, fields and the relations between the tables. Can anyone tell me where I could look to find other design examples for a database that will handle Invoice/Receivables and Payments? Thanks in advance. Paul |
#2
|
|||
|
|||
finding design examples for Invoices and Payments
Take a look he
http://www.databaseanswers.com/data_models/index.htm There is a wealth of data models available, one of which might help you. -- --Roger Carlson www.rogersaccesslibrary.com Reply to: Roger dot Carlson at Spectrum-Health dot Org "Paul James" wrote in message ... I'm building an application that will need to track Invoices (Receivables) and Payments, and rather than reinvent a widely-used wheel from scratch, I'm looking for design ideas that might be available. That is, I'm trying to find examples of the tables, fields and their relationships that others have used successfully. I've looked at the Time and Billing template on the MS web site, and it's got some useful design ideas, but it's Project-centered, instead of being Invoice-centered. I'm not yet sure which is best for my database, and I'd first like to find some other design examples before I try to make a decision. I don't even need the entire database - I'm primarily interested in the table relationships showing the tables, fields and the relations between the tables. Can anyone tell me where I could look to find other design examples for a database that will handle Invoice/Receivables and Payments? Thanks in advance. Paul |
#3
|
|||
|
|||
finding design examples for Invoices and Payments
Great site. This is the kind of information I was looking for. The link to
the e-Commerce data model contains invoices. Thanks, Roger. If anyone else know of other sites with a wealth of data models like the one Roger submitted, please share them with the group as well. TIA |
Thread Tools | |
Display Modes | |
|
|