Table 774 User Details
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") { } }}