vinregistrationmakemodelyearcolourodometerfirst_registeredlast_servicedpriceflat_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_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 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_idon_commissioncommission_rategross_earnings 4567 ##TRUE_VALUE## 0.15 12345.67 4569 ##FALSE_VALUE## 0 12345.67
sale_idsale_datedetailsamountvincustomer_idsalesrep_idw_codetradein_id 12345678 2014-01-10 Blah blah blah 29995 7A8DH1E0701123456 234567 4567 D 12345680 2014-02-15 Blah blah blah 36950 7A8DH1E0701341652 234569 4567 B 12345679