Quoted Rate Import
Information on the requirements for the Quoted Rate Import available in RMS.
Import Information
- The file to be imported must be in a comma delimited .csv format (Field Delimiter).
- If a data field within this file contains commas, it should be surrounded with "double quotes" (Text Delimiter).
- Line returns should be replaced with the pipe character '|'. (Usually found on the backslash key).
- Microsoft Excel is able to save using a.csv format that should match these requirements.
-
RMS is able to determine whether the first record is a header record.
Warning
The Quoted Rate Import will override any existing rates on reservations and record the nightly breakdown.
Reservation Stay Dates not covered by the import will display a value of $0.
Field Order
| Order |
Field Name |
Field Type |
Required |
Max Charaters |
RMS Equivalent |
| 1 |
Legacy Res ID |
Alpha Numeric |
Y |
50 |
Legacy Res ID |
| 2 |
Date |
Date |
Y |
50 |
Date Rate Applies |
| 3 |
Total_Rate |
Numeric |
Y |
|
Base Rate Amount |
| 4 |
Charge Type |
Alpha Numeric |
N |
|
Rate Type |
Sample File
Quoted Rate.csv
How could we improve this answer?