Transfers
Create, update, and query the available transfers in Stripe.
Table Specific Information
Select
Server-Side Query Support
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.
- Id, AccountId and Destination support the following operator: =.
- Created support the following operators: <,>>=,<,<=, =.
The provider supports all columns to be used as criteria in the WHERE clause of a SELECT statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you can still retrieve:
-a Transfer by specifying its Id:
SELECT * FROM Transfers WHERE Id = 'tr_12345678'
-a Transfer created after a specific date (Created may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range):
SELECT * FROM Transfers WHERE Created = '2023-07-21 19:00:27.0'
-Transfers created after a specific date (Created may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range):
SELECT * FROM Transfers WHERE Created > '12/2/2015'
Insert
Currency, Amount, and Destination are required to insert into this table. The Destination is the Id of a connected Stripe account:
INSERT INTO Transfers (Amount, Currency, Destination, TransferGroup) VALUES (1000, 'USD', 'acct_19abC2DFGl5DVRzj', 'ORDER_95')
Update
To update a transfer, set a description or metadata and specify an Id in the WHERE clause:
UPDATE Transfers SET Description = 'New desc', MetadataAggregate = '{\"test\" : \"test\"}' WHERE Id = 'tr_123456788' )
Delete
Delete is not supported.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The Id of the transfer. | |
| Currency | String | False |
The currency. | |
| Amount | Integer | False |
Amount (in cents) to be transferred to your bank account. | |
| AmountReversed | Integer | True |
Amount in cents reversed (can be less than the amount attribute on the transfer if a partial reversal was issued). | |
| ApplicationFee | String | True |
The application fee. | |
| BalanceTransaction | String | True |
Balance transaction that describes the impact of this transfer on your account balance. | |
| Created | Datetime | True |
Time that this record of the transfer was first created. | |
| Date | Datetime | True |
Date the transfer is scheduled to arrive in the bank. This doesn't factor in delays like weekends or bank holidays. | |
| Description | String | False |
Internal-only description of the transfer. | |
| Destination | String | False |
The Id of the bank account, card, or Stripe account the transfer was sent to. | |
| DestinationPayment | String | True |
If the destination is a Stripe account, this will be the Id of the payment that the destination account received for the transfer. | |
| FailureCode | String | True |
Error code explaining reason for transfer failure if available. | |
| FailureMessage | String | True |
Message to user further explaining reason for transfer failure if available. | |
| Reversed | Boolean | True |
Whether or not the transfer has been fully reversed. If the transfer is only partially reversed, this attribute will still be false. | |
| SourceTransaction | String | False |
The Id of the charge (or other transaction) that was used to fund the transfer. If null, the transfer was funded from the available balance. | |
| SourceType | String | False |
The source balance this transfer came from. | |
| StatementDescriptor | String | True |
Extra information about a transfer to be displayed on the user's bank statement. | |
| Status | String | True |
Current status of the transfer. | |
| Type | String | True |
The type of the transfer.Can be card, bank_account, or stripe_account. | |
| MetadataAggregate | String | False |
The transfer metadata object. | |
| Object | String | True |
String representing the object's type. Objects of the same type share the same value. | |
| Livemode | Boolean | True |
Has the value true if the object exists in live mode or the value false if the object exists in test mode. | |
| ReversalsAggregate | String | True |
A list of reversals that have been applied to the transfer. | |
| TransferGroup | String | False |
A string that identifies this transaction as part of a group. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AccountId | String |
The Id of the connected account to get transfers for. |