OrderLineItemDuties
Lists duties allocated to order line items.
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.
- LineItemId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderLineItemDuties WHERE LineItemId = 'Val1'
Columns
| Name | Type | References | Description |
| LineItemId | String | A globally unique Id for the order line item associated with the duty. | |
| Id [KEY] | String | A globally unique Id for the duty record. | |
| CountryCodeOfOrigin | String | The ISO 3166-1 alpha-2 country code of the item's country of origin, used in calculating the duty. | |
| HarmonizedSystemCode | String | The harmonized system (HS) code of the item, used in calculating the duty. | |
| PricePresentmentMoneyAmount | Decimal | The duty amount, in presentment currency, as a decimal value. | |
| PricePresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the duty amount. | |
| PriceShopMoneyAmount | Decimal | The duty amount, in shop currency, as a decimal value. | |
| PriceShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the duty amount. |