Query 5480 Customer Sales Entity

Base Application, Microsoft.Sales.Customer

src/Layers/W1/BaseApp/Sales/Customer/CustomerSalesEntity.Query.al54 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.Sales.Receivables;/// <summary>/// Provides an API query endpoint for retrieving customer sales amounts with date filtering./// </summary>query 5480 "Customer Sales Entity"{    Caption = 'customerSales', Locked = true;    EntityName = 'customerSale';    EntitySetName = 'customerSales';    QueryType = API;    elements    {        dataitem(Customer; Customer)        {            column(customerId; SystemId)            {                Caption = 'Id', Locked = true;            }            column(customerNumber; "No.")            {                Caption = 'No', Locked = true;            }            column(name; Name)            {                Caption = 'Name', Locked = true;            }            dataitem(Cust_Ledger_Entry; "Cust. Ledger Entry")            {                DataItemLink = "Customer No." = Customer."No.";                SqlJoinType = LeftOuterJoin;                DataItemTableFilter = "Document Type" = filter(Invoice | "Credit Memo");                column(totalSalesAmount; "Sales (LCY)")                {                    Caption = 'TotalSalesAmount', Locked = true;                    Method = Sum;                }                filter(dateFilter; "Posting Date")                {                    Caption = 'DateFilter', Locked = true;                }            }        }    }}