Contracted Rates restrict access to specific Rate Types for a designated Company, Travel Agent, and/or Wholesaler. This article provides details on the requirements for the Company, Travel Agent, and Wholesaler Rate Type Link Import in RMS.
Â
Import Information
- The import file must be in a comma delimited .csv format, see template at the bottom of this article.
- Microsoft Excel is able to save using a .csv format that should match these requirements.
- The fields within this file must not contain commas.
- RMS is able to determine whether the first record is a header record.
Â
Field Order
| Order | Field Name | Field Type | Required | Max Characters | Notes |
| 1 | Legacy ID | Alpha Numeric | Y | 50 | Company, Travel Agent/Wholesaler Spare Field 1 |
| 2 | Legacy ID Type | Alphabet | Y | 1 |
C = Company A = Travel Agent W = Wholesaler |
| 3 | Tariff Type | Alpha Numeric | Y | Â | Tariff Type Name |
| 4 | Property | Alpha Numeric | N | Â | Blank assigns Tariff Type to all properties |
| 5 | Valid From | Date | N | Â | See Date Format Below |
| 6 | Valid To | Date | N | Â | See Date Format Below |
Â
Date Format
All date fields must use the format DD-MMM-YYYY (25-JAN-2026).
Â
Import Validation
To ensure that your data is clean, consistent, and ready for the Live production environment after it has been validated and imported into the Training environment, follow these steps:
In the side menu of RMS Training, go to Setup > Company or Setup > Travel Agent for data review.Â
- Highlight a Company or Travel Agent and select the Edit icon.
- Navigate to the 'Rate Assignment' menu.
- Verify the correct Tariff (Rate) Types assigned.
Â
Downloadable Import File
The attached import file below contains the required file format for the Company, Travel Agent, Wholesaler Rate Type Link Import. Download the file and review the column headers. Populate the file with the data, ensuring that each line contains a Legacy ID Type, Legacy Master ID and Tariff Type.
Â
Next Article: Data Validation & Trial Imports
Â
Â
Comments
0 comments
Please sign in to leave a comment.