Appointment table/entity reference (Microsoft Dynamics 365)

Artigo
02/08/2025

Commitment representing a time interval with start/end times and duration.

Note

The Microsoft Dynamics 365 Appointment table extends the Microsoft Dataverse Appointment table.

Writable columns/attributes

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

ServiceId

Property	Value
Description	Unique identifier for an associated service.
DisplayName	Service
IsValidForForm	False
IsValidForRead	True
LogicalName	`serviceid`
RequiredLevel	None
Type	Lookup
Targets	service

Customized columns/attributes

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

OptionalAttendees
RegardingObjectId
requiredattendees

OptionalAttendees

Changes from OptionalAttendees (Microsoft Dataverse)

Property	Value
Targets	entitlement, equipment, lead, msdyn_salessuggestion

RegardingObjectId

Changes from RegardingObjectId (Microsoft Dataverse)

Property	Value
Targets	bookableresourcebooking, bookableresourcebookingheader, bulkoperation, campaign, campaignactivity, contract, entitlement, entitlementtemplate, incident, invoice, lead, msdyn_customerasset, msdyn_playbookinstance, msdyn_postalbum, msdyn_salessuggestion, msdyn_swarm, opportunity, quote, salesorder, site

requiredattendees

Changes from requiredattendees (Microsoft Dataverse)

Property	Value
Targets	entitlement, equipment, lead, msdyn_salessuggestion

Many-to-One relationships

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

bookableresourcebooking_Appointments
bookableresourcebookingheader_Appointments
BulkOperation_Appointment
Campaign_Appointments
CampaignActivity_Appointments
Contract_Appointments
entitlement_Appointments
entitlementtemplate_Appointments
Incident_Appointments
Invoice_Appointments
Lead_Appointments
msdyn_customerasset_Appointments
msdyn_postalbum_Appointments
msdyn_salessuggestion_Appointments
msdyn_swarm_Appointments
Opportunity_Appointments
Quote_Appointments
SalesOrder_Appointments
service_appointments
site_Appointments

bookableresourcebooking_Appointments

One-To-Many Relationship: bookableresourcebooking bookableresourcebooking_Appointments

Property	Value
ReferencedEntity	`bookableresourcebooking`
ReferencedAttribute	`bookableresourcebookingid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_bookableresourcebooking_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

bookableresourcebookingheader_Appointments

One-To-Many Relationship: bookableresourcebookingheader bookableresourcebookingheader_Appointments

Property	Value
ReferencedEntity	`bookableresourcebookingheader`
ReferencedAttribute	`bookableresourcebookingheaderid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_bookableresourcebookingheader_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

BulkOperation_Appointment

One-To-Many Relationship: bulkoperation BulkOperation_Appointment

Property	Value
ReferencedEntity	`bulkoperation`
ReferencedAttribute	`activityid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_bulkoperation_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Campaign_Appointments

One-To-Many Relationship: campaign Campaign_Appointments

Property	Value
ReferencedEntity	`campaign`
ReferencedAttribute	`campaignid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_campaign_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

CampaignActivity_Appointments

One-To-Many Relationship: campaignactivity CampaignActivity_Appointments

Property	Value
ReferencedEntity	`campaignactivity`
ReferencedAttribute	`activityid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_campaignactivity_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Contract_Appointments

One-To-Many Relationship: contract Contract_Appointments

Property	Value
ReferencedEntity	`contract`
ReferencedAttribute	`contractid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_contract_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

entitlement_Appointments

One-To-Many Relationship: entitlement entitlement_Appointments

Property	Value
ReferencedEntity	`entitlement`
ReferencedAttribute	`entitlementid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_entitlement_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

entitlementtemplate_Appointments

One-To-Many Relationship: entitlementtemplate entitlementtemplate_Appointments

Property	Value
ReferencedEntity	`entitlementtemplate`
ReferencedAttribute	`entitlementtemplateid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_entitlementtemplate_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Incident_Appointments

One-To-Many Relationship: incident Incident_Appointments

Property	Value
ReferencedEntity	`incident`
ReferencedAttribute	`incidentid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_incident_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Invoice_Appointments

One-To-Many Relationship: invoice Invoice_Appointments

Property	Value
ReferencedEntity	`invoice`
ReferencedAttribute	`invoiceid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_invoice_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Lead_Appointments

One-To-Many Relationship: lead Lead_Appointments

Property	Value
ReferencedEntity	`lead`
ReferencedAttribute	`leadid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_lead_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_customerasset_Appointments

One-To-Many Relationship: msdyn_customerasset msdyn_customerasset_Appointments

Property	Value
ReferencedEntity	`msdyn_customerasset`
ReferencedAttribute	`msdyn_customerassetid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_customerasset_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_postalbum_Appointments

One-To-Many Relationship: msdyn_postalbum msdyn_postalbum_Appointments

Property	Value
ReferencedEntity	`msdyn_postalbum`
ReferencedAttribute	`msdyn_postalbumid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_postalbum_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_salessuggestion_Appointments

One-To-Many Relationship: msdyn_salessuggestion msdyn_salessuggestion_Appointments

Property	Value
ReferencedEntity	`msdyn_salessuggestion`
ReferencedAttribute	`msdyn_salessuggestionid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_salessuggestion_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_swarm_Appointments

One-To-Many Relationship: msdyn_swarm msdyn_swarm_Appointments

Property	Value
ReferencedEntity	`msdyn_swarm`
ReferencedAttribute	`msdyn_swarmid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_swarm_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Opportunity_Appointments

One-To-Many Relationship: opportunity Opportunity_Appointments

Property	Value
ReferencedEntity	`opportunity`
ReferencedAttribute	`opportunityid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_opportunity_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Quote_Appointments

One-To-Many Relationship: quote Quote_Appointments

Property	Value
ReferencedEntity	`quote`
ReferencedAttribute	`quoteid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_quote_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

SalesOrder_Appointments

One-To-Many Relationship: salesorder SalesOrder_Appointments

Property	Value
ReferencedEntity	`salesorder`
ReferencedAttribute	`salesorderid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_salesorder_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

service_appointments

One-To-Many Relationship: service service_appointments

Property	Value
ReferencedEntity	`service`
ReferencedAttribute	`serviceid`
ReferencingAttribute	`serviceid`
ReferencingEntityNavigationPropertyName	`serviceid_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

site_Appointments

One-To-Many Relationship: site site_Appointments

Property	Value
ReferencedEntity	`site`
ReferencedAttribute	`siteid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_site_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

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

appointment_campaignresponse
msdyn_appointment_msdyn_conversationinsight_conversationinsighttarget
msdyn_appointment_msdyn_externalrecord
msdyn_appointment_msdyn_ocrecording_recordingtarget
msdyn_appointment_msdyn_transcript_transcripttarget
msdyn_msdyn_conversationactionitem_appointment_msdyn_CreatedActivity
msdyn_msdyn_salescopilotinsight_appointment_msdyn_activityid
msdyn_msdyn_sciconversation_appointment_msdyn_RelatedActivity

appointment_campaignresponse

Many-To-One Relationship: campaignresponse appointment_campaignresponse

Property	Value
ReferencingEntity	`campaignresponse`
ReferencingAttribute	`originatingactivityid`
ReferencedEntityNavigationPropertyName	`appointment_campaignresponse`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_appointment_msdyn_conversationinsight_conversationinsighttarget

Many-To-One Relationship: msdyn_conversationinsight msdyn_appointment_msdyn_conversationinsight_conversationinsighttarget

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

msdyn_appointment_msdyn_externalrecord

Many-To-One Relationship: msdyn_externalrecord msdyn_appointment_msdyn_externalrecord

Property	Value
ReferencingEntity	`msdyn_externalrecord`
ReferencingAttribute	`msdyn_referencerecord`
ReferencedEntityNavigationPropertyName	`msdyn_appointment_msdyn_externalrecord`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_appointment_msdyn_ocrecording_recordingtarget

Many-To-One Relationship: msdyn_ocrecording msdyn_appointment_msdyn_ocrecording_recordingtarget

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

msdyn_appointment_msdyn_transcript_transcripttarget

Many-To-One Relationship: msdyn_transcript msdyn_appointment_msdyn_transcript_transcripttarget

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

msdyn_msdyn_conversationactionitem_appointment_msdyn_CreatedActivity

Many-To-One Relationship: msdyn_conversationactionitem msdyn_msdyn_conversationactionitem_appointment_msdyn_CreatedActivity

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

msdyn_msdyn_salescopilotinsight_appointment_msdyn_activityid

Many-To-One Relationship: msdyn_salescopilotinsight msdyn_msdyn_salescopilotinsight_appointment_msdyn_activityid

Property	Value
ReferencingEntity	`msdyn_salescopilotinsight`
ReferencingAttribute	`msdyn_activityid`
ReferencedEntityNavigationPropertyName	`msdyn_msdyn_salescopilotinsight_appointment_msdyn_activityid`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_msdyn_sciconversation_appointment_msdyn_RelatedActivity

Many-To-One Relationship: msdyn_sciconversation msdyn_msdyn_sciconversation_appointment_msdyn_RelatedActivity

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

Compartilhar via