TransferReversals

Represents the reversals belonging to a specific transfer, including the reversed amount, linked refunds, and balance transaction details.

Table-Specific Information

SELECT

The connector uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the connector.


Column	Supported Operators
Id	=
Transfer	=
AccountId	=

To query the TransferReversals table, the Id of the transfer whose reversals are retrieved is required:

SELECT * FROM TransferReversals WHERE Transfer = 'tr_12345678'

INSERT

The Transfer column is required to insert to this table:

INSERT INTO TransferReversals (Amount, Transfer) VALUES (2000, 'tr_12345678')

UPDATE

To update metadata in this table, specify both the Id and Transfer values:

UPDATE TransferReversals SET Metadata = '{"Description": "test metadata update"}' WHERE Id = 'trr_13jgn4kj' AND Transfer = 'tr_12345678'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id of the reversal.
Transfer [KEY]	String	False	Transfers.Id	The Id of the transfer that was reversed.
Amount	Integer	False		A positive integer, in cents, representing how much of this transfer to reverse.
RefundApplicationFee	Boolean	False		Indicates whether the application fee is refunded when reversing this transfer. This field is used only during insert operation and is not returned in response.
Currency	String	True		The three-letter ISO currency code of the reversal, in lowercase.
Metadata	String	False		The set of key-value pairs that you can attach to the transfer reversal. This is useful for storing additional information about the reversal in a structured format.
Object	String	True		The string representing the object's type. Objects of the same type share the same value.
BalanceTransaction	String	True		The balance transaction that describes the impact on your account balance.
DestinationPaymentRefund	String	True		The linked payment refund for the transfer reversal.
Created	Datetime	True		The time at which the transfer reversal was created, measured in seconds since the Unix epoch.
SourceRefund	String	True		The Id of the refund responsible for the transfer reversal.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
Description	String	An arbitrary string that you can attach to a reversal. It is displayed alongside the reversal in the dashboard. This value is unset if you POST an empty value.
AccountId	String	The Id of the connected account to get transfer reversals for.