OrderTaxLines
Shows taxes calculated for an order at the order level.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- ResourceId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderTaxLines WHERE ResourceId = 'Val1'
Columns
| Name | Type | References | Description |
| Title [KEY] | String | The name of the tax. | |
| ResourceId [KEY] | String |
Orders.Id | A globally unique Id. |
| Source | String | The source of the tax. | |
| Rate | Double | The proportion of the line item price that this tax represents, expressed as a decimal. | |
| ChannelLiable | Bool | Whether the channel that submitted the tax line is liable for remittance. A value of null indicates unknown liability. | |
| RatePercentage | Double | The proportion of the line item price that this tax represents, expressed as a percentage. | |
| PriceSetPresentmentMoneyAmount | Decimal | The tax amount in the presentment currency, expressed as a decimal. | |
| PriceSetPresentmentMoneyCurrencyCode | String | The currency code of the tax amount in the presentment currency. | |
| PriceSetShopMoneyAmount | Decimal | The tax amount in the shop's currency, expressed as a decimal. | |
| PriceSetShopMoneyCurrencyCode | String | The currency code of the tax amount in the shop's currency. |