VAT rate or VAT amount as a column?

From: Emily Jones <emilyj_at_hotmail.com>
Date: Thu, 3 Aug 2006 20:23:53 +0100
Message-ID: <44d24d4a$0$632$5a6aecb4@news.aaisp.net.uk>

Customers are charged for a service (a training course) and at the moment always plus VAT.

At the moment I've got, something like:

CustomerCourse:
ID, name, ... Fee, Vat

where vat is an amount calculated using the current rate. I'm not storing the total, as that's derived.

Maybe I should store the VAT as a %, because the amount is really derived. And if I've got the capability to have a different VAT rate for each CustomerCourse record, then there's the flexibility that I might need, if, for instance there is a reason to charge a particular customer a different rate of VAT.

Opinions please.

Emily Jones Received on Thu Aug 03 2006 - 14:23:53 CDT