Opportunity KPI Item (msdyn_opportunitykpiitem) table/entity reference (Microsoft Dynamics 365)

2025-08-29

Messages

The following table lists the messages for the Opportunity KPI Item (msdyn_opportunitykpiitem) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
`Associate` Event: True	Associate records	Associate records
`BulkRetain` Event: True	BulkRetain	Learn to use messages with the SDK for .NET
`Create` Event: True	`POST` /msdyn_opportunitykpiitems See Create	Create records
`CreateMultiple` Event: True	CreateMultiple	CreateMultipleRequest
`Delete` Event: True	`DELETE` /msdyn_opportunitykpiitems(msdyn_opportunitykpiitemid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`IsValidStateTransition` Event: False	IsValidStateTransition	IsValidStateTransitionRequest
`PurgeRetainedContent` Event: True	PurgeRetainedContent	Learn to use messages with the SDK for .NET
`Restore` Event: True	Restore	Learn to use messages with the SDK for .NET
`Retain` Event: True	Retain	Learn to use messages with the SDK for .NET
`Retrieve` Event: True	`GET` /msdyn_opportunitykpiitems(msdyn_opportunitykpiitemid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /msdyn_opportunitykpiitems See Query data	Query data
`RollbackRetain` Event: True	RollbackRetain	Learn to use messages with the SDK for .NET
`SetState` Event: True	`PATCH` /msdyn_opportunitykpiitems(msdyn_opportunitykpiitemid) Update the `statecode` and `statuscode` properties.	SetStateRequest
`Update` Event: True	`PATCH` /msdyn_opportunitykpiitems(msdyn_opportunitykpiitemid) See Update	Update records
`UpdateMultiple` Event: True	UpdateMultiple	UpdateMultipleRequest
`Upsert` Event: False	`PATCH` /msdyn_opportunitykpiitems(msdyn_opportunitykpiitemid) See Upsert a table row	UpsertRequest
`UpsertMultiple` Event: False	UpsertMultiple	UpsertMultipleRequest
`ValidateRetentionConfig` Event: True	ValidateRetentionConfig	Learn to use messages with the SDK for .NET

Properties

The following table lists selected properties for the Opportunity KPI Item (msdyn_opportunitykpiitem) table.

Property	Value
DisplayName	Opportunity KPI Item
DisplayCollectionName	Opportunity KPI Items
SchemaName	`msdyn_opportunitykpiitem`
CollectionSchemaName	`msdyn_opportunitykpiitems`
EntitySetName	`msdyn_opportunitykpiitems`
LogicalName	`msdyn_opportunitykpiitem`
LogicalCollectionName	`msdyn_opportunitykpiitems`
PrimaryIdAttribute	`msdyn_opportunitykpiitemid`
PrimaryNameAttribute	`msdyn_name`
TableType	`Standard`
OwnershipType	`OrganizationOwned`

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

ImportSequenceNumber
msdyn_acilastupdatetimestamp
msdyn_averagefirstresponsetimebytheminhrs
msdyn_averagefirstresponsetimebyusinhrs
msdyn_computationaccuracy
msdyn_date
msdyn_emailattachmentopens
msdyn_emaillinksclicked
msdyn_emailsreceived
msdyn_emailssent
msdyn_facetimewithcustomer
msdyn_lastactivitybyteam
msdyn_lastactivitydirection
msdyn_lastactivityid
msdyn_lastactivitytype
msdyn_liemailssent
msdyn_meetingsreceived
msdyn_meetingssent
msdyn_name
msdyn_nextactivitybyteam
msdyn_nextactivitydirection
msdyn_nextactivityid
msdyn_nextactivitytype
msdyn_openedemails
msdyn_opportunityid
msdyn_opportunitykpiitemId
msdyn_phonecallsmade
msdyn_phonecallsreceived
msdyn_relationshiphealthscorestate
msdyn_relationshiphealthscorevalue
msdyn_relationshiphealthtrend
msdyn_responseratebythem
msdyn_responseratebyus
msdyn_timespentbycustomer
msdyn_timespentbycustomer_calculated
msdyn_timespentbyteam
msdyn_timespentbyteam_calculated
OverriddenCreatedOn
statecode
statuscode
TimeZoneRuleVersionNumber
UTCConversionTimeZoneCode

ImportSequenceNumber

Property	Value
Description	Sequence number of the import that created this record.
DisplayName	Import Sequence Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`importsequencenumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

msdyn_acilastupdatetimestamp

Property	Value
Description	TimeStamp value when the KPI are retrieved from ACI
DisplayName	Last Updated
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_acilastupdatetimestamp`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Auto
SourceTypeMask	0

msdyn_averagefirstresponsetimebytheminhrs

Property	Value
Description	Average time taken by the customer(in hrs) to respond.
DisplayName	Average customer response time
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_averagefirstresponsetimebytheminhrs`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	100000000000
MinValue	0
Precision	2
SourceTypeMask	0

msdyn_averagefirstresponsetimebyusinhrs

Property	Value
Description	Average time taken by the seller(in hrs) to respond.
DisplayName	Average seller response time
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_averagefirstresponsetimebyusinhrs`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	100000000000
MinValue	0
Precision	2
SourceTypeMask	0

msdyn_computationaccuracy

Property	Value
Description
DisplayName	Computation Accuracy
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_computationaccuracy`
RequiredLevel	None
Type	Picklist
DefaultFormValue	100000000
GlobalChoiceName	`msdyn_kpicomputationaccuracy`

msdyn_computationaccuracy Choices/Options

Value	Label
100000000	Complete
100000001	Partial

msdyn_date

Property	Value
Description
DisplayName	Date
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_date`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	True
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Auto
SourceTypeMask	0

msdyn_emailattachmentopens

Property	Value
Description	Shows the rate of opening attachments on followed emails.
DisplayName	Opening Attachments Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_emailattachmentopens`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	100000000000
MinValue	0
Precision	2
SourceTypeMask	0

msdyn_emaillinksclicked

Property	Value
Description	Shows the rate of links clicked on in followed emails.
DisplayName	Clicked Links Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_emaillinksclicked`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	100000000000
MinValue	0
Precision	2
SourceTypeMask	0

msdyn_emailsreceived

Property	Value
Description	Number of emails received.
DisplayName	Received Emails
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_emailsreceived`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_emailssent

Property	Value
Description	Number of emails sent by internal contacts to external contacts.
DisplayName	Sent Emails
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_emailssent`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_facetimewithcustomer

Property	Value
Description
DisplayName	Facetime with customer
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_facetimewithcustomer`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_lastactivitybyteam

Property	Value
Description	Date of the last interaction.
DisplayName	Last Activity by Team
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_lastactivitybyteam`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	True
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Auto
SourceTypeMask	0

msdyn_lastactivitydirection

Property	Value
Description	Last activity direction.
DisplayName	Last Activity Direction
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_lastactivitydirection`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`msdyn_msdyn_opportunitykpiitem_msdyn_lastactivitydirection`

msdyn_lastactivitydirection Choices/Options

Value	Label
0	Incoming
1	Outgoing

msdyn_lastactivityid

Property	Value
Description	ID of the last activity.
DisplayName	ID of Last activity
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_lastactivityid`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

msdyn_lastactivitytype

Property	Value
Description	Last activity type.
DisplayName	Last Activity Type
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_lastactivitytype`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1250

msdyn_liemailssent

Property	Value
Description
DisplayName	LI Emails Sent
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_liemailssent`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_meetingsreceived

Property	Value
Description	Number of meetings sent by the customer.
DisplayName	Received Meetings
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_meetingsreceived`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_meetingssent

Property	Value
Description	Number of meetings sent to the customer.
DisplayName	Sent Meetings
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_meetingssent`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_name

Property	Value
Description	The name of the custom entity.
DisplayName	Custom Entity Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

msdyn_nextactivitybyteam

Property	Value
Description	Next activity due by internal contacts or next meeting that is linked to the record.
DisplayName	Next Activity by Team
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_nextactivitybyteam`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	True
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Auto
SourceTypeMask	0

msdyn_nextactivitydirection

Property	Value
Description	Next activity direction.
DisplayName	Next Activity Direction
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_nextactivitydirection`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`msdyn_msdyn_opportunitykpiitem_msdyn_nextactivitydirection`

msdyn_nextactivitydirection Choices/Options

Value	Label
0	Incoming
1	Outgoing

msdyn_nextactivityid

Property	Value
Description	ID of the next activity.
DisplayName	ID of Next Activity
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_nextactivityid`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

msdyn_nextactivitytype

Property	Value
Description	Next activity type.
DisplayName	Next Activity Type
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_nextactivitytype`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1250

msdyn_openedemails

Property	Value
Description	Shows the rate of opening followed emails.
DisplayName	Opening Emails Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_openedemails`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	100000000000
MinValue	0
Precision	2
SourceTypeMask	0

msdyn_opportunityid

Property	Value
Description	Parent Opportunity ID.
DisplayName	Parent Opportunity ID
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_opportunityid`
RequiredLevel	None
Type	Lookup
Targets	opportunity

msdyn_opportunitykpiitemId

Property	Value
Description	Unique identifier for entity instances.
DisplayName	Unique Identifier for Entity Instances
IsValidForForm	False
IsValidForRead	True
LogicalName	`msdyn_opportunitykpiitemid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

msdyn_phonecallsmade

Property	Value
Description	Shows the number of phone calls made.
DisplayName	Phone Calls Made
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_phonecallsmade`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_phonecallsreceived

Property	Value
Description	Shows the number of phone calls received.
DisplayName	Phone Calls Received
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_phonecallsreceived`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_relationshiphealthscorestate

Property	Value
Description	KPI health score.
DisplayName	Relationship Health State
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_relationshiphealthscorestate`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`msdyn_msdyn_opportunitykpiitem_msdyn_relationshiphealthscorestate`

msdyn_relationshiphealthscorestate Choices/Options

Value	Label
0	Good
1	Fair
2	Poor
3	Not enough info
4	No Closed Activities
5	Health Computation In Progress
6	Something went wrong
7	Entity older than 2 years

msdyn_relationshiphealthscorevalue

Property	Value
Description	Health score for the opportunity.
DisplayName	Relationship Health
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_relationshiphealthscorevalue`
RequiredLevel	None
Type	Integer
MaxValue	100
MinValue	0

msdyn_relationshiphealthtrend

Property	Value
Description	Direction the relationship health is moving.
DisplayName	Relationship Health Trend
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_relationshiphealthtrend`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`msdyn_msdyn_opportunitykpiitem_msdyn_relationshiphealthtrend`

msdyn_relationshiphealthtrend Choices/Options

Value	Label
0	Improving
1	Steady
2	Declining
3	Not enough info
4	Something went wrong
5	Health not applicable

msdyn_responseratebythem

Property	Value
Description	Rate of response of the customer.
DisplayName	Rate of response of the customer
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_responseratebythem`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	100000000000
MinValue	0
Precision	2
SourceTypeMask	0

msdyn_responseratebyus

Property	Value
Description	Rate of response by the seller.
DisplayName	Rate of response by the seller
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_responseratebyus`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	100000000000
MinValue	0
Precision	2
SourceTypeMask	0

msdyn_timespentbycustomer

Property	Value
Description	Time spent by external contacts on activities.
DisplayName	Time Engaged with Customer
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_timespentbycustomer`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_timespentbycustomer_calculated

Property	Value
Description	Time spent by external contacts on activities.
DisplayName	Time Engaged with Customer in Hours
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_timespentbycustomer_calculated`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	100000000000
MinValue	-100000000000
Precision	1
SourceTypeMask	1

msdyn_timespentbyteam

Property	Value
Description	Time spent by the team on activities.
DisplayName	Time Spent by Team
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_timespentbyteam`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_timespentbyteam_calculated

Property	Value
Description	Time spent by the team on activities.
DisplayName	Time Spent by Team in Hours
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_timespentbyteam_calculated`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	100000000000
MinValue	-100000000000
Precision	1
SourceTypeMask	1

OverriddenCreatedOn

Property	Value
Description	Date and time when the record was migrated.
DisplayName	Record Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	`overriddencreatedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

statecode

Property	Value
Description	Status of the Opportunity KPI.
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`statecode`
RequiredLevel	SystemRequired
Type	State
DefaultFormValue
GlobalChoiceName	`msdyn_opportunitykpiitem_statecode`

statecode Choices/Options

Value	Details
0	Label: Active DefaultStatus: 1 InvariantName: `Active`
1	Label: Inactive DefaultStatus: 2 InvariantName: `Inactive`

statuscode

Property	Value
Description	Reason for the status of the Opportunity KPI Item
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	`statuscode`
RequiredLevel	None
Type	Status
DefaultFormValue
GlobalChoiceName	`msdyn_opportunitykpiitem_statuscode`

statuscode Choices/Options

Value	Details
1	Label: Active State:0 TransitionData: None
2	Label: Inactive State:1 TransitionData: None

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`timezoneruleversionnumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
IsValidForForm	False
IsValidForRead	True
LogicalName	`utcconversiontimezonecode`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

CreatedBy
CreatedOn
CreatedOnBehalfBy
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OrganizationId
VersionNumber

CreatedBy

Property	Value
Description	Unique identifier of the user who created the record.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Date and time when the record was created.
DisplayName	Created On
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the record.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedBy

Property	Value
Description	Unique identifier of the user who modified the record.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when the record was modified.
DisplayName	Modified On
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who modified the record.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

OrganizationId

Property	Value
Description	Unique identifier for the organization.
DisplayName	Organization Id
IsValidForForm	False
IsValidForRead	True
LogicalName	`organizationid`
RequiredLevel	None
Type	Lookup
Targets	organization

VersionNumber

Property	Value
Description	Version Number
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`versionnumber`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

lk_msdyn_opportunitykpiitem_createdby
lk_msdyn_opportunitykpiitem_createdonbehalfby
lk_msdyn_opportunitykpiitem_modifiedby
lk_msdyn_opportunitykpiitem_modifiedonbehalfby
msdyn_opportunity_msdyn_opportunitykpiitem_opportunityid
organization_msdyn_opportunitykpiitem

lk_msdyn_opportunitykpiitem_createdby

One-To-Many Relationship: systemuser lk_msdyn_opportunitykpiitem_createdby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdby`
ReferencingEntityNavigationPropertyName	`createdby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_msdyn_opportunitykpiitem_createdonbehalfby

One-To-Many Relationship: systemuser lk_msdyn_opportunitykpiitem_createdonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdonbehalfby`
ReferencingEntityNavigationPropertyName	`createdonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_msdyn_opportunitykpiitem_modifiedby

One-To-Many Relationship: systemuser lk_msdyn_opportunitykpiitem_modifiedby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedby`
ReferencingEntityNavigationPropertyName	`modifiedby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_msdyn_opportunitykpiitem_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_msdyn_opportunitykpiitem_modifiedonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedonbehalfby`
ReferencingEntityNavigationPropertyName	`modifiedonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_opportunity_msdyn_opportunitykpiitem_opportunityid

One-To-Many Relationship: opportunity msdyn_opportunity_msdyn_opportunitykpiitem_opportunityid

Property	Value
ReferencedEntity	`opportunity`
ReferencedAttribute	`opportunityid`
ReferencingAttribute	`msdyn_opportunityid`
ReferencingEntityNavigationPropertyName	`msdyn_opportunityid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

organization_msdyn_opportunitykpiitem

One-To-Many Relationship: organization organization_msdyn_opportunitykpiitem

Property	Value
ReferencedEntity	`organization`
ReferencedAttribute	`organizationid`
ReferencingAttribute	`organizationid`
ReferencingEntityNavigationPropertyName	`organizationid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

msdyn_msdyn_opportunitykpiitem_opportunity_opportunitykpiid
msdyn_opportunitykpiitem_AsyncOperations
msdyn_opportunitykpiitem_BulkDeleteFailures
msdyn_opportunitykpiitem_MailboxTrackingFolders
msdyn_opportunitykpiitem_PrincipalObjectAttributeAccesses
msdyn_opportunitykpiitem_ProcessSession
msdyn_opportunitykpiitem_SyncErrors

msdyn_msdyn_opportunitykpiitem_opportunity_opportunitykpiid

Many-To-One Relationship: opportunity msdyn_msdyn_opportunitykpiitem_opportunity_opportunitykpiid

Property	Value
ReferencingEntity	`opportunity`
ReferencingAttribute	`msdyn_opportunitykpiid`
ReferencedEntityNavigationPropertyName	`msdyn_msdyn_opportunitykpiitem_opportunity_opportunitykpiid`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_opportunitykpiitem_AsyncOperations

Many-To-One Relationship: asyncoperation msdyn_opportunitykpiitem_AsyncOperations

Property	Value
ReferencingEntity	`asyncoperation`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`msdyn_opportunitykpiitem_AsyncOperations`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_opportunitykpiitem_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure msdyn_opportunitykpiitem_BulkDeleteFailures

Property	Value
ReferencingEntity	`bulkdeletefailure`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`msdyn_opportunitykpiitem_BulkDeleteFailures`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_opportunitykpiitem_MailboxTrackingFolders

Many-To-One Relationship: mailboxtrackingfolder msdyn_opportunitykpiitem_MailboxTrackingFolders

Property	Value
ReferencingEntity	`mailboxtrackingfolder`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`msdyn_opportunitykpiitem_MailboxTrackingFolders`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_opportunitykpiitem_PrincipalObjectAttributeAccesses

Many-To-One Relationship: principalobjectattributeaccess msdyn_opportunitykpiitem_PrincipalObjectAttributeAccesses

Property	Value
ReferencingEntity	`principalobjectattributeaccess`
ReferencingAttribute	`objectid`
ReferencedEntityNavigationPropertyName	`msdyn_opportunitykpiitem_PrincipalObjectAttributeAccesses`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_opportunitykpiitem_ProcessSession

Many-To-One Relationship: processsession msdyn_opportunitykpiitem_ProcessSession

Property	Value
ReferencingEntity	`processsession`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`msdyn_opportunitykpiitem_ProcessSession`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_opportunitykpiitem_SyncErrors

Many-To-One Relationship: syncerror msdyn_opportunitykpiitem_SyncErrors

Property	Value
ReferencingEntity	`syncerror`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`msdyn_opportunitykpiitem_SyncErrors`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Feedback

Was this page helpful?