BankAccountTokens

Returns the available Bank Account Tokens in Stripe and supports creating them.

Table-Specific Information

SELECT

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


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		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 entity that holds the account type.
AccountNumber	String	False		The type of entity that holds the account number.
BankName	String	True		The name of the bank associated with the routing number.
Fingerprint	String	True		The unique identifier.
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 account.
Country	String	False		Two-letter ISO code representing the country the bank account/card is located in.
Currency	String	False		The currency of the card.
ClientIp	String	True		The IP address of the client that generated the token.
Created	Datetime	True		The date and time of the token.
Used	Boolean	True		Indicates whether this token has already been used.
LiveMode	Boolean	True		Indicates whether the object exists in live mode. The value is true in live mode and false in test mode.
Type	String	True		The type of 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.