Receipt Import
Overview
This file allows the import of receipt transactions from a standard Comma Delimited file into the RMS system. Other types of financial transactions can also be imported separately using the following file definitions:
You must be able to provide a CSV file in the format as indicated below. It may be necessary to seek technical advice in order to create your file in the format that RMS requires.
Please Note: Depending on your existing system or source data this file format may vary. Please consult RMS support if unsure
Sample File - Pending
Important Information
- Transactions can only be imported after Reservations have been imported or created in RMS.
- The file to be imported must be in a comma delimited CSV format (Field Delimiter).
- If a data field within this file contain commas, it should be surrounded with "double quotes" (Text Delimiter).
- 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 or not, thus it is not necessary to strip the header record (field names) prior to the import
- Guest Accounts cannot be imported for RMSCentral databases.
- All Date fields must be supplied in DD-MMM-YYYY format.
- CreditCardTypes must already exist in RMS
- Transactions will show as being created by the user 'System Import'.
Field Order - All fields must not contain commas
| Order | Field Name | Field Type | Required | Max Characters | Description |
|---|---|---|---|---|---|
| 1 | Legacy ID | Alpha Numeric | Y | 50 | Legacy System ID. (Imported during previous imports. Used to find the correct account for the transaction). |
| 2 | Legacy ID Type | Numeric | Y | 1 | Specifies the type of Legacy ID provided for the transaction. Valid values below. |
| 3 | Account Type | Numeric | Y | 1 | The account type for the Transaction. Valid values below. |
| 4 | Date | Date DD-MMM-YYYY | Y | The posting date for the transaction. | |
| 5 | Comment | Alpha Numeric | N | 100 | Any extra information about the transaction |
| 6 | Amount | Numeric | Y | The amount for the transaction. Should be a positive amount. | |
| 7 | Receipt Type | Numeric | Y | 1 | The type of receipt for receipt transactions. Valid values below. |
| 8 | CreditCardType | Alpha Numeric | Required if Receipt Type of EFTPOS is provided. | 50 | The Credit card type for Credit Card receipts. |
| 9 | Cheque Number | Alpha Numeric | Required if Receipt Type of Cheque is provided | The Cheque Number for Cheque receipts. |
Valid Values
Legacy ID Type
1 - Res
2 - Guest
3 - Company
4 - Travel Agent
5 - Group Res
Account Type
1 - Accom
2 - Extras
3 - Phone
4 - Gas
5 - Electricity
6 - Water
8 - Internet
Receipt Type
1 - Cash
2 - Cheque
4 - EftPOS
5 - Journal
8 - DirectCredit
Classifications
- © Copyright 2015 RMS