User Settings (UserSettings) table/entity reference

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
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
• AdvancedFindStartupMode
• AMDesignator
• AutoCaptureUserStatus
• AutoCreateContactOnPromote
• BusinessUnitId
• CalendarType
• CurrencyDecimalPrecision
• CurrencyFormatCode
• CurrencySymbol
• D365AutoInstallAttemptStatus
• DataValidationModeForExportToExcel
• DateFormatCode
• DateFormatString
• DateSeparator
• DecimalSymbol
• DefaultCalendarView
• DefaultCountryCode
• DefaultDashboardId
• DefaultSearchExperience
• EntityFormMode
• FullNameConventionCode
• GetStartedPaneContentEnabled
• HelpLanguageId
• HomepageArea
• HomepageLayout
• HomepageSubarea
• IgnoreUnsolicitedEmail
• IncomingEmailFilteringMethod
• IsAppsForCrmAlertDismissed
• IsAutoDataCaptureEnabled
• IsDefaultCountryCodeCheckEnabled
• IsDuplicateDetectionEnabledWhenGoingOnline
• IsEmailConversationViewEnabled
• IsGuidedHelpEnabled
• IsResourceBookingExchangeSyncEnabled
• IsSendAsAllowed
• LastAlertsViewedTime
• LastModifiedTimeForViewPersonalizationSettings
• LocaleId
• LongDateFormatCode
• NegativeCurrencyFormatCode
• NegativeFormatCode
• NextTrackingNumber
• NumberGroupFormat
• NumberSeparator
• OfflineSyncInterval
• OutlookSyncInterval
• PagingLimit
• PersonalizationSettings
• PMDesignator
• PreferredSolution
• PricingDecimalPrecision
• ReleaseChannel
• ReportScriptErrors
• ResourceBookingExchangeSyncVersion
• SelectedGlobalFilterId
• ShowWeekNumber
• SplitViewState
• SyncContactCompany
• SystemUserId
• TableScopedDVSearchFeatureTeachingBubbleViews
• TableScopedDVSearchQuickFindTeachingBubbleViews
• TimeFormatCode
• TimeFormatString
• TimeSeparator
• TimeZoneBias
• TimeZoneCode
• TimeZoneDaylightBias
• TimeZoneDaylightDay
• TimeZoneDaylightDayOfWeek
• TimeZoneDaylightHour
• TimeZoneDaylightMinute
• TimeZoneDaylightMonth
• TimeZoneDaylightSecond
• TimeZoneDaylightYear
• TimeZoneStandardBias
• TimeZoneStandardDay
• TimeZoneStandardDayOfWeek
• TimeZoneStandardHour
• TimeZoneStandardMinute
• TimeZoneStandardMonth
• TimeZoneStandardSecond
• TimeZoneStandardYear
• TrackingTokenId
• TransactionCurrencyId
• TryToggleSets
• TryToggleStatus
• UILanguageId
• UseCrmFormForAppointment
• UseCrmFormForContact
• UseCrmFormForEmail
• UseCrmFormForTask
• UseImageStrips
• UserProfile
• VisualizationPaneLayout
• WorkdayStartTime
• WorkdayStopTime

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
• BusinessUnitIdName
• CreatedBy
• CreatedOn
• CreatedOnBehalfBy
• EmailPassword
• EmailUsername
• ModifiedBy
• ModifiedOn
• ModifiedOnBehalfBy
• VersionNumber

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
• lk_usersettings_createdonbehalfby
• lk_usersettings_modifiedonbehalfby
• lk_usersettingsbase_createdby
• lk_usersettingsbase_modifiedby
• transactioncurrency_usersettings
• user_settings
• user_settings_preferred_solution

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