OrderRefundsItems
List of Items refunded.
Table Specific Information
Select
The component uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- OrderId supports the = and IN comparisons.
- OrderRefundsId supports the = and IN comparisons.
The rest of the filter is executed client-side within the component.
For example, the following queries are processed server-side:
SELECT * FROM OrderRefundsItems WHERE OrderRefundId = 2
SELECT * FROM OrderRefundsItems WHERE OrderId = 2
Columns
| Name | Type | Description |
| ItemId [KEY] | Integer | 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. |
| OrderRefundId [KEY] | Integer | The ID of the order refund. |
| OrderId | Integer | Reference to order id. |
| ItemType | String | Type of item that was refunded. Possible values are: PRODUCT, GIFT_WRAPPING, SHIPPING, HANDLING, ORDER, FEE |
| Quantity | Integer | Quantity of item refunded. Note: this will only be populated for item_type PRODUCT |
| Reason | String | Reason for refunding an item. |
| RequestedAmount | Decimal | A non-negative 2 decimal place rounded value that represents the amount that can be charged/refunded via payment providers.. |