Organization
This is a table representing the Organization entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the organization. |
| AcknowledgementTemplateId_Id | String | False |
Unique identifier of the template to be used for acknowledgement when a user unsubscribes. |
| AcknowledgementTemplateId_LogicalName | String | False | |
| AcknowledgementTemplateId_Name | String | False | |
| AllowAddressBookSyncs | Boolean | False |
Indicates whether background address book synchronization in Microsoft Office Outlook is allowed. |
| AllowAutoResponseCreation | Boolean | False |
Indicates whether automatic response creation is allowed. |
| AllowAutoUnsubscribe | Boolean | False |
Indicates whether automatic unsubscribe is allowed. |
| AllowAutoUnsubscribeAcknowledgement | Boolean | False |
Indicates whether automatic unsubscribe acknowledgement email is allowed to send. |
| AllowClientMessageBarAd | Boolean | False |
Indicates whether Outlook Client message bar advertisement is allowed. |
| AllowEntityOnlyAudit | Boolean | False |
Indicates whether auditing of changes to entity is allowed when no attributes have changed. |
| AllowMarketingEmailExecution | Boolean | False |
Indicates whether marketing emails execution is allowed. |
| AllowOfflineScheduledSyncs | Boolean | False |
Indicates whether background offline synchronization in Microsoft Office Outlook is allowed. |
| AllowOutlookScheduledSyncs | Boolean | False |
Indicates whether scheduled synchronizations to Outlook are allowed. |
| AllowUnresolvedPartiesOnEmailSend | Boolean | False |
Indicates whether users are allowed to send email to unresolved parties (parties must still have an email address). |
| AllowWebExcelExport | Boolean | False |
Indicates whether Web-based export of grids to Microsoft Office Excel is allowed. |
| AMDesignator | String | False |
AM designator to use throughout Microsoft Dynamics CRM. |
| BaseCurrencyId_Id | String | False |
Unique identifier of the base currency of the organization. |
| BaseCurrencyId_LogicalName | String | False | |
| BaseCurrencyId_Name | String | False | |
| BaseCurrencyPrecision | Integer | True |
Number of decimal places that can be used for the base currency. |
| BaseCurrencySymbol | String | True |
Symbol used for the base currency. |
| BlockedAttachments | String | False |
Prevent upload or download of certain attachment types that are considered dangerous. |
| BulkOperationPrefix | String | False |
Prefix used for bulk operation numbering. |
| BusinessClosureCalendarId | String | False |
Unique identifier of the business closure calendar of organization. |
| CalendarType | Integer | False |
Calendar type for the system. Set to Gregorian US by default. |
| CampaignPrefix | String | False |
Prefix used for campaign numbering. |
| CasePrefix | String | False |
Prefix to use for all cases throughout Microsoft Dynamics CRM. |
| ContractPrefix | String | False |
Prefix to use for all contracts throughout Microsoft Dynamics CRM. |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the organization. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the organization was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the organization. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| CurrencyDecimalPrecision | Integer | False |
Number of decimal places that can be used for currency. |
| CurrencyDisplayOption | String | False |
Indicates whether to display money fields with currency code or currency symbol. |
| CurrencyFormatCode | String | False |
Information about how currency symbols are placed throughout Microsoft Dynamics CRM. |
| CurrencySymbol | String | False |
Symbol used for currency throughout Microsoft Dynamics CRM. |
| CurrentBulkOperationNumber | Integer | False |
Current bulk operation number. |
| CurrentCampaignNumber | Integer | False |
Current campaign number. |
| CurrentCaseNumber | Integer | False |
First case number to use. |
| CurrentContractNumber | Integer | False |
First contract number to use. |
| CurrentImportSequenceNumber | Integer | True |
Import sequence to use. |
| CurrentInvoiceNumber | Integer | False |
First invoice number to use. |
| CurrentKbNumber | Integer | False |
First article number to use. |
| CurrentOrderNumber | Integer | False |
First order number to use. |
| CurrentParsedTableNumber | Integer | True |
First parsed table number to use. |
| CurrentQuoteNumber | Integer | False |
First quote number to use. |
| DateFormatCode | String | False |
Information about how the date is displayed throughout Microsoft CRM. |
| DateFormatString | String | False |
String showing how the date is displayed throughout Microsoft CRM. |
| DateSeparator | String | False |
Character used to separate the month, the day, and the year in dates throughout Microsoft Dynamics CRM. |
| DecimalSymbol | String | False |
Symbol used for decimal in Microsoft Dynamics CRM. |
| DefaultRecurrenceEndRangeType | String | False |
Type of default recurrence end range date. |
| DisabledReason | String | True |
Reason for disabling the organization. |
| EmailSendPollingPeriod | Integer | False |
Normal polling frequency used for sending email in Microsoft Office Outlook. |
| EnablePricingOnCreate | Boolean | False |
Enable pricing calculations on a Create call. |
| EnableSmartMatching | Boolean | False |
Use Smart Matching. |
| ExpireSubscriptionsInDays | Integer | False |
Maximum number of days before deleting inactive subscriptions. |
| FeatureSet | String | False |
Features to be enabled as an XML BLOB. |
| FiscalCalendarStart | Datetime | False |
Start date for the fiscal period that is to be used throughout Microsoft CRM. |
| FiscalPeriodFormat | String | False |
Information that specifies how the name of the fiscal period is displayed throughout Microsoft CRM. |
| FiscalPeriodFormatPeriod | String | False |
Format in which the fiscal period will be displayed. |
| FiscalPeriodType | Integer | False |
Type of fiscal period used throughout Microsoft CRM. |
| FiscalSettingsUpdated | Boolean | True |
Information that specifies whether the fiscal settings have been updated. |
| FiscalYearDisplayCode | Integer | False |
Information that specifies whether the fiscal year should be displayed based on the start date or the end date of the fiscal year. |
| FiscalYearFormat | String | False |
Information that specifies how the name of the fiscal year is displayed throughout Microsoft CRM. |
| FiscalYearFormatPrefix | String | False |
Prefix for the display of the fiscal year. |
| FiscalYearFormatSuffix | String | False |
Suffix for the display of the fiscal year. |
| FiscalYearFormatYear | String | False |
Format for the year. |
| FiscalYearPeriodConnect | String | False |
Information that specifies how the names of the fiscal year and the fiscal period should be connected when displayed together. |
| FullNameConventionCode | String | False |
Order in which names are to be displayed throughout Microsoft CRM. |
| FutureExpansionWindow | Integer | False |
Specifies the maximum number of months in future for which the recurring activities can be created. |
| GetStartedPaneContentEnabled | Boolean | False |
Indicates whether Get Started content is enabled for this organization. |
| GoalRollupExpiryTime | Integer | False |
Number of days after the goal's end date after which the rollup of the goal stops automatically. |
| GoalRollupFrequency | Integer | False |
Number of hours between automatic rollup jobs . |
| GrantAccessToNetworkService | Boolean | False |
For internal use only. |
| HashDeltaSubjectCount | Integer | False |
Maximum difference allowed between subject keywords count of the email messaged to be correlated |
| HashFilterKeywords | String | False |
Filter Subject Keywords |
| HashMaxCount | Integer | False |
Maximum number of subject keywords or recipients used for correlation |
| HashMinAddressCount | Integer | False |
Minimum number of recipients required to match for email messaged to be correlated |
| IgnoreInternalEmail | Boolean | False |
Indicates whether incoming email sent by internal Microsoft Dynamics CRM users or queues should be tracked. |
| InitialVersion | String | False |
Initial version of the organization. |
| IntegrationUserId | String | False |
Unique identifier of the integration user for the organization. |
| InvoicePrefix | String | False |
Prefix to use for all invoice numbers throughout Microsoft Dynamics CRM. |
| IsAppMode | Boolean | False |
Indicates whether loading of Microsoft Dynamics CRM in a browser window that does not have address, tool, and menu bars is enabled. |
| IsAuditEnabled | Boolean | False |
Enable or disable auditing of changes. |
| IsDisabled | Boolean | True |
Information that specifies whether the organization is disabled. |
| IsDuplicateDetectionEnabled | Boolean | False |
Indicates whether duplicate detection of records is enabled. |
| IsDuplicateDetectionEnabledForImport | Boolean | False |
Indicates whether duplicate detection of records during import is enabled. |
| IsDuplicateDetectionEnabledForOfflineSync | Boolean | False |
Indicates whether duplicate detection of records during offline synchronization is enabled. |
| IsDuplicateDetectionEnabledForOnlineCreateUpdate | Boolean | False |
Indicates whether duplicate detection during online create or update is enabled. |
| IsFiscalPeriodMonthBased | Boolean | False |
Indicates whether the fiscal period is displayed as the month number. |
| IsPresenceEnabled | Boolean | False |
Information on whether IM presence is enabled. |
| IsRegistered | Boolean | True |
For internal use only. |
| IsSOPIntegrationEnabled | Boolean | False |
Enable sales order processing integration. |
| ISVIntegrationCode | String | False |
Indicates whether loading of Microsoft Dynamics CRM in a browser window that does not have address, tool, and menu bars is enabled. |
| KbPrefix | String | False |
Prefix to use for all articles in Microsoft Dynamics CRM. |
| LanguageCode | Integer | False |
Preferred language for the organization. |
| LocaleId | Integer | False |
Unique identifier of the locale of the organization. |
| LongDateFormatCode | Integer | False |
Information that specifies how the Long Date format is displayed in Microsoft Dynamics CRM. |
| MaxAppointmentDurationDays | Integer | False |
Maximum number of days an appointment can last. |
| MaximumTrackingNumber | Integer | False |
Maximum tracking number before recycling takes place. |
| MaxRecordsForExportToExcel | Integer | False |
Maximum number of records that will be exported to a static Microsoft Office Excel worksheet when exporting from the grid. |
| MaxRecordsForLookupFilters | Integer | False |
Maximum number of lookup and picklist records that can be selected by user for filtering. |
| MaxUploadFileSize | Integer | False |
Maximum allowed size of an attachment. |
| MinAddressBookSyncInterval | Integer | False |
Normal polling frequency used for address book synchronization in Microsoft Office Outlook. |
| MinOfflineSyncInterval | Integer | False |
Normal polling frequency used for background offline synchronization in Microsoft Office Outlook. |
| MinOutlookSyncInterval | Integer | False |
Minimum allowed time between scheduled Outlook synchronizations. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the organization. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the organization was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the organization. |
| ModifiedOnBehalfBy_LogicalName | String | True | |
| ModifiedOnBehalfBy_Name | String | True | |
| Name | String | False |
Name of the organization. The name is set when Microsoft CRM is installed and should not be changed. |
| NegativeCurrencyFormatCode | Integer | False |
Information that specifies how negative currency numbers are displayed throughout Microsoft Dynamics CRM. |
| NegativeFormatCode | String | False |
Information that specifies how negative numbers are displayed throughout Microsoft CRM. |
| NextTrackingNumber | Integer | False |
Next token to be placed on the subject line of an email message. |
| NumberFormat | String | False |
Specification of how numbers are displayed throughout Microsoft CRM. |
| NumberGroupFormat | String | False |
Specifies how numbers are grouped in Microsoft Dynamics CRM. |
| NumberSeparator | String | False |
Symbol used for number separation in Microsoft Dynamics CRM. |
| OrderPrefix | String | False |
Prefix to use for all orders throughout Microsoft Dynamics CRM. |
| OrganizationId | String | True |
Unique identifier of the organization. |
| OrgDbOrgSettings | String | False |
Organization settings stored in Organization Database. |
| ParsedTableColumnPrefix | String | True |
Prefix used for parsed table columns. |
| ParsedTablePrefix | String | True |
Prefix used for parsed tables. |
| PastExpansionWindow | Integer | False |
Specifies the maximum number of months in past for which the recurring activities can be created. |
| Picture | String | False |
For internal use only. |
| PinpointLanguageCode | Integer | False | |
| PMDesignator | String | False |
PM designator to use throughout Microsoft Dynamics CRM. |
| PricingDecimalPrecision | Integer | False |
Number of decimal places that can be used for prices. |
| PrivilegeUserGroupId | String | False |
Unique identifier of the default privilege for users in the organization. |
| PrivReportingGroupId | String | False |
For internal use only. |
| PrivReportingGroupName | String | False |
For internal use only. |
| QuotePrefix | String | False |
Prefix to use for all quotes throughout Microsoft Dynamics CRM. |
| RecurrenceDefaultNumberOfOccurrences | Integer | False |
Specifies the default value for number of occurrences field in the recurrence dialog. |
| RecurrenceExpansionJobBatchInterval | Integer | False |
Specifies the interval (in seconds) for pausing expansion job. |
| RecurrenceExpansionJobBatchSize | Integer | False |
Specifies the value for number of instances created in on demand job in one shot. |
| RecurrenceExpansionSynchCreateMax | Integer | False |
Specifies the maximum number of instances to be created synchronously after creating a recurring appointment. |
| ReferenceSiteMapXml | String | False |
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. |
| RenderSecureIFrameForEmail | Boolean | False |
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. |
| ReportingGroupId | String | False |
For internal use only. |
| ReportingGroupName | String | False |
For internal use only. |
| ReportScriptErrors | String | False |
Picklist for selecting the organization preference for reporting scripting errors. |
| RequireApprovalForQueueEmail | Boolean | False |
Indicates whether Send As Other User privilege is enabled. |
| RequireApprovalForUserEmail | Boolean | False |
Indicates whether Send As Other User privilege is enabled. |
| SampleDataImportId | String | False |
Unique identifier of the sample data import job. |
| SchemaNamePrefix | String | False |
Prefix used for custom entities and attributes. |
| ShareToPreviousOwnerOnAssign | Boolean | False |
Information that specifies whether to share to previous owner on assign. |
| ShowWeekNumber | Boolean | False |
Information that specifies whether to display the week number in calendar displays throughout Microsoft CRM. |
| SiteMapXml | String | False |
XML string that defines the navigation structure for the application. |
| SortId | Integer | False |
For internal use only. |
| SqlAccessGroupId | String | False |
For internal use only. |
| SqlAccessGroupName | String | False |
For internal use only. |
| SQMEnabled | Boolean | False |
Setting for SQM data collection, 0 no, 1 yes enabled |
| SupportUserId | String | False |
Unique identifier of the support user for the organization. |
| SystemUserId | String | False |
Unique identifier of the system user for the organization. |
| TagMaxAggressiveCycles | Integer | False |
Maximum number of aggressive polling cycles executed for email auto-tagging when a new email is received. |
| TagPollingPeriod | Integer | False |
Normal polling frequency used for email receive auto-tagging in outlook. |
| TimeFormatCode | String | False |
Information that specifies how the time is displayed throughout Microsoft CRM. |
| TimeFormatString | String | False |
Text for how time is displayed in Microsoft Dynamics CRM. |
| TimeSeparator | String | False |
Text for how the time separator is displayed throughout Microsoft Dynamics CRM. |
| TimeZoneRuleVersionNumber | Integer | False |
For internal use only. |
| TokenExpiry | Integer | False |
Duration used for token expiration. |
| TrackingPrefix | String | False |
History list of tracking token prefixes. |
| TrackingTokenIdBase | Integer | False |
Base number used to provide separate tracking token identifiers to users belonging to different deployments. |
| TrackingTokenIdDigits | Integer | False |
Number of digits used to represent a tracking token identifier. |
| UniqueSpecifierLength | Integer | False |
Number of characters appended to invoice, quote, and order numbers. |
| UserGroupId | String | False |
Unique identifier of the default group of users in the organization. |
| UTCConversionTimeZoneCode | Integer | False |
Time zone code that was in use when the record was created. |
| V3CalloutConfigHash | String | True |
Hash of the V3 callout configuration file. |
| WeekStartDayCode | String | False |
Designated first day of the week throughout Microsoft Dynamics CRM. |
| YearStartWeekCode | Integer | False |
Information that specifies how the first week of the year is specified in Microsoft Dynamics CRM. |