Description
The card transactions CSV is a list of transactions that occurred in the reporting period via the virtual debit card product. 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 | v3.0+ |
Timestamp | The timestamp when the transaction occurred | v3.0+ |
Transaction Type | The type of the transaction (either card_purchase or card_refund) | v3.0+ |
Related Catch Order ID | Catch's unique identifier for the order. This can be used to tie capture and refund events back to an order. | v3.0+ |
Network Transaction ID | The ID provided through the card network for the given transaction. | v3.0+ |
Card Number Last Four | The last four digits of the Catch card used for the transaction. | v3.0+ |
Catch User ID | Catch’s unique internal identifier for the user that created the transaction | v3.0+ |
External Amount | The amount the merchant provided to Catch for the transaction. This amount is prior to any reward adjustments or fees. | v3.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. | v3.0+ |
Catch Fees | The total amount of Catch Fees charged for this transaction | v3.0+ |
Transaction Adjustment Amount | The impact of transaction adjustments on the Net Transaction Amount. | v3.0+ |
Net Billed Amount | The total costs from the transaction to be netted against the daily settlement. A negative amount is owed to Catch and a positive amount is owed to you. Net Billed Amount = Net Redeemed Rewards + Catch Fees | v3.0+ |
Billed via Settlement | True if the costs of the transactions are being netted against the daily settlement. | v3.0+ |
Merchant ID | Catch identifier for brand; This can be used to distinguish between brand reports when managing multiple Catch integrated brands. | v3.0+ |