Query 123 Fixed Assets Analysis

Base Application, Microsoft.FixedAssets.Reports

src/Layers/W1/BaseApp/FixedAssets/FixedAsset/FixedAssetsAnalysis.Query.al176 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.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.';                                }                            }                        }                    }                }            }        }    }}