OrderCoupons
Lists all order coupons.
Table Specific Information
Select
The connector uses the BigCommerce API to process WHERE clause conditions built with the OrderId column, which 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 OrderId = 2;
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Numeric ID of this product within this order. | |
| OrderId | Integer |
Orders.Id | 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. |