Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Early Payment Discounts

Posted on 2013-01-30
2
199 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 77

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 77

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem with SqlConnection 4 177
problems with mysql ODBC Connector and vbscript 4 38
running code or pseudo code of table structure 5 30
category table 2 30
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

808 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