ShopifyPaymentsAccountBalanceTransactions

A list of balance transactions associated with a Shopify Payments account balance.

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 ShopifyPaymentsAccountBalanceTransactions


Name	Type	References	Description
Id [KEY]	String		A globally-unique ID.
ShopifyPaymentsAccountId	String	ShopifyPaymentsAccount.Id	A globally-unique ID.
NetAmount	Decimal		The net amount contributing to the merchant's balance. Decimal money amount.
NetCurrencyCode	String		The net amount contributing to the merchant's balance. Currency of the money.
TransactionDate	Datetime		The date and time when the balance transaction was processed.
SourceType	String		The source type of the balance transaction.
Type	String		The type of the transaction.
Test	Bool		Whether the transaction was created in test mode.
Amount	Decimal		Decimal money amount.
AmountCurrencyCode	String		Currency of the money.
FeeAmount	Decimal		Decimal money amount.
FeeCurrencyCode	String		Currency of the money.
AssociatedOrderId	String		The ID of the associated order.
AssociatedOrderName	String		The name of the associated order.
AssociatedPayoutId	String		The ID of the payout associated with the balance transaction.
AssociatedPayoutStatus	String		The status of the payout associated with the balance transaction.