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.
SourceId	String		The ID of the resource leading to the transaction.
SourceType	String		The source type of the balance transaction.
SourceOrderTransactionId	String		The id of the Order Transaction that resulted in this balance transaction.
AdjustmentReason	String		The reason for the adjustment that's associated with the transaction. If the source_type isn't an adjustment, the value will be null.
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.