StoreCreditAccountDebitRevertTransactions
Displays debit reversal transactions created when a debit entry is voided or corrected.
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 StoreCreditAccountDebitRevertTransactions WHERE Id = 'Val1'
SELECT * FROM StoreCreditAccountDebitRevertTransactions WHERE CustomerStoreCreditAccountId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the debit revert transaction record. | |
| Amount | Decimal | The monetary value of the debit amount being reversed, represented as a decimal money value. | |
| AmountCurrencyCode | String | The three-letter ISO currency code representing the currency of the reversal amount (for example, USD or EUR). | |
| DebitTransactionId | String | The unique identifier of the original debit transaction that this reversal offsets or cancels. | |
| BalanceAfterTransactionAmount | Decimal | The customer's store credit balance immediately following the reversal, expressed as a decimal money amount. | |
| BalanceAfterTransactionCurrencyCode | String | The three-letter ISO currency code corresponding to the balance currency after the reversal is applied. | |
| CreatedAt | Datetime | The date and time when the debit reversal transaction was created and recorded in the system. | |
| CustomerStoreCreditAccountId | String | The globally unique identifier of the customer's store credit account associated with this reversal transaction. |