• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

Early Payment Discounts

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?
0
t3chguy
Asked:
t3chguy
  • 2
1 Solution
 
arnoldCommented:
Presumably your table includes an internal discount field along with a payment field.
You would then determine whether the payment is early and what discount applies to populate the discount column while entering the amount paid into the ament column.
0
 
arnoldCommented:
Missed the question, you would associate a vendor id with a discountid. Presumably you can not group discounts
I.e. have a shared discounts. The dilemma is which will have more rows, the population of every possible discount option that each vendor will select.
I.e. if you only have a limited set of discount options, you can limit the vendor to selecting one of the discount options.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now