The Search and Reporting functionality in RPM provides the ability for you to download the results of your queries or reports to a CSV format. CSV format files can be imported in Excel for further analysis.
Here's the format for the CSV Output file: (18 field)
| Field Index | Field Name | Field Format |
| 1 | Name (Cardholdername) | 30 characters maximum |
| 2 | Account Name | |
| 3 | Ref Num | 20 characters maximum |
| 4 | Cust.Ref Num (Customer_Ref) | 20 characters maximum |
| 5 | Card Type | |
| 6 | Status | |
| 7 | Auth No (Authorization Number) | 6 digit maximum |
| 8 | Time (Transaction Time) | MM/DD/YY HH:MM |
| 9 | Merchant Name | |
| 10 | Terminal Name | |
| 11 | Expiry Date | MMYY (no slash) |
| 12 | Gateway (Gateway ID) | Annnnn-nn (e.g. A12345-01) |
| 13 | Merchant Code | |
| 14 | Tag |
|
| 15 | Amount |
$0.00 format |
| 16 | Cardnumber |
16 digit card number |
| 17 | Code (Transactioncode) |
applicable transaction code |
| 18 | Reference_3 |
30 characters maximum |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article