<div>
Presumably your table includes an internal discount field along with a payment field.<br />
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
I'm looking for some advice on how to store early payment discounts in a database table.<br />
<br />
Some customers offer 10 net 30 2% some offer 10 net 21 5%, etc.<br />
<br />
I was thinking about creating a discounts table, but structuring it is where I'm lost at.<br />
<br />
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?
</div>
</div>


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?

Early Payment Discounts

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.