ShopifyPaymentsAccountBalanceTransactions
A list of balance transactions associated with a Shopify Payments account balance.
View-Specific Information
Select
The cmdlet processes all filters client-side within the cmdlet. 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. | |
| ShopifyPaymentsAccountId | String | 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. |