JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462