Objects/Tables/Table 5340 CRM Systemuser

Table 5340 CRM Systemuser in 28

Jonas Paprotka, Base Application 28.5.54151.54365, checked 2026-09-20

App: Base Application
Namespace: Microsoft.Integration.D365Sales

Versions17 18 19 20 21 22 23 24 25 26 2728latest

Source29

Fields, 120

Id	Name	Type	Obsolete
1	SystemUserId	Guid	-
2	OrganizationId	Guid	-
3	BusinessUnitId	Guid	-
4	ParentSystemUserId	Guid	-
5	FirstName	Text[64]	-
6	Salutation	Text[20]	-
7	MiddleName	Text[50]	-
8	LastName	Text[64]	-
9	PersonalEMailAddress	Text[100]	-
10	FullName	Text[200]	-
11	NickName	Text[50]	-
12	Title	Text[128]	-
13	InternalEMailAddress	Text[100]	-
14	JobTitle	Text[100]	-
15	MobileAlertEMail	Text[100]	-
16	PreferredEmailCode	Option	-
17	HomePhone	Text[50]	-
18	MobilePhone	Text[64]	-
19	PreferredPhoneCode	Option	-
20	PreferredAddressCode	Option	-
21	PhotoUrl	Text[200]	-
22	DomainName	Text[250]	-
23	PassportLo	Integer	-
24	CreatedOn	DateTime	-
25	PassportHi	Integer	-
26	DisabledReason	Text[250]	-
27	ModifiedOn	DateTime	-
28	CreatedBy	Guid	-
29	EmployeeId	Text[100]	-
30	ModifiedBy	Guid	-
31	IsDisabled	Boolean	-
32	GovernmentId	Text[100]	-
33	VersionNumber	BigInteger	-
34	ParentSystemUserIdName	Text[200]	-
35	Address1_AddressId	Guid	-
36	Address1_AddressTypeCode	Option	-
37	Address1_Name	Text[100]	-
38	Address1_Line1	Text[250]	-
39	Address1_Line2	Text[250]	-
40	Address1_Line3	Text[250]	-
41	Address1_City	Text[128]	-
42	Address1_StateOrProvince	Text[128]	-
43	Address1_County	Text[128]	-
44	Address1_Country	Text[128]	-
45	Address1_PostOfficeBox	Text[40]	-
46	Address1_PostalCode	Text[40]	-
47	Address1_UTCOffset	Integer	-
48	Address1_UPSZone	Text[4]	-
49	Address1_Latitude	Decimal	-
50	Address1_Telephone1	Text[64]	-
51	Address1_Longitude	Decimal	-
52	Address1_ShippingMethodCode	Option	-
53	Address1_Telephone2	Text[50]	-
54	Address1_Telephone3	Text[50]	-
55	Address1_Fax	Text[64]	-
56	Address2_AddressId	Guid	-
57	Address2_AddressTypeCode	Option	-
58	Address2_Name	Text[100]	-
59	Address2_Line1	Text[250]	-
60	Address2_Line2	Text[250]	-
61	Address2_Line3	Text[250]	-
62	Address2_City	Text[128]	-
63	Address2_StateOrProvince	Text[128]	-
64	Address2_County	Text[128]	-
65	Address2_Country	Text[128]	-
66	Address2_PostOfficeBox	Text[40]	-
67	Address2_PostalCode	Text[40]	-
68	Address2_UTCOffset	Integer	-
69	Address2_UPSZone	Text[4]	-
70	Address2_Latitude	Decimal	-
71	Address2_Telephone1	Text[50]	-
72	Address2_Longitude	Decimal	-
73	Address2_ShippingMethodCode	Option	-
74	Address2_Telephone2	Text[50]	-
75	Address2_Telephone3	Text[50]	-
76	Address2_Fax	Text[50]	-
77	CreatedByName	Text[200]	-
78	ModifiedByName	Text[200]	-
79	BusinessUnitIdName	Text[160]	-
80	Skills	Text[100]	-
81	DisplayInServiceViews	Boolean	-
82	SetupUser	Boolean	-
83	WindowsLiveID	Text[250]	-
84	IncomingEmailDeliveryMethod	Option	-
85	OutgoingEmailDeliveryMethod	Option	-
86	ImportSequenceNumber	Integer	-
87	AccessMode	Option	-
88	InviteStatusCode	Option	-
89	OverriddenCreatedOn	Date	-
90	UTCConversionTimeZoneCode	Integer	-
91	TimeZoneRuleVersionNumber	Integer	-
92	YomiFullName	Text[200]	-
93	YomiLastName	Text[64]	-
94	YomiMiddleName	Text[50]	-
95	YomiFirstName	Text[64]	-
96	IsIntegrationUser	Boolean	-
97	DefaultFiltersPopulated	Boolean	-
98	CreatedOnBehalfBy	Guid	-
99	ModifiedOnBehalfBy	Guid	-
100	ModifiedOnBehalfByName	Text[200]	-
101	CreatedOnBehalfByName	Text[200]	-
102	EmailRouterAccessApproval	Option	-
103	TransactionCurrencyId	Guid	-
104	TransactionCurrencyIdName	Text[100]	-
105	ExchangeRate	Decimal	-
106	CALType	Option	-
107	IsLicensed	Boolean	-
108	IsSyncWithDirectory	Boolean	-
109	YammerEmailAddress	Text[200]	-
110	YammerUserId	Text[128]	-
111	UserLicenseType	Integer	-
112	EntityImageId	Guid	-
113	Address2_Composite	Blob	-
114	Address1_Composite	Blob	-
115	ProcessId	Guid	-
116	StageId	Guid	-
117	IsEmailAddressApprovedByO365Ad	Boolean	-
118	TraversedPath	Text[250]	-
119	SharePointEmailAddress	Text[250]	-
120	ApplicationId	Guid	-

Keys, 2

Name	Fields	Obsolete
Key1, clustered	SystemUserId	-
Key2	FullName	-