Query 60 Power BI Sales Hdr. Cust.

Base Application, Microsoft.Integration.PowerBI

src/Layers/W1/BaseApp/Integration/PowerBI/ReportingData/PowerBISalesHdrCust.Query.al75 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.Inventory.Item;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;query 60 "Power BI Sales Hdr. Cust."{    Caption = 'Power BI Sales Hdr. Cust.';    elements    {        dataitem(Sales_Header; "Sales Header")        {            column(No; "No.")            {            }            dataitem(Sales_Line; "Sales Line")            {                DataItemLink = "Document Type" = Sales_Header."Document Type", "Document No." = Sales_Header."No.";                DataItemTableFilter = Type = const(Item);                column(Item_No; "No.")                {                }                column(Quantity; Quantity)                {                }                column(Qty_Invoiced_Base; "Qty. Invoiced (Base)")                {                }                column(Qty_Shipped_Base; "Qty. Shipped (Base)")                {                }                dataitem(Item; Item)                {                    DataItemLink = "No." = Sales_Line."No.";                    column(Base_Unit_of_Measure; "Base Unit of Measure")                    {                    }                    column(Description; Description)                    {                    }                    column(Inventory; Inventory)                    {                    }                    column(Unit_Price; "Unit Price")                    {                    }                    dataitem(Customer; Customer)                    {                        DataItemLink = "No." = Sales_Line."Sell-to Customer No.";                        column(Customer_No; "No.")                        {                        }                        column(Name; Name)                        {                        }                        column(Balance; Balance)                        {                        }                        column(Country_Region_Code; "Country/Region Code")                        {                        }                    }                }            }        }    }}