Table 5363 "CRM Organization"

Base Application · Microsoft.Integration.D365Sales · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	CRM Organization
TableType	CRM
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	OrganizationId	Guid	Organization caption
2	Name	Text[160]	Organization Name caption
3	UserGroupId	Guid	User Group caption
4	PrivilegeUserGroupId	Guid	Privilege User Group caption
5	RecurrenceExpansionJobBatchSiz	Integer	Recurrence Expansion On Demand Job Batch Size caption
6	RecurrenceExpansionJobBatchInt	Integer	Recurrence Expansion Job Batch Interval caption
7	FiscalPeriodType	Integer	Fiscal Period Type caption
8	FiscalCalendarStart	Date	Fiscal Calendar Start caption
9	DateFormatCode	Option	Date Format Code caption	OptionCaption:
10	TimeFormatCode	Option	Time Format Code caption	OptionCaption:
11	CurrencySymbol	Text[13]	Currency Symbol caption
12	WeekStartDayCode	Option	Week Start Day Code caption	OptionCaption:
13	DateSeparator	Text[5]	Date Separator caption
14	FullNameConventionCode	Option	Full Name Display Order caption	OptionCaption: Last Name; First Name,First Name,Last Name; First Name; Middle Initial,First Name; Middle Initial; Last Name,Last Name; First Name; Middle Name,First Name; Middle Name; Last Name,Last Name; space; First Name,Last Name; no space; First Name
15	NegativeFormatCode	Option	Negative Format caption	OptionCaption: Brackets,Dash,Dash plus Space,Trailing Dash,Space plus Trailing Dash
16	NumberFormat	Text[2]	Number Format caption
17	IsDisabled	Boolean	Is Organization Disabled caption
18	DisabledReason	Text[250]	Disabled Reason caption
19	KbPrefix	Text[20]	Article Prefix caption
20	CurrentKbNumber	Integer	Current Article Number caption
21	CasePrefix	Text[20]	Case Prefix caption
22	CurrentCaseNumber	Integer	Current Case Number caption
23	ContractPrefix	Text[20]	Contract Prefix caption
24	CurrentContractNumber	Integer	Current Contract Number caption
25	QuotePrefix	Text[20]	Quote Prefix caption
26	CurrentQuoteNumber	Integer	Current Quote Number caption
27	OrderPrefix	Text[20]	Order Prefix caption
28	CurrentOrderNumber	Integer	Current Order Number caption
29	InvoicePrefix	Text[20]	Invoice Prefix caption
30	CurrentInvoiceNumber	Integer	Current Invoice Number caption
31	UniqueSpecifierLength	Integer	Unique String Length caption
32	CreatedOn	DateTime	Created On caption
33	ModifiedOn	DateTime	Modified On caption
34	FiscalYearFormat	Text[25]	Fiscal Year Format caption
35	FiscalPeriodFormat	Text[25]	Fiscal Period Format caption
36	FiscalYearPeriodConnect	Text[5]	Fiscal Year Period Connector caption
37	LanguageCode	Integer	Language caption
38	SortId	Integer	Sort caption
39	DateFormatString	Text[250]	Date Format String caption
40	TimeFormatString	Text[250]	Time Format String caption
41	PricingDecimalPrecision	Integer	Pricing Decimal Precision caption
42	ShowWeekNumber	Boolean	Show Week Number caption
43	NextTrackingNumber	Integer	Next Tracking Number caption
44	TagMaxAggressiveCycles	Integer	Auto-Tag Max Cycles caption
45	SystemUserId	Guid	System User caption
46	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
47	GrantAccessToNetworkService	Boolean	Grant Access To Network Service caption
48	AllowOutlookScheduledSyncs	Boolean	Allow Scheduled Synchronization caption
49	AllowMarketingEmailExecution	Boolean	Allow Marketing Email Execution caption
50	SqlAccessGroupId	Guid	SQL Access Group caption
51	CurrencyFormatCode	Option	Currency Format Code caption	OptionCaption: $123,123$,$ 123,123 $
52	FiscalSettingsUpdated	Boolean	Is Fiscal Settings Updated caption
53	ReportingGroupId	Guid	Reporting Group caption
54	TokenExpiry	Integer	Token Expiration Duration caption
55	ShareToPreviousOwnerOnAssign	Boolean	Share To Previous Owner On Assign caption
56	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
57	IntegrationUserId	Guid	Integration User caption
58	TrackingTokenIdBase	Integer	Tracking Token Base caption
59	BusinessClosureCalendarId	Guid	Business Closure Calendar caption
60	AllowAutoUnsubscribeAcknowledg	Boolean	Allow Automatic Unsubscribe Acknowledgement caption
61	AllowAutoUnsubscribe	Boolean	Allow Automatic Unsubscribe caption
62	VersionNumber	BigInteger	Version Number caption
63	TrackingPrefix	Text[250]	Tracking Prefix caption
64	MinOutlookSyncInterval	Integer	Min Synchronization Frequency caption
65	BulkOperationPrefix	Text[20]	Bulk Operation Prefix caption
66	AllowAutoResponseCreation	Boolean	Allow Automatic Response Creation caption
67	MaximumTrackingNumber	Integer	Max Tracking Number caption
68	CampaignPrefix	Text[20]	Campaign Prefix caption
69	SqlAccessGroupName	Text[250]	SQL Access Group Name caption
70	CurrentCampaignNumber	Integer	Current Campaign Number caption
71	FiscalYearDisplayCode	Integer	Fiscal Year Display caption
72	SiteMapXml	BLOB	SiteMap XML caption
73	ReportingGroupName	Text[250]	Reporting Group Name caption
74	CurrentBulkOperationNumber	Integer	Current Bulk Operation Number caption
75	SchemaNamePrefix	Text[8]	Customization Name Prefix caption
76	IgnoreInternalEmail	Boolean	Ignore Internal Email caption
77	TagPollingPeriod	Integer	Auto-Tag Interval caption
78	TrackingTokenIdDigits	Integer	Tracking Token Digits caption
79	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
80	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
81	NumberGroupFormat	Text[50]	Number Grouping Format caption
82	LongDateFormatCode	Integer	Long Date Format caption
83	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
84	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
85	CurrentImportSequenceNumber	Integer	Current Import Sequence Number caption
86	ParsedTablePrefix	Text[20]	Parsed Table Prefix caption
87	V3CalloutConfigHash	Text[250]	V3 Callout Hash caption
88	IsFiscalPeriodMonthBased	Boolean	Is Fiscal Period Monthly caption
89	LocaleId	Integer	Locale caption
90	ParsedTableColumnPrefix	Text[20]	Parsed Table Column Prefix caption
91	SupportUserId	Guid	Support User caption
92	AMDesignator	Text[25]	AM Designator caption
93	CurrencyDisplayOption	Option	Display Currencies Using caption	OptionCaption: Currency symbol,Currency code
94	MinAddressBookSyncInterval	Integer	Min Address Synchronization Frequency caption
95	IsDuplicateDetectionEnabledFor	Boolean	Is Duplicate Detection Enabled for Online Create/Update caption
96	FeatureSet	Text[250]	Feature Set caption
97	BlockedAttachments	Text[250]	Block Attachments caption
98	IsDuplicateDetectionEnabledFo1	Boolean	Is Duplicate Detection Enabled For Offline Synchronization caption
99	AllowOfflineScheduledSyncs	Boolean	Allow Offline Scheduled Synchronization caption
100	AllowUnresolvedPartiesOnEmailS	Boolean	Allow Unresolved Address Email Send caption
101	TimeSeparator	Text[5]	Time Separator caption
102	CurrentParsedTableNumber	Integer	Current Parsed Table Number caption
103	MinOfflineSyncInterval	Integer	Min Offline Synchronization Frequency caption
104	AllowWebExcelExport	Boolean	Allow Export to Excel caption
105	ReferenceSiteMapXml	Text[250]	Reference SiteMap XML caption
106	IsDuplicateDetectionEnabledFo2	Boolean	Is Duplicate Detection Enabled For Import caption
107	CalendarType	Integer	Calendar Type caption
108	SQMEnabled	Boolean	Is SQM Enabled caption
109	NegativeCurrencyFormatCode	Integer	Negative Currency Format caption
110	AllowAddressBookSyncs	Boolean	Allow Address Book Synchronization caption
111	ISVIntegrationCode	Option	ISV Integration Mode caption	OptionCaption: ,None,Web,Outlook Workstation Client,Web; Outlook Workstation Client,Outlook Laptop Client,Web; Outlook Laptop Client,Outlook,All
112	DecimalSymbol	Text[5]	Decimal Symbol caption
113	MaxUploadFileSize	Integer	Max Upload File Size caption
114	IsAppMode	Boolean	Is Application Mode Enabled caption
115	EnablePricingOnCreate	Boolean	Enable Pricing On Create caption
116	IsSOPIntegrationEnabled	Boolean	Is Sales Order Integration Enabled caption
117	PMDesignator	Text[25]	PM Designator caption
118	CurrencyDecimalPrecision	Integer	Currency Decimal Precision caption
119	MaxAppointmentDurationDays	Integer	Max Appointment Duration caption
120	EmailSendPollingPeriod	Integer	Email Send Polling Frequency caption
121	RenderSecureIFrameForEmail	Boolean	Render Secure Frame For Email caption
122	NumberSeparator	Text[5]	Number Separator caption
123	PrivReportingGroupId	Guid	Privilege Reporting Group caption
124	BaseCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
125	MaxRecordsForExportToExcel	Integer	Max Records For Excel Export caption
126	PrivReportingGroupName	Text[250]	Privilege Reporting Group Name caption
127	YearStartWeekCode	Integer	Year Start Week Code caption
128	IsPresenceEnabled	Boolean	Presence Enabled caption
129	IsDuplicateDetectionEnabled	Boolean	Is Duplicate Detection Enabled caption
130	BaseCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(BaseCurrencyId)))
131	ExpireSubscriptionsInDays	Integer	Days to Expire Subscriptions caption
132	IsAuditEnabled	Boolean	Is Auditing Enabled caption
133	BaseCurrencyPrecision	Integer	Base Currency Precision caption
134	BaseCurrencySymbol	Text[5]	Base Currency Symbol caption
135	MaxRecordsForLookupFilters	Integer	Max Records Filter Selection caption
136	AllowEntityOnlyAudit	Boolean	Allow Entity Level Auditing caption
137	DefaultRecurrenceEndRangeType	Option	Default Recurrence End Range Type caption	OptionCaption: ,No End Date,Number of Occurrences,End By Date
138	FutureExpansionWindow	Integer	Future Expansion Window caption
139	PastExpansionWindow	Integer	Past Expansion Window caption
140	RecurrenceExpansionSynchCreate	Integer	Recurrence Expansion Synchronization Create Maximum caption
141	RecurrenceDefaultNumberOfOccur	Integer	Recurrence Default Number of Occurrences caption
142	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
143	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
144	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
145	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
146	GetStartedPaneContentEnabled	Boolean	Is Get Started Pane Content Enabled caption
147	UseReadForm	Boolean	Use Read-Optimized Form caption
148	InitialVersion	Text[20]	Initial Version caption
149	SampleDataImportId	Guid	Sample Data Import caption
150	ReportScriptErrors	Option	Report Script Errors caption	OptionCaption: ,No preference for sending an error report to Microsoft about Microsoft Dynamics CRM,Ask me for permission to send an error report to Microsoft,Automatically send an error report to Microsoft without asking me for permission,Never send an error report to Microsoft about Microsoft Dynamics CRM
151	RequireApprovalForUserEmail	Boolean	Is Approval For User Email Required caption
152	RequireApprovalForQueueEmail	Boolean	Is Approval For Queue Email Required caption
153	GoalRollupExpiryTime	Integer	Rollup Expiration Time for Goal caption
154	GoalRollupFrequency	Integer	Automatic Rollup Frequency for Goal caption
155	AutoApplyDefaultonCaseCreate	Boolean	Auto Apply Default Entitlement on Case Create caption
156	AutoApplyDefaultonCaseUpdate	Boolean	Auto Apply Default Entitlement on Case Update caption
157	FiscalYearFormatPrefix	Option	Prefix for Fiscal Year caption	OptionCaption: ,FY
158	FiscalYearFormatSuffix	Option	Suffix for Fiscal Year caption	OptionCaption: ,FY, Fiscal Year
159	FiscalYearFormatYear	Option	Fiscal Year Format Year caption	OptionCaption: ,YYYY,YY,GGYY
160	DiscountCalculationMethod	Option	Discount calculation method caption	OptionCaption: Line item,Per unit
161	FiscalPeriodFormatPeriod	Option	Format for Fiscal Period caption	OptionCaption: ,Quarter {0},Q{0},P{0},Month {0},M{0},Semester {0},Month Name
162	AllowClientMessageBarAd	Boolean	Allow Outlook Client Message Bar Advertisement caption
163	AllowUserFormModePreference	Boolean	Allow User Form Mode Preference caption
164	HashFilterKeywords	Text[250]	Hash Filter Keywords caption
165	HashMaxCount	Integer	Hash Max Count caption
166	HashDeltaSubjectCount	Integer	Hash Delta Subject Count caption
167	HashMinAddressCount	Integer	Hash Min Address Count caption
168	EnableSmartMatching	Boolean	Enable Smart Matching caption
169	PinpointLanguageCode	Integer	—
170	OrgDbOrgSettings	Text[250]	Organization Database Organization Settings caption
171	IsUserAccessAuditEnabled	Boolean	Is User Access Auditing Enabled caption
172	UserAccessAuditingInterval	Integer	User Authentication Auditing Interval caption
173	QuickFindRecordLimitEnabled	Boolean	Quick Find Record Limit Enabled caption
174	EnableBingMapsIntegration	Boolean	Enable Integration with Bing Maps caption
175	IsDefaultCountryCodeCheckEnabl	Boolean	Enable or disable country code selection caption
176	DefaultCountryCode	Text[30]	Default Country Code caption
177	UseSkypeProtocol	Boolean	User Skype Protocol caption
178	IncomingEmailExchangeEmailRetr	Integer	Exchange Email Retrieval Batch Size caption
179	EmailCorrelationEnabled	Boolean	Use Email Correlation caption
180	YammerOAuthAccessTokenExpired	Boolean	Yammer OAuth Access Token Expired caption
181	DefaultEmailSettings	Text[250]	Default Email Settings caption
182	YammerGroupId	Integer	Yammer Group Id caption
183	YammerNetworkPermalink	Text[100]	Yammer Network Permalink caption
184	YammerPostMethod	Option	Internal Use Only caption	OptionCaption: Public,Private
185	EmailConnectionChannel	Option	Email Connection Channel caption	OptionCaption: Server-Side Synchronization,Microsoft Dynamics CRM 2015 Email Router
186	IsAutoSaveEnabled	Boolean	Auto Save Enabled caption
187	BingMapsApiKey	Text[250]	Bing Maps API Key caption
188	GenerateAlertsForErrors	Boolean	Generate Alerts For Errors caption
189	GenerateAlertsForInformation	Boolean	Generate Alerts For Information caption
190	GenerateAlertsForWarnings	Boolean	Generate Alerts For Warnings caption
191	NotifyMailboxOwnerOfEmailServe	Boolean	Notify Mailbox Owner Of Email Server Level Alerts caption
192	MaximumActiveBusinessProcessFl	Integer	Maximum active business process flows per entity caption
193	EntityImageId	Guid	Entity Image Id caption
194	AllowUsersSeeAppdownloadMessag	Boolean	Allow the showing tablet application notification bars in a browser. caption
195	SignupOutlookDownloadFWLink	Text[200]	CRMForOutlookDownloadURL caption
196	CascadeStatusUpdate	Boolean	Cascade Status Update caption
197	RestrictStatusUpdate	Boolean	Restrict Status Update caption
198	SuppressSLA	Boolean	Is SLA suppressed caption
199	SocialInsightsTermsAccepted	Boolean	Social Insights Terms of Use caption
200	SocialInsightsInstance	Text[250]	Social Insights instance identifier caption
201	DisableSocialCare	Boolean	Is Social Care disabled caption
202	MaxProductsInBundle	Integer	Bundle Item Limit caption
203	UseInbuiltRuleForDefaultPricel	Boolean	Use Inbuilt Rule For Default Pricelist Selection caption
204	OOBPriceCalculationEnabled	Boolean	Enable OOB Price calculation caption
205	IsHierarchicalSecurityModelEna	Boolean	Enable Hierarchical Security Model caption
206	MaximumDynamicPropertiesAllowe	Integer	Product Properties Item Limit caption
207	UsePositionHierarchy	Boolean	Use position hierarchy caption
208	MaxDepthForHierarchicalSecurit	Integer	Maximum depth for hierarchy security propagation. caption
209	SlaPauseStates	Text[250]	SLA pause states caption
210	SocialInsightsEnabled	Boolean	Social Insights Enabled caption
211	IsAppointmentAttachmentSyncEna	Boolean	Is Attachment Sync Enabled caption
212	IsAssignedTasksSyncEnabled	Boolean	Is Assigned Tasks Sync Enabled caption
213	IsContactMailingAddressSyncEna	Boolean	Is Mailing Address Sync Enabled caption
214	MaxSupportedInternetExplorerVe	Integer	Max supported IE version caption
215	GlobalHelpUrl	Text[250]	Global Help URL. caption
216	GlobalHelpUrlEnabled	Boolean	Is Customizable Global Help enabled caption
217	GlobalAppendUrlParametersEnabl	Boolean	Is AppendUrl Parameters enabled caption
218	KMSettings	Text[250]	Knowledge Management Settings caption
219	MobileClientMashupEnabled	Boolean	Is Mobile Client Mashup enabled caption
220	CreateProductsWithoutParentInA	Boolean	Enable Active Initial Product State caption
221	IsMailboxInactiveBackoffEnable	Boolean	Is Mailbox Keep Alive Enabled caption
222	IsFullTextSearchEnabled	Boolean	Enable Full-text search for Quick Find caption
223	EnforceReadOnlyPlugins	Boolean	Organization setting to enforce read only plugins. caption
224	SharePointDeploymentType	Option	Choose SharePoint Deployment Type caption	OptionCaption: Online,On-Premises
225	DefaultThemeData	BLOB	Default Theme Data caption
226	IsFolderBasedTrackingEnabled	Boolean	Is Folder Based Tracking Enabled caption
227	WebResourceHash	Text[100]	Web resource hash caption
228	ExpireChangeTrackingInDays	Integer	Days to Expire Change Tracking Deleted Records caption
229	MaxFolderBasedTrackingMappings	Integer	Max Folder Based Tracking Mappings caption
230	PrivacyStatementUrl	Text[250]	Privacy Statement URL caption
231	PluginTraceLogSetting	Option	Plug-in Trace Log Setting caption	OptionCaption: Off,Exception,All
232	IsMailboxForcedUnlockingEnable	Boolean	Is Mailbox Forced Unlocking Enabled caption
233	MailboxIntermittentIssueMinRan	Integer	Lower Threshold For Mailbox Intermittent Issue caption
234	MailboxPermanentIssueMinRange	Integer	Lower Threshold For Mailbox Permanent Issue. caption
235	HighContrastThemeData	BLOB	High contrast Theme Data caption
236	DelegatedAdminUserId	Guid	Delegated Admin caption
237	IsEmailServerProfileContentFil	Boolean	Is Email Server Profile Content Filtering Enabled caption
238	IsDelegateAccessEnabled	Boolean	Is Delegation Access Enabled caption
239	DisplayNavigationTour	Boolean	Display Navigation Tour caption
240	UseLegacyRendering	Boolean	Legacy Form Rendering caption

Keys

Key1: OrganizationId (clustered)
Key2: Name

Relations

CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
BaseCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
BaseCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”

Referenced by

18 fields in 10 objects relate to this table (TableRelation or CalcFormula).

Table 5344 “CRM Post”: OrganizationIdName, OrganizationId
Table 5346 “CRM Pricelevel”: OrganizationIdName, OrganizationId
Table 5348 “CRM Product”: OrganizationIdName, OrganizationId
Table 5362 “CRM Uomschedule”: OrganizationIdName, OrganizationId
Table 5364 “CRM Businessunit”: OrganizationIdName, OrganizationId
Table 5366 “CRM Discounttype”: OrganizationIdName, OrganizationId
Table 5367 “CRM Account Statistics”: OrganizationIdName, OrganizationId
Table 5368 “CRM NAV Connection”: OrganizationIdName, OrganizationId
Table 5345 “CRM Transactioncurrency”: OrganizationId
Table 5398 “CDS Field Security Profile”: OrganizationId

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "CRM Organization"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.