OrderTaxLines
Retrieve the tax 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. If the 'OrderId' filter is not specified,
the adapter will fetch a list of all the orders and perform a request for each order in the list.
SELECT * FROM OrderTaxLines WHERE OrderId = 12
Columns
| Name | Type | Description |
| Id [KEY] | Long | Item ID. |
| RateCode | String | Tax rate code. |
| RateId | String | Tax rate ID. |
| Label | String | Tax rate label. |
| Compound | Boolean | Show if is a compound tax rate. |
| TaxTotal | String | Tax total (not including shipping taxes). |
| ShippingTaxTotal | String | Shipping tax total. |
| MetaData | String | Meta data. See Order - Meta data properties |
| OrderId | Long | Id of the order. |