Early Payment Discounts
Posted on 2013-01-30
I'm looking for some advice on how to store early payment discounts in a database table.
Some customers offer 10 net 30 2% some offer 10 net 21 5%, etc.
I was thinking about creating a discounts table, but structuring it is where I'm lost at.
I have a vendors table which would store the ID of the discount, but exactly how would I structure the discounts table to hold all of these different possibilities?