Edit

Share via

Opportunity table/entity reference (Microsoft Dynamics 365 Field Service)

  • Article

Potential revenue-generating event, or sale to an account, which needs to be tracked through a sales process to completion.

Note

The Microsoft Dynamics 365 Field Service Opportunity table extends the Microsoft Dynamics 365 Opportunity table.

Writable columns/attributes

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

msdyn_OrderType

Property Value
Description Internal use only.
DisplayName Order Type
IsValidForForm True
IsValidForRead True
LogicalName msdyn_ordertype
RequiredLevel Recommended
Type Picklist
DefaultFormValue 192350000
GlobalChoiceName msdyn_opportunity_msdyn_ordertype

msdyn_OrderType Choices/Options

Value Label
192350000 Item based
690970002 Service-Maintenance Based

msdyn_WorkOrderType

Property Value
Description Unique identifier for Work Order Type associated with Opportunity.
DisplayName Work Order Type
IsValidForForm True
IsValidForRead True
LogicalName msdyn_workordertype
RequiredLevel None
Type Lookup
Targets msdyn_workordertype

Many-to-One relationships

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

msdyn_msdyn_workordertype_opportunity_WorkOrderType

One-To-Many Relationship: msdyn_workordertype msdyn_msdyn_workordertype_opportunity_WorkOrderType

Property Value
ReferencedEntity msdyn_workordertype
ReferencedAttribute msdyn_workordertypeid
ReferencingAttribute msdyn_workordertype
ReferencingEntityNavigationPropertyName msdyn_workordertype
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-to-Many relationships

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

msdyn_opportunity_msdyn_workorder

Many-To-One Relationship: msdyn_workorder msdyn_opportunity_msdyn_workorder

Property Value
ReferencingEntity msdyn_workorder
ReferencingAttribute msdyn_opportunityid
ReferencedEntityNavigationPropertyName msdyn_opportunity_msdyn_workorder
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Sales
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

opportunity_msdyn_bookingalerts

Many-To-One Relationship: msdyn_bookingalert opportunity_msdyn_bookingalerts

Property Value
ReferencingEntity msdyn_bookingalert
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName opportunity_msdyn_bookingalerts
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: CRMActivity.RollupByParty
ViewId: 00000000-0000-0000-00aa-000010001903

See also

Dataverse table/entity reference
Dataverse Web API Reference