Query 100 Top Customer Overview

Base Application, Microsoft.Sales.Customer

src/Layers/W1/BaseApp/Sales/Customer/TopCustomerOverview.Query.al66 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.Customer;using Microsoft.CRM.Team;using Microsoft.Foundation.Address;/// <summary>/// Provides an overview of customers with sales, profit, and geographic information for analysis./// </summary>query 100 "Top Customer Overview"{    Caption = 'Top Customer Overview';    elements    {        dataitem(Customer; Customer)        {            column(Name; Name)            {            }            column(No; "No.")            {            }            column(Sales_LCY; "Sales (LCY)")            {            }            column(Profit_LCY; "Profit (LCY)")            {            }            column(Country_Region_Code; "Country/Region Code")            {            }            column(City; City)            {            }            column(Global_Dimension_1_Code; "Global Dimension 1 Code")            {            }            column(Global_Dimension_2_Code; "Global Dimension 2 Code")            {            }            column(Salesperson_Code; "Salesperson Code")            {            }            dataitem(Salesperson_Purchaser; "Salesperson/Purchaser")            {                DataItemLink = Code = Customer."Salesperson Code";                column(SalesPersonName; Name)                {                }                dataitem(Country_Region; "Country/Region")                {                    DataItemLink = Code = Customer."Country/Region Code";                    column(CountryRegionName; Name)                    {                    }                }            }        }    }}