OrderRefundsItems

List of Items refunded.

Table Specific Information

Select

The driver will use the BigCommerce API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.

OrderId supports the '=, IN' comparison.
OrderRefundsId supports the '=, IN' comparison.

For example, the following queries are processed server side:

SELECT * FROM OrderRefundsItems

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	Integer	The ID of the order refund.
OrderId	Integer	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	Boolean	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..

JDBC Driver for BigCommerce

OrderRefundsItems

Table Specific Information

Select

Columns