BankAccountByV1Id
Retrieve a bank account by its legacy Square V1 bank account ID.
Table Specific Information
Select
The add-in uses the Square API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the add-in.
- V1BankAccountId supports the following operator: =.
Retrieve a bank account by its legacy V1 bank account ID:
SELECT * FROM BankAccountByV1Id WHERE V1BankAccountId = 'LEGACY_BANK_ACCOUNT_ID'
Columns
| Name | Type | Description |
| Id [KEY] | String | The Square-issued ID of the bank account. |
| AccountNumberSuffix | String | The last few digits of the bank account number. |
| Country | String | The ISO 3166 Alpha-2 country code where the bank account is based. |
| Currency | String | The ISO 4217 currency code associated with the bank account. |
| LocationId | String | The ID of the location that the bank account is associated with. |
| AccountType | String | The type of the bank account (e.g., CHECKING, SAVINGS, INVESTMENT). |
| HolderName | String | The name associated with the bank account. |
| PrimaryBankIdentificationNumber | String | The primary identifier for the bank (e.g., routing number in the US). |
| Status | String | The current verification status of this bank account. |
| Creditable | Boolean | Indicates whether Square can send money to this bank account. |
| Debitable | Boolean | Indicates whether Square can take money from this bank account. |
| BankName | String | The name of the bank that manages this account. |
| Version | Integer | The current version of the bank account. |
Pseudocolumns
Pseudo column fields are used in the WHERE clause of SELECT statements (unless stated otherwise) and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| V1BankAccountId | String | The V1 identifier of the bank account. Used to retrieve the bank account via the legacy Square API. |