BankAccounts
Returns the bank accounts attached to a customer in Stripe, including account holder, routing, and payout details.
Table-Specific Information
SELECT
The component 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 component.
| Column | Supported Operators |
| Id | = |
| CustomerId | = |
| AccountId | = |
To query the BankAccounts table, CustomerId is required:
SELECT * FROM BankAccounts WHERE CustomerId = 'cus_12345678'
INSERT
To create a new bank account, specify Country, Currency, and AccountNumber. CustomerId and Object are required:
INSERT INTO BankAccounts (AccountNumber, Country, Currency, Object, AccountHolderName, AccountHolderType, MetadataAggregate, CustomerId, RoutingNumber) VALUES (000999999991, 'US', 'usd', 'bank_account', 'Test1', 'company', '[{\"Check\":\"123\",\"QWERTY\":\"456\"}]', 'cus_PEDFTqrddhgBaF', 110000000)
UPDATE
To update a bank account, specify an Id and a CustomerId:
UPDATE BankAccounts SET AccountHolderName = 'My Name', AccountHolderType = 'individual' WHERE Id = 'ba_12345678' AND CustomerId = 'cus_12345678'
DELETE
To delete a bank account, specify an Id and a CustomerId:
DELETE FROM BankAccounts WHERE Id = 'ba_12345678' AND CustomerId = 'cus_12345678'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique identifier for the bank account. | |
| CustomerId [KEY] | String | False |
Customers.Id |
The Id of the customer this account belongs to. |
| Account | String | True |
Accounts.Id |
The Id of the account. |
| AccountHolderName | String | False |
The name of the person or business that owns the bank account. | |
| AccountHolderType | String | False |
The type of entity that holds the account. | |
| AccountNumber | String | False |
The account number for the bank account, in a format that can vary by country. | |
| BankName | String | True |
The name of the bank associated with the routing number. | |
| Country | String | False |
The two-letter ISO code representing the country in which the bank account is located. | |
| Currency | String | False |
The three-letter ISO currency code representing the currency paid out to the bank account. | |
| DefaultForCurrency | Boolean | True |
Indicates whether this bank account is the default external account for its currency. | |
| Fingerprint | String | True |
A unique identifier for this particular bank account. You can use this attribute to check whether two bank accounts are the same. | |
| Last4 | String | True |
The last 4 digits of the bank account number. | |
| RoutingNumber | String | False |
The routing transit number for the bank account. | |
| Status | String | True |
The status of the bank account. | |
| AccountType | String | True |
The bank account type. This can only be checking or savings in most countries. In Japan, this can only be futsu or toza. | |
| MetadataAggregate | String | False |
The set of key-value pairs that you can attach to the bank account object. | |
| Object | String | True |
The string representing the object's type. Objects of the same type share the same value. The allowed values are bank_account. | |
| AvailablePayoutMethods | String | True |
A set of available payout methods for this bank account. Only values from this set should be passed as the method when creating a payout. |
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 |
| Source | String |
The Id of the token used to create the bank account. |
| AccountId | String |
The Id of the connected account for which to retrieve bank accounts. |