vin
registration
make
model
year
colour
odometer
first_registered
last_serviced
price
flat_rate
7A8DH1E0701123456
NFO214
Holden
Barina
1999
Green
225271.8
1999-05-23
2013-11-18
2999
20
7A8DH1E0701654321
DEF234
Subaru
Impreza
2004
Silver
95431.5
2004-08-06
11995
50
7A8DH1E0701341652
GEF20
BMW
M3
2008
Black
45500
2008-04-14
2014-02-10
45995
200
customer_id
firstname
lastname
address
phone
email
credit_rating
comments
234567
Russell
Sang
74 Patmos Avenue
02139414116
rsang@example.nz
A
A-grade customer.
234569
Helen
Patrick
28 Cherry Drive
02137254888
helen_patrick@foo.bar.nz
D
234568
Stephanie
Torrence
21 Elwyn Crescent
02737076169
stef_1234@example.com
Has she bought anything yet?
234570
Clifford
Johns
45 Pine Hill Road
02136507402
mobycat@frabjous.co.nz
C
Talks a lot.
234571
William
Charles
34 Scobie Road
02232104933
B
staff_id
firstname
lastname
address
phone
date_hired
date_of_birth
4567
Sang
Dyson
74 Patmos Avenue
02139414116
2008-12-05
1979-06-17
4569
Patricia
Kwak
28 Cherry Drive
02137254888
2012-04-23
1967-08-08
4568
Teresa
Soto
21 Elwyn Crescent
02737076169
2005-06-04
1992-12-25
4570
John
Reed
45 Pine Hill Road
02136507402
2013-08-13
1985-05-21
4571
Charles
Barajas
34 Scobie Road
02232104933
2001-11-09
1964-09-15
staff_id
on_commission
commission_rate
gross_earnings
4567
##TRUE_VALUE##
0.15
12345.67
4569
##FALSE_VALUE##
0
12345.67
purchase_id
purchase_date
details
amount
vin
customer_id
salesrep_id
1234567890
2014-01-10
Blah blah blah
29995
7A8DH1E0701123456
234567
4567
1234567891
2014-01-25
Blah blah blah
45995
7A8DH1E0701654321
234568
4569
1234567892
2014-02-15
Blah blah blah
36950
7A8DH1E0701341652
234569
4567