Description of _refund

All <date>_refund_*.csv files are built the same way. The date is always in UTC format.

The following files are on the SFTP server for transaction information:

YYYYMMDDZ_refund_failed.consolidated.csv

YYYYMMDDZ_refund_fundsrejected.consolidated.csv

YYYYMMDDZ_refund_fundssent.consolidated.csv

YYYYMMDDZ_refund_succeeded.consolidated.csv

Explanation of fields:

Title	Description	Type
`REFUNDID`	The PPRO-generated Refund ID	numeric
`REFUNDSTATE`	The state of the refund	string
`FAILTYPE`	Failtype (if the refund failed)	string
`FUNDSSTATE`	The state of funds	string
`AMOUNT`	The amount of transaction in cents	numeric
`CURRENCY`	The currency of transaction (EUR, USD, PLN, etc.)	string
`REFTXID`	The PPRO transaction ID against which the refund was issued	numeric
`MERCHANTREFUNDID`	The merchant refund ID (if provided)	string
`INITTS`	The timestamp of the refund initiation (UTC time)	string
`SUCCEEDEDTS`	The UTC-format timestamp if the refund state changed to `succeeded`	string
`FAILEDTS`	The UTC-format timestamp if the refund state changed to `failed`	string
`FUNDSSENTTS`	The UTC-format timestamp if the refund changed to `sent`	string
`FUNDSREJECTEDTS`	If an error occurred the human readable error text for the specific refund	string
`ERRORTEXT`	If an error occurred: the human-readable error text for the specific transaction	string
`MCONTRACT`	If using consolidated files: the merchant contract ID	string