ShopifyPaymentsAccountBalanceTransactions
Displays all balance transactions for a Shopify Payments account, including payouts and adjustments.
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 ShopifyPaymentsAccountBalanceTransactions
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the Shopify Payments balance transaction. | |
| ShopifyPaymentsAccountId | String | The globally unique identifier of the Shopify Payments account associated with this balance transaction. | |
| NetAmount | Decimal | The total net amount that contributes to the merchant's balance after accounting for fees and adjustments, expressed as a decimal value. | |
| NetCurrencyCode | String | The three-letter ISO currency code representing the currency of the net amount (for example, USD or GBP). | |
| TransactionDate | Datetime | The date and time when the balance transaction was processed by Shopify Payments. | |
| SourceId | String | The identifier of the originating resource that triggered the balance transaction, such as an order, payout, or adjustment. | |
| SourceType | String | The type of resource or event that initiated the balance transaction, such as 'Order', 'Payout', or 'FeeAdjustment'. | |
| SourceOrderTransactionId | String | The unique identifier of the order transaction that resulted in this balance transaction, if applicable. | |
| AdjustmentReason | String | The explanation or reason for an adjustment related to this transaction. If the transaction is not an adjustment, the value is null. | |
| Type | String | The classification of the balance transaction, such as 'charge', 'refund', 'fee', or 'payout'. | |
| Test | Bool | Indicates whether this transaction occurred in test mode rather than live payment processing. | |
| Amount | Decimal | The total amount of the transaction before any fees or adjustments, expressed as a decimal value. | |
| AmountCurrencyCode | String | The three-letter ISO currency code representing the transaction's currency (for example, EUR or AUD). | |
| FeeAmount | Decimal | The total amount of fees deducted from the transaction, expressed as a decimal value. | |
| FeeCurrencyCode | String | The three-letter ISO currency code representing the currency in which fees were charged. | |
| AssociatedOrderId | String | The unique identifier of the order associated with this balance transaction. | |
| AssociatedOrderName | String | The name or order number of the associated Shopify order linked to the transaction. | |
| AssociatedPayoutId | String | The unique identifier of the payout linked to this transaction, if applicable. | |
| AssociatedPayoutStatus | String | The current status of the payout associated with the transaction, such as 'scheduled', 'in_transit', or 'paid'. |