Section E - Import Fields Available (Vehicles)

Modified on Tue, 21 Dec, 2021 at 2:14 PM

Section E - Mileage allowance (Privately Owned Vehicles)

Before you can allocate mileage to an employee, that employee needs to have a vehicle to which to attach the mileage. Private vehicles do not need to be unique, so you can create generic vehicles (like MILEAGE or LUMPSUM).

Full Description	Database Field	Data Type	Char Limit	Inclusion	Pre-Format
Cubic Capacity	CC	Numeric	4	Compulsory
Car Description	DESCRIPTIO	Character	50	Compulsory
Optional Extras	EXTRAS	Numeric	10	Not Required
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
Number	NI_NUMBER	Character	10	Optional	Check only
Payroll Number	PAYROLL	Character	20	Optional	Check only
List Price	PRICE	Numeric	10	Not Required
Date car first registered	REGISTERED	Date	8	Not Required
Registration Number	R_NUMBER	Character	10	Key field