StoreCreditAccountCreditTransactions
Lists transactions that credit (increase) a store credit account.
Table-Specific Information
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The 本製品 processes other filters client-side within the 本製品.
- Id supports the '=, IN' comparison operators.
- CustomerStoreCreditAccountId supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM StoreCreditAccountCreditTransactions WHERE Id = 'Val1'
SELECT * FROM StoreCreditAccountCreditTransactions WHERE CustomerStoreCreditAccountId = 'Val1'
Insert
The following columns can be used to create a new record:
Amount, AmountCurrencyCode, ExpiresAt, CustomerStoreCreditAccountId
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally unique Id for the store credit account credit transaction. | |
| Amount | Decimal | True |
The transaction amount, expressed as a decimal value. | |
| AmountCurrencyCode | String | True |
The currency code of the transaction amount. | |
| RemainingAmount | Decimal | True |
The remaining credit balance after the transaction, expressed as a decimal value. | |
| RemainingAmountCurrencyCode | String | True |
The currency code of the remaining credit balance. | |
| ExpiresAt | Datetime | True |
The date and time when the transaction expires. Debit transactions always spend the soonest expiring credit first. | |
| BalanceAfterTransactionAmount | Decimal | True |
The account balance after the transaction, expressed as a decimal value. | |
| BalanceAfterTransactionCurrencyCode | String | True |
The currency code of the account balance after the transaction. | |
| CreatedAt | Datetime | True |
The date and time when the transaction was created. | |
| CustomerStoreCreditAccountId | String | True |
A globally unique Id for the associated customer store credit account. |