Edit

Share via

Appointment table/entity reference (Microsoft Dataverse)

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

Messages

The following table lists the messages for the Appointment table. Messages represent operations that can be performed on the table. They may also be events.

Name
Is Event?		 Web API Operation SDK for .NET
Assign
Event: True		 PATCH /appointments(activityid)
Update the ownerid property.		 AssignRequest
Associate
Event: True		 Associate records Associate records
Book
Event: True		 Book BookRequest
Create
Event: True		 POST /appointments
See Create		 Create records
CreateException
Event: True		 CreateException CreateExceptionRequest
Delete
Event: True		 DELETE /appointments(activityid)
See Delete		 Delete records
Disassociate
Event: True		 Disassociate records Disassociate records
GrantAccess
Event: True		 GrantAccess GrantAccessRequest
ImmediateBook
Event: True		 ImmediateBook ImmediateBookRequest
ModifyAccess
Event: True		 ModifyAccess ModifyAccessRequest
Reschedule
Event: True		 Reschedule RescheduleRequest
Retrieve
Event: True		 GET /appointments(activityid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: True		 GET /appointments
See Query data		 Query data
RetrievePrincipalAccess
Event: True		 RetrievePrincipalAccess RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess
Event: True		 RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess
Event: True		 RevokeAccess RevokeAccessRequest
SetState
Event: True		 PATCH /appointments(activityid)
Update the statecode and statuscode properties.		 SetStateRequest
Update
Event: True		 PATCH /appointments(activityid)
See Update		 Update records
Upsert
Event: False		 PATCH /appointments(activityid)
See Upsert a table row		 UpsertRequest
Validate
Event: True		 Validate ValidateRequest
ValidateSavedQuery
Event: True		 ValidateSavedQuery ValidateSavedQueryRequest
ValidateUnpublished
Event: True		 ValidateUnpublished ValidateUnpublishedRequest

Properties

The following table lists selected properties for the Appointment table.

Property Value
DisplayName Appointment
DisplayCollectionName Appointments
SchemaName Appointment
CollectionSchemaName Appointments
EntitySetName appointments
LogicalName appointment
LogicalCollectionName appointments
PrimaryIdAttribute activityid
PrimaryNameAttribute subject
TableType Standard
OwnershipType UserOwned

Writable columns/attributes

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

ActivityAdditionalParams

Property Value
Description For internal use only.
DisplayName Additional Parameters
IsValidForForm True
IsValidForRead True
LogicalName activityadditionalparams
RequiredLevel None
Type Memo
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 8192

ActivityId

Property Value
Description Unique identifier of the appointment.
DisplayName Appointment
IsValidForForm False
IsValidForRead True
LogicalName activityid
RequiredLevel SystemRequired
Type Uniqueidentifier

ActualDurationMinutes

Property Value
Description Shows the value selected in the Duration field on the appointment at the time that the appointment is closed as completed. The duration is used to report the time spent on the activity.
DisplayName Actual Duration
IsValidForForm True
IsValidForRead True
LogicalName actualdurationminutes
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue 0

ActualEnd

Property Value
Description Enter the actual end date and time of the appointment. By default, it displays the date and time when the activity was completed or canceled, but can be edited to capture the actual duration of the appointment.
DisplayName Actual End
IsValidForForm True
IsValidForRead True
LogicalName actualend
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ActualStart

Property Value
Description Enter the actual start date and time for the appointment. By default, it displays the date and time when the activity was created, but can be edited to capture the actual duration of the appointment.
DisplayName Actual Start
IsValidForForm True
IsValidForRead True
LogicalName actualstart
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

AttachmentErrors

Property Value
Description Select the error code to identify issues with the outlook item recipients or attachments, such as blocked attachments.
DisplayName AttachmentErrors
IsValidForForm True
IsValidForRead True
LogicalName attachmenterrors
RequiredLevel None
Type Picklist
DefaultFormValue 0
GlobalChoiceName appointment_attachmenterrors

AttachmentErrors Choices/Options

Value Label
0 None
1 The appointment was saved as a Microsoft Dynamics 365 appointment record, but not all the attachments could be saved with it. An attachment cannot be saved if it is blocked or if its file type is invalid.

Category

Property Value
Description Type a category to identify the appointment type, such as sales demo, prospect call, or service call, to tie the appointment to a business group or function.
DisplayName Category
IsValidForForm True
IsValidForRead True
LogicalName category
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 250

Description

Property Value
Description Type additional information to describe the purpose of the appointment.
DisplayName Description
IsValidForForm True
IsValidForRead True
LogicalName description
RequiredLevel None
Type Memo
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 1048576

GlobalObjectId

Property Value
Description Shows the ID of the appointment in Microsoft Office Outlook. The ID is used to synchronize the appointment between Microsoft Dynamics 365 and the correct Exchange account.
DisplayName Outlook Appointment
IsValidForForm False
IsValidForRead True
LogicalName globalobjectid
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 300

ImportSequenceNumber

Property Value
Description Unique identifier of the data import or data migration that created this record.
DisplayName Import Sequence Number
IsValidForForm False
IsValidForRead True
LogicalName importsequencenumber
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

IsAllDayEvent

Property Value
Description Select whether the appointment is an all-day event to make sure that the required resources are scheduled for the full day.
DisplayName All Day Event
IsValidForForm True
IsValidForRead True
LogicalName isalldayevent
RequiredLevel None
Type Boolean
GlobalChoiceName appointment_isalldayevent
DefaultValue False
True Label Yes
False Label No

IsBilled

Property Value
Description Information regarding whether the appointment was billed as part of resolving a case.
DisplayName Is Billed
IsValidForForm False
IsValidForRead True
LogicalName isbilled
RequiredLevel None
Type Boolean
GlobalChoiceName appointment_isbilled
DefaultValue False
True Label Yes
False Label No

IsDraft

Property Value
Description Information regarding whether the appointment is a draft.
DisplayName IsDraft
IsValidForForm False
IsValidForRead True
LogicalName isdraft
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName appointment_isdraft
DefaultValue False
True Label Yes
False Label No

IsMapiPrivate

Property Value
Description For internal use only.
DisplayName Is Private
IsValidForForm False
IsValidForRead True
LogicalName ismapiprivate
RequiredLevel None
Type Boolean
GlobalChoiceName appointment_ismapiprivate
DefaultValue False
True Label Yes
False Label No

IsOnlineMeeting

Property Value
Description Displays whether or not this is an online meeting.
DisplayName Is Online Meeting
IsValidForForm True
IsValidForRead True
LogicalName isonlinemeeting
RequiredLevel None
Type Boolean
GlobalChoiceName isonlinemeeting
DefaultValue False
True Label Yes
False Label No

IsWorkflowCreated

Property Value
Description Information regarding whether the appointment was created from a workflow rule.
DisplayName Is Workflow Created
IsValidForForm False
IsValidForRead True
LogicalName isworkflowcreated
RequiredLevel None
Type Boolean
GlobalChoiceName appointment_isworkflowcreated
DefaultValue False
True Label Yes
False Label No

LastOnHoldTime

Property Value
Description Contains the date and time stamp of the last on hold time.
DisplayName Last On Hold Time
IsValidForForm True
IsValidForRead True
LogicalName lastonholdtime
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

Location

Property Value
Description Type the ___location where the appointment will take place, such as a conference room or customer office.
DisplayName Location
IsValidForForm True
IsValidForRead True
LogicalName ___location
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 200

OnlineMeetingChatId

Property Value
Description Shows the online meeting chat id.
DisplayName Online Meeting Chat Id
IsValidForForm True
IsValidForRead True
LogicalName onlinemeetingchatid
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 200

OnlineMeetingId

Property Value
Description Shows the online meeting id.
DisplayName Online Meeting Id
IsValidForForm True
IsValidForRead True
LogicalName onlinemeetingid
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 300

OnlineMeetingJoinUrl

Property Value
Description Shows the online meeting join url.
DisplayName Online Meeting Join Url
IsValidForForm True
IsValidForRead True
LogicalName onlinemeetingjoinurl
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 600

OnlineMeetingType

Property Value
Description Displays the online meeting type.
DisplayName Online Meeting Type
IsValidForForm True
IsValidForRead True
LogicalName onlinemeetingtype
RequiredLevel None
Type Picklist
DefaultFormValue
GlobalChoiceName onlinemeetingtype

OnlineMeetingType Choices/Options

Value Label
1 Teams Meeting

OptionalAttendees

Property Value
Description Enter the account, contact, lead, user, or other equipment resources that are not needed at the appointment, but can optionally attend.
DisplayName Optional Attendees
IsValidForForm True
IsValidForRead True
LogicalName optionalattendees
RequiredLevel None
Type PartyList
Targets account, contact, knowledgearticle, queue, systemuser, unresolvedaddress

Organizer

Property Value
Description Enter the user who is in charge of coordinating or leading the appointment to make sure the appointment is displayed in the user's My Activities view.
DisplayName Organizer
IsValidForForm True
IsValidForRead True
LogicalName organizer
RequiredLevel None
Type PartyList
Targets systemuser

OutlookOwnerApptId

Property Value
Description Unique identifier of the Microsoft Office Outlook appointment owner that correlates to the PR_OWNER_APPT_ID MAPI property.
DisplayName Outlook Appointment Owner
IsValidForForm False
IsValidForRead True
LogicalName outlookownerapptid
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

OverriddenCreatedOn

Property Value
Description Date and time that the record was migrated.
DisplayName Record Created On
IsValidForForm False
IsValidForRead True
LogicalName overriddencreatedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Inactive
SourceTypeMask 0

OwnerId

Property Value
Description Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user.
DisplayName Owner
IsValidForForm True
IsValidForRead True
LogicalName ownerid
RequiredLevel SystemRequired
Type Owner
Targets systemuser, team

OwnerIdType

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridtype
RequiredLevel SystemRequired
Type EntityName

PriorityCode

Property Value
Description Select the priority so that preferred customers or critical issues are handled quickly.
DisplayName Priority
IsValidForForm True
IsValidForRead True
LogicalName prioritycode
RequiredLevel None
Type Picklist
DefaultFormValue 1
GlobalChoiceName appointment_prioritycode

PriorityCode Choices/Options

Value Label
0 Low
1 Normal
2 High

ProcessId

Property Value
Description Shows the ID of the process.
DisplayName Process
IsValidForForm False
IsValidForRead True
LogicalName processid
RequiredLevel None
Type Uniqueidentifier

RegardingObjectId

Property Value
Description Choose the record that the appointment relates to.
DisplayName Regarding
IsValidForForm True
IsValidForRead True
LogicalName regardingobjectid
RequiredLevel None
Type Lookup
Targets account, adx_invitation, contact, knowledgearticle, knowledgebaserecord, mspp_adplacement, mspp_pollplacement, mspp_publishingstatetransitionrule, mspp_redirect, mspp_shortcut, mspp_website

RegardingObjectTypeCode

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName regardingobjecttypecode
RequiredLevel None
Type EntityName

requiredattendees

Property Value
Description Enter the account, contact, lead, user, or other equipment resources that are required to attend the appointment.
DisplayName Required Attendees
IsValidForForm True
IsValidForRead True
LogicalName requiredattendees
RequiredLevel None
Type PartyList
Targets account, contact, knowledgearticle, queue, systemuser, unresolvedaddress

ScheduledDurationMinutes

Property Value
Description Shows the expected duration of the appointment, in minutes.
DisplayName Duration
IsValidForForm True
IsValidForRead True
LogicalName scheduleddurationminutes
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue 0

ScheduledEnd

Property Value
Description Enter the expected due date and time for the activity to be completed to provide details about the timing of the appointment.
DisplayName End Time
IsValidForForm True
IsValidForRead True
LogicalName scheduledend
RequiredLevel ApplicationRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ScheduledStart

Property Value
Description Enter the expected start date and time for the activity to provide details about the timing of the appointment.
DisplayName Start Time
IsValidForForm True
IsValidForRead True
LogicalName scheduledstart
RequiredLevel ApplicationRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

SLAId

Property Value
Description Choose the service level agreement (SLA) that you want to apply to the appointment record.
DisplayName SLA
IsValidForForm True
IsValidForRead True
LogicalName slaid
RequiredLevel None
Type Lookup
Targets sla

SortDate

Property Value
Description Shows the date and time by which the activities are sorted.
DisplayName Sort Date
IsValidForForm True
IsValidForRead True
LogicalName sortdate
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

StageId

Property Value
Description Shows the ID of the stage.
DisplayName (Deprecated) Process Stage
IsValidForForm False
IsValidForRead True
LogicalName stageid
RequiredLevel None
Type Uniqueidentifier

StateCode

Property Value
Description Shows whether the appointment is open, completed, or canceled. Completed and canceled appointments are read-only and can't be edited.
DisplayName Status
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State
DefaultFormValue 0
GlobalChoiceName appointment_statecode

StateCode Choices/Options

Value Details
0 Label: Open
DefaultStatus: 1
InvariantName: Open
1 Label: Completed
DefaultStatus: 3
InvariantName: Completed
2 Label: Canceled
DefaultStatus: 4
InvariantName: Canceled
3 Label: Scheduled
DefaultStatus: 5
InvariantName: Scheduled

StatusCode

Property Value
Description Select the appointment's status.
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel None
Type Status
DefaultFormValue -1
GlobalChoiceName appointment_statuscode

StatusCode Choices/Options

Value Details
1 Label: Free
State:0
TransitionData: None
2 Label: Tentative
State:0
TransitionData: None
3 Label: Completed
State:1
TransitionData: None
4 Label: Canceled
State:2
TransitionData: None
5 Label: Busy
State:3
TransitionData: None
6 Label: Out of Office
State:3
TransitionData: None

Subcategory

Property Value
Description Type a subcategory to identify the appointment type and relate the activity to a specific product, sales region, business group, or other function.
DisplayName Sub-Category
IsValidForForm True
IsValidForRead True
LogicalName subcategory
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 250

Subject

Property Value
Description Type a short description about the objective or primary topic of the appointment.
DisplayName Subject
IsValidForForm True
IsValidForRead True
LogicalName subject
RequiredLevel ApplicationRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 200

SubscriptionId

Property Value
Description For internal use only.
DisplayName Subscription
IsValidForForm False
IsValidForRead False
LogicalName subscriptionid
RequiredLevel None
Type Uniqueidentifier

TimeZoneRuleVersionNumber

Property Value
Description For internal use only.
DisplayName Time Zone Rule Version Number
IsValidForForm False
IsValidForRead True
LogicalName timezoneruleversionnumber
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -1

TransactionCurrencyId

Property Value
Description Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName Currency
IsValidForForm True
IsValidForRead True
LogicalName transactioncurrencyid
RequiredLevel None
Type Lookup
Targets transactioncurrency

TraversedPath

Property Value
Description For internal use only.
DisplayName (Deprecated) Traversed Path
IsValidForForm False
IsValidForRead True
LogicalName traversedpath
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 1250

UTCConversionTimeZoneCode

Property Value
Description Time zone code that was in use when the record was created.
DisplayName UTC Conversion Time Zone Code
IsValidForForm False
IsValidForRead True
LogicalName utcconversiontimezonecode
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -1

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

ActivityTypeCode

Property Value
Description Type of activity.
DisplayName Activity Type
IsValidForForm False
IsValidForRead True
LogicalName activitytypecode
RequiredLevel SystemRequired
Type EntityName

AttachmentCount

Property Value
Description Shows the number of attachments on the appointment.
DisplayName Attachment Count
IsValidForForm False
IsValidForRead True
LogicalName attachmentcount
RequiredLevel SystemRequired
Type Integer
MaxValue 2147483647
MinValue 0

CreatedBy

Property Value
Description Shows who created the record.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName createdby
RequiredLevel None
Type Lookup
Targets systemuser

CreatedOn

Property Value
Description Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName Created On
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

CreatedOnBehalfBy

Property Value
Description Shows who created the record on behalf of another user.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

ExchangeRate

Property Value
Description Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
DisplayName Exchange Rate
IsValidForForm True
IsValidForRead True
LogicalName exchangerate
RequiredLevel None
Type Decimal
ImeMode Disabled
MaxValue 100000000000
MinValue 1E-12
Precision 12
SourceTypeMask 0

FormattedScheduledEnd

Property Value
Description Formatted scheduled end time of the appointment.
DisplayName Formatted End Date
IsValidForForm True
IsValidForRead True
LogicalName formattedscheduledend
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior TimeZoneIndependent
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

FormattedScheduledStart

Property Value
Description Formatted scheduled start time of the appointment.
DisplayName Formatted Start Date
IsValidForForm True
IsValidForRead True
LogicalName formattedscheduledstart
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior TimeZoneIndependent
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

InstanceTypeCode

Property Value
Description Type of instance of a recurring series.
DisplayName Appointment Type
IsValidForForm False
IsValidForRead True
LogicalName instancetypecode
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue 0
GlobalChoiceName appointment_instancetypecode

InstanceTypeCode Choices/Options

Value Label
0 Not Recurring
1 Recurring Master
2 Recurring Instance
3 Recurring Exception
4 Recurring Future Exception

IsRegularActivity

Property Value
Description Information regarding whether the activity is a regular activity type or event type.
DisplayName Is Regular Activity
IsValidForForm False
IsValidForRead True
LogicalName isregularactivity
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName activitypointer_isregularactivity
DefaultValue False
True Label Yes
False Label No

IsUnsafe

Property Value
Description For internal use only.
DisplayName IsUnsafe
IsValidForForm False
IsValidForRead True
LogicalName isunsafe
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue 0

ModifiedBy

Property Value
Description Shows who last updated the record.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Type Lookup
Targets systemuser

ModifiedFieldsMask

Property Value
Description For internal use only.
DisplayName Modified Fields Mask
IsValidForForm False
IsValidForRead True
LogicalName modifiedfieldsmask
RequiredLevel None
Type Memo
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 1073741823

ModifiedOn

Property Value
Description Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName Modified On
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ModifiedOnBehalfBy

Property Value
Description Shows who created the record on behalf of another user.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

OnHoldTime

Property Value
Description Shows how long, in minutes, that the record was on hold.
DisplayName On Hold Time (Minutes)
IsValidForForm True
IsValidForRead True
LogicalName onholdtime
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

OriginalStartDate

Property Value
Description The original start date of the appointment.
DisplayName Original Start Date
IsValidForForm False
IsValidForRead True
LogicalName originalstartdate
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

OwnerIdName

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridname
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

OwnerIdYomiName

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridyominame
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

OwningBusinessUnit

Property Value
Description Shows the business unit that the record owner belongs to.
DisplayName Owning Business Unit
IsValidForForm True
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Type Lookup
Targets businessunit

OwningTeam

Property Value
Description Unique identifier of the team that owns the appointment.
DisplayName Owning Team
IsValidForForm False
IsValidForRead True
LogicalName owningteam
RequiredLevel None
Type Lookup
Targets team

OwningUser

Property Value
Description Unique identifier of the user that owns the appointment.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel None
Type Lookup
Targets systemuser

SafeDescription

Property Value
Description Safe body text of the appointment.
DisplayName Safe Description
IsValidForForm False
IsValidForRead True
LogicalName safedescription
RequiredLevel None
Type Memo
Format Email
FormatName Email
ImeMode Auto
IsLocalizable False
MaxLength 1073741823

SeriesId

Property Value
Description Shows the ID of the recurring series of an instance.
DisplayName Series Id
IsValidForForm False
IsValidForRead True
LogicalName seriesid
RequiredLevel None
Type Uniqueidentifier

SLAInvokedId

Property Value
Description Last SLA that was applied to this appointment. This field is for internal use only.
DisplayName Last SLA applied
IsValidForForm False
IsValidForRead True
LogicalName slainvokedid
RequiredLevel None
Type Lookup
Targets sla

VersionNumber

Property Value
Description Version number of the appointment.
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
RequiredLevel None
Type BigInt
MaxValue 9223372036854775807
MinValue -9223372036854775808

Many-to-One relationships

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

Account_Appointments

One-To-Many Relationship: account Account_Appointments

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

activity_pointer_appointment

One-To-Many Relationship: activitypointer activity_pointer_appointment

Property Value
ReferencedEntity activitypointer
ReferencedAttribute activityid
ReferencingAttribute activityid
ReferencingEntityNavigationPropertyName activityid_activitypointer
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

adx_invitation_Appointments

One-To-Many Relationship: adx_invitation adx_invitation_Appointments

Property Value
ReferencedEntity adx_invitation
ReferencedAttribute adx_invitationid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_adx_invitation_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

business_unit_appointment_activities

One-To-Many Relationship: businessunit business_unit_appointment_activities

Property Value
ReferencedEntity businessunit
ReferencedAttribute businessunitid
ReferencingAttribute owningbusinessunit
ReferencingEntityNavigationPropertyName owningbusinessunit_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

Contact_Appointments

One-To-Many Relationship: contact Contact_Appointments

Property Value
ReferencedEntity contact
ReferencedAttribute contactid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_contact_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

KnowledgeArticle_Appointments

One-To-Many Relationship: knowledgearticle KnowledgeArticle_Appointments

Property Value
ReferencedEntity knowledgearticle
ReferencedAttribute knowledgearticleid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_knowledgearticle_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

KnowledgeBaseRecord_Appointments

One-To-Many Relationship: knowledgebaserecord KnowledgeBaseRecord_Appointments

Property Value
ReferencedEntity knowledgebaserecord
ReferencedAttribute knowledgebaserecordid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_knowledgebaserecord_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_appointment_createdby

One-To-Many Relationship: systemuser lk_appointment_createdby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdby
ReferencingEntityNavigationPropertyName createdby_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_appointment_createdonbehalfby

One-To-Many Relationship: systemuser lk_appointment_createdonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdonbehalfby
ReferencingEntityNavigationPropertyName createdonbehalfby_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_appointment_modifiedby

One-To-Many Relationship: systemuser lk_appointment_modifiedby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedby
ReferencingEntityNavigationPropertyName modifiedby_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_appointment_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_appointment_modifiedonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedonbehalfby
ReferencingEntityNavigationPropertyName modifiedonbehalfby_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

manualsla_appointment

One-To-Many Relationship: sla manualsla_appointment

Property Value
ReferencedEntity sla
ReferencedAttribute slaid
ReferencingAttribute slaid
ReferencingEntityNavigationPropertyName sla_appointment_sla
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_adplacement_Appointments

One-To-Many Relationship: mspp_adplacement mspp_adplacement_Appointments

Property Value
ReferencedEntity mspp_adplacement
ReferencedAttribute mspp_adplacementid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_mspp_adplacement_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_pollplacement_Appointments

One-To-Many Relationship: mspp_pollplacement mspp_pollplacement_Appointments

Property Value
ReferencedEntity mspp_pollplacement
ReferencedAttribute mspp_pollplacementid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_mspp_pollplacement_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_publishingstatetransitionrule_Appointments

One-To-Many Relationship: mspp_publishingstatetransitionrule mspp_publishingstatetransitionrule_Appointments

Property Value
ReferencedEntity mspp_publishingstatetransitionrule
ReferencedAttribute mspp_publishingstatetransitionruleid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_mspp_publishingstatetransitionrule_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_redirect_Appointments

One-To-Many Relationship: mspp_redirect mspp_redirect_Appointments

Property Value
ReferencedEntity mspp_redirect
ReferencedAttribute mspp_redirectid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_mspp_redirect_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_shortcut_Appointments

One-To-Many Relationship: mspp_shortcut mspp_shortcut_Appointments

Property Value
ReferencedEntity mspp_shortcut
ReferencedAttribute mspp_shortcutid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_mspp_shortcut_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_website_Appointments

One-To-Many Relationship: mspp_website mspp_website_Appointments

Property Value
ReferencedEntity mspp_website
ReferencedAttribute mspp_websiteid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_mspp_website_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

owner_appointments

One-To-Many Relationship: owner owner_appointments

Property Value
ReferencedEntity owner
ReferencedAttribute ownerid
ReferencingAttribute ownerid
ReferencingEntityNavigationPropertyName ownerid_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

processstage_appointments

One-To-Many Relationship: processstage processstage_appointments

Property Value
ReferencedEntity processstage
ReferencedAttribute processstageid
ReferencingAttribute stageid
ReferencingEntityNavigationPropertyName stageid_processstage
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

recurringappointmentmaster_appointment

One-To-Many Relationship: recurringappointmentmaster recurringappointmentmaster_appointment

Property Value
ReferencedEntity recurringappointmentmaster
ReferencedAttribute activityid
ReferencingAttribute seriesid
ReferencingEntityNavigationPropertyName seriesid_recurringappointmentmaster
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

sla_appointment

One-To-Many Relationship: sla sla_appointment

Property Value
ReferencedEntity sla
ReferencedAttribute slaid
ReferencingAttribute slainvokedid
ReferencingEntityNavigationPropertyName slainvokedid_appointment_sla
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

team_appointment

One-To-Many Relationship: team team_appointment

Property Value
ReferencedEntity team
ReferencedAttribute teamid
ReferencingAttribute owningteam
ReferencingEntityNavigationPropertyName owningteam_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

TransactionCurrency_Appointment

One-To-Many Relationship: transactioncurrency TransactionCurrency_Appointment

Property Value
ReferencedEntity transactioncurrency
ReferencedAttribute transactioncurrencyid
ReferencingAttribute transactioncurrencyid
ReferencingEntityNavigationPropertyName transactioncurrencyid_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

user_appointment

One-To-Many Relationship: systemuser user_appointment

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute owninguser
ReferencingEntityNavigationPropertyName owninguser_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-to-Many relationships

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

appointment_actioncard

Many-To-One Relationship: actioncard appointment_actioncard

Property Value
ReferencingEntity actioncard
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName appointment_actioncard
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

appointment_activity_mime_attachment

Many-To-One Relationship: activitymimeattachment appointment_activity_mime_attachment

Property Value
ReferencingEntity activitymimeattachment
ReferencingAttribute objectid
ReferencedEntityNavigationPropertyName appointment_activity_mime_attachment
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

appointment_activity_parties

Many-To-One Relationship: activityparty appointment_activity_parties

Property Value
ReferencingEntity activityparty
ReferencingAttribute activityid
ReferencedEntityNavigationPropertyName appointment_activity_parties
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Appointment_Annotation

Many-To-One Relationship: annotation Appointment_Annotation

Property Value
ReferencingEntity annotation
ReferencingAttribute objectid
ReferencedEntityNavigationPropertyName Appointment_Annotation
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Appointment_AsyncOperations

Many-To-One Relationship: asyncoperation Appointment_AsyncOperations

Property Value
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Appointment_AsyncOperations
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Appointment_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure Appointment_BulkDeleteFailures

Property Value
ReferencingEntity bulkdeletefailure
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Appointment_BulkDeleteFailures
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

appointment_connections1

Many-To-One Relationship: connection appointment_connections1

Property Value
ReferencingEntity connection
ReferencingAttribute record1id
ReferencedEntityNavigationPropertyName appointment_connections1
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 100
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

appointment_connections2

Many-To-One Relationship: connection appointment_connections2

Property Value
ReferencingEntity connection
ReferencingAttribute record2id
ReferencedEntityNavigationPropertyName appointment_connections2
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order: 100
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Appointment_DuplicateBaseRecord

Many-To-One Relationship: duplicaterecord Appointment_DuplicateBaseRecord

Property Value
ReferencingEntity duplicaterecord
ReferencingAttribute baserecordid
ReferencedEntityNavigationPropertyName Appointment_DuplicateBaseRecord
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Appointment_DuplicateMatchingRecord

Many-To-One Relationship: duplicaterecord Appointment_DuplicateMatchingRecord

Property Value
ReferencingEntity duplicaterecord
ReferencingAttribute duplicaterecordid
ReferencedEntityNavigationPropertyName Appointment_DuplicateMatchingRecord
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

appointment_PostFollows

Many-To-One Relationship: postfollow appointment_PostFollows

Property Value
ReferencingEntity postfollow
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName appointment_PostFollows
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

appointment_PostRegardings

Many-To-One Relationship: postregarding appointment_PostRegardings

Property Value
ReferencingEntity postregarding
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName appointment_PostRegardings
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

appointment_principalobjectattributeaccess

Many-To-One Relationship: principalobjectattributeaccess appointment_principalobjectattributeaccess

Property Value
ReferencingEntity principalobjectattributeaccess
ReferencingAttribute objectid
ReferencedEntityNavigationPropertyName appointment_principalobjectattributeaccess
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Appointment_ProcessSessions

Many-To-One Relationship: processsession Appointment_ProcessSessions

Property Value
ReferencingEntity processsession
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Appointment_ProcessSessions
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 110
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Appointment_QueueItem

Many-To-One Relationship: queueitem Appointment_QueueItem

Property Value
ReferencingEntity queueitem
ReferencingAttribute objectid
ReferencedEntityNavigationPropertyName Appointment_QueueItem
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Appointment_SyncErrors

Many-To-One Relationship: syncerror Appointment_SyncErrors

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Appointment_SyncErrors
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

slakpiinstance_appointment

Many-To-One Relationship: slakpiinstance slakpiinstance_appointment

Property Value
ReferencingEntity slakpiinstance
ReferencingAttribute regarding
ReferencedEntityNavigationPropertyName slakpiinstance_appointment
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
appointment