Service Activity (ServiceAppointment) table/entity reference (Microsoft Dynamics 365 Customer Service)

Статья
02/08/2025

Activity offered by the organization to satisfy its customer's needs. Each service activity includes date, time, duration, and required resources.

Note

The Microsoft Dynamics 365 Customer Service Service Activity (ServiceAppointment) table extends the Microsoft Dynamics 365 Service Activity (ServiceAppointment) table.

Writable columns/attributes

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

msdyn_OrganizationalUnitId

Property	Value
Description	OrganizationalUnit ServiceAppointment Id
DisplayName	OrganizationalUnit ServiceAppointment Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_organizationalunitid`
RequiredLevel	None
Type	Lookup
Targets	msdyn_organizationalunit

Customized columns/attributes

Microsoft Dynamics 365 Customer Service modifies the definition of columns/attributes defined in other solutions. Listed by SchemaName.

RegardingObjectId

Changes from RegardingObjectId (Microsoft Dynamics 365)

Property	Value
Targets	msdyn_bookingalertstatus, msdyn_bookingrule, msdyn_resourceterritory, msdyn_systemuserschedulersetting, msdyn_timegroup, msdyn_timegroupdetail

Many-to-One relationships

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

msdyn_bookingalertstatus_ServiceAppointments
msdyn_bookingrule_ServiceAppointments
msdyn_organizationalunit_serviceappointment
msdyn_resourceterritory_ServiceAppointments
msdyn_systemuserschedulersetting_ServiceAppointments
msdyn_timegroup_ServiceAppointments
msdyn_timegroupdetail_ServiceAppointments

msdyn_bookingalertstatus_ServiceAppointments

One-To-Many Relationship: msdyn_bookingalertstatus msdyn_bookingalertstatus_ServiceAppointments

Property	Value
ReferencedEntity	`msdyn_bookingalertstatus`
ReferencedAttribute	`msdyn_bookingalertstatusid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_bookingalertstatus_serviceappointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_bookingrule_ServiceAppointments

One-To-Many Relationship: msdyn_bookingrule msdyn_bookingrule_ServiceAppointments

Property	Value
ReferencedEntity	`msdyn_bookingrule`
ReferencedAttribute	`msdyn_bookingruleid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_bookingrule_serviceappointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_organizationalunit_serviceappointment

One-To-Many Relationship: msdyn_organizationalunit msdyn_organizationalunit_serviceappointment

Property	Value
ReferencedEntity	`msdyn_organizationalunit`
ReferencedAttribute	`msdyn_organizationalunitid`
ReferencingAttribute	`msdyn_organizationalunitid`
ReferencingEntityNavigationPropertyName	`msdyn_OrganizationalUnitServiceAppointmentId_ServiceAppointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_resourceterritory_ServiceAppointments

One-To-Many Relationship: msdyn_resourceterritory msdyn_resourceterritory_ServiceAppointments

Property	Value
ReferencedEntity	`msdyn_resourceterritory`
ReferencedAttribute	`msdyn_resourceterritoryid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_resourceterritory_serviceappointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_systemuserschedulersetting_ServiceAppointments

One-To-Many Relationship: msdyn_systemuserschedulersetting msdyn_systemuserschedulersetting_ServiceAppointments

Property	Value
ReferencedEntity	`msdyn_systemuserschedulersetting`
ReferencedAttribute	`msdyn_systemuserschedulersettingid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_systemuserschedulersetting_serviceappointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_timegroup_ServiceAppointments

One-To-Many Relationship: msdyn_timegroup msdyn_timegroup_ServiceAppointments

Property	Value
ReferencedEntity	`msdyn_timegroup`
ReferencedAttribute	`msdyn_timegroupid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_timegroup_serviceappointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_timegroupdetail_ServiceAppointments

One-To-Many Relationship: msdyn_timegroupdetail msdyn_timegroupdetail_ServiceAppointments

Property	Value
ReferencedEntity	`msdyn_timegroupdetail`
ReferencedAttribute	`msdyn_timegroupdetailid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_timegroupdetail_serviceappointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

One-to-Many relationships

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

msdyn_serviceappointment_bookableresourcebooking_serviceappointment
msdyn_serviceappointment_msdyn_resourcerequirement_serviceappointment

msdyn_serviceappointment_bookableresourcebooking_serviceappointment

Many-To-One Relationship: bookableresourcebooking msdyn_serviceappointment_bookableresourcebooking_serviceappointment

Property	Value
ReferencingEntity	`bookableresourcebooking`
ReferencingAttribute	`msdyn_serviceappointment`
ReferencedEntityNavigationPropertyName	`msdyn_serviceappointment_bookableresourcebooking_serviceappointment`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_serviceappointment_msdyn_resourcerequirement_serviceappointment

Many-To-One Relationship: msdyn_resourcerequirement msdyn_serviceappointment_msdyn_resourcerequirement_serviceappointment

Property	Value
ReferencingEntity	`msdyn_resourcerequirement`
ReferencingAttribute	`msdyn_serviceappointment`
ReferencedEntityNavigationPropertyName	`msdyn_serviceappointment_msdyn_resourcerequirement_serviceappointment`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseLabel` Group: `Details` Label: Requirements MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Поделиться через