Table 9005 User Plan, source in 24
Source242526272829metadata in 24
src/System Application/App/Azure AD Plan/src/UserPlan.Table.al63 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.Azure.Identity;
using System.Security.AccessControl;
/// <summary>
/// Displays a list of the plans assigned to users.
/// </summary>
table 9005 "User Plan"
{
Caption = 'User Plan';
DataPerCompany = false;
ReplicateData = false;
Access = Internal;
InherentEntitlements = rX;
InherentPermissions = rX;
fields
{
field(1; "User Security ID"; Guid)
{
Caption = 'User Security ID';
DataClassification = EndUserPseudonymousIdentifiers;
TableRelation = User."User Security ID";
}
field(2; "Plan ID"; Guid)
{
DataClassification = SystemMetadata;
Caption = 'Plan ID';
TableRelation = Plan."Plan ID";
}
field(10; "User Name"; Code[50])
{
CalcFormula = lookup(User."User Name" where("User Security ID" = field("User Security ID")));
Caption = 'User Name';
FieldClass = FlowField;
}
field(11; "User Full Name"; Text[80])
{
CalcFormula = lookup(User."Full Name" where("User Security ID" = field("User Security ID")));
Caption = 'Full Name';
FieldClass = FlowField;
}
field(12; "Plan Name"; Text[50])
{
CalcFormula = lookup(Plan.Name where("Plan ID" = field("Plan ID")));
Caption = 'Plan Name';
FieldClass = FlowField;
}
}
keys
{
key(Key1; "Plan ID", "User Security ID")
{
Clustered = true;
}
}
}