Skip to content
  • There are no suggestions because the search field is empty.

23 - 27 November 2026 | Upcoming Release: BRIGHT fee & price fields update

Upcoming changes to the fee and price fields in FL3XX BRIGHT.

 

Made for: FL3XX BRIGHT users

Category:


Subcategory:

Reports - feature category tag


BRIGHT tag

Included in: All subscription tiers Knowledge Base: FL3XX BRIGHT data sets & data points - fees

 

1. About

    1.1 Changes in the BRIGHT Booking Report

    1.2 Changes applicable to Data Lake users

2. Why this will change

3. Some benefits at a glance

4. FAQs

    4.1 Will the totals in my dashboards change?

    4.2 Were my numbers in BRIGHT wrong before?

    4.3 Does this apply to older bookings too?

 



1. About the changes

1.1 Changes in the BRIGHT Booking Report

Starting the week of 23 November, the type of the Booking Cancellation Fee field will change from text to number. If you use this field in a calculated field with text functions or as a filter, please check it after the release.

In addition, fee and price fields in BRIGHT will display values to two decimal places instead of whole numbers, so they match the Pricing screen in FL3XX to the cent. Dashboards and analyses will continue to work as before.

 

1.2 Changes applicable to Data Lake users

For Data Lake users, there will be another important change: 41 fee and price columns will change type in the manifest from double precision to numeric (38,2). If your pipeline maps any of these columns to an integer type, please update the mapping to decimal or float before the release.

Here is a list of the affected columns.

Report Column
Booking Report
  • Quote Net Price

  • Quote Gross Price

  • Booking Fees

  • Pos. Flight Fees

  • Handling Fees

  • Landing Fees

  • Minimum Flight Fee Day

  • Overnight Fees

  • Pax Airport Fees

  • Pax Flight Fees

  • Leg Fees

  • Catering Fees

  • Crew Variable Cost

  • Daily Fees

  • Fix Cost

  • Maintenance Cost

  • Nav Cost

  • Crew Swap Fees

  • Fuel Cost

  • Augmented Crew Fees

  • Margin

  • Parking Fees

  • Services Fees

  • Pax Tax

  • Net Price

  • Total Cost

  • Discount

  • Fuel Stop Fees

  • Gross Price

  • Surcharge

  • VAT/FET (deprecated)

  • Minimum Booking Fees

  • Minimum Hours Fees

  • Departure Fees

  • DOC Margin

  • Minimum Pos. Hours Fees

  • Total (deprecated)

  • Charter Name

  • Sub-Charter Name

Flight Report
  • Gross Price

  • Net Price

 

1.3 Checklists

✅ Checklist Booking Report

→ Check the Booking Cancellation Fee field if you use it in a calculated field with text functions or as a filter.

 

✅ Checklist for Data Lake users

→ Check whether you use any of the 41 columns listed in 1.2 Changes applicable for Data Lake users.

→ If your pipeline maps any of these columns to an integer type, update the mapping to decimal or float before 23 November.

 


 

2. Why this will change

Previously, BRIGHT displayed fee and price fields as whole numbers, so cents were cut off. For example, a fee of 123.46 was displayed as 123. As a result, totals in BRIGHT could differ from those shown on the Pricing screen in FL3XX. With this update, the values will match to the cent.

 


 

3. Some benefits at a glance

  • Fee and price values in BRIGHT match the Pricing screen in FL3XX to the cent.
  • Totals and averages no longer lose cents to rounding.
  • The Booking Cancellation Fee is now a number, so you can sum and average it like the other fees.
  • ...and more!

 


 

4. FAQs

4.1 Will the totals in my dashboards change?
Yes, slightly. Values that were previously displayed as whole numbers will now include cents, so sums and averages may change slightly. The underlying data in FL3XX will not change.

 

4.2 Were my numbers in BRIGHT wrong before?
The underlying data has always included cents. Only the display in BRIGHT omitted them. Data Lake files already contained decimal values.

 

4.3 Does this apply to older bookings too?
Yes. After the release, all bookings in BRIGHT will show cents, including past bookings.