Appointment table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

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

Messages

Message Web API Operation SDK class or method
Assign PATCH /appointments(activityid)
Update ownerid property.
AssignRequest
Book Book BookRequest
Create POST /appointments
See Create
CreateRequest or
Create
CreateException CreateException CreateExceptionRequest
Delete DELETE /appointments(activityid)
See Delete
DeleteRequest or
Delete
GrantAccess GrantAccess GrantAccessRequest
ImmediateBook ImmediateBook ImmediateBookRequest
ModifyAccess ModifyAccess ModifyAccessRequest
Reschedule Reschedule RescheduleRequest
Retrieve GET /appointments(activityid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET /appointments
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess RevokeAccessRequest
SetState PATCH /appointments(activityid)
Update statecode and statuscode properties.
SetStateRequest
Update PATCH /appointments(activityid)
See Update
UpdateRequest or
Update
Validate Validate ValidateRequest
ValidateSavedQuery ValidateSavedQuery ValidateSavedQueryRequest
ValidateUnpublished ValidateUnpublished ValidateUnpublishedRequest

Properties

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

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
Format TextArea
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName activityadditionalparams
MaxLength 8192
RequiredLevel None
Type Memo

ActivityId

Property Value
Description Unique identifier of the appointment.
DisplayName Appointment
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
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
Format Duration
IsValidForForm True
IsValidForRead True
LogicalName actualdurationminutes
MaxValue 2147483647
MinValue 0
RequiredLevel None
Type Integer

ActualEnd

Property Value
DateTimeBehavior UserLocal
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
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName actualend
RequiredLevel None
Type DateTime

ActualStart

Property Value
DateTimeBehavior UserLocal
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
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName actualstart
RequiredLevel None
Type DateTime

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

AttachmentErrors Choices/Options

Value Label Description
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
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName category
MaxLength 250
RequiredLevel None
Type String

Description

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

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
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName globalobjectid
MaxLength 300
RequiredLevel None
Type String

ImportSequenceNumber

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

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

IsAllDayEvent Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

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

IsBilled Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

IsDraft

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

IsDraft Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

IsMapiPrivate

Property Value
Description For internal use only.
DisplayName Is Private
IsValidForForm False
IsValidForRead True
LogicalName ismapiprivate
RequiredLevel None
Type Boolean

IsMapiPrivate Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

IsOnlineMeeting

Added by: msft_ActivitiesInfra_Extensions Solution

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

IsOnlineMeeting Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

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

IsWorkflowCreated Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

LastOnHoldTime

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

Location

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

OnlineMeetingChatId

Added by: msft_ActivitiesInfra_Extensions Solution

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

OnlineMeetingId

Added by: msft_ActivitiesInfra_Extensions Solution

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

OnlineMeetingJoinUrl

Added by: msft_ActivitiesInfra_Extensions Solution

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

OnlineMeetingType

Added by: msft_ActivitiesInfra_Extensions Solution

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

OnlineMeetingType Choices/Options

Value Label Description
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
Targets account,contact,knowledgearticle,queue,systemuser,unresolvedaddress
Type PartyList

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
Targets systemuser
Type PartyList

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
Format None
IsValidForForm False
IsValidForRead True
LogicalName outlookownerapptid
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

OverriddenCreatedOn

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

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
Targets systemuser,team
Type Owner

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

PriorityCode Choices/Options

Value Label Description
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
Targets account,adx_invitation,contact,knowledgearticle,knowledgebaserecord,mspp_adplacement,mspp_pollplacement,mspp_publishingstatetransitionrule,mspp_redirect,mspp_shortcut,mspp_website
Type Lookup

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
Targets account,contact,knowledgearticle,queue,systemuser,unresolvedaddress
Type PartyList

ScheduledDurationMinutes

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

ScheduledEnd

Property Value
DateTimeBehavior UserLocal
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
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName scheduledend
RequiredLevel ApplicationRequired
Type DateTime

ScheduledStart

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

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
Targets sla
Type Lookup

SortDate

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

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
IsValidForCreate False
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State

StateCode Choices/Options

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

StatusCode

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

StatusCode Choices/Options

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

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
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName subcategory
MaxLength 250
RequiredLevel None
Type String

Subject

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

SubscriptionId

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

TimeZoneRuleVersionNumber

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

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
Targets transactioncurrency
Type Lookup

TraversedPath

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

UTCConversionTimeZoneCode

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

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or 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
Format None
IsValidForForm False
IsValidForRead True
LogicalName attachmentcount
MaxValue 2147483647
MinValue 0
RequiredLevel SystemRequired
Type Integer

CreatedBy

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

CreatedByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyyominame
MaxLength 100
RequiredLevel None
Type String

CreatedOn

Property Value
DateTimeBehavior UserLocal
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
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime

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
Targets systemuser
Type Lookup

CreatedOnBehalfByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

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
MaxValue 100000000000
MinValue 0.000000000001
Precision 12
RequiredLevel None
Type Decimal

FormattedScheduledEnd

Added by: msft_ActivitiesInfra_Extensions Solution

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

FormattedScheduledStart

Added by: msft_ActivitiesInfra_Extensions Solution

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

InstanceTypeCode

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

InstanceTypeCode Choices/Options

Value Label Description
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

IsRegularActivity Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

IsUnsafe

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

ModifiedBy

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

ModifiedByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyyominame
MaxLength 100
RequiredLevel None
Type String

ModifiedFieldsMask

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

ModifiedOn

Property Value
DateTimeBehavior UserLocal
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
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

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
Targets systemuser
Type Lookup

ModifiedOnBehalfByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

OnHoldTime

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

OriginalStartDate

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

OwnerIdName

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

OwnerIdYomiName

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

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
Targets businessunit
Type Lookup

OwningBusinessUnitName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunitname
MaxLength 160
RequiredLevel None
Type String

OwningTeam

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

OwningUser

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

RegardingObjectIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName regardingobjectidname
MaxLength 400
RequiredLevel None
Type String

RegardingObjectIdYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName regardingobjectidyominame
MaxLength 400
RequiredLevel None
Type String

SafeDescription

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

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
Targets sla
Type Lookup

SLAInvokedIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName slainvokedidname
MaxLength 100
RequiredLevel None
Type String

SLAName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName slaname
MaxLength 100
RequiredLevel None
Type String

TransactionCurrencyIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName transactioncurrencyidname
MaxLength 100
RequiredLevel None
Type String

VersionNumber

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

One-To-Many Relationships

Listed by SchemaName.

appointment_PostFollows

Same as the appointment_PostFollows many-to-one relationship for the postfollow table/entity.

Property Value
ReferencingEntity postfollow
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName appointment_PostFollows
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Appointment_DuplicateMatchingRecord

Same as the Appointment_DuplicateMatchingRecord many-to-one relationship for the duplicaterecord table/entity.

Property Value
ReferencingEntity duplicaterecord
ReferencingAttribute duplicaterecordid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Appointment_DuplicateMatchingRecord
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Appointment_ProcessSessions

Same as the Appointment_ProcessSessions many-to-one relationship for the processsession table/entity.

Property Value
ReferencingEntity processsession
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Appointment_ProcessSessions
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 110
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

appointment_connections1

Same as the appointment_connections1 many-to-one relationship for the connection table/entity.

Property Value
ReferencingEntity connection
ReferencingAttribute record1id
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName appointment_connections1
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 100
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

appointment_activity_parties

Same as the appointment_activity_parties many-to-one relationship for the activityparty table/entity.

Property Value
ReferencingEntity activityparty
ReferencingAttribute activityid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName appointment_activity_parties
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Appointment_Annotation

Same as the Appointment_Annotation many-to-one relationship for the annotation table/entity.

Property Value
ReferencingEntity annotation
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Appointment_Annotation
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

appointment_connections2

Same as the appointment_connections2 many-to-one relationship for the connection table/entity.

Property Value
ReferencingEntity connection
ReferencingAttribute record2id
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName appointment_connections2
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order: 100
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Appointment_DuplicateBaseRecord

Same as the Appointment_DuplicateBaseRecord many-to-one relationship for the duplicaterecord table/entity.

Property Value
ReferencingEntity duplicaterecord
ReferencingAttribute baserecordid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Appointment_DuplicateBaseRecord
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

slakpiinstance_appointment

Same as the slakpiinstance_appointment many-to-one relationship for the slakpiinstance table/entity.

Property Value
ReferencingEntity slakpiinstance
ReferencingAttribute regarding
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName slakpiinstance_appointment
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Appointment_SyncErrors

Same as the Appointment_SyncErrors many-to-one relationship for the syncerror table/entity.

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Appointment_SyncErrors
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

Appointment_AsyncOperations

Same as the Appointment_AsyncOperations many-to-one relationship for the asyncoperation table/entity.

Property Value
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Appointment_AsyncOperations
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

appointment_actioncard

Same as the appointment_actioncard many-to-one relationship for the actioncard table/entity.

Property Value
ReferencingEntity actioncard
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName appointment_actioncard
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

appointment_principalobjectattributeaccess

Same as the appointment_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess table/entity.

Property Value
ReferencingEntity principalobjectattributeaccess
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName appointment_principalobjectattributeaccess
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

appointment_activity_mime_attachment

Same as the appointment_activity_mime_attachment many-to-one relationship for the activitymimeattachment table/entity.

Property Value
ReferencingEntity activitymimeattachment
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName appointment_activity_mime_attachment
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Appointment_QueueItem

Same as the Appointment_QueueItem many-to-one relationship for the queueitem table/entity.

Property Value
ReferencingEntity queueitem
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Appointment_QueueItem
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Appointment_BulkDeleteFailures

Same as the Appointment_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.

Property Value
ReferencingEntity bulkdeletefailure
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Appointment_BulkDeleteFailures
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

KnowledgeBaseRecord_Appointments

See the KnowledgeBaseRecord_Appointments one-to-many relationship for the knowledgebaserecord table/entity.

business_unit_appointment_activities

See the business_unit_appointment_activities one-to-many relationship for the businessunit table/entity.

lk_appointment_modifiedby

See the lk_appointment_modifiedby one-to-many relationship for the systemuser table/entity.

TransactionCurrency_Appointment

See the TransactionCurrency_Appointment one-to-many relationship for the transactioncurrency table/entity.

lk_appointment_modifiedonbehalfby

See the lk_appointment_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.

lk_appointment_createdby

See the lk_appointment_createdby one-to-many relationship for the systemuser table/entity.

sla_appointment

See the sla_appointment one-to-many relationship for the sla table/entity.

Contact_Appointments

See the Contact_Appointments one-to-many relationship for the contact table/entity.

lk_appointment_createdonbehalfby

See the lk_appointment_createdonbehalfby one-to-many relationship for the systemuser table/entity.

KnowledgeArticle_Appointments

See the KnowledgeArticle_Appointments one-to-many relationship for the knowledgearticle table/entity.

Account_Appointments

See the Account_Appointments one-to-many relationship for the account table/entity.

manualsla_appointment

See the manualsla_appointment one-to-many relationship for the sla table/entity.

team_appointment

See the team_appointment one-to-many relationship for the team table/entity.

user_appointment

See the user_appointment one-to-many relationship for the systemuser table/entity.

recurringappointmentmaster_appointment

See the recurringappointmentmaster_appointment one-to-many relationship for the recurringappointmentmaster table/entity.

processstage_appointments

See the processstage_appointments one-to-many relationship for the processstage table/entity.

activity_pointer_appointment

See the activity_pointer_appointment one-to-many relationship for the activitypointer table/entity.

adx_invitation_Appointments

Added by: Power Pages Runtime Core Solution

See the adx_invitation_Appointments one-to-many relationship for the adx_invitation table/entity.

mspp_adplacement_Appointments

Added by: Power Pages Apps Solution

See the mspp_adplacement_Appointments one-to-many relationship for the mspp_adplacement table/entity.

mspp_pollplacement_Appointments

Added by: Power Pages Apps Solution

See the mspp_pollplacement_Appointments one-to-many relationship for the mspp_pollplacement table/entity.

mspp_publishingstatetransitionrule_Appointments

Added by: Power Pages Apps Solution

See the mspp_publishingstatetransitionrule_Appointments one-to-many relationship for the mspp_publishingstatetransitionrule table/entity.

mspp_redirect_Appointments

Added by: Power Pages Apps Solution

See the mspp_redirect_Appointments one-to-many relationship for the mspp_redirect table/entity.

mspp_shortcut_Appointments

Added by: Power Pages Apps Solution

See the mspp_shortcut_Appointments one-to-many relationship for the mspp_shortcut table/entity.

mspp_website_Appointments

Added by: Power Pages Apps Solution

See the mspp_website_Appointments one-to-many relationship for the mspp_website table/entity.

See also

Dataverse table/entity reference
Web API Reference
appointment EntityType