Query 6100 E-Doc. Line by Receipt

E-Document Core, Microsoft.eServices.EDocument.Processing.Import.Purchase

src/Apps/W1/EDocument/App/src/Processing/Import/Purchase/PurchaseOrderMatching/EDocLineByReceipt.Query.al49 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.eServices.EDocument.Processing.Import.Purchase;using Microsoft.Purchases.History;/// <summary>/// Query to get the e-document lines sorted by the receipt number that they have assigned/// </summary>query 6100 "E-Doc. Line by Receipt"{    Access = Internal;    OrderBy = ascending(ReceiptNo);    InherentEntitlements = X;    InherentPermissions = X;    elements    {        dataitem(EDocumentPurchaseLine; "E-Document Purchase Line")        {            column(SystemId; SystemId)            {            }            column(EDocumentEntryNo; "E-Document Entry No.")            {            }            dataitem(EDocPurchaseLinePOMatch; "E-Doc. Purchase Line PO Match")            {                DataItemLink = "E-Doc. Purchase Line SystemId" = EDocumentPurchaseLine.SystemId;                SqlJoinType = LeftOuterJoin;                column(PurchaseLineSystemId; "Purchase Line SystemId")                {                }                column(ReceiptLineSystemId; "Receipt Line SystemId")                {                }                dataitem(PurchRcptLine; "Purch. Rcpt. Line")                {                    DataItemLink = SystemId = EDocPurchaseLinePOMatch."Receipt Line SystemId";                    column(ReceiptNo; "Document No.")                    {                    }                }            }        }    }}