BankAccountTokens

Create and query the available Bank Account Tokens in Stripe.

Table Specific Information

Select

Server-Side Query Support

The adapter will use 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 adapter.

Id supports the following operator: =.

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

SELECT * FROM BankAccountTokens WHERE Id='btok_12345678'

Insert

To insert into BankAccountTokens, Country, Currency, 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	False		The bank account this token will represent.
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	False		Name of the bank associated with the routing number.
Fingerprint	String	False		Uniquely 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		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	False		The IP address of the client that generated the token.
Created	Datetime	True		The datetime of the token.
Used	Boolean	False		Whether or not this token has already been used.
LiveMode	Boolean	False		Has the value true if the object exists in live mode or the value false if the object exists in test mode.
Type	String	False		Type of token.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
CustomerId	String	The Id of the customer to create a token for.
AccountId	String	The Id of the connected account to get bank account tokens for