OrderCoupons
Lists all order coupons.
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 '=' comparison.
- OrderId supports the '=' comparison.
The rest of the filter is executed client-side within the connector.
For example, the following queries are processed server-side:
SELECT * FROM OrderCoupons WHERE Id = 1 SELECT * FROM OrderCoupons WHERE OrderId = 2
Columns
Name | Type | References | Description |
Id [KEY] | Integer | Numeric ID of this product within this order. | |
OrderId | Integer | Numeric ID of the associated order. | |
CouponId | Integer | The coupon id. | |
Code | String | The code of the coupon. | |
Amount | Decimal | The amount of the coupon. | |
Type | Integer | The type of the coupon. | |
Discount | Decimal | The discount of the coupon. |