StoreCreditAccountExpirationTransactions
Lists store credit expiration events when unused balances expire after a set duration.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- CustomerStoreCreditAccountId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM StoreCreditAccountExpirationTransactions WHERE CustomerStoreCreditAccountId = 'Val1'
Columns
| Name | Type | References | Description |
| Amount | Decimal | The monetary value of store credit that has expired and is no longer available for use. Decimal money amount. | |
| AmountCurrencyCode | String | The three-letter ISO currency code representing the currency of the expired credit amount (for example, USD or EUR). | |
| CreditTransactionId | String | The globally unique identifier of the original credit transaction that has now expired. | |
| BalanceAfterTransactionAmount | Decimal | The remaining store credit balance after the expiration was processed, expressed as a decimal money amount. | |
| BalanceAfterTransactionCurrencyCode | String | The three-letter ISO currency code corresponding to the balance remaining after the expiration transaction. | |
| CreatedAt | Datetime | The date and time when the expiration transaction was created and recorded in the system. | |
| CustomerStoreCreditAccountId | String | The globally unique identifier of the customer's store credit account associated with this expiration transaction. |