ADO.NET Provider for BigCommerce

Build 23.0.8770

OrderRefundsItems

List of Items refunded.

Table Specific Information

Select

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

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 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 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.8770