Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Messages
The following table lists the messages for the Lead KPI Item (msdyn_leadkpiitem) 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 | 
|---|---|---|
| AssociateEvent: True | Associate records | Associate records | 
| BulkRetainEvent: True | BulkRetain | Learn to use messages with the SDK for .NET | 
| CreateEvent: True | POST/msdyn_leadkpiitemsSee Create | Create records | 
| CreateMultipleEvent: True | CreateMultiple | CreateMultipleRequest | 
| DeleteEvent: True | DELETE/msdyn_leadkpiitems(msdyn_leadkpiitemid)See Delete | Delete records | 
| DisassociateEvent: True | Disassociate records | Disassociate records | 
| IsValidStateTransitionEvent: False | IsValidStateTransition | IsValidStateTransitionRequest | 
| PurgeRetainedContentEvent: True | PurgeRetainedContent | Learn to use messages with the SDK for .NET | 
| RestoreEvent: True | Restore | Learn to use messages with the SDK for .NET | 
| RetainEvent: True | Retain | Learn to use messages with the SDK for .NET | 
| RetrieveEvent: True | GET/msdyn_leadkpiitems(msdyn_leadkpiitemid)See Retrieve | Retrieve records | 
| RetrieveMultipleEvent: True | GET/msdyn_leadkpiitemsSee Query data | Query data | 
| RollbackRetainEvent: True | RollbackRetain | Learn to use messages with the SDK for .NET | 
| SetStateEvent: True | PATCH/msdyn_leadkpiitems(msdyn_leadkpiitemid)Update the statecodeandstatuscodeproperties. | SetStateRequest | 
| UpdateEvent: True | PATCH/msdyn_leadkpiitems(msdyn_leadkpiitemid)See Update | Update records | 
| UpdateMultipleEvent: True | UpdateMultiple | UpdateMultipleRequest | 
| UpsertEvent: False | PATCH/msdyn_leadkpiitems(msdyn_leadkpiitemid)See Upsert a table row | UpsertRequest | 
| UpsertMultipleEvent: False | UpsertMultiple | UpsertMultipleRequest | 
| ValidateRetentionConfigEvent: True | ValidateRetentionConfig | Learn to use messages with the SDK for .NET | 
Properties
The following table lists selected properties for the Lead KPI Item (msdyn_leadkpiitem) table.
| Property | Value | 
|---|---|
| DisplayName | Lead KPI Item | 
| DisplayCollectionName | Lead KPI Items | 
| SchemaName | msdyn_leadkpiitem | 
| CollectionSchemaName | msdyn_leadkpiitems | 
| EntitySetName | msdyn_leadkpiitems | 
| LogicalName | msdyn_leadkpiitem | 
| LogicalCollectionName | msdyn_leadkpiitems | 
| PrimaryIdAttribute | msdyn_leadkpiitemid | 
| 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_leadid
- msdyn_leadkpiitemId
- msdyn_liemailssent
- msdyn_meetingsreceived
- msdyn_meetingssent
- msdyn_name
- msdyn_nextactivitybyteam
- msdyn_nextactivitydirection
- msdyn_nextactivityid
- msdyn_nextactivitytype
- msdyn_openedemails
- 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 | Total 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_leadkpiitem_msdyn_lastactivitydirection | 
msdyn_lastactivitydirection Choices/Options
| Value | Label | 
|---|---|
| 0 | Incoming | 
| 1 | Outgoing | 
msdyn_lastactivityid
| Property | Value | 
|---|---|
| Description | ID of the last activity. | 
| DisplayName | Last Activity ID | 
| 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_leadid
| Property | Value | 
|---|---|
| Description | Parent lead ID. | 
| DisplayName | LeadId | 
| IsValidForForm | True | 
| IsValidForRead | True | 
| LogicalName | msdyn_leadid | 
| RequiredLevel | None | 
| Type | Lookup | 
| Targets | lead | 
msdyn_leadkpiitemId
| Property | Value | 
|---|---|
| Description | Unique identifier for entity instances. | 
| DisplayName | Unique Identifier for Entity Instances | 
| IsValidForForm | False | 
| IsValidForRead | True | 
| LogicalName | msdyn_leadkpiitemid | 
| RequiredLevel | SystemRequired | 
| Type | Uniqueidentifier | 
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_leadkpiitem_msdyn_nextactivitydirection | 
msdyn_nextactivitydirection Choices/Options
| Value | Label | 
|---|---|
| 0 | Incoming | 
| 1 | Outgoing | 
msdyn_nextactivityid
| Property | Value | 
|---|---|
| Description | ID of the next activity. | 
| DisplayName | Next Activity ID | 
| 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_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_leadkpiitem_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 lead. | 
| DisplayName | Relationship Health Score | 
| 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_leadkpiitem_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 for emails and meetings by Internal Contacts in relation to the record. | 
| 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 for emails and meetings by Internal Contacts in relation to the record. | 
| 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 Lead KPI. | 
| DisplayName | Status | 
| IsValidForForm | True | 
| IsValidForRead | True | 
| LogicalName | statecode | 
| RequiredLevel | SystemRequired | 
| Type | State | 
| DefaultFormValue | |
| GlobalChoiceName | msdyn_leadkpiitem_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 Lead KPI. | 
| DisplayName | Status Reason | 
| IsValidForForm | True | 
| IsValidForRead | True | 
| LogicalName | statuscode | 
| RequiredLevel | None | 
| Type | Status | 
| DefaultFormValue | |
| GlobalChoiceName | msdyn_leadkpiitem_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_leadkpiitem_createdby
- lk_msdyn_leadkpiitem_createdonbehalfby
- lk_msdyn_leadkpiitem_modifiedby
- lk_msdyn_leadkpiitem_modifiedonbehalfby
- msdyn_lead_msdyn_leadkpiitem_leadid
- organization_msdyn_leadkpiitem
lk_msdyn_leadkpiitem_createdby
One-To-Many Relationship: systemuser lk_msdyn_leadkpiitem_createdby
| Property | Value | 
|---|---|
| ReferencedEntity | systemuser | 
| ReferencedAttribute | systemuserid | 
| ReferencingAttribute | createdby | 
| ReferencingEntityNavigationPropertyName | createdby | 
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade | 
lk_msdyn_leadkpiitem_createdonbehalfby
One-To-Many Relationship: systemuser lk_msdyn_leadkpiitem_createdonbehalfby
| Property | Value | 
|---|---|
| ReferencedEntity | systemuser | 
| ReferencedAttribute | systemuserid | 
| ReferencingAttribute | createdonbehalfby | 
| ReferencingEntityNavigationPropertyName | createdonbehalfby | 
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade | 
lk_msdyn_leadkpiitem_modifiedby
One-To-Many Relationship: systemuser lk_msdyn_leadkpiitem_modifiedby
| Property | Value | 
|---|---|
| ReferencedEntity | systemuser | 
| ReferencedAttribute | systemuserid | 
| ReferencingAttribute | modifiedby | 
| ReferencingEntityNavigationPropertyName | modifiedby | 
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade | 
lk_msdyn_leadkpiitem_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_msdyn_leadkpiitem_modifiedonbehalfby
| Property | Value | 
|---|---|
| ReferencedEntity | systemuser | 
| ReferencedAttribute | systemuserid | 
| ReferencingAttribute | modifiedonbehalfby | 
| ReferencingEntityNavigationPropertyName | modifiedonbehalfby | 
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade | 
msdyn_lead_msdyn_leadkpiitem_leadid
One-To-Many Relationship: lead msdyn_lead_msdyn_leadkpiitem_leadid
| Property | Value | 
|---|---|
| ReferencedEntity | lead | 
| ReferencedAttribute | leadid | 
| ReferencingAttribute | msdyn_leadid | 
| ReferencingEntityNavigationPropertyName | msdyn_leadid | 
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: CascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade | 
organization_msdyn_leadkpiitem
One-To-Many Relationship: organization organization_msdyn_leadkpiitem
| Property | Value | 
|---|---|
| ReferencedEntity | organization | 
| ReferencedAttribute | organizationid | 
| ReferencingAttribute | organizationid | 
| ReferencingEntityNavigationPropertyName | organizationid | 
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade | 
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- msdyn_leadkpiitem_AsyncOperations
- msdyn_leadkpiitem_BulkDeleteFailures
- msdyn_leadkpiitem_MailboxTrackingFolders
- msdyn_leadkpiitem_PrincipalObjectAttributeAccesses
- msdyn_leadkpiitem_ProcessSession
- msdyn_leadkpiitem_SyncErrors
- msdyn_msdyn_leadkpiitem_lead_leadkpiid
msdyn_leadkpiitem_AsyncOperations
Many-To-One Relationship: asyncoperation msdyn_leadkpiitem_AsyncOperations
| Property | Value | 
|---|---|
| ReferencingEntity | asyncoperation | 
| ReferencingAttribute | regardingobjectid | 
| ReferencedEntityNavigationPropertyName | msdyn_leadkpiitem_AsyncOperations | 
| IsCustomizable | True | 
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 | 
msdyn_leadkpiitem_BulkDeleteFailures
Many-To-One Relationship: bulkdeletefailure msdyn_leadkpiitem_BulkDeleteFailures
| Property | Value | 
|---|---|
| ReferencingEntity | bulkdeletefailure | 
| ReferencingAttribute | regardingobjectid | 
| ReferencedEntityNavigationPropertyName | msdyn_leadkpiitem_BulkDeleteFailures | 
| IsCustomizable | True | 
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 | 
msdyn_leadkpiitem_MailboxTrackingFolders
Many-To-One Relationship: mailboxtrackingfolder msdyn_leadkpiitem_MailboxTrackingFolders
| Property | Value | 
|---|---|
| ReferencingEntity | mailboxtrackingfolder | 
| ReferencingAttribute | regardingobjectid | 
| ReferencedEntityNavigationPropertyName | msdyn_leadkpiitem_MailboxTrackingFolders | 
| IsCustomizable | True | 
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 | 
msdyn_leadkpiitem_PrincipalObjectAttributeAccesses
Many-To-One Relationship: principalobjectattributeaccess msdyn_leadkpiitem_PrincipalObjectAttributeAccesses
| Property | Value | 
|---|---|
| ReferencingEntity | principalobjectattributeaccess | 
| ReferencingAttribute | objectid | 
| ReferencedEntityNavigationPropertyName | msdyn_leadkpiitem_PrincipalObjectAttributeAccesses | 
| IsCustomizable | True | 
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 | 
msdyn_leadkpiitem_ProcessSession
Many-To-One Relationship: processsession msdyn_leadkpiitem_ProcessSession
| Property | Value | 
|---|---|
| ReferencingEntity | processsession | 
| ReferencingAttribute | regardingobjectid | 
| ReferencedEntityNavigationPropertyName | msdyn_leadkpiitem_ProcessSession | 
| IsCustomizable | True | 
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 | 
msdyn_leadkpiitem_SyncErrors
Many-To-One Relationship: syncerror msdyn_leadkpiitem_SyncErrors
| Property | Value | 
|---|---|
| ReferencingEntity | syncerror | 
| ReferencingAttribute | regardingobjectid | 
| ReferencedEntityNavigationPropertyName | msdyn_leadkpiitem_SyncErrors | 
| IsCustomizable | True | 
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 | 
msdyn_msdyn_leadkpiitem_lead_leadkpiid
Many-To-One Relationship: lead msdyn_msdyn_leadkpiitem_lead_leadkpiid
| Property | Value | 
|---|---|
| ReferencingEntity | lead | 
| ReferencingAttribute | msdyn_leadkpiid | 
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_leadkpiitem_lead_leadkpiid | 
| IsCustomizable | False | 
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 | 
See also
Dataverse table/entity reference
Dataverse Web API Reference