Edit

Share via


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

Association between an opportunity and a product.

Note

The Microsoft Dynamics 365 Field Service Opportunity Line (OpportunityProduct) table extends the Microsoft Dynamics 365 Opportunity Line (OpportunityProduct) table.

Properties

The following table lists selected properties for the Opportunity Line (OpportunityProduct) table.

Property Value
DisplayName Opportunity Line
DisplayCollectionName Opportunity Lines

Writable columns/attributes

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

msdyn_Duration

Property Value
Description Enter the duration of the agreement
DisplayName Duration
IsValidForForm True
IsValidForRead True
LogicalName msdyn_duration
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue 0

msdyn_enddate

Property Value
Description Enter the end date of the agreement
DisplayName End Date
IsValidForForm True
IsValidForRead True
LogicalName msdyn_enddate
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Auto
SourceTypeMask 0

msdyn_LineType

Property Value
Description The field to distinguish the order lines to be of project service or field service
DisplayName Line Type
IsValidForForm True
IsValidForRead True
LogicalName msdyn_linetype
RequiredLevel None
Type Picklist
DefaultFormValue -1
GlobalChoiceName msdyn_linetype

msdyn_LineType Choices/Options

Value Label
690970000 Project Service Line
690970001 Field Service Line

msdyn_pricelist

Property Value
Description Select a price list for the opportunity line
DisplayName Price List
IsValidForForm True
IsValidForRead True
LogicalName msdyn_pricelist
RequiredLevel None
Type Lookup
Targets pricelevel

msdyn_serviceaccount

Property Value
Description Select the service account for the opportunity line
DisplayName Service Account
IsValidForForm True
IsValidForRead True
LogicalName msdyn_serviceaccount
RequiredLevel None
Type Lookup
Targets account

msdyn_startdate

Property Value
Description Start date of the Agreement
DisplayName Start Date
IsValidForForm True
IsValidForRead True
LogicalName msdyn_startdate
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Auto
SourceTypeMask 0

Many-to-One relationships

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

msdyn_account_opportunityproduct_ServiceAccount

One-To-Many Relationship: account msdyn_account_opportunityproduct_ServiceAccount

Property Value
ReferencedEntity account
ReferencedAttribute accountid
ReferencingAttribute msdyn_serviceaccount
ReferencingEntityNavigationPropertyName msdyn_serviceaccount
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: Cascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

See also

Dataverse table/entity reference
Dataverse Web API Reference