SystemUser (User) Entity Metadata

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the system user (user) entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is SystemUser.

To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.

In This Topic

Entity Metadata

The following table shows the metadata for the system user (user) entity.

 

Metadata property Value

OTC

8

EntityLogicalName

systemuser

DisplayName

User

OwnershipType

BusinessOwned

IsCustomizable

True

Description

Person with access to the Microsoft CRM system and who owns objects in the Microsoft CRM database.

IsAvailableOffline

True

IsAuditEnabled

False

AutoRouteToOwnerQueue

False

CanBeInManyToMany

True

CanBePrimaryEntityInRelationship

True

CanBeRelatedEntityInRelationship

True

CanCreateAttributes

True

CanCreateCharts

True

CanCreateForms

True

CanCreateViews

True

CanModifyAdditionalSettings

True

CanTriggerWorkflow

True

IsActivity

False

IsActivityParty

True

IsChildEntity

False

IsConnectionsEnabled

canmodifyconnectionsettings

IsCustomEntity

False

IsDocumentManagementEnabled

False

IsDuplicateDetectionEnabled

False

IsEnabledForCharts

True

IsImportable

True

IsIntersect

False

IsMailMergeEnabled

False

IsManaged

True

IsMappable

True

IsReadingPaneEnabled

True

IsRenameable

True

IsValidForAdvancedFind

True

IsValidForQueue

False

IsVisibleInMobile

False

PrimaryIdAttribute

systemuserid

PrimaryNameAttribute

fullname

ReportViewName

FilteredSystemUser

RecurrenceBaseEntityLogicalName

x

DisplayCollectionName

Users

Privilege Metadata

The following table shows the privilege metadata for the system user (user) entity.

 

PrivilegeName Id Type CanBeBasic CanBeDeep CanBeGlobal CanBeLocal

prvAppendToUser

3399e6d2-dd3c-4a14-8433-39c1eca27aaa

AppendTo

False

True

True

True

prvAppendUser

84d66926-87d4-4489-b21a-451b01ec0c41

Append

False

True

True

True

prvAssignManager

28c3a786-82a5-4ff6-8d54-4876db4ba2f8

None

False

True

True

True

prvAssignTerritory

d5b32fc2-2f74-486b-a2d5-7a2506d1e580

None

False

True

True

True

prvCreateUser

0a3d4421-af6d-42ed-b3c2-b51deb73d1d5

Create

False

True

True

True

prvDisableUser

095860d1-42de-4efc-8d53-4b60e74d3d26

None

False

True

True

True

prvReadUser

76faad15-bc44-4f4d-84dc-dd1e1dda74d9

Read

False

True

True

True

prvReparentUser

2759a407-c37f-4955-aa64-05f44bb88402

None

False

True

True

True

prvWriteUser

dbb088d1-c7b7-40e7-8728-fdedb539319c

Write

False

True

True

True

Attribute Metadata

The following table shows the attribute metadata for the system user (user) entity. For a list of attributes that are for internal use only, see Internal Attributes.

 

LogicalName

Description

Type

SchemaName

IsCustomAttribute

IsCustomizable

RequiredLevel

IsValidForCreate

IsValidForRead

IsValidForUpdate

CanBeSecuredForCreate

CanBeSecuredForRead

CanBeSecuredForUpdate

IsAuditEnabled

IsManaged

IsPrimaryId

IsPrimaryName

IsRenameable

IsSecured

IsValidForAdvancedFind

DisplayName

DeprecatedVersion

accessmode

Type of user.

Picklist

AccessMode

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

Access Mode

activedirectoryguid

Active Directory object GUID for the system user.

Uniqueidentifier

ActiveDirectoryGuid

False

False

None

False

False

False

False

False

False

False

True

False

False

False

False

False

address1_addressid

Unique identifier for address 1.

Uniqueidentifier

Address1_AddressId

False

False

None

True

True

True

False

False

False

False

True

True

False

False

False

False

Address 1: ID

address1_addresstypecode

Type of address for address 1, such as billing, shipping, or primary address.

Picklist

Address1_AddressTypeCode

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Address 1: Address Type

address1_city

City name for address 1.

String

Address1_City

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

City

address1_country

Country/region name in address 1.

String

Address1_Country

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Country/Region

address1_county

County name for address 1.

String

Address1_County

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 1: County

address1_fax

Fax number for address 1.

String

Address1_Fax

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 1: Fax

address1_latitude

Latitude for address 1.

Double

Address1_Latitude

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 1: Latitude

address1_line1

First line for entering address 1 information.

String

Address1_Line1

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Street 1

address1_line2

Second line for entering address 1 information.

String

Address1_Line2

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Street 2

address1_line3

Third line for entering address 1 information.

String

Address1_Line3

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Street 3

address1_longitude

Longitude for address 1.

Double

Address1_Longitude

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 1: Longitude

address1_name

Name to enter for address 1.

String

Address1_Name

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 1: Name

address1_postalcode

ZIP Code or postal code for address 1.

String

Address1_PostalCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

ZIP/Postal Code

address1_postofficebox

Post office box number for address 1.

String

Address1_PostOfficeBox

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 1: Post Office Box

address1_shippingmethodcode

Method of shipment for address 1.

Picklist

Address1_ShippingMethodCode

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Address 1: Shipping Method

address1_stateorprovince

State or province for address 1.

String

Address1_StateOrProvince

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

State/Province

address1_telephone1

First telephone number associated with address 1.

String

Address1_Telephone1

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Main Phone

address1_telephone2

Second telephone number associated with address 1.

String

Address1_Telephone2

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Other Phone

address1_telephone3

Third telephone number associated with address 1.

String

Address1_Telephone3

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Pager

address1_upszone

United Parcel Service (UPS) zone for address 1.

String

Address1_UPSZone

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Address 1: UPS Zone

address1_utcoffset

UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.

Integer

Address1_UTCOffset

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Address 1: UTC Offset

address2_addressid

Unique identifier for address 2.

Uniqueidentifier

Address2_AddressId

False

False

None

True

True

True

False

False

False

False

True

True

False

False

False

False

Address 2: ID

address2_addresstypecode

Type of address for address 2, such as billing, shipping, or primary address.

Picklist

Address2_AddressTypeCode

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Address 2: Address Type

address2_city

City name for address 2.

String

Address2_City

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Other City

address2_country

Country/region name in address 2.

String

Address2_Country

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Other Country/Region

address2_county

County name for address 2.

String

Address2_County

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 2: County

address2_fax

Fax number for address 2.

String

Address2_Fax

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 2: Fax

address2_latitude

Latitude for address 2.

Double

Address2_Latitude

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 2: Latitude

address2_line1

First line for entering address 2 information.

String

Address2_Line1

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Other Street 1

address2_line2

Second line for entering address 2 information.

String

Address2_Line2

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Other Street 2

address2_line3

Third line for entering address 2 information.

String

Address2_Line3

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Other Street 3

address2_longitude

Longitude for address 2.

Double

Address2_Longitude

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 2: Longitude

address2_name

Name to enter for address 2.

String

Address2_Name

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 2: Name

address2_postalcode

ZIP Code or postal code for address 2.

String

Address2_PostalCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Other ZIP/Postal Code

address2_postofficebox

Post office box number for address 2.

String

Address2_PostOfficeBox

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 2: Post Office Box

address2_shippingmethodcode

Method of shipment for address 2.

Picklist

Address2_ShippingMethodCode

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Address 2: Shipping Method

address2_stateorprovince

State or province for address 2.

String

Address2_StateOrProvince

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Other State/Province

address2_telephone1

First telephone number associated with address 2.

String

Address2_Telephone1

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 2: Telephone 1

address2_telephone2

Second telephone number associated with address 2.

String

Address2_Telephone2

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 2: Telephone 2

address2_telephone3

Third telephone number associated with address 2.

String

Address2_Telephone3

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 2: Telephone 3

address2_upszone

United Parcel Service (UPS) zone for address 2.

String

Address2_UPSZone

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Address 2: UPS Zone

address2_utcoffset

UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time.

Integer

Address2_UTCOffset

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Address 2: UTC Offset

businessunitid

Unique identifier of the business unit with which the user is associated.

Lookup

BusinessUnitId

False

True

SystemRequired

True

True

False

False

False

False

True

True

False

False

True

False

True

Business Unit

calendarid

Fiscal calendar associated with the user.

Lookup

CalendarId

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Calendar

caltype

License type of user.

Picklist

CALType

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

License Type

createdby

Unique identifier of the user who created the user.

Lookup

CreatedBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Created By

createdon

Date and time when the user was created.

DateTime

CreatedOn

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Created On

createdonbehalfby

Unique identifier of the delegate user who created the systemuser.

Lookup

CreatedOnBehalfBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Created By (Delegate)

defaultfilterspopulated

Indicates if default outlook filters have been populated.

Boolean

DefaultFiltersPopulated

False

True

SystemRequired

False

True

False

False

False

False

True

True

False

False

False

False

False

Default Filters Populated

disabledreason

Reason for disabling the user.

String

DisabledReason

False

True

None

False

True

False

False

False

False

True

True

False

False

False

False

False

Disabled Reason

displayinserviceviews

Whether to display the user in service views.

Boolean

DisplayInServiceViews

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Display in Service Views

domainname

Active Directory domain of which the user is a member.

String

DomainName

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

User Name

emailrouteraccessapproval

Shows the status of the primary e-mail address.

Picklist

EmailRouterAccessApproval

False

True

SystemRequired

False

True

True

False

False

False

True

True

False

False

True

False

True

Primary E-mail Status

employeeid

Employee identifier for the user.

String

EmployeeId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Employee

exchangerate

Exchange rate for the currency associated with the systemuser with respect to the base currency.

Decimal

ExchangeRate

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Exchange Rate

firstname

First name of the user.

String

FirstName

False

True

ApplicationRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

First Name

fullname

Full name of the user.

String

FullName

False

True

None

False

True

False

False

False

False

True

True

False

True

True

False

True

Full Name

governmentid

Government identifier for the user.

String

GovernmentId

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Government

homephone

Home phone number for the user.

String

HomePhone

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Home Phone

importsequencenumber

Unique identifier of the data import or data migration that created this record.

Integer

ImportSequenceNumber

False

True

None

True

True

False

False

False

False

True

True

False

False

True

False

True

Import Sequence Number

incomingemaildeliverymethod

Incoming e-mail delivery method for the user.

Picklist

IncomingEmailDeliveryMethod

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

Incoming E-mail Delivery Method

internalemailaddress

Internal e-mail address for the user.

String

InternalEMailAddress

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

Primary E-mail

invitestatuscode

User invitation status.

Picklist

InviteStatusCode

False

True

ApplicationRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

Invitation Status

isactivedirectoryuser

Information about whether the user is an AD user.

Boolean

IsActiveDirectoryUser

False

True

SystemRequired

False

False

False

False

False

False

True

True

False

False

False

False

False

isdisabled

Information about whether the user is enabled.

Boolean

IsDisabled

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Status

isintegrationuser

Check if user is an integration user.

Boolean

IsIntegrationUser

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

Integration user mode

islicensed

Information about whether the user is licensed.

Boolean

IsLicensed

False

False

SystemRequired

True

True

True

False

False

False

False

True

False

False

False

False

False

User Licensed

issyncwithdirectory

Information about whether the user is synced with the directory.

Boolean

IsSyncWithDirectory

False

False

SystemRequired

True

True

True

False

False

False

False

True

False

False

False

False

False

User Synced

jobtitle

Job title of the user.

String

JobTitle

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Job Title

lastname

Last name of the user.

String

LastName

False

True

ApplicationRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

Last Name

middlename

Middle name of the user.

String

MiddleName

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Middle Name

mobilealertemail

Mobile alert e-mail address for the user.

String

MobileAlertEMail

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Mobile Alert E-mail

mobilephone

Mobile phone number for the user.

String

MobilePhone

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Mobile Phone

modifiedby

Unique identifier of the user who last modified the user.

Lookup

ModifiedBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified By

modifiedon

Date and time when the user was last modified.

DateTime

ModifiedOn

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified On

modifiedonbehalfby

Unique identifier of the delegate user who last modified the systemuser.

Lookup

ModifiedOnBehalfBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified By (Delegate)

nickname

Nickname of the user.

String

NickName

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Nickname

organizationid

Unique identifier of the organization associated with the user.

Uniqueidentifier

OrganizationId

False

True

SystemRequired

False

True

False

False

False

False

False

True

False

False

True

False

False

Organization

outgoingemaildeliverymethod

Outgoing e-mail delivery method for the user.

Picklist

OutgoingEmailDeliveryMethod

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

Outgoing E-mail Delivery Method

overriddencreatedon

Date and time that the record was migrated.

DateTime

OverriddenCreatedOn

False

True

None

True

True

False

False

False

False

True

True

False

False

True

False

True

Record Created On

parentsystemuserid

Unique identifier of the manager of the user.

Lookup

ParentSystemUserId

False

True

None

True

True

False

False

False

False

True

True

False

False

True

False

True

Manager

passporthi

For internal use only.

Integer

PassportHi

False

True

None

True

True

True

False

False

False

False

True

False

False

False

False

False

Passport Hi

passportlo

For internal use only.

Integer

PassportLo

False

True

None

True

True

True

False

False

False

False

True

False

False

False

False

False

Passport Lo

personalemailaddress

Personal e-mail address of the user.

String

PersonalEMailAddress

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

E-mail 2

photourl

URL for the Web site on which a photo of the user is located.

String

PhotoUrl

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Photo URL

preferredaddresscode

Preferred address for the user.

Picklist

PreferredAddressCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Preferred Address

preferredemailcode

Preferred e-mail address for the user.

Picklist

PreferredEmailCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Preferred E-mail

preferredphonecode

Preferred phone number for the user.

Picklist

PreferredPhoneCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Preferred Phone

queueid

Unique identifier of the default queue for the user.

Lookup

QueueId

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Default Queue

salutation

Salutation for correspondence with the user.

String

Salutation

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Salutation

setupuser

Check if user is a setup user.

Boolean

SetupUser

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

Restricted Access Mode

siteid

Site at which the user is located.

Lookup

SiteId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Site

skills

Skill set of the user.

String

Skills

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Skills

systemuserid

Unique identifier for the user.

Uniqueidentifier

SystemUserId

False

True

SystemRequired

True

True

False

False

False

False

False

True

True

False

True

False

True

User

territoryid

Unique identifier of the territory to which the user is assigned.

Lookup

TerritoryId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Territory

timezoneruleversionnumber

For internal use only.

Integer

TimeZoneRuleVersionNumber

False

True

None

True

True

True

False

False

False

False

True

False

False

False

False

False

Time Zone Rule Version Number

title

Title of the user.

String

Title

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Title

transactioncurrencyid

Unique identifier of the currency associated with the systemuser.

Lookup

TransactionCurrencyId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Currency

utcconversiontimezonecode

Time zone code that was in use when the record was created.

Integer

UTCConversionTimeZoneCode

False

True

None

True

True

True

False

False

False

False

True

False

False

False

False

False

UTC Conversion Time Zone Code

versionnumber

Version number of the user.

BigInt

VersionNumber

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Version number

windowsliveid

Windows Live ID

String

WindowsLiveID

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Windows Live ID

yammeremailaddress

User's Yammer login email address

String

YammerEmailAddress

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Yammer Email

yammeruserid

User's Yammer ID

String

YammerUserId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Yammer User ID

yomifirstname

Pronunciation of the first name of the user, written in phonetic hiragana or katakana characters.

String

YomiFirstName

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Yomi First Name

yomifullname

Pronunciation of the full name of the user, written in phonetic hiragana or katakana characters.

String

YomiFullName

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Yomi Full Name

yomilastname

Pronunciation of the last name of the user, written in phonetic hiragana or katakana characters.

String

YomiLastName

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Yomi Last Name

yomimiddlename

Pronunciation of the middle name of the user, written in phonetic hiragana or katakana characters.

String

YomiMiddleName

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Yomi Middle Name

Internal Attributes

The following table contains the attributes that are intended for internal use only.

 

Attribute logical name

yammeremailaddress

yammeruserid

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship with the system user (user) entity.

 

Relationship schema name Referencing entity

user_accounts

account

lk_accountbase_modifiedby

account

lk_accountbase_createdby

account

system_user_accounts

account

lk_accountbase_modifiedonbehalfby

account

lk_accountbase_createdonbehalfby

account

system_user_activity_parties

activityparty

lk_activitypointer_modifiedby

activitypointer

user_activity

activitypointer

lk_activitypointer_createdby

activitypointer

lk_activitypointer_modifiedonbehalfby

activitypointer

lk_activitypointer_createdonbehalfby

activitypointer

annotation_owning_user

annotation

lk_annotationbase_modifiedby

annotation

lk_annotationbase_modifiedonbehalfby

annotation

lk_annotationbase_createdby

annotation

lk_annotationbase_createdonbehalfby

annotation

lk_annualfiscalcalendar_modifiedby

annualfiscalcalendar

lk_annualfiscalcalendar_modifiedonbehalfby

annualfiscalcalendar

lk_annualfiscalcalendar_salespersonid

annualfiscalcalendar

lk_annualfiscalcalendar_createdonbehalfby

annualfiscalcalendar

lk_annualfiscalcalendar_createdby

annualfiscalcalendar

lk_applicationfile_createdonbehalfby

applicationfile

lk_applicationfile_modifiedonbehalfby

applicationfile

lk_applicationfile_createdby

applicationfile

lk_applicationfile_modifiedby

applicationfile

user_appointment

appointment

lk_appointment_createdonbehalfby

appointment

lk_appointment_modifiedonbehalfby

appointment

lk_appointment_createdby

appointment

lk_appointment_modifiedby

appointment

lk_asyncoperation_createdonbehalfby

asyncoperation

lk_asyncoperation_modifiedonbehalfby

asyncoperation

lk_asyncoperation_createdby

asyncoperation

SystemUser_AsyncOperations

asyncoperation

lk_asyncoperation_modifiedby

asyncoperation

system_user_asyncoperation

asyncoperation

modifiedonbehalfby_attributemap

attributemap

modifiedby_attributemap

attributemap

createdby_attributemap

attributemap

createdonbehalfby_attributemap

attributemap

lk_audit_userid

audit

lk_audit_callinguserid

audit

SystemUser_BulkDeleteFailures

bulkdeletefailure

lk_bulkdeleteoperation_modifiedonbehalfby

bulkdeleteoperation

lk_bulkdeleteoperationbase_createdby

bulkdeleteoperation

lk_bulkdeleteoperation_createdonbehalfby

bulkdeleteoperation

lk_bulkdeleteoperationbase_modifiedby

bulkdeleteoperation

lk_BulkOperation_createdonbehalfby

bulkoperation

user_BulkOperation

bulkoperation

lk_BulkOperation_modifiedonbehalfby

bulkoperation

lk_BulkOperation_modifiedby

bulkoperation

lk_BulkOperation_createdby

bulkoperation

lk_businessunit_createdonbehalfby

businessunit

lk_businessunit_modifiedonbehalfby

businessunit

lk_businessunitbase_modifiedby

businessunit

lk_businessunitbase_createdby

businessunit

bizmap_systemuser_businessid

businessunitmap

lk_businessunitnewsarticlebase_modifiedby

businessunitnewsarticle

lk_businessunitnewsarticle_createdonbehalfby

businessunitnewsarticle

lk_businessunitnewsarticle_modifiedonbehalfby

businessunitnewsarticle

lk_businessunitnewsarticlebase_createdby

businessunitnewsarticle

lk_calendar_modifiedby

calendar

lk_calendar_createdonbehalfby

calendar

lk_calendar_modifiedonbehalfby

calendar

lk_calendar_createdby

calendar

lk_calendarrule_modifiedby

calendarrule

lk_calendarrule_createdonbehalfby

calendarrule

lk_calendarrule_createdby

calendarrule

lk_calendarrule_modifiedonbehalfby

calendarrule

lk_campaign_createdby

campaign

lk_campaign_modifiedonbehalfby

campaign

lk_campaign_createdonbehalfby

campaign

SystemUser_Campaigns

campaign

lk_campaign_modifiedby

campaign

lk_campaignactivity_modifiedonbehalfby

campaignactivity

lk_campaignactivity_modifiedby

campaignactivity

lk_campaignactivity_createdby

campaignactivity

lk_campaignactivity_createdonbehalfby

campaignactivity

user_campaignactivity

campaignactivity

user_campaignresponse

campaignresponse

lk_campaignresponse_createdonbehalfby

campaignresponse

lk_campaignresponse_modifiedonbehalfby

campaignresponse

lk_campaignresponse_modifiedby

campaignresponse

lk_campaignresponse_createdby

campaignresponse

lk_columnmapping_createdby

columnmapping

lk_columnmapping_createdonbehalfby

columnmapping

lk_columnmapping_modifiedonbehalfby

columnmapping

lk_columnmapping_modifiedby

columnmapping

lk_competitor_createdonbehalfby

competitor

lk_competitor_modifiedonbehalfby

competitor

lk_competitorbase_modifiedby

competitor

lk_competitorbase_createdby

competitor

lk_competitoraddressbase_createdby

competitoraddress

lk_competitoraddressbase_modifiedby

competitoraddress

lk_competitoraddress_createdonbehalfby

competitoraddress

lk_competitoraddress_modifiedonbehalfby

competitoraddress

createdby_connection

connection

lk_connectionbase_modifiedonbehalfby

connection

modifiedby_connection

connection

lk_connectionbase_createdonbehalfby

connection

systemuser_connections1

connection

systemuser_connections2

connection

createdby_connection_role

connectionrole

lk_connectionrolebase_createdonbehalfby

connectionrole

modifiedby_connection_role

connectionrole

lk_connectionrolebase_modifiedonbehalfby

connectionrole

lk_constraintbasedgroup_modifiedby

constraintbasedgroup

lk_constraintbasedgroup_modifiedonbehalfby

constraintbasedgroup

constraintbasedgroup_systemuser

constraintbasedgroup

lk_constraintbasedgroup_createdonbehalfby

constraintbasedgroup

lk_constraintbasedgroup_createdby

constraintbasedgroup

system_user_contacts

contact

lk_contactbase_createdby

contact

contact_owning_user

contact

lk_contact_createdonbehalfby

contact

lk_contact_modifiedonbehalfby

contact

lk_contactbase_modifiedby

contact

lk_contractbase_createdby

contract

system_user_service_contracts

contract

lk_contract_modifiedonbehalfby

contract

lk_contractbase_modifiedby

contract

lk_contract_createdonbehalfby

contract

lk_contractdetailbase_modifiedby

contractdetail

lk_contractdetail_modifiedonbehalfby

contractdetail

lk_contractdetail_createdonbehalfby

contractdetail

lk_contractdetailbase_createdby

contractdetail

lk_contracttemplate_createdonbehalfby

contracttemplate

lk_contracttemplatebase_modifiedby

contracttemplate

lk_contracttemplatebase_createdby

contracttemplate

lk_contracttemplate_modifiedonbehalfby

contracttemplate

lk_customeraddressbase_modifiedby

customeraddress

lk_customeraddressbase_createdby

customeraddress

lk_customeraddress_modifiedonbehalfby

customeraddress

lk_customeraddress_createdonbehalfby

customeraddress

lk_customeropportunityrole_modifiedonbehalfby

customeropportunityrole

lk_customeropportunityrole_createdonbehalfby

customeropportunityrole

lk_customeropportunityrole_createdby

customeropportunityrole

user_customer_opportunity_roles

customeropportunityrole

lk_customeropportunityrole_modifiedby

customeropportunityrole

createdby_customer_relationship

customerrelationship

modifiedby_customer_relationship

customerrelationship

user_customer_relationship

customerrelationship

modifiedonbehalfby_customer_relationship

customerrelationship

createdonbehalfby_customer_relationship

customerrelationship

lk_discountbase_modifiedby

discount

lk_discount_modifiedonbehalfby

discount

lk_discount_createdonbehalfby

discount

lk_discountbase_createdby

discount

lk_discounttypebase_modifiedby

discounttype

lk_discounttypebase_createdby

discounttype

lk_discounttype_createdonbehalfby

discounttype

lk_discounttype_modifiedonbehalfby

discounttype

lk_DisplayStringbase_modifiedby

displaystring

lk_DisplayStringbase_createdby

displaystring

lk_DisplayStringbase_modifiedonbehalfby

displaystring

lk_DisplayStringbase_createdonbehalfby

displaystring

lk_documentindex_createdonbehalfby

documentindex

lk_documentindex_createdby

documentindex

lk_documentindex_modifiedby

documentindex

lk_documentindex_modifiedonbehalfby

documentindex

SystemUser_DuplicateMatchingRecord

duplicaterecord

SystemUser_DuplicateBaseRecord

duplicaterecord

lk_duplicaterule_createdonbehalfby

duplicaterule

SystemUser_DuplicateRules

duplicaterule

lk_duplicaterule_modifiedonbehalfby

duplicaterule

lk_duplicaterulebase_createdby

duplicaterule

lk_duplicaterulebase_modifiedby

duplicaterule

lk_duplicaterulecondition_modifiedonbehalfby

duplicaterulecondition

lk_duplicaterulecondition_createdonbehalfby

duplicaterulecondition

lk_duplicateruleconditionbase_modifiedby

duplicaterulecondition

lk_duplicateruleconditionbase_createdby

duplicaterulecondition

lk_email_modifiedonbehalfby

email

lk_email_modifiedby

email

lk_email_createdby

email

user_email

email

lk_email_createdonbehalfby

email

lk_entitymap_modifiedonbehalfby

entitymap

createdby_entitymap

entitymap

modifiedby_entitymap

entitymap

lk_entitymap_createdonbehalfby

entitymap

lk_equipment_modifiedby

equipment

lk_equipment_modifiedonbehalfby

equipment

equipment_systemuser

equipment

lk_equipment_createdonbehalfby

equipment

lk_equipment_createdby

equipment

lk_fax_modifiedby

fax

lk_fax_createdby

fax

lk_fax_createdonbehalfby

fax

user_fax

fax

lk_fax_modifiedonbehalfby

fax

lk_fieldsecurityprofile_createdonbehalfby

fieldsecurityprofile

lk_fieldsecurityprofile_createdby

fieldsecurityprofile

lk_fieldsecurityprofile_modifiedonbehalfby

fieldsecurityprofile

lk_fieldsecurityprofile_modifiedby

fieldsecurityprofile

lk_fixedmonthlyfiscalcalendar_modifiedonbehalfby

fixedmonthlyfiscalcalendar

lk_fixedmonthlyfiscalcalendar_salespersonid

fixedmonthlyfiscalcalendar

lk_fixedmonthlyfiscalcalendar_createdby

fixedmonthlyfiscalcalendar

lk_fixedmonthlyfiscalcalendar_modifiedby

fixedmonthlyfiscalcalendar

lk_fixedmonthlyfiscalcalendar_createdonbehalfby

fixedmonthlyfiscalcalendar

lk_goal_createdby

goal

lk_goal_createdonbehalfby

goal

lk_goal_modifiedby

goal

lk_goal_modifiedonbehalfby

goal

user_goal

goal

user_goal_goalowner

goal

lk_goalrollupquery_createdby

goalrollupquery

lk_goalrollupquery_createdonbehalfby

goalrollupquery

lk_goalrollupquery_modifiedby

goalrollupquery

lk_goalrollupquery_modifiedonbehalfby

goalrollupquery

lk_import_createdonbehalfby

import

SystemUser_Imports

import

lk_importbase_createdby

import

lk_import_modifiedonbehalfby

import

lk_importbase_modifiedby

import

lk_importdatabase_modifiedby

importdata

lk_importdata_createdonbehalfby

importdata

SystemUser_ImportData

importdata

lk_importdatabase_createdby

importdata

lk_importdata_modifiedonbehalfby

importdata

lk_importentitymapping_modifiedonbehalfby

importentitymapping

lk_importentitymapping_createdonbehalfby

importentitymapping

lk_importentitymapping_createdby

importentitymapping

lk_importentitymapping_modifiedby

importentitymapping

lk_importfilebase_createdonbehalfby

importfile

lk_importfilebase_modifiedby

importfile

SystemUser_ImportFiles

importfile

lk_importfilebase_createdby

importfile

ImportFile_SystemUser

importfile

lk_importfilebase_modifiedonbehalfby

importfile

lk_importjobbase_modifiedonbehalfby

importjob

lk_importjobbase_createdby

importjob

lk_importjobbase_createdonbehalfby

importjob

lk_importjobbase_modifiedby

importjob

lk_importlog_modifiedonbehalfby

importlog

lk_importlogbase_createdby

importlog

lk_importlog_createdonbehalfby

importlog

SystemUser_ImportLogs

importlog

lk_importlogbase_modifiedby

importlog

lk_importmapbase_createdby

importmap

lk_importmap_createdonbehalfby

importmap

SystemUser_ImportMaps

importmap

lk_importmap_modifiedonbehalfby

importmap

lk_importmapbase_modifiedby

importmap

lk_incidentbase_modifiedonbehalfby

incident

lk_incidentbase_createdonbehalfby

incident

lk_incidentbase_modifiedby

incident

lk_incidentbase_createdby

incident

system_user_incidents

incident

lk_incidentresolution_createdby

incidentresolution

lk_incidentresolution_modifiedonbehalfby

incidentresolution

lk_incidentresolution_modifiedby

incidentresolution

user_incidentresolution

incidentresolution

lk_incidentresolution_createdonbehalfby

incidentresolution

lk_integrationstatus_modifiedonbehalfby

integrationstatus

lk_integrationstatus_createdonbehalfby

integrationstatus

lk_integrationstatus_modifiedby

integrationstatus

lk_integrationstatus_createdby

integrationstatus

lk_internaladdressbase_createdby

internaladdress

lk_internaladdress_createdonbehalfby

internaladdress

lk_internaladdress_modifiedonbehalfby

internaladdress

systemuser_internal_addresses

internaladdress

lk_internaladdressbase_modifiedby

internaladdress

lk_invoice_modifiedonbehalfby

invoice

lk_invoice_createdonbehalfby

invoice

lk_invoicebase_createdby

invoice

lk_invoicebase_modifiedby

invoice

system_user_invoices

invoice

lk_invoicedetailbase_modifiedby

invoicedetail

lk_invoicedetail_createdonbehalfby

invoicedetail

lk_invoicedetail_modifiedonbehalfby

invoicedetail

system_user_invoicedetail

invoicedetail

lk_invoicedetailbase_createdby

invoicedetail

lk_isvconfigbase_createdby

isvconfig

lk_isvconfigbase_modifiedby

isvconfig

lk_isvconfig_modifiedonbehalfby

isvconfig

lk_isvconfig_createdonbehalfby

isvconfig

lk_kbarticle_createdonbehalfby

kbarticle

lk_kbarticle_modifiedonbehalfby

kbarticle

lk_kbarticlebase_createdby

kbarticle

lk_kbarticlebase_modifiedby

kbarticle

lk_kbarticlecommentbase_modifiedby

kbarticlecomment

lk_kbarticlecommentbase_createdby

kbarticlecomment

lk_kbarticlecomment_createdonbehalfby

kbarticlecomment

lk_kbarticlecomment_modifiedonbehalfby

kbarticlecomment

lk_kbarticletemplatebase_modifiedby

kbarticletemplate

lk_kbarticletemplate_modifiedonbehalfby

kbarticletemplate

lk_kbarticletemplatebase_createdby

kbarticletemplate

lk_kbarticletemplate_createdonbehalfby

kbarticletemplate

lk_leadbase_modifiedby

lead

lk_leadbase_createdby

lead

lk_lead_modifiedonbehalfby

lead

lk_lead_createdonbehalfby

lead

lead_owning_user

lead

lk_leadaddress_createdonbehalfby

leadaddress

lk_leadaddressbase_modifiedby

leadaddress

lk_leadaddressbase_createdby

leadaddress

lk_leadaddress_modifiedonbehalfby

leadaddress

lk_letter_modifiedonbehalfby

letter

lk_letter_createdby

letter

user_letter

letter

lk_letter_modifiedby

letter

lk_letter_createdonbehalfby

letter

lk_list_modifiedby

list

lk_list_createdby

list

lk_list_modifiedonbehalfby

list

user_list

list

lk_list_createdonbehalfby

list

lk_listmember_createdonbehalfby

listmember

lk_listmember_modifiedonbehalfby

listmember

lk_listmember_createdby

listmember

lk_listmember_modifiedby

listmember

lk_lookupmapping_modifiedby

lookupmapping

lk_lookupmapping_createdonbehalfby

lookupmapping

lk_lookupmapping_modifiedonbehalfby

lookupmapping

lk_lookupmapping_createdby

lookupmapping

lk_mailmergetemplate_modifiedonbehalfby

mailmergetemplate

lk_mailmergetemplate_createdonbehalfby

mailmergetemplate

lk_mailmergetemplatebase_createdby

mailmergetemplate

lk_mailmergetemplatebase_modifiedby

mailmergetemplate

lk_metric_createdby

metric

lk_metric_createdonbehalfby

metric

lk_metric_modifiedby

metric

lk_metric_modifiedonbehalfby

metric

lk_monthlyfiscalcalendar_salespersonid

monthlyfiscalcalendar

lk_monthlyfiscalcalendar_modifiedby

monthlyfiscalcalendar

lk_monthlyfiscalcalendar_createdby

monthlyfiscalcalendar

lk_monthlyfiscalcalendar_modifiedonbehalfby

monthlyfiscalcalendar

lk_monthlyfiscalcalendar_createdonbehalfby

monthlyfiscalcalendar

lk_msdyn_postalbum_createdby

msdyn_postalbum

lk_msdyn_postalbum_createdonbehalfby

msdyn_postalbum

lk_msdyn_postalbum_modifiedby

msdyn_postalbum

lk_msdyn_postalbum_modifiedonbehalfby

msdyn_postalbum

user_msdyn_postalbum

msdyn_postalbum

lk_msdyn_postconfig_createdby

msdyn_postconfig

lk_msdyn_postconfig_createdonbehalfby

msdyn_postconfig

lk_msdyn_postconfig_modifiedby

msdyn_postconfig

lk_msdyn_postconfig_modifiedonbehalfby

msdyn_postconfig

lk_msdyn_postruleconfig_createdby

msdyn_postruleconfig

lk_msdyn_postruleconfig_createdonbehalfby

msdyn_postruleconfig

lk_msdyn_postruleconfig_modifiedby

msdyn_postruleconfig

lk_msdyn_postruleconfig_modifiedonbehalfby

msdyn_postruleconfig

lk_msdyn_wallsavedquery_createdby

msdyn_wallsavedquery

lk_msdyn_wallsavedquery_createdonbehalfby

msdyn_wallsavedquery

lk_msdyn_wallsavedquery_modifiedby

msdyn_wallsavedquery

lk_msdyn_wallsavedquery_modifiedonbehalfby

msdyn_wallsavedquery

lk_msdyn_wallsavedqueryusersettings_createdby

msdyn_wallsavedqueryusersettings

lk_msdyn_wallsavedqueryusersettings_createdonbehalfby

msdyn_wallsavedqueryusersettings

lk_msdyn_wallsavedqueryusersettings_modifiedby

msdyn_wallsavedqueryusersettings

lk_msdyn_wallsavedqueryusersettings_modifiedonbehalfby

msdyn_wallsavedqueryusersettings

user_msdyn_wallsavedqueryusersettings

msdyn_wallsavedqueryusersettings

msdyn_systemuser_wallsavedqueryusersettings_userid

msdyn_wallsavedqueryusersettings

lk_opportunity_modifiedonbehalfby

opportunity

lk_opportunity_createdonbehalfby

opportunity

lk_opportunitybase_createdby

opportunity

opportunity_owning_user

opportunity

lk_opportunitybase_modifiedby

opportunity

user_opportunityclose

opportunityclose

lk_opportunityclose_createdby

opportunityclose

lk_opportunityclose_createdonbehalfby

opportunityclose

lk_opportunityclose_modifiedonbehalfby

opportunityclose

lk_opportunityclose_modifiedby

opportunityclose

lk_opportunityproductbase_createdby

opportunityproduct

lk_opportunityproduct_createdonbehalfby

opportunityproduct

lk_opportunityproductbase_modifiedby

opportunityproduct

lk_opportunityproduct_modifiedonbehalfby

opportunityproduct

lk_orderclose_modifiedby

orderclose

lk_orderclose_createdby

orderclose

user_orderclose

orderclose

lk_orderclose_modifiedonbehalfby

orderclose

lk_orderclose_createdonbehalfby

orderclose

lk_organizationbase_createdby

organization

lk_organization_createdonbehalfby

organization

lk_organization_modifiedonbehalfby

organization

lk_organizationbase_modifiedby

organization

lk_ownermapping_createdonbehalfby

ownermapping

OwnerMapping_SystemUser

ownermapping

lk_ownermapping_modifiedonbehalfby

ownermapping

lk_ownermapping_modifiedby

ownermapping

lk_ownermapping_createdby

ownermapping

lk_phonecall_modifiedby

phonecall

lk_phonecall_createdonbehalfby

phonecall

lk_phonecall_modifiedonbehalfby

phonecall

lk_phonecall_createdby

phonecall

user_phonecall

phonecall

lk_picklistmapping_createdby

picklistmapping

lk_picklistmapping_createdonbehalfby

picklistmapping

lk_picklistmapping_modifiedby

picklistmapping

lk_picklistmapping_modifiedonbehalfby

picklistmapping

lk_pluginassembly_modifiedonbehalfby

pluginassembly

createdby_pluginassembly

pluginassembly

modifiedby_pluginassembly

pluginassembly

lk_pluginassembly_createdonbehalfby

pluginassembly

lk_plugintype_createdonbehalfby

plugintype

lk_plugintype_modifiedonbehalfby

plugintype

modifiedby_plugintype

plugintype

createdby_plugintype

plugintype

createdby_plugintypestatistic

plugintypestatistic

lk_plugintypestatisticbase_modifiedonbehalfby

plugintypestatistic

modifiedby_plugintypestatistic

plugintypestatistic

lk_plugintypestatisticbase_createdonbehalfby

plugintypestatistic

lk_post_modifiedonbehalfby

post

lk_post_createdby

post

lk_post_createdonbehalfby

post

lk_post_modifiedby

post

lk_postcomment_createdby

postcomment

lk_postcomment_createdonbehalfby

postcomment

lk_PostFollow_createdby

postfollow

systemuser_PostFollows

postfollow

user_owner_postfollows

postfollow

lk_postfollow_createdonbehalfby

postfollow

lk_postlike_createdonbehalfby

postlike

lk_postlike_createdby

postlike

systemuser_PostRegardings

postregarding

systemuser_PostRoles

postrole

lk_pricelevel_modifiedonbehalfby

pricelevel

lk_pricelevelbase_modifiedby

pricelevel

lk_pricelevelbase_createdby

pricelevel

lk_pricelevel_createdonbehalfby

pricelevel

systemuser_principalobjectattributeaccess_principalid

principalobjectattributeaccess

systemuser_principalobjectattributeaccess

principalobjectattributeaccess

lk_processsession_completedby

processsession

lk_processsessionbase_createdonbehalfby

processsession

SystemUser_ProcessSessions

processsession

lk_processsessionbase_modifiedonbehalfby

processsession

lk_processsession_createdby

processsession

lk_processsession_executedby

processsession

lk_processsession_startedby

processsession

lk_processsession_modifiedby

processsession

lk_processsession_canceledby

processsession

lk_productbase_createdby

product

lk_product_createdonbehalfby

product

lk_product_modifiedonbehalfby

product

lk_productbase_modifiedby

product

lk_productpricelevelbase_createdby

productpricelevel

lk_productpricelevel_createdonbehalfby

productpricelevel

lk_productpricelevelbase_modifiedby

productpricelevel

lk_productpricelevel_modifiedonbehalfby

productpricelevel

lk_publisher_createdby

publisher

lk_publisher_modifiedby

publisher

lk_publisherbase_modifiedonbehalfby

publisher

lk_publisherbase_createdonbehalfby

publisher

lk_publisheraddressbase_modifiedonbehalfby

publisheraddress

lk_publisheraddressbase_modifiedby

publisheraddress

lk_publisheraddressbase_createdonbehalfby

publisheraddress

lk_publisheraddressbase_createdby

publisheraddress

lk_quarterlyfiscalcalendar_modifiedby

quarterlyfiscalcalendar

lk_quarterlyfiscalcalendar_salespersonid

quarterlyfiscalcalendar

lk_quarterlyfiscalcalendar_createdby

quarterlyfiscalcalendar

lk_quarterlyfiscalcalendar_modifiedonbehalfby

quarterlyfiscalcalendar

lk_quarterlyfiscalcalendar_createdonbehalfby

quarterlyfiscalcalendar

lk_queue_modifiedonbehalfby

queue

lk_queuebase_createdby

queue

queue_primary_user

queue

lk_queuebase_modifiedby

queue

lk_queue_createdonbehalfby

queue

lk_queueitem_modifiedonbehalfby

queueitem

lk_queueitembase_workerid

queueitem

lk_queueitem_createdonbehalfby

queueitem

lk_queueitembase_createdby

queueitem

lk_queueitembase_modifiedby

queueitem

lk_quote_createdonbehalfby

quote

system_user_quotes

quote

lk_quotebase_modifiedby

quote

lk_quote_modifiedonbehalfby

quote

lk_quotebase_createdby

quote

lk_quoteclose_modifiedby

quoteclose

lk_quoteclose_modifiedonbehalfby

quoteclose

lk_quoteclose_createdonbehalfby

quoteclose

user_quoteclose

quoteclose

lk_quoteclose_createdby

quoteclose

lk_quotedetailbase_modifiedby

quotedetail

lk_quotedetail_modifiedonbehalfby

quotedetail

system_user_quotedetail

quotedetail

lk_quotedetail_createdonbehalfby

quotedetail

lk_quotedetailbase_createdby

quotedetail

lk_recurrencerule_modifiedby

recurrencerule

lk_recurrencerulebase_createdonbehalfby

recurrencerule

lk_recurrencerule_createdby

recurrencerule

lk_recurrencerulebase_modifiedonbehalfby

recurrencerule

lk_recurringappointmentmaster_createdonbehalfby

recurringappointmentmaster

lk_recurringappointmentmaster_modifiedby

recurringappointmentmaster

user_recurringappointmentmaster

recurringappointmentmaster

lk_recurringappointmentmaster_createdby

recurringappointmentmaster

lk_recurringappointmentmaster_modifiedonbehalfby

recurringappointmentmaster

lk_relationshiprole_createdonbehalfby

relationshiprole

createdby_relationship_role

relationshiprole

lk_relationshiprole_modifiedonbehalfby

relationshiprole

modifiedby_relationship_role

relationshiprole

createdby_relationship_role_map

relationshiprolemap

lk_relationshiprolemap_createdonbehalfby

relationshiprolemap

modifiedby_relationship_role_map

relationshiprolemap

lk_relationshiprolemap_modifiedonbehalfby

relationshiprolemap

lk_report_modifiedonbehalfby

report

lk_reportbase_modifiedby

report

lk_reportbase_createdby

report

lk_report_createdonbehalfby

report

lk_reportcategorybase_createdby

reportcategory

lk_reportcategorybase_modifiedby

reportcategory

lk_reportcategory_modifiedonbehalfby

reportcategory

lk_reportcategory_createdonbehalfby

reportcategory

lk_reportentity_createdonbehalfby

reportentity

lk_reportentitybase_modifiedby

reportentity

lk_reportentity_modifiedonbehalfby

reportentity

lk_reportentitybase_createdby

reportentity

lk_reportlink_modifiedonbehalfby

reportlink

lk_reportlinkbase_createdby

reportlink

lk_reportlinkbase_modifiedby

reportlink

lk_reportlink_createdonbehalfby

reportlink

lk_reportvisibilitybase_modifiedby

reportvisibility

lk_reportvisibilitybase_createdby

reportvisibility

lk_reportvisibility_modifiedonbehalfby

reportvisibility

lk_reportvisibility_createdonbehalfby

reportvisibility

systemuser_resources

resource

lk_resourcespec_modifiedonbehalfby

resourcespec

lk_resourcespec_createdby

resourcespec

lk_resourcespec_createdonbehalfby

resourcespec

lk_resourcespec_modifiedby

resourcespec

lk_role_createdonbehalfby

role

lk_rolebase_modifiedby

role

lk_rolebase_createdby

role

lk_role_modifiedonbehalfby

role

lk_rollupfield_createdby

rollupfield

lk_rollupfield_createdonbehalfby

rollupfield

lk_rollupfield_modifiedby

rollupfield

lk_rollupfield_modifiedonbehalfby

rollupfield

system_user_sales_literature

salesliterature

lk_salesliteraturebase_createdby

salesliterature

lk_salesliterature_createdonbehalfby

salesliterature

lk_salesliterature_modifiedonbehalfby

salesliterature

lk_salesliteraturebase_modifiedby

salesliterature

lk_salesliteratureitem_createdonbehalfby

salesliteratureitem

lk_salesliteratureitembase_createdby

salesliteratureitem

lk_salesliteratureitem_modifiedonbehalfby

salesliteratureitem

lk_salesliteratureitembase_modifiedby

salesliteratureitem

lk_salesorderbase_createdby

salesorder

lk_salesorder_modifiedonbehalfby

salesorder

lk_salesorder_createdonbehalfby

salesorder

system_user_orders

salesorder

lk_salesorderbase_modifiedby

salesorder

lk_salesorderdetailbase_createdby

salesorderdetail

system_user_salesorderdetail

salesorderdetail

lk_salesorderdetail_modifiedonbehalfby

salesorderdetail

lk_salesorderdetailbase_modifiedby

salesorderdetail

lk_salesorderdetail_createdonbehalfby

salesorderdetail

lk_savedquerybase_createdby

savedquery

lk_savedquery_modifiedonbehalfby

savedquery

lk_savedquerybase_modifiedby

savedquery

lk_savedquery_createdonbehalfby

savedquery

lk_savedqueryvisualizationbase_modifiedby

savedqueryvisualization

lk_savedqueryvisualizationbase_createdby

savedqueryvisualization

lk_savedqueryvisualizationbase_createdonbehalfby

savedqueryvisualization

lk_savedqueryvisualizationbase_modifiedonbehalfby

savedqueryvisualization

lk_sdkmessage_modifiedonbehalfby

sdkmessage

modifiedby_sdkmessage

sdkmessage

lk_sdkmessage_createdonbehalfby

sdkmessage

createdby_sdkmessage

sdkmessage

lk_sdkmessagefilter_createdonbehalfby

sdkmessagefilter

lk_sdkmessagefilter_modifiedonbehalfby

sdkmessagefilter

modifiedby_sdkmessagefilter

sdkmessagefilter

createdby_sdkmessagefilter

sdkmessagefilter

lk_sdkmessagepair_createdonbehalfby

sdkmessagepair

modifiedby_sdkmessagepair

sdkmessagepair

lk_sdkmessagepair_modifiedonbehalfby

sdkmessagepair

createdby_sdkmessagepair

sdkmessagepair

impersonatinguserid_sdkmessageprocessingstep

sdkmessageprocessingstep

createdby_sdkmessageprocessingstep

sdkmessageprocessingstep

modifiedby_sdkmessageprocessingstep

sdkmessageprocessingstep

lk_sdkmessageprocessingstep_modifiedonbehalfby

sdkmessageprocessingstep

lk_sdkmessageprocessingstep_createdonbehalfby

sdkmessageprocessingstep

lk_sdkmessageprocessingstepimage_modifiedonbehalfby

sdkmessageprocessingstepimage

lk_sdkmessageprocessingstepimage_createdonbehalfby

sdkmessageprocessingstepimage

createdby_sdkmessageprocessingstepimage

sdkmessageprocessingstepimage

modifiedby_sdkmessageprocessingstepimage

sdkmessageprocessingstepimage

modifiedby_sdkmessageprocessingstepsecureconfig

sdkmessageprocessingstepsecureconfig

lk_sdkmessageprocessingstepsecureconfig_modifiedonbehalfby

sdkmessageprocessingstepsecureconfig

createdby_sdkmessageprocessingstepsecureconfig

sdkmessageprocessingstepsecureconfig

lk_sdkmessageprocessingstepsecureconfig_createdonbehalfby

sdkmessageprocessingstepsecureconfig

modifiedby_sdkmessagerequest

sdkmessagerequest

createdby_sdkmessagerequest

sdkmessagerequest

lk_sdkmessagerequest_modifiedonbehalfby

sdkmessagerequest

lk_sdkmessagerequest_createdonbehalfby

sdkmessagerequest

lk_sdkmessagerequestfield_createdonbehalfby

sdkmessagerequestfield

createdby_sdkmessagerequestfield

sdkmessagerequestfield

lk_sdkmessagerequestfield_modifiedonbehalfby

sdkmessagerequestfield

modifiedby_sdkmessagerequestfield

sdkmessagerequestfield

modifiedby_sdkmessageresponse

sdkmessageresponse

createdby_sdkmessageresponse

sdkmessageresponse

lk_sdkmessageresponse_createdonbehalfby

sdkmessageresponse

lk_sdkmessageresponse_modifiedonbehalfby

sdkmessageresponse

lk_sdkmessageresponsefield_createdonbehalfby

sdkmessageresponsefield

lk_sdkmessageresponsefield_modifiedonbehalfby

sdkmessageresponsefield

modifiedby_sdkmessageresponsefield

sdkmessageresponsefield

createdby_sdkmessageresponsefield

sdkmessageresponsefield

lk_semiannualfiscalcalendar_modifiedby

semiannualfiscalcalendar

lk_semiannualfiscalcalendar_modifiedonbehalfby

semiannualfiscalcalendar

lk_semiannualfiscalcalendar_createdby

semiannualfiscalcalendar

lk_semiannualfiscalcalendar_salespersonid

semiannualfiscalcalendar

lk_semiannualfiscalcalendar_createdonbehalfby

semiannualfiscalcalendar

lk_service_modifiedonbehalfby

service

lk_service_createdonbehalfby

service

lk_service_createdby

service

lk_service_modifiedby

service

system_user_service_appointments

serviceappointment

lk_serviceappointment_modifiedby

serviceappointment

lk_serviceappointment_createdonbehalfby

serviceappointment

lk_serviceappointment_createdby

serviceappointment

lk_serviceappointment_modifiedonbehalfby

serviceappointment

lk_serviceendpointbase_createdonbehalfby

serviceendpoint

createdby_serviceendpoint

serviceendpoint

modifiedby_serviceendpoint

serviceendpoint

lk_serviceendpointbase_modifiedonbehalfby

serviceendpoint

user_sharepointdocumentlocation

sharepointdocumentlocation

lk_sharepointdocumentlocationbase_createdby

sharepointdocumentlocation

lk_sharepointdocumentlocationbase_modifiedby

sharepointdocumentlocation

lk_sharepointdocumentlocationbase_createdonbehalfby

sharepointdocumentlocation

lk_sharepointdocumentlocationbase_modifiedonbehalfby

sharepointdocumentlocation

user_sharepointsite

sharepointsite

lk_sharepointsitebase_createdonbehalfby

sharepointsite

lk_sharepointsitebase_modifiedby

sharepointsite

lk_sharepointsitebase_modifiedonbehalfby

sharepointsite

lk_sharepointsitebase_createdby

sharepointsite

lk_sitebase_createdby

site

lk_site_createdonbehalfby

site

lk_sitebase_modifiedby

site

lk_site_modifiedonbehalfby

site

lk_solution_createdby

solution

lk_solution_modifiedby

solution

lk_solutionbase_createdonbehalfby

solution

lk_solutionbase_modifiedonbehalfby

solution

lk_solutioncomponentbase_createdonbehalfby

solutioncomponent

lk_solutioncomponentbase_modifiedonbehalfby

solutioncomponent

lk_subject_modifiedonbehalfby

subject

lk_subjectbase_modifiedby

subject

lk_subject_createdonbehalfby

subject

lk_subjectbase_createdby

subject

lk_systemuserbase_modifiedby

systemuser

lk_systemuser_createdonbehalfby

systemuser

user_parent_user

systemuser

lk_systemuser_modifiedonbehalfby

systemuser

lk_systemuserbase_createdby

systemuser

systemuserbusinessunitentitymap_systemuserid_systemuser

systemuserbusinessunitentitymap

sup_principalid_systemuser

systemuserprincipals

lk_task_modifiedonbehalfby

task

lk_task_modifiedby

task

lk_task_createdby

task

user_task

task

lk_task_createdonbehalfby

task

lk_teambase_modifiedby

team

lk_team_createdonbehalfby

team

lk_teambase_createdby

team

lk_team_modifiedonbehalfby

team

lk_teambase_administratorid

team

lk_templatebase_modifiedby

template

lk_templatebase_createdonbehalfby

template

lk_templatebase_createdby

template

lk_templatebase_modifiedonbehalfby

template

system_user_email_templates

template

lk_territorybase_createdby

territory

lk_territorybase_modifiedby

territory

system_user_territories

territory

lk_territory_createdonbehalfby

territory

lk_territory_modifiedonbehalfby

territory

lk_timezonedefinition_modifiedby

timezonedefinition

lk_timezonedefinition_createdby

timezonedefinition

lk_timezonedefinition_modifiedonbehalfby

timezonedefinition

lk_timezonedefinition_createdonbehalfby

timezonedefinition

lk_timezonelocalizedname_modifiedby

timezonelocalizedname

lk_timezonelocalizedname_createdby

timezonelocalizedname

lk_timezonelocalizedname_modifiedonbehalfby

timezonelocalizedname

lk_timezonelocalizedname_createdonbehalfby

timezonelocalizedname

lk_timezonerule_createdby

timezonerule

lk_timezonerule_createdonbehalfby

timezonerule

lk_timezonerule_modifiedby

timezonerule

lk_timezonerule_modifiedonbehalfby

timezonerule

lk_transactioncurrency_modifiedonbehalfby

transactioncurrency

lk_transactioncurrencybase_modifiedby

transactioncurrency

lk_transactioncurrency_createdonbehalfby

transactioncurrency

lk_transactioncurrencybase_createdby

transactioncurrency

lk_transformationmapping_createdby

transformationmapping

lk_transformationmapping_modifiedby

transformationmapping

lk_transformationmapping_createdonbehalfby

transformationmapping

lk_transformationmapping_modifiedonbehalfby

transformationmapping

lk_transformationparametermapping_createdonbehalfby

transformationparametermapping

lk_transformationparametermapping_modifiedby

transformationparametermapping

lk_transformationparametermapping_createdby

transformationparametermapping

lk_transformationparametermapping_modifiedonbehalfby

transformationparametermapping

lk_uombase_createdby

uom

lk_uom_createdonbehalfby

uom

lk_uombase_modifiedby

uom

lk_uom_modifiedonbehalfby

uom

lk_uomschedule_modifiedonbehalfby

uomschedule

lk_uomschedulebase_createdby

uomschedule

lk_uomschedulebase_modifiedby

uomschedule

lk_uomschedule_createdonbehalfby

uomschedule

userentityinstancedata_systemuser

userentityinstancedata

userentityinstancedata_owning_user

userentityinstancedata

userentityuisettings_owning_user

userentityuisettings

lk_userfiscalcalendar_modifiedby

userfiscalcalendar

lk_userfiscalcalendar_createdonbehalfby

userfiscalcalendar

system_user_quotas

userfiscalcalendar

lk_userfiscalcalendar_modifiedonbehalfby

userfiscalcalendar

lk_userfiscalcalendar_createdby

userfiscalcalendar

lk_userformbase_modifiedonbehalfby

userform

user_userform

userform

lk_userform_modifiedby

userform

lk_userform_createdby

userform

lk_userformbase_createdonbehalfby

userform

user_userquery

userquery

lk_userquery_modifiedby

userquery

lk_userquery_createdby

userquery

lk_userquery_createdonbehalfby

userquery

lk_userquery_modifiedonbehalfby

userquery

lk_userqueryvisualization_modifiedby

userqueryvisualization

user_userqueryvisualizations

userqueryvisualization

lk_userqueryvisualizationbase_modifiedonbehalfby

userqueryvisualization

lk_userqueryvisualization_createdby

userqueryvisualization

lk_userqueryvisualizationbase_createdonbehalfby

userqueryvisualization

lk_usersettings_createdonbehalfby

usersettings

lk_usersettingsbase_createdby

usersettings

user_settings

usersettings

lk_usersettingsbase_modifiedby

usersettings

lk_usersettings_modifiedonbehalfby

usersettings

lk_webresourcebase_modifiedonbehalfby

webresource

webresource_modifiedby

webresource

webresource_createdby

webresource

lk_webresourcebase_createdonbehalfby

webresource

lk_webwizard_createdonbehalfby

webwizard

lk_webwizard_modifiedby

webwizard

lk_webwizard_createdby

webwizard

lk_webwizard_modifiedonbehalfby

webwizard

lk_wizardaccessprivilege_createdonbehalfby

wizardaccessprivilege

lk_wizardaccessprivilege_modifiedonbehalfby

wizardaccessprivilege

lk_wizardaccessprivilege_modifiedby

wizardaccessprivilege

lk_wizardaccessprivilege_createdby

wizardaccessprivilege

lk_wizardpage_modifiedonbehalfby

wizardpage

lk_wizardpage_modifiedby

wizardpage

lk_wizardpage_createdby

wizardpage

lk_wizardpage_createdonbehalfby

wizardpage

workflow_createdby

workflow

workflow_modifiedby

workflow

workflow_createdonbehalfby

workflow

system_user_workflow

workflow

workflow_modifiedonbehalfby

workflow

workflow_dependency_createdby

workflowdependency

workflow_dependency_createdonbehalfby

workflowdependency

workflow_dependency_modifiedby

workflowdependency

workflow_dependency_modifiedonbehalfby

workflowdependency

lk_workflowlog_modifiedby

workflowlog

lk_workflowlog_modifiedonbehalfby

workflowlog

lk_workflowlog_createdonbehalfby

workflowlog

lk_workflowlog_createdby

workflowlog

Many-to-Many Relationships

The following table shows the many-to-many relationships for the system user (user) entity.

 

Relationship schema name Entity 1 Entity 2 Intersect entity

systemuserprofiles_association

systemuser

fieldsecurityprofile

systemuserprofiles

systemuserroles_association

systemuser

role

systemuserroles

teammembership_association

team

systemuser

teammembership

For information about using intersect entities, see Retrieve Records for Many-To-Many Relationships Using Intersect Entities.

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship with the system user (user) entity.

 

Relationship schema name Referenced entity

business_unit_system_users

businessunit

calendar_system_users

calendar

organization_system_users

organization

queue_system_user

queue

site_system_users

site

user_parent_user

systemuser

lk_systemuserbase_modifiedby

systemuser

lk_systemuser_modifiedonbehalfby

systemuser

lk_systemuserbase_createdby

systemuser

lk_systemuser_createdonbehalfby

systemuser

territory_system_users

territory

TransactionCurrency_SystemUser

transactioncurrency

See Also

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.

Community Additions

Show: