Requirement Import
Information on the requirements for the Requirement Import available in RMS.
Import Information
- The file to be imported must be in a comma delimited .csv format.
- 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 | Unique | Max Characters | Notes |
---|---|---|---|---|---|---|
1 | Legacy ID | Alpha Numeric | Y | 20 | Must Exisit in RMS | |
2 | Legacy ID Type | Numeric | Y |
1 = Reservation Requirement 2 = Guest Requirement |
||
3 | Requirement | Alpha Numeric | Y | 50 | Must Exist in RMS | |
4 | From Date | Date | Y | |||
5 | To Date | Date | Y | |||
6 | Required Daily | Yes/No | N | |||
7 | Housekeeping Requirement | Yes/No | N | |||
8 | Requirement Description | Alpha Numeric | N | |||
9 | Guest Facing | Yes/No | N | |||
10 | Sundry | Alpha Numeric | N | N | 50 | Must Exist in RMS |
11 | Quantity | Numeric | N | |||
12 | Unit Price | Numeric | N | |||
13 | Use Sundry Amt | Yes/No | N | Use the Unit Price setup on the Sundry Charge in RMS. | ||
14 | Chg Req Daily | Yes/No | N | If Sundry Charge should be posted to the account daily. | ||
15 | Inc To Date | Yes/No | N | If Requirement End Date should be included in posted charges. |