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_at_news.aaisp.net.uk>
Customers are charged for a service (a training course) and at the moment always plus VAT.
Date: Thu, 3 Aug 2006 20:23:53 +0100
Message-ID: <44d24d4a$0$632$5a6aecb4_at_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 - 21:23:53 CEST