Reference Data qt variants Detail

Reference Data: Qt Variants Detail

Header

Filter	Type	Description
Variant ID	Number	Shows the selected record. Use the lookup to find another record or go back to the List tab
View Edit History	Button	Click to open the Audit History pop-up to review changes made on the selected record

Series

Vehicle Type (Text) - This field stores the vehicle type that has been allocated by RedBook or Glass during the data import process. Do not edit this field. This field is shown in quotes as Quotes / Vehicle Specifications "Variant Vehicle Type".

Engine Code

Power Plant Type (Drop List) - If your Vehicle data is supplied by RedBook, and you have subscribed to their 'POWERPLANTTYPE' field, this field will be populated when importing RedBook data.

Acceleration

Battery Capacity (Kwh) (String) - The maximum capacity of the High Voltage Battery in kWh. If your Vehicle data is supplied by RedBook, and you have subscribed to their 'HVBatteryCapacity' field, this field will be populated when importing RedBook data.

Battery Charge Socket Type (String) - Standard plug type for the main HV battery charge port. If your Vehicle data is supplied by RedBook, and you have subscribed to their 'HVBatteryChargeSocketType' field, this field will be populated when importing RedBook data.

Battery AC Charge Outlet (String) - The specification of the socket type for Normal Charge Time. If your Vehicle data is supplied by RedBook, and you have subscribed to their 'HVBatteryACChargeOutletDesc' field, this field will be populated when importing RedBook data.

Battery AC Fast Charge (String) - The specification of the AC fast charge system for AC Fast Charge Time. If your Vehicle data is supplied by RedBook, and you have subscribed to their 'HVBatteryACFastChargeDesc' field, this field will be populated when importing RedBook data.

Battery DC Fast Charge (String) - The specification of the DC fast charge system for DC Fast Charge Time. If your Vehicle data is supplied by RedBook, and you have subscribed to their 'HVBatteryDCFastChargeDesc' field, this field will be populated when importing RedBook data.

Battery Warranty Years (String) - The number of years for which the High Voltage Battery is warranted against degradation to a given capacity. If your Vehicle data is supplied by RedBook, and you have subscribed to their 'HVBatteryWarrantyYears' field, this field will be populated when importing RedBook data.

Battery Warranty Kms (String) - The number of km the High Voltage Battery warranty covers (-1 = Unlimited). If your Vehicle data is supplied by RedBook, and you have subscribed to their 'HVBatteryWarrantyKM' field, this field will be populated when importing RedBook data.

Electric Engine Km Range (String) - Pure electric driving range in km (WLTP standard). If your Vehicle data is supplied by RedBook, and you have subscribed to their 'KMRangeElectricEngWLTP' field, this field will be populated when importing RedBook data.

Energy Consumption (Wh/Km) (String) - The vehicle's electricity consumption per km as measured under testing standards (in Wh/km). If your Vehicle data is supplied by RedBook, and you have subscribed to their 'EnergyConsumption' field, this field will be populated when importing RedBook data.

Fuel

Fuel Type - This is linked to the qt_fuel_type_translations table using the data source field, so there need to be entries in that table to match the data source for the variant.

Fuel Combined - Default fuel consumption rate used in the Quotes / Lease Fuel profile to calculate the fuel budget.

CO2 Emissions - This is used in the ACT Purchase Stamp Duty calculation and also in one of the Carbon Emissions Offset (CEO) budget calculations.

Qt Variant Dealer Discounts

This table stores each variant's dealer discount.

This table links each variant to a client and/or supplier to default in and calculate any available discounts.

More information on how this works is available on the Quotes / Vehicle screen where the value is entered and stored.

Filters

Filter	Type	Description
Make	Drop List	Select a make
Model	Drop List	Select a model
Model Year	Drop List	'--All--' is the default filter. Choose a model year to narrow your search
Variant	Drop List	'--All--' is the default filter. Choose a variant to see the Variant ID
Supplier Code	Text	Enter or Search for the Supplier Code of the Dealer the Discount is to be applied against
Client Code	Text	Enter or Search for the Client Code that the Dealer Discount is linked to
Variant ID	Number	You can enter a Variant ID directly to see that variant. The Variant ID will be displayed if a variant has been selected
Last Effective Date	Check Box	This is selected by default to display the most recent record for each of the Variants/Models (when Model Year = "--All--")
View Edit History	Button	The Variant ID must be entered to display the Audit History window. This will display any and what changes have been made to Variant Dealer Discount profile

Field Descriptions

Field	Type	Description
ID	Number	Shows the Variant Dealer Discount ID
Variant Code	Text	Variant code
Variant	Text	A description of the selected Variant
Discount Type	Text	Links to qt_discount_types
Supplier	Number	Links to fm_suppliers and is represented as the 'Preferred Dealer'
Client	Number	Links to fm_clients
Discount $	Number	The amount entered is the value that will default into the quote when the Variant / Supplier / Client combination are selected
Effective Date	Date	Date when discount becomes effective

Action Buttons

Button	Description
View	Click to view the displayed records
Edit	Click to edit the displayed records
New	Click to create a new profile record
Save	When you have finished editing the record, click to save
Cancel	Cancel if you do not want to save your current edits

Validations and Alerts

Alert	Comments
Invalid Supplier Code	The entered Supplier Code does not exist
Invalid Client Code	The entered Client Code does not exist
Invalid Date! You must enter a valid date as DD/MM/YYYY, or leave it blank	An invalid date has been entered
Not Found	The entered Make / Model does not have any Dealer Discount entries
A Variant ID must be selected to view audit history	A Variant ID must be entered with dealer discount data to enable the Audit History window to display any historical changes

Qt Variant Optional Equipment

This table links the optional equipment (using descriptions and codes from qt_optional_equipment) to individual variants.

Filters

Filter Name	Type	Description
Make	List	Defaults to --Please Select-- or you can select a Make
Model	List	Defaults to --Please Select-- or you can select a Model
Model Year	List	Defaults to --All-- or you can select a Model Year
Variant	List	Defaults to --All-- or you can select a Variant
Variant ID	Text	Enter a Variant ID and use "Tab" on your keyboard to load the Variant's Optional Equipment
Option Code	Text	Enter an Option Code and use "Tab" on your keyboard to load the Optional Equipment for the Variant/s
Supplier Code	Text	Enter Supplier Code and use "Tab" on your keyboard to load the Optional Equipment for the Variant/s
Status	List	Defaults to --All-- or you can select a Status (active or inactive)

Field Descriptions

Year (Text) - Model Year

Variant (Text) - Mouse over Variant to see the Variant Code

Option Code (Text) - Optional Equipment Code

Option Description (Text) - Optional Equipment description

Supplier Code (Text) - Supplier for the Option

I (Check Box) - If the feature is configured by your business, you can check this field and the option will be added to new quotes automatically. Visit the Quotes / Options Include by Default page for more details on this feature

Residual $ (Number) - Residual value of the Option

Cost Net (Number) - Cost price ex GST of the Option

Price Net (Number) - Price ex GST of the Option

Price GST (Number) - GST price of the Option

Price Gross (Number) - Gross price of the Option

Type (List) - Choose from factory, dealer or aftermarket. 'Aftermarket' options (for example: rust proofing, navigators etc) can be used for options fitted at the dealership or after delivery. The cost price indicates the cost to you and the list price the price to the customer, the difference being a margin. If options are set to 'aftermarket' they appear in their own section on the Options box on the quote/vehicle screen

DF (Check Box) - Yes or No

Status (List) - Must be active to be selectable on a quote

Validations and Alerts

Alert	Comments
Table {tablename} already locked by user: {userlogin}	The table cannot be edited while another user is editing it. Wait and try again later. Visit System Locks for more details

Qt Variant Profiles

This table stores each variant's profile.

This table links each variant to various profiling tables to be used primarily in quote budget calculations.

An example of how a profile might be structured is shown in the Quote Profiles page.

Filters

Field	Type	Description
Make	Drop List	Select a make
Model	Drop List	Select a model
Model Year	Drop List	'--All--' is the default filter. Choose a model year to narrow your search
Variant	Drop List	'--All--' is the default filter. Choose a variant to see the Variant ID
Variant ID	Number	You can enter a Variant ID directly to see that variant. The Variant ID will be displayed if a variant has been selected

Field Descriptions

ID (Number) - Shows the Variant Profile ID

Variant

Service Profile - Store the default Quotes / Lease Maintenance "Profile Name" here

Tyre Code - Store the default Quotes / Lease Tyres "Tyre Code" here

Tyres / Set - Store the default Quotes / Lease Tyres "Tyres per Set" here

Tyre Interval - Store the default Quotes / Lease Tyres "Interval KMs" here. Example: Replace tyres every 40,000 kms

Vehicle Type (Text) - This field is shown in quotes as Quotes / Vehicle Specifications "Profile Vehicle Type". The "Profile Vehicle Type" hyperlinks to this record. This field is normally updated by a scheduler script. It can be updated in this screen if a correction is needed

Delivery Metro - Default dealer delivery fee

RV Margin

Insurance Type (Drop List) - Choose or update the insurance type to use in quotes for this variant. It displays the qt_insurance_types. Bulk update of this field can be performed using the Vehicle to Insurance Type classification mapping process

Action Buttons

Button	Description
View	Click to view the displayed records
Edit	Click to edit the displayed records
New	Click to create a new profile record
Save	When you have finished editing the record, click to save
Cancel	Cancel if you do not want to save your current edits

Validations and Alerts

Alert	Comments
Table {tablename} already locked by user: {userlogin}	The table cannot be edited while another user is editing it. Wait and try again later. Visit System Locks for more details
Invalid Vehicle Type	The entered Vehicle Type does not exist. Use the Search function to find available Types