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 /leadtoopportunitysalesprocessesSee 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 /leadtoopportunitysalesprocessesSee 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 |
See also
Dataverse table/entity reference
Dataverse Web API Reference