ApplicationFeeRefunds
Returns a list of application fees you've previously collected.
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.
- ApplicationFeeId supports the following operator: =.
- Id supports the following operator: =.
You can select from ApplicationFeeRefunds with the following queries:
SELECT * FROM ApplicationFeeRefunds WHERE ApplicationFeeId = 'fee_1ACvR6I2xUg5aQMAnqlDqwJY' SELECT * FROM ApplicationFeeRefunds WHERE Id = 'fr_A2ZYOWsSreeFvP'
Columns
Name | Type | References | Description |
Id [KEY] | String | The id of files. | |
ApplicationFeeId [KEY] | String | The Id of the application fee. | |
Amount | Integer | Amount, in cents. | |
BalanceTransaction | String | Balance transaction that describes the impact on your account balance. | |
Currency | String | Three-letter ISO currency code, in lowercase. Must be a supported currency. | |
Created | Datetime | Time at which the object was created. Measured in seconds since the Unix epoch. | |
MetadataAggregate | String | The set of key/value pairs that you can attach to a an object. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description | |
AccountId | String | The Id of the connected account to get files for. |