ODBC Driver for Shopify

Build 25.0.9434

OrderNonFulfillableLineItemDuties

Lists duties on line items that cannot be fulfilled.

View-Specific Information

Select

The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operators. The 本製品 processes other filters client-side within the 本製品.

  • LineItemId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM OrderNonFulfillableLineItemDuties WHERE LineItemId = 'Val1'

Columns

Name Type References Description
LineItemId String

OrderNonFulfillableLineItems.Id

A globally unique Id for the non-fulfillable 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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434