Hi all, It's Monday, caffeine intake is low and I am having a brainfreeze.
I need to keep track of payments made by the client (amount and date), as well as the commissions paid to the sales reps. The reps get paid each time a client makes a payment; ie if the client pays 1000 of his 2000 balance the rep gets a percent of the 1000 not the 2000. That being said, I am on a SQL 2K DB. I thought about having a couple of columns like: Total Cost Invoice Date Invoice Amount Balance Commissions However, I don't want to overwrite the existing data (as this is going to be available for tracking and allowing the reps to print out an intemized view). I am having trouble of thinking about the best way to do this. I don't want to put in a ton of colums (in case they are not used but likewist don't want to put too few). Anyone got any ideas? Thanks! T ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
