CRM Organization

Table

CRM Organization

Fields |
Keys |
Relations To |
Relations From

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	OrganizationId (OrganizationId)	GUID	ExternalName: organizationid ExternalType: Uniqueidentifier ExternalAccess: Read Description: Unique identifier of the organization.
2	Name (Name)	Text160	ExternalName: name ExternalType: String ExternalAccess: Insert Description: Name of the organization. The name is set when Microsoft CRM is installed and should not be changed.
3	UserGroupId (UserGroupId)	GUID	ExternalName: usergroupid ExternalType: Uniqueidentifier Description: Unique identifier of the default group of users in the organization.
4	PrivilegeUserGroupId (PrivilegeUserGroupId)	GUID	ExternalName: privilegeusergroupid ExternalType: Uniqueidentifier Description: Unique identifier of the default privilege for users in the organization.
5	RecurrenceExpansionJobBatchSiz (RecurrenceExpansionJobBatchSiz)	Integer	ExternalName: recurrenceexpansionjobbatchsize ExternalType: Integer Description: Specifies the value for number of instances created in on demand job in one shot.
6	RecurrenceExpansionJobBatchInt (RecurrenceExpansionJobBatchInt)	Integer	ExternalName: recurrenceexpansionjobbatchinterval ExternalType: Integer Description: Specifies the interval (in seconds) for pausing expansion job.
7	FiscalPeriodType (FiscalPeriodType)	Integer	ExternalName: fiscalperiodtype ExternalType: Integer Description: Type of fiscal period used throughout Microsoft CRM.
8	FiscalCalendarStart (FiscalCalendarStart)	Date	ExternalName: fiscalcalendarstart ExternalType: DateTime Description: Start date for the fiscal period that is to be used throughout Microsoft CRM.
9	DateFormatCode (DateFormatCode)	Option	[ ] OptionOrdinalValues: -1 InitValue: [ ] ExternalName: dateformatcode ExternalType: Picklist Description: Information about how the date is displayed throughout Microsoft CRM.
10	TimeFormatCode (TimeFormatCode)	Option	[ ] OptionOrdinalValues: -1 InitValue: [ ] ExternalName: timeformatcode ExternalType: Picklist Description: Information that specifies how the time is displayed throughout Microsoft CRM.
11	CurrencySymbol (CurrencySymbol)	Text13	ExternalName: currencysymbol ExternalType: String Description: Symbol used for currency throughout Microsoft Dynamics CRM.
12	WeekStartDayCode (WeekStartDayCode)	Option	[ ] OptionOrdinalValues: -1 InitValue: [ ] ExternalName: weekstartdaycode ExternalType: Picklist Description: Designated first day of the week throughout Microsoft Dynamics CRM.
13	DateSeparator (DateSeparator)	Text5	ExternalName: dateseparator ExternalType: String Description: Character used to separate the month, the day, and the year in dates throughout Microsoft Dynamics CRM.
14	FullNameConventionCode (FullNameConventionCode)	Option	[LastNameFirstName,FirstName,LastNameFirstNameMiddleInitial,FirstNameMiddleInitialLastName,LastNameFirstNameMiddleName,FirstNameMiddleNameLastName,LastNamespaceFirstName,LastNamenospaceFirstName] OptionOrdinalValues: [0;1;2;3;4;5;6;7] InitValue: LastNameFirstName ExternalName: fullnameconventioncode ExternalType: Picklist Description: Order in which names are to be displayed throughout Microsoft CRM.
15	NegativeFormatCode (NegativeFormatCode)	Option	[Brackets,Dash,DashplusSpace,TrailingDash,SpaceplusTrailingDash] OptionOrdinalValues: [0;1;2;3;4] InitValue: Brackets ExternalName: negativeformatcode ExternalType: Picklist Description: Information that specifies how negative numbers are displayed throughout Microsoft CRM.
16	NumberFormat (NumberFormat)	Text2	ExternalName: numberformat ExternalType: String Description: Specification of how numbers are displayed throughout Microsoft CRM.
17	IsDisabled (IsDisabled)	Boolean	ExternalName: isdisabled ExternalType: Boolean ExternalAccess: Read Description: Information that specifies whether the organization is disabled.
18	DisabledReason (DisabledReason)	Text250	ExternalName: disabledreason ExternalType: String ExternalAccess: Read Description: Reason for disabling the organization.
19	KbPrefix (KbPrefix)	Text20	ExternalName: kbprefix ExternalType: String Description: Prefix to use for all articles in Microsoft Dynamics CRM.
20	CurrentKbNumber (CurrentKbNumber)	Integer	ExternalName: currentkbnumber ExternalType: Integer Description: First article number to use.
21	CasePrefix (CasePrefix)	Text20	ExternalName: caseprefix ExternalType: String Description: Prefix to use for all cases throughout Microsoft Dynamics CRM.
22	CurrentCaseNumber (CurrentCaseNumber)	Integer	ExternalName: currentcasenumber ExternalType: Integer Description: First case number to use.
23	ContractPrefix (ContractPrefix)	Text20	ExternalName: contractprefix ExternalType: String Description: Prefix to use for all contracts throughout Microsoft Dynamics CRM.
24	CurrentContractNumber (CurrentContractNumber)	Integer	ExternalName: currentcontractnumber ExternalType: Integer Description: First contract number to use.
25	QuotePrefix (QuotePrefix)	Text20	ExternalName: quoteprefix ExternalType: String Description: Prefix to use for all quotes throughout Microsoft Dynamics CRM.
26	CurrentQuoteNumber (CurrentQuoteNumber)	Integer	ExternalName: currentquotenumber ExternalType: Integer Description: First quote number to use.
27	OrderPrefix (OrderPrefix)	Text20	ExternalName: orderprefix ExternalType: String Description: Prefix to use for all orders throughout Microsoft Dynamics CRM.
28	CurrentOrderNumber (CurrentOrderNumber)	Integer	ExternalName: currentordernumber ExternalType: Integer Description: First order number to use.
29	InvoicePrefix (InvoicePrefix)	Text20	ExternalName: invoiceprefix ExternalType: String Description: Prefix to use for all invoice numbers throughout Microsoft Dynamics CRM.
30	CurrentInvoiceNumber (CurrentInvoiceNumber)	Integer	ExternalName: currentinvoicenumber ExternalType: Integer Description: First invoice number to use.
31	UniqueSpecifierLength (UniqueSpecifierLength)	Integer	MinValue: 4 MaxValue: 6 ExternalName: uniquespecifierlength ExternalType: Integer Description: Number of characters appended to invoice, quote, and order numbers.
32	CreatedOn (CreatedOn)	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the organization was created.
33	ModifiedOn (ModifiedOn)	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the organization was last modified.
34	FiscalYearFormat (FiscalYearFormat)	Text25	ExternalName: fiscalyearformat ExternalType: String Description: Information that specifies how the name of the fiscal year is displayed throughout Microsoft CRM.
35	FiscalPeriodFormat (FiscalPeriodFormat)	Text25	ExternalName: fiscalperiodformat ExternalType: String Description: Information that specifies how the name of the fiscal period is displayed throughout Microsoft CRM.
36	FiscalYearPeriodConnect (FiscalYearPeriodConnect)	Text5	ExternalName: fiscalyearperiodconnect ExternalType: String Description: Information that specifies how the names of the fiscal year and the fiscal period should be connected when displayed together.
37	LanguageCode (LanguageCode)	Integer	ExternalName: languagecode ExternalType: Integer ExternalAccess: Insert Description: Preferred language for the organization.
38	SortId (SortId)	Integer	ExternalName: sortid ExternalType: Integer Description: For internal use only.
39	DateFormatString (DateFormatString)	Text250	ExternalName: dateformatstring ExternalType: String Description: String showing how the date is displayed throughout Microsoft CRM.
40	TimeFormatString (TimeFormatString)	Text250	ExternalName: timeformatstring ExternalType: String Description: Text for how time is displayed in Microsoft Dynamics CRM.
41	PricingDecimalPrecision (PricingDecimalPrecision)	Integer	MaxValue: 4 ExternalName: pricingdecimalprecision ExternalType: Integer Description: Number of decimal places that can be used for prices.
42	ShowWeekNumber (ShowWeekNumber)	Boolean	ExternalName: showweeknumber ExternalType: Boolean Description: Information that specifies whether to display the week number in calendar displays throughout Microsoft CRM.
43	NextTrackingNumber (NextTrackingNumber)	Integer	ExternalName: nexttrackingnumber ExternalType: Integer Description: Next token to be placed on the subject line of an email message.
44	TagMaxAggressiveCycles (TagMaxAggressiveCycles)	Integer	ExternalName: tagmaxaggressivecycles ExternalType: Integer Description: Maximum number of aggressive polling cycles executed for email auto-tagging when a new email is received.
45	SystemUserId (SystemUserId)	GUID	ExternalName: systemuserid ExternalType: Uniqueidentifier Description: Unique identifier of the system user for the organization.
46	CreatedBy (CreatedBy)	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who created the organization. TableRelation: "CRM Systemuser".SystemUserId
47	GrantAccessToNetworkService (GrantAccessToNetworkService)	Boolean	ExternalName: grantaccesstonetworkservice ExternalType: Boolean ExternalAccess: Insert Description: For internal use only.
48	AllowOutlookScheduledSyncs (AllowOutlookScheduledSyncs)	Boolean	ExternalName: allowoutlookscheduledsyncs ExternalType: Boolean Description: Indicates whether scheduled synchronizations to Outlook are allowed.
49	AllowMarketingEmailExecution (AllowMarketingEmailExecution)	Boolean	ExternalName: allowmarketingemailexecution ExternalType: Boolean Description: Indicates whether marketing emails execution is allowed.
50	SqlAccessGroupId (SqlAccessGroupId)	GUID	ExternalName: sqlaccessgroupid ExternalType: Uniqueidentifier Description: For internal use only.
51	CurrencyFormatCode (CurrencyFormatCode)	Option	[$123,123$,$1231,123$1] OptionOrdinalValues: [0;1;2;3] InitValue: $123 ExternalName: currencyformatcode ExternalType: Picklist Description: Information about how currency symbols are placed throughout Microsoft Dynamics CRM.
52	FiscalSettingsUpdated (FiscalSettingsUpdated)	Boolean	ExternalName: fiscalsettingsupdated ExternalType: Boolean ExternalAccess: Read Description: Information that specifies whether the fiscal settings have been updated.
53	ReportingGroupId (ReportingGroupId)	GUID	ExternalName: reportinggroupid ExternalType: Uniqueidentifier Description: For internal use only.
54	TokenExpiry (TokenExpiry)	Integer	ExternalName: tokenexpiry ExternalType: Integer ExternalAccess: Modify Description: Duration used for token expiration.
55	ShareToPreviousOwnerOnAssign (ShareToPreviousOwnerOnAssign)	Boolean	ExternalName: sharetopreviousowneronassign ExternalType: Boolean ExternalAccess: Modify Description: Information that specifies whether to share to previous owner on assign.
56	ModifiedBy (ModifiedBy)	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who last modified the organization. TableRelation: "CRM Systemuser".SystemUserId
57	IntegrationUserId (IntegrationUserId)	GUID	ExternalName: integrationuserid ExternalType: Uniqueidentifier Description: Unique identifier of the integration user for the organization.
58	TrackingTokenIdBase (TrackingTokenIdBase)	Integer	ExternalName: trackingtokenidbase ExternalType: Integer Description: Base number used to provide separate tracking token identifiers to users belonging to different deployments.
59	BusinessClosureCalendarId (BusinessClosureCalendarId)	GUID	ExternalName: businessclosurecalendarid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the business closure calendar of organization.
60	AllowAutoUnsubscribeAcknowledg (AllowAutoUnsubscribeAcknowledg)	Boolean	ExternalName: allowautounsubscribeacknowledgement ExternalType: Boolean Description: Indicates whether automatic unsubscribe acknowledgement email is allowed to send.
61	AllowAutoUnsubscribe (AllowAutoUnsubscribe)	Boolean	ExternalName: allowautounsubscribe ExternalType: Boolean Description: Indicates whether automatic unsubscribe is allowed.
62	VersionNumber (VersionNumber)	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the organization.
63	TrackingPrefix (TrackingPrefix)	Text250	ExternalName: trackingprefix ExternalType: String Description: History list of tracking token prefixes.
64	MinOutlookSyncInterval (MinOutlookSyncInterval)	Integer	ExternalName: minoutlooksyncinterval ExternalType: Integer Description: Minimum allowed time between scheduled Outlook synchronizations.
65	BulkOperationPrefix (BulkOperationPrefix)	Text20	ExternalName: bulkoperationprefix ExternalType: String Description: Prefix used for bulk operation numbering.
66	AllowAutoResponseCreation (AllowAutoResponseCreation)	Boolean	ExternalName: allowautoresponsecreation ExternalType: Boolean Description: Indicates whether automatic response creation is allowed.
67	MaximumTrackingNumber (MaximumTrackingNumber)	Integer	ExternalName: maximumtrackingnumber ExternalType: Integer Description: Maximum tracking number before recycling takes place.
68	CampaignPrefix (CampaignPrefix)	Text20	ExternalName: campaignprefix ExternalType: String Description: Prefix used for campaign numbering.
69	SqlAccessGroupName (SqlAccessGroupName)	Text250	ExternalName: sqlaccessgroupname ExternalType: String Description: For internal use only.
70	CurrentCampaignNumber (CurrentCampaignNumber)	Integer	ExternalName: currentcampaignnumber ExternalType: Integer Description: Current campaign number.
71	FiscalYearDisplayCode (FiscalYearDisplayCode)	Integer	ExternalName: fiscalyeardisplaycode ExternalType: Integer Description: Information that specifies whether the fiscal year should be displayed based on the start date or the end date of the fiscal year.
72	SiteMapXml (SiteMapXml)	BLOB [Memo]	ExternalName: sitemapxml ExternalType: Memo Description: XML string that defines the navigation structure for the application.
73	ReportingGroupName (ReportingGroupName)	Text250	ExternalName: reportinggroupname ExternalType: String Description: For internal use only.
74	CurrentBulkOperationNumber (CurrentBulkOperationNumber)	Integer	ExternalName: currentbulkoperationnumber ExternalType: Integer Description: Current bulk operation number.
75	SchemaNamePrefix (SchemaNamePrefix)	Text8	ExternalName: schemanameprefix ExternalType: String Description: Prefix used for custom entities and attributes.
76	IgnoreInternalEmail (IgnoreInternalEmail)	Boolean	ExternalName: ignoreinternalemail ExternalType: Boolean Description: Indicates whether incoming email sent by internal Microsoft Dynamics CRM users or queues should be tracked.
77	TagPollingPeriod (TagPollingPeriod)	Integer	ExternalName: tagpollingperiod ExternalType: Integer Description: Normal polling frequency used for email receive auto-tagging in outlook.
78	TrackingTokenIdDigits (TrackingTokenIdDigits)	Integer	ExternalName: trackingtokeniddigits ExternalType: Integer Description: Number of digits used to represent a tracking token identifier.
79	ModifiedByName (ModifiedByName)	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
80	CreatedByName (CreatedByName)	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
81	NumberGroupFormat (NumberGroupFormat)	Text50	ExternalName: numbergroupformat ExternalType: String Description: Specifies how numbers are grouped in Microsoft Dynamics CRM.
82	LongDateFormatCode (LongDateFormatCode)	Integer	ExternalName: longdateformatcode ExternalType: Integer Description: Information that specifies how the Long Date format is displayed in Microsoft Dynamics CRM.
83	UTCConversionTimeZoneCode (UTCConversionTimeZoneCode)	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
84	TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber)	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
85	CurrentImportSequenceNumber (CurrentImportSequenceNumber)	Integer	ExternalName: currentimportsequencenumber ExternalType: Integer ExternalAccess: Read Description: Import sequence to use.
86	ParsedTablePrefix (ParsedTablePrefix)	Text20	ExternalName: parsedtableprefix ExternalType: String ExternalAccess: Read Description: Prefix used for parsed tables.
87	V3CalloutConfigHash (V3CalloutConfigHash)	Text250	ExternalName: v3calloutconfighash ExternalType: String ExternalAccess: Read Description: Hash of the V3 callout configuration file.
88	IsFiscalPeriodMonthBased (IsFiscalPeriodMonthBased)	Boolean	ExternalName: isfiscalperiodmonthbased ExternalType: Boolean Description: Indicates whether the fiscal period is displayed as the month number.
89	LocaleId (LocaleId)	Integer	ExternalName: localeid ExternalType: Integer Description: Unique identifier of the locale of the organization.
90	ParsedTableColumnPrefix (ParsedTableColumnPrefix)	Text20	ExternalName: parsedtablecolumnprefix ExternalType: String ExternalAccess: Read Description: Prefix used for parsed table columns.
91	SupportUserId (SupportUserId)	GUID	ExternalName: supportuserid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the support user for the organization.
92	AMDesignator (AMDesignator)	Text25	ExternalName: amdesignator ExternalType: String Description: AM designator to use throughout Microsoft Dynamics CRM.
93	CurrencyDisplayOption (CurrencyDisplayOption)	Option	[Currencysymbol,Currencycode] OptionOrdinalValues: [0;1] InitValue: Currencysymbol ExternalName: currencydisplayoption ExternalType: Picklist Description: Indicates whether to display money fields with currency code or currency symbol.
94	MinAddressBookSyncInterval (MinAddressBookSyncInterval)	Integer	ExternalName: minaddressbooksyncinterval ExternalType: Integer Description: Normal polling frequency used for address book synchronization in Microsoft Office Outlook.
95	IsDuplicateDetectionEnabledFor (IsDuplicateDetectionEnabledFor)	Boolean	ExternalName: isduplicatedetectionenabledforonlinecreateupdate ExternalType: Boolean Description: Indicates whether duplicate detection during online create or update is enabled.
96	FeatureSet (FeatureSet)	Text250	ExternalName: featureset ExternalType: String Description: Features to be enabled as an XML BLOB.
97	BlockedAttachments (BlockedAttachments)	Text250	ExternalName: blockedattachments ExternalType: String Description: Prevent upload or download of certain attachment types that are considered dangerous.
98	IsDuplicateDetectionEnabledFo1 (IsDuplicateDetectionEnabledFo1)	Boolean	ExternalName: isduplicatedetectionenabledforofflinesync ExternalType: Boolean Description: Indicates whether duplicate detection of records during offline synchronization is enabled.
99	AllowOfflineScheduledSyncs (AllowOfflineScheduledSyncs)	Boolean	ExternalName: allowofflinescheduledsyncs ExternalType: Boolean Description: Indicates whether background offline synchronization in Microsoft Office Outlook is allowed.
100	AllowUnresolvedPartiesOnEmailS (AllowUnresolvedPartiesOnEmailS)	Boolean	ExternalName: allowunresolvedpartiesonemailsend ExternalType: Boolean Description: Indicates whether users are allowed to send email to unresolved parties (parties must still have an email address).
101	TimeSeparator (TimeSeparator)	Text5	ExternalName: timeseparator ExternalType: String Description: Text for how the time separator is displayed throughout Microsoft Dynamics CRM.
102	CurrentParsedTableNumber (CurrentParsedTableNumber)	Integer	ExternalName: currentparsedtablenumber ExternalType: Integer ExternalAccess: Read Description: First parsed table number to use.
103	MinOfflineSyncInterval (MinOfflineSyncInterval)	Integer	ExternalName: minofflinesyncinterval ExternalType: Integer Description: Normal polling frequency used for background offline synchronization in Microsoft Office Outlook.
104	AllowWebExcelExport (AllowWebExcelExport)	Boolean	ExternalName: allowwebexcelexport ExternalType: Boolean Description: Indicates whether Web-based export of grids to Microsoft Office Excel is allowed.
105	ReferenceSiteMapXml (ReferenceSiteMapXml)	Text250	ExternalName: referencesitemapxml ExternalType: String Description: XML string that defines the navigation structure for the application. This is the site map from the previously upgraded build and is used in a 3-way merge during upgrade.
106	IsDuplicateDetectionEnabledFo2 (IsDuplicateDetectionEnabledFo2)	Boolean	ExternalName: isduplicatedetectionenabledforimport ExternalType: Boolean Description: Indicates whether duplicate detection of records during import is enabled.
107	CalendarType (CalendarType)	Integer	ExternalName: calendartype ExternalType: Integer Description: Calendar type for the system. Set to Gregorian US by default.
108	SQMEnabled (SQMEnabled)	Boolean	ExternalName: sqmenabled ExternalType: Boolean Description: Setting for SQM data collection, 0 no, 1 yes enabled
109	NegativeCurrencyFormatCode (NegativeCurrencyFormatCode)	Integer	ExternalName: negativecurrencyformatcode ExternalType: Integer Description: Information that specifies how negative currency numbers are displayed throughout Microsoft Dynamics CRM.
110	AllowAddressBookSyncs (AllowAddressBookSyncs)	Boolean	ExternalName: allowaddressbooksyncs ExternalType: Boolean Description: Indicates whether background address book synchronization in Microsoft Office Outlook is allowed.
111	ISVIntegrationCode (ISVIntegrationCode)	Option	[ ,None,Web,OutlookWorkstationClient,Web;OutlookWorkstationClient,OutlookLaptopClient,Web;OutlookLaptopClient,Outlook,All] OptionOrdinalValues: [-1;0;1;2;3;4;5;6;7] InitValue: [ ] ExternalName: isvintegrationcode ExternalType: Picklist Description: Indicates whether loading of Microsoft Dynamics CRM in a browser window that does not have address, tool, and menu bars is enabled.
112	DecimalSymbol (DecimalSymbol)	Text5	ExternalName: decimalsymbol ExternalType: String Description: Symbol used for decimal in Microsoft Dynamics CRM.
113	MaxUploadFileSize (MaxUploadFileSize)	Integer	ExternalName: maxuploadfilesize ExternalType: Integer Description: Maximum allowed size of an attachment.
114	IsAppMode (IsAppMode)	Boolean	ExternalName: isappmode ExternalType: Boolean Description: Indicates whether loading of Microsoft Dynamics CRM in a browser window that does not have address, tool, and menu bars is enabled.
115	EnablePricingOnCreate (EnablePricingOnCreate)	Boolean	ExternalName: enablepricingoncreate ExternalType: Boolean Description: Enable pricing calculations on a Create call.
116	IsSOPIntegrationEnabled (IsSOPIntegrationEnabled)	Boolean	ExternalName: issopintegrationenabled ExternalType: Boolean Description: Enable sales order processing integration.
117	PMDesignator (PMDesignator)	Text25	ExternalName: pmdesignator ExternalType: String Description: PM designator to use throughout Microsoft Dynamics CRM.
118	CurrencyDecimalPrecision (CurrencyDecimalPrecision)	Integer	ExternalName: currencydecimalprecision ExternalType: Integer Description: Number of decimal places that can be used for currency.
119	MaxAppointmentDurationDays (MaxAppointmentDurationDays)	Integer	ExternalName: maxappointmentdurationdays ExternalType: Integer Description: Maximum number of days an appointment can last.
120	EmailSendPollingPeriod (EmailSendPollingPeriod)	Integer	ExternalName: emailsendpollingperiod ExternalType: Integer Description: Normal polling frequency used for sending email in Microsoft Office Outlook.
121	RenderSecureIFrameForEmail (RenderSecureIFrameForEmail)	Boolean	ExternalName: rendersecureiframeforemail ExternalType: Boolean Description: Flag to render the body of email in the Web form in an IFRAME with the security='restricted' attribute set. This is additional security but can cause a credentials prompt.
122	NumberSeparator (NumberSeparator)	Text5	ExternalName: numberseparator ExternalType: String Description: Symbol used for number separation in Microsoft Dynamics CRM.
123	PrivReportingGroupId (PrivReportingGroupId)	GUID	ExternalName: privreportinggroupid ExternalType: Uniqueidentifier Description: For internal use only.
124	BaseCurrencyId (BaseCurrencyId)	GUID	ExternalName: basecurrencyid ExternalType: Lookup ExternalAccess: Insert Description: Unique identifier of the base currency of the organization. TableRelation: "CRM Transactioncurrency".TransactionCurrencyId
125	MaxRecordsForExportToExcel (MaxRecordsForExportToExcel)	Integer	ExternalName: maxrecordsforexporttoexcel ExternalType: Integer Description: Maximum number of records that will be exported to a static Microsoft Office Excel worksheet when exporting from the grid.
126	PrivReportingGroupName (PrivReportingGroupName)	Text250	ExternalName: privreportinggroupname ExternalType: String Description: For internal use only.
127	YearStartWeekCode (YearStartWeekCode)	Integer	ExternalName: yearstartweekcode ExternalType: Integer Description: Information that specifies how the first week of the year is specified in Microsoft Dynamics CRM.
128	IsPresenceEnabled (IsPresenceEnabled)	Boolean	ExternalName: ispresenceenabled ExternalType: Boolean Description: Information on whether IM presence is enabled.
129	IsDuplicateDetectionEnabled (IsDuplicateDetectionEnabled)	Boolean	ExternalName: isduplicatedetectionenabled ExternalType: Boolean Description: Indicates whether duplicate detection of records is enabled.
130	BaseCurrencyIdName (BaseCurrencyIdName)	Text100	ExternalName: basecurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(BaseCurrencyId)))	FlowField
131	ExpireSubscriptionsInDays (ExpireSubscriptionsInDays)	Integer	ExternalName: expiresubscriptionsindays ExternalType: Integer Description: Maximum number of days before deleting inactive subscriptions.
132	IsAuditEnabled (IsAuditEnabled)	Boolean	ExternalName: isauditenabled ExternalType: Boolean Description: Enable or disable auditing of changes.
133	BaseCurrencyPrecision (BaseCurrencyPrecision)	Integer	MaxValue: 4 ExternalName: basecurrencyprecision ExternalType: Integer ExternalAccess: Read Description: Number of decimal places that can be used for the base currency.
134	BaseCurrencySymbol (BaseCurrencySymbol)	Text5	ExternalName: basecurrencysymbol ExternalType: String ExternalAccess: Read Description: Symbol used for the base currency.
135	MaxRecordsForLookupFilters (MaxRecordsForLookupFilters)	Integer	ExternalName: maxrecordsforlookupfilters ExternalType: Integer Description: Maximum number of lookup and picklist records that can be selected by user for filtering.
136	AllowEntityOnlyAudit (AllowEntityOnlyAudit)	Boolean	ExternalName: allowentityonlyaudit ExternalType: Boolean ExternalAccess: Insert Description: Indicates whether auditing of changes to entity is allowed when no attributes have changed.
137	DefaultRecurrenceEndRangeType (DefaultRecurrenceEndRangeType)	Option	[ ,NoEndDate,NumberofOccurrences,EndByDate] OptionOrdinalValues: [-1;1;2;3] InitValue: [ ] ExternalName: defaultrecurrenceendrangetype ExternalType: Picklist Description: Type of default recurrence end range date.
138	FutureExpansionWindow (FutureExpansionWindow)	Integer	MinValue: 1 MaxValue: 140 ExternalName: futureexpansionwindow ExternalType: Integer Description: Specifies the maximum number of months in future for which the recurring activities can be created.
139	PastExpansionWindow (PastExpansionWindow)	Integer	MinValue: 1 MaxValue: 120 ExternalName: pastexpansionwindow ExternalType: Integer Description: Specifies the maximum number of months in past for which the recurring activities can be created.
140	RecurrenceExpansionSynchCreate (RecurrenceExpansionSynchCreate)	Integer	MinValue: 1 MaxValue: 1000 ExternalName: recurrenceexpansionsynchcreatemax ExternalType: Integer Description: Specifies the maximum number of instances to be created synchronously after creating a recurring appointment.
141	RecurrenceDefaultNumberOfOccur (RecurrenceDefaultNumberOfOccur)	Integer	MinValue: 1 MaxValue: 999 ExternalName: recurrencedefaultnumberofoccurrences ExternalType: Integer Description: Specifies the default value for number of occurrences field in the recurrence dialog.
142	CreatedOnBehalfBy (CreatedOnBehalfBy)	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the delegate user who created the organization. TableRelation: "CRM Systemuser".SystemUserId
143	CreatedOnBehalfByName (CreatedOnBehalfByName)	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
144	ModifiedOnBehalfBy (ModifiedOnBehalfBy)	GUID	ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the delegate user who last modified the organization. TableRelation: "CRM Systemuser".SystemUserId
145	ModifiedOnBehalfByName (ModifiedOnBehalfByName)	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
146	GetStartedPaneContentEnabled (GetStartedPaneContentEnabled)	Boolean	ExternalName: getstartedpanecontentenabled ExternalType: Boolean Description: Indicates whether Get Started content is enabled for this organization.
147	UseReadForm (UseReadForm)	Boolean	ExternalName: usereadform ExternalType: Boolean Description: Indicates whether the read-optimized form should be enabled for this organization.
148	InitialVersion (InitialVersion)	Text20	ExternalName: initialversion ExternalType: String ExternalAccess: Insert Description: Initial version of the organization.
149	SampleDataImportId (SampleDataImportId)	GUID	ExternalName: sampledataimportid ExternalType: Uniqueidentifier Description: Unique identifier of the sample data import job.
150	ReportScriptErrors (ReportScriptErrors)	Option	[ ,NopreferenceforsendinganerrorreporttoMicrosoftaboutMicrosoftDynamicsCRM,AskmeforpermissiontosendanerrorreporttoMicrosoft,AutomaticallysendanerrorreporttoMicrosoftwithoutaskingmeforpermission,NeversendanerrorreporttoMicrosoftaboutMicrosoftDynamicsCRM] OptionOrdinalValues: [-1;0;1;2;3] InitValue: [ ] ExternalName: reportscripterrors ExternalType: Picklist Description: Picklist for selecting the organization preference for reporting scripting errors.
151	RequireApprovalForUserEmail (RequireApprovalForUserEmail)	Boolean	ExternalName: requireapprovalforuseremail ExternalType: Boolean Description: Indicates whether Send As Other User privilege is enabled.
152	RequireApprovalForQueueEmail (RequireApprovalForQueueEmail)	Boolean	ExternalName: requireapprovalforqueueemail ExternalType: Boolean Description: Indicates whether Send As Other User privilege is enabled.
153	GoalRollupExpiryTime (GoalRollupExpiryTime)	Integer	MaxValue: 400 ExternalName: goalrollupexpirytime ExternalType: Integer Description: Number of days after the goal's end date after which the rollup of the goal stops automatically.
154	GoalRollupFrequency (GoalRollupFrequency)	Integer	MinValue: 1 ExternalName: goalrollupfrequency ExternalType: Integer Description: Number of hours between automatic rollup jobs .
155	AutoApplyDefaultonCaseCreate (AutoApplyDefaultonCaseCreate)	Boolean	ExternalName: autoapplydefaultoncasecreate ExternalType: Boolean Description: Select whether to auto apply the default customer entitlement on case creation.
156	AutoApplyDefaultonCaseUpdate (AutoApplyDefaultonCaseUpdate)	Boolean	ExternalName: autoapplydefaultoncaseupdate ExternalType: Boolean Description: Select whether to auto apply the default customer entitlement on case update.
157	FiscalYearFormatPrefix (FiscalYearFormatPrefix)	Option	[ ,FY] OptionOrdinalValues: [-1;1;2] InitValue: [ ] ExternalName: fiscalyearformatprefix ExternalType: Picklist Description: Prefix for the display of the fiscal year.
158	FiscalYearFormatSuffix (FiscalYearFormatSuffix)	Option	[ ,FY,FiscalYear] OptionOrdinalValues: [-1;1;2;3] InitValue: [ ] ExternalName: fiscalyearformatsuffix ExternalType: Picklist Description: Suffix for the display of the fiscal year.
159	FiscalYearFormatYear (FiscalYearFormatYear)	Option	[ ,YYYY,YY,GGYY] OptionOrdinalValues: [-1;1;2;3] InitValue: [ ] ExternalName: fiscalyearformatyear ExternalType: Picklist Description: Format for the year.
160	DiscountCalculationMethod (DiscountCalculationMethod)	Option	[Lineitem,Perunit] OptionOrdinalValues: [0;1] InitValue: Lineitem ExternalName: discountcalculationmethod ExternalType: Picklist Description: Discount calculation method for the QOOI product.
161	FiscalPeriodFormatPeriod (FiscalPeriodFormatPeriod)	Option	[ ,Quarter{0},Q{0},P{0},Month{0},M{0},Semester{0},MonthName] OptionOrdinalValues: [-1;1;2;3;4;5;6;7] InitValue: [ ] ExternalName: fiscalperiodformatperiod ExternalType: Picklist Description: Format in which the fiscal period will be displayed.
162	AllowClientMessageBarAd (AllowClientMessageBarAd)	Boolean	ExternalName: allowclientmessagebarad ExternalType: Boolean Description: Indicates whether Outlook Client message bar advertisement is allowed.
163	AllowUserFormModePreference (AllowUserFormModePreference)	Boolean	ExternalName: allowuserformmodepreference ExternalType: Boolean Description: Indicates whether individuals can select their form mode preference in their personal options.
164	HashFilterKeywords (HashFilterKeywords)	Text250	ExternalName: hashfilterkeywords ExternalType: String Description: Filter Subject Keywords
165	HashMaxCount (HashMaxCount)	Integer	ExternalName: hashmaxcount ExternalType: Integer Description: Maximum number of subject keywords or recipients used for correlation
166	HashDeltaSubjectCount (HashDeltaSubjectCount)	Integer	ExternalName: hashdeltasubjectcount ExternalType: Integer Description: Maximum difference allowed between subject keywords count of the email messaged to be correlated
167	HashMinAddressCount (HashMinAddressCount)	Integer	ExternalName: hashminaddresscount ExternalType: Integer Description: Minimum number of recipients required to match for email messaged to be correlated
168	EnableSmartMatching (EnableSmartMatching)	Boolean	ExternalName: enablesmartmatching ExternalType: Boolean Description: Use Smart Matching.
169	PinpointLanguageCode (PinpointLanguageCode)	Integer	ExternalName: pinpointlanguagecode ExternalType: Integer ExternalAccess: Modify
170	OrgDbOrgSettings (OrgDbOrgSettings)	Text250	ExternalName: orgdborgsettings ExternalType: String Description: Organization settings stored in Organization Database.
171	IsUserAccessAuditEnabled (IsUserAccessAuditEnabled)	Boolean	ExternalName: isuseraccessauditenabled ExternalType: Boolean Description: Enable or disable auditing of user access.
172	UserAccessAuditingInterval (UserAccessAuditingInterval)	Integer	ExternalName: useraccessauditinginterval ExternalType: Integer Description: The interval at which user access is checked for auditing.
173	QuickFindRecordLimitEnabled (QuickFindRecordLimitEnabled)	Boolean	ExternalName: quickfindrecordlimitenabled ExternalType: Boolean Description: Indicates whether a quick find record limit should be enabled for this organization (allows for faster Quick Find queries but prevents overly broad searches).
174	EnableBingMapsIntegration (EnableBingMapsIntegration)	Boolean	ExternalName: enablebingmapsintegration ExternalType: Boolean Description: Enable Integration with Bing Maps
175	IsDefaultCountryCodeCheckEnabl (IsDefaultCountryCodeCheckEnabl)	Boolean	ExternalName: isdefaultcountrycodecheckenabled ExternalType: Boolean Description: Enable or disable country code selection.
176	DefaultCountryCode (DefaultCountryCode)	Text30	ExternalName: defaultcountrycode ExternalType: String Description: Text area to enter default country code.
177	UseSkypeProtocol (UseSkypeProtocol)	Boolean	ExternalName: useskypeprotocol ExternalType: Boolean Description: Indicates default protocol selected for organization.
178	IncomingEmailExchangeEmailRetr (IncomingEmailExchangeEmailRetr)	Integer	MinValue: 1 ExternalName: incomingemailexchangeemailretrievalbatchsize ExternalType: Integer Description: Setting for the Async Service Mailbox Queue. Defines the retrieval batch size of exchange server.
179	EmailCorrelationEnabled (EmailCorrelationEnabled)	Boolean	ExternalName: emailcorrelationenabled ExternalType: Boolean Description: Flag to turn email correlation on or off.
180	YammerOAuthAccessTokenExpired (YammerOAuthAccessTokenExpired)	Boolean	ExternalName: yammeroauthaccesstokenexpired ExternalType: Boolean ExternalAccess: Modify Description: Denotes whether the OAuth access token for Yammer network has expired
181	DefaultEmailSettings (DefaultEmailSettings)	Text250	ExternalName: defaultemailsettings ExternalType: String Description: XML string containing the default email settings that are applied when a user or queue is created.
182	YammerGroupId (YammerGroupId)	Integer	ExternalName: yammergroupid ExternalType: Integer ExternalAccess: Modify Description: Denotes the Yammer group ID
183	YammerNetworkPermalink (YammerNetworkPermalink)	Text100	ExternalName: yammernetworkpermalink ExternalType: String ExternalAccess: Modify Description: Denotes the Yammer network permalink
184	YammerPostMethod (YammerPostMethod)	Option	[Public,Private] OptionOrdinalValues: [0;1] InitValue: Public ExternalName: yammerpostmethod ExternalType: Picklist ExternalAccess: Modify Description: Internal Use Only
185	EmailConnectionChannel (EmailConnectionChannel)	Option	[Server-SideSynchronization,MicrosoftDynamicsCRM2015EmailRouter] OptionOrdinalValues: [0;1] InitValue: Server-SideSynchronization ExternalName: emailconnectionchannel ExternalType: Picklist Description: Select if you want to use the Email Router or server-side synchronization for email processing.
186	IsAutoSaveEnabled (IsAutoSaveEnabled)	Boolean	ExternalName: isautosaveenabled ExternalType: Boolean Description: Information on whether auto save is enabled.
187	BingMapsApiKey (BingMapsApiKey)	Text250	ExternalName: bingmapsapikey ExternalType: String Description: Api Key to be used in requests to Bing Maps services.
188	GenerateAlertsForErrors (GenerateAlertsForErrors)	Boolean	ExternalName: generatealertsforerrors ExternalType: Boolean Description: Indicates whether alerts will be generated for errors.
189	GenerateAlertsForInformation (GenerateAlertsForInformation)	Boolean	ExternalName: generatealertsforinformation ExternalType: Boolean Description: Indicates whether alerts will be generated for information.
190	GenerateAlertsForWarnings (GenerateAlertsForWarnings)	Boolean	ExternalName: generatealertsforwarnings ExternalType: Boolean Description: Indicates whether alerts will be generated for warnings.
191	NotifyMailboxOwnerOfEmailServe (NotifyMailboxOwnerOfEmailServe)	Boolean	ExternalName: notifymailboxownerofemailserverlevelalerts ExternalType: Boolean Description: Indicates whether mailbox owners will be notified of email server profile level alerts.
192	MaximumActiveBusinessProcessFl (MaximumActiveBusinessProcessFl)	Integer	MinValue: 1 ExternalName: maximumactivebusinessprocessflowsallowedperentity ExternalType: Integer Description: Maximum number of active business process flows allowed per entity
193	EntityImageId (EntityImageId)	GUID	ExternalName: entityimageid ExternalType: Uniqueidentifier ExternalAccess: Read Description: For internal use only.
194	AllowUsersSeeAppdownloadMessag (AllowUsersSeeAppdownloadMessag)	Boolean	ExternalName: allowusersseeappdownloadmessage ExternalType: Boolean Description: Indicates whether the showing tablet application notification bars in a browser is allowed.
195	SignupOutlookDownloadFWLink (SignupOutlookDownloadFWLink)	Text200	ExternalName: signupoutlookdownloadfwlink ExternalType: String Description: CRM for Outlook Download URL
196	CascadeStatusUpdate (CascadeStatusUpdate)	Boolean	ExternalName: cascadestatusupdate ExternalType: Boolean Description: Flag to cascade Update on incident.
197	RestrictStatusUpdate (RestrictStatusUpdate)	Boolean	ExternalName: restrictstatusupdate ExternalType: Boolean Description: Flag to restrict Update on incident.
198	SuppressSLA (SuppressSLA)	Boolean	ExternalName: suppresssla ExternalType: Boolean Description: Indicates whether SLA is suppressed.
199	SocialInsightsTermsAccepted (SocialInsightsTermsAccepted)	Boolean	ExternalName: socialinsightstermsaccepted ExternalType: Boolean ExternalAccess: Modify Description: Flag for whether the organization has accepted the Social Insights terms of use.
200	SocialInsightsInstance (SocialInsightsInstance)	Text250	ExternalName: socialinsightsinstance ExternalType: String Description: Identifier for the Social Insights instance for the organization.
201	DisableSocialCare (DisableSocialCare)	Boolean	ExternalName: disablesocialcare ExternalType: Boolean Description: Indicates whether Social Care is disabled.
202	MaxProductsInBundle (MaxProductsInBundle)	Integer	ExternalName: maxproductsinbundle ExternalType: Integer Description: Restrict the maximum no of items in a bundle
203	UseInbuiltRuleForDefaultPricel (UseInbuiltRuleForDefaultPricel)	Boolean	ExternalName: useinbuiltrulefordefaultpricelistselection ExternalType: Boolean Description: Flag indicates whether to Use Inbuilt Rule For DefaultPricelist.
204	OOBPriceCalculationEnabled (OOBPriceCalculationEnabled)	Boolean	ExternalName: oobpricecalculationenabled ExternalType: Boolean Description: Enable OOB pricing calculation logic for Opportunity, Quote, Order and Invoice entities.
205	IsHierarchicalSecurityModelEna (IsHierarchicalSecurityModelEna)	Boolean	ExternalName: ishierarchicalsecuritymodelenabled ExternalType: Boolean Description: Enable Hierarchical Security Model
206	MaximumDynamicPropertiesAllowe (MaximumDynamicPropertiesAllowe)	Integer	ExternalName: maximumdynamicpropertiesallowed ExternalType: Integer Description: Restrict the maximum number of product properties for a product family/bundle
207	UsePositionHierarchy (UsePositionHierarchy)	Boolean	ExternalName: usepositionhierarchy ExternalType: Boolean Description: Use position hierarchy
208	MaxDepthForHierarchicalSecurit (MaxDepthForHierarchicalSecurit)	Integer	ExternalName: maxdepthforhierarchicalsecuritymodel ExternalType: Integer Description: Maximum depth for hierarchy security propagation.
209	SlaPauseStates (SlaPauseStates)	Text250	ExternalName: slapausestates ExternalType: String Description: Contains the on hold case status values.
210	SocialInsightsEnabled (SocialInsightsEnabled)	Boolean	ExternalName: socialinsightsenabled ExternalType: Boolean ExternalAccess: Modify Description: Flag for whether the organization is using Social Insights.
211	IsAppointmentAttachmentSyncEna (IsAppointmentAttachmentSyncEna)	Boolean	ExternalName: isappointmentattachmentsyncenabled ExternalType: Boolean Description: Enable or disable attachments sync for outlook and exchange.
212	IsAssignedTasksSyncEnabled (IsAssignedTasksSyncEnabled)	Boolean	ExternalName: isassignedtaskssyncenabled ExternalType: Boolean Description: Enable or disable assigned tasks sync for outlook and exchange.
213	IsContactMailingAddressSyncEna (IsContactMailingAddressSyncEna)	Boolean	ExternalName: iscontactmailingaddresssyncenabled ExternalType: Boolean Description: Enable or disable mailing address sync for outlook and exchange.
214	MaxSupportedInternetExplorerVe (MaxSupportedInternetExplorerVe)	Integer	ExternalName: maxsupportedinternetexplorerversion ExternalType: Integer ExternalAccess: Read Description: The maximum version of IE to run browser emulation for in Outlook client
215	GlobalHelpUrl (GlobalHelpUrl)	Text250	ExternalName: globalhelpurl ExternalType: String Description: URL for the web page global help.
216	GlobalHelpUrlEnabled (GlobalHelpUrlEnabled)	Boolean	ExternalName: globalhelpurlenabled ExternalType: Boolean Description: Indicates whether the customizable global help is enabled.
217	GlobalAppendUrlParametersEnabl (GlobalAppendUrlParametersEnabl)	Boolean	ExternalName: globalappendurlparametersenabled ExternalType: Boolean Description: Indicates whether the append URL parameters is enabled.
218	KMSettings (KMSettings)	Text250	ExternalName: kmsettings ExternalType: String Description: XML string containing the Knowledge Management settings that are applied in Knowledge Management Wizard.
219	MobileClientMashupEnabled (MobileClientMashupEnabled)	Boolean	ExternalName: mobileclientmashupenabled ExternalType: Boolean Description: Indicates whether the mobile client mashup is enabled.
220	CreateProductsWithoutParentInA (CreateProductsWithoutParentInA)	Boolean	ExternalName: createproductswithoutparentinactivestate ExternalType: Boolean Description: Enable Initial state of newly created products to be Active instead of Draft
221	IsMailboxInactiveBackoffEnable (IsMailboxInactiveBackoffEnable)	Boolean	ExternalName: ismailboxinactivebackoffenabled ExternalType: Boolean Description: Enable or disable mailbox keep alive for Server Side Sync.
222	IsFullTextSearchEnabled (IsFullTextSearchEnabled)	Boolean	ExternalName: isfulltextsearchenabled ExternalType: Boolean Description: Indicates whether full-text search for Quick Find entities should be enabled for the organization.
223	EnforceReadOnlyPlugins (EnforceReadOnlyPlugins)	Boolean	ExternalName: enforcereadonlyplugins ExternalType: Boolean Description: Organization setting to enforce read only plugins.
224	SharePointDeploymentType (SharePointDeploymentType)	Option	[Online,On-Premises] OptionOrdinalValues: [0;1] InitValue: Online ExternalName: sharepointdeploymenttype ExternalType: Picklist Description: Indicates which SharePoint deployment type is configured for Server to Server. (Online or On-Premises)
225	DefaultThemeData (DefaultThemeData)	BLOB [Memo]	ExternalName: defaultthemedata ExternalType: Memo Description: Default theme data for the organization.
226	IsFolderBasedTrackingEnabled (IsFolderBasedTrackingEnabled)	Boolean	ExternalName: isfolderbasedtrackingenabled ExternalType: Boolean Description: Enable or disable folder based tracking for Server Side Sync.
227	WebResourceHash (WebResourceHash)	Text100	ExternalName: webresourcehash ExternalType: String Description: Hash value of web resources.
228	ExpireChangeTrackingInDays (ExpireChangeTrackingInDays)	Integer	MaxValue: 365 ExternalName: expirechangetrackingindays ExternalType: Integer Description: Maximum number of days to keep change tracking deleted records
229	MaxFolderBasedTrackingMappings (MaxFolderBasedTrackingMappings)	Integer	MinValue: 1 MaxValue: 25 ExternalName: maxfolderbasedtrackingmappings ExternalType: Integer Description: Maximum number of Folder Based Tracking mappings user can add
230	PrivacyStatementUrl (PrivacyStatementUrl)	Text250	ExternalName: privacystatementurl ExternalType: String Description: Privacy Statement URL
231	PluginTraceLogSetting (PluginTraceLogSetting)	Option	[Off,Exception,All] OptionOrdinalValues: [0;1;2] InitValue: Off ExternalName: plugintracelogsetting ExternalType: Picklist Description: Plug-in Trace Log Setting for the Organization.
232	IsMailboxForcedUnlockingEnable (IsMailboxForcedUnlockingEnable)	Boolean	ExternalName: ismailboxforcedunlockingenabled ExternalType: Boolean Description: Enable or disable forced unlocking for Server Side Sync mailboxes.
233	MailboxIntermittentIssueMinRan (MailboxIntermittentIssueMinRan)	Integer	ExternalName: mailboxintermittentissueminrange ExternalType: Integer Description: Lower Threshold For Mailbox Intermittent Issue.
234	MailboxPermanentIssueMinRange (MailboxPermanentIssueMinRange)	Integer	ExternalName: mailboxpermanentissueminrange ExternalType: Integer Description: Lower Threshold For Mailbox Permanent Issue.
235	HighContrastThemeData (HighContrastThemeData)	BLOB [Memo]	ExternalName: highcontrastthemedata ExternalType: Memo Description: High contrast theme data for the organization.
236	DelegatedAdminUserId (DelegatedAdminUserId)	GUID	ExternalName: delegatedadminuserid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the delegated admin user for the organization.
237	IsEmailServerProfileContentFil (IsEmailServerProfileContentFil)	Boolean	ExternalName: isemailserverprofilecontentfilteringenabled ExternalType: Boolean Description: Enable Email Server Profile content filtering
238	IsDelegateAccessEnabled (IsDelegateAccessEnabled)	Boolean	ExternalName: isdelegateaccessenabled ExternalType: Boolean Description: Enable Delegation Access content
239	DisplayNavigationTour (DisplayNavigationTour)	Boolean	ExternalName: displaynavigationtour ExternalType: Boolean Description: Indicates whether or not navigation tour is displayed.
240	UseLegacyRendering (UseLegacyRendering)	Boolean	ExternalName: uselegacyrendering ExternalType: Boolean Description: Select whether to use legacy form rendering.

Keys

#	Fields
0	OrganizationId (OrganizationId)		Clustered: Yes
1	Name (Name)

Table Relations To Other Tables

Field	Related Table	Related Field
ModifiedOnBehalfBy (ModifiedOnBehalfBy)	CRM Systemuser	SystemUserId (SystemUserId)	TableRelation: "CRM Systemuser".SystemUserId	1..n
BaseCurrencyId (BaseCurrencyId)	CRM Transactioncurrency	TransactionCurrencyId (TransactionCurrencyId)	TableRelation: "CRM Transactioncurrency".TransactionCurrencyId	1..n

Table Relations From Other Tables

From Table	From Field
CRM Account Statistics	OrganizationId (OrganizationId)	TableRelation: "CRM Organization".OrganizationId	1..n
CRM Businessunit	OrganizationId (OrganizationId)	TableRelation: "CRM Organization".OrganizationId	1..n
CRM Discounttype	OrganizationId (OrganizationId)	TableRelation: "CRM Organization".OrganizationId	1..n
CRM NAV Connection	OrganizationId (OrganizationId)	TableRelation: "CRM Organization".OrganizationId	1..n
CRM Post	RegardingObjectId (RegardingObjectId)	TableRelation: IF (RegardingObjectTypeCode=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (RegardingObjectTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (RegardingObjectTypeCode=CONST(contact)) "CRM Contact".ContactId ELSE IF (RegardingObjectTypeCode=CONST(opportunity)) "CRM Opportunity".OpportunityId ELSE IF (RegardingObjectTypeCode=CONST(post)) "CRM Post".PostId ELSE IF (RegardingObjectTypeCode=CONST(transactioncurrency)) "CRM Transactioncurrency".TransactionCurrencyId ELSE IF (RegardingObjectTypeCode=CONST(pricelevel)) "CRM Pricelevel".PriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(productpricelevel)) "CRM Productpricelevel".ProductPriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(product)) "CRM Product".ProductId ELSE IF (RegardingObjectTypeCode=CONST(incident)) "CRM Incident".IncidentId ELSE IF (RegardingObjectTypeCode=CONST(incidentresolution)) "CRM Incidentresolution".ActivityId ELSE IF (RegardingObjectTypeCode=CONST(quote)) "CRM Quote".QuoteId ELSE IF (RegardingObjectTypeCode=CONST(quotedetail)) "CRM Quotedetail".QuoteDetailId ELSE IF (RegardingObjectTypeCode=CONST(salesorder)) "CRM Salesorder".SalesOrderId ELSE IF (RegardingObjectTypeCode=CONST(salesorderdetail)) "CRM Salesorderdetail".SalesOrderDetailId ELSE IF (RegardingObjectTypeCode=CONST(invoice)) "CRM Invoice".InvoiceId ELSE IF (RegardingObjectTypeCode=CONST(invoicedetail)) "CRM Invoicedetail".InvoiceDetailId ELSE IF (RegardingObjectTypeCode=CONST(contract)) "CRM Contract".ContractId ELSE IF (RegardingObjectTypeCode=CONST(team)) "CRM Team".TeamId ELSE IF (RegardingObjectTypeCode=CONST(customeraddress)) "CRM Customeraddress".CustomerAddressId ELSE IF (RegardingObjectTypeCode=CONST(uom)) "CRM Uom".UoMId ELSE IF (RegardingObjectTypeCode=CONST(uomschedule)) "CRM Uomschedule".UoMScheduleId ELSE IF (RegardingObjectTypeCode=CONST(organization)) "CRM Organization".OrganizationId ELSE IF (RegardingObjectTypeCode=CONST(businessunit)) "CRM Businessunit".BusinessUnitId ELSE IF (RegardingObjectTypeCode=CONST(discount)) "CRM Discount".DiscountId ELSE IF (RegardingObjectTypeCode=CONST(discounttype)) "CRM Discounttype".DiscountTypeId;	1..n
CRM Pricelevel	OrganizationId (OrganizationId)	TableRelation: "CRM Organization".OrganizationId	1..n
CRM Product	OrganizationId (OrganizationId)	TableRelation: "CRM Organization".OrganizationId	1..n
CRM Transactioncurrency	OrganizationId (OrganizationId)	TableRelation: "CRM Organization".OrganizationId	1..n
CRM Uomschedule	OrganizationId (OrganizationId)	TableRelation: "CRM Organization".OrganizationId	1..n

Diagrams

Tables A-Z

a

b

c

d

e

f

g

h

i

j

l

m

n

o

p

q

r

s

t

u

v

w

x

z

Table

CRM Organization

Fields

Keys

Table Relations To Other Tables

Table Relations From Other Tables