Query 486 ProjectsAnalysis
src/Layers/W1/BaseApp/Projects/Project/Analysis/ProjectsAnalysis.Query.al303 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.Projects.Project.Analysis;using Microsoft.Inventory.Location;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Ledger;using Microsoft.Utilities;query 486 ProjectsAnalysis{ QueryType = Normal; DataAccessIntent = ReadOnly; UsageCategory = ReportsAndAnalysis; Caption = 'Project Ad-hoc Analysis'; AboutTitle = 'About Project Ad-hoc Analysis'; AboutText = 'The Project Analysis a query that joins data from project ledger entries with project master data.'; elements { dataitem(JobLedgerEntry; "Job Ledger Entry") { column(JobNo; "Job No.") { Caption = 'Project No.'; } column(PostingDate; "Posting Date") { Caption = 'Posting Date'; } column(DocumentNo; "Document No.") { Caption = 'Document No.'; } column(DocumentDate; "Document Date") { Caption = 'Document Date'; } column(Type; Type) { Caption = 'Type'; } column(No; "No.") { Caption = 'No.'; } column(Description; Description) { Caption = 'Description'; } column(Quantity; Quantity) { Caption = 'Quantity'; } column(DirectUnitCostLCY; "Direct Unit Cost (LCY)") { Caption = 'Direct Unit Cost (LCY)'; } column(UnitCostLCY; "Unit Cost (LCY)") { Caption = 'Unit Cost (LCY)'; } column(TotalCostLCY; "Total Cost (LCY)") { Caption = 'Total Cost (LCY)'; } column(UnitPriceLCY; "Unit Price (LCY)") { Caption = 'Unit Price (LCY)'; } column(TotalPriceLCY; "Total Price (LCY)") { Caption = 'Total Price (LCY)'; } column(ResourceGroupNo; "Resource Group No.") { Caption = 'Resource Group No.'; } column(UnitOfMeasureCode; "Unit of Measure Code") { Caption = 'Unit of Measure Code'; } column(JobPostingGroup; "Job Posting Group") { Caption = 'Project Posting Group'; } column(AmtToPostToGL; "Amt. to Post to G/L") { Caption = 'Amt. to Post to G/L'; } column(AmtPostedToGL; "Amt. Posted to G/L") { Caption = 'Amt. Posted to G/L'; } column(EntryType; "Entry Type") { Caption = 'Entry Type'; } column(JournalBatchName; "Journal Batch Name") { Caption = 'Journal Batch Name'; } column(ReasonCode; "Reason Code") { Caption = 'Reason Code'; } column(TransactionType; "Transaction Type") { Caption = 'Transaction Type'; } column(TransportMethod; "Transport Method") { Caption = 'Transport Method'; } column(CountryRegionCode; "Country/Region Code") { Caption = 'Country/Region Code'; } column(GenBusPostingGroup; "Gen. Bus. Posting Group") { Caption = 'Gen. Bus. Posting Group'; } column(GenProdPostingGroup; "Gen. Prod. Posting Group") { Caption = 'Gen. Prod. Posting Group'; } column(EntryExitPoint; "Entry/Exit Point") { Caption = 'Entry/Exit Point'; } column(ExternalDocumentNo; "External Document No.") { Caption = 'External Document No.'; } column(AreaCode; "Area") { Caption = 'Area'; } column(TransactionSpecification; "Transaction Specification") { Caption = 'Transaction Specification'; } column(NoSeries; "No. Series") { Caption = 'No. Series'; } column(AdditionalCurrencyTotalCost; "Additional-Currency Total Cost") { Caption = 'Additional-Currency Total Cost'; } column(AdditionalCurrencyTotalPrice; "Add.-Currency Total Price") { Caption = 'Add.-Currency Total Price'; } column(AdditionalCurrencyLineAmount; "Add.-Currency Line Amount") { Caption = 'Add.-Currency Line Amount'; } column(LineAmountLCY; "Line Amount (LCY)") { Caption = 'Line Amount (LCY)'; } column(UnitCost; "Unit Cost") { Caption = 'Unit Cost'; } column(TotalCost; "Total Cost") { Caption = 'Total Cost'; } column(UnitPrice; "Unit Price") { Caption = 'Unit Price'; } column(TotalPrice; "Total Price") { Caption = 'Total Price'; } column(LineAmount; "Line Amount") { Caption = 'Line Amount'; } column(LineDiscountAmount; "Line Discount Amount") { Caption = 'Line Discount Amount'; } column(LineDiscountAmountLCY; "Line Discount Amount (LCY)") { Caption = 'Line Discount Amount (LCY)'; } column(CurrencyCode; "Currency Code") { Caption = 'Currency Code'; } column(CurrencyFactor; "Currency Factor") { Caption = 'Currency Factor'; } column(LedgerEntryType; "Ledger Entry Type") { Caption = 'Ledger Entry Type'; } column(LedgerEntryNo; "Ledger Entry No.") { Caption = 'Ledger Entry No.'; } column(SerialNo; "Serial No.") { Caption = 'Serial No.'; } column(LotNo; "Lot No.") { Caption = 'Lot No.'; } column(LineDiscountPercent; "Line Discount %") { Caption = 'Line Discount %'; } column(LineType; "Line Type") { Caption = 'Line Type'; } 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(Job; Job) { DataItemLink = "No." = JobLedgerEntry."Job No."; column(JobDescription; Description) { Caption = 'Project Description'; } dataitem(JobTask; "Job Task") { DataItemLink = "Job No." = JobLedgerEntry."Job No.", "Job Task No." = JobLedgerEntry."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 = JobLedgerEntry."Work Type Code"; column(WorkTypeCode; Code) { Caption = 'Work Type Code'; } column(WorkTypeDescription; Description) { Caption = 'Work Type Description'; } dataitem(Location; Location) { DataItemLink = "Code" = JobLedgerEntry."Location Code"; column(LocationCode; Code) { Caption = 'Location Code'; } column(LocationName; Name) { Caption = 'Location Name'; } } } } } } }}