OrderNonFulfillableLineItemDuties
Lists the duties associated with the line items.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- LineItemId supports the '=' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM OrderNonFulfillableLineItemDuties
SELECT * FROM OrderNonFulfillableLineItemDuties WHERE LineItemId = 'Val 1'
Columns
| Name | Type | References | Description |
| LineItemId | String | A globally-unique ID. | |
| Id [KEY] | String | A globally-unique ID. | |
| CountryCodeOfOrigin | String | The ISO 3166-1 alpha-2 country code of the country of origin used in calculating the duty. | |
| HarmonizedSystemCode | String | The harmonized system code of the item used in calculating the duty. | |
| PricePresentmentMoneyAmount | Decimal | Decimal money amount. | |
| PricePresentmentMoneyCurrencyCode | String | Currency of the money. | |
| PriceShopMoneyAmount | Decimal | Decimal money amount. | |
| PriceShopMoneyCurrencyCode | String | Currency of the money. |