ODBC Driver for WooCommerce

Build 20.0.7587

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 driver 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] Integer 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 Integer Id of the order.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587