The Franchise Model Cross-Reference form is accessed via Fleet System Management / Kerridge Utilities / Maintain Model Cross-Reference and is used to cross reference Rev 6 model codes with Rev 8 model codes within a Rev 6 to Rev 8 conversion. The data is written to the Fleet Management ddxrf file.
This table does not have to be manually maintained as both the Rev 6 and Rev 8 model code files are maintained within the David Henley System which may be used to populate this table. The table is subsequently accessed and used within the conversion process itself.
Warning: It is important that this table contains the most up-to-date possible data prior to running the conversion routine.
The form is split into three areas. These are the Titlebar, the Franchise Model Cross-Reference Record Table and the column of Command Buttons at the bottom of the form.
In addition to displaying the form name the Title Bar provides a number of useful buttons.
This form displays a record table of all the current vehicle variant codes.
The unique Rev6 variant code (maintained by DHS) for example, AL1630LP4S .
The Rev6 twenty-five character alphanumeric textual description for the vehicle variant for example, ALFA 164 3.0 V6 LUSS .
The associated Rev6 Franchise Data Franchise code for the vehicle. This is not a required field.
The associated Rev6 Franchise Data Model code for the vehicle. This is not a required field.
The unique Rev8 variant code (maintained by DHS) to be cross-reference against the Rev6 variant code in the first column.
The list displays up to a maximum of twenty five variant code records at any one time. To view the remaining records the Scroll Bar to the right of the form can be operated in a number of ways:
To edit the variant code record table a single-right-click of the mouse in any of the columns displays a small menu box with the following options:
- Edit Row
Enables the values in the selected row/record to be edited.
- Copy
Enables the variant code value for one record to be copied to other records.
- Filter
Displays a Selection Criteria Box which enables selection of only those records meeting the selection criteria for the column upon which the filter is selected to operate. The following mutually exclusive selection criteria option buttons/fields are available:
- Equals
Searches the selected column for a description matching that entered in the data entry box at the bottom of the form. Any records equaling the criteria are displayed.
- Not Equal
Searches the selected column for a description matching that entered in the data entry box at the bottom of the form. Any records equaling the criteria are not displayed.
- Greater Than
Searches the selected column for any records with a text character string which is alphabetically higher than the character(s) entered in the data entry box at the bottom of the form. Any records greater than the criteria are displayed.
- Less Than
Searches the selected column for any records with a text character string which is alphabetically lower than the character(s) entered in the data entry box at the bottom of the form. Any records less than the criteria are displayed.
- Contains
Searches the selected column for any records with a text character string containing the character(s) entered in the data entry box at the bottom of the form. Any records meeting the criteria are displayed.
- Range
Searches the selected column for any records with a text character string which is alphabetically equal to or between the character(s) entered in the two data entry box at the bottom of the form. Any records meeting the criteria are displayed.
- No Filter
No filter is applied to the record search. The Reset command button also activates the "No Filter" option.
A number of command buttons are available. Some buttons are context sensitive and are dimmed and only become available dependent upon the particular process that is being accessed. The full list of command buttons is as follows:
Exits the Franchise Model Cross-Reference form and returns to the Kerridge Utilities Menu .
Provides online access to a context sensitive Help form.
Sorts the records by the chosen keypath. Upon selection, a Keypath List Box is displayed from which the appropriate keypath (if there is more than one) is selected.
A check box that, when selected, sorts the records in descending order.
Redisplays the records on the form with any new modifications.
A check box that, when selected, automatically redisplays all records on the form after an amendment.
Restricts a Sort by allowing entry of a text string for the agreement number from which to start.
Restricts a Sort by allowing entry of a text string for the agreement number at which to finish.
The purpose of this field is to allow the display of a user-defined selection of fields for every record. This is intended to reduce data entry errors.
Selection of this button displays a further form that provides an Ad-hoc Report Generator for the creation of quick query reports to form. An enquiry is formulated by completing a simple set of verbs and field names. A saved formulated query can be retrieved for future use.
Displays each field in a record by row, with the field name in the left-hand column and the field data in the right hand column. Within this option, records may be created, amended or deleted.