Tables contain the codes needed to complete many fields in the CrossCheck Travel Enterprise screens. There is one set of Tables for the entire network.
The Table data is displayed in the List-Search screens and it is possible to add, delete or amend information as required through the Table Maintenance windows.
All codes in each table must contain a full and accurate description, as this description is often used in document production.
In these cases, the system reads the code on the file then prints the code description on the document.
Tables can be updated ‘on the fly’ by double clicking on the field. E.g. Marketing Codes on the front a Trip. Double click on the field and then click on Table Maintenance – the user can then edit from here.
Opening the Table Maintenance Screen
To access the Table maintenance screens DO NOT use the supervisor Log In. Access to these screens is through the normal CrossCheck Travel Enterprise User Id and Password.
From the menu, select Tools, then Tables and then the table required from the sub menu.
Glossary of Codes Sub -tables in CCTE (Tools/Tables/Codes)
|
Table Name |
Found on Screen |
Other Information |
|
Address Type |
Available in Trip, Client, Debtors, Creditors tabs |
These are available by default, eg. H, B, M etc I - Invoice used for Debtors |
|
Aircraft |
Flight Segment in trip segment tab Prints on Itineraries |
Many are set by default, however if a new Aircraft type was downloaded, a New Aircraft Type and Description would need to be added |
|
Amount on Account Reason |
Debtors must have reasons loaded as to why not on Credit Card if to Invoice |
These Amount on Account Reasons and any others required are set up by the Agency, if required |
|
Balance Reason |
Trip Balance Nanny reasons in trip accounting screen. |
These Balance Reasons need to be built by the Agency Manager prior to Trip Nanny being switched on |
|
Banks
|
Receipts & Payments,
|
A number of Banks are set as default, additional new Banks can be added as required by the Agency See Module 3: Tables |
|
CalypsoNet Trip Status |
Updates segment status on import of CalypsoNet booking into Trip Segment |
|
|
Car Type |
Car Segment in trip segment tab |
Set by default utilizing car types from Carmaster\Viewpoint |
|
Client Category |
In client marketing tab |
Client categories can be built by the Agency, as required |
|
Email Group |
In Phone field of all modules when create E – email field |
An Agency can specify a group of email recipients, rather than just a single email address, for certain financial documents |
|
Bulk payment Type |
eNett or Internet payment |
To be built by Agency Note: If using eNett Creditor extractions, eNett would not be required to be set up in this Code |
|
Fare Basis |
On Ticket/Cheque requisitions |
These are not set by default and need to be built by the Agency, if required |
|
KeyWords |
CalypsoNet link
ViewTrip path |
Filter on keyWords and the code CalypsoNet should be available for viewing. The CalypsoNet link to be prepopulated by default Loaded in here automatically when installed |
|
Marketing Codes |
Marketing field on FRONT OF TRIP |
These are more like Advertising codes, and need to be created as required by Agency |
|
Meals |
Flight segments in trip segments tab |
Located in Transits/Meals/SSR - Set by default to match servicing used in flight segments and downloaded with booking when available |
|
Office Locations |
Branches may have different locations, eg. SYD and Mel |
This is used in Supervisor for Multibranching purposes only – See CCTE Accounts Management Multi Branch Guide, Answer 43425 in Ask Travelport |
|
Order Method |
Front Trip tab |
Travel Order method |
|
Phone Type |
Trip, Client, Debtor, Creditor tabs |
These are available by default, eg. H, B, M, E etc |
|
Reason Code |
Debtors Fare Savings |
Entered into quotes or tickets custom tabs |
|
Region |
Front of Trip |
To be built as required by Agency |
|
Room Type |
Hotel segment in trip segment tab |
Set by default utilizing Hotel room types from Roommaster\Viewpoint |
|
Seat Type |
Flight segments in trip segments tab – Transits/Meals/SSR |
Downloaded from host flight service code within segment |
|
Segment Status |
Flight Segment in trip segments tab
CalypsoNet import of bookings
|
Downloaded from host flight segment, or can be manually input for manual creation and/or updated On import segment status will show as: |
|
Special Interest |
NO LONGER USED |
NO LONGER USED |
|
SSR Codes |
Flight Segment in trip segments tab |
Downloaded from host flight segment, or can be manually input for manual creation and/or updated |
|
Title |
Pax title on Client or Trip file |
Available as default, eg. Mr, Mrs, Dr, etc |
|
Trip Status |
On Trip tab |
Available as default, eg. Active, Finalised, etc A trip search can be based on the status. Once configured by a Manager/Supervisor, Quick Trip and Enquiry Status will prompt the creation of Follow Up Workflow Action items. See Trip Status Follow Up Prompts
|
|
Visa Type |
In client file passport tab |
Available as default, eg. Tourist, Business, etc. Also used in visa letter |
|
Workflow Reason Codes |
TripCheck |
When Reason Codes have been made Mandatory within Security, the reasons must be added to the Workflow, see Trip Check Workflow within this Guide. More details can also be obtained from CCTE Consultant User Guide, Answer 27133 in Ask Travelport. |
Examples follow of some of the Code table items within CCTE:
Balance Reason
Balance reasons must be entered when closing the Trip accounting screen if the file is out of balance and the Trip Balance Nanny is set to request this entry.
Client Category
This code is used under the marketing tab in the Client file. A report can be run to retrieve client files based on Category.
Email Group
An Agency can specify a group of email recipients, rather than just a single email address, for certain financial documents. There is a default email group (GE = General Email), where all email addresses will automatically belong to prior to creating additional groups.
The Agency Supervisor can create new email groups as required. Rules for adding a new email group:
- Email Group Code will be limited to 3 characters
- Email Group Description will be limited to 15 characters
- The Email Group Codes will be available for selection against the email addresses stored within CCTE
- Only a single Email Group will apply per email address
- If a single email address needs to belong to more than one email group, it needs to be added again, and linked to the additional group
Fare Basis
The Fare Basis field appears on ticket and cheque requisitions. This field can be set as mandatory in the branch set up screens.