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. |