Query 30100 Shpfy Shipment Location
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; } } } } }}