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

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

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

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

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.

Web API Reference
systemuser EntityType