Table User
Stores user account information and security settings for all users in the Business Central tenant. Manages user authentication, licensing, and access control across companies and applications.
Remarks
This table serves as the central user repository for security management, license assignment, and user authentication. Integrates with Azure Active Directory, permission sets, and user groups. Used by authentication services, user management interfaces, and security audit processes.
Properties
| Name | Value |
|---|---|
| Caption | User |
| DataPerCompany | False |
| ReplicateData | False |
| Scope | Cloud |
| CompressionType | None |
Fields
| Name | Type | Description |
|---|---|---|
| "User Security ID" | Guid | Unique global identifier for the user account in the Business Central security system. |
| "User Name" | Code[50] | Login name used for user authentication and identification. |
| "Full Name" | Text[80] | Complete display name of the user for identification and user interface purposes. |
| State | Option | Current activation status of the user account (Enabled or Disabled). |
| "Expiry Date" | DateTime | Date and time when the user account expires and access is automatically revoked. |
| "Windows Security ID" | Text[119] | Windows Active Directory security identifier for domain-authenticated users. |
| "Change Password" | Boolean | Indicates whether the user must change their password on next login. |
| "License Type" | Option | License type assigned to the user determining available functionality and restrictions. |
| "Authentication Email" | Text[250] | Email address used for authentication and Azure Active Directory integration. |
| "Contact Email" | Text[250] | Primary contact email address for communications and notifications. |
| "Exchange Identifier" | Text[250] | Exchange server identifier for Microsoft Office and email integration. |
| "Application ID" | Guid | Azure Active Directory application identifier for service principal accounts. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |