Edit

Share via

User Settings (UserSettings) table/entity reference (Microsoft Dataverse)

User's preferred settings.

Messages

The following table lists the messages for the User Settings (UserSettings) table. Messages represent operations that can be performed on the table. They may also be events.

Name
Is Event?		 Web API Operation SDK for .NET
Associate
Event: True		 Associate records Associate records
Disassociate
Event: True		 Disassociate records Disassociate records
Retrieve
Event: False		 GET /usersettingscollection(systemuserid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: True		 GET /usersettingscollection
See Query data		 Query data
Update
Event: True		 PATCH /usersettingscollection(systemuserid)
See Update		 Update records

Properties

The following table lists selected properties for the User Settings (UserSettings) table.

Property Value
DisplayName User Settings
DisplayCollectionName User Settings
SchemaName UserSettings
CollectionSchemaName UserSettingses
EntitySetName usersettingscollection
LogicalName usersettings
LogicalCollectionName usersettingses
PrimaryIdAttribute systemuserid
TableType Standard
OwnershipType BusinessOwned

Writable columns/attributes

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

AddressBookSyncInterval

Property Value
Description Normal polling frequency used for address book synchronization in Microsoft Office Outlook.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName addressbooksyncinterval
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

AdvancedFindStartupMode

Property Value
Description Default mode, such as simple or detailed, for advanced find.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName advancedfindstartupmode
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

AMDesignator

Property Value
Description AM designator to use in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName amdesignator
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 25

AutoCaptureUserStatus

Property Value
Description Set user status for ADC Suggestions
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName autocaptureuserstatus
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

AutoCreateContactOnPromote

Property Value
Description Auto-create contact on client promote
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName autocreatecontactonpromote
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

BusinessUnitId

Property Value
Description Unique identifier of the business unit with which the user is associated.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName businessunitid
RequiredLevel SystemRequired
Type Uniqueidentifier

CalendarType

Property Value
Description Calendar type for the system. Set to Gregorian US by default.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName calendartype
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

CurrencyDecimalPrecision

Property Value
Description Number of decimal places that can be used for currency.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName currencydecimalprecision
RequiredLevel ApplicationRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

CurrencyFormatCode

Property Value
Description Information about how currency symbols are placed in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName currencyformatcode
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

CurrencySymbol

Property Value
Description Symbol used for currency in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName currencysymbol
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 13

D365AutoInstallAttemptStatus

Property Value
Description Determines the status of auto install of Dynamics 365 to Teams attempt has been completed
DisplayName d365autoinstallattemptstatus
IsValidForForm True
IsValidForRead True
LogicalName d365autoinstallattemptstatus
RequiredLevel None
Type Picklist
DefaultFormValue 0
GlobalChoiceName usersettings_d365autoinstallattemptstatus

D365AutoInstallAttemptStatus Choices/Options

Value Label
0 Not attempted
1 Auto installed
2 Already installed
3 Teams admin blocked
4 Unauthorized
5 No Solution
6 No Graph API
7 Resource Disabled

DataValidationModeForExportToExcel

Property Value
Description Information that specifies the level of data validation in excel worksheets exported in a format suitable for import.
DisplayName Data Validation Mode For Export To Excel
IsValidForForm True
IsValidForRead True
LogicalName datavalidationmodeforexporttoexcel
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue 0
GlobalChoiceName usersettings_datavalidationmodeforexporttoexcel

DataValidationModeForExportToExcel Choices/Options

Value Label
0 Full
1 None

DateFormatCode

Property Value
Description Information about how the date is displayed in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName dateformatcode
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

DateFormatString

Property Value
Description String showing how the date is displayed throughout Microsoft 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName dateformatstring
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 255

DateSeparator

Property Value
Description Character used to separate the month, the day, and the year in dates in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName dateseparator
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 5

DecimalSymbol

Property Value
Description Symbol used for decimal in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName decimalsymbol
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 5

DefaultCalendarView

Property Value
Description Default calendar view for the user.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName defaultcalendarview
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

DefaultCountryCode

Property Value
Description Text area to enter default country code.
DisplayName Default Country Code
IsValidForForm False
IsValidForRead True
LogicalName defaultcountrycode
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 30

DefaultDashboardId

Property Value
Description Unique identifier of the default dashboard.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName defaultdashboardid
RequiredLevel None
Type Uniqueidentifier

DefaultSearchExperience

Property Value
Description Default search experience for the user.
DisplayName Default Search Experience
IsValidForForm True
IsValidForRead True
LogicalName defaultsearchexperience
RequiredLevel None
Type Picklist
DefaultFormValue 2
GlobalChoiceName usersettings_defaultsearchexperience

DefaultSearchExperience Choices/Options

Value Label
0 Relevance search
1 Categorized search
2 Use last search
3 Custom search

EntityFormMode

Property Value
Description Indicates the form mode to be used.
DisplayName Form Mode
IsValidForForm False
IsValidForRead True
LogicalName entityformmode
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue 0
GlobalChoiceName usersettings_entityformmode

EntityFormMode Choices/Options

Value Label
0 Organization default
1 Read-optimized
2 Edit

FullNameConventionCode

Property Value
Description Order in which names are to be displayed in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName fullnameconventioncode
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

GetStartedPaneContentEnabled

Property Value
Description Information that specifies whether the Get Started pane in lists is enabled.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName getstartedpanecontentenabled
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_getstartedpanecontentenabled
DefaultValue True
True Label Yes
False Label No

HelpLanguageId

Property Value
Description Unique identifier of the Help language.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName helplanguageid
RequiredLevel ApplicationRequired
Type Integer
MaxValue 2147483647
MinValue 0

HomepageArea

Property Value
Description Web site home page for the user.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName homepagearea
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 200

HomepageLayout

Property Value
Description Configuration of the home page layout.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName homepagelayout
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 2000

HomepageSubarea

Property Value
Description Web site page for the user.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName homepagesubarea
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 200

IgnoreUnsolicitedEmail

Property Value
Description Information that specifies whether a user account is to ignore unsolicited email (deprecated).
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName ignoreunsolicitedemail
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_ignoreunsolicitedemail
DefaultValue True
True Label Yes
False Label No

IncomingEmailFilteringMethod

Property Value
Description Incoming email filtering method.
DisplayName Incoming Email Filtering Method
IsValidForForm True
IsValidForRead True
LogicalName incomingemailfilteringmethod
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue 2
GlobalChoiceName usersettings_incomingemailfilteringmethod

IncomingEmailFilteringMethod Choices/Options

Value Label
0 All email messages
1 Email messages in response to Dynamics 365 email
2 Email messages from Dynamics 365 Leads, Contacts and Accounts
3 Email messages from Dynamics 365 records that are email enabled
4 No email messages

IsAppsForCrmAlertDismissed

Property Value
Description Show or dismiss alert for Apps for 365.
DisplayName Show alert for Apps for 365.
IsValidForForm False
IsValidForRead True
LogicalName isappsforcrmalertdismissed
RequiredLevel None
Type Boolean
GlobalChoiceName usersettings_isappsforcrmalertdismissed
DefaultValue False
True Label Yes
False Label No

IsAutoDataCaptureEnabled

Property Value
Description Indicates whether to use the Auto Capture feature enabled or not.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName isautodatacaptureenabled
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_featureenabled
DefaultValue False
True Label Yes
False Label No

IsDefaultCountryCodeCheckEnabled

Property Value
Description Enable or disable country code selection .
DisplayName Enable Default Country Code
IsValidForForm False
IsValidForRead True
LogicalName isdefaultcountrycodecheckenabled
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName user_iscountrycodeselectionenabled
DefaultValue True
True Label Yes
False Label No

IsDuplicateDetectionEnabledWhenGoingOnline

Property Value
Description Indicates if duplicate detection is enabled when going online.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName isduplicatedetectionenabledwhengoingonline
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_isduplicatedetectionenabledwhengoingonline
DefaultValue False
True Label Yes
False Label No

IsEmailConversationViewEnabled

Property Value
Description Enable or disable email conversation view on timeline wall selection.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName isemailconversationviewenabled
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_isemailconversationviewenabled
DefaultValue False
True Label Yes
False Label No

IsGuidedHelpEnabled

Property Value
Description Enable or disable guided help.
DisplayName Enable Default Guided Help
IsValidForForm False
IsValidForRead True
LogicalName isguidedhelpenabled
RequiredLevel None
Type Boolean
GlobalChoiceName usersettings_isguidedhelpenabled
DefaultValue True
True Label Yes
False Label No

IsResourceBookingExchangeSyncEnabled

Property Value
Description Indicates if the synchronization of user resource booking with Exchange is enabled at user level.
DisplayName Resource booking synchronization enabled
IsValidForForm False
IsValidForRead True
LogicalName isresourcebookingexchangesyncenabled
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_isresourcebookingexchangesyncenabled
DefaultValue False
True Label Enabled
False Label Disabled

IsSendAsAllowed

Property Value
Description Indicates if send as other user privilege is enabled or not.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName issendasallowed
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_issendasallowed
DefaultValue False
True Label Yes
False Label No

LastAlertsViewedTime

Property Value
Description Shows the last time when the traces were read from the database.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName lastalertsviewedtime
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

LastModifiedTimeForViewPersonalizationSettings

Property Value
Description Stores the timestamp for when the ViewPersonalizationSettings attribute was updated for this user in the UserEntityUISettings table.
DisplayName Last modified timestamp for the view personalization settings in UserEntityUISettings table
IsValidForForm False
IsValidForRead True
LogicalName lastmodifiedtimeforviewpersonalizationsettings
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Auto
SourceTypeMask 0

LocaleId

Property Value
Description Unique identifier of the user locale.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName localeid
RequiredLevel ApplicationRequired
Type Integer
MaxValue 2147483647
MinValue 0

LongDateFormatCode

Property Value
Description Information that specifies how Long Date is displayed throughout Microsoft 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName longdateformatcode
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

NegativeCurrencyFormatCode

Property Value
Description Information that specifies how negative currency numbers are displayed in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName negativecurrencyformatcode
RequiredLevel SystemRequired
Type Integer
MaxValue 15
MinValue 0

NegativeFormatCode

Property Value
Description Information that specifies how negative numbers are displayed in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName negativeformatcode
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

NextTrackingNumber

Property Value
Description Next tracking number.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName nexttrackingnumber
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

NumberGroupFormat

Property Value
Description Information that specifies how numbers are grouped in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName numbergroupformat
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 25

NumberSeparator

Property Value
Description Symbol used for number separation in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName numberseparator
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 5

OfflineSyncInterval

Property Value
Description Normal polling frequency used for background offline synchronization in Microsoft Office Outlook.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName offlinesyncinterval
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

OutlookSyncInterval

Property Value
Description Normal polling frequency used for record synchronization in Microsoft Office Outlook.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName outlooksyncinterval
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

PagingLimit

Property Value
Description Information that specifies how many items to list on a page in list views.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName paginglimit
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue 0

PersonalizationSettings

Property Value
Description For internal use only.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName personalizationsettings
RequiredLevel None
Type Memo
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 1073741823

PMDesignator

Property Value
Description PM designator to use in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName pmdesignator
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 25

PreferredSolution

Property Value
Description Preferred Solution when create a component without under a solution in this organization
DisplayName Preferred Solution
IsValidForForm True
IsValidForRead True
LogicalName preferredsolution
RequiredLevel None
Type Lookup
Targets solution

PricingDecimalPrecision

Property Value
Description Number of decimal places that can be used for prices.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName pricingdecimalprecision
RequiredLevel ApplicationRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

ReleaseChannel

Property Value
Description Model app channel override
DisplayName Model app channel override
IsValidForForm True
IsValidForRead True
LogicalName releasechannel
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue 0
GlobalChoiceName usersettings_releasechannel

ReleaseChannel Choices/Options

Value Label
0 None
1 Semi-annual channel override
2 Monthly channel override
3 Inner channel override

ReportScriptErrors

Property Value
Description Picklist for selecting the user preference for reporting scripting errors.
DisplayName Report Script Errors
IsValidForForm True
IsValidForRead True
LogicalName reportscripterrors
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue -1
GlobalChoiceName usersettings_reportscripterrors

ReportScriptErrors Choices/Options

Value Label
1 Ask me for permission to send an error report to Microsoft
2 Automatically send an error report to Microsoft without asking me for permission
3 Never send an error report to Microsoft about Microsoft Dynamics 365

ResourceBookingExchangeSyncVersion

Property Value
Description The version number for resource booking synchronization with Exchange.
DisplayName User resource booking synchronization version
IsValidForForm False
IsValidForRead True
LogicalName resourcebookingexchangesyncversion
RequiredLevel SystemRequired
Type BigInt
MaxValue 9223372036854775807
MinValue -9223372036854775808

SelectedGlobalFilterId

Property Value
Description Store selected customer service hub dashboard saved filter id.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName selectedglobalfilterid
RequiredLevel None
Type Uniqueidentifier

ShowWeekNumber

Property Value
Description Information that specifies whether to display the week number in calendar displays in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName showweeknumber
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_showweeknumber
DefaultValue False
True Label Yes
False Label No

SplitViewState

Property Value
Description For Internal use only
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName splitviewstate
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_splitviewstate
DefaultValue False
True Label Expanded
False Label Collapsed

SyncContactCompany

Property Value
Description Indicates if the company field in Microsoft Office Outlook items are set during Outlook synchronization.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName synccontactcompany
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_synccontactcompany
DefaultValue False
True Label Yes
False Label No

SystemUserId

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

TableScopedDVSearchFeatureTeachingBubbleViews

Property Value
Description The number of times a user has interacted with the Tabled Scoped Dataverse Search feature teaching bubble.
DisplayName Table Scoped Dataverse Search Feature Teaching Bubble Views
IsValidForForm False
IsValidForRead True
LogicalName tablescopeddvsearchfeatureteachingbubbleviews
RequiredLevel SystemRequired
Type Integer
MaxValue 100
MinValue 0

TableScopedDVSearchQuickFindTeachingBubbleViews

Property Value
Description The number of times a user has interacted with the Tabled Scoped Dataverse Search Quick Find teaching bubble.
DisplayName Table Scoped Dataverse Search Quick Find Teaching Bubble Views
IsValidForForm False
IsValidForRead True
LogicalName tablescopeddvsearchquickfindteachingbubbleviews
RequiredLevel SystemRequired
Type Integer
MaxValue 100
MinValue 0

TimeFormatCode

Property Value
Description Information that specifies how the time is displayed in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timeformatcode
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

TimeFormatString

Property Value
Description Text for how time is displayed in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timeformatstring
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 255

TimeSeparator

Property Value
Description Text for how time is displayed in Microsoft Dynamics 365.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timeseparator
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 5

TimeZoneBias

Property Value
Description Local time zone adjustment for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonebias
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

TimeZoneCode

Property Value
Description Local time zone for the user.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonecode
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneDaylightBias

Property Value
Description Local time zone daylight adjustment for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonedaylightbias
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

TimeZoneDaylightDay

Property Value
Description Local time zone daylight day for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonedaylightday
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneDaylightDayOfWeek

Property Value
Description Local time zone daylight day of week for the user. System calculated based on the time zone selected in Options.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonedaylightdayofweek
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneDaylightHour

Property Value
Description Local time zone daylight hour for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonedaylighthour
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneDaylightMinute

Property Value
Description Local time zone daylight minute for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonedaylightminute
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneDaylightMonth

Property Value
Description Local time zone daylight month for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonedaylightmonth
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneDaylightSecond

Property Value
Description Local time zone daylight second for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonedaylightsecond
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneDaylightYear

Property Value
Description Local time zone daylight year for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonedaylightyear
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneStandardBias

Property Value
Description Local time zone standard time bias for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonestandardbias
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue -2147483648

TimeZoneStandardDay

Property Value
Description Local time zone standard day for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonestandardday
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneStandardDayOfWeek

Property Value
Description Local time zone standard day of week for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonestandarddayofweek
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneStandardHour

Property Value
Description Local time zone standard hour for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonestandardhour
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneStandardMinute

Property Value
Description Local time zone standard minute for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonestandardminute
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneStandardMonth

Property Value
Description Local time zone standard month for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonestandardmonth
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneStandardSecond

Property Value
Description Local time zone standard second for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonestandardsecond
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TimeZoneStandardYear

Property Value
Description Local time zone standard year for the user. System calculated based on the time zone selected.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName timezonestandardyear
RequiredLevel SystemRequired
Type Integer
MaxValue
MinValue

TrackingTokenId

Property Value
Description Tracking token ID.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName trackingtokenid
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

TransactionCurrencyId

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

TryToggleSets

Property Value
Description The list of app modules with try toggle sets
DisplayName TryToggleSets
IsValidForForm False
IsValidForRead True
LogicalName trytogglesets
RequiredLevel None
Type Memo
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 1073741823

TryToggleStatus

Property Value
Description Enable or disable try toggle status.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName trytogglestatus
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_trytogglestatus
DefaultValue False
True Label Yes
False Label No

UILanguageId

Property Value
Description Unique identifier of the language in which to view the user interface (UI).
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName uilanguageid
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue 0

UseCrmFormForAppointment

Property Value
Description Indicates whether to use the Microsoft Dynamics 365 appointment form within Microsoft Office Outlook for creating new appointments.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName usecrmformforappointment
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_usecrmformforappointment
DefaultValue False
True Label Yes
False Label No

UseCrmFormForContact

Property Value
Description Indicates whether to use the Microsoft Dynamics 365 contact form within Microsoft Office Outlook for creating new contacts.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName usecrmformforcontact
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_usecrmformforcontact
DefaultValue False
True Label Yes
False Label No

UseCrmFormForEmail

Property Value
Description Indicates whether to use the Microsoft Dynamics 365 email form within Microsoft Office Outlook for creating new emails.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName usecrmformforemail
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_usecrmformforemail
DefaultValue False
True Label Yes
False Label No

UseCrmFormForTask

Property Value
Description Indicates whether to use the Microsoft Dynamics 365 task form within Microsoft Office Outlook for creating new tasks.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName usecrmformfortask
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_usecrmformfortask
DefaultValue False
True Label Yes
False Label No

UseImageStrips

Property Value
Description Indicates whether image strips are used to render images.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName useimagestrips
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_useimagestrips
DefaultValue True
True Label Yes
False Label No

UserProfile

Property Value
Description Specifies user profile ids in comma separated list.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName userprofile
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 1024

VisualizationPaneLayout

Property Value
Description The layout of the visualization pane.
DisplayName Visualization Pane Layout.
IsValidForForm True
IsValidForRead True
LogicalName visualizationpanelayout
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue 1
GlobalChoiceName usersettings_visualizationpanelayout

VisualizationPaneLayout Choices/Options

Value Label
0 Top-bottom
1 Side-by-side

WorkdayStartTime

Property Value
Description Workday start time for the user.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName workdaystarttime
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 5

WorkdayStopTime

Property Value
Description Workday stop time for the user.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName workdaystoptime
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 5

Read-only columns/attributes

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

AllowEmailCredentials

Property Value
Description This attribute is no longer used. The data is now in the Mailbox.AllowEmailConnectorToUseCredentials attribute.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName allowemailcredentials
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName usersettings_allowemailcredentials
DefaultValue False
True Label Yes
False Label No

BusinessUnitIdName

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

CreatedBy

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

CreatedOn

Property Value
Description Date and time when the user settings object was created.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

CreatedOnBehalfBy

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

EmailPassword

Property Value
Description This attribute is no longer used. The data is now in the Mailbox.Password attribute.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName emailpassword
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 200

EmailUsername

Property Value
Description This attribute is no longer used. The data is now in the Mailbox.UserName attribute.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName emailusername
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 200

ModifiedBy

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

ModifiedOn

Property Value
Description Date and time when the user settings object was last modified.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ModifiedOnBehalfBy

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

VersionNumber

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

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

business_unit_user_settings

One-To-Many Relationship: businessunit business_unit_user_settings

Property Value
ReferencedEntity businessunit
ReferencedAttribute businessunitid
ReferencingAttribute businessunitid
ReferencingEntityNavigationPropertyName businessunitid_businessunit
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_usersettings_createdonbehalfby

One-To-Many Relationship: systemuser lk_usersettings_createdonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdonbehalfby
ReferencingEntityNavigationPropertyName createdonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_usersettings_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_usersettings_modifiedonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedonbehalfby
ReferencingEntityNavigationPropertyName modifiedonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_usersettingsbase_createdby

One-To-Many Relationship: systemuser lk_usersettingsbase_createdby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdby
ReferencingEntityNavigationPropertyName createdby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_usersettingsbase_modifiedby

One-To-Many Relationship: systemuser lk_usersettingsbase_modifiedby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedby
ReferencingEntityNavigationPropertyName modifiedby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

transactioncurrency_usersettings

One-To-Many Relationship: transactioncurrency transactioncurrency_usersettings

Property Value
ReferencedEntity transactioncurrency
ReferencedAttribute transactioncurrencyid
ReferencingAttribute transactioncurrencyid
ReferencingEntityNavigationPropertyName transactioncurrencyid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

user_settings

One-To-Many Relationship: systemuser user_settings

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute systemuserid
ReferencingEntityNavigationPropertyName systemuserid_systemuser
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

user_settings_preferred_solution

One-To-Many Relationship: solution user_settings_preferred_solution

Property Value
ReferencedEntity solution
ReferencedAttribute solutionid
ReferencingAttribute preferredsolution
ReferencingEntityNavigationPropertyName preferredsolution
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

See also

Dataverse table/entity reference
Dataverse Web API Reference
usersettings