Table 9153 My Account

Base Application, Microsoft.Finance.GeneralLedger.Account

src/Layers/W1/BaseApp/Finance/GeneralLedger/Account/MyAccount.Table.al119 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.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Ledger;using System.Security.AccessControl;/// <summary>/// Stores personalized G/L account favorites for individual users./// Allows users to create shortcuts to frequently accessed accounts for quick navigation and monitoring./// </summary>table 9153 "My Account"{    Caption = 'My Account';    DataClassification = CustomerContent;    fields    {        /// <summary>        /// User identifier for the account favorite owner.        /// </summary>        field(1; "User ID"; Code[50])        {            Caption = 'User ID';            DataClassification = EndUserIdentifiableInformation;            TableRelation = User."User Name";            ValidateTableRelation = false;        }        /// <summary>        /// The G/L account number that the user has marked as a favorite.        /// </summary>        field(2; "Account No."; Code[20])        {            Caption = 'Account No.';            ToolTip = 'Specifies the G/L account number.';            NotBlank = true;            TableRelation = "G/L Account";            trigger OnValidate()            begin                SetAccountFields();            end;        }        /// <summary>        /// The name of the G/L account, populated automatically from the account master data.        /// </summary>        field(3; Name; Text[100])        {            Caption = 'Name';            ToolTip = 'Specifies the name of the G/L account.';            Editable = false;        }#if not CLEANSCHEMA29        /// <summary>        /// Legacy account balance field, replaced by "Acc. Balance" to avoid modification issues.        /// </summary>        field(5; "Account Balance"; Decimal)        {            AutoFormatType = 0;            Caption = 'Account Balance (to be removed)';            Editable = false;            ObsoleteState = Removed;            ObsoleteTag = '29.0';            ObsoleteReason = 'Replaced by "Acc. Balance" to avoid modification in My Accounts page.';        }#endif        /// <summary>        /// The totaling filter from the G/L account, used for calculating balances of total-type accounts.        /// </summary>        field(7; Totaling; Text[250])        {            Caption = 'Totaling';            Editable = false;        }        /// <summary>        /// Current balance of the G/L account, calculated from posted G/L entries.        /// </summary>        field(10; "Acc. Balance"; Decimal)        {            AutoFormatExpression = '';            AutoFormatType = 1;            CalcFormula = sum("G/L Entry".Amount where("G/L Account No." = field("Account No."),                                                       "G/L Account No." = field(filter(Totaling))));            Caption = 'Balance';            ToolTip = 'Specifies the balance of the G/L account.';            Editable = false;            FieldClass = FlowField;        }    }    keys    {        key(Key1; "User ID", "Account No.")        {            Clustered = true;        }        key(Key2; Name)        {        }    }    fieldgroups    {    }    local procedure SetAccountFields()    var        GLAccount: Record "G/L Account";    begin        GLAccount.SetLoadFields("Name", Totaling);        if GLAccount.Get("Account No.") then begin            Name := GLAccount.Name;            Totaling := GLAccount.Totaling;        end;    end;}