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 Assembly |
|---|---|---|
| Assign | PATCH [org URI]/api/data/v9.0/appointments(activityid) Update ownerid property. |
AssignRequest |
| Book | Book Action | BookRequest |
| Create | POST [org URI]/api/data/v9.0/appointments See Create |
CreateRequest or Create |
| CreateException | CreateException Action | CreateExceptionRequest |
| Delete | DELETE [org URI]/api/data/v9.0/appointments(activityid) See Delete |
DeleteRequest or Delete |
| GrantAccess | GrantAccess Action | GrantAccessRequest |
| ImmediateBook | ImmediateBook Action | ImmediateBookRequest |
| ModifyAccess | ModifyAccess Action | ModifyAccessRequest |
| Reschedule | Reschedule Action | RescheduleRequest |
| Retrieve | GET [org URI]/api/data/v9.0/appointments(activityid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/appointments See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccess Function | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess Function | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccess Action | RevokeAccessRequest |
| SetState | PATCH [org URI]/api/data/v9.0/appointments(activityid) Update statecode and statuscode properties. |
SetStateRequest |
| Update | PATCH [org URI]/api/data/v9.0/appointments(activityid) See Update |
UpdateRequest or Update |
| Validate | Validate Action | ValidateRequest |
| ValidateSavedQuery | ValidateSavedQuery Action | ValidateSavedQueryRequest |
| ValidateUnpublished | ValidateUnpublished Action | 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
- ActivityId
- ActualDurationMinutes
- ActualEnd
- ActualStart
- AttachmentErrors
- Category
- Description
- GlobalObjectId
- ImportSequenceNumber
- IsAllDayEvent
- IsBilled
- IsDraft
- IsMapiPrivate
- IsWorkflowCreated
- LastOnHoldTime
- Location
- OptionalAttendees
- Organizer
- OutlookOwnerApptId
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- PriorityCode
- ProcessId
- RegardingObjectId
- RegardingObjectTypeCode
- requiredattendees
- ScheduledDurationMinutes
- ScheduledEnd
- ScheduledStart
- SLAId
- SortDate
- StageId
- StateCode
- StatusCode
- Subcategory
- Subject
- SubscriptionId
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- TraversedPath
- UTCConversionTimeZoneCode
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: False
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: False
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: False
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: False
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: False
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 |
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,contact,knowledgearticle,knowledgebaserecord |
| 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
- AttachmentCount
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ExchangeRate
- InstanceTypeCode
- IsRegularActivity
- IsUnsafe
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedFieldsMask
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OnHoldTime
- OriginalStartDate
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- RegardingObjectIdName
- RegardingObjectIdYomiName
- SafeDescription
- SeriesId
- SLAInvokedId
- SLAInvokedIdName
- SLAName
- TransactionCurrencyIdName
- VersionNumber
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 |
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: False
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 | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Targets | businessunit |
| Type | Lookup |
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 | |
| 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
- Appointment_DuplicateMatchingRecord
- Appointment_ProcessSessions
- appointment_connections1
- appointment_activity_parties
- Appointment_Annotation
- appointment_connections2
- Appointment_DuplicateBaseRecord
- slakpiinstance_appointment
- Appointment_SyncErrors
- Appointment_AsyncOperations
- appointment_actioncard
- appointment_principalobjectattributeaccess
- appointment_activity_mime_attachment
- Appointment_QueueItem
- Appointment_BulkDeleteFailures
appointment_PostFollows
Same as postfollow table appointment_PostFollows Many-To-One relationship.
| 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 duplicaterecord table Appointment_DuplicateMatchingRecord Many-To-One relationship.
| 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 processsession table Appointment_ProcessSessions Many-To-One relationship.
| 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 connection table appointment_connections1 Many-To-One relationship.
| 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 activityparty table appointment_activity_parties Many-To-One relationship.
| 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 annotation table Appointment_Annotation Many-To-One relationship.
| 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 connection table appointment_connections2 Many-To-One relationship.
| 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 duplicaterecord table Appointment_DuplicateBaseRecord Many-To-One relationship.
| 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 slakpiinstance table slakpiinstance_appointment Many-To-One relationship.
| 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 syncerror table Appointment_SyncErrors Many-To-One relationship.
| 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 asyncoperation table Appointment_AsyncOperations Many-To-One relationship.
| 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 actioncard table appointment_actioncard Many-To-One relationship.
| 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 principalobjectattributeaccess table appointment_principalobjectattributeaccess Many-To-One relationship.
| 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 activitymimeattachment table appointment_activity_mime_attachment Many-To-One relationship.
| 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 queueitem table Appointment_QueueItem Many-To-One relationship.
| 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 bulkdeletefailure table Appointment_BulkDeleteFailures Many-To-One relationship.
| 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
- business_unit_appointment_activities
- lk_appointment_modifiedby
- TransactionCurrency_Appointment
- lk_appointment_modifiedonbehalfby
- lk_appointment_createdby
- sla_appointment
- Contact_Appointments
- lk_appointment_createdonbehalfby
- KnowledgeArticle_Appointments
- Account_Appointments
- manualsla_appointment
- team_appointment
- user_appointment
- recurringappointmentmaster_appointment
- processstage_appointments
- activity_pointer_appointment
KnowledgeBaseRecord_Appointments
See knowledgebaserecord Table KnowledgeBaseRecord_Appointments One-To-Many relationship.
business_unit_appointment_activities
See businessunit Table business_unit_appointment_activities One-To-Many relationship.
lk_appointment_modifiedby
See systemuser Table lk_appointment_modifiedby One-To-Many relationship.
TransactionCurrency_Appointment
See transactioncurrency Table TransactionCurrency_Appointment One-To-Many relationship.
lk_appointment_modifiedonbehalfby
See systemuser Table lk_appointment_modifiedonbehalfby One-To-Many relationship.
lk_appointment_createdby
See systemuser Table lk_appointment_createdby One-To-Many relationship.
sla_appointment
See sla Table sla_appointment One-To-Many relationship.
Contact_Appointments
See contact Table Contact_Appointments One-To-Many relationship.
lk_appointment_createdonbehalfby
See systemuser Table lk_appointment_createdonbehalfby One-To-Many relationship.
KnowledgeArticle_Appointments
See knowledgearticle Table KnowledgeArticle_Appointments One-To-Many relationship.
Account_Appointments
See account Table Account_Appointments One-To-Many relationship.
manualsla_appointment
See sla Table manualsla_appointment One-To-Many relationship.
team_appointment
See team Table team_appointment One-To-Many relationship.
user_appointment
See systemuser Table user_appointment One-To-Many relationship.
recurringappointmentmaster_appointment
See recurringappointmentmaster Table recurringappointmentmaster_appointment One-To-Many relationship.
processstage_appointments
See processstage Table processstage_appointments One-To-Many relationship.
activity_pointer_appointment
See activitypointer Table activity_pointer_appointment One-To-Many relationship.
See also
About the table reference
Web API Reference
appointment EntityType