> ... My percentages of discount are in doubles (as sometimes you have to include a lot of decimal places to meet a final price to the customer), so in every calculation of the total of invoices, orders, ... I have to do the conversion. I think I'm going to change data types in the table definition.
You might consider defining the discount in absolute terms, rather than percentage. One possibility is to have two discount fields, an absolute amount and a percentage; and (for example) if the absolute amount is empty, use the percentage.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)