Reports

IC Occupancy Rate  and Revenue Report

This report allows a thorough analysis of the flight revenue. It shows a certain information according to the status of the flight at the time of the inquiry.

The information displayed varies depending on whether it is requested:

1. Prior to the departure of a flight or,

2. After the flight closed at check-in.

Pre-Check-In Information

The command for getting this report is the following:

VICFLIGHT/DATE

Example:

VIC4420/22JUN

LEG INFORMATION

REVENUE

When  dealing with flights with intermediate stops in order to obtain the flight  balance ,the cost values must be charged for each of the legs, otherwise the total balance thereof can not be calculated.

Post Check-In Information

Example: VIC5200/13JUN

The command that must be entered to check this report is the following:

VICFLIGHT/DATE

General flight information

Information by marketing segments

Booking Details

Flight Post Check-in information with Upgrades / Downgrades

In case the flight checked contains upgrade and /or  downgrades, the VIC report will contain other columns that will optimize the analysis. The columns are:

BOOK Number of reservations in each class

UPG / DWG: Number  upgraded or downgraded passengers in each class:

FROM: Number of passengers with reservations in another class, and due to an upgrade or downgrade are  checked in that class.

TO: Number of passengers with reservations in that class, and due to an upgrade or downgrade are checked in another class.

Example:

Description:

Class C: I had 2 reservations (BOOK). 8 passengers flew in this class (PAX). 7 passengers had upgrade. 1 passenger had a downgrade.
Class J: I had 2 reservations (BOOK). 1 passenger flew in this class (PAX).
Class Y: I had 5 reservations (BOOK). 1 passenger flew in this class (PAX). 1 passenger had upgrade. 5 passengers had downgrade.
Class H: I had 4 reservations (BOOK). 2 passengers flew in this class (PAX). 2 passengers had downgrade

Cost table

This functionality allows the administration of the "Cost Table " in reference to the different sections of the airline. Values assigned to the  Cost Table  will be reflected, in the VIC statistical report, in a comparative way with the collection of the flight.

Note:
The user must have duty code  6 or 8 in order to perform  this command

Add items

To enter the costs for each leg and period, the following command should be entered:

TFC / A- {Origin} {Destination} {-} / {date from} - {date to} / {currency} {amount}

Description:

Example:

TFC/A-EZELPB/1NOV-30NOV/USD4500

Add items indicating equipment 

You can enter the cost table by type of aircraft that operates the route. To indicate the type of aircraft, the equipment indicator should be inserted between the section and the date, as shown below:

TFC / A- (Destination Distance) / E (equipment id) / (date from) - (date to) / (currency) (amount)

Example:

TFC / A-EZELPB / E737 / 1NOV-30NOV / USD4500

Notes:
Field E (equipment) is optional. If this field is not entered, the cost will apply to all equipments.
After the indicator E, the equipment indicator should be entered in the DNE field. For example: 733 for the 737-300 aircraft-

Delete Items

To delete  costs added for a section, the following command must be entered:

TFC/D-ítems

Note:

Several items can be indicated separated by comma or with hyphens (to indicate ranges).

Modify Items

TFC/M-7/30NOV15/USD4500

The cost can also be modified for a period of time, provided that this period is within the time range of the item to be modified.

Check the cost table

The following command must be performed in order to check the cost table:

TFC*

Table Display 

Description:

History

In order to verify the history of the values added in the cost table you must enter the following command;

TFC/H

Example:

Cost table applied to VIC report

Once the Cost Table has been generated, the system will automatically calculate the pre-established values as expenses and calculate the amounts collected by flight and leg, cost of the flight, balance of the flight and each leg-

Note:
In order to obtain the calculations mentioned above, you must have the cost table with the values charged for each leg.

Example:

Description:

Report by Origin / Destination

The report can be requested by origin and destination, or only origin or destination.

The commands are:

TBR7AEPSLA Origin / destination

TBR7AEPALL Only origin (from AEP to all destinations)

TBR7ALLAEP Only destination (from all airports to AEP))

TBR7 Total Booking Report

Este reporte permite visualizar la cantidad de bookings (pasajeros reservados por tramo) activos en el host actuando en avance hasta 330 días.

This report allows to display  the number of bookings (passengers booked per leg ) active in the host acting in advance up to 330 days.

General

To obtain a report of all booked  passengers including waiting lists, subject to space and requested  on all operated routes, the command is as follows:

TBR7ALLALL

The ALL ALL indicator emphasizes that all origins and all destinations are considered.

This report displays all the routes operated by the carrier during a period of  time from the current date  up to  330 days in advance. The number of reservations is described by day and month, totaling at the end of the month.

At the end of the display  you can see the signature, date and time stamp.

DEP: Origin. Airport / ALL (all)

ARR: Destination. Airport / ALL (all)

FLT: Flight

DATES RANGE: Dates Range included in the display (330 days)

Report by Origin / Destination

The report can be requested by origin and destination, or only origin or destination.

The commands are:

TBR7AEPSLA Origin / destination

TBR7AEPALL Only origin (from AEP to all destinations)

TBR7ALLAEP Only destination (from all airports to AEP))

Report by Flight 

A booking report can be obtained by specified flight with the following command:

TBR7ALLALL/4104

Report by reservation status

You can request a report by booking status with the following command:

TBR7ALLALL*K

Report by Host, Agency or other GDS

You can request a bookings report discriminated  by Host or travel agencies.

The command to obtain a booking report created in the agencies is the following:

TBR7ALLALL#A

This command only allows to display bookings generated only by travel agencies.

The command to obtain the booking report  created in the host is:

TBR7ALLALL#H

This command only allows to display bookings generated only by the host.

Description:

The command to obtain a booking report created by another GDS:

TBR7ALLALL#G

This command allows you to display booking  generated from  office Subtype Z, which is the one that receives the PNRs from another GDS.

Description:

Combinations

Both origin / destination report ,flight number or status can be combined, therefore, a route, origin or destination of a specific flight for confirmed passengers could be requested.
To generate the report, with the mentioned combinations, you must enter the following command

TBR7AEPSLA/4104*K

Description:

Export Report to Excel

Any of the report options  can be sent to EXCEL spreadsheets.

The command to export the report is as follows:

TBR7ALLALL-EXCEL

You must enter the corresponding report request adding it  -EXCEL at the end. You can also apply this method with the TBR reports that follow.