Query 5480 Customer Sales Entity
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; } } } }}