Description
The transactions CSV is a list of transactions that occurred via the integrated payment method in the reporting period. This includes both purchase and refunds.
Note, as above, that because Catch does not pull funds, the transactions in this CSV may be different from those in the settlement events CSV. For example, if a merchant carries a negative balance into the reporting period, we may include transactions from prior to the reporting period in the settlement events CSV but not here. If a merchant carries a negative balance out of the reporting window, we may include transactions here but not in the settlement events CSV.
Columns
| Column Name | Description | Report Version |
|---|---|---|
| Catch Transaction ID | Catch’s unique internal identifier for the transaction | v2.0+ |
| Timestamp | The timestamp when the transaction occurred | v2.0+ |
| Transaction Type | The type of the transaction (either purchase or refund) | v2.0+ |
| Related Catch Transaction ID | Only populated for refunds: The ID of the purchase that is being refunded | v2.0+ |
| Merchant Transaction ID | The ID the merchant provided to Catch for the transaction Note: This value will only be populated if supplied by the merchant | v2.0+ |
| Catch User ID | Catch’s unique internal identifier for the user that created the transaction | v2.0+ |
| Merchant User ID | The ID the merchant provided to Catch for the user Note: This value will be blank on Refund transactions and will only be populated on Purchase transactions if supplied by the merchant | v2.0+ |
| External Amount | The amount the merchant provided to Catch for the transaction. This amount is prior to any reward adjustments or fees. | v2.0+ |
| Net Redeemed Rewards | The impact reward redemptions had on the Net Transaction Amount. A reward redemption would result in a negative value. A refund of a purchase on which credits were redeemed would result in a positive value. | v2.0+ |
| Catch Fees | The total amount of Catch Fees charged for this transaction | v2.0+ |
| Transaction Adjustment Amount | The impact of transaction adjustments on the Net Transaction Amount. | v2.0+ |
| Net Transaction Amount | The amount owed to the merchant based on this transaction, after taking into account rewards and fees Net Transaction Amount = External Amount + Net Redeemed Rewards + Catch Fees | v2.0+ |
| Merchant ID | Catch identifier for brand; This can be used to distinguish between brand reports when managing multiple Catch integrated brands. | v2.1+ |