Query 50 Power BI Customer List

// ------------------------------------------------------------------------------------------------
// 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.")
                {
                }
            }
        }
    }
}