This topic has not yet been rated - Rate this topic

Organization Entity Metadata

[Applies to: Microsoft Dynamics CRM 2011 and Microsoft Dynamics CRM Online]

The following information is for the organization entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is Organization.

In This Topic

Entity Metadata

Privilege Metadata

Attribute Metadata

One-to-Many Relationships

Many-to-Many Relationships

Many-to-One Relationships

Entity Metadata

The following table shows the metadata for the organization entity.

Metadata property	Value
OTC	1019
EntityLogicalName	organization
DisplayName	Organization
OwnershipType	OrganizationOwned
IsCustomizable	True
Description	Top level of the Microsoft Dynamics CRM business hierarchy. The organization can be a specific business, holding company, or corporation.
IsAvailableOffline	True
IsAuditEnabled	False
AutoRouteToOwnerQueue	False
CanBeInManyToMany	False
CanBePrimaryEntityInRelationship	False
CanBeRelatedEntityInRelationship	False
CanCreateAttributes	False
CanCreateCharts	False
CanCreateForms	False
CanCreateViews	False
CanModifyAdditionalSettings	True
CanTriggerWorkflow	False
IsActivity	False
IsActivityParty	False
IsChildEntity	False
IsConnectionsEnabled	canmodifyconnectionsettings
IsCustomEntity	False
IsDocumentManagementEnabled	False
IsDuplicateDetectionEnabled	False
IsEnabledForCharts	False
IsImportable	False
IsIntersect	False
IsMailMergeEnabled	False
IsManaged	True
IsMappable	False
IsReadingPaneEnabled	True
IsRenameable	False
IsValidForAdvancedFind	False
IsValidForQueue	False
IsVisibleInMobile	False
PrimaryIdAttribute	organizationid
PrimaryNameAttribute	name
ReportViewName	FilteredOrganization
RecurrenceBaseEntityLogicalName
DisplayCollectionName	Organizations

Privilege Metadata

The following table shows the privilege metadata for the organization entity.

PrivilegeName	Id	Type	CanBeBasic	CanBeDeep	CanBeGlobal	CanBeLocal
prvAppendToOrganization	e7753b34-17f3-400e-8396-88e24b8dc519	AppendTo	False	False	True	False
prvReadOrganization	dbd3ad17-b6bd-46c8-8db7-179fec82c937	Read	False	False	True	False
prvWriteOrganization	9f7b7e89-e5f6-41fd-8390-f06a7ec66d25	Write	False	False	True	False

Attribute Metadata

The following table shows the attribute metadata for the organization entity. For a list of attributes that are for internal use only, see Internal Attributes.

LogicalName	Description	Type	SchemaName	IsCustomAttribute	IsCustomizable	RequiredLevel	IsValidForCreate	IsValidForRead	IsValidForUpdate	CanBeSecuredForCreate	CanBeSecuredForRead	CanBeSecuredForUpdate	IsAuditEnabled	IsManaged	IsPrimaryId	IsPrimaryName	IsRenameable	IsSecured	IsValidForAdvancedFind	DisplayName	DeprecatedVersion
acknowledgementtemplateid	Unique identifier of the template to be used for acknowledgement when a user unsubscribes.	Lookup	AcknowledgementTemplateId	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Acknowledgement Template
allowaddressbooksyncs	Indicates whether background address book synchronization in Microsoft Office Outlook is allowed.	Boolean	AllowAddressBookSyncs	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Allow Address Book Synchronization
allowautoresponsecreation	Indicates whether automatic response creation is allowed.	Boolean	AllowAutoResponseCreation	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Allow Automatic Response Creation
allowautounsubscribe	Indicates whether automatic unsubscribe is allowed.	Boolean	AllowAutoUnsubscribe	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Allow Automatic Unsubscribe
allowautounsubscribeacknowledgement	Indicates whether automatic unsubscribe acknowledgement e-mail is allowed to send.	Boolean	AllowAutoUnsubscribeAcknowledgement	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Allow Automatic Unsubscribe Acknowledgement
allowclientmessagebarad	Indicates whether Outlook Client message bar advertisement is allowed.	Boolean	AllowClientMessageBarAd	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	True	False	False	Allow Outlook Client Message Bar Advertisement
allowentityonlyaudit	Indicates whether auditing of changes to entity is allowed when no attributes have changed.	Boolean	AllowEntityOnlyAudit	False	True	SystemRequired	True	True	False	False	False	False	True	True	False	False	False	False	False	Allow Entity Level Auditing
allowmarketingemailexecution	Indicates whether marketing e-mails execution is allowed.	Boolean	AllowMarketingEmailExecution	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Allow Marketing E-mail Execution
allowofflinescheduledsyncs	Indicates whether background offline synchronization in Microsoft Office Outlook is allowed.	Boolean	AllowOfflineScheduledSyncs	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Allow Offline Scheduled Synchronization
allowoutlookscheduledsyncs	Indicates whether scheduled synchronizations to Outlook are allowed.	Boolean	AllowOutlookScheduledSyncs	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Allow Scheduled Synchronization
allowunresolvedpartiesonemailsend	Indicates whether users are allowed to send e-mail to unresolved parties (parties must still have an e-mail address).	Boolean	AllowUnresolvedPartiesOnEmailSend	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Allow Unresolved Address E-mail Send
allowuserformmodepreference	Indicates whether individuals can select their form mode preference in their personal options.	Boolean	AllowUserFormModePreference	False	False	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Allow User Form Mode Preference
allowwebexcelexport	Indicates whether Web-based export of grids to Microsoft Office Excel is allowed.	Boolean	AllowWebExcelExport	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Allow Export to Excel
amdesignator	AM designator to use throughout Microsoft Dynamics CRM.	String	AMDesignator	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	AM Designator
basecurrencyid	Unique identifier of the base currency of the organization.	Lookup	BaseCurrencyId	False	True	None	True	True	False	False	False	False	True	True	False	False	False	False	True	Currency
basecurrencyprecision	Number of decimal places that can be used for the base currency.	Integer	BaseCurrencyPrecision	False	True	SystemRequired	False	True	False	False	False	False	True	True	False	False	False	False	False	Base Currency Precision
basecurrencysymbol	Symbol used for the base currency.	String	BaseCurrencySymbol	False	True	SystemRequired	False	True	False	False	False	False	True	True	False	False	False	False	False	Base Currency Symbol
baseisocurrencycode		String	BaseISOCurrencyCode	False	True	SystemRequired	False	False	False	False	False	False	True	True	False	False	False	False	False	Base ISO Currency Code
blockedattachments	Prevent upload or download of certain attachment types that are considered dangerous.	String	BlockedAttachments	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Block Attachments
bulkoperationprefix	Prefix used for bulk operation numbering.	String	BulkOperationPrefix	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Bulk Operation Prefix
businessclosurecalendarid	Unique identifier of the business closure calendar of organization.	Uniqueidentifier	BusinessClosureCalendarId	False	False	None	True	True	False	False	False	False	False	True	False	False	False	False	False	Business Closure Calendar
calendartype	Calendar type for the system. Set to Gregorian US by default.	Integer	CalendarType	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Calendar Type
campaignprefix	Prefix used for campaign numbering.	String	CampaignPrefix	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Campaign Prefix
caseprefix	Prefix to use for all cases throughout Microsoft Dynamics CRM.	String	CasePrefix	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Case Prefix
contractprefix	Prefix to use for all contracts throughout Microsoft Dynamics CRM.	String	ContractPrefix	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Contract Prefix
createdby	Unique identifier of the user who created the organization.	Lookup	CreatedBy	False	False	None	False	True	False	False	False	False	False	True	False	False	False	False	False	Created By
createdon	Date and time when the organization was created.	DateTime	CreatedOn	False	False	None	False	True	False	False	False	False	False	True	False	False	False	False	False	Created On
createdonbehalfby	Unique identifier of the delegate user who created the organization.	Lookup	CreatedOnBehalfBy	False	True	None	False	True	False	False	False	False	False	True	False	False	False	False	False	Created By (Delegate)
currencydecimalprecision	Number of decimal places that can be used for currency.	Integer	CurrencyDecimalPrecision	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Currency Decimal Precision
currencydisplayoption	Indicates whether to display money fields with currency code or currency symbol.	Picklist	CurrencyDisplayOption	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Display Currencies Using
currencyformatcode	Information about how currency symbols are placed throughout Microsoft Dynamics CRM.	Picklist	CurrencyFormatCode	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Currency Format Code
currencysymbol	Symbol used for currency throughout Microsoft Dynamics CRM.	String	CurrencySymbol	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Currency Symbol
currentbulkoperationnumber	Current bulk operation number.	Integer	CurrentBulkOperationNumber	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Current Bulk Operation Number
currentcampaignnumber	Current campaign number.	Integer	CurrentCampaignNumber	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Current Campaign Number
currentcasenumber	First case number to use.	Integer	CurrentCaseNumber	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Current Case Number
currentcontractnumber	First contract number to use.	Integer	CurrentContractNumber	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Current Contract Number
currentimportsequencenumber	Import sequence to use.	Integer	CurrentImportSequenceNumber	False	True	SystemRequired	False	True	False	False	False	False	True	True	False	False	False	False	False	Current Import Sequence Number
currentinvoicenumber	First invoice number to use.	Integer	CurrentInvoiceNumber	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Current Invoice Number
currentkbnumber	First article number to use.	Integer	CurrentKbNumber	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Current Article Number
currentordernumber	First order number to use.	Integer	CurrentOrderNumber	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Current Order Number
currentparsedtablenumber	First parsed table number to use.	Integer	CurrentParsedTableNumber	False	True	SystemRequired	False	True	False	False	False	False	True	True	False	False	False	False	False	Current Parsed Table Number
currentquotenumber	First quote number to use.	Integer	CurrentQuoteNumber	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Current Quote Number
dateformatcode	Information about how the date is displayed throughout Microsoft CRM.	Picklist	DateFormatCode	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Date Format Code
dateformatstring	String showing how the date is displayed throughout Microsoft CRM.	String	DateFormatString	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Date Format String
dateseparator	Character used to separate the month, the day, and the year in dates throughout Microsoft Dynamics CRM.	String	DateSeparator	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Date Separator
decimalsymbol	Symbol used for decimal in Microsoft Dynamics CRM.	String	DecimalSymbol	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Decimal Symbol
defaultcountrycode	Text area to enter default country code.	String	DefaultCountryCode	False	False	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Default Country Code
defaultrecurrenceendrangetype	Type of default recurrence end range date.	Picklist	DefaultRecurrenceEndRangeType	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Default Recurrence End Range Type
disabledreason	Reason for disabling the organization.	String	DisabledReason	False	True	None	False	True	False	False	False	False	True	True	False	False	False	False	False	Disabled Reason
emailsendpollingperiod	Normal polling frequency used for sending e-mail in Microsoft Office Outlook.	Integer	EmailSendPollingPeriod	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	E-mail Send Polling Frequency
enablebingmapsintegration	Enable Integration with Bing Maps	Boolean	EnableBingMapsIntegration	False	False	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Enable Integration with Bing Maps
enablepricingoncreate	Enable pricing calculations on a Create call.	Boolean	EnablePricingOnCreate	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Enable Pricing On Create
enablesmartmatching	Use Smart Matching.	Boolean	EnableSmartMatching	False	False	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Enable Smart Matching
expiresubscriptionsindays	Maximum number of days before deleting inactive subscriptions.	Integer	ExpireSubscriptionsInDays	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Days to Expire Subscriptions
featureset	Features to be enabled as an XML BLOB.	String	FeatureSet	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Feature Set
fiscalcalendarstart	Start date for the fiscal period that is to be used throughout Microsoft CRM.	DateTime	FiscalCalendarStart	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Fiscal Calendar Start
fiscalperiodformat	Information that specifies how the name of the fiscal period is displayed throughout Microsoft CRM.	String	FiscalPeriodFormat	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Fiscal Period Format
fiscalperiodformatperiod	Format in which the fiscal period will be displayed.	Picklist	FiscalPeriodFormatPeriod	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Format for Fiscal Period
fiscalperiodtype	Type of fiscal period used throughout Microsoft CRM.	Integer	FiscalPeriodType	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Fiscal Period Type
fiscalsettingsupdated	Information that specifies whether the fiscal settings have been updated.	Boolean	FiscalSettingsUpdated	False	True	SystemRequired	False	True	False	False	False	False	True	True	False	False	False	False	False	Is Fiscal Settings Updated	5.0.0.0
fiscalyeardisplaycode	Information that specifies whether the fiscal year should be displayed based on the start date or the end date of the fiscal year.	Integer	FiscalYearDisplayCode	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Fiscal Year Display
fiscalyearformat	Information that specifies how the name of the fiscal year is displayed throughout Microsoft CRM.	String	FiscalYearFormat	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Fiscal Year Format
fiscalyearformatprefix	Prefix for the display of the fiscal year.	Picklist	FiscalYearFormatPrefix	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Prefix for Fiscal Year
fiscalyearformatsuffix	Suffix for the display of the fiscal year.	Picklist	FiscalYearFormatSuffix	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Suffix for Fiscal Year
fiscalyearformatyear	Format for the year.	Picklist	FiscalYearFormatYear	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Fiscal Year Format Year
fiscalyearperiodconnect	Information that specifies how the names of the fiscal year and the fiscal period should be connected when displayed together.	String	FiscalYearPeriodConnect	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Fiscal Year Period Connector
fullnameconventioncode	Order in which names are to be displayed throughout Microsoft CRM.	Picklist	FullNameConventionCode	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Full Name Display Order
futureexpansionwindow	Specifies the maximum number of months in future for which the recurring activities can be created.	Integer	FutureExpansionWindow	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Future Expansion Window
getstartedpanecontentenabled	Indicates whether Get Started content is enabled for this organization.	Boolean	GetStartedPaneContentEnabled	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Is Get Started Pane Content Enabled
goalrollupexpirytime	Number of days after the goal's end date after which the rollup of the goal stops automatically.	Integer	GoalRollupExpiryTime	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Rollup Expiration Time for Goal
goalrollupfrequency	Number of hours between automatic rollup jobs .	Integer	GoalRollupFrequency	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Automatic Rollup Frequency for Goal
grantaccesstonetworkservice	For internal use only.	Boolean	GrantAccessToNetworkService	False	True	None	True	True	False	False	False	False	False	True	False	False	False	False	False	Grant Access To Network Service
hashdeltasubjectcount	Maximum difference allowed between subject keywords count of the e-mail messaged to be correlated	Integer	HashDeltaSubjectCount	False	False	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Hash Delta Subject Count
hashfilterkeywords	Filter Subject Keywords	String	HashFilterKeywords	False	False	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Hash Filter Keywords
hashmaxcount	Maximum number of subject keywords or recipients used for correlation	Integer	HashMaxCount	False	False	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Hash Max Count
hashminaddresscount	Minimum number of recipients required to match for e-mail messaged to be correlated	Integer	HashMinAddressCount	False	False	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Hash Min Address Count
ignoreinternalemail	Indicates whether incoming e-mail sent by internal Microsoft Dynamics CRM users or queues should be tracked.	Boolean	IgnoreInternalEmail	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Ignore Internal E-mail
initialversion	Initial version of the organization.	String	InitialVersion	False	True	None	True	True	False	False	False	False	True	True	False	False	False	False	False	Initial Version
integrationuserid	Unique identifier of the integration user for the organization.	Uniqueidentifier	IntegrationUserId	False	False	None	True	True	True	False	False	False	False	True	False	False	False	False	False	Integration User
invoiceprefix	Prefix to use for all invoice numbers throughout Microsoft Dynamics CRM.	String	InvoicePrefix	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Invoice Prefix
isappmode	Indicates whether loading of Microsoft Dynamics CRM in a browser window that does not have address, tool, and menu bars is enabled.	Boolean	IsAppMode	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Is Application Mode Enabled
isauditenabled	Enable or disable auditing of changes.	Boolean	IsAuditEnabled	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Is Auditing Enabled
isdefaultcountrycodecheckenabled	Enable or disable country code selection.	Boolean	IsDefaultCountryCodeCheckEnabled	False	False	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Enable or disable country code selection
isdisabled	Information that specifies whether the organization is disabled.	Boolean	IsDisabled	False	True	None	False	True	False	False	False	False	True	True	False	False	False	False	False	Is Organization Disabled
isduplicatedetectionenabled	Indicates whether duplicate detection of records is enabled.	Boolean	IsDuplicateDetectionEnabled	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Is Duplicate Detection Enabled
isduplicatedetectionenabledforimport	Indicates whether duplicate detection of records during import is enabled.	Boolean	IsDuplicateDetectionEnabledForImport	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Is Duplicate Detection Enabled For Import
isduplicatedetectionenabledforofflinesync	Indicates whether duplicate detection of records during offline synchronization is enabled.	Boolean	IsDuplicateDetectionEnabledForOfflineSync	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Is Duplicate Detection Enabled For Offline Synchronization
isduplicatedetectionenabledforonlinecreateupdate	Indicates whether duplicate detection during online create or update is enabled.	Boolean	IsDuplicateDetectionEnabledForOnlineCreateUpdate	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Is Duplicate Detection Enabled for Online Create/Update
isfiscalperiodmonthbased	Indicates whether the fiscal period is displayed as the month number.	Boolean	IsFiscalPeriodMonthBased	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Is Fiscal Period Monthly
ispresenceenabled	Information on whether IM presence is enabled.	Boolean	IsPresenceEnabled	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Presence Enabled
issopintegrationenabled	Enable sales order processing integration.	Boolean	IsSOPIntegrationEnabled	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Is Sales Order Integration Enabled
isuseraccessauditenabled	Enable or disable auditing of user access.	Boolean	IsUserAccessAuditEnabled	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Is User Access Auditing Enabled
isvintegrationcode	Indicates whether loading of Microsoft Dynamics CRM in a browser window that does not have address, tool, and menu bars is enabled.	Picklist	ISVIntegrationCode	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	ISV Integration Mode	5.0.0.0
kbprefix	Prefix to use for all articles in Microsoft Dynamics CRM.	String	KbPrefix	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Article Prefix
languagecode	Preferred language for the organization.	Integer	LanguageCode	False	True	None	True	True	False	False	False	False	True	True	False	False	False	False	False	Language
localeid	Unique identifier of the locale of the organization.	Integer	LocaleId	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Locale
longdateformatcode	Information that specifies how the Long Date format is displayed in Microsoft Dynamics CRM.	Integer	LongDateFormatCode	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Long Date Format
maxappointmentdurationdays	Maximum number of days an appointment can last.	Integer	MaxAppointmentDurationDays	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Max Appointment Duration
maximumtrackingnumber	Maximum tracking number before recycling takes place.	Integer	MaximumTrackingNumber	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Max Tracking Number
maxrecordsforexporttoexcel	Maximum number of records that will be exported to a static Microsoft Office Excel worksheet when exporting from the grid.	Integer	MaxRecordsForExportToExcel	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Max Records For Excel Export
maxrecordsforlookupfilters	Maximum number of lookup and picklist records that can be selected by user for filtering.	Integer	MaxRecordsForLookupFilters	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Max Records Filter Selection
maxuploadfilesize	Maximum allowed size of an attachment.	Integer	MaxUploadFileSize	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Max Upload File Size
metadatasynclasttimeofneverexpireddeletedobjects	What is the last date/time where there are metadata tracking deleted objects that have never been outside of the expiration period.	DateTime	MetadataSyncLastTimeOfNeverExpiredDeletedObjects	False	False	None	False	False	False	False	False	False	True	True	False	False	False	False	False	The last date/time for never expired metadata tracking deleted objects
metadatasynctimestamp		BigInt	MetadataSyncTimestamp	False	False	SystemRequired	False	False	False	False	False	False	True	True	False	False	False	False	False		5.0.0.0
minaddressbooksyncinterval	Normal polling frequency used for address book synchronization in Microsoft Office Outlook.	Integer	MinAddressBookSyncInterval	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Min Address Synchronization Frequency
minofflinesyncinterval	Normal polling frequency used for background offline synchronization in Microsoft Office Outlook.	Integer	MinOfflineSyncInterval	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Min Offline Synchronization Frequency
minoutlooksyncinterval	Minimum allowed time between scheduled Outlook synchronizations.	Integer	MinOutlookSyncInterval	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Min Synchronization Frequency
modifiedby	Unique identifier of the user who last modified the organization.	Lookup	ModifiedBy	False	False	None	False	True	False	False	False	False	False	True	False	False	False	False	False	Modified By
modifiedon	Date and time when the organization was last modified.	DateTime	ModifiedOn	False	False	None	False	True	False	False	False	False	False	True	False	False	False	False	False	Modified On
modifiedonbehalfby	Unique identifier of the delegate user who last modified the organization.	Lookup	ModifiedOnBehalfBy	False	True	None	False	True	False	False	False	False	False	True	False	False	False	False	False	Modified By (Delegate)
name	Name of the organization. The name is set when Microsoft CRM is installed and should not be changed.	String	Name	False	True	SystemRequired	True	True	False	False	False	False	True	True	False	True	False	False	False	Organization Name
negativecurrencyformatcode	Information that specifies how negative currency numbers are displayed throughout Microsoft Dynamics CRM.	Integer	NegativeCurrencyFormatCode	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Negative Currency Format
negativeformatcode	Information that specifies how negative numbers are displayed throughout Microsoft CRM.	Picklist	NegativeFormatCode	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Negative Format
nextcustomobjecttypecode	Next entity type code to use for custom entities.	Integer	NextCustomObjectTypeCode	False	True	SystemRequired	False	False	False	False	False	False	True	True	False	False	False	False	False	Next Entity Type Code
nexttrackingnumber	Next token to be placed on the subject line of an e-mail message.	Integer	NextTrackingNumber	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Next Tracking Number
numberformat	Specification of how numbers are displayed throughout Microsoft CRM.	String	NumberFormat	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Number Format
numbergroupformat	Specifies how numbers are grouped in Microsoft Dynamics CRM.	String	NumberGroupFormat	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Number Grouping Format
numberseparator	Symbol used for number separation in Microsoft Dynamics CRM.	String	NumberSeparator	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Number Separator
orderprefix	Prefix to use for all orders throughout Microsoft Dynamics CRM.	String	OrderPrefix	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Order Prefix
organizationid	Unique identifier of the organization.	Uniqueidentifier	OrganizationId	False	False	SystemRequired	False	True	False	False	False	False	False	True	True	False	False	False	False	Organization
orgdborgsettings	Organization settings stored in Organization Database.	String	OrgDbOrgSettings	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False
parsedtablecolumnprefix	Prefix used for parsed table columns.	String	ParsedTableColumnPrefix	False	True	SystemRequired	False	True	False	False	False	False	True	True	False	False	False	False	False	Parsed Table Column Prefix
parsedtableprefix	Prefix used for parsed tables.	String	ParsedTablePrefix	False	True	SystemRequired	False	True	False	False	False	False	True	True	False	False	False	False	False	Parsed Table Prefix
pastexpansionwindow	Specifies the maximum number of months in past for which the recurring activities can be created.	Integer	PastExpansionWindow	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Past Expansion Window
picture	For internal use only.	Memo	Picture	False	True	None	True	True	True	False	False	False	False	True	False	False	False	False	False	Picture
pinpointlanguagecode		Integer	PinpointLanguageCode	False	True	None	False	True	True	False	False	False	True	True	False	False	False	False	False
pmdesignator	PM designator to use throughout Microsoft Dynamics CRM.	String	PMDesignator	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	PM Designator
pricingdecimalprecision	Number of decimal places that can be used for prices.	Integer	PricingDecimalPrecision	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Pricing Decimal Precision
privilegeusergroupid	Unique identifier of the default privilege for users in the organization.	Uniqueidentifier	PrivilegeUserGroupId	False	False	None	True	True	True	False	False	False	False	True	False	False	False	False	False	Privilege User Group
privreportinggroupid	For internal use only.	Uniqueidentifier	PrivReportingGroupId	False	False	None	True	True	True	False	False	False	False	True	False	False	False	False	False	Privilege Reporting Group
privreportinggroupname	For internal use only.	String	PrivReportingGroupName	False	True	None	True	True	True	False	False	False	False	True	False	False	False	False	False	Privilege Reporting Group Name
quickfindrecordlimitenabled	Indicates whether a quick find record limit should be enabled for this organization (allows for faster Quick Find queries but prevents overly broad searches).	Boolean	QuickFindRecordLimitEnabled	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Quick Find Record Limit Enabled
quoteprefix	Prefix to use for all quotes throughout Microsoft Dynamics CRM.	String	QuotePrefix	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Quote Prefix
recurrencedefaultnumberofoccurrences	Specifies the default value for number of occurrences field in the recurrence dialog.	Integer	RecurrenceDefaultNumberOfOccurrences	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Recurrence Default Number of Occurrences
recurrenceexpansionjobbatchinterval	Specifies the interval (in seconds) for pausing expansion job.	Integer	RecurrenceExpansionJobBatchInterval	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Recurrence Expansion Job Batch Interval
recurrenceexpansionjobbatchsize	Specifies the value for number of instances created in on demand job in one shot.	Integer	RecurrenceExpansionJobBatchSize	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Recurrence Expansion OnDemand Job Batch Size
recurrenceexpansionsynchcreatemax	Specifies the maximum number of instances to be created synchronously after creating a recurring appointment.	Integer	RecurrenceExpansionSynchCreateMax	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Recurrence Expansion Synchronization Create Maximum
referencesitemapxml	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.	String	ReferenceSiteMapXml	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Reference SiteMap XML	5.0.0.0
rendersecureiframeforemail	Flag to render the body of e-mail in the Web form in an IFRAME with the security='restricted' attribute set. This is additional security but can cause a credentials prompt.	Boolean	RenderSecureIFrameForEmail	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Render Secure Frame For E-mail
reportinggroupid	For internal use only.	Uniqueidentifier	ReportingGroupId	False	False	None	True	True	True	False	False	False	False	True	False	False	False	False	False	Reporting Group
reportinggroupname	For internal use only.	String	ReportingGroupName	False	True	None	True	True	True	False	False	False	False	True	False	False	False	False	False	Reporting Group Name
reportscripterrors	Picklist for selecting the organization preference for reporting scripting errors.	Picklist	ReportScriptErrors	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	True	Report Script Errors
requireapprovalforqueueemail	Indicates whether Send As Other User privilege is enabled.	Boolean	RequireApprovalForQueueEmail	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Is Approval For Queue E-mail Required
requireapprovalforuseremail	Indicates whether Send As Other User privilege is enabled.	Boolean	RequireApprovalForUserEmail	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Is Approval For User E-mail Required
sampledataimportid	Unique identifier of the sample data import job.	Uniqueidentifier	SampleDataImportId	False	False	None	True	True	True	False	False	False	False	True	False	False	False	False	False	Sample Data Import
schemanameprefix	Prefix used for custom entities and attributes.	String	SchemaNamePrefix	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Customization Name Prefix
sharetopreviousowneronassign	Information that specifies whether to share to previous owner on assign.	Boolean	ShareToPreviousOwnerOnAssign	False	True	SystemRequired	False	True	True	False	False	False	True	True	False	False	False	False	False	Share To Previous Owner On Assign
showweeknumber	Information that specifies whether to display the week number in calendar displays throughout Microsoft CRM.	Boolean	ShowWeekNumber	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Show Week Number
sitemapxml	XML string that defines the navigation structure for the application.	Memo	SiteMapXml	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	SiteMap XML	5.0.0.0
sortid	For internal use only.	Integer	SortId	False	True	None	True	True	True	False	False	False	False	True	False	False	False	False	False	Sort
sqlaccessgroupid	For internal use only.	Uniqueidentifier	SqlAccessGroupId	False	False	None	True	True	True	False	False	False	False	True	False	False	False	False	False	SQL Access Group
sqlaccessgroupname	For internal use only.	String	SqlAccessGroupName	False	True	None	True	True	True	False	False	False	False	True	False	False	False	False	False	SQL Access Group Name
sqmenabled	Setting for SQM data collection, 0 no, 1 yes enabled	Boolean	SQMEnabled	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Is SQM Enabled
supportuserid	Unique identifier of the support user for the organization.	Uniqueidentifier	SupportUserId	False	False	None	True	True	False	False	False	False	False	True	False	False	False	False	False	Support User
systemuserid	Unique identifier of the system user for the organization.	Uniqueidentifier	SystemUserId	False	False	None	True	True	True	False	False	False	False	True	False	False	False	False	False	System User
tagmaxaggressivecycles	Maximum number of aggressive polling cycles executed for e-mail auto-tagging when a new e-mail is received.	Integer	TagMaxAggressiveCycles	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Auto-Tag Max Cycles
tagpollingperiod	Normal polling frequency used for e-mail receive auto-tagging in outlook.	Integer	TagPollingPeriod	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Auto-Tag Interval
timeformatcode	Information that specifies how the time is displayed throughout Microsoft CRM.	Picklist	TimeFormatCode	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Time Format Code
timeformatstring	Text for how time is displayed in Microsoft Dynamics CRM.	String	TimeFormatString	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Time Format String
timeseparator	Text for how the time separator is displayed throughout Microsoft Dynamics CRM.	String	TimeSeparator	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Time Separator
timezoneruleversionnumber	For internal use only.	Integer	TimeZoneRuleVersionNumber	False	True	None	True	True	True	False	False	False	False	True	False	False	False	False	False	Time Zone Rule Version Number
tokenexpiry	Duration used for token expiration.	Integer	TokenExpiry	False	True	None	False	True	True	False	False	False	True	True	False	False	False	False	False	Token Expiration Duration
tokenkey	Token key.	String	TokenKey	False	True	None	False	False	True	False	False	False	True	True	False	False	False	False	False	Token Key
trackingprefix	History list of tracking token prefixes.	String	TrackingPrefix	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Tracking Prefix
trackingtokenidbase	Base number used to provide separate tracking token identifiers to users belonging to different deployments.	Integer	TrackingTokenIdBase	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Tracking Token Base
trackingtokeniddigits	Number of digits used to represent a tracking token identifier.	Integer	TrackingTokenIdDigits	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Tracking Token Digits
uniquespecifierlength	Number of characters appended to invoice, quote, and order numbers.	Integer	UniqueSpecifierLength	False	True	None	True	True	True	False	False	False	True	True	False	False	False	False	False	Unique String Length
useraccessauditinginterval	The interval at which user access is checked for auditing.	Integer	UserAccessAuditingInterval	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	User Authentication Auditing Interval
usereadform	Indicates whether the read-optimized form should be enabled for this organization.	Boolean	UseReadForm	False	False	SystemRequired	True	True	True	False	False	False	False	True	False	False	False	False	False	Use Read-Optimized Form
usergroupid	Unique identifier of the default group of users in the organization.	Uniqueidentifier	UserGroupId	False	False	None	True	True	True	False	False	False	False	True	False	False	False	False	False	User Group
utcconversiontimezonecode	Time zone code that was in use when the record was created.	Integer	UTCConversionTimeZoneCode	False	True	None	True	True	True	False	False	False	False	True	False	False	False	False	False	UTC Conversion Time Zone Code
v3calloutconfighash	Hash of the V3 callout configuration file.	String	V3CalloutConfigHash	False	True	None	False	True	False	False	False	False	True	True	False	False	False	False	False	V3 Callout Hash
versionnumber	Version number of the organization.	BigInt	VersionNumber	False	False	None	False	True	False	False	False	False	False	True	False	False	False	False	False	Version Number
weekstartdaycode	Designated first day of the week throughout Microsoft Dynamics CRM.	Picklist	WeekStartDayCode	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Week Start Day Code
yammergroupid	Denotes the Yammer group ID	Integer	YammerGroupId	False	False	None	False	False	False	False	False	False	True	True	False	False	False	False	False	Yammer Group Id
yammernetworkpermalink	Denotes the Yammer network permalink	String	YammerNetworkPermalink	False	False	None	False	False	False	False	False	False	True	True	False	False	False	False	False	Yammer Network Permalink
yammeroauthaccesstokenexpired	Denotes whether the OAuth access token for Yammer network has expired	Boolean	YammerOAuthAccessTokenExpired	False	False	None	False	False	False	False	False	False	True	True	False	False	False	False	False	Yammer OAuth access token expired
yammerpostmethod	Internal Use Only	Picklist	YammerPostMethod	False	False	None	False	False	False	False	False	False	True	True	False	False	False	False	False	Internal Use Only
yearstartweekcode	Information that specifies how the first week of the year is specified in Microsoft Dynamics CRM.	Integer	YearStartWeekCode	False	True	SystemRequired	True	True	True	False	False	False	True	True	False	False	False	False	False	Year Start Week Code

Internal Attributes

The following table contains the attributes that are intended for internal use only.

Attribute logical name
yammergroupid
yammernetworkpermalink
yammeroauthaccesstokenexpired
yammerpostmethod
yammerpostmethod

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship with the organization entity.

Relationship schema name	Referencing entity
organization_applicationfile	applicationfile
Organization_AsyncOperations	asyncoperation
organization_attributemap	attributemap
Organization_BulkDeleteFailures	bulkdeletefailure
organization_business_units	businessunit
organization_business_unit_news_articles	businessunitnewsarticle
organization_calendars	calendar
organization_competitors	competitor
organization_complexcontrols	complexcontrol
organization_connection_roles	connectionrole
organization_constraint_based_groups	constraintbasedgroup
organization_contract_templates	contracttemplate
organization_discount_types	discounttype
organization_custom_displaystrings	displaystring
organization_indexed_documents	documentindex
organization_entitymap	entitymap
organization_equipment	equipment
lk_fieldsecurityprofile_organizationid	fieldsecurityprofile
organization_importjob	importjob
organization_integration_statuses	integrationstatus
organization_isvconfigs	isvconfig
organization_kb_articles	kbarticle
organization_kb_article_templates	kbarticletemplate
organization_licenses	license
organization_metric	metric
organization_msdyn_postconfig	msdyn_postconfig
organization_msdyn_postruleconfig	msdyn_postruleconfig
organization_msdyn_wallsavedquery	msdyn_wallsavedquery
organization_pluginassembly	pluginassembly
organization_plugintype	plugintype
organization_plugintypestatistic	plugintypestatistic
organization_post	post
organization_PostComment	postcomment
organization_postlike	postlike
organization_postrole	postrole
organization_price_levels	pricelevel
lk_principalobjectattributeaccess_organizationid	principalobjectattributeaccess
organization_products	product
organization_publisher	publisher
organization_queues	queue
organization_queueitems	queueitem
organization_relationship_roles	relationshiprole
organization_resources	resource
organization_resource_groups	resourcegroup
organization_resource_specs	resourcespec
organization_ribbon_command	ribboncommand
organization_ribbon_context_group	ribboncontextgroup
organization_ribbon_customization	ribboncustomization
organization_ribbon_diff	ribbondiff
organization_ribbon_rule	ribbonrule
organization_ribbon_tab_to_command_map	ribbontabtocommandmap
organization_roles	role
organization_sales_literature	salesliterature
organization_saved_queries	savedquery
organization_saved_query_visualizations	savedqueryvisualization
organization_sdkmessage	sdkmessage
organization_sdkmessagefilter	sdkmessagefilter
organization_sdkmessagepair	sdkmessagepair
organization_sdkmessageprocessingstep	sdkmessageprocessingstep
organization_sdkmessageprocessingstepimage	sdkmessageprocessingstepimage
organization_sdkmessageprocessingstepsecureconfig	sdkmessageprocessingstepsecureconfig
organization_sdkmessagerequest	sdkmessagerequest
organization_sdkmessagerequestfield	sdkmessagerequestfield
organization_sdkmessageresponse	sdkmessageresponse
organization_sdkmessageresponsefield	sdkmessageresponsefield
organization_services	service
organization_serviceendpoint	serviceendpoint
organization_sites	site
organization_sitemap	sitemap
organization_solution	solution
organization_status_maps	statusmap
organization_string_maps	stringmap
organization_subjects	subject
organization_systemforms	systemform
organization_system_users	systemuser
organization_teams	team
organization_territories	territory
organization_transactioncurrencies	transactioncurrency
organization_uof_schedules	uomschedule
userentityinstancedata_organization	userentityinstancedata
webresource_organization	webresource
organization_webwizard	webwizard
organization_wizardaccessprivilege	wizardaccessprivilege
organization_wizardpage	wizardpage

Many-to-Many Relationships

There are no many-to-many relationships for the organization entity.

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship with the organization entity.

Relationship schema name	Referenced entity
calendar_organization	calendar
lk_organizationbase_modifiedby	systemuser
lk_organization_createdonbehalfby	systemuser
lk_organizationbase_createdby	systemuser
lk_organization_modifiedonbehalfby	systemuser
Template_Organization	template
basecurrency_organization	transactioncurrency

Community Additions

ADD

Organization Entity Metadata

In This Topic

Entity Metadata

Privilege Metadata

Attribute Metadata

Internal Attributes

One-to-Many Relationships

Many-to-Many Relationships

Many-to-One Relationships

See Also

Reference

Concepts

Community Additions