Query 5900 Service Analysis

Base Application, Microsoft.Service.Analysis

src/Layers/W1/BaseApp/Service/Analysis/ServiceAnalysis.Query.al325 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.Service.Analysis;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Projects.Project.Job;using Microsoft.Sales.Customer;using Microsoft.Service.Contract;using Microsoft.Service.Item;using Microsoft.Service.Ledger;using Microsoft.Utilities;query 5900 "Service Analysis"{    QueryType = Normal;    DataAccessIntent = ReadOnly;    UsageCategory = ReportsAndAnalysis;    Caption = 'Service Ad-hoc Analysis';    AboutTitle = 'About Service Ad-hoc Analysis';    AboutText = 'The Service Analysis is a query that joins data from service ledger entries with service master data.';    elements    {        dataitem(ServiceLedgerEntry; "Service Ledger Entry")        {            column(ServiceContractNo; "Service Contract No.")            {                Caption = 'Service Contract No.';            }            column(DocumentType; "Document Type")            {                Caption = 'Document Type';            }            column(DocumentNo; "Document No.")            {                Caption = 'Document No.';            }            column(DocumentLineNo; "Document Line No.")            {                Caption = 'Document Line No.';            }            column(Type; "Type")            {                Caption = 'Type';            }            column(No; "No.")            {                Caption = 'No.';            }            column(Description; "Description")            {                Caption = 'Description';            }            column(MovedFromPrepaidAcc; "Moved from Prepaid Acc.")            {                Caption = 'Moved from Prepaid Acc.';            }            column(PostingDate; "Posting Date")            {                Caption = 'Posting Date';            }            column(AmountLCY; "Amount (LCY)")            {                Caption = 'Amount (LCY)';            }            column(ShipToCode; "Ship-to Code")            {                Caption = 'Ship-to Code';            }            column(ContractInvoicePeriod; "Contract Invoice Period")            {                Caption = 'Contract Invoice Period';            }            column(VariantCodeServiced; "Variant Code (Serviced)")            {                Caption = 'Variant Code (Serviced)';            }            column(ContractGroupCode; "Contract Group Code")            {                Caption = 'Contract Group Code';            }            column(CostAmount; "Cost Amount")            {                Caption = 'Cost Amount';            }            column(DiscountAmount; "Discount Amount")            {                Caption = 'Discount Amount';            }            column(UnitCost; "Unit Cost")            {                Caption = 'Unit Cost';            }            column(Quantity; "Quantity")            {                Caption = 'Quantity';            }            column(ChargedQty; "Charged Qty.")            {                Caption = 'Charged Qty.';            }            column(UnitPrice; "Unit Price")            {                Caption = 'Unit Price';            }            column(DiscountPercentage; "Discount %")            {                Caption = 'Discount %';            }            column(ContractDiscountAmount; "Contract Disc. Amount")            {                Caption = 'Contract Disc. Amount';            }            column(FaultReasonCode; "Fault Reason Code")            {                Caption = 'Fault Reason Code';            }            column(ServiceOrderType; "Service Order Type")            {                Caption = 'Service Order Type';            }            column(ServiceOrderNo; "Service Order No.")            {                Caption = 'Service Order No.';            }            column(UnitOfMeasureCode; "Unit of Measure Code")            {                Caption = 'Unit of Measure Code';            }            column(BinCode; "Bin Code")            {                Caption = 'Bin Code';            }            column(ResponsibilityCenter; "Responsibility Center")            {                Caption = 'Responsibility Center';            }            column(VariantCode; "Variant Code")            {                Caption = 'Variant Code';            }            column(EntryType; "Entry Type")            {                Caption = 'Entry Type';            }            column(Open; "Open")            {                Caption = 'Open';            }            column(ServicePriceAdjmtGrCode; "Serv. Price Adjmt. Gr. Code")            {                Caption = 'Serv. Price Adjmt. Gr. Code';            }            column(ServicePriceGroupCode; "Service Price Group Code")            {                Caption = 'Service Price Group Code';            }            column(Prepaid; "Prepaid")            {                Caption = 'Prepaid';            }            column(ApplyUntilEntryNo; "Apply Until Entry No.")            {                Caption = 'Apply Until Entry No.';            }            column(AppliesToEntryNo; "Applies-to Entry No.")            {                Caption = 'Applies-to Entry No.';            }            column(Amount; "Amount")            {                Caption = 'Amount';            }            column(GlobalDimension1Code; "Global Dimension 1 Code")            {                Caption = 'Global Dimension 1 Code';            }            column(GlobalDimension2Code; "Global Dimension 2 Code")            {                Caption = 'Global Dimension 2 Code';            }            column(ShortcutDimension3Code; "Shortcut Dimension 3 Code")            {                Caption = 'Shortcut Dimension 3 Code';            }            column(ShortcutDimension4Code; "Shortcut Dimension 4 Code")            {                Caption = 'Shortcut Dimension 4 Code';            }            column(ShortcutDimension5Code; "Shortcut Dimension 5 Code")            {                Caption = 'Shortcut Dimension 5 Code';            }            column(ShortcutDimension6Code; "Shortcut Dimension 6 Code")            {                Caption = 'Shortcut Dimension 6 Code';            }            column(ShortcutDimension7Code; "Shortcut Dimension 7 Code")            {                Caption = 'Shortcut Dimension 7 Code';            }            column(ShortcutDimension8Code; "Shortcut Dimension 8 Code")            {                Caption = 'Shortcut Dimension 8 Code';            }            dataitem(Service_Contract_Header; "Service Contract Header")            {                DataItemLink = "Contract No." = ServiceLedgerEntry."Service Contract No.";                DataItemTableFilter = "Contract Type" = const(Contract);                column(ServiceContractDesc; Description)                {                    Caption = 'Service Contract Description';                }                dataitem(ServiceContractAccountGroup; "Service Contract Account Group")                {                    DataItemLink = Code = ServiceLedgerEntry."Serv. Contract Acc. Gr. Code";                    column(ServiceContractAccGroupCode; "Code")                    {                        Caption = 'Service Contract Acc. Group Code.';                    }                    column(ServiceContractAccGroupDesc; Description)                    {                        Caption = 'Service Contract Acc. Group Desc.';                    }                    dataitem(Customer; Customer)                    {                        DataItemLink = "No." = ServiceLedgerEntry."Customer No.";                        column(CustomerNo; "No.")                        {                            Caption = 'Customer No.';                        }                        column(CustomerName; Name)                        {                            Caption = 'Customer Name';                        }                        dataitem(BillToCustomer; Customer)                        {                            DataItemLink = "No." = ServiceLedgerEntry."Bill-to Customer No.";                            column(BillToCustomerNo; "No.")                            {                                Caption = 'Bill-to Customer No.';                            }                            column(BillToCustomerName; Name)                            {                                Caption = 'Bill-to Customer Name';                            }                            dataitem(ItemServiced; Item)                            {                                DataItemLink = "No." = ServiceLedgerEntry."Item No. (Serviced)";                                column(ItemServicedNo; "No.")                                {                                    Caption = 'Item No. (Serviced)';                                }                                column(ItemServicedDescription; Description)                                {                                    Caption = 'Item Description (Serviced)';                                }                                dataitem(ServiceItemServiced; "Service Item")                                {                                    DataItemLink = "No." = ServiceLedgerEntry."Service Item No. (Serviced)";                                    column(ServiceItemServicedNo; "No.")                                    {                                        Caption = 'Service Item No. (Serviced)';                                    }                                    column(ServiceItemServicedDescription; Description)                                    {                                        Caption = 'Service Item Description (Serviced)';                                    }                                    dataitem(Job; Job)                                    {                                        DataItemLink = "No." = ServiceLedgerEntry."Job No.";                                        column(JobDescription; Description)                                        {                                            Caption = 'Project Description';                                        }                                        dataitem(JobTask; "Job Task")                                        {                                            DataItemLink = "Job No." = ServiceLedgerEntry."Job No.", "Job Task No." = ServiceLedgerEntry."Job Task No.";                                            column(JobTaskNo; "Job Task No.")                                            {                                                Caption = 'Project Task No.';                                            }                                            column(JobTaskDescription; Description)                                            {                                                Caption = 'Project Task Description';                                            }                                            dataitem(WorkType; "Work Type")                                            {                                                DataItemLink = Code = ServiceLedgerEntry."Work Type Code";                                                column(WorkTypeCode; Code)                                                {                                                    Caption = 'Work Type Code';                                                }                                                column(WorkTypeDescription; Description)                                                {                                                    Caption = 'Work Type Description';                                                }                                                dataitem(Location; Location)                                                {                                                    DataItemLink = "Code" = ServiceLedgerEntry."Location Code";                                                    column(LocationCode; Code)                                                    {                                                        Caption = 'Location Code';                                                    }                                                    column(LocationName; Name)                                                    {                                                        Caption = 'Location Name';                                                    }                                                }                                            }                                        }                                    }                                }                            }                        }                    }                }            }        }    }}