Log a Service Request for assistance from our Customer Support Team.

    Alternatively, enter your question below to request a new article in the Help Centre.


    Repeat Charge Import

    Information on the requirements for the Repeat Charge Import available in RMS.

    Import Information

    • The file to be imported must be in a comma delimited .csv format (Field Delimiter).
    • If a data field within this file contains commas, it should be surrounded with "double quotes" (Text Delimiter).
    • Line returns should be replaced with the pipe character '|'. (Usually found on the backslash key).
    • Microsoft Excel is able to save using a .csv format that should match these requirements.
    • RMS is able to determine whether the first record is a header record.


    Field Order

    Order Field Name Field Type Required Max Characters Notes
    1 Legacy Res ID Alpha Numeric Y 50 Legacy Res ID

    2

    Legacy ID Type Alpha Numeric Y   Use 1 for Res Account
    3 Account Type Alpha Numeric Y   See Below 'Account Type Values'
    4 Sundry Alpha Numeric Y   Sundry Charge Description
    5 Initial Trans True/False     Create an Initial Transaction
    6 Initial Start Date if initial trans is True   Initial Transaction Start Date
    7 Initial End Date if initial trans is True   Initial Transaction End Date
    8 Initial Amount Numeric if initial trans is True   Amount of Initial Transaction
    9 Repeat Every Numeric     Frequency to Repeat the Charge
    10 Repeat Period Alpha Y   Day | Week | Month
    11 Amount Numeric Y   Amount to charge.
    12 Use Sundry Amt True/False     Use the amount set against the set Sundry Charge
    13 Daily Rate True/False     Amount entered is to be multiplied by the number of days within the Repeat Charge frequency range.
    14 Limit Last Charge True/False     Will prorata the final repeat charge to stop on the end date.
    15 Show Paid to True/False     Show Paid To on the account screen.
    (Only one repeat per account can have this flag.)
    16 Use Arrive True/False if no Start Date   Use the Arrival Date of the Reservation as the Start Date.
    17 Start Date Date if no Use Arrive   Specify a Start Date.
    18 Use Depart True/False if no End Date   Use the Departure Date as the End Date.
    19 Inc Depart Day True/False     Include Departure Date in Charged Dates.
    20 End Date Date in no Use Depart   Specify an End Date
    21

    Periods to Roll

    Numeric    

    Specify the number of Repeat Charge cycles to post to the account.


    Account Type Values

    • 1 - Accom
    • 2 - Extras
    • 3 - Phone
    • 4 - Gas
    • 5 - Electricity
    • 6 - Water
    • 8 - Internet


    Sample File

    Repeat Charge Import.csv

    Was this article helpful?

    Send Feedback

    Can’t find what you’re looking for?

    Our team of RMS experts are here for you!

    Submit a Question