OrderTaxes
Gets all order taxes related to an order.
Table Specific Information
Select
The component uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=' comparison.
- OrderId supports the '=' comparison.
The rest of the filter is executed client-side within the component.
For example, the following queries are processed server-side:
SELECT * FROM OrderTaxes WHERE Id = 1 SELECT * FROM OrderTaxes WHERE OrderId = 2
Columns
Name | Type | References | 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. |