ADO.NET Provider for BigCommerce

Build 23.0.8839


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


Name Type References Description
ItemId [KEY] Integer corresponding to the item_types of PRODUCT, GIFT_WRAPPING. corresponding to the item_types of SHIPPING, HANDLING. 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839