OrderRefundsItems
List of Items refunded.
Table Specific Information
Select
The add-in 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 add-in.
For example, the following queries are processed server-side:
SELECT * FROM OrderRefundsItems WHERE OrderRefundId = 2
SELECT * FROM OrderRefundsItems WHERE OrderId = 2
Columns
| Name | Type | References | 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 |
OrderRefunds.Id | The ID of the order refund. |
| OrderId | Integer |
OrderRefunds.OrderId | Reference to order id. |
| ItemType | String | Type of item that was refunded. | |
| 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.. |