Lookup tables in FleetWave provide the options available to users when they click on specific dropdown fields in Add/Edit/View screens - the field 'looks up' what's in the table to populate the dropdown list.
Check out the video:
For example, if you navigate to the Body Types table under Vehicles, you'll see records for Saloon, Hatchback etc. And then when you're adding a vehicle the 'Body Type' dropdown field will contain these same values to select from.
Many of these tables are available on the menu bar so that you can configure the dropdown values to meet your needs by adding or removing records. Some tables will not contain any data when you first login to your FleetWave site, so we recommend establishing your lookup tables as one of the first tasks to getting started - see the table below for a list of empty lookup tables.
Most lookup tables are within their specific module in the menu bar, however, there are some instances where a dropdown field is used across multiple modules. This is primarily the hierarchy tables, and these can be found under the Account menu item.
All lookup tables require a 'Code' and a 'Description' as a minimum. The code is the value stored at database level and is usually either a number sequence, such as 001, 002, 003 etc. or an abbreviation, such as UL for unleaded fuel. The description is what the user will see on screen in the dropdown field. Many of the tables won't ask for any other details than this, but a few provide the option to add additional information that lends itself to functionality elsewhere in the system, which is explained below.
The table below lists all the module-specific lookup tables provided in FleetWave, with a brief description of the purpose of each table and whether it is supplied with data or blank:
|
Module |
Table |
Purpose | Data |
|
Vehicles |
Manufacturers |
Supplies the values for the 'Make' field on the Models and Vehicles screens. | Yes |
|
Vehicles |
Models |
Supplies the values for the 'Model' field on the Vehicles screen. Can set standard model details, such as fuel type and tank size, which will pull through when adding a vehicle and selecting the model. Can also set targets for the model relating to performance, efficiency and cost. |
Yes |
| Vehicles | Body Types | Supplies the values for the 'Body Type' field on the Vehicles screen. | Yes |
| Vehicles | Vehicle Types |
Supplies the values for the 'Vehicle Type' field on the Body Types, Models and Vehicles screens. Can set standard replacement details against specific vehicle types. |
Yes |
| Vehicles | Transmission | Supplies the values for the 'Transmission' field on the Vehicles screen. | Yes |
| Vehicles | Economy Label | Supplies the economy label that visually demonstrates a vehicle's emissions based on its CO₂ g/km, which is used on the Vehicles screen and Emissions Report. | Yes |
| Vehicles | Vehicle Sale Reasons | Supplies the values for the 'Sale Reason' field on the Vehicles screen. | Yes |
| Drivers | Driver Categories | Supplies the values for the 'Driver Category' field on the Drivers screen. | No |
| Drivers | Driver Roles | Supplies the values for the 'Driver Role' field on the Drivers screen. | No |
| Drivers | Training Courses | Supplies the values for the 'Training Course' field on the Driver Training screen. | No |
| Drivers | Training Providers | Supplies the values for the 'Training Provider' field on the Driver Training screen. | No |
| Allocations | Allocation Reasons | Supplies the values for the 'Allocation Reason' field on the Reallocation Tool screen. | Yes |
| Maintenance | Job Reasons | Supplies the values for the 'Job Reason' field on the Maintenance and Job Events screens. | Yes |
| Maintenance | Service Types | Supplies the values for the 'Service Type' field on the Maintenance screen. | No |
| Maintenance | Job Events/Triggers | Supplies the values for the 'Reason' field on the Vehicle Service Events screen. | Yes |
|
Fuel |
Fuel Types | Supplies the values for the 'Fuel Type' field on the Fuel, Fuel Keys/Cards, Models, Economy Label and Vehicles screens. | Yes |
| Fuel | Fuel Families | Supplies the values for the 'Fuel Family' field on the Fuel Types screen. | Yes |
| Accidents | Accident Reasons | Supplies the values for the 'Accident Reason' field on the Accidents screen. | Yes |
| Accidents | Road Condition | Supplies the values for the 'Road Condition' field on the Accidents screen. | Yes |
| Accidents | Weather | Supplies the values for the 'Weather' field on the Accidents screen. | Yes |
| Costing | Costing Codes | Supplies the values for the 'Costing Code' field on the Costing screen. | No |
| Costing | Costing Families | Supplies the values for the 'Costing Family' field on the Costing Codes screen. | Yes |
| Costing | Tax Rates | Supplies the values for the 'Tax Rate' field on multiple screens. | Yes |