Solved

Early Payment Discounts

Posted on 2013-01-30
2
200 Views
Last Modified: 2013-02-28
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
Comment
Question by:t3chguy
  • 2
2 Comments
 
LVL 78

Expert Comment

by:arnold
ID: 38836337
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
 
LVL 78

Accepted Solution

by:
arnold earned 500 total points
ID: 38836387
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question