Enquiry Operator Request template fields

To get value of listed below items they should be put in template in format: $ { item } (without spaces)

Item:

Value

subjDate

04 - 05 Jan 2017

subjPath

ABM-WYA-CNS

paxmax

8



-------------------------------------------------------------------------------------------------------------
operator Object
-------------------------------------------------------------------------------------------------------------

operator.id

28

operator.quota_id

50002

operator.operator_id

500

operator.actype_id

1102

operator.aircraft_id

802

operator.reg_no

VH-BBY

operator.buy_cur_id

0

operator.buy_cur_rate

0.0000000

operator.sell_cur_id

0

operator.sell_cur_rate

0.0000000

operator.margin_cur_id

0

operator.margin_cur_rate

0.0000000

operator.buy_price

0

operator.sell_price

0

operator.sent

0

operator.booking

1

operator.operator_response

GBRH Operator notes

operator.catering


operator.pax

4

operator.baggage

150

operator.baggage_capacity

0

operator.owners_approval

0

operator.smoking

0

operator.toilet

0

operator.prior

1

operator.need_to_quote

1

operator.creator_id

1

operator.create_date

2017-01-03 09:00:44

operator.editor_id

2

operator.edit_date

2017-01-03 15:03:17

operator.deleted

0

operator.inclusions


operator.exclusions


operator.operator

Great Barrier Reef Helicopters

operator.compliance_check


operator.actype

Bell 206 Jet Ranger

operator.year


operator.refurbishment_year

0

operator.pax_max

4

operator.cbm1

0.00

operator.bed

0

operator.cbm

150.00 cbm

operator.endurance_h

0

operator.endurance_km

732

operator.buy_cur


operator.sell_cur


operator.margin_cur


-------------------------------------------------------------------------------------------------------------

charterObj object
-------------------------------------------------------------------------------------------------------------

charterObj.id

50002

charterObj.invoice_id

4

charterObj.customer_id

90

charterObj.contact_id

45

charterObj.company_id

25

charterObj.other_company_id

0

charterObj.broker_id

714

charterObj.booked_operator_id

28

charterObj.booked_option_id

20

charterObj.booked_actype_id

1102

charterObj.booked_aircraft_id

802

charterObj.booked_courier_id

0

charterObj.booked_call_sign


charterObj.other_broker_id

0

charterObj.status

WON

charterObj.fixture_type_id

1

charterObj.reason_id

1

charterObj.source_type_id

16

charterObj.source_descr_id

127

charterObj.mt_thread_id

0

charterObj.mt_thread_tag


charterObj.status_reason_comments

TEST

charterObj.ref_no

IA17ET01001

charterObj.request_date

2017-01-03

charterObj.close_date

2017-01-03 09:19:40

charterObj.note

TRAINING....

charterObj.operator_notes

With pets....

charterObj.revenue_type1_id

3

charterObj.revenue_type2_id

59

charterObj.description


charterObj.type_of_commodity


charterObj.close_user_id

1

charterObj.sell_cur_id

0

charterObj.sell_cur_rate

1.0000000

charterObj.buy_cur_id

0

charterObj.buy_cur_rate

0.0000000

charterObj.margin_cur_id

0

charterObj.margin_cur_rate

0.0000000

charterObj.currency_id

19

charterObj.currency_rate

1.0000000

charterObj.cargo_origin


charterObj.cargo_dest


charterObj.cargo_awb_no


charterObj.awb_stoc_id

0

charterObj.cargo_mawb


charterObj.cargo_hawb


charterObj.checked

0

charterObj.contracting_basis


charterObj.receive_point

port

charterObj.delivery_point

port

charterObj.transit

0

charterObj.delivery

0

charterObj.creator_id

1

charterObj.create_date

2017-01-03 08:57:06

charterObj.editor_id

2

charterObj.edit_date

2017-01-03 11:48:48

charterObj.deleted

0

charterObj.category

default

charterObj.flight_id

0

charterObj.awb_id

0

charterObj.other_awb_id

0

charterObj.used_empty_leg_id

0

charterObj.slx_id


charterObj.slx_response_code

0

charterObj.extra_broker_details


charterObj.linked_id

0

charterObj.reason

Better Price

charterObj.customer_contact

Darwin

charterObj.customer

AeroRescue NT

charterObj.customer_type

customer

charterObj.customer_orig

AeroRescue NT

charterObj.company

Independent Aviation

charterObj.other_company


charterObj.company_amd_code

IAV

charterObj.other_company_amd_code


charterObj.broker_amd_code

ET

charterObj.broker

Ettiene Du Toit

charterObj.other_broker


charterObj.other_broker_amd_code


charterObj.booked_actype

Bell 206 Jet Ranger

charterObj.booked_operator

Great Barrier Reef Helicopters

charterObj.booked_aircraft

VH-BBY

charterObj.revenue_type1

VIP

charterObj.revenue_type2

executive

charterObj.creator

01

charterObj.editor

sales

charterObj.close_user

01

charterObj.files

0

charterObj.source_type

Contract

charterObj.source_descr

QGOV

charterObj.customer_country_name

Australia

charterObj.customer_country_code

AU

charterObj.customer_city


charterObj.fixture_type

Full Charter

charterObj.currency

AUD

charterObj.pre_contract_complete

0

charterObj.pre_billing_complete

0

charterObj.operators_cnt

4

charterObj.awb_no


charterObj.other_awb_no


charterObj.items_from_date

04 Jan 2017
05 Jan 2017

charterObj.items_from_city

Cairns - CNS
Whyalla - WYA

charterObj.items_to_cityWhyalla - WYA
Cairns - CNS
charterObj.items_pax8
8
charterObj.buy_price4000.000000000
charterObj.sell_price5000.000000000


-------------------------------------------------------------------------------------------------------------


-------------------------------------------------------------------------------------------------------------
option item (should be addressed through cycle: # { foreach ( $ { option } in $ { options })}
-------------------------------------------------------------------------------------------------------------

option.id

20

option.quota_id

50002

option.name


option.rotations

1

option.prior

1

option.path_iata

CNS-WYA-CNS

option.path_icao

YBCS-YWHA-YBCS

option.cities

Cairns-Whyalla-Cairns

option.airport_names

Cairns-Whyalla-Cairns

option.mail_request

[27,28,29,30]

option.won

1

option.deleted

0

option.additionals

{"sorted":true,"na":[]}

option.customer_path_icao

YBCS-YWHA-YBCS

option.customer_path_iata

CNS-WYA-CNS

-------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------
route item (should be addressed through cycle: # { foreach ( $ { route } in $ { option.items })}
-------------------------------------------------------------------------------------------------------------

route.id

55

route.quota_id

50002

route.option_id

20

route.date

0000-00-00

route.from_id

1471

route.to_id

8588

route.seats

4

route.catering


route.from_procedure


route.to_procedure


route.from_transportation_id

0

route.to_transportation_id

0

route.from_transportation_contact_id

0

route.to_transportation_contact_id

0

route.from_terminal_id

0

route.to_terminal_id

0

route.from_handling_id

0

route.to_handling_id

0

route.from_handling_contact_id

0

route.to_handling_contact_id

0

route.from_date_act

0000-00-00 00:00:00

route.to_date_act

0000-00-00 00:00:00

route.general_origin


route.general_dest


route.pax_range


route.general_departure_date


route.general_arrival_date


route.aircraft_id

0

route.call_sign


route.pax

8


route.satcom



route.cargo

0


route.crew_list



route.pax_list

[{"nationality":"","name":"Vitaly Phone 505050504 5405 "}]


route.notes



route.empty_leg

0


route.handling



route.brief_notes



route.not_qoute

0


route.prior

1


route.creator_id

1


route.create_date

2017-01-03 08:57:06


route.editor_id

2


route.edit_date

2017-01-03 15:03:17


route.deleted

0


route.captain



route.captain_tel



route.copilot



route.copilot_tel



route.fltattendant



route.fltattendant_tel



route.rotation_no

1


route.pcs

0


route.dims



route.tbc

0


route.cargo_volume



route.exclude_fir



route.exclude_point



route.announcements



route.checkin



route.ticketing



route.free_seating

1


route.from_date_utc

2017-01-04 23:00:00


route.to_date_utc

2017-01-05 02:30:00


route.time_diff

03:30


route.date_diff

1


route.date_diff_local

0


route.from_local_diff

(UTC 10:00)


route.to_local_diff

(UTC 10:30)


route.localtime_diff

0:30


route.from_time

09:00


route.to_time

13:00


route.from_time_zulu

23:00


route.to_time_zulu

02:30


route.from_date

2017-01-04 23:00:00


route.to_date

2017-01-05 02:30:00


route.from

YBCS


route.to

YWHA


route.from_date_local

Thursday, 5 Jan 2017


route.to_date_local

Thursday, 5 Jan 2017


route.from_date_local_ext

Thursday, 5 January 2017, 09:00


route.to_date_local_ext

Thursday, 5 January 2017, 13:00


route.to_gmt

10.30


route.from_iata

CNS


route.from_icao

YBCS


route.from_city

Cairns


route.from_airport_name

Cairns


route.to_iata

WYA


route.to_icao

YWHA


route.to_city

Whyalla


route.to_airport_name

Whyalla


route.distance

0


route.operator

Great Barrier Reef Helicopters


route.booked_actype_id

1102


route.broker_id

714


route.rt1_id

3


route.company_id

25


route.smoking



route.booked_aircraft_id

802


route.reg_no

VH-BBY


route.operator_id

500


route.actype

Bell 206 Jet Ranger


route.id

56


route.quota_id

50002


route.option_id

20


route.date

0000-00-00


route.from_id

8588


route.to_id

1471


route.seats

4


route.catering



route.from_procedure



route.to_procedure



route.from_transportation_id

0


route.to_transportation_id

0


route.from_transportation_contact_id

0


route.to_transportation_contact_id

0


route.from_terminal_id

0


route.to_terminal_id

0


route.from_handling_id

0


route.to_handling_id

0


route.from_handling_contact_id

0


route.to_handling_contact_id

0


route.from_date_act

0000-00-00 00:00:00


route.to_date_act

0000-00-00 00:00:00


route.general_origin



route.general_dest



route.pax_range



route.general_departure_date



route.general_arrival_date



route.aircraft_id

0


route.call_sign



route.pax

8


route.satcom



route.cargo

0


route.crew_list



route.pax_list



route.notes



route.empty_leg

0


route.handling



route.brief_notes



route.not_qoute

0


route.prior

2


route.creator_id

1


route.create_date

2017-01-03 08:57:06


route.editor_id

2


route.edit_date

2017-01-03 15:03:17


route.deleted

0


route.captain



route.captain_tel



route.copilot



route.copilot_tel



route.fltattendant



route.fltattendant_tel



route.rotation_no

1


route.pcs

0


route.dims



route.tbc

0


route.cargo_volume



route.exclude_fir



route.exclude_point



route.announcements



route.checkin



route.ticketing



route.free_seating

1


route.from_date_utc

2017-01-05 04:30:00


route.to_date_utc

2017-01-05 05:00:00


route.time_diff

00:30


route.date_diff

0


route.date_diff_local

0


route.from_local_diff

(UTC 10:30)


route.to_local_diff

(UTC 10:00)


route.localtime_diff

-0:30


route.from_time

15:00


route.to_time

15:00


route.from_time_zulu

04:30


route.to_time_zulu

05:00


route.from_date

2017-01-05 04:30:00


route.to_date

2017-01-05 05:00:00


route.from

YWHA


route.to

YBCS


route.from_date_local

Thursday, 5 Jan 2017


route.to_date_local

Thursday, 5 Jan 2017


route.from_date_local_ext

Thursday, 5 January 2017, 15:00


route.to_date_local_ext

Thursday, 5 January 2017, 15:00


route.to_gmt

10.00


route.from_iata

WYA


route.from_icao

YWHA


route.from_city

Whyalla


route.from_airport_name

Whyalla


route.to_iata

CNS


route.to_icao

YBCS


route.to_city

Cairns


route.to_airport_name

Cairns


route.distance

0


route.operator

Great Barrier Reef Helicopters


route.booked_actype_id

1102


route.broker_id

714


route.rt1_id

3


route.company_id

25


route.smoking



route.booked_aircraft_id

802


route.reg_no

VH-BBY


route.operator_id

500


route.actype

Bell 206 Jet Ranger


-------------------------------------------------------------------------------------------------------------