Contact Support


    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.

    Info

    Rows 9-15 are available in RMS 9+ Version 10.19.224.3 or above.



    Sample File

    Requirements.csv

    Was this article helpful?

    Send Feedback

    Can’t find what you’re looking for?

    Contact Support