Query 123 Fixed Assets Analysis

// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------
namespace Microsoft.FixedAssets.Reports;

using Microsoft.FixedAssets.Depreciation;
using Microsoft.FixedAssets.FixedAsset;
using Microsoft.FixedAssets.Ledger;
using Microsoft.FixedAssets.Setup;

query 123 "Fixed Assets Analysis"
{
    QueryType = Normal;
    DataAccessIntent = ReadOnly;
    UsageCategory = ReportsAndAnalysis;
    Caption = 'Fixed Assets Ad-hoc Analysis';
    AboutTitle = 'About Fixed Assets Ad-hoc Analysis';
    AboutText = 'The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report ''Book Value 01''.';

    elements
    {
        dataitem(FALedgerEntry; "FA Ledger Entry")
        {
            column(No; "FA No.")
            {
                Caption = 'FA No.';
            }
            column(FAPostingDate; "FA Posting Date")
            {
                Caption = 'FA Posting Date';
            }
            column(PostingDate; "Posting Date")
            {
                Caption = 'Posting Date';
            }
            column(DocumentType; "Document Type")
            {
                Caption = 'Document Type';
            }
            column(DocumentDate; "Document Date")
            {
                Caption = 'Document Date';
            }
            column(DocumentNo; "Document No.")
            {
                Caption = 'Document No.';
            }
            column(Description; Description)
            {
                Caption = 'Description';
            }
            column(PostingCategory; "FA Posting Category")
            {
                Caption = 'Posting Category';
            }
            column(FAPostingType; "FA Posting Type")
            {
                Caption = 'Posting Type';
            }
            column(Amount; Amount)
            {
                Caption = 'Amount';
            }
            column(ReclassificationEntry; "Reclassification Entry")
            {
                Caption = 'Reclassification Entry';
            }
            column(FApostingGroup; "FA Posting Group")
            {
                Caption = 'FA Posting Group';
            }
            column(Depreciation_Method; "Depreciation Method")
            {
                Caption = 'Depreciation Method';
            }
            column(DepreciationStartingDate; "Depreciation Starting Date")
            {
                Caption = 'Depreciation Starting Date';
            }
            column(DepreciationEndingDate; "Depreciation Ending Date")
            {
                Caption = 'Depreciation Ending Date';
            }
            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(FixedAsset; "Fixed Asset")
            {
                DataItemLink = "No." = FALedgerEntry."FA No.";
                column(FADescription; Description)
                {
                    Caption = 'FA Description';
                }
                dataitem(FAClass; "FA Class")
                {
                    DataItemLink = Code = FALedgerEntry."FA Class Code";
                    column(ClassCode; Code)
                    {
                        Caption = 'Class Code';
                    }
                    column(ClassName; Name)
                    {
                        Caption = 'Class Name';
                    }
                    dataitem(FASubClass; "FA Subclass")
                    {
                        DataItemLink = Code = FALedgerEntry."FA Subclass Code";
                        column(SubClassCode; Code)
                        {
                            Caption = 'Subclass Code';
                        }
                        column(FASubClassName; Name)
                        {
                            Caption = 'Subclass Name';
                        }
                        dataitem(FALocation; "FA Location")
                        {
                            DataItemLink = Code = FALedgerEntry."FA Location Code";
                            column(FALocationCode; Code)
                            {
                                Caption = 'FA Location Code';
                            }
                            column(FALocationName; Name)
                            {
                                Caption = 'FA Location Name';
                            }
                            dataitem(DepreciationBook; "Depreciation Book")
                            {
                                DataItemLink = "Code" = FALedgerEntry."Depreciation Book Code";
                                column(DepBookCode; Code)
                                {
                                    Caption = 'Depreciation Book Code';
                                }
                                column(DepBookDescription; Description)
                                {
                                    Caption = 'Depreciation Book Desc.';
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}