StoreCreditAccountDebitRevertTransactions
Lists debit-revert transactions created when a debit is reversed on a store credit account.
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 Id for the debit revert transaction. | |
| Amount | Decimal | The amount of the reverted debit transaction, expressed as a decimal value. | |
| AmountCurrencyCode | String | The currency code of the reverted debit transaction amount. | |
| DebitTransactionId | String | The Id of the original debit transaction being reverted. | |
| BalanceAfterTransactionAmount | Decimal | The account balance after the revert transaction, expressed as a decimal value. | |
| BalanceAfterTransactionCurrencyCode | String | The currency code of the account balance after the revert transaction. | |
| CreatedAt | Datetime | The date and time when the revert transaction was created. | |
| CustomerStoreCreditAccountId | String | A globally unique Id for the associated customer store credit account. |