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. |