vinregistrationmakemodelyearcolourodometerfirst_registeredlast_servicedpriceflat_rate 7A8DH1E0701123456 NFO214 Holden Barina 1999 Green 225271.8 23-MAY-1999 18-NOV-2013 2999 20 7A8DH1E0701654321 DEF234 Subaru Impreza 2004 Silver 95431.5 06-AUG-2004 11995 50 7A8DH1E0701341652 GEF20 BMW M3 2008 Black 45500 14-APR-2008 10-FEB-2014 45995 200 customer_idfirstnamelastnameaddressphoneemailcredit_ratingcomments 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_idfirstnamelastnameaddressphonedate_hireddate_of_birth 4567 Sang Dyson 74 Patmos Avenue 02139414116 05-DEC-2008 17-JUN-1979 4569 Patricia Kwak 28 Cherry Drive 02137254888 23-APR-2012 08-AUG-1967 4568 Teresa Soto 21 Elwyn Crescent 02737076169 04-APR-2005 25-DEC-1986 4570 John Reed 45 Pine Hill Road 02136507402 13-AUG-2013 21-MAY-1985 4571 Charles Barajas 34 Scobie Road 02232104933 09-NOV-2001 15-SEP-1964 staff_idon_commissioncommission_rategross_earnings 4567 ##TRUE_VALUE## 0.15 12345.67 4569 ##FALSE_VALUE## 0 12345.67 w_codemax_agemax_kmdurationdistancenotes A 4 50000 3 5000 Category A motor vehicle B 6 75000 2 3000 Category B motor vehicle C 8 100000 1 1500 Category C motor vehicle D 0 0 Category D motor vehicle purchase_idpurchase_datedetailsamountvincustomer_idsalesrep_id 12345678 10-JAN-2014 Blah blah blah 29995 7A8DH1E0701123456 234567 4567 12345679 25-JAN-2014 Blah blah blah 45995 7A8DH1E0701654321 234568 4569 sale_idsale_datedetailsamountvincustomer_idsalesrep_idw_codetradein_id 12345678 10-JAN-2014 Blah blah blah 29995 7A8DH1E0701123456 234567 4567 D 12345680 15-FEB-2014 Blah blah blah 36950 7A8DH1E0701341652 234569 4567 B 12345679