BankAccountTokens

Returns the bank account tokens in Stripe, which represent a bank account in a way that can be securely shared and used to create payment sources.

Table-Specific Information

SELECT

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


Column	Supported Operators
Id	=
AccountId	=

To query the BankAccountTokens table, the Id of desired token is required:

SELECT * FROM BankAccountTokens WHERE Id = 'btok_12345678'

INSERT

To insert into BankAccountTokens, Country, and AccountNumber are required:

INSERT INTO BankAccountTokens (Country, Currency, AccountHolderName, AccountHolderType, AccountNumber, RoutingNumber) VALUES ('US', 'USD', 'Sab nu', 'individual', '000123456789', '110000000')

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id of the token.
BankAccountId	String	True	BankAccounts.Id	The Id of the bank account this token represents.
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.
AccountType	String	False		The type of the bank account, such as checking or savings.
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.
Fingerprint	String	True		A unique identifier for the bank account, which you can use 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.
Country	String	False		The two-letter ISO code representing the country in which the bank account is located.
Currency	String	False		The currency of the bank account.
ClientIp	String	True		The IP address of the client that generated the token.
Created	Datetime	True		The date and time at which the token was created.
Used	Boolean	True		Indicates whether this token has already been used.
LiveMode	Boolean	True		Indicates whether the object exists in live mode. Returns false if the object exists in test mode.
Type	String	True		The type of the token.

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.