Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: 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: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: 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: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: 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: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: 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: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: 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: UseCollectionNameGroup: DetailsLabel: 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: UseLabelGroup: DetailsLabel: Requirements MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference