UserSettings
This is a table representing the UserSettings entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the user settings object. |
| AddressBookSyncInterval | Integer | False |
Normal polling frequency used for address book synchronization in Microsoft Office Outlook. |
| AdvancedFindStartupMode | Integer | False |
Default mode, such as simple or detailed, for advanced find. |
| AllowEmailCredentials | Boolean | False |
Indicates whether a user wants to specify email credentials. |
| AMDesignator | String | False |
AM designator to use in Microsoft Dynamics CRM. |
| AutoCreateContactOnPromote | Integer | False |
Auto-create contact on client promote |
| BusinessUnitId | String | False |
Unique identifier of the business unit with which the user is associated. |
| CalendarType | Integer | False |
Calendar type for the system. Set to Gregorian US by default. |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the user settings. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the user settings object was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the usersettings. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| CurrencyDecimalPrecision | Integer | False |
Number of decimal places that can be used for currency. |
| CurrencyFormatCode | Integer | False |
Information about how currency symbols are placed in Microsoft Dynamics CRM. |
| CurrencySymbol | String | False |
Symbol used for currency in Microsoft Dynamics CRM. |
| DataValidationModeForExportToExcel | String | False |
Information that specifies the level of data validation in excel worksheets exported in a format suitable for import. |
| DateFormatCode | Integer | False |
Information about how the date is displayed in Microsoft Dynamics CRM. |
| DateFormatString | String | False |
String showing how the date is displayed throughout Microsoft CRM. |
| DateSeparator | String | False |
Character used to separate the month, the day, and the year in dates in Microsoft Dynamics CRM. |
| DecimalSymbol | String | False |
Symbol used for decimal in Microsoft Dynamics CRM. |
| DefaultCalendarView | Integer | False |
Default calendar view for the user. |
| DefaultDashboardId | String | False |
Unique identifier of the default dashboard. |
| EmailPassword | String | False |
email password. |
| EmailUsername | String | False |
email user name. |
| FullNameConventionCode | Integer | False |
Order in which names are to be displayed in Microsoft Dynamics CRM. |
| GetStartedPaneContentEnabled | Boolean | False |
Information that specifies whether the Get Started pane in lists is enabled. |
| HelpLanguageId | Integer | False |
Unique identifier of the Help language. |
| HomepageArea | String | False |
Web site home page for the user. |
| HomepageLayout | String | False |
Configuration of the home page layout. |
| HomepageSubarea | String | False |
Web site page for the user. |
| IgnoreUnsolicitedEmail | Boolean | False |
Information that specifies whether a user account is to ignore unsolicited email (deprecated). |
| IncomingEmailFilteringMethod | String | False |
Incoming email filtering method. |
| IsDuplicateDetectionEnabledWhenGoingOnline | Boolean | False |
Indicates if duplicate detection is enabled when going online. |
| IsSendAsAllowed | Boolean | False |
Indicates if send as other user privilege is enabled or not. |
| LocaleId | Integer | False |
Unique identifier of the user locale. |
| LongDateFormatCode | Integer | False |
Information that specifies how Long Date is displayed throughout Microsoft CRM. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the user settings. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the user settings object was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the usersettings. |
| ModifiedOnBehalfBy_LogicalName | String | True | |
| ModifiedOnBehalfBy_Name | String | True | |
| NegativeCurrencyFormatCode | Integer | False |
Information that specifies how negative currency numbers are displayed in Microsoft Dynamics CRM. |
| NegativeFormatCode | Integer | False |
Information that specifies how negative numbers are displayed in Microsoft Dynamics CRM. |
| NextTrackingNumber | Integer | False |
Next tracking number. |
| NumberGroupFormat | String | False |
Information that specifies how numbers are grouped in Microsoft Dynamics CRM. |
| NumberSeparator | String | False |
Symbol used for number separation in Microsoft Dynamics CRM. |
| OfflineSyncInterval | Integer | False |
Normal polling frequency used for background offline synchronization in Microsoft Office Outlook. |
| OutlookSyncInterval | Integer | False |
Normal polling frequency used for record synchronization in Microsoft Office Outlook. |
| PagingLimit | Integer | False |
Information that specifies how many items to list on a page in list views. |
| PersonalizationSettings | String | False |
For internal use only. |
| PMDesignator | String | False |
PM designator to use in Microsoft Dynamics CRM. |
| PricingDecimalPrecision | Integer | False |
Number of decimal places that can be used for prices. |
| ReportScriptErrors | String | False |
Picklist for selecting the user preference for reporting scripting errors. |
| ShowWeekNumber | Boolean | False |
Information that specifies whether to display the week number in calendar displays in Microsoft Dynamics CRM. |
| SyncContactCompany | Boolean | False |
Indicates if the company field in Microsoft Office Outlook items are set during Outlook synchronization. |
| SystemUserId | String | False |
Unique identifier of the user. |
| TimeFormatCode | Integer | False |
Information that specifies how the time is displayed in Microsoft Dynamics CRM. |
| TimeFormatString | String | False |
Text for how time is displayed in Microsoft Dynamics CRM. |
| TimeSeparator | String | False |
Text for how time is displayed in Microsoft Dynamics CRM. |
| TimeZoneBias | Integer | False |
Local time zone adjustment for the user. System calculated based on the time zone selected. |
| TimeZoneCode | Integer | False |
Local time zone for the user. |
| TimeZoneDaylightBias | Integer | False |
Local time zone daylight adjustment for the user. System calculated based on the time zone selected. |
| TimeZoneDaylightDay | Integer | False |
Local time zone daylight day for the user. System calculated based on the time zone selected. |
| TimeZoneDaylightDayOfWeek | Integer | False |
Local time zone daylight day of week for the user. System calculated based on the time zone selected in Options. |
| TimeZoneDaylightHour | Integer | False |
Local time zone daylight hour for the user. System calculated based on the time zone selected. |
| TimeZoneDaylightMinute | Integer | False |
Local time zone daylight minute for the user. System calculated based on the time zone selected. |
| TimeZoneDaylightMonth | Integer | False |
Local time zone daylight month for the user. System calculated based on the time zone selected. |
| TimeZoneDaylightSecond | Integer | False |
Local time zone daylight second for the user. System calculated based on the time zone selected. |
| TimeZoneDaylightYear | Integer | False |
Local time zone daylight year for the user. System calculated based on the time zone selected. |
| TimeZoneStandardBias | Integer | False |
Local time zone standard time bias for the user. System calculated based on the time zone selected. |
| TimeZoneStandardDay | Integer | False |
Local time zone standard day for the user. System calculated based on the time zone selected. |
| TimeZoneStandardDayOfWeek | Integer | False |
Local time zone standard day of week for the user. System calculated based on the time zone selected. |
| TimeZoneStandardHour | Integer | False |
Local time zone standard hour for the user. System calculated based on the time zone selected. |
| TimeZoneStandardMinute | Integer | False |
Local time zone standard minute for the user. System calculated based on the time zone selected. |
| TimeZoneStandardMonth | Integer | False |
Local time zone standard month for the user. System calculated based on the time zone selected. |
| TimeZoneStandardSecond | Integer | False |
Local time zone standard second for the user. System calculated based on the time zone selected. |
| TimeZoneStandardYear | Integer | False |
Local time zone standard year for the user. System calculated based on the time zone selected. |
| TrackingTokenId | Integer | False |
Tracking token ID. |
| TransactionCurrencyId_Id | String | False |
Unique identifier of the default currency of the user. |
| TransactionCurrencyId_LogicalName | String | False | |
| TransactionCurrencyId_Name | String | False | |
| UILanguageId | Integer | False |
Unique identifier of the language in which to view the user interface (UI). |
| UseCrmFormForAppointment | Boolean | False |
Indicates whether to use the Microsoft Dynamics CRM appointment form within Microsoft Office Outlook for creating new appointments. |
| UseCrmFormForContact | Boolean | False |
Indicates whether to use the Microsoft Dynamics CRM contact form within Microsoft Office Outlook for creating new contacts. |
| UseCrmFormForEmail | Boolean | False |
Indicates whether to use the Microsoft Dynamics CRM email form within Microsoft Office Outlook for creating new emails. |
| UseCrmFormForTask | Boolean | False |
Indicates whether to use the Microsoft Dynamics CRM task form within Microsoft Office Outlook for creating new tasks. |
| UseImageStrips | Boolean | False |
Indicates whether image strips are used to render images. |
| UserProfile | String | False |
Specifies user profile ids in comma separated list. |
| VisualizationPaneLayout | String | False |
The layout of the visualization pane. |
| WorkdayStartTime | String | False |
Workday start time for the user. |
| WorkdayStopTime | String | False |
Workday stop time for the user. |