Section F - Import Fields Available (Cars)

Modified on Wed, 22 Dec, 2021 at 9:58 AM

Vehicles - Company Car Details

Full Description	Database Field	Data Type	Field Length	Inclusion	Pre-Format
Cubic Capacity	CC	Numeric	4	Compulsory
Grams of CO2 per Km	CO2	Numeric	4	Compulsory
Car Description	DESCRIPTIO	Character	50	Compulsory
Optional Extras	EXTRAS	Numeric	10	Optional
Fleet Number	FLEETNO	Character	15	Optional
Type of Fuel	FUEL	Character	10	Compulsory	HMRC Fuel Types D = Diesel F = Euro6d (RDE2) Diesel A = All Other V5 Fuel Types F = Euro 6d F = (RDE2) Diesel D = Diesel D = Euro 4d A = Petrol A = Electric A = Hybrid Petrol A = Hybrid Diesel A = LPG A = Retrofit A = Ethanol
National Insurance Number	NI_NUMBER	Character	10	Optional	Only for records checking
Car has no CO2 rating	NOAPPCO2	Character	3	Optional
Payroll Number	PAYROLL	Character	20	Optional	Only for record checking
List price of car	PRICE	Numeric	10	Compulsory
Mileage Range on Battery	RANGE	Numeric	4	Optional / Compulsory	Required for ULEV cars 1-50 g/km wef April 2020)
Date Car Registered	REGISTERED	Date	8	Compulsory	dd/mm/yyyy
Registration Number	R_NUMBER	Character	10	Key field