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. |