OrderCoupons
Lists all order coupons.
Table Specific Information
Select
The adapter 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 adapter.
- Id supports the '=' comparison.
- OrderId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM OrderCoupons SELECT * FROM OrderCoupons WHERE Id = 1 SELECT * FROM OrderCoupons WHERE OrderId = 2
Columns
| Name | Type | 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. |