ODBC Driver for Shopify

Build 24.0.9062

FulfillmentOrderLocationsForMove

A list of locations that the fulfillment order can potentially move to.

View-Specific Information

Select

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

  • FulfillmentOrderId supports the '=,IN' comparison operators.
  • LocationId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM FulfillmentOrderLocationsForMove
  SELECT * FROM FulfillmentOrderLocationsForMove WHERE FulfillmentOrderId = 'Val1'
  SELECT * FROM FulfillmentOrderLocationsForMove WHERE LocationId = 'Val1'

Columns

Name Type References Description
FulfillmentOrderId [KEY] String The unique identifier of the fulfillment order.
LocationId [KEY] String The unique identifier of the location.
AvailableLineItemsCount Long Total number of fulfillment order line items that can be moved from their current assigned location to the given location.
UnavailableLineItemsCount Long Total number of fulfillment order line items that can't be moved from their current assigned location to the given location.
Movable Bool Whether the fulfillment order can be moved to the location.
Message String A human-readable string with the reason why the fulfillment order, or some of its line items, can't be moved to the location.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062