ODBC Driver for Shopify

Build 24.0.9060

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 columns and operators. The driver processes other filters client-side within the driver.

  • 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

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060