Plant Job Supplement (Import)

This import brings in all the other supplement data for a Plant Item. It will populate the 'Plant Details' tab.

The file has to have the following 45 columns:

Column	Column	Name	Description	Data Type	Length	Required	Validated
1	A	Plant Code	Plant Code	Text	20	-1	Yes
2	B	Make	Make	Text	50	0
3	C	Model	Model	Text	50	0
4	D	Registration	Registration	Text	20	0
5	E	Road User Type	Road User Type	Text	20	0
6	F	Road User Class	Road user Class	Text	20	0
7	G	Speedo	Speedo	Integer	Null	0
8	H	Hubo Meter Reg	Hubo Meter Reg	Text	20	0
9	I	Hour Meter Reg	Hour Meter Reg	Text	20	0
10	J	Hubo KM	Hubo KM	Integer	Null	0
11	K	Total Hours	Total Hours	Integer	Null	0
12	L	Radio Make	Radio Make	Text	20	0
13	M	Radio Model	Radio Model	Text	20	0
14	N	Radio Security Code	Radio Security Code	Text	20	0
15	O	Towbar Cert	Towbar Cert	Text	20	0
16	P	Alarmed	Alarmed -1 = Yes, 0 = No	Integer	Integer 05	0
17	Q	VIN	VIN	Text	20	0
18	R	Chassis No	Chassis No	Text	20	0
19	S	Engine	Engine	Text	20	0
20	T	Weight	Weight	Text	20	0
21	U	Transmission	Transmission	Text	20	0
22	V	Tyre Size	Tyre Size	Text	10	0
23	W	Warranty	Warranty	Text	10	0
24	X	Key No	Key No	Text	10	0
25	Y	Air Con	Air Con -1 = Yes, 0 = No	Integer	Integer 06	0
26	Z	Fuel	Fuel	Text	10	0
27	AA	Cab	Cab	Text	10	0
28	AB	Chassis Type	Chassis Type	Text	20	0
29	AC	Colour	Colour	Text	20	0
30	AD	Fuel Card No	Fuel Card Number	Text	20	0
31	AE	Purchase Value	Purchase Value	Number	Null	0
32	AF	Supplier	Supplier ID Number	Integer	Null	0	Yes
33	AG	Sale Date	Sale Date	Date	Null	0
34	AH	Sale Value	Sale Value	Number	Null	0
35	AI	Group Code	Plant Group Code	Text	20	0	Yes
36	AJ	Location	Plant Location	Text	20	0	Yes
37	AK	Drive Type	Drive Type	Text	20	0
38	AL	Driver	Driver Full Name	Text	50	0	Yes
39	AM	Team	Team	Text	20	0
40	AN	Date Pur	Date Pur	Date	Null	0
41	AO	Fleet No	Fleet No	Text	20	0
42	AP	Serial No	Serial No	Text	80	0
43	AQ	Manufacture Date	Manufacture Date	Date	Null	0
44	AR	Plant Class Code	Plant Class Code	Text	10	0
45	AS	Hourly Rate	Hourly Rate	Number	Null	-1	Yes

Notes:

Plant Group Code; Plant Location; Driver; Plant Class were initially imported in the Plant Import. They can be null in this import but where populated they will overwrite the initial import

SupplierID
Put in the Company ID number from the Company Maintenance.

Hourly Rate
This field has to be filled in the spreadsheet. It cannot be null. Generally you will not enter the hourly rate in the Plant Details tab so just put '0' in the spreadsheet.

Date Fields
Entry of the three Date Fields should be dd/mm/yyyy