Table 774 User Details

System Application, System.Security.User

src/System Application/App/User Details/src/UserDetails.Table.al135 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 System.Security.User;using System.Security.AccessControl;/// <summary>/// Fetches user details information stored across multiple other tables./// </summary>table 774 "User Details"{    Access = Public;    Caption = 'User Details';    DataClassification = SystemMetadata; // temporary table    InherentEntitlements = X;    InherentPermissions = X;    TableType = Temporary;    // Keeping field IDs aligned with the User table, so that transfer fields would work if at some point a page would switch source table from User to User Details    fields    {        /// <summary>        /// An ID that uniquely identifies the user.        /// </summary>        field(1; "User Security ID"; Guid)        {            Access = Internal;        }        /// <summary>        /// User's name.        /// </summary>        field(2; "User Name"; Code[50])        {            Access = Internal;            CalcFormula = lookup(User."User Name" where("User Security ID" = field("User Security ID")));            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// User's full name.        /// </summary>        field(3; "Full Name"; Text[80])        {            Access = Internal;            CalcFormula = lookup(User."Full Name" where("User Security ID" = field("User Security ID")));            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Specifies whether the user can access companies in the current environment.        /// </summary>        field(4; State; Option)        {            Access = Internal;            CalcFormula = lookup(User.State where("User Security ID" = field("User Security ID")));            Editable = false;            FieldClass = FlowField;            OptionCaption = 'Active,Inactive';            OptionMembers = Enabled,Disabled;        }        /// <summary>        /// The authentication email of the user.        /// </summary>        field(11; "Authentication Email"; Text[250])        {            Access = Internal;            CalcFormula = lookup(User."Authentication Email" where("User Security ID" = field("User Security ID")));            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// The contact email of the user.        /// </summary>        field(14; "Contact Email"; Text[250])        {            Access = Internal;            CalcFormula = lookup(User."Contact Email" where("User Security ID" = field("User Security ID")));            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// An ID that uniquely identifies the user for the purposes of sending telemetry.        /// </summary>        field(21; "Telemetry User ID"; Guid)        {            Access = Internal;            CalcFormula = lookup("User Property"."Telemetry User ID" where("User Security ID" = field("User Security ID")));            Caption = 'Telemetry ID';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// An ID assigned to the user in Microsoft Entra.        /// </summary>        field(22; "Authentication Object ID"; Text[80])        {            Access = Internal;            CalcFormula = lookup("User Property"."Authentication Object ID" where("User Security ID" = field("User Security ID")));            Caption = 'Entra Object ID';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// True if the user SUPER permission set in any company, false otherwise.        /// </summary>        field(23; "Has SUPER permission set"; Boolean)        {            Access = Internal;            CalcFormula = exist("Access Control" where("User Security ID" = field("User Security ID"),                                                  "Role ID" = const('SUPER'),                                                  Scope = const(System),                                                  "App ID" = const('{00000000-0000-0000-0000-000000000000}')));            Editable = false;            FieldClass = FlowField;        }    }    keys    {        key(Key1; "User Security ID")        {            Clustered = true;        }    }    fieldgroups    {        fieldgroup(DropDown; "User Name")        {        }    }}