CustomerStoreCreditAccounts
Shows store credit account balances and transactions linked to individual customers.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- Id supports the '=, IN' comparison operators.
- CustomerId supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM CustomerStoreCreditAccounts WHERE Id = 'Val1'
SELECT * FROM CustomerStoreCreditAccounts WHERE CustomerId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A unique identifier for the customer store credit account record. | |
| CustomerId | String | The unique identifier of the customer who owns this store credit account. | |
| BalanceAmount | Decimal | The current balance of the customer's store credit, expressed as a decimal monetary amount. | |
| BalanceCurrencyCode | String | The three-letter ISO currency code representing the currency of the store credit balance. |