StoreCreditAccountCreditTransactions
Logs credit transactions that increase store credit account balances, such as issued refunds or promotions.
Table-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.
- 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 identifier for the store credit transaction record. | |
| Amount | Decimal | True |
The total monetary value of the store credit applied in this transaction, represented as a decimal amount. | |
| AmountCurrencyCode | String | True |
The three-letter ISO currency code for the transaction amount (for example, USD or EUR). | |
| RemainingAmount | Decimal | True |
The remaining unspent store credit available from this transaction, represented as a decimal amount. | |
| RemainingAmountCurrencyCode | String | True |
The three-letter ISO currency code corresponding to the remaining balance currency. | |
| ExpiresAt | Datetime | True |
The exact date and time when the store credit transaction expires. Debit transactions automatically consume credits that are closest to expiry first. | |
| BalanceAfterTransactionAmount | Decimal | True |
The customer's total store credit balance immediately after this transaction, expressed as a decimal value. | |
| BalanceAfterTransactionCurrencyCode | String | True |
The three-letter ISO currency code representing the balance currency after this transaction. | |
| CreatedAt | Datetime | True |
The date and time when the store credit transaction was recorded in the system. | |
| CustomerStoreCreditAccountId | String | True |
The globally unique identifier of the customer's store credit account associated with this transaction. |