Hi I'd normally have one table with a transaction type ID field. If nothing else, makes it easier to maintain and reporting different transactions means no need for unions.
I suppose this may depend on the amount of transaction maybe, if that were to be millions then you might need to split into different tables for performance possibly. You may need to ensure your key field is ok with an invoice and a payment having the same ref number I also use autonumbers in the parent/detail relationship to keep it simple. Just trying to think, from memory I think Pegasus has different tables for each transaction type (stran, wtran etc) and Sage one table (tran) for all. I'm sure Dom will pick up on that one! Regards Graham -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions Sent: 30 October 2006 13:53 To: Profox Subject: Debits/credits database design I've got a couple small projects to do (hopefully) soon and they deal with customers invoices, payments, and adjustments. Asking those of you who've designed systems with these kinds of needs: do you make a table called "transactions" and just keep all of the data there, having a record identifier to show if it's a payment/debit/adjustment? If not, how have you designed tables to handle this data in the past? Apologies if not enough information there....it's a Monday! ;-) It's just discussion at this point, and nothing concrete. Consider this a "theoretical discussion" on design. tia! --Michael -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
