TaxItems
Query order taxes.
View-Specific Information
The connector uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns. The supported SQL operators are '=' for OrderId and '>' and '<' for OrderUpdatedAt. The connector processes other filters client-side within the connector. For example, the following queries are processed server-side.Select
SELECT * FROM TaxItems WHERE OrderId = '123'
SELECT * FROM TaxItems WHERE OrderUpdatedAt > '2018-05-21'
Columns
Name | Type | References | Description |
LineNumber [KEY] | Long | A unique numeric identifier for the table. | |
OrderId | Long |
Orders.Id | The id of the order. |
OrderUpdatedAt | Datetime | The date and time when the order was last modified. | |
ChannelLiable | Bool | Whether the channel that submitted the tax line is liable for remitting. | |
TaxItemPrice | Decimal | The amount of tax to be charged. | |
TaxItemRate | Decimal | The rate of tax to be applied. | |
TaxItemTitle | String | The name of the tax. |