Import Information
- The file to be imported must be in a comma delimited .csv format (Field Delimiter).
- Data fields including a comma should be surrounded in "double quotes"(Text Delimiter).
- Line returns should be replaced with the pipe character '|'
- Microsoft Excel is able to save using a .csv format that should match these requirements.
- Header rows may be left in place as RMS can determine if there is a header row.
Field Order
Order | Field Name | Field Type | Required | Max Characters | notes |
---|---|---|---|---|---|
1 | Legacy Res ID | Alpha Numeric | Y | 50 | Legacy Res ID |
2 | From Date | Date | Y | Start date of Add On dd-mmm-yyyy | |
3 | To Date | Date | Y | End date of Add On dd-mmm-yyyy | |
4 | Use Arrive | True/False | Add on will follow Arr date if changed | ||
5 | Use Depart | True/False | Add on will follow Dep date if changed | ||
6 | Add On Type | Alpha Numeric | Y | 20 | Name of Add On Category |
7 | Add On | Alpha Numeric | Y | 20 | Name of Add On Area |
8 | Houskeeping | True/False | To show in HK report | ||
9 | Sundry | Alpha Numeric | 20 | Name of Sundry if Charging | |
10 | UseSundryAmt | True/False | Use amount from Sundry Charge | ||
11 | Daily Charges | True/False | Charge each day | ||
12 | Amount | Currency | Amount to Charge |