Quote Vehicle Report

Quotes Vehicle Report

quotes_vehicle_report_format_default

Choose default output format for Quotes / Vehicle tab display.

Setting	Value
Module	qt
Control	quotes_vehicle_report_format_default
Default	Office(xlsx)
Options	Office(xlsx), ExcelXml, Email-send, Text(CSV)

quotes_vehicle_report_attachment_format

Choose default file extension for attaching Dealer Quote Request emails.

Setting	Value
Module	qt
Control	quotes_vehicle_report_attachment_format

Requires dealerquoterequest form setup matching chosen format.

Format Requirements

Global Control	Required Template	Output Format
ExcelXml	dealerquoterequest.xml	xls
Office(xlsx)	dealerquoterequest.xlsx	xlsx
PDF	dealerquoterequest.xlsx	PDF

System Controls: Salary Packaging (sp)

sp_login_access_role

Used in Salary Packaging.

Setting	Value
Module	sp
Control	sp_login_access_role
Default	package_employee

sp_client_packaging_defaults_bank_account_enabled_flag

Set default entry for Clients / Packaging Defaults "Client Bank Account" field.

Setting	Value
Module	sp
Control	sp_client_packaging_defaults_bank_account_enabled_flag
Default	no

sp_client_packaging_defaults_taxable_sales_default

Set default entry for Clients / Packaging Defaults "Taxable Sales" tab.

Setting	Value
Module	sp
Control	sp_client_packaging_defaults_taxable_sales_default
Default	only-fees
Options	only-fees, all-items

sp_employee_package_items_edit_flag

SP employee package items edit flag.

Setting	Value
Module	sp
Control	sp_employee_package_items_edit_flag
Default	1

superannuation_guarantee_rate

Rate used to calculate default Employees / Contact "Employer Super" amount.

Setting	Value
Module	sp
Control	superannuation_guarantee_rate
Default	0.115

Refer to Tax Rates page for control history.

Gb DMZ Upload File Destinations

Table schema for SFTP configuration used by DmzUploadFile scheduler method.

Table Schema

Field	Datatype
dmz_upload_file_destination_id	int(10) unsigned
name	varchar(50) NOT NULL
type	ENUM (sftp) NOT NULL
configuration	BLOB [encrypted]
status_flag	enum('active','inactive')

Configuration Types

Password Authentication

Field	Value
Host	sftp.supplier.com
Port	22
Username	Name
Password	Password

Key Authentication

Field	Value
Host	sftp.supplier.com
Port	22
Username	Name
Key	Password

Key with Encryption

Field	Value
Host	sftp.supplier.com
Port	22
Username	Name
Key	Password
Encryption key_name	keyprovider@encrypt.com.au
Encryption key	encryption key (base64 coded when deployed)

Gb Tables: Import/Export Restrictions

Tables available for import/export can be restricted by updating gb_tables entries. Table also controls sort order in tables list display.

Note: Long-running exports stopped if exceed timeout in gb_controls. File size limits apply to export process.

Restriction Flags and Behaviour

import_flag	export_flag	export_sample_rows_only_flag	Outcome	Comments
yes	yes	no	Can import, export, sample	Default for most tables
yes	yes	yes	Can import, can't export, can sample	Cannot export; only sample allowed
yes	no	no	Can import, can't export, can't sample	Cannot sample; export prevents access
no	yes	yes	Can't import, can't export, can sample	Cannot export; only sample allowed
no	yes	no	Can import, can export, can sample	Some tables set this way
no	no	yes	Can't import, can't export, can't sample	Cannot sample; export prevents access
no	no	no	Can't import, can't export, can't sample	No access

Restricted Tables

Hard-coded tables: modifying settings won't update behaviour. Some restricted to Super role only.

Import Only

Flags	Outcome T	ables
yes / no / yes	Can import, can't export, can sample	qt_variants

No Access (Hard-Coded)

Flags	Outcome	Tables
no / no / no	Can't import, can't export, can't sample	db_sequence_batch_no, db_sequence_interface_batch_no, db_sequence_invoice_no, db_sequence_mail_batch_no, db_sequence_payment_no, gb_api_consumption_log, gb_api_permissions, gb_controls, gb_role_api_permissions, gb_role_api_restrictions, gb_sessions, gb_user_api_restrictions, gb_user_passwords

Export Only (Hard-Coded)

Flags	Outcome	Tables
no / yes / no	Can't import, can export, can't sample	fm_contract_budgets, fm_contract_cost_centre_allocations, fm_contract_division_allocations, fm_contract_driver_allocations, fm_contract_events_imports, fm_service_profiles_import, fm_supplier_client_credit_rating, gb_audit_import, gb_audit_import_archive_201810, gb_enum, gb_event_log, gb_mail, gb_mail_attachments, gb_mail_recipients, gb_mail_recipient_statuses, gb_queries, gb_referrer, gb_role_kpis, gb_role_restrictions, gb_role_user_restrictions, gb_scheduler_job_recipients, gb_screen_resolutions, gb_user_roles, gb_user_role_kpis, gb_web_service_log, pq_model_options, pq_quote_laptop, pq_quote_super, pq_quote_vehicle, pq_quote_vehicle_options, pq_rate_lookup, qt_insurance_loading_rates, qt_insurer_locations_by_postcode, qt_optional_equipment_packs, qt_quote_insurance_disclosures, qt_quote_insurance_loading_types, qt_variant_paints, sl_receipt_imports, sp_uni_card_transactions

Export and Sample (Hard-Coded)

Flags	Outcome	Tables
no / yes / yes	Can't import, can export, can sample	gb_audit, gb_audit_fields, gb_locks, gb_unique_ids, gl_controls