Diagrams


Table

CRM Organization

DynamicsDocs.comCRM Organization«Table 5363»CRM OrganizationOrganizationId [PK]NameUserGroupIdPrivilegeUserGroupIdRecurrenceExpansionJobBatchSizRecurrenceExpansionJobBatchIntFiscalPeriodTypeFiscalCalendarStartDateFormatCode; []TimeFormatCode; []CurrencySymbolWeekStartDayCode; []DateSeparatorFullNameConventionCode; [LastNameFirst...NegativeFormatCode; [Brackets,Dash,Das...NumberFormatIsDisabledDisabledReasonKbPrefixCurrentKbNumberCasePrefixCurrentCaseNumberContractPrefixCurrentContractNumberQuotePrefixCurrentQuoteNumberOrderPrefixCurrentOrderNumberInvoicePrefixCurrentInvoiceNumberUniqueSpecifierLength...«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId«Table 5346»CRM PricelevelPriceLevelId [PK]OrganizationIdNameDescriptionShippingMethodCode; [DefaultValue]BeginDatePaymentMethodCode; [DefaultValue]FreightTermsCode; [DefaultValue]EndDateCreatedByCreatedOnModifiedByModifiedOnStateCode; [Active,Inactive]VersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberTransactionCurrencyIdOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameExchangeRate«Table 5348»CRM ProductProductId [PK]DefaultUoMScheduleIdOrganizationIdNameDefaultUoMIdPriceLevelIdDescriptionProductTypeCode; [SalesInventory,Misce...ProductUrlPriceIsKitProductNumberSizeCurrentCostStockVolumeStandardCostStockWeightQuantityDecimalQuantityOnHandIsStockItemSupplierNameVendorNameVendorPartNumberCreatedOnModifiedOnCreatedByStateCode; [Active,Retired,Draft,Under...ModifiedByStatusCode; [,Active,Retired,Draft,Und...VersionNumberDefaultUoMIdName...«Table 5362»CRM UomscheduleUoMScheduleId [PK]OrganizationIdNameDescriptionCreatedOnCreatedByModifiedOnModifiedByVersionNumberCreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberBaseUoMNameOverriddenCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameStateCode; [Active,Inactive]StatusCode; [,Active,Inactive]«Table 5364»CRM BusinessunitBusinessUnitId [PK]OrganizationIdNameDescriptionDivisionNameFileAsNameTickerSymbolStockExchangeUTCOffsetCreatedOnModifiedOnCreditLimitCostCenterWebSiteUrlFtpSiteUrlEMailAddressInheritanceMaskCreatedByModifiedByWorkflowSuspendedParentBusinessUnitIdIsDisabledDisabledReasonVersionNumberParentBusinessUnitIdNameAddress1_AddressIdAddress1_AddressTypeCode; [DefaultValu...Address1_NameAddress1_Line1Address1_Line2Address1_Line3...«Table 5366»CRM DiscounttypeDiscountTypeId [PK]OrganizationIdNameDescriptionIsAmountTypeStateCode; [Active,Inactive]CreatedOnCreatedByModifiedByModifiedOnVersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameOverriddenCreatedOnTransactionCurrencyIdImportSequenceNumberTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«Table 5367»CRM Account StatisticsAccountStatisticsId [PK]CreatedOnCreatedByModifiedOnModifiedByCreatedOnBehalfByModifiedOnBehalfByCreatedByNameCreatedOnBehalfByNameModifiedByNameModifiedOnBehalfByNameOrganizationIdOrganizationIdNamestatecode; [,Active,Inactive]statuscode; [,Active,Inactive]VersionNumberImportSequenceNumberOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeNameCustomer NoBalance [LCY]TransactionCurrencyIdTransactionCurrencyIdNameExchangeRateBalance [Base]Outstanding Orders [LCY]Outstanding Orders [Base]Shipped Not Invoiced [LCY]Shipped Not Invoiced [Base]...«Table 5368»CRM NAV ConnectionNAVConnectionId [PK]CreatedOnCreatedByModifiedOnModifiedByCreatedOnBehalfByModifiedOnBehalfByCreatedByNameCreatedOnBehalfByNameModifiedByNameModifiedOnBehalfByNameOrganizationIdOrganizationIdNamestatecode; [,Active,Inactive]statuscode; [,Active,Inactive]VersionNumberImportSequenceNumberOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeNameDynamics NAV URL«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...<BaseCurrencyId><OrganizationId><OrganizationId><RegardingObjectId><OrganizationId><OrganizationId><OrganizationId><OrganizationId><OrganizationId><OrganizationId><OrganizationId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwningBusinessU><RegardingObjectId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><PriceLevelId><DefaultUoMScheduleId><ParentProductId><ParentBusinessUnitId><BusinessUnitId>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 OrganizationId GUID
2 Name Text160
3 UserGroupId GUID
4 PrivilegeUserGroupId GUID
5 RecurrenceExpansionJobBatchSiz Integer
6 RecurrenceExpansionJobBatchInt Integer
7 FiscalPeriodType Integer
8 FiscalCalendarStart Date
9 DateFormatCode Option
10 TimeFormatCode Option
11 CurrencySymbol Text13
12 WeekStartDayCode Option
13 DateSeparator Text5
14 FullNameConventionCode Option
15 NegativeFormatCode Option
16 NumberFormat Text2
17 IsDisabled Boolean
18 DisabledReason Text250
19 KbPrefix Text20
20 CurrentKbNumber Integer
21 CasePrefix Text20
22 CurrentCaseNumber Integer
23 ContractPrefix Text20
24 CurrentContractNumber Integer
25 QuotePrefix Text20
26 CurrentQuoteNumber Integer
27 OrderPrefix Text20
28 CurrentOrderNumber Integer
29 InvoicePrefix Text20
30 CurrentInvoiceNumber Integer
31 UniqueSpecifierLength Integer
32 CreatedOn DateTime
33 ModifiedOn DateTime
34 FiscalYearFormat Text25
35 FiscalPeriodFormat Text25
36 FiscalYearPeriodConnect Text5
37 LanguageCode Integer
38 SortId Integer
39 DateFormatString Text250
40 TimeFormatString Text250
41 PricingDecimalPrecision Integer
42 ShowWeekNumber Boolean
43 NextTrackingNumber Integer
44 TagMaxAggressiveCycles Integer
45 SystemUserId GUID
46 CreatedBy GUID
47 GrantAccessToNetworkService Boolean
48 AllowOutlookScheduledSyncs Boolean
49 AllowMarketingEmailExecution Boolean
50 SqlAccessGroupId GUID
51 CurrencyFormatCode Option
52 FiscalSettingsUpdated Boolean
53 ReportingGroupId GUID
54 TokenExpiry Integer
55 ShareToPreviousOwnerOnAssign Boolean
56 ModifiedBy GUID
57 IntegrationUserId GUID
58 TrackingTokenIdBase Integer
59 BusinessClosureCalendarId GUID
60 AllowAutoUnsubscribeAcknowledg Boolean
61 AllowAutoUnsubscribe Boolean
62 VersionNumber BigInteger
63 TrackingPrefix Text250
64 MinOutlookSyncInterval Integer
65 BulkOperationPrefix Text20
66 AllowAutoResponseCreation Boolean
67 MaximumTrackingNumber Integer
68 CampaignPrefix Text20
69 SqlAccessGroupName Text250
70 CurrentCampaignNumber Integer
71 FiscalYearDisplayCode Integer
72 SiteMapXml BLOB [Memo]
73 ReportingGroupName Text250
74 CurrentBulkOperationNumber Integer
75 SchemaNamePrefix Text8
76 IgnoreInternalEmail Boolean
77 TagPollingPeriod Integer
78 TrackingTokenIdDigits Integer
79 ModifiedByName Text200 FlowField
80 CreatedByName Text200 FlowField
81 NumberGroupFormat Text50
82 LongDateFormatCode Integer
83 UTCConversionTimeZoneCode Integer
84 TimeZoneRuleVersionNumber Integer
85 CurrentImportSequenceNumber Integer
86 ParsedTablePrefix Text20
87 V3CalloutConfigHash Text250
88 IsFiscalPeriodMonthBased Boolean
89 LocaleId Integer
90 ParsedTableColumnPrefix Text20
91 SupportUserId GUID
92 AMDesignator Text25
93 CurrencyDisplayOption Option
94 MinAddressBookSyncInterval Integer
95 IsDuplicateDetectionEnabledFor Boolean
96 FeatureSet Text250
97 BlockedAttachments Text250
98 IsDuplicateDetectionEnabledFo1 Boolean
99 AllowOfflineScheduledSyncs Boolean
100 AllowUnresolvedPartiesOnEmailS Boolean
101 TimeSeparator Text5
102 CurrentParsedTableNumber Integer
103 MinOfflineSyncInterval Integer
104 AllowWebExcelExport Boolean
105 ReferenceSiteMapXml Text250
106 IsDuplicateDetectionEnabledFo2 Boolean
107 CalendarType Integer
108 SQMEnabled Boolean
109 NegativeCurrencyFormatCode Integer
110 AllowAddressBookSyncs Boolean
111 ISVIntegrationCode Option
112 DecimalSymbol Text5
113 MaxUploadFileSize Integer
114 IsAppMode Boolean
115 EnablePricingOnCreate Boolean
116 IsSOPIntegrationEnabled Boolean
117 PMDesignator Text25
118 CurrencyDecimalPrecision Integer
119 MaxAppointmentDurationDays Integer
120 EmailSendPollingPeriod Integer
121 RenderSecureIFrameForEmail Boolean
122 NumberSeparator Text5
123 PrivReportingGroupId GUID
124 BaseCurrencyId GUID
125 MaxRecordsForExportToExcel Integer
126 PrivReportingGroupName Text250
127 YearStartWeekCode Integer
128 IsPresenceEnabled Boolean
129 IsDuplicateDetectionEnabled Boolean
130 BaseCurrencyIdName Text100 FlowField
131 ExpireSubscriptionsInDays Integer
132 IsAuditEnabled Boolean
133 BaseCurrencyPrecision Integer
134 BaseCurrencySymbol Text5
135 MaxRecordsForLookupFilters Integer
136 AllowEntityOnlyAudit Boolean
137 DefaultRecurrenceEndRangeType Option
138 FutureExpansionWindow Integer
139 PastExpansionWindow Integer
140 RecurrenceExpansionSynchCreate Integer
141 RecurrenceDefaultNumberOfOccur Integer
142 CreatedOnBehalfBy GUID
143 CreatedOnBehalfByName Text200 FlowField
144 ModifiedOnBehalfBy GUID
145 ModifiedOnBehalfByName Text200 FlowField
146 GetStartedPaneContentEnabled Boolean
147 UseReadForm Boolean
148 InitialVersion Text20
149 SampleDataImportId GUID
150 ReportScriptErrors Option
151 RequireApprovalForUserEmail Boolean
152 RequireApprovalForQueueEmail Boolean
153 GoalRollupExpiryTime Integer
154 GoalRollupFrequency Integer
155 AutoApplyDefaultonCaseCreate Boolean
156 AutoApplyDefaultonCaseUpdate Boolean
157 FiscalYearFormatPrefix Option
158 FiscalYearFormatSuffix Option
159 FiscalYearFormatYear Option
160 DiscountCalculationMethod Option
161 FiscalPeriodFormatPeriod Option
162 AllowClientMessageBarAd Boolean
163 AllowUserFormModePreference Boolean
164 HashFilterKeywords Text250
165 HashMaxCount Integer
166 HashDeltaSubjectCount Integer
167 HashMinAddressCount Integer
168 EnableSmartMatching Boolean
169 PinpointLanguageCode Integer
170 OrgDbOrgSettings Text250
171 IsUserAccessAuditEnabled Boolean
172 UserAccessAuditingInterval Integer
173 QuickFindRecordLimitEnabled Boolean
174 EnableBingMapsIntegration Boolean
175 IsDefaultCountryCodeCheckEnabl Boolean
176 DefaultCountryCode Text30
177 UseSkypeProtocol Boolean
178 IncomingEmailExchangeEmailRetr Integer
179 EmailCorrelationEnabled Boolean
180 YammerOAuthAccessTokenExpired Boolean
181 DefaultEmailSettings Text250
182 YammerGroupId Integer
183 YammerNetworkPermalink Text100
184 YammerPostMethod Option
185 EmailConnectionChannel Option
186 IsAutoSaveEnabled Boolean
187 BingMapsApiKey Text250
188 GenerateAlertsForErrors Boolean
189 GenerateAlertsForInformation Boolean
190 GenerateAlertsForWarnings Boolean
191 NotifyMailboxOwnerOfEmailServe Boolean
192 MaximumActiveBusinessProcessFl Integer
193 EntityImageId GUID
194 AllowUsersSeeAppdownloadMessag Boolean
195 SignupOutlookDownloadFWLink Text200
196 CascadeStatusUpdate Boolean
197 RestrictStatusUpdate Boolean
198 SuppressSLA Boolean
199 SocialInsightsTermsAccepted Boolean
200 SocialInsightsInstance Text250
201 DisableSocialCare Boolean
202 MaxProductsInBundle Integer
203 UseInbuiltRuleForDefaultPricel Boolean
204 OOBPriceCalculationEnabled Boolean
205 IsHierarchicalSecurityModelEna Boolean
206 MaximumDynamicPropertiesAllowe Integer
207 UsePositionHierarchy Boolean
208 MaxDepthForHierarchicalSecurit Integer
209 SlaPauseStates Text250
210 SocialInsightsEnabled Boolean
211 IsAppointmentAttachmentSyncEna Boolean
212 IsAssignedTasksSyncEnabled Boolean
213 IsContactMailingAddressSyncEna Boolean
214 MaxSupportedInternetExplorerVe Integer
215 GlobalHelpUrl Text250
216 GlobalHelpUrlEnabled Boolean
217 GlobalAppendUrlParametersEnabl Boolean
218 KMSettings Text250
219 MobileClientMashupEnabled Boolean
220 CreateProductsWithoutParentInA Boolean
221 IsMailboxInactiveBackoffEnable Boolean
222 IsFullTextSearchEnabled Boolean
223 EnforceReadOnlyPlugins Boolean
224 SharePointDeploymentType Option
225 DefaultThemeData BLOB [Memo]
226 IsFolderBasedTrackingEnabled Boolean
227 WebResourceHash Text100
228 ExpireChangeTrackingInDays Integer
229 MaxFolderBasedTrackingMappings Integer
230 PrivacyStatementUrl Text250
231 PluginTraceLogSetting Option
232 IsMailboxForcedUnlockingEnable Boolean
233 MailboxIntermittentIssueMinRan Integer
234 MailboxPermanentIssueMinRange Integer
235 HighContrastThemeData BLOB [Memo]
236 DelegatedAdminUserId GUID
237 IsEmailServerProfileContentFil Boolean
238 IsDelegateAccessEnabled Boolean
239 DisplayNavigationTour Boolean
240 UseLegacyRendering Boolean

Keys

# Fields
0 OrganizationId Clustered: Yes
1 Name

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field
CRM Account Statistics OrganizationId 1..n
CRM Businessunit OrganizationId 1..n
CRM Discounttype OrganizationId 1..n
CRM NAV Connection OrganizationId 1..n
CRM Post RegardingObjectId 1..n
CRM Pricelevel OrganizationId 1..n
CRM Product OrganizationId 1..n
CRM Transactioncurrency OrganizationId 1..n
CRM Uomschedule OrganizationId 1..n