Query 100 Top Customer Overview
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) { } } } } }}