OrderLineItemDuties
Displays duty charges applied to order line items for customs or import purposes.
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 identifier for the order line item associated with the duty charge. | |
| Id [KEY] | String | A globally unique identifier for the duty record applied to the line item. | |
| CountryCodeOfOrigin | String | The ISO 3166-1 alpha-2 country code identifying the country where the item originated, used to calculate import duties. | |
| HarmonizedSystemCode | String | The harmonized system (HS) code representing the product category for customs and duty calculation purposes. | |
| PricePresentmentMoneyAmount | Decimal | The duty amount charged for the line item, expressed in the customer's presentment currency. | |
| PricePresentmentMoneyCurrencyCode | String | The ISO currency code representing the presentment currency used for the duty amount. | |
| PriceShopMoneyAmount | Decimal | The duty amount charged for the line item, expressed in the shop's base currency. | |
| PriceShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency used for the duty amount. |