Payment Refunds File Field Specification (CSV)
payment_refunds_in.csv
payment_refunds_in.csv.resp
File format is standard CSV (http://www.ietf.org/rfc/rfc4180.txt).
| Field Index | Description | Format | Required | Max Len |
|---|---|---|---|---|
| 1 | Refund Amount | 99999999.99 | Yes | 12 |
| 2 | Transaction ID | Yes | 36 | |
| 3 | First Name | No | 50 | |
| 4 | Last Name | No | 50 | |
| 5 | Tracking ID | No | 50 | |
| 6 | Memo | No | 200 |
Example record
"120.54","B5Gr6U2Zh0","JOHN","SMITH","EOB2010289","Automatic refund of overpayment"
Response File
A response file will be generated during the import of the refunds file. There will be a row in the response file for each record processed. The row will contain the line number in the refunds file being processed and the Transaction ID. The results of the refund and a new Transaction ID for the refuld will also be included. If an exception occurs during the processing of a record, the details of the exception will be included at the end of the row.
| Field Index | Description | Format | Max Len |
|---|---|---|---|
| 1 | Input Row Number | 9999 | 12 |
| 2 | Input Transaction ID | 36 | |
| 3 | Refund Results | 20 | |
| 4 | Refund Transaction ID | 36 | |
| 5 | Refund Message | 500 | |
| 6 | Refund Timestamp | ISO 8601 | 20 |
Refund Results Values
| Value | Description |
|---|---|
| APPROVED | The refund was approved |
| DECLINED | The refund was declined |
| FAILED | The refund could not be completed |
Example response file
"1","B5Gr6U2Zh0","APPROVED","A56GFCIct9","Approved","2016-03-15T22:01:46Z" "2","DCTFE2FJW0","FAILED",,"Payment not found","2016-03-15T22:01:46Z"