TDV Adapter for Shopify

Build 24.0.9060

FulfillmentOrderLocationsForMove

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

View-Specific Information

Select

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

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