Query 50 Power BI Customer List

Base Application, Microsoft.Integration.PowerBI

src/Layers/W1/BaseApp/Integration/PowerBI/ReportingData/PowerBICustomerList.Query.al56 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.Integration.PowerBI;using Microsoft.Sales.Customer;using Microsoft.Sales.Receivables;query 50 "Power BI Customer List"{    Caption = 'Power BI Customer List';    elements    {        dataitem(Customer; Customer)        {            column(Customer_Name; Name)            {            }            column(Customer_No; "No.")            {            }            column(Credit_Limit; "Credit Limit (LCY)")            {            }            column(Balance_Due; "Balance Due")            {            }            dataitem(Detailed_Cust_Ledg_Entry; "Detailed Cust. Ledg. Entry")            {                DataItemLink = "Customer No." = Customer."No.";                column(Posting_Date; "Posting Date")                {                }                column(Cust_Ledger_Entry_No; "Cust. Ledger Entry No.")                {                }                column(Amount; Amount)                {                }                column(Amount_LCY; "Amount (LCY)")                {                }                column(Transaction_No; "Transaction No.")                {                }                column(Entry_No; "Entry No.")                {                }            }        }    }}