Table "CRM Systemuser"
ID 5340
Namespace: Microsoft.Integration.D365Sales
Properties
| Name | Value |
|---|---|
| Caption | Dataverse Systemuser |
| Description | Person with access to the Microsoft Dataverse system and who owns objects in the Microsoft Dataverse database. |
| ExternalName | systemuser |
| TableType | CRM |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| SystemUserId | Guid | |
| OrganizationId | Guid | |
| BusinessUnitId | Guid | |
| ParentSystemUserId | Guid | |
| FirstName | Text[64] | |
| Salutation | Text[20] | |
| MiddleName | Text[50] | |
| LastName | Text[64] | |
| PersonalEMailAddress | Text[100] | |
| FullName | Text[200] | |
| NickName | Text[50] | |
| Title | Text[128] | |
| InternalEMailAddress | Text[100] | |
| JobTitle | Text[100] | |
| MobileAlertEMail | Text[100] | |
| PreferredEmailCode | Option | |
| HomePhone | Text[50] | |
| MobilePhone | Text[64] | |
| PreferredPhoneCode | Option | |
| PreferredAddressCode | Option | |
| PhotoUrl | Text[200] | |
| DomainName | Text[250] | |
| PassportLo | Integer | |
| CreatedOn | DateTime | |
| PassportHi | Integer | |
| DisabledReason | Text[250] | |
| ModifiedOn | DateTime | |
| CreatedBy | Guid | |
| EmployeeId | Text[100] | |
| ModifiedBy | Guid | |
| IsDisabled | Boolean | |
| GovernmentId | Text[100] | |
| VersionNumber | BigInteger | |
| ParentSystemUserIdName | Text[200] | |
| Address1_AddressId | Guid | |
| Address1_AddressTypeCode | Option | |
| Address1_Name | Text[100] | |
| Address1_Line1 | Text[250] | |
| Address1_Line2 | Text[250] | |
| Address1_Line3 | Text[250] | |
| Address1_City | Text[128] | |
| Address1_StateOrProvince | Text[128] | |
| Address1_County | Text[128] | |
| Address1_Country | Text[128] | |
| Address1_PostOfficeBox | Text[40] | |
| Address1_PostalCode | Text[40] | |
| Address1_UTCOffset | Integer | |
| Address1_UPSZone | Text[4] | |
| Address1_Latitude | Decimal | |
| Address1_Telephone1 | Text[64] | |
| Address1_Longitude | Decimal | |
| Address1_ShippingMethodCode | Option | |
| Address1_Telephone2 | Text[50] | |
| Address1_Telephone3 | Text[50] | |
| Address1_Fax | Text[64] | |
| Address2_AddressId | Guid | |
| Address2_AddressTypeCode | Option | |
| Address2_Name | Text[100] | |
| Address2_Line1 | Text[250] | |
| Address2_Line2 | Text[250] | |
| Address2_Line3 | Text[250] | |
| Address2_City | Text[128] | |
| Address2_StateOrProvince | Text[128] | |
| Address2_County | Text[128] | |
| Address2_Country | Text[128] | |
| Address2_PostOfficeBox | Text[40] | |
| Address2_PostalCode | Text[40] | |
| Address2_UTCOffset | Integer | |
| Address2_UPSZone | Text[4] | |
| Address2_Latitude | Decimal | |
| Address2_Telephone1 | Text[50] | |
| Address2_Longitude | Decimal | |
| Address2_ShippingMethodCode | Option | |
| Address2_Telephone2 | Text[50] | |
| Address2_Telephone3 | Text[50] | |
| Address2_Fax | Text[50] | |
| CreatedByName | Text[200] | |
| ModifiedByName | Text[200] | |
| BusinessUnitIdName | Text[160] | |
| Skills | Text[100] | |
| DisplayInServiceViews | Boolean | |
| SetupUser | Boolean | |
| WindowsLiveID | Text[250] | |
| IncomingEmailDeliveryMethod | Option | |
| OutgoingEmailDeliveryMethod | Option | |
| ImportSequenceNumber | Integer | |
| AccessMode | Option | |
| InviteStatusCode | Option | |
| OverriddenCreatedOn | Date | |
| UTCConversionTimeZoneCode | Integer | |
| TimeZoneRuleVersionNumber | Integer | |
| YomiFullName | Text[200] | |
| YomiLastName | Text[64] | |
| YomiMiddleName | Text[50] | |
| YomiFirstName | Text[64] | |
| IsIntegrationUser | Boolean | |
| DefaultFiltersPopulated | Boolean | |
| CreatedOnBehalfBy | Guid | |
| ModifiedOnBehalfBy | Guid | |
| ModifiedOnBehalfByName | Text[200] | |
| CreatedOnBehalfByName | Text[200] | |
| EmailRouterAccessApproval | Option | |
| TransactionCurrencyId | Guid | |
| TransactionCurrencyIdName | Text[100] | |
| ExchangeRate | Decimal | |
| CALType | Option | |
| IsLicensed | Boolean | |
| IsSyncWithDirectory | Boolean | |
| YammerEmailAddress | Text[200] | |
| YammerUserId | Text[128] | |
| UserLicenseType | Integer | |
| EntityImageId | Guid | |
| Address2_Composite | Blob | |
| Address1_Composite | Blob | |
| ProcessId | Guid | |
| StageId | Guid | |
| IsEmailAddressApprovedByO365Ad | Boolean | |
| TraversedPath | Text[250] | |
| SharePointEmailAddress | Text[250] | |
| ApplicationId | Guid | |
| SystemId | Guid | |
| SystemRowVersion | BigInteger |