JDBC Driver for Shopify

Build 24.0.9187

OrderNonFulfillableLineItemDuties

Lists the duties associated with the line items.

View-Specific Information

Select

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

  • 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.
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.

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