OrderTaxes
Gets all order taxes related to an order.
Table Specific Information
Select
The driver will use the BigCommerce API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
- Id supports the '=' comparison.
- OrderId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM OrderTaxes SELECT * FROM OrderTaxes WHERE Id = 1 SELECT * FROM OrderTaxes WHERE OrderId = 2
Columns
| 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 | Integer | 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 will be the order product id. Otherwise the field will return as null. |
| LineItemType | String | Type of tax on item. |