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.|
|Y||The posting date for the transaction.|
|5||Comment||Alpha Numeric||N||100||Any extra information about the transaction|
The amount for the transaction.
Should be a positive amount.
|7||Receipt Type||Numeric|| |
|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.|