Angle Field Mappings

Corporate Type

Field location: Fleet / Administration / Clients / Contact page.

Angle Finance field name: entityType

Corporate Type field mapped to entityType. Below are accepted values by Angle Finance.

Accepted Values

entityType

Partnership

ProprietaryLimitedCompany

Trust

Government

Other

LimitedCompany

Mappings

Catch-e Corporate Type options mapped to Angle Finance:

Catch-e	Angle Finance
Australian Company - Public	LimitedCompany
Australian Company - Private	ProprietaryLimitedCompany
Foreign Unregistered Company - Public	LimitedCompany
Foreign Registered Company - Public	LimitedCompany
Government Entity	Government
Individual	Other
Trust - Private	Trust
Incorporated Association	Other
Cooperative	Other
Partnership	Partnership
Foreign Registered Company - Private	ProprietaryLimitedCompany
Sole Trader	Other
Trust - Regulated	Trust
Unincorporated Association	Other
Foreign Unregistered Company - Private	ProprietaryLimitedCompany

Mapping Updates

If Angle modify list by adding field name options or removing existing values, refer Mapping Updates process pages.

Useful Queries

Angle Interface Mappings

select tif.table_name, tif.field_name, tift.field_value, tif.interface_field_name, tift.interface_value from qt_interface_fields as tif left join qt_interface_field_translations as tift on tift.interface_field_id = tif.interface_field_id left join fm_driver_employment_types as det on det.driver_employment_type_code = tift.field_value where tif.interface_type = 'angle' and tif.interface_field_name = 'entityType' and tift.status_flag = 'active';

Corporate Type with Angle Mapping

select ct.corporate_code, ct.description as corporate_type, st1.interface_value from gb_corporate_types as ct left join (select tif.table_name, tif.field_name, tift.field_value, tif.interface_field_name, tift.interface_value from qt_interface_fields as tif left join qt_interface_field_translations as tift on tift.interface_field_id = tif.interface_field_id left join fm_driver_employment_types as det on det.driver_employment_type_code = tift.field_value where tif.interface_type = 'angle' and tif.interface_field_name = 'entityType' and tift.status_flag = 'active') as st1 on st1.field_value = ct.corporate_code ORDER BY ct.description;

Fees

Fee fields mapped to Angle Finance. Below are accepted fee field mappings.

Default Mapping

Default mapping of Catch-e Broker Fees to Angle Finance:

Broker Fee	Angle Field
establishment_fee	ESTFEENL
originator_fee	ORIGFEE

Inverted Mapping

Alternative mapping if applying field values differently:

Broker Fee	Angle Field
establishment_fee	ORIGFEE
originator_fee	ESTFEENL

Useful Queries

Angle Fee Mappings

select tif.* from qt_interface_fields as tif where tif.interface_type = 'angle' and tif.table_name = 'qt_quotes' and tif.interface_field_name IN ('ESTFEENL','ORIGFEE');

Fuel Type

Field location: Quotes / Vehicle Specifications "Fuel Type" field.

Angle Finance field name: fuelType

Fuel Type mapped to fuelType. Below are accepted values by Angle Finance.

Accepted Values

fuelType

Petrol

Diesel

Hybrid

LPG

CNG

Electric

CNG+Others

DIESEL

DIESEL/ELECTRIC

ELECTRIC

HYDROGEN/ELECTRIC

LEADED PETROL

LIQUID PETROLEUM GAS

NOT PROVIDED

PREMIUM UNLEADED/ELECTRIC

PREMIUM UNLEADED PETROL

UNLEADED PETROL

UNLEADED PETROL/ELECTRIC

ELECTRIC/PULP

Default Mapping

Default system mapping. Review and update to suit system data.

Fuel Type	fuelType
null	NOT PROVIDED **
CNG	CNG
Diesel	Diesel
Dual Fuel	PREMIUM UNLEADED/ELECTRIC
Electric	Electric
Hybrid	Hybrid
LPG	LPG
Petrol	Petrol
PULP	PREMIUM UNLEADED PETROL
ULP	UNLEADED PETROL

** If no other mapping matches, null mapping record applied.

Mapping Updates

If Angle modify list by adding field name options or removing existing values, refer Mapping Updates process pages.

Useful Queries

Fuel Type Values

select tif.interface_type, tif.interface_field_name, interface_value, tif.table_name, tif.field_name, tift.field_value from qt_interface_field_translations as tift inner join qt_interface_fields as tif on tif.interface_field_id = tift.interface_field_id and tif.interface_type = 'angle' and tif.interface_field_name = 'fuelType' ORDER BY tift.interface_value;

Fuel Type List with Mappings

select ftt.fuel_type_external_code, ftt.fuel_type_code, st1.interface_value, st1.interface_field_name, st1.interface_type, st1.table_name, st1.field_name, st1.field_value from qt_fuel_type_translations as ftt left join (select tif.interface_type, tif.interface_field_name, interface_value, tif.table_name, tif.field_name, tift.field_value from qt_interface_field_translations as tift inner join qt_interface_fields as tif on tif.interface_field_id = tift.interface_field_id and tif.interface_type = 'angle' and tif.interface_field_name = 'fuelType') as st1 on st1.field_value = ftt.fuel_type_code order by st1.field_value, ftt.fuel_type_external_code;

Gender

Field location: Drivers / Contact tab.

Angle Finance field name: gender

Gender field mapped to gender. Below are accepted values by Angle Finance.

Accepted Values

gender

Male

Female

Unknown

Mappings

Catch-e Gender options mapped to Angle Finance:

Gender	Angle - gender
Female	Female
Male	Male
Other	Unknown
null	Unknown

Mapping Updates

If Angle modify list by adding field name options or removing existing values, refer Mapping Updates process pages.

Useful Queries

Angle Mapping

select tif.table_name, tif.field_name, tift.field_value, tif.interface_field_name, tift.interface_value from qt_interface_fields as tif left join qt_interface_field_translations as tift on tift.interface_field_id = tif.interface_field_id where tif.interface_type = 'angle' and tift.status_flag = 'active' and tif.field_name = 'gender' order by tif.table_name, tif.field_name, tift.interface_value;

Industry

Field location: Fleet / Administration / Clients / Contact page.

Angle Finance field name: industry

Industry field mapped to industry. Industry definitions based off Australian and New Zealand Standard Industrial Classification (ANZSIC codes).

Refer https://www.ato.gov.au/calculators-and-tools/business-industry-code-tool-anzsic-coder for more information.

Note: Can reference ANZSIC Code to enter in "SIC Code" field below Industry in Catch-e. SIC Code mandatory field for Angle Finance.

Default Mapping

Default mapping selects 'T999999' for all records and passes into JSON file.

To return stored client codes in JSON file, map codes to format accepted by Angle.

Interface Type	Interface Field Name	Table Name	Field Name	Field Value	Interface Value
angle	industry	fm_client_industries	client_industry_code	NULL	T999999

Useful Queries

Angle Interface Mappings

select tif.table_name, tif.field_name, tift.field_value, tif.interface_field_name, tift.interface_value from qt_interface_fields as tif inner join qt_interface_field_translations as tift on tift.interface_field_id = tif.interface_field_id where tif.interface_type = 'angle' and tif.interface_field_name = 'industry' and tift.status_flag = 'active';

Industry Type

select cli.client_industry_code, st1.interface_value from fm_client_industries as cli left join (select tif.table_name, tif.field_name, tift.field_value, tif.interface_field_name, tift.interface_value from qt_interface_fields as tif left join qt_interface_field_translations as tift on tift.interface_field_id = tif.interface_field_id left join fm_driver_employment_types as det on det.driver_employment_type_code = tift.field_value where tif.interface_type = 'angle' and tif.interface_field_name = 'industry' and tift.status_flag = 'active') as st1 on st1.field_value = cli.client_industry_code where cli.status_flag = 'active';

Marital Status

Field location: Drivers / Finances tab.

Angle Finance field name: relationshipStatus

Marital Status field mapped to relationshipStatus. Below are accepted values by Angle Finance.

Accepted Values

relationshipStatus

Married

Separated

Divorced

Single

DeFacto

Widowed

Unspecified

Mappings

Catch-e Marital Status options mapped to Angle Finance:

Marital Status	Angle - relationshipStatus
null	Unspecified
De Facto	DeFacto
Divorced	Divorced
Married	Married
Other	Unspecified
Separated	Separated
Single	Single
Widowed	Widowed

Mapping Updates

If Angle modify list by adding field name options or removing existing values, refer Mapping Updates process pages.

Useful Queries

Angle Mapping

select tif.table_name, tif.field_name, tift.field_value, tif.interface_field_name, tift.interface_value from qt_interface_fields as tif left join qt_interface_field_translations as tift on tift.interface_field_id = tif.interface_field_id where tif.interface_type = 'angle' and tift.status_flag = 'active' and tif.field_name = 'marital_status' order by tif.table_name, tif.field_name, tift.field_value;

New or Used

Field location: Quotes / Vehicle page "New or Used" field.

Angle Finance field name: assetCondition

New or Used field mapped to assetCondition. Below are accepted values for Angle Finance.

Accepted Values

assetCondition

Demo

New

Used

Mappings

Catch-e New or Used options mapped to Angle Finance:

New or Used	assetCondition
Demonstrator	Demo
New	New
Used	Used

Mapping Updates

If Angle modify list by adding field name options or removing existing values, refer Mapping Updates process pages.

Notes

All interface field mappings stored in [qt_interface_fields] table
Field translations stored in [qt_interface_field_translations] table
Mapping updates required if Angle Finance adds or removes field values
Status flag 'active' indicates mapping is currently in use
Some fields support null/empty value default mappings
Review default mappings and customise as needed for system data