Lead To Opportunity Sales Process (LeadToOpportunitySalesProcess) table/entity reference (Microsoft Dynamics 365)

Lead To Opportunity Sales Process Business Process Flow

Messages

The following table lists the messages for the Lead To Opportunity Sales Process (LeadToOpportunitySalesProcess) 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
`Create` Event: True	`POST` /leadtoopportunitysalesprocesses See Create	Create records
`Delete` Event: True	`DELETE` /leadtoopportunitysalesprocesses(businessprocessflowinstanceid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`Retrieve` Event: False	`GET` /leadtoopportunitysalesprocesses(businessprocessflowinstanceid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: False	`GET` /leadtoopportunitysalesprocesses See Query data	Query data
`SetState` Event: True	`PATCH` /leadtoopportunitysalesprocesses(businessprocessflowinstanceid) Update the `statecode` and `statuscode` properties.	SetStateRequest
`Update` Event: True	`PATCH` /leadtoopportunitysalesprocesses(businessprocessflowinstanceid) See Update	Update records
`Upsert` Event: False	`PATCH` /leadtoopportunitysalesprocesses(businessprocessflowinstanceid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Lead To Opportunity Sales Process (LeadToOpportunitySalesProcess) table.

Property	Value
DisplayName	Lead To Opportunity Sales Process
DisplayCollectionName	Lead To Opportunity Sales Process
SchemaName	`LeadToOpportunitySalesProcess`
CollectionSchemaName	`LeadToOpportunitySalesProcesses`
EntitySetName	`leadtoopportunitysalesprocesses`
LogicalName	`leadtoopportunitysalesprocess`
LogicalCollectionName	`leadtoopportunitysalesprocesses`
PrimaryIdAttribute	`businessprocessflowinstanceid`
PrimaryNameAttribute	`name`
TableType	`Standard`
OwnershipType	`OrganizationOwned`

Writable columns/attributes

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

ActiveStageId
ActiveStageStartedOn
BusinessProcessFlowInstanceId
CompletedOn
ImportSequenceNumber
LeadId
Name
OpportunityId
OverriddenCreatedOn
ProcessId
StateCode
StatusCode
TimeZoneRuleVersionNumber
TransactionCurrencyId
TraversedPath
UTCConversionTimeZoneCode

ActiveStageId

Property	Value
Description	Unique identifier of the active stage for the Business Process Flow instance.
DisplayName	Active Stage
IsValidForForm	True
IsValidForRead	True
LogicalName	`activestageid`
RequiredLevel	None
Type	Lookup
Targets	processstage

ActiveStageStartedOn

Property	Value
Description	Date and time when current active stage is started.
DisplayName	Active Stage Started On
IsValidForForm	True
IsValidForRead	True
LogicalName	`activestagestartedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

BusinessProcessFlowInstanceId

Property	Value
Description	Unique identifier for Lead To Opportunity Sales Process bpf entity instances
DisplayName	Lead To Opportunity Sales Process Instance Id
IsValidForForm	False
IsValidForRead	True
LogicalName	`businessprocessflowinstanceid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

CompletedOn

Property	Value
Description	Date and time when Business Process Flow instance is completed
DisplayName	Completed On
IsValidForForm	True
IsValidForRead	True
LogicalName	`completedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

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

LeadId

Property	Value
Description	Unique identifier of the workflow associated to the Business Process Flow instance.
DisplayName	Lead
IsValidForForm	True
IsValidForRead	True
LogicalName	`leadid`
RequiredLevel	None
Type	Lookup
Targets	lead

Name

Property	Value
Description	Process Name.
DisplayName	Process Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`name`
RequiredLevel	ApplicationRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

OpportunityId

Property	Value
Description	Unique identifier of the workflow associated to the Business Process Flow instance.
DisplayName	Opportunity Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`opportunityid`
RequiredLevel	None
Type	Lookup
Targets	opportunity

OverriddenCreatedOn

Property	Value
Description	Date and time that 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

ProcessId

Property	Value
Description	Unique identifier of the workflow associated to the Business Process Flow instance.
DisplayName	Process
IsValidForForm	True
IsValidForRead	True
LogicalName	`processid`
RequiredLevel	None
Type	Lookup
Targets	workflow

StateCode

Property	Value
Description	Shows whether the Delve action record is pending, completed, or tracking.
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`statecode`
RequiredLevel	SystemRequired
Type	State
DefaultFormValue	0
GlobalChoiceName	`leadtoopportunitysalesprocess_statecode`

StateCode Choices/Options

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

StatusCode

Property	Value
Description	Select the delve action record status.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	`statuscode`
RequiredLevel	None
Type	Status
DefaultFormValue	-1
GlobalChoiceName	`leadtoopportunitysalesprocess_statuscode`

StatusCode Choices/Options

Value	Details
1	Label: Active State:0 TransitionData: None
2	Label: Finished State:1 TransitionData: None
3	Label: Aborted 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

TransactionCurrencyId

Property	Value
Description	Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName	Currency
IsValidForForm	True
IsValidForRead	True
LogicalName	`transactioncurrencyid`
RequiredLevel	None
Type	Lookup
Targets	transactioncurrency

TraversedPath

Property	Value
Description	Comma delimited string of process stage ids that represent visited stages of the Business Process Flow instance.
DisplayName	Traversed Path
IsValidForForm	True
IsValidForRead	True
LogicalName	`traversedpath`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	1250

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
Duration
ExchangeRate
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

Duration

Property	Value
Description	Duration between completed on and started on, used by business process flow.
DisplayName	Duration
IsValidForForm	True
IsValidForRead	True
LogicalName	`duration`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

ExchangeRate

Property	Value
Description	Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
DisplayName	Exchange Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	`exchangerate`
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	1E-12
Precision	12
SourceTypeMask	0

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	SystemRequired
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_leadtoopportunitysalesprocess_activestageid
lk_leadtoopportunitysalesprocess_createdby
lk_leadtoopportunitysalesprocess_createdonbehalfby
lk_leadtoopportunitysalesprocess_leadid
lk_leadtoopportunitysalesprocess_modifiedby
lk_leadtoopportunitysalesprocess_modifiedonbehalfby
lk_leadtoopportunitysalesprocess_opportunityid
lk_leadtoopportunitysalesprocess_processid
organization_leadtoopportunitysalesprocess
transactioncurrency_leadtoopportunitysalesprocess

lk_leadtoopportunitysalesprocess_activestageid

One-To-Many Relationship: processstage lk_leadtoopportunitysalesprocess_activestageid

Property	Value
ReferencedEntity	`processstage`
ReferencedAttribute	`processstageid`
ReferencingAttribute	`activestageid`
ReferencingEntityNavigationPropertyName	`activestageid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_leadtoopportunitysalesprocess_createdby

One-To-Many Relationship: systemuser lk_leadtoopportunitysalesprocess_createdby

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

lk_leadtoopportunitysalesprocess_createdonbehalfby

One-To-Many Relationship: systemuser lk_leadtoopportunitysalesprocess_createdonbehalfby

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

lk_leadtoopportunitysalesprocess_leadid

One-To-Many Relationship: lead lk_leadtoopportunitysalesprocess_leadid

Property	Value
ReferencedEntity	`lead`
ReferencedAttribute	`leadid`
ReferencingAttribute	`leadid`
ReferencingEntityNavigationPropertyName	`leadId`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_leadtoopportunitysalesprocess_modifiedby

One-To-Many Relationship: systemuser lk_leadtoopportunitysalesprocess_modifiedby

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

lk_leadtoopportunitysalesprocess_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_leadtoopportunitysalesprocess_modifiedonbehalfby

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

lk_leadtoopportunitysalesprocess_opportunityid

One-To-Many Relationship: opportunity lk_leadtoopportunitysalesprocess_opportunityid

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

lk_leadtoopportunitysalesprocess_processid

One-To-Many Relationship: workflow lk_leadtoopportunitysalesprocess_processid

Property	Value
ReferencedEntity	`workflow`
ReferencedAttribute	`workflowid`
ReferencingAttribute	`processid`
ReferencingEntityNavigationPropertyName	`processid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

organization_leadtoopportunitysalesprocess

One-To-Many Relationship: organization organization_leadtoopportunitysalesprocess

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`

transactioncurrency_leadtoopportunitysalesprocess

One-To-Many Relationship: transactioncurrency transactioncurrency_leadtoopportunitysalesprocess

Property	Value
ReferencedEntity	`transactioncurrency`
ReferencedAttribute	`transactioncurrencyid`
ReferencingAttribute	`transactioncurrencyid`
ReferencingEntityNavigationPropertyName	`transactioncurrencyid`
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.

leadtoopportunitysalesprocess_AsyncOperations
leadtoopportunitysalesprocess_BulkDeleteFailures
leadtoopportunitysalesprocess_MailboxTrackingFolders
leadtoopportunitysalesprocess_PrincipalObjectAttributeAccesses
leadtoopportunitysalesprocess_ProcessSession
LeadToOpportunitySalesProcess_SyncErrors
lk_leadtoopportunitysalesprocess_workflowlogs

leadtoopportunitysalesprocess_AsyncOperations

Many-To-One Relationship: asyncoperation leadtoopportunitysalesprocess_AsyncOperations

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

leadtoopportunitysalesprocess_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure leadtoopportunitysalesprocess_BulkDeleteFailures

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

leadtoopportunitysalesprocess_MailboxTrackingFolders

Many-To-One Relationship: mailboxtrackingfolder leadtoopportunitysalesprocess_MailboxTrackingFolders

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

leadtoopportunitysalesprocess_PrincipalObjectAttributeAccesses

Many-To-One Relationship: principalobjectattributeaccess leadtoopportunitysalesprocess_PrincipalObjectAttributeAccesses

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

leadtoopportunitysalesprocess_ProcessSession

Many-To-One Relationship: processsession leadtoopportunitysalesprocess_ProcessSession

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

LeadToOpportunitySalesProcess_SyncErrors

Many-To-One Relationship: syncerror LeadToOpportunitySalesProcess_SyncErrors

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

lk_leadtoopportunitysalesprocess_workflowlogs

Many-To-One Relationship: workflowlog lk_leadtoopportunitysalesprocess_workflowlogs

Property	Value
ReferencingEntity	`workflowlog`
ReferencingAttribute	`asyncoperationid`
ReferencedEntityNavigationPropertyName	`workflowlogs_leadtoopportunitysalesprocess`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Feedback

Was this page helpful?

Last updated on 2025-08-29