Enquiry Operator Request template fields

Item:

Value

subjDate

04 - 05 Jan 2017

subjPath

ABM-WYA-CNS

paxmax

8

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.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

Cairns - CNS
Whyalla - WYA

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.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