Table 9005 User Plan in 26
- App
- System Application
- Namespace
- System.Azure.Identity
Versions171819202122232425262728latest
Source in 26
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;
}
}
}Fields, 5
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | User Security ID | Guid | - |
| 2 | Plan ID | Guid | - |
| 10 | User Name | Code[50] | - |
| 11 | User Full Name | Text[80] | - |
| 12 | Plan Name | Text[50] | - |
Keys, 1
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Plan ID, User Security ID | - |