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
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. |