Rate Type Import
Information on the requirements for the Rate Type 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 contain 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.
Field Order
Order | Field Name | Field Type | Required | Max Charaters | RMS Equivalent |
---|---|---|---|---|---|
1 | ChargeType | String | Y | 50 | Rate / Charge Type |
2 | short_description | String | Y | 50 | Rate Charge Description |
3 | Structure | String |
Y | 6 | OTA or Direct Rates |
4 | Code | String | N | 50 | |
5 | Long Description | String | N | 500 | |
6 | G/L Acc Code | String | N | 50 | |
7 | Discount | String | N | 20 | |
8 | Grouping | String | N | 50 | |
9 | Advance Puchase | Numeric | N | 3 | |
10 | Last Minute | Numeric | N | 3 | |
11 | Refundable Charge | String | N | 20 | |
12 | Booking Source | String | N | 20 | |
13 | Market Segment | String | N | 20 | |
14 | Cancellation Policy | String | N | 20 | |
15 | Meal Plan | String | N | 20 | |
16 | Contracted Rate | True/False | N | Blank = False | |
17 | BAR Rate | True/False | N | Blank = False | |
18 | No Discount Allowed | True/False | N | Blank = False | |
19 | Only Available to Members | True/False | N | Blank = False | |
20 | Do not Use Promo | True/False | N | Blank = False | |
21 | Base Rate Override | True/False | N | Blank = False | |
22 |
Status |
String |
Y |
Y |
Value = Active or Inactive |