ShopifyPaymentsAccountBalanceTransactions
A list of balance transactions associated with a Shopify Payments account balance.
View-Specific Information
Select
The add-in uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.
- ShopifyPaymentsAccountId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM ShopifyPaymentsAccountBalanceTransactions
SELECT * FROM ShopifyPaymentsAccountBalanceTransactions WHERE ShopifyPaymentsAccountId = 'Val1'
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. |