Query 488 Purch. Order Perf. Analysis
src/Layers/W1/BaseApp/Purchases/Analysis/PurchOrderPerfAnalysis.Query.al196 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.Purchases.Analysis;using Microsoft.CRM.Team;using Microsoft.Purchases.Document;query 488 "Purch. Order Perf. Analysis"{ QueryType = Normal; DataAccessIntent = ReadOnly; UsageCategory = ReportsAndAnalysis; Caption = 'Purchase Order Performance Analysis'; AboutTitle = 'About Purchase Order Performance Analysis'; AboutText = 'The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data.'; elements { dataitem(PurchaseHeader; "Purchase Header") { DataItemTableFilter = "Document Type" = const(Order); column(DocumentNo; "No.") { Caption = 'No.'; } column(Status; Status) { Caption = 'Status'; } column(VendorOrderNo; "Vendor Order No.") { Caption = 'Vendor Order No.'; } column(PurchaserCode; "Purchaser Code") { Caption = 'Purchaser Code'; } column(OrderDate; "Order Date") { Caption = 'Order Date'; } column(DueDate; "Due Date") { Caption = 'Due Date'; } column(DocumentDate; "Document Date") { Caption = 'Document Date'; } column(PostingDate; "Posting Date") { Caption = 'Posting Date'; } column(BuyFromVendorNo; "Buy-from Vendor No.") { Caption = 'Buy-from Vendor No.'; } column(BuyFromVendorName; "Buy-from Vendor Name") { Caption = 'Buy-from Vendor Name'; } column(PayToVendorNo; "Pay-to Vendor No.") { Caption = 'Pay-to Vendor No.'; } column(PayToVendorName; "Pay-to Name") { Caption = 'Pay-to Vendor Name'; } dataitem(PurchaseLine; "Purchase Line") { DataItemLink = "Document Type" = PurchaseHeader."Document Type", "Document No." = PurchaseHeader."No."; SqlJoinType = InnerJoin; column(Type; Type) { Caption = 'Type'; } column(No; "No.") { Caption = 'No.'; } column(Description; Description) { Caption = 'Description'; } column(Quantity; Quantity) { Caption = 'Quantity'; } column(UnitOfMeasureCode; "Unit of Measure Code") { Caption = 'Unit of Measure Code'; } column(LocationCode; "Location Code") { Caption = 'Location Code'; } column(VariantCode; "Variant Code") { Caption = 'Variant Code'; } column(LineDiscountAmount; "Line Discount Amount") { Caption = 'Line Discount Amount'; } column(InvDiscountAmount; "Inv. Discount Amount") { Caption = 'Inv. Discount Amount'; } column(Amount; Amount) { Caption = 'Amount'; } column(AmountIncludingVAT; "Amount Including VAT") { Caption = 'Amount Including VAT'; } column(CurrencyCode; "Currency Code") { Caption = 'Currency Code'; } column(RequestedReceiptDate; "Requested Receipt Date") { Caption = 'Requested Receipt Date'; } column(PromisedReceiptDate; "Promised Receipt Date") { Caption = 'Promised Receipt Date'; } column(ExpectedReceiptDate; "Expected Receipt Date") { Caption = 'Expected Receipt Date'; } column(QuantityReceived; "Quantity Received") { Caption = 'Quantity Received'; } column(QuantityInvoiced; "Quantity Invoiced") { Caption = 'Quantity Invoiced'; } column(OutstandingQuantity; "Outstanding Quantity") { Caption = 'Outstanding Quantity'; } column(QtyRcdNotInvoiced; "Qty. Rcd. Not Invoiced") { Caption = 'Qty. Rcd. Not Invoiced'; } column(OutstandingQtyBase; "Outstanding Qty. (Base)") { Caption = 'Outstanding Qty. (Base)'; } column(QtyRcdNotInvoicedBase; "Qty. Rcd. Not Invoiced (Base)") { Caption = 'Qty. Rcd. Not Invoiced (Base)'; } column(OutstandingAmount; "Outstanding Amount") { Caption = 'Outstanding Amount'; } column(AmtRcdNotInvoiced; "Amt. Rcd. Not Invoiced") { Caption = 'Amt. Rcd. Not Invoiced'; } column(OutstandingAmountLCY; "Outstanding Amount (LCY)") { Caption = 'Outstanding Amount (LCY)'; } column(AmtRcdNotInvoicedLCY; "Amt. Rcd. Not Invoiced (LCY)") { Caption = 'Amt. Rcd. Not Invoiced (LCY)'; } column(ShortcutDimension1Code; "Shortcut Dimension 1 Code") { Caption = 'Shortcut Dimension 1 Code'; } column(ShortcutDimension2Code; "Shortcut Dimension 2 Code") { Caption = 'Shortcut Dimension 2 Code'; } dataitem(SalespersonPurchaser; "Salesperson/Purchaser") { DataItemLink = Code = PurchaseHeader."Purchaser Code"; SqlJoinType = InnerJoin; column(PurchaserName; Name) { Caption = 'Purchaser Name'; } } } } }}