List of Items refunded.
Table Specific Information
The 本製品 uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- OrderId supports the '=, IN' comparison.
- OrderRefundsId supports the '=, IN' comparison.
The rest of the filter is executed client-side within the 本製品.
For example, the following queries are processed server-side:
SELECT * FROM OrderRefundsItems WHERE OrderRefundId = 2
SELECT * FROM OrderRefundsItems WHERE OrderId = 2
|order_product.id corresponding to the item_types of PRODUCT, GIFT_WRAPPING. order_address.id corresponding to the item_types of SHIPPING, HANDLING. order.id corresponding to the item_type of ORDER.
|The ID of the order refund.
|Reference to order id.
|Type of item that was refunded.
|Quantity of item refunded. Note: this will only be populated for item_type PRODUCT
|Reason for refunding an item.
|A non-negative 2 decimal place rounded value that represents the amount that can be charged/refunded via payment providers.