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
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
- IsOnlineMeeting
- IsWorkflowCreated
- LastOnHoldTime
- Location
- OnlineMeetingChatId
- OnlineMeetingId
- OnlineMeetingJoinUrl
- OnlineMeetingType
- 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: 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
- AttachmentCount
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ExchangeRate
- FormattedScheduledEnd
- FormattedScheduledStart
- InstanceTypeCode
- IsRegularActivity
- IsUnsafe
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedFieldsMask
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OnHoldTime
- OriginalStartDate
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- 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 |
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 | |
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 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
- 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
- adx_invitation_Appointments
- mspp_adplacement_Appointments
- mspp_pollplacement_Appointments
- mspp_publishingstatetransitionrule_Appointments
- mspp_redirect_Appointments
- mspp_shortcut_Appointments
- mspp_website_Appointments
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
意見反映
https://aka.ms/ContentUserFeedback。
即將推出:我們會在 2024 年淘汰 GitHub 問題,並以全新的意見反應系統取代並作為內容意見反應的渠道。 如需更多資訊,請參閱:提交及檢視以下的意見反映: