Re: [GENERAL] General Ledger db design

2007-03-01 Thread Brent Wood
Filipe Fernandes wrote: [snip] Martin Winsler wrote: Does anybody have any experience or knowledge of building financial accounting databases? [snip] I too was thinking about building a double entry accounting system and I've been following this thread closely,

Re: [GENERAL] General Ledger db design

2007-03-01 Thread Merlin Moncure
On 2/26/07, Filipe Fernandes [EMAIL PROTECTED] wrote: [snip] Martin Winsler wrote: Does anybody have any experience or knowledge of building financial accounting databases? [snip] I too was thinking about building a double entry accounting system and I've been following this thread closely,

Re: [GENERAL] General Ledger db design

2007-02-26 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/26/07 01:39, Karl O. Pinc wrote: On 02/25/2007 06:21:45 PM, Kenneth Downs wrote: Martin Winsler wrote: [snip] The above proposal takes care of the data structure/referential integrity issues, but does not solve the data integrity

Re: [GENERAL] General Ledger db design

2007-02-26 Thread Raymond O'Donnell
Kenneth Downs wrote: So far so good. Now we have AR invoices, and AP vouchers. Let's My apologies if this is a stupid question, but what do AR and AP stand for? I'm following this thread with interest. Ray. --- Raymond

Re: [GENERAL] General Ledger db design

2007-02-26 Thread Michael Glaesemann
On Feb 26, 2007, at 19:32 , Raymond O'Donnell wrote: Kenneth Downs wrote: So far so good. Now we have AR invoices, and AP vouchers. Let's My apologies if this is a stupid question, but what do AR and AP stand for? I'm following this thread with interest. Accounts Receivable and

Re: [GENERAL] General Ledger db design

2007-02-26 Thread Kenneth Downs
Karl O. Pinc wrote: On 02/25/2007 06:21:45 PM, Kenneth Downs wrote: Martin Winsler wrote: This is a real world situation where referential integrity needs to be broken in theory, I believe. Does anybody have any experience or knowledge of building financial accounting databases? Am I

Re: [GENERAL] General Ledger db design

2007-02-26 Thread Filipe Fernandes
[snip] Martin Winsler wrote: Does anybody have any experience or knowledge of building financial accounting databases? [snip] I too was thinking about building a double entry accounting system and I've been following this thread closely, learning a few tricks on the way :) I've been gathering

Re: [GENERAL] General Ledger db design

2007-02-26 Thread Karl O. Pinc
On 02/26/2007 07:40:17 AM, Kenneth Downs wrote: Karl O. Pinc wrote: On 02/25/2007 06:21:45 PM, Kenneth Downs wrote: Martin Winsler wrote: This is a real world situation where referential integrity needs to be broken in theory, I believe. The problem is that with double entry accounting

Re: [GENERAL] General Ledger db design

2007-02-26 Thread Kenneth Downs
Karl O. Pinc wrote: You can put triggers into the financial transaction detail table that says that the batch id has to be valid if it exists to get your referential integrity right. Right. You can also not allow new rows to be inserted if there is already a batch row, thus the insertion of

Re: [GENERAL] General Ledger db design

2007-02-26 Thread Karl O. Pinc
On 02/26/2007 11:41:18 AM, Kenneth Downs wrote: You can also not allow new rows to be inserted if there is already a batch row, thus the insertion of a batch row closes the batch. Not sure what you mean, but you can in fact have any number of open batches, on the assumption that it is a

Re: [GENERAL] General Ledger db design

2007-02-26 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/26/07 10:35, Filipe Fernandes wrote: [snip] Martin Winsler wrote: Does anybody have any experience or knowledge of building financial accounting databases? [snip] I too was thinking about building a double entry accounting system and

Re: [GENERAL] General Ledger db design

2007-02-26 Thread Filipe Fernandes
Look at SQL-Ledger and LedgerSMB [snip] Ledger SMB (http://www.ledgersmb.org/about/) might be a place to start. Thanks Ron and Brent for the suggestion... very much appreciated. filipe ---(end of broadcast)--- TIP 3: Have you checked our

Re: [GENERAL] General Ledger db design

2007-02-25 Thread Kenneth Downs
Martin Winsler wrote: I hope this isn't too far off topic. I've noticed some discussion about referential integrity, the use of nulls, and database design recently here. This is a real world situation where referential integrity needs to be broken in theory, I believe. Does anybody have

Re: [GENERAL] General Ledger db design

2007-02-25 Thread Karl O. Pinc
On 02/25/2007 06:21:45 PM, Kenneth Downs wrote: Martin Winsler wrote: This is a real world situation where referential integrity needs to be broken in theory, I believe. Does anybody have any experience or knowledge of building financial accounting databases? Am I wrong about this?

[GENERAL] General Ledger db design

2007-02-23 Thread Martin Winsler
I hope this isn't too far off topic. I've noticed some discussion about referential integrity, the use of nulls, and database design recently here. This is a real world situation where referential integrity needs to be broken in theory, I believe. Does anybody have any experience or

Re: [GENERAL] General Ledger db design

2007-02-23 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/23/07 20:35, Martin Winsler wrote: I hope this isn't too far off topic. I've noticed some discussion about referential integrity, the use of nulls, and database design recently here. This is a real world situation where referential