OrderRefunds
Returns a list of refunds.
Table Specific Information
Select
The connector uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- Id supports the = and IN comparisons.
- OrderId supports the = and IN comparisons.
- Created supports the =, >, <, >=, and <= comparisons.
The rest of the filter is executed client-side within the connector. For example, the following queries are processed server-side:
SELECT * FROM OrderRefunds WHERE Id = 1
SELECT * FROM OrderRefunds WHERE OrderId = 2
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Refund resource ID. | |
| Created [KEY] | Datetime | Timestamp of when this refund was created. | |
| OrderId | Integer | Reference to order id. | |
| Reason | String | Reason for refund. | |
| TotalAmount | Decimal | A non-negative 2 decimal place rounded value that represents the amount that can be charged/refunded via payment providers. | |
| TotalTax | Decimal | Total tax amount refunded back to the shopper. Note: order_level_amount does not affect tax liability. | |
| UserId | Integer | Reference to the user's id who create this refund. | |
| UsesMerchantOverrideValues | Boolean | Whether refund amount and tax are provided explicitly by merchant override |