SystemUser table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse. Person with access to the Microsoft CRM system and who owns objects in the Microsoft CRM database.

Messages

Message	Web API Operation	SDK Assembly
Create	POST [org URI]/api/data/v9.0/systemusers See Create	CreateRequest or Create
Delete	DELETE [org URI]/api/data/v9.0/systemusers(systemuserid) See Delete	DeleteRequest or Delete
msdyn_GDPROptoutUser	Microsoft.Dynamics.CRM.msdyn_GDPROptoutUser?text=msdyn_GDPROptoutUser Action	Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message.
ReassignObjectsSystemUser	ReassignObjectsSystemUser Action	ReassignObjectsSystemUserRequest
RemoveParent	RemoveParent Action	RemoveParentRequest
Retrieve	GET [org URI]/api/data/v9.0/systemusers(systemuserid) See Retrieve	RetrieveRequest or Retrieve
RetrieveAllChildUsersSystemUser	RetrieveAllChildUsersSystemUser Function	RetrieveAllChildUsersSystemUserRequest
RetrieveMultiple	GET [org URI]/api/data/v9.0/systemusers See Query Data	RetrieveMultipleRequest or RetrieveMultiple
SetBusinessEquipment	Microsoft.Dynamics.CRM.SetBusinessEquipment?text=SetBusinessEquipment Action	SetBusinessEquipmentRequest
SetBusinessSystemUser	SetBusinessSystemUser Action	SetBusinessSystemUserRequest
SetParentBusinessUnit	Associate and disassociate entities	SetParentBusinessUnitRequest
SetParentSystemUser	SetParentSystemUser Action	SetParentSystemUserRequest
SetParentTeam	SetParentTeam Action	SetParentTeamRequest
SetState	PATCH [org URI]/api/data/v9.0/systemusers(systemuserid) Update statecode and statuscode properties.	SetStateRequest
Update	PATCH [org URI]/api/data/v9.0/systemusers(systemuserid) See Update	UpdateRequest or Update

Properties

Property	Value
CollectionSchemaName	SystemUsers
DisplayCollectionName	Users
DisplayName	User
EntitySetName	systemusers
IsBPFEntity	False
LogicalCollectionName	systemusers
LogicalName	systemuser
OwnershipType	BusinessOwned
PrimaryIdAttribute	systemuserid
PrimaryNameAttribute	fullname
SchemaName	SystemUser

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• AccessMode
• Address1_AddressId
• Address1_AddressTypeCode
• Address1_City
• Address1_Country
• Address1_County
• Address1_Fax
• Address1_Latitude
• Address1_Line1
• Address1_Line2
• Address1_Line3
• Address1_Longitude
• Address1_Name
• Address1_PostalCode
• Address1_PostOfficeBox
• Address1_ShippingMethodCode
• Address1_StateOrProvince
• Address1_Telephone1
• Address1_Telephone2
• Address1_Telephone3
• Address1_UPSZone
• Address1_UTCOffset
• Address2_AddressId
• Address2_AddressTypeCode
• Address2_City
• Address2_Country
• Address2_County
• Address2_Fax
• Address2_Latitude
• Address2_Line1
• Address2_Line2
• Address2_Line3
• Address2_Longitude
• Address2_Name
• Address2_PostalCode
• Address2_PostOfficeBox
• Address2_ShippingMethodCode
• Address2_StateOrProvince
• Address2_Telephone1
• Address2_Telephone2
• Address2_Telephone3
• Address2_UPSZone
• Address2_UTCOffset
• ApplicationId
• AzureState
• BusinessUnitId
• CalendarId
• CALType
• DisplayInServiceViews
• DomainName
• EmailRouterAccessApproval
• EmployeeId
• EntityImage
• FirstName
• GovernmentId
• HomePhone
• ImportSequenceNumber
• IncomingEmailDeliveryMethod
• InternalEMailAddress
• InviteStatusCode
• IsDisabled
• IsIntegrationUser
• IsLicensed
• IsSyncWithDirectory
• JobTitle
• LastName
• MiddleName
• MobileAlertEMail
• MobileOfflineProfileId
• MobileOfflineProfileIdName
• MobilePhone
• msdyn_AgentType
• msdyn_BotApplicationId
• msdyn_BotDescription
• msdyn_BotEndpoint
• msdyn_bothandle
• msdyn_BotProvider
• msdyn_BotSecretKeys
• msdyn_Capacity
• msdyn_cognitiveservicesregion
• msdyn_cognitiveservicessubscriptionkey
• msdyn_DefaultPresenceIdUser
• msdyn_gdproptout
• msdyn_gridwrappercontrolfield
• msdyn_isexpertenabledforswarm
• msdyn_OwningEnvironmentId
• msdyn_phonenumberid
• msdyn_UserType
• NickName
• OutgoingEmailDeliveryMethod
• OverriddenCreatedOn
• ParentSystemUserId
• PassportHi
• PassportLo
• PersonalEMailAddress
• PhotoUrl
• PositionId
• PreferredAddressCode
• PreferredEmailCode
• PreferredPhoneCode
• ProcessId
• QueueId
• Salutation
• SetupUser
• SharePointEmailAddress
• SiteId
• Skills
• StageId
• SystemUserId
• TerritoryId
• TimeZoneRuleVersionNumber
• Title
• TransactionCurrencyId
• TraversedPath
• UserLicenseType
• UTCConversionTimeZoneCode
• WindowsLiveID
• YammerEmailAddress
• YammerUserId
• YomiFirstName
• YomiLastName
• YomiMiddleName

AccessMode

Property	Value
Description	Type of user.
DisplayName	Access Mode
IsValidForForm	True
IsValidForRead	True
LogicalName	accessmode
RequiredLevel	SystemRequired
Type	Picklist

AccessMode Choices/Options

Value	Label
0	Read-Write
1	Administrative
2	Read
3	Support User
4	Non-interactive
5	Delegated Admin

Address1_AddressId

Property	Value
Description	Unique identifier for address 1.
DisplayName	Address 1: ID
IsValidForForm	False
IsValidForRead	True
LogicalName	address1_addressid
RequiredLevel	None
Type	Uniqueidentifier

Address1_AddressTypeCode

Property	Value
Description	Type of address for address 1, such as billing, shipping, or primary address.
DisplayName	Address 1: Address Type
IsValidForForm	False
IsValidForRead	True
LogicalName	address1_addresstypecode
RequiredLevel	None
Type	Picklist

Address1_AddressTypeCode Choices/Options

Value	Label
1	Default Value

Address1_City

Property	Value
Description	City name for address 1.
DisplayName	City
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_city
MaxLength	128
RequiredLevel	None
Type	String

Address1_Country

Property	Value
Description	Country/region name in address 1.
DisplayName	Country/Region
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_country
MaxLength	128
RequiredLevel	None
Type	String

Address1_County

Property	Value
Description	County name for address 1.
DisplayName	Address 1: County
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_county
MaxLength	128
RequiredLevel	None
Type	String

Address1_Fax

Property	Value
Description	Fax number for address 1.
DisplayName	Address 1: Fax
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_fax
MaxLength	64
RequiredLevel	None
Type	String

Address1_Latitude

Property	Value
Description	Latitude for address 1.
DisplayName	Address 1: Latitude
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_latitude
MaxValue	90
MinValue	-90
Precision	5
RequiredLevel	None
Type	Double

Address1_Line1

Property	Value
Description	First line for entering address 1 information.
DisplayName	Street 1
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_line1
MaxLength	1024
RequiredLevel	None
Type	String

Address1_Line2

Property	Value
Description	Second line for entering address 1 information.
DisplayName	Street 2
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_line2
MaxLength	1024
RequiredLevel	None
Type	String

Address1_Line3

Property	Value
Description	Third line for entering address 1 information.
DisplayName	Street 3
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_line3
MaxLength	1024
RequiredLevel	None
Type	String

Address1_Longitude

Property	Value
Description	Longitude for address 1.
DisplayName	Address 1: Longitude
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_longitude
MaxValue	180
MinValue	-180
Precision	5
RequiredLevel	None
Type	Double

Address1_Name

Property	Value
Description	Name to enter for address 1.
DisplayName	Address 1: Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_name
MaxLength	100
RequiredLevel	None
Type	String

Address1_PostalCode

Property	Value
Description	ZIP Code or postal code for address 1.
DisplayName	ZIP/Postal Code
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_postalcode
MaxLength	40
RequiredLevel	None
Type	String

Address1_PostOfficeBox

Property	Value
Description	Post office box number for address 1.
DisplayName	Address 1: Post Office Box
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_postofficebox
MaxLength	40
RequiredLevel	None
Type	String

Address1_ShippingMethodCode

Property	Value
Description	Method of shipment for address 1.
DisplayName	Address 1: Shipping Method
IsValidForForm	False
IsValidForRead	True
LogicalName	address1_shippingmethodcode
RequiredLevel	None
Type	Picklist

Address1_ShippingMethodCode Choices/Options

Value	Label
1	Default Value

Address1_StateOrProvince

Property	Value
Description	State or province for address 1.
DisplayName	State/Province
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_stateorprovince
MaxLength	128
RequiredLevel	None
Type	String

Address1_Telephone1

Property	Value
Description	First telephone number associated with address 1.
DisplayName	Main Phone
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_telephone1
MaxLength	64
RequiredLevel	None
Type	String

Address1_Telephone2

Property	Value
Description	Second telephone number associated with address 1.
DisplayName	Other Phone
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_telephone2
MaxLength	50
RequiredLevel	None
Type	String

Address1_Telephone3

Property	Value
Description	Third telephone number associated with address 1.
DisplayName	Pager
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_telephone3
MaxLength	50
RequiredLevel	None
Type	String

Address1_UPSZone

Property	Value
Description	United Parcel Service (UPS) zone for address 1.
DisplayName	Address 1: UPS Zone
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	address1_upszone
MaxLength	4
RequiredLevel	None
Type	String

Address1_UTCOffset

Property	Value
Description	UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.
DisplayName	Address 1: UTC Offset
Format	TimeZone
IsValidForForm	False
IsValidForRead	True
LogicalName	address1_utcoffset
MaxValue	1500
MinValue	-1500
RequiredLevel	None
Type	Integer

Address2_AddressId

Property	Value
Description	Unique identifier for address 2.
DisplayName	Address 2: ID
IsValidForForm	False
IsValidForRead	True
LogicalName	address2_addressid
RequiredLevel	None
Type	Uniqueidentifier

Address2_AddressTypeCode

Property	Value
Description	Type of address for address 2, such as billing, shipping, or primary address.
DisplayName	Address 2: Address Type
IsValidForForm	False
IsValidForRead	True
LogicalName	address2_addresstypecode
RequiredLevel	None
Type	Picklist

Address2_AddressTypeCode Choices/Options

Value	Label
1	Default Value

Address2_City

Property	Value
Description	City name for address 2.
DisplayName	Other City
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_city
MaxLength	128
RequiredLevel	None
Type	String

Address2_Country

Property	Value
Description	Country/region name in address 2.
DisplayName	Other Country/Region
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_country
MaxLength	128
RequiredLevel	None
Type	String

Address2_County

Property	Value
Description	County name for address 2.
DisplayName	Address 2: County
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_county
MaxLength	128
RequiredLevel	None
Type	String

Address2_Fax

Property	Value
Description	Fax number for address 2.
DisplayName	Address 2: Fax
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_fax
MaxLength	50
RequiredLevel	None
Type	String

Address2_Latitude

Property	Value
Description	Latitude for address 2.
DisplayName	Address 2: Latitude
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_latitude
MaxValue	90
MinValue	-90
Precision	5
RequiredLevel	None
Type	Double

Address2_Line1

Property	Value
Description	First line for entering address 2 information.
DisplayName	Other Street 1
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_line1
MaxLength	1024
RequiredLevel	None
Type	String

Address2_Line2

Property	Value
Description	Second line for entering address 2 information.
DisplayName	Other Street 2
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_line2
MaxLength	1024
RequiredLevel	None
Type	String

Address2_Line3

Property	Value
Description	Third line for entering address 2 information.
DisplayName	Other Street 3
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_line3
MaxLength	1024
RequiredLevel	None
Type	String

Address2_Longitude

Property	Value
Description	Longitude for address 2.
DisplayName	Address 2: Longitude
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_longitude
MaxValue	180
MinValue	-180
Precision	5
RequiredLevel	None
Type	Double

Address2_Name

Property	Value
Description	Name to enter for address 2.
DisplayName	Address 2: Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_name
MaxLength	100
RequiredLevel	None
Type	String

Address2_PostalCode

Property	Value
Description	ZIP Code or postal code for address 2.
DisplayName	Other ZIP/Postal Code
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_postalcode
MaxLength	40
RequiredLevel	None
Type	String

Address2_PostOfficeBox

Property	Value
Description	Post office box number for address 2.
DisplayName	Address 2: Post Office Box
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_postofficebox
MaxLength	40
RequiredLevel	None
Type	String

Address2_ShippingMethodCode

Property	Value
Description	Method of shipment for address 2.
DisplayName	Address 2: Shipping Method
IsValidForForm	False
IsValidForRead	True
LogicalName	address2_shippingmethodcode
RequiredLevel	None
Type	Picklist

Address2_ShippingMethodCode Choices/Options

Value	Label
1	Default Value

Address2_StateOrProvince

Property	Value
Description	State or province for address 2.
DisplayName	Other State/Province
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_stateorprovince
MaxLength	128
RequiredLevel	None
Type	String

Address2_Telephone1

Property	Value
Description	First telephone number associated with address 2.
DisplayName	Address 2: Telephone 1
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_telephone1
MaxLength	50
RequiredLevel	None
Type	String

Address2_Telephone2

Property	Value
Description	Second telephone number associated with address 2.
DisplayName	Address 2: Telephone 2
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_telephone2
MaxLength	50
RequiredLevel	None
Type	String

Address2_Telephone3

Property	Value
Description	Third telephone number associated with address 2.
DisplayName	Address 2: Telephone 3
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_telephone3
MaxLength	50
RequiredLevel	None
Type	String

Address2_UPSZone

Property	Value
Description	United Parcel Service (UPS) zone for address 2.
DisplayName	Address 2: UPS Zone
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	address2_upszone
MaxLength	4
RequiredLevel	None
Type	String

Address2_UTCOffset

Property	Value
Description	UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time.
DisplayName	Address 2: UTC Offset
Format	TimeZone
IsValidForForm	False
IsValidForRead	True
LogicalName	address2_utcoffset
MaxValue	1500
MinValue	-1500
RequiredLevel	None
Type	Integer

ApplicationId

Property	Value
Description	The identifier for the application. This is used to access data in another application.
DisplayName	Application ID
IsValidForForm	True
IsValidForRead	True
LogicalName	applicationid
RequiredLevel	None
Type	Uniqueidentifier

AzureState

Added by: AuthorizationCore Solution

Property	Value
Description	Azure state of user
DisplayName	Azure State
IsValidForCreate	False
IsValidForForm	True
IsValidForRead	True
LogicalName	azurestate
RequiredLevel	SystemRequired
Type	Picklist

AzureState Choices/Options

Value	Label
0	Exists
1	Soft deleted
2	Not found or hard deleted

BusinessUnitId

Property	Value
Description	Unique identifier of the business unit with which the user is associated.
DisplayName	Business Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	businessunitid
RequiredLevel	SystemRequired
Targets	businessunit
Type	Lookup

CalendarId

Property	Value
Description	Fiscal calendar associated with the user.
DisplayName	Calendar
IsValidForForm	False
IsValidForRead	True
LogicalName	calendarid
RequiredLevel	None
Targets	calendar
Type	Lookup

CALType

Property	Value
Description	License type of user. This is used only in the on-premises version of the product. Online licenses are managed through Microsoft 365 Office Portal
DisplayName	License Type
IsValidForForm	True
IsValidForRead	True
LogicalName	caltype
RequiredLevel	SystemRequired
Type	Picklist

CALType Choices/Options

Value	Label
0	Professional
1	Administrative
2	Basic
3	Device Professional
4	Device Basic
5	Essential
6	Device Essential
7	Enterprise
8	Device Enterprise
9	Sales
10	Service
11	Field Service
12	Project Service

DisplayInServiceViews

Property	Value
Description	Whether to display the user in service views.
DisplayName	Display in Service Views
IsValidForForm	False
IsValidForRead	True
LogicalName	displayinserviceviews
RequiredLevel	None
Type	Boolean

DisplayInServiceViews Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

DomainName

Property	Value
Description	Active Directory domain of which the user is a member.
DisplayName	User Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	domainname
MaxLength	1024
RequiredLevel	SystemRequired
Type	String

EmailRouterAccessApproval

Property	Value
Description	Shows the status of the primary email address.
DisplayName	Primary Email Status
IsValidForCreate	False
IsValidForForm	True
IsValidForRead	True
LogicalName	emailrouteraccessapproval
RequiredLevel	SystemRequired
Type	Picklist

EmailRouterAccessApproval Choices/Options

Value	Label
0	Empty
1	Approved
2	Pending Approval
3	Rejected

EmployeeId

Property	Value
Description	Employee identifier for the user.
DisplayName	Employee
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	employeeid
MaxLength	100
RequiredLevel	None
Type	String

EntityImage

Property	Value
Description	Shows the default image for the record.
DisplayName	Entity Image
IsPrimaryImage	True
IsValidForForm	False
IsValidForRead	True
LogicalName	entityimage
MaxHeight	144
MaxWidth	144
RequiredLevel	None
Type	Image

FirstName

Property	Value
Description	First name of the user.
DisplayName	First Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	firstname
MaxLength	256
RequiredLevel	ApplicationRequired
Type	String

GovernmentId

Property	Value
Description	Government identifier for the user.
DisplayName	Government
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	governmentid
MaxLength	100
RequiredLevel	None
Type	String

HomePhone

Property	Value
Description	Home phone number for the user.
DisplayName	Home Phone
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	homephone
MaxLength	50
RequiredLevel	None
Type	String

ImportSequenceNumber

Property	Value
Description	Unique identifier of the data import or data migration that created this record.
DisplayName	Import Sequence Number
Format	None
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	importsequencenumber
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

IncomingEmailDeliveryMethod

Property	Value
Description	Incoming email delivery method for the user.
DisplayName	Incoming Email Delivery Method
IsValidForForm	True
IsValidForRead	True
LogicalName	incomingemaildeliverymethod
RequiredLevel	SystemRequired
Type	Picklist

IncomingEmailDeliveryMethod Choices/Options

Value	Label
0	None
1	Microsoft Dynamics 365 for Outlook
2	Server-Side Synchronization or Email Router
3	Forward Mailbox

InternalEMailAddress

Property	Value
Description	Internal email address for the user.
DisplayName	Primary Email
FormatName	Email
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	internalemailaddress
MaxLength	100
RequiredLevel	SystemRequired
Type	String

InviteStatusCode

Property	Value
Description	User invitation status.
DisplayName	Invitation Status
IsValidForForm	True
IsValidForRead	True
LogicalName	invitestatuscode
RequiredLevel	ApplicationRequired
Type	Picklist

InviteStatusCode Choices/Options

Value	Label
0	Invitation Not Sent
1	Invited
2	Invitation Near Expired
3	Invitation Expired
4	Invitation Accepted
5	Invitation Rejected
6	Invitation Revoked

IsDisabled

Property	Value
Description	Information about whether the user is enabled.
DisplayName	Status
IsValidForCreate	False
IsValidForForm	True
IsValidForRead	True
LogicalName	isdisabled
RequiredLevel	None
Type	Boolean

IsDisabled Choices/Options

Value	Label
1	Disabled
0	Enabled

DefaultValue: False

IsIntegrationUser

Property	Value
Description	Check if user is an integration user.
DisplayName	Integration user mode
IsValidForForm	True
IsValidForRead	True
LogicalName	isintegrationuser
RequiredLevel	SystemRequired
Type	Boolean

IsIntegrationUser Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

IsLicensed

Property	Value
Description	Information about whether the user is licensed.
DisplayName	User Licensed
IsValidForForm	True
IsValidForRead	True
LogicalName	islicensed
RequiredLevel	SystemRequired
Type	Boolean

IsLicensed Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

IsSyncWithDirectory

Property	Value
Description	Information about whether the user is synced with the directory.
DisplayName	User Synced
IsValidForForm	False
IsValidForRead	True
LogicalName	issyncwithdirectory
RequiredLevel	SystemRequired
Type	Boolean

IsSyncWithDirectory Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

JobTitle

Property	Value
Description	Job title of the user.
DisplayName	Job Title
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	jobtitle
MaxLength	100
RequiredLevel	None
Type	String

LastName

Property	Value
Description	Last name of the user.
DisplayName	Last Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	lastname
MaxLength	256
RequiredLevel	ApplicationRequired
Type	String

MiddleName

Property	Value
Description	Middle name of the user.
DisplayName	Middle Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	middlename
MaxLength	50
RequiredLevel	None
Type	String

MobileAlertEMail

Property	Value
Description	Mobile alert email address for the user.
DisplayName	Mobile Alert Email
FormatName	Email
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	mobilealertemail
MaxLength	100
RequiredLevel	None
Type	String

MobileOfflineProfileId

Property	Value
Description	Items contained with a particular SystemUser.
DisplayName	Mobile Offline Profile
IsValidForForm	False
IsValidForRead	True
LogicalName	mobileofflineprofileid
RequiredLevel	None
Targets	mobileofflineprofile
Type	Lookup

MobileOfflineProfileIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	mobileofflineprofileidname
MaxLength	100
RequiredLevel	None
Type	String

MobilePhone

Property	Value
Description	Mobile phone number for the user.
DisplayName	Mobile Phone
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	mobilephone
MaxLength	64
RequiredLevel	None
Type	String

msdyn_AgentType

Added by: Omnichannel – Bot Enabler Solution

Property	Value
Description	Type of user - Application user or Bot application user
DisplayName	User type
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_agentType
RequiredLevel	None
Type	Picklist

msdyn_AgentType Choices/Options

Value	Label
192350000	Application user
192350001	Bot application user

msdyn_BotApplicationId

Added by: Omnichannel – Bot Enabler Solution

Property	Value
Description	Application ID of the bot.
DisplayName	Bot application ID
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_botapplicationid
MaxLength	100
RequiredLevel	None
Type	String

msdyn_BotDescription

Added by: Omnichannel – Base Solution

Property	Value
Description	BOT User Description
DisplayName	Description
Format	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_botdescription
MaxLength	2000
RequiredLevel	None
Type	Memo

msdyn_BotEndpoint

Added by: Omnichannel – Base Solution

Property	Value
Description	Bot User Endpoint
DisplayName	Endpoint
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_botendpoint
MaxLength	100
RequiredLevel	None
Type	String

msdyn_bothandle

Added by: Omnichannel - Bot Enabler Patch Solution

Property	Value
Description	Bot handle
DisplayName	Bot handle
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_bothandle
MaxLength	100
RequiredLevel	None
Type	String

msdyn_BotProvider

Added by: Omnichannel - Bot Enabler Patch Solution

Property	Value
Description	Indicates the type of bot
DisplayName	Bot Provider
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_botprovider
RequiredLevel	ApplicationRequired
Type	Picklist

msdyn_BotProvider Choices/Options

Value	Label
192350000	Virtual Agent
192350001	Other
192350002	None

msdyn_BotSecretKeys

Added by: Omnichannel – Base Solution

Property	Value
Description	Bot User Secret Keys
DisplayName	Secret Keys
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_botsecretkeys
MaxLength	100
RequiredLevel	None
Type	String

msdyn_Capacity

Added by: Omnichannel – Base Solution

Property	Value
Description	Capacity associated with the User.
DisplayName	Capacity
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_capacity
MaxValue	2147483647
MinValue	0
RequiredLevel	None
Type	Integer

msdyn_cognitiveservicesregion

Added by: Omnichannel - Telephony Solution

Property	Value
Description	Cognitive Services Region
DisplayName	Cognitive Services Region
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_cognitiveservicesregion
MaxLength	100
RequiredLevel	None
Type	String

msdyn_cognitiveservicessubscriptionkey

Added by: Omnichannel - Telephony Solution

Property	Value
Description	Cognitive Services Subscription Key
DisplayName	Cognitive Services Subscription Key
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_cognitiveservicessubscriptionkey
MaxLength	100
RequiredLevel	None
Type	String

msdyn_DefaultPresenceIdUser

Added by: Omnichannel – Base Solution

Property	Value
Description	Unique identifier for Presence associated with User.
DisplayName	Default Presence
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_defaultpresenceiduser
RequiredLevel	None
Targets	msdyn_presence
Type	Lookup

msdyn_gdproptout

Added by: SI Common Solution

Property	Value
Description	Describes whether user is opted out or not
DisplayName	GDPR Optout
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_gdproptout
RequiredLevel	None
Type	Boolean

msdyn_gdproptout Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

msdyn_gridwrappercontrolfield

Added by: Omnichannel - Skill Based Routing Solution

Property	Value
Description	Field to bind grid wrapper control
DisplayName	Grid Wrapper Control field
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_gridwrappercontrolfield
MaxLength	4000
RequiredLevel	None
Type	String

msdyn_isexpertenabledforswarm

Added by: swarming Solution

Property	Value
Description	Check if swarm is enabled for the experts.
DisplayName	Expert Enabled Swarm
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_isexpertenabledforswarm
RequiredLevel	ApplicationRequired
Type	Boolean

msdyn_isexpertenabledforswarm Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

msdyn_OwningEnvironmentId

Added by: Omnichannel - Bot Enabler Patch Solution

Property	Value
Description	Environment Id of the CDS environment that owns the bot user.
DisplayName	Owning Environment Id
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_owningenvironmentid
MaxLength	500
RequiredLevel	None
Type	String

msdyn_phonenumberid

Added by: Omnichannel - CommunicationBase Solution

Property	Value
Description
DisplayName	Phone Number
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_phonenumberid
RequiredLevel	None
Targets	msdyn_ocphonenumber
Type	Lookup

msdyn_UserType

Added by: Omnichannel – Base Solution

Property	Value
Description	Type of user - CRM or BOT user
DisplayName	Type
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_usertype
RequiredLevel	None
Type	Picklist

msdyn_UserType Choices/Options

Value	Label
192350000	CRM User
192350001	BOT User

NickName

Property	Value
Description	Nickname of the user.
DisplayName	Nickname
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	nickname
MaxLength	50
RequiredLevel	None
Type	String

OutgoingEmailDeliveryMethod

Property	Value
Description	Outgoing email delivery method for the user.
DisplayName	Outgoing Email Delivery Method
IsValidForForm	True
IsValidForRead	True
LogicalName	outgoingemaildeliverymethod
RequiredLevel	SystemRequired
Type	Picklist

OutgoingEmailDeliveryMethod Choices/Options

Value	Label
0	None
1	Microsoft Dynamics 365 for Outlook
2	Server-Side Synchronization or Email Router

OverriddenCreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time that the record was migrated.
DisplayName	Record Created On
Format	DateOnly
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	overriddencreatedon
RequiredLevel	None
Type	DateTime

ParentSystemUserId

Property	Value
Description	Unique identifier of the manager of the user.
DisplayName	Manager
IsValidForForm	True
IsValidForRead	True
LogicalName	parentsystemuserid
RequiredLevel	None
Targets	systemuser
Type	Lookup

PassportHi

Property	Value
Description	For internal use only.
DisplayName	Passport Hi
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	passporthi
MaxValue	1000000000
MinValue	0
RequiredLevel	None
Type	Integer

PassportLo

Property	Value
Description	For internal use only.
DisplayName	Passport Lo
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	passportlo
MaxValue	1000000000
MinValue	0
RequiredLevel	None
Type	Integer

PersonalEMailAddress

Property	Value
Description	Personal email address of the user.
DisplayName	Email 2
FormatName	Email
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	personalemailaddress
MaxLength	100
RequiredLevel	None
Type	String

PhotoUrl

Property	Value
Description	URL for the Website on which a photo of the user is located.
DisplayName	Photo URL
FormatName	Url
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	photourl
MaxLength	200
RequiredLevel	None
Type	String

PositionId

Property	Value
Description	User's position in hierarchical security model.
DisplayName	Position
IsValidForForm	True
IsValidForRead	True
LogicalName	positionid
RequiredLevel	None
Targets	position
Type	Lookup

PreferredAddressCode

Property	Value
Description	Preferred address for the user.
DisplayName	Preferred Address
IsValidForForm	True
IsValidForRead	True
LogicalName	preferredaddresscode
RequiredLevel	None
Type	Picklist

PreferredAddressCode Choices/Options

Value	Label
1	Mailing Address
2	Other Address

PreferredEmailCode

Property	Value
Description	Preferred email address for the user.
DisplayName	Preferred Email
IsValidForForm	True
IsValidForRead	True
LogicalName	preferredemailcode
RequiredLevel	None
Type	Picklist

PreferredEmailCode Choices/Options

Value	Label
1	Default Value

PreferredPhoneCode

Property	Value
Description	Preferred phone number for the user.
DisplayName	Preferred Phone
IsValidForForm	True
IsValidForRead	True
LogicalName	preferredphonecode
RequiredLevel	None
Type	Picklist

PreferredPhoneCode Choices/Options

Value	Label
1	Main Phone
2	Other Phone
3	Home Phone
4	Mobile Phone
192350005	Omnichannel Phone

ProcessId

Property	Value
Description	Shows the ID of the process.
DisplayName	Process
IsValidForForm	False
IsValidForRead	True
LogicalName	processid
RequiredLevel	None
Type	Uniqueidentifier

QueueId

Property	Value
Description	Unique identifier of the default queue for the user.
DisplayName	Default Queue
IsValidForForm	False
IsValidForRead	True
LogicalName	queueid
RequiredLevel	None
Targets	queue
Type	Lookup

Salutation

Property	Value
Description	Salutation for correspondence with the user.
DisplayName	Salutation
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	salutation
MaxLength	20
RequiredLevel	None
Type	String

SetupUser

Property	Value
Description	Check if user is a setup user.
DisplayName	Restricted Access Mode
IsValidForForm	True
IsValidForRead	True
LogicalName	setupuser
RequiredLevel	SystemRequired
Type	Boolean

SetupUser Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

SharePointEmailAddress

Property	Value
Description	SharePoint Work Email Address
DisplayName	SharePoint Email Address
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	sharepointemailaddress
MaxLength	1024
RequiredLevel	None
Type	String

SiteId

Added by: Service Solution

Property	Value
Description	Site at which the user is located.
DisplayName	Site
IsValidForForm	True
IsValidForRead	True
LogicalName	siteid
RequiredLevel	None
Targets	site
Type	Lookup

Skills

Property	Value
Description	Skill set of the user.
DisplayName	Skills
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	skills
MaxLength	100
RequiredLevel	None
Type	String

StageId

Property	Value
Description	Shows the ID of the stage.
DisplayName	(Deprecated) Process Stage
IsValidForForm	False
IsValidForRead	True
LogicalName	stageid
RequiredLevel	None
Type	Uniqueidentifier

SystemUserId

Property	Value
Description	Unique identifier for the user.
DisplayName	User
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	systemuserid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

TerritoryId

Added by: Application Common Solution

Property	Value
Description	Unique identifier of the territory to which the user is assigned.
DisplayName	Territory
IsValidForForm	True
IsValidForRead	True
LogicalName	territoryid
RequiredLevel	None
Targets	territory
Type	Lookup

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleversionnumber
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

Title

Property	Value
Description	Title of the user.
DisplayName	Title
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	title
MaxLength	128
RequiredLevel	None
Type	String

TransactionCurrencyId

Property	Value
Description	Unique identifier of the currency associated with the systemuser.
DisplayName	Currency
IsValidForForm	True
IsValidForRead	True
LogicalName	transactioncurrencyid
RequiredLevel	None
Targets	transactioncurrency
Type	Lookup

TraversedPath

Property	Value
Description	For internal use only.
DisplayName	(Deprecated) Traversed Path
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	traversedpath
MaxLength	1250
RequiredLevel	None
Type	String

UserLicenseType

Property	Value
Description	Shows the type of user license.
DisplayName	User License Type
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	userlicensetype
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	SystemRequired
Type	Integer

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	utcconversiontimezonecode
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

WindowsLiveID

Property	Value
Description	Windows Live ID
DisplayName	Windows Live ID
FormatName	Email
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	windowsliveid
MaxLength	1024
RequiredLevel	None
Type	String

YammerEmailAddress

Property	Value
Description	User's Yammer login email address
DisplayName	Yammer Email
FormatName	Email
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yammeremailaddress
MaxLength	200
RequiredLevel	None
Type	String

YammerUserId

Property	Value
Description	User's Yammer ID
DisplayName	Yammer User ID
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yammeruserid
MaxLength	128
RequiredLevel	None
Type	String

YomiFirstName

Property	Value
Description	Pronunciation of the first name of the user, written in phonetic hiragana or katakana characters.
DisplayName	Yomi First Name
FormatName	PhoneticGuide
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yomifirstname
MaxLength	64
RequiredLevel	None
Type	String

YomiLastName

Property	Value
Description	Pronunciation of the last name of the user, written in phonetic hiragana or katakana characters.
DisplayName	Yomi Last Name
FormatName	PhoneticGuide
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yomilastname
MaxLength	64
RequiredLevel	None
Type	String

YomiMiddleName

Property	Value
Description	Pronunciation of the middle name of the user, written in phonetic hiragana or katakana characters.
DisplayName	Yomi Middle Name
FormatName	PhoneticGuide
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yomimiddlename
MaxLength	50
RequiredLevel	None
Type	String

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

• ActiveDirectoryGuid
• Address1_Composite
• Address2_Composite
• ApplicationIdUri
• AzureActiveDirectoryObjectId
• AzureDeletedOn
• BusinessUnitIdName
• CreatedBy
• CreatedByName
• CreatedByYomiName
• CreatedOn
• CreatedOnBehalfBy
• CreatedOnBehalfByName
• CreatedOnBehalfByYomiName
• DefaultFiltersPopulated
• DefaultMailbox
• DefaultMailboxName
• DefaultOdbFolderName
• DeletedState
• DisabledReason
• EntityImage_Timestamp
• EntityImage_URL
• EntityImageId
• ExchangeRate
• FullName
• IdentityId
• IsActiveDirectoryUser
• IsEmailAddressApprovedByO365Admin
• LatestUpdateTime
• ModifiedBy
• ModifiedByName
• ModifiedByYomiName
• ModifiedOn
• ModifiedOnBehalfBy
• ModifiedOnBehalfByName
• ModifiedOnBehalfByYomiName
• msdyn_DefaultPresenceIdUserName
• msdyn_phonenumberidName
• OrganizationId
• OrganizationIdName
• ParentSystemUserIdName
• ParentSystemUserIdYomiName
• PositionIdName
• QueueIdName
• SiteIdName
• TerritoryIdName
• TransactionCurrencyIdName
• UserPuid
• VersionNumber
• YomiFullName

ActiveDirectoryGuid

Property	Value
Description	Active Directory object GUID for the system user.
DisplayName	Active Directory Guid
IsValidForForm	False
IsValidForRead	False
LogicalName	activedirectoryguid
RequiredLevel	None
Type	Uniqueidentifier

Address1_Composite

Property	Value
Description	Shows the complete primary address.
DisplayName	Address
Format	TextArea
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_composite
MaxLength	1000
RequiredLevel	None
Type	Memo

Address2_Composite

Property	Value
Description	Shows the complete secondary address.
DisplayName	Other Address
Format	TextArea
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_composite
MaxLength	1000
RequiredLevel	None
Type	Memo

ApplicationIdUri

Property	Value
Description	The URI used as a unique logical identifier for the external app. This can be used to validate the application.
DisplayName	Application ID URI
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	applicationiduri
MaxLength	1024
RequiredLevel	None
Type	String

AzureActiveDirectoryObjectId

Property	Value
Description	This is the application directory object Id.
DisplayName	Azure AD Object ID
IsValidForForm	True
IsValidForRead	True
LogicalName	azureactivedirectoryobjectid
RequiredLevel	None
Type	Uniqueidentifier

AzureDeletedOn

Added by: AuthorizationCore Solution

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the user was set as soft deleted in Azure.
DisplayName	Azure Deleted On
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	azuredeletedon
RequiredLevel	None
Type	DateTime

BusinessUnitIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	businessunitidname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

CreatedBy

Property	Value
Description	Unique identifier of the user who created the user.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyyominame
MaxLength	100
RequiredLevel	None
Type	String

CreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the user was created.
DisplayName	Created On
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the systemuser.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedOnBehalfByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedOnBehalfByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

DefaultFiltersPopulated

Property	Value
Description	Indicates if default outlook filters have been populated.
DisplayName	Default Filters Populated
IsValidForForm	False
IsValidForRead	True
LogicalName	defaultfilterspopulated
RequiredLevel	SystemRequired
Type	Boolean

DefaultFiltersPopulated Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

DefaultMailbox

Property	Value
Description	Select the mailbox associated with this user.
DisplayName	Mailbox
IsValidForForm	True
IsValidForRead	True
LogicalName	defaultmailbox
RequiredLevel	None
Targets	mailbox
Type	Lookup

DefaultMailboxName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	defaultmailboxname
MaxLength	100
RequiredLevel	None
Type	String

DefaultOdbFolderName

Property	Value
Description	Type a default folder name for the user's OneDrive For Business location.
DisplayName	Default OneDrive for Business Folder Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	defaultodbfoldername
MaxLength	200
RequiredLevel	SystemRequired
Type	String

DeletedState

Added by: AuthorizationCore Solution

Property	Value
Description	User delete state
DisplayName	Deleted State
IsValidForForm	True
IsValidForRead	True
LogicalName	deletedstate
RequiredLevel	SystemRequired
Type	Picklist

DeletedState Choices/Options

Value	Label
0	Not deleted
1	Soft deleted

DisabledReason

Property	Value
Description	Reason for disabling the user.
DisplayName	Disabled Reason
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	disabledreason
MaxLength	500
RequiredLevel	None
Type	String

EntityImage_Timestamp

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	entityimage_timestamp
MaxValue	9223372036854775807
MinValue	-9223372036854775808
RequiredLevel	None
Type	BigInt

EntityImage_URL

Property	Value
Description
DisplayName
FormatName	Url
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	entityimage_url
MaxLength	200
RequiredLevel	None
Type	String

EntityImageId

Property	Value
Description	For internal use only.
DisplayName	Entity Image Id
IsValidForForm	False
IsValidForRead	True
LogicalName	entityimageid
RequiredLevel	None
Type	Uniqueidentifier

ExchangeRate

Property	Value
Description	Exchange rate for the currency associated with the systemuser with respect to the base currency.
DisplayName	Exchange Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	exchangerate
MaxValue	100000000000
MinValue	0.000000000001
Precision	12
RequiredLevel	None
Type	Decimal

FullName

Property	Value
Description	Full name of the user.
DisplayName	Full Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	fullname
MaxLength	200
RequiredLevel	None
Type	String

IdentityId

Property	Value
Description	For internal use only.
DisplayName	Unique user identity id
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	identityid
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	SystemRequired
Type	Integer

IsActiveDirectoryUser

Property	Value
Description	Information about whether the user is an AD user.
DisplayName	Is Active Directory User
IsValidForForm	False
IsValidForRead	False
LogicalName	isactivedirectoryuser
RequiredLevel	SystemRequired
Type	Boolean

IsActiveDirectoryUser Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: True

IsEmailAddressApprovedByO365Admin

Property	Value
Description	Shows the status of approval of the email address by O365 Admin.
DisplayName	Email Address O365 Admin Approval Status
IsValidForForm	False
IsValidForRead	True
LogicalName	isemailaddressapprovedbyo365admin
RequiredLevel	SystemRequired
Type	Boolean

IsEmailAddressApprovedByO365Admin Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

LatestUpdateTime

Property	Value
DateTimeBehavior	UserLocal
Description	Time stamp of the latest update for the user
DisplayName	Latest User Update Time
Format	DateAndTime
IsValidForForm	False
IsValidForRead	False
LogicalName	latestupdatetime
RequiredLevel	None
Type	DateTime

ModifiedBy

Property	Value
Description	Unique identifier of the user who last modified the user.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyyominame
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the user was last modified.
DisplayName	Modified On
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who last modified the systemuser.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedOnBehalfByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOnBehalfByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

msdyn_DefaultPresenceIdUserName

Added by: Omnichannel – Base Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	msdyn_defaultpresenceidusername
MaxLength	100
RequiredLevel	None
Type	String

msdyn_phonenumberidName

Added by: Omnichannel - CommunicationBase Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	msdyn_phonenumberidname
MaxLength	100
RequiredLevel	None
Type	String

OrganizationId

Property	Value
Description	Unique identifier of the organization associated with the user.
DisplayName	Organization
IsValidForForm	True
IsValidForRead	True
LogicalName	organizationid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

OrganizationIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	organizationidname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

ParentSystemUserIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	parentsystemuseridname
MaxLength	100
RequiredLevel	None
Type	String

ParentSystemUserIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	parentsystemuseridyominame
MaxLength	100
RequiredLevel	None
Type	String

PositionIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	positionidname
MaxLength	100
RequiredLevel	None
Type	String

QueueIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	queueidname
MaxLength	400
RequiredLevel	None
Type	String

SiteIdName

Added by: Service Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	siteidname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

TerritoryIdName

Added by: Application Common Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	territoryidname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

TransactionCurrencyIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	transactioncurrencyidname
MaxLength	100
RequiredLevel	None
Type	String

UserPuid

Property	Value
Description	User PUID User Identifiable Information
DisplayName	User PUID
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	userpuid
MaxLength	100
RequiredLevel	None
Type	String

VersionNumber

Property	Value
Description	Version number of the user.
DisplayName	Version number
IsValidForForm	False
IsValidForRead	True
LogicalName	versionnumber
MaxValue	9223372036854775807
MinValue	-9223372036854775808
RequiredLevel	None
Type	BigInt

YomiFullName

Property	Value
Description	Pronunciation of the full name of the user, written in phonetic hiragana or katakana characters.
DisplayName	Yomi Full Name
FormatName	PhoneticGuide
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yomifullname
MaxLength	200
RequiredLevel	None
Type	String

One-To-Many Relationships

Listed by SchemaName.

• lk_systemuserbase_modifiedby
• lk_systemuser_createdonbehalfby
• user_parent_user
• lk_systemuser_modifiedonbehalfby
• lk_systemuserbase_createdby

lk_systemuserbase_modifiedby

Same as systemuser table lk_systemuserbase_modifiedby Many-To-One relationship.

Property	Value
ReferencingEntity	systemuser
ReferencingAttribute	modifiedby
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	lk_systemuserbase_modifiedby
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

lk_systemuser_createdonbehalfby

Same as systemuser table lk_systemuser_createdonbehalfby Many-To-One relationship.

Property	Value
ReferencingEntity	systemuser
ReferencingAttribute	createdonbehalfby
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	lk_systemuser_createdonbehalfby
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

user_parent_user

Same as systemuser table user_parent_user Many-To-One relationship.

Property	Value
ReferencingEntity	systemuser
ReferencingAttribute	parentsystemuserid
IsHierarchical	True
IsCustomizable	True
ReferencedEntityNavigationPropertyName	user_parent_user
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

lk_systemuser_modifiedonbehalfby

Same as systemuser table lk_systemuser_modifiedonbehalfby Many-To-One relationship.

Property	Value
ReferencingEntity	systemuser
ReferencingAttribute	modifiedonbehalfby
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	lk_systemuser_modifiedonbehalfby
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

lk_systemuserbase_createdby

Same as systemuser table lk_systemuserbase_createdby Many-To-One relationship.

Property	Value
ReferencingEntity	systemuser
ReferencingAttribute	createdby
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	lk_systemuserbase_createdby
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

• user_parent_user
• lk_systemuserbase_modifiedby
• lk_systemuser_modifiedonbehalfby
• lk_systemuserbase_createdby
• lk_systemuser_createdonbehalfby

user_parent_user

See systemuser Table user_parent_user One-To-Many relationship.

lk_systemuserbase_modifiedby

See systemuser Table lk_systemuserbase_modifiedby One-To-Many relationship.

lk_systemuser_modifiedonbehalfby

See systemuser Table lk_systemuser_modifiedonbehalfby One-To-Many relationship.

lk_systemuserbase_createdby

See systemuser Table lk_systemuserbase_createdby One-To-Many relationship.

lk_systemuser_createdonbehalfby

See systemuser Table lk_systemuser_createdonbehalfby One-To-Many relationship.

See also

Web API Reference
systemuser EntityType