BankAccountByV1Id
Retrieve a bank account by its legacy Square V1 bank account ID.
Table Specific Information
Select
The connector 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 connector.
- 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. |