Add Ons Import
Information on requirements for importing Add Ons into RMS.
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 |
Sample File
Add On.csv
How could we improve this answer?