Query 124 Sales Order Analysis

Base Application, Microsoft.Sales.Analysis

src/Layers/W1/BaseApp/Sales/Analysis/SalesOrderAnalysis.Query.al199 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.Sales.Analysis;using Microsoft.CRM.Team;using Microsoft.Sales.Document;/// <summary>/// Provides sales order performance analysis by joining sales headers and lines data./// </summary>query 124 "Sales Order Analysis"{    QueryType = Normal;    DataAccessIntent = ReadOnly;    UsageCategory = ReportsAndAnalysis;    Caption = 'Sales Order Performance Analysis';    AboutTitle = 'Sales Order Performance Analysis';    AboutText = 'The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines.';    elements    {        dataitem(Sales_Header; "Sales Header")        {            DataItemTableFilter = "Document Type" = const(Order);            column(DocumentNo; "No.")            {                Caption = 'Document No.';            }            column(Status; Status)            {                Caption = 'Status';            }            column(ExternalDocumentNo; "External Document No.")            {                Caption = 'External Document No.';            }            column(SalespersonCode; "Salesperson Code")            {                Caption = 'Salesperson 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(SellToCustomerNo; "Sell-to Customer No.")            {                Caption = 'Sell-to Customer No.';            }            column(SellToCustomerName; "Sell-to Customer Name")            {                Caption = 'Sell-to Customer Name';            }            column(BillToCustomerNo; "Bill-to Customer No.")            {                Caption = 'Bill-to Customer No.';            }            column(BillToCustomerName; "Bill-to Name")            {                Caption = 'Bill-to Customer Name';            }            dataitem(Sales_Line; "Sales Line")            {                DataItemLink = "Document Type" = Sales_Header."Document Type", "Document No." = Sales_Header."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(PlannedDeliveryDate; "Planned Delivery Date")                {                    Caption = 'Planned Delivery Date';                }                column(PlannedShipmentDate; "Planned Shipment Date")                {                    Caption = 'Planned Shipment Date';                }                column(ShipmentDate; "Shipment Date")                {                    Caption = 'Shipment Date';                }                column(QuantityShipped; "Quantity Shipped")                {                    Caption = 'Quantity Shipped';                }                column(QuantityInvoiced; "Quantity Invoiced")                {                    Caption = 'Quantity Invoiced';                }                column(OutstandingQty; "Outstanding Quantity")                {                    Caption = 'Outstanding Qty.';                }                column(QtyShippedNotInvoiced; "Qty. Shipped Not Invoiced")                {                    Caption = 'Qty. Shipped Not Invoiced';                }                column(OutstandingQtyBase; "Outstanding Qty. (Base)")                {                    Caption = 'Outstanding Qty. (Base)';                }                column(QtyShippedNotInvdBase; "Qty. Shipped Not Invd. (Base)")                {                    Caption = 'Qty. Shipped Not Invd. (Base)';                }                column(OutstandingAmount; "Outstanding Amount")                {                    Caption = 'Outstanding Amount';                }                column(ShippedNotInvoiced; "Shipped Not Invoiced")                {                    Caption = 'Shipped Not Invoiced';                }                column(OutstandingAmountLCY; "Outstanding Amount (LCY)")                {                    Caption = 'Outstanding Amount (LCY)';                }                column(ShippedNotInvoicedLCY; "Shipped Not Invoiced (LCY)")                {                    Caption = 'Shipped 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(Salesperson_Purchaser; "Salesperson/Purchaser")                {                    DataItemLink = Code = Sales_Header."Salesperson Code";                    SqlJoinType = InnerJoin;                    column(Name; Name)                    {                        Caption = 'Salesperson Name';                    }                }            }        }    }}