Scope - Quotation

Overview

The Quotation scope covers flight quotations created during the sales process in Leon. Each record represents a quote (or Request for Quote — RFQ) issued in response to a client enquiry, including the quoted route, pricing, aircraft, trip details, and the current status of the quote. The scope also captures booking and cancellation data, allowing operators to track a quote through its full lifecycle from initial request to confirmation or rejection.

Operators use this scope to analyse sales pipeline performance, monitor quote conversion rates, review pricing decisions, and report on revenue generated from booked trips. It is particularly useful for sales teams looking to understand how quickly quotes are turned around, which assignees handle the most bookings, and how quoted prices compare to actual realisation.

What reports can you build with this scope?

Examples of typical reports operators build with this scope:

Sales pipeline summary — lists all active quotes with their status, assignee, route, and pricing, giving the sales team a current view of open opportunities.
Quote conversion analysis — compares the number of quotes sent versus quotes booked, broken down by aircraft type, trip type, or assignee, to measure sales effectiveness.
Monthly revenue report — aggregates booked trip prices and VAT by month or week, supporting invoicing and financial forecasting.
Quote response time tracking — measures the time between when a quote request was received and when it was quoted, helping identify bottlenecks in the quoting process.
Cancellation and rejection analysis — reports on canceled or rejected quotes including the reason and who canceled them, to support process improvement.

Available columns

Columns are the data fields that can appear in your report. When building a report, select the columns most relevant to your analysis.

Trip and aircraft identification

Column	Column key	Description
Trip nid	`trip_nid`	Internal identifier of the trip associated with the quote.
Aircraft	`registration`	Aircraft registration assigned to the quoted trip.
Aircraft type	`aircraft_type`	Type of aircraft assigned to the quote.
Aircraft labels	`aircraft_tags`	Labels/tags assigned to the aircraft.
Operator	`operator`	Air Operator Certificate (AOC) / operator associated with the quote.
Trip No	`quote_realization_trip_no`	The trip number as shown in the system.
Trip Type	`quote_realization_trip_type`	Type of trip (e.g. commercial, owner, ferry).
Trip Status	`quote_realization_trip_status`	Current status of the trip linked to the quote.
Trip Deletion Note	`quote_realization_trip_deletion_note`	Note recorded when a trip was deleted.
Trip Start Date [Plan][UTC]	`trip_start_date`	Planned start date of the trip, expressed in UTC.
Trip End Date [Plan][UTC]	`trip_end_date`	Planned end date of the trip, expressed in UTC.
Week Number	`week_number`	Calendar week number of the trip.
Tags	`tags`	All tags applied to the quote or trip.
Flight/Trip Tags	`flight_tags`	Tags applied to either the flights or the trip.
Trip Tags	`trip_tags_only`	Tags applied at the trip level only.
Flight Tags	`flight_tags_only`	Tags applied at the individual flight level only.

Quote request (RFQ) details

Column	Column key	Description
Quote request ID	`quote_request_provider_friendly_id`	Human-readable identifier of the quote request (RFQ).
Quote unique ID	`quote_unique_id`	Unique internal identifier of the specific quote version.
Quote request status	`quote_request_status`	Current status of the quote request (e.g. sent, booked, rejected).
Quote request created date	`quote_request_created_date`	Date and time when the quote request was created.
Quote request last update	`quote_request_last_external_update`	Date and time of the last update to the quote request.
First departure UTC	`quote_realization_first_departure_utc`	Date and time of the first departure leg of the quoted trip, in UTC.
RFQ route ICAO	`quote_requests_route_icao`	Route of the original request for quote, expressed as ICAO airport codes.
RFQ route IATA	`quote_requests_route_iata`	Route of the original request for quote, expressed as IATA airport codes.
RFQ route airport city name	`quote_route_custom_apts_cities`	City names of airports on the RFQ route.
RFQ Route type	`rfq_route_type`	Type of route specified in the RFQ (e.g. one-way, return).
RFQ creating year	`rfq_create_year`	Year in which the RFQ was created.
RFQ creating month	`rfq_create_month`	Month in which the RFQ was created.
Quote route ICAO	`quote_realization_route_icao`	Route of the actual quote realisation, expressed as ICAO airport codes.
Quote route IATA	`quote_realization_route_iata`	Route of the actual quote realisation, expressed as IATA airport codes.
ROUTE AIRPORT CITY NAME	`route_custom_apts_cities`	City names of airports on the quoted route.
Quoting date timestamp	`quote_realization_quoted_date`	Timestamp of when the quote was issued.
Quote booking time difference	`quote_booking_time_difference`	Time elapsed between the quote being created and being booked.
Quote response time	`quote_response_time`	Time elapsed between receiving the RFQ and sending the quote.

Client and contact details

Column	Column key	Description
Requested by	`quote_requests_requested_by`	Name of the person or company who submitted the quote request.
Is requested by company	`quote_requests_is_requested_by_company`	Indicates whether the requester is a company rather than an individual.
Representative	`quote_requests_representative`	Name of the client representative handling the request.
Representative email	`quote_requests_representative_email`	Email address of the client representative.
Representative phone	`quote_requests_representative_phone`	Phone number of the client representative.
Requester email	`requester_email`	Email address of the person who submitted the RFQ.
Assignee	`quote_requests_assignee`	Leon user assigned to handle the quote.
Assignee code	`quote_requests_assignee_code`	Short code identifying the assigned user.
Assignee base	`quote_requests_assignee_base`	Home base of the assigned user.
Client label	`client_label`	Label assigned to the client associated with the quote.
Client country	`client_country`	Country of the client associated with the quote.
Lead PAX List	`quote_realization_lead_passengers_list`	List of lead passengers on the quoted trip.
Unique PAX list	`quote_realization_unique_passengers_list`	List of unique passengers across all legs of the quoted trip.

Booking details

Column	Column key	Description
Is quote booked	`quote_is_booked`	Indicates whether the quote has been confirmed as booked.
Booking date UTC	`booking_date`	Date and time the quote was booked, expressed in UTC.
Booking date [LT, Assignee Office]	`booking_date_LT`	Booking date expressed in local time of the assignee's office.
Booking date timestamp	`booking_date_timestamp`	Numeric timestamp of the booking date.
Booking year	`booked_year`	Year in which the trip was booked.
Booking month	`booked_month`	Month in which the trip was booked.
Flight No	`booked_trip_flight_number`	Flight number(s) of the booked trip.
Flown route ICAO	`booked_trip_route`	Route of the booked trip, expressed as ICAO airport codes.
Invoice No	`quote_realization_invoice_no`	Invoice number associated with the quote realisation.
Invoice paid	`is_paid`	Indicates whether the associated invoice has been paid.
Invoice tags	`invoice_tags`	Tags applied to the associated invoice.
Contract name	`contract_name`	Name of the contract linked to the quote.
Contract number	`contract_number`	Number of the contract linked to the quote.

Cancellation details

Column	Column key	Description
Canceled by	`quote_request_reject_canceled_by`	Name of the person who canceled or rejected the quote.
Cancellation reason	`quote_request_reject_cancellation_reason`	Reason provided when the quote was canceled or rejected.

Pricing and revenue

Column	Column key	Description
Price	`quote_realization_price`	Total quoted price in the quote's native currency.
Price currency	`quote_realization_currency`	Currency of the quoted price.
VAT %	`quote_realization_VAT_rate`	VAT rate applied to the quote (as a percentage).
VAT	`quote_realization_VAT_amount`	VAT amount applied to the quoted price.
Custom currency	`quote_realization_convert_currency`	Currency used for custom currency conversion.
Price in custom currency	`quote_realization_price_converted`	Quoted price converted to the selected custom currency.
VAT in custom currency	`quote_realization_vat_converted`	VAT amount converted to the selected custom currency.
Hourly price (flight time) in custom currency	`quote_realization_flight_time_hourly_price`	Effective hourly rate based on flight time, expressed in the custom currency.
Hourly price (block time) in custom currency	`quote_realization_block_time_hourly_price`	Effective hourly rate based on block time, expressed in the custom currency.
Hourly price (block time) in custom currency [JL]	`block_time_jl_hourly_price`	Effective hourly rate based on Journey Log block time, expressed in the custom currency.
Operator Price (for subcharter)	`operator_price`	Price paid to the subchartered operator (applicable for subcharter trips).
Margin	`subcharter_margin`	Margin on the trip (used for subcharter analysis).
Profit	`subcharter_profit`	Profit on the trip (used for subcharter analysis).
Quote price when quoted	`quote_price_when_quoted`	Price of the quote at the time it was issued.
Quote price when booked	`quote_price_when_booked`	Price of the quote at the time it was confirmed as booked.
Quote margin when price based	`quote_margin_price_based`	Margin calculated on the basis of the quoted price.
Quote cost when price based	`quote_cost_price_based`	Cost calculated on the basis of the quoted price.
Quote income when price based	`quote_income_price_based`	Income calculated on the basis of the quoted price.
Total Gross	`total_gross`	Total gross amount for the trip including all fees.
Total Net	`total_net`	Total net amount for the trip after deductions.
Third Party Commission	`third_party_commission`	Commission amount payable to a third party.
Quote referral fee	`quote_referral_fee`	Referral fee associated with the quote.
Quote commission fee PAX	`quote_commission_fee_pax`	Commission fee related to passenger flights on the quote.
Quote commission fee ferry	`quote_commission_fee_ferry`	Commission fee related to ferry flights on the quote.
Quote Wi-Fi fee	`quote_wifi_fee`	Wi-Fi fee included in the quote.
Quote cost difference	`quote_cost_difference`	Difference between the quoted cost and actual cost.

Flight time and block time

Column	Column key	Description
Sum flight time [Quote]	`quote_realization_flight_time`	Total flight time across all legs as stated in the quote.
Sum flight time PAX [Quote]	`quote_realization_flight_time_pax`	Total flight time on passenger legs as stated in the quote.
Sum flight time ferry [Quote]	`quote_realization_flight_time_ferry`	Total flight time on ferry legs as stated in the quote.
Sum flight time cargo [Quote]	`quote_realization_flight_time_cargo`	Total flight time on cargo legs as stated in the quote.
Sum flight time PAX [Plan]	`trip_flight_time_pax_plan`	Total planned flight time on passenger legs.
Sum flight time ferry [Plan]	`trip_flight_time_ferry_plan`	Total planned flight time on ferry legs.
Sum flight time [JL]	`trip_flight_time_log`	Total flight time on all legs as recorded in the Journey Log.
Sum flight time PAX [JL]	`trip_flight_time_pax_log`	Total flight time on passenger legs as recorded in the Journey Log.
Sum flight time ferry [JL]	`trip_flight_time_ferry_log`	Total flight time on ferry legs as recorded in the Journey Log.
Sum flight time cargo [JL]	`trip_flight_time_cargo_log`	Total flight time on cargo legs as recorded in the Journey Log.
Sum block time [Quote]	`quote_realization_block_time`	Total block time across all legs as stated in the quote.
Sum block time PAX [Plan]	`quote_realization_block_time_pax_plan`	Total planned block time on passenger legs.
Sum block time PAX [JL]	`trip_block_time_pax_log`	Total block time on passenger legs as recorded in the Journey Log.
Sum block time [JL]	`block_time_jl`	Total block time on all legs as recorded in the Journey Log.
Average sector flight time	`quote_realization_avg_leg_flight_time`	Average flight time per leg based on the quote.
Average sector block time	`quote_realization_avg_leg_block_time`	Average block time per leg based on the quote.

Passenger counts

Column	Column key	Description
Sum PAX number	`quote_realization_sum_pax`	Total number of passengers across all legs of the quoted trip.
Sum unique PAX number	`quote_realization_unique_passengers_count`	Total number of unique passengers across the trip (counted once per person).
Legs with pax	`quote_realization_legs_with_pax_no`	Number of legs in the trip that carried passengers.
Legs number	`quote_realization_legs_no`	Total number of legs in the trip.

Fee breakdown

Column	Column key	Description
Flight Hour Fee	`flight_hour_fee`	Fee charged per flight hour.
Pax Flight Fee	`pax_flight_fee`	Fee charged for passenger flights.
PAX/Ferry Flight Fee Summary	`ferry_and_pax_flight_fee`	Combined fee for passenger and ferry flights.
Pax Flight Fee Discount	`pax_flight_fee_discount`	Discount applied to the passenger flight fee.
PAX/Ferry Flight Fee Summary Discount	`ferry_and_pax_flight_fee_discount`	Discount applied to the combined PAX/ferry flight fee.
Trip Startup Fee	`trip_startup_fee`	Fixed fee charged at the start of the trip.
Overnight Fee	`overnight_fee`	Fee for overnight crew stops.
Aircraft Parking Fee	`aircraft_parking_fee`	Fee for parking the aircraft.
Leg Fee	`leg_fee`	Fee charged per flight leg.
Pax Leg Fee	`pax_leg_fee`	Fee charged per passenger per leg.
Eurocontrol Fee	`eurocontrol_fee`	Eurocontrol en-route navigation charges.
Landings Fee	`landings_fee`	Fee charged for landings.
Arrival Pax Fee	`arrival_pax_fee`	Fee charged per arriving passenger.
Departure Pax Fee	`departure_pax_fee`	Fee charged per departing passenger.
Catering Pax Fee	`catering_pax_fee`	Catering fee charged per passenger.
Discount per PAX	`discount_per_pax`	Discount amount applied per passenger.
Fuel Block Fee	`fuel_block_fee`	Fuel surcharge based on block time.
Fuel Flight Fee	`fuel_flight_fee`	Fuel surcharge based on flight time.
Pet Fee	`pet_fee`	Fee charged for transporting pets.
Saturday Departure	`saturday_takeoff_fee`	Surcharge for departures on Saturdays.
Sunday Departure	`sunday_takeoff_fee`	Surcharge for departures on Sundays.
Parking fee per 24h	`overnight_charge`	Aircraft parking fee charged per 24-hour period.
Night Landing	`night_landings_fee`	Surcharge for night landings.
Landing Permit Fees	`landing_permit_fee`	Fees for obtaining landing permits.
Holiday	`holiday_fee`	Surcharge for operations on public holidays.
Handling Basic Fee	`handling_basic_fee`	Basic ground handling fee.
Handling ADEP	`handling_adep`	Ground handling fee at the departure airport (ADEP).
Flight Plan	`flight_plan`	Fee related to flight plan filing.
Crew Layover Fee	`crew_layover_fee`	Fee for crew layovers between flights.
Catering	`catering`	Catering cost included in the quote.
Additional Fee / Discount (%)	`additional_fee`	Additional fee or percentage-based discount applied to the quote.
Discount	`discount`	Discount amount applied to the quote.
CO2 Offsetting name	`CarbonOffsetFeeName`	Name of the CO2 offsetting scheme applied.
CO2 Offsetting	`CarbonOffsetFeePrice`	Fee charged for CO2 offsetting.
Carbon offsetting level 1	`carbon_offset_level_1`	CO2 offsetting fee at level 1.
Pax Block Fee	`pax_block_fee`	Fee based on block time for passenger flights.
Ferry Block Fee	`ferry_block_fee`	Fee based on block time for ferry flights.
Ferry Block Fee Discount	`ferry_block_fee_discount`	Discount applied to the ferry block fee.
Cargo Block Fee	`cargo_block_fee`	Fee based on block time for cargo flights.
Cargo Flight Fee	`cargo_flight_fee`	Fee based on flight time for cargo flights.
Flight Hour Fee Trip Minimum	`flight_hour_fee_trip_minimum`	Minimum flight hour fee applicable per trip.
Flight Hour Fee Daily Minimum	`flight_hour_fee_daily_minimum`	Minimum flight hour fee applicable per day.
Block Hour Fee	`block_hour_fee`	Fee charged per block hour.
Block Hour Fee Trip Minimum	`block_hour_fee_trip_minimum`	Minimum block hour fee applicable per trip.
Block Hour Fee Daily Minimum	`block_hour_fee_daily_minimum`	Minimum block hour fee applicable per day.
Non Ferry Flight Hour Fee	`non_ferry_flight_hour_fee`	Flight hour fee applicable to non-ferry flights only.
Non Ferry Block Hour Fee	`non_ferry_block_hour_fee`	Block hour fee applicable to non-ferry flights only.
PAX Fee	`pax_fee`	General fee charged per passenger.
Crew Costs Fee	`crew_costs_fee`	Fee representing crew costs included in the quote.
CPT Cost Fee	`cpt_cost_fee`	Captain cost fee included in the quote.
Owner Block Hour Fee	`owner_block_hour_fee`	Block hour fee applicable to owner flights.
Navigational Block Hour Fee	`navigational_block_hour_fee`	Block hour fee related to navigational charges.
Discount Ferry Flight	`discount_ferry_flight`	Discount applied specifically to ferry flights.
Crew Block Hour Cost Fee	`crew_block_hour_cost_fee`	Crew cost calculated per block hour.
Crew charge	`crew_charge`	Total crew charge included in the quote.
Crew Hotel Fee	`crew_hotel_fee`	Hotel costs for crew included in the quote.
Taxi Time Fee	`taxi_time_fee`	Fee for taxi time at the airport.
PAX Minimum Departure Fee	`pax_minimum_fee_departure`	Minimum fee charged per departure for passengers.
Minimum day charge fee (block time)	`minimum_day_fee`	Minimum daily charge based on block time.
Short sector fee	`short_sector_fee`	Surcharge applied to short-sector flights.
Extra Fee	`extra_fee`	Miscellaneous extra fee included in the quote.
Flying Days Fee	`flying_days_fee`	Fee based on the number of flying days.
Daily Flight Fee	`daily_flight_fee`	Fee charged per day of flight operations.
Schedule Days Fee	`schedule_days_fee`	Fee based on the number of scheduled days.
Aircraft VIP Lounge	`aircraft_vip_lounge`	Fee for VIP lounge services related to the aircraft.
Pax specific catering	`pax_specific_catering`	Catering fee specific to individual passenger requirements.
Pax transportation	`pax_transportation`	Transportation fee for passengers.
Services	`services`	General services fee included in the quote.
Custom Extra Fee 1	`custom_extra_fee_1`	Custom additional fee slot 1, defined by the operator.
Custom Extra Fee 2	`custom_extra_fee_2`	Custom additional fee slot 2, defined by the operator.
Custom Extra Fee 3	`custom_extra_fee_3`	Custom additional fee slot 3, defined by the operator.
Custom Extra Fee 4	`custom_extra_fee_4`	Custom additional fee slot 4, defined by the operator.
Custom Extra Fee 5	`custom_extra_fee_5`	Custom additional fee slot 5, defined by the operator.

Sales notes

Column	Column key	Description
Sales Notes	`sales_notes`	Free-text sales notes attached to the quote.
Legal note	`legal_note`	Legal note included in the quote document.
Customer note	`customer_note`	Note visible to the customer in the quote.
Cancellation policy	`cancellation_policy`	Cancellation policy text included in the quote.
Additional note	`additional_note`	Additional note attached to the quote.
Aircraft note	`aircraft_note`	Note about the aircraft included in the quote.

Checklist status

Column	Column key	Description
Invoices status [Chkl]	`checklist_trip_item_invoices_status`	Status of the invoices checklist item for the trip.
Payments status [Chkl]	`checklist_trip_item_payments_status`	Status of the payments checklist item for the trip.
Ground Transport status [Chkl]	`checklist_trip_item_ground_transport_status`	Status of the ground transport checklist item for the trip.
Contract signed status [Chkl]	`checklist_trip_item_contract_signed_status`	Status of the contract signed checklist item for the trip.
Pax list status [Chkl]	`checklist_leg_item_pax_list_status`	Status of the passenger list checklist item per leg.
Catering status [Chkl]	`checklist_leg_item_catering_status`	Status of the catering checklist item per leg.
Flight Brief status [Chkl]	`checklist_leg_item_flight_brief_status`	Status of the flight brief checklist item per leg.
Pets documents status [Chkl]	`checklist_leg_item_pets_documents_status`	Status of the pets documents checklist item per leg.

Available filters

Filters let you narrow down the data to the specific subset you need — by date range, aircraft, status, and more.

Filter	Description
Operator	Filters data to a specific Air Operator Certificate (AOC) / operator within the account.
Aircraft	Limits the report to quotes for one or more selected aircraft.
Aircraft type	Limits the report to quotes for aircraft of the selected type(s).
Trip Status	Filters quotes by the current status of the associated trip.
RFQ Status	Filters by the status of the Request for Quote (e.g. pending, sent, booked, rejected).
Subcharter	Filters to include or exclude subcharter trips.
Booked	Filters to include only booked or only unbooked quotes.
Currency converter	Selects the currency to use for converted price columns.
Assignee	Filters quotes by the Leon user assigned to handle them.
Tags include	Limits the report to quotes that carry at least one of the selected tags.
Tags exclude	Excludes quotes that carry any of the selected tags.
Date range type	Defines which date field is used to apply the date range filter (e.g. trip start date, booking date, RFQ creation date).
Canceled by	Filters quotes by the person who canceled or rejected them.
Requested by	Filters quotes by the client or person who submitted the request.
Trip Type	Limits the report to trips of the selected type(s).
Passenger list	Filters quotes that include one or more specific passengers.
PAX	Filters by a specific passenger on the quote.
PAX Lead	Filters by the lead passenger on the quote.
Is CO2 offsetting filled	Filters quotes where the CO2 offsetting field has been completed.
Has invoice number	Filters quotes that have an invoice number assigned.
Aircraft labels	Limits the report to quotes for aircraft carrying the selected label(s).
Client labels	Limits the report to quotes associated with clients carrying the selected label(s).