JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462