Table 5340 "CRM Systemuser"

Base Application · Microsoft.Integration.D365Sales · captioned “Dataverse Systemuser” · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Dataverse Systemuser
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	SystemUserId	Guid	User caption
2	OrganizationId	Guid	Organization caption
3	BusinessUnitId	Guid	Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
4	ParentSystemUserId	Guid	Manager caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
5	FirstName	Text[64]	First Name caption
6	Salutation	Text[20]	—
7	MiddleName	Text[50]	Middle Name caption
8	LastName	Text[64]	Last Name caption
9	PersonalEMailAddress	Text[100]	Email 2 caption
10	FullName Δ BC28	Text[200]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
11	NickName	Text[50]	Nickname caption
12	Title	Text[128]	—
13	InternalEMailAddress Δ BC28	Text[100]	Specifies the email address.
14	JobTitle	Text[100]	Job Title caption
15	MobileAlertEMail	Text[100]	Mobile Alert Email caption
16	PreferredEmailCode	Option	Preferred Email caption	OptionCaption: Default Value
17	HomePhone	Text[50]	Home Phone caption
18	MobilePhone Δ BC28	Text[64]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
19	PreferredPhoneCode	Option	Preferred Phone caption	OptionCaption: Main Phone,Other Phone,Home Phone,Mobile Phone
20	PreferredAddressCode	Option	Preferred Address caption	OptionCaption: Mailing Address,Other Address
21	PhotoUrl	Text[200]	Photo URL caption
22	DomainName	Text[250]	User Name caption
23	PassportLo	Integer	Passport Lo caption
24	CreatedOn	DateTime	Created On caption
25	PassportHi	Integer	Passport Hi caption
26	DisabledReason	Text[250]	Disabled Reason caption
27	ModifiedOn	DateTime	Modified On caption
28	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
29	EmployeeId	Text[100]	Employee caption
30	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
31	IsDisabled	Boolean	Status caption
32	GovernmentId	Text[100]	Government caption
33	VersionNumber	BigInteger	Version number caption
34	ParentSystemUserIdName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ParentSystemUserId)))
35	Address1_AddressId	Guid	Address 1: ID caption
36	Address1_AddressTypeCode	Option	Address 1: Address Type caption	OptionCaption: Default Value
37	Address1_Name	Text[100]	Address 1: Name caption
38	Address1_Line1	Text[250]	Street 1 caption
39	Address1_Line2	Text[250]	Street 2 caption
40	Address1_Line3	Text[250]	Street 3 caption
41	Address1_City	Text[128]	City caption
42	Address1_StateOrProvince	Text[128]	State/Province caption
43	Address1_County	Text[128]	Address 1: County caption
44	Address1_Country	Text[128]	Country/Region caption
45	Address1_PostOfficeBox	Text[40]	Address 1: Post Office Box caption
46	Address1_PostalCode	Text[40]	ZIP/Postal Code caption
47	Address1_UTCOffset	Integer	Address 1: UTC Offset caption
48	Address1_UPSZone	Text[4]	Address 1: UPS Zone caption
49	Address1_Latitude Δ BC28	Decimal	Address 1: Latitude caption
50	Address1_Telephone1	Text[64]	Main Phone caption
51	Address1_Longitude Δ BC28	Decimal	Address 1: Longitude caption
52	Address1_ShippingMethodCode	Option	Address 1: Shipping Method caption	OptionCaption: Default Value
53	Address1_Telephone2	Text[50]	Other Phone caption
54	Address1_Telephone3	Text[50]	Pager caption
55	Address1_Fax	Text[64]	Address 1: Fax caption
56	Address2_AddressId	Guid	Address 2: ID caption
57	Address2_AddressTypeCode	Option	Address 2: Address Type caption	OptionCaption: Default Value
58	Address2_Name	Text[100]	Address 2: Name caption
59	Address2_Line1	Text[250]	Other Street 1 caption
60	Address2_Line2	Text[250]	Other Street 2 caption
61	Address2_Line3	Text[250]	Other Street 3 caption
62	Address2_City	Text[128]	Other City caption
63	Address2_StateOrProvince	Text[128]	Other State/Province caption
64	Address2_County	Text[128]	Address 2: County caption
65	Address2_Country	Text[128]	Other Country/Region caption
66	Address2_PostOfficeBox	Text[40]	Address 2: Post Office Box caption
67	Address2_PostalCode	Text[40]	Other ZIP/Postal Code caption
68	Address2_UTCOffset	Integer	Address 2: UTC Offset caption
69	Address2_UPSZone	Text[4]	Address 2: UPS Zone caption
70	Address2_Latitude Δ BC28	Decimal	Address 2: Latitude caption
71	Address2_Telephone1	Text[50]	Address 2: Telephone 1 caption
72	Address2_Longitude Δ BC28	Decimal	Address 2: Longitude caption
73	Address2_ShippingMethodCode	Option	Address 2: Shipping Method caption	OptionCaption: Default Value
74	Address2_Telephone2	Text[50]	Address 2: Telephone 2 caption
75	Address2_Telephone3	Text[50]	Address 2: Telephone 3 caption
76	Address2_Fax	Text[50]	Address 2: Fax caption
77	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
78	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
79	BusinessUnitIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Businessunit”.Name where(BusinessUnitId = field(BusinessUnitId)))
80	Skills	Text[100]	—
81	DisplayInServiceViews	Boolean	Display in Service Views caption
82	SetupUser	Boolean	Restricted Access Mode caption
83	WindowsLiveID	Text[250]	Windows Live ID caption
84	IncomingEmailDeliveryMethod	Option	Incoming Email Delivery Method caption	OptionCaption: None,Microsoft Dynamics CRM for Outlook,Server-Side Synchronization or Email Router,Forward Mailbox
85	OutgoingEmailDeliveryMethod	Option	Outgoing Email Delivery Method caption	OptionCaption: None,Microsoft Dynamics CRM for Outlook,Server-Side Synchronization or Email Router
86	ImportSequenceNumber	Integer	Import Sequence Number caption
87	AccessMode	Option	Access Mode caption	OptionCaption: Read-Write,Administrative,Read,Support User,Non-interactive
88	InviteStatusCode	Option	Invitation Status caption	OptionCaption: Invitation Not Sent,Invited,Invitation Near Expired,Invitation Expired,Invitation Accepted,Invitation Rejected,Invitation Revoked
89	OverriddenCreatedOn	Date	Record Created On caption
90	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
91	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
92	YomiFullName	Text[200]	Yomi Full Name caption
93	YomiLastName	Text[64]	Yomi Last Name caption
94	YomiMiddleName	Text[50]	Yomi Middle Name caption
95	YomiFirstName	Text[64]	Yomi First Name caption
96	IsIntegrationUser	Boolean	Integration user mode caption
97	DefaultFiltersPopulated	Boolean	Default Filters Populated caption
98	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
99	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
100	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
101	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
102	EmailRouterAccessApproval	Option	Primary Email Status caption	OptionCaption: Empty,Approved,Pending Approval,Rejected
103	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
104	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
105	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
106	CALType	Option	License Type caption	OptionCaption: Professional,Administrative,Basic,Device Professional,Device Basic,Essential,Device Essential,Enterprise,Device Enterprise
107	IsLicensed	Boolean	User Licensed caption
108	IsSyncWithDirectory	Boolean	User Synced caption
109	YammerEmailAddress	Text[200]	Yammer Email caption
110	YammerUserId	Text[128]	Yammer User ID caption
111	UserLicenseType	Integer	User License Type caption
112	EntityImageId	Guid	Entity Image Id caption
113	Address2_Composite	BLOB	Other Address caption
114	Address1_Composite	BLOB	Address caption
115	ProcessId	Guid	Process caption
116	StageId	Guid	Process Stage caption
117	IsEmailAddressApprovedByO365Ad	Boolean	Email Address O365 Admin Approval Status caption
118	TraversedPath	Text[250]	Traversed Path caption
119	SharePointEmailAddress	Text[250]	SharePoint Email Address caption
120	ApplicationId	Guid	Application ID caption

Keys

Key1: SystemUserId (clustered)
Key2: FullName

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”
ParentSystemUserIdName: 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”
ParentSystemUserId: TableRelation Table 5340 “CRM Systemuser”
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
BusinessUnitIdName: CalcFormula Table 5364 “CRM Businessunit”
BusinessUnitId: TableRelation Table 5364 “CRM Businessunit”

Referenced by

497 fields in 71 objects relate to this table (TableRelation or CalcFormula).

Table 5341 “CRM Account”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, PreferredSystemUserIdName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, OwningUser, PreferredSystemUserId
Table 5342 “CRM Contact”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, PreferredSystemUserIdName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, OwningUser, PreferredSystemUserId
Table 5352 “CRM Quotedetail”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, SalesRepIdName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, SalesRepId
Table 5354 “CRM Salesorderdetail”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, SalesRepIdName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, SalesRepId
Table 5356 “CRM Invoicedetail”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, SalesRepIdName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, SalesRepId
Table 5340 “CRM Systemuser”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, ParentSystemUserIdName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, ParentSystemUserId
Table 5343 “CRM Opportunity”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, OwningUser
Table 5344 “CRM Post”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, RegardingObjectId, RegardingObjectOwnerId
Table 5349 “CRM Incident”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, OwningUser
Table 5350 “CRM Incidentresolution”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, OwningUser
Table 5351 “CRM Quote”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, OwningUser
Table 5353 “CRM Salesorder”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, OwningUser
Table 5355 “CRM Invoice”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, OwningUser
Table 5357 “CRM Contract”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, OwningUser
Table 5359 “CRM Team”: AdministratorIdName, CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, AdministratorId, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 5360 “CRM Customeraddress”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, OwningUser
Table 5393 “CDS Company”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwnerId, OwningUser
Table 6206 “FS Resource Pay Type”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6616 “FS Resource Pay Type”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 7206 “CRM Company”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 5345 “CRM Transactioncurrency”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 5346 “CRM Pricelevel”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 5347 “CRM Productpricelevel”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 5348 “CRM Product”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 5361 “CRM Uom”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 5362 “CRM Uomschedule”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 5363 “CRM Organization”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 5364 “CRM Businessunit”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 5365 “CRM Discount”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 5366 “CRM Discounttype”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 5367 “CRM Account Statistics”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 5368 “CRM NAV Connection”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 6404 “FS Project Task”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 6615 “FS Project Task”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 6624 “FS Warehouse”: CreatedByName, CreatedOnBehalfByName, ModifiedByName, ModifiedOnBehalfByName, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy
Table 6400 “FS Work Order”: ClosedBy, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6410 “FS Bookable Resource”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser, UserId
Table 6610 “FS Bookable Resource”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser, UserId
Table 6617 “FS Work Order”: ClosedBy, CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6242 “Sust. Assessment”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6243 “Sust. Assessment Req. Fact”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6244 “Sust. Assessment Requirement”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6245 “Sust. Concept”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6246 “Sust. ESG Fact”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6247 “Sust. Range Period”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6248 “Sust. Requirement Concept”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6249 “Sust. Standard”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6251 “Sust. Unit”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6254 “Sust. Standard Requirement”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
Table 6402 “FS Work Order Product”: CreatedBy, CreatedOnBehalfBy, ModifiedBy, ModifiedOnBehalfBy, OwningUser
and 21 more objects (94 fields): data/code/relations/29.json

Pages and codeunits on this table

Page 5340 “CRM Systemuser List” (source table)
Page 7209 “CDS Couple Salespersons” (source table)

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 Systemuser"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.