OrderTaxes

Gets all order taxes related to an order.

Table Specific Information

The add-in uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

The rest of the filter is executed client-side within the add-in.

For example, the following queries are processed server-side:

SELECT * FROM OrderTaxes WHERE OrderId = 2


Name	Type	Description
Id [KEY]	Integer	Numeric Id of this product within this order.
OrderId	Integer	Numeric Id of the associated order.
OrderAddressId	Integer	The unique numeric identifier of the order address object associated with the order.
TaxRateId	Integer	The unique numeric identifier of the tax rate.
TaxClassId	Integer	The unique numeric identifier of the tax class object.
Name	String	The name of the tax class object.
Class	String	The name of the type of tax that was applied.
Rate	Decimal	The tax rate.
Priority	Decimal	The order in which the tax is applied.
PriorityAmount	Decimal	The amount of tax calculated on the order.
LineAmount	Decimal	The line amount.
OrderProductId	String	If the line_item_type is 'item' or 'handling' then this field is the order product Id. Otherwise, the field returns as null.
LineItemType	String	Type of tax on item. Possible values are: item, shipping, handling, or gift-wrapping.