OrderCouponLines
Retrieve the coupon lines for an order.
Table Specific Information
Select
WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query.
These columns support only the = comparison, unless stated otherwise. The available column for this
table is: OrderId. All other columns are processed client side.
SELECT * FROM OrderCouponLines WHERE OrderId = 144
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Item ID. | |
| Code | String | Coupon code. | |
| Discount | String | Discount total. | |
| DiscountTax | String | Discount total tax. | |
| MetaData | String | Meta data. See Order - Meta data properties | |
| OrderId | String |
Orders.Id | Id of the order. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| ReferenceNumber | String | This column will be used in Bulk operations to get specific values from the Temp tables. |