ShopifyPaymentsAccount
Returns Shopify Payments account details, including balances, disputes, and payouts.
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 ShopifyPaymentsAccount
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique Id for the Shopify Payments account. | |
| Activated | Bool | Indicates whether the Shopify Payments setup is completed. | |
| Country | String | The country associated with the Shopify Payments account. | |
| Onboardable | Bool | Indicates whether the Shopify Payments account can be onboarded. | |
| DefaultCurrency | String | The default payout currency for the Shopify Payments account. | |
| PayoutStatementDescriptor | String | The descriptor used for payouts. This text appears on the merchant's bank statement when they receive a payout. | |
| PayoutScheduleInterval | String | The interval at which payouts are sent to the connected bank account. | |
| PayoutScheduleMonthlyAnchor | Int | The day of the month funds are paid out. Accepts values from 1–31. If set to monthly, payouts scheduled on the 29th–31st are sent on the last day of shorter months. | |
| PayoutScheduleWeeklyAnchor | String | The day of the week funds are paid out. Accepts values from Monday to Friday. Used when the payment interval is set to weekly. |