Refunds
Represents a refund of items or transactions in an order.
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operator. The 本製品 processes other filters client-side within the 本製品.
- OrderId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM Refunds
SELECT * FROM Refunds WHERE OrderId = 'Val1'
Insert
Insert statements are mapped to the 'refundCreate' GraphQL mutation.
The following columns can be used to create a new record:
OrderId, Note
The following pseudo-columns can be used to create a new record:
RefundLineItems
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Globally unique identifier. | |
| LegacyResourceId | String | True |
The ID of the corresponding resource in the REST Admin API. | |
| OrderId | String | True |
Orders.Id |
A globally-unique ID. |
| Note | String | True |
The optional note associated with the refund. | |
| CreatedAt | Datetime | True |
The date and time when the refund was created. | |
| UpdatedAt | Datetime | True |
The date and time when the refund was updated. | |
| ReturnId | String | True |
A globally-unique ID. | |
| StaffMemberId | String | True |
A globally-unique ID.(This column is available only with a ShopifyPlus subscription) | |
| TotalRefundedSetPresentmentMoneyAmount | Decimal | True |
Decimal money amount. | |
| TotalRefundedSetPresentmentMoneyCurrencyCode | String | True |
Currency of the money. | |
| TotalRefundedSetShopMoneyAmount | Decimal | True |
Decimal money amount. | |
| TotalRefundedSetShopMoneyCurrencyCode | String | True |
Currency of the money. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御したり、INSERT ステートメントのパラメータとして使用したりすることができます。
| Name | Type | Description |
| RefundLineItems | String |
The list of the line items in the draft order. |