ShopifyPaymentsAccountBankAccounts
Lists connected bank accounts used for Shopify Payments deposits and withdrawals.
View-Specific Information
Select
The connector processes all filters client-side within the connector. The following query is the only one processed server-side:
SELECT * FROM ShopifyPaymentsAccountBankAccounts
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the Shopify Payments bank account record. | |
| ShopifyPaymentsAccountId | String | The globally unique identifier of the Shopify Payments account linked to this bank account. | |
| BankName | String | The official name of the financial institution where the merchant's payouts are deposited. | |
| Country | String | The country where the bank account is registered and operates. | |
| Currency | String | The three-letter ISO currency code representing the currency in which payouts are made to this bank account. | |
| Status | String | The current status of the bank account, such as 'active', 'pending_verification', or 'disabled'. | |
| AccountNumberLastDigits | String | The last few digits of the merchant's bank account number, displayed for reference while the rest remains securely redacted. | |
| CreatedAt | Datetime | The date and time when the bank account was added or linked to the Shopify Payments account. |