ShopifyPaymentsAccountBalanceTransactions
Lists balance transactions associated with the account's balances.
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 Id for the balance transaction. | |
| ShopifyPaymentsAccountId | String | A globally unique Id for the associated Shopify Payments account. | |
| NetAmount | Decimal | The net amount contributing to the merchant's balance, expressed as a decimal value. | |
| NetCurrencyCode | String | The currency code of the net amount contributing to the merchant's balance. | |
| TransactionDate | Datetime | The date and time when the balance transaction was processed. | |
| SourceId | String | The Id of the resource that led to the transaction. | |
| SourceType | String | The type of source that generated the balance transaction. | |
| SourceOrderTransactionId | String | The Id of the order transaction that resulted in this balance transaction. | |
| AdjustmentReason | String | The reason for the adjustment associated with the transaction. Null if the source type is not an adjustment. | |
| Type | String | The type of balance transaction. | |
| Test | Bool | Indicates whether the transaction was created in test mode. | |
| Amount | Decimal | The gross transaction amount, expressed as a decimal value. | |
| AmountCurrencyCode | String | The currency code of the gross transaction amount. | |
| FeeAmount | Decimal | The transaction fee amount, expressed as a decimal value. | |
| FeeCurrencyCode | String | The currency code of the transaction fee amount. | |
| AssociatedOrderId | String | The Id of the order associated with the balance transaction. | |
| AssociatedOrderName | String | The name of the order associated with the balance transaction. | |
| AssociatedPayoutId | String | The Id of the payout associated with the balance transaction. | |
| AssociatedPayoutStatus | String | The status of the payout associated with the balance transaction. |