DynamicsDocs.com

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

Keys

#	Fields
0	OrganizationId		Clustered: Yes
1	Name

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table	From Field
CRM Account Statistics	OrganizationId	TableRelation: "CRM Organization".OrganizationId	1..n
CRM Businessunit	OrganizationId	TableRelation: "CRM Organization".OrganizationId	1..n
CRM Discounttype	OrganizationId	TableRelation: "CRM Organization".OrganizationId	1..n
CRM NAV Connection	OrganizationId	TableRelation: "CRM Organization".OrganizationId	1..n
CRM Post	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	TableRelation: "CRM Organization".OrganizationId	1..n
CRM Product	OrganizationId	TableRelation: "CRM Organization".OrganizationId	1..n
CRM Transactioncurrency	OrganizationId	TableRelation: "CRM Organization".OrganizationId	1..n
CRM Uomschedule	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