Query 30100 Shpfy Shipment Location

Shopify Connector, Microsoft.Integration.Shopify

src/Apps/W1/Shopify/App/src/Shipping/Queries/ShpfyShipmentLocation.Query.al46 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Integration.Shopify;using Microsoft.Sales.History;query 30100 "Shpfy Shipment Location"{    Access = Internal;    Caption = 'Shopify Shipment Location';    QueryType = Normal;    elements    {        dataitem(SalesShipmentHeader; "Sales Shipment Header")        {            column(No; "No.") { }            dataitem(SalesShipmentLine; "Sales Shipment Line")            {                DataItemLink = "Document No." = SalesShipmentHeader."No.";                DataItemTableFilter = Type = const(Item), Quantity = filter('>0');                SqlJoinType = InnerJoin;                dataitem(OrderLine; "Shpfy Order Line")                {                    DataItemLink = "Line Id" = SalesShipmentLine."Shpfy Order Line Id";                    SqlJoinType = InnerJoin;                    column(LocationId; "Location Id") { }                    column(DeliveryMethodType; "Delivery Method Type") { }                    column(NoOfLines)                    {                        Method = Count;                    }                }            }        }    }}