ShopifyPaymentsAccount

Returns Shopify Payments account information, including balances and payouts.

View-Specific Information

The connector processes all filters client-side within the connector. The following query is the only one processed server side:

  SELECT * FROM ShopifyPaymentsAccount


Name	Type	References	Description
Id [KEY]	String		A globally-unique ID.
Activated	Bool		Whether the Shopify Payments setup is completed.
Country	String		The Shopify Payments account country.
Onboardable	Bool		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. The descriptor appears on a merchant's bank statement when they receive a payout.
FraudSettingsDeclineChargeOnAvsFailure	Bool		Decline a charge if there is an AVS failure.
FraudSettingsDeclineChargeOnCvcFailure	Bool		Decline a charge if there is an CVC failure.
NotificationSettingsPayouts	Bool		Receive email notifications when new payouts are sent or payouts fail.
PayoutScheduleInterval	String		The interval at which payouts are sent to the connected bank account.
PayoutScheduleMonthlyAnchor	Int		The day of the month funds will be paid out. The value can be any day of the month from the 1st to the 31st. If the payment interval is set to monthly, this value will be used. Payouts scheduled between 29-31st of the month are sent on the last day of shorter months.
PayoutScheduleWeeklyAnchor	String		The day of the week funds will be paid out. The value can be any weekday from Monday to Friday. If the payment interval is set to weekly, this value will be used.