title | description | ms.date | ms.service | ms.topic | ms.assetid | author | ms.author | search.audienceType | |
---|---|---|---|---|---|---|---|---|---|
Appointment table/entity reference (Microsoft Dataverse) | Microsoft Docs |
Includes schema information and supported messages for the Appointment table/entity. |
06/04/2024 |
powerapps |
reference |
3948cc48-07c8-7f60-0608-71c37158ad7c |
phecke |
pehecke |
|
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Commitment representing a time interval with start/end times and duration.
Message | Web API Operation | SDK class or method |
---|---|---|
Assign | PATCH /appointments(activityid) Update ownerid property. |
xref:Microsoft.Crm.Sdk.Messages.AssignRequest |
Book | <xref:Microsoft.Dynamics.CRM.Book?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.BookRequest |
Create | POST /appointments See Create |
xref:Microsoft.Xrm.Sdk.Messages.CreateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Create* |
CreateException | <xref:Microsoft.Dynamics.CRM.CreateException?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.CreateExceptionRequest |
Delete | DELETE /appointments(activityid) See Delete |
xref:Microsoft.Xrm.Sdk.Messages.DeleteRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Delete* |
GrantAccess | <xref:Microsoft.Dynamics.CRM.GrantAccess?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.GrantAccessRequest |
ImmediateBook | <xref:Microsoft.Dynamics.CRM.ImmediateBook?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.ImmediateBookRequest |
ModifyAccess | <xref:Microsoft.Dynamics.CRM.ModifyAccess?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.ModifyAccessRequest |
Reschedule | <xref:Microsoft.Dynamics.CRM.Reschedule?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.RescheduleRequest |
Retrieve | GET /appointments(activityid) See Retrieve |
xref:Microsoft.Xrm.Sdk.Messages.RetrieveRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Retrieve* |
RetrieveMultiple | GET /appointments See Query Data |
xref:Microsoft.Xrm.Sdk.Messages.RetrieveMultipleRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.RetrieveMultiple* |
RetrievePrincipalAccess | <xref:Microsoft.Dynamics.CRM.RetrievePrincipalAccess?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | <xref:Microsoft.Dynamics.CRM.RetrieveSharedPrincipalsAndAccess?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | <xref:Microsoft.Dynamics.CRM.RevokeAccess?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.RevokeAccessRequest |
SetState | PATCH /appointments(activityid) Update statecode and statuscode properties. |
xref:Microsoft.Crm.Sdk.Messages.SetStateRequest |
Update | PATCH /appointments(activityid) See Update |
xref:Microsoft.Xrm.Sdk.Messages.UpdateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Update* |
Validate | <xref:Microsoft.Dynamics.CRM.Validate?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.ValidateRequest |
ValidateSavedQuery | <xref:Microsoft.Dynamics.CRM.ValidateSavedQuery?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.ValidateSavedQueryRequest |
ValidateUnpublished | <xref:Microsoft.Dynamics.CRM.ValidateUnpublished?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.ValidateUnpublishedRequest |
Property | Value |
---|---|
CollectionSchemaName | Appointments |
DisplayCollectionName | Appointments |
DisplayName | Appointment |
EntitySetName | appointments |
IsBPFEntity | False |
LogicalCollectionName | appointments |
LogicalName | appointment |
OwnershipType | UserOwned |
PrimaryIdAttribute | activityid |
PrimaryNameAttribute | subject |
SchemaName | Appointment |
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
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 |
Property | Value |
---|---|
Description | Unique identifier of the appointment. |
DisplayName | Appointment |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | activityid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
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 |
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 |
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 |
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 |
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. |
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 |
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 |
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 |
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 |
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 |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
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 |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
Property | Value |
---|---|
Description | Information regarding whether the appointment is a draft. |
DisplayName | IsDraft |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | isdraft |
RequiredLevel | SystemRequired |
Type | Boolean |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Is Private |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | ismapiprivate |
RequiredLevel | None |
Type | Boolean |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
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 |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
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 |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
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 |
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 |
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 |
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 |
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 |
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 |
Value | Label | Description |
---|---|---|
1 | Teams Meeting |
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 |
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 |
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 |
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 |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
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 |
Value | Label | Description |
---|---|---|
0 | Low | |
1 | Normal | |
2 | High |
Property | Value |
---|---|
Description | Shows the ID of the process. |
DisplayName | Process |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | processid |
RequiredLevel | None |
Type | Uniqueidentifier |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | regardingobjecttypecode |
RequiredLevel | None |
Type | EntityName |
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 |
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 |
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 |
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 |
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 |
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 |
Property | Value |
---|---|
Description | Shows the ID of the stage. |
DisplayName | (Deprecated) Process Stage |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | stageid |
RequiredLevel | None |
Type | Uniqueidentifier |
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 |
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Open | 1 | Open |
1 | Completed | 3 | Completed |
2 | Canceled | 4 | Canceled |
3 | Scheduled | 5 | Scheduled |
Property | Value |
---|---|
Description | Select the appointment's status. |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
Value | Label | State |
---|---|---|
1 | Free | 0 |
2 | Tentative | 0 |
3 | Completed | 1 |
4 | Canceled | 2 |
5 | Busy | 3 |
6 | Out of Office | 3 |
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 |
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 |
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Subscription |
IsValidForForm | False |
IsValidForRead | False |
IsValidForUpdate | False |
LogicalName | subscriptionid |
RequiredLevel | None |
Type | Uniqueidentifier |
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 |
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 |
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 |
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 |
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
Property | Value |
---|---|
Description | Type of activity. |
DisplayName | Activity Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | activitytypecode |
RequiredLevel | SystemRequired |
Type | EntityName |
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 |
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
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 |
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 |
Property | Value |
---|---|
Description | Type of instance of a recurring series. |
DisplayName | Appointment Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | instancetypecode |
RequiredLevel | SystemRequired |
Type | Picklist |
Value | Label | Description |
---|---|---|
0 | Not Recurring | |
1 | Recurring Master | |
2 | Recurring Instance | |
3 | Recurring Exception | |
4 | Recurring Future Exception |
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 |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
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 |
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
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 |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunitname |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
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 |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | regardingobjectidname |
MaxLength | 400 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | regardingobjectidyominame |
MaxLength | 400 |
RequiredLevel | None |
Type | String |
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 |
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 |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | slainvokedidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | slaname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | transactioncurrencyidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
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
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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
See the KnowledgeBaseRecord_Appointments one-to-many relationship for the knowledgebaserecord table/entity.
See the business_unit_appointment_activities one-to-many relationship for the businessunit table/entity.
See the lk_appointment_modifiedby one-to-many relationship for the systemuser table/entity.
See the TransactionCurrency_Appointment one-to-many relationship for the transactioncurrency table/entity.
See the lk_appointment_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
See the lk_appointment_createdby one-to-many relationship for the systemuser table/entity.
See the sla_appointment one-to-many relationship for the sla table/entity.
See the Contact_Appointments one-to-many relationship for the contact table/entity.
See the lk_appointment_createdonbehalfby one-to-many relationship for the systemuser table/entity.
See the KnowledgeArticle_Appointments one-to-many relationship for the knowledgearticle table/entity.
See the Account_Appointments one-to-many relationship for the account table/entity.
See the manualsla_appointment one-to-many relationship for the sla table/entity.
See the team_appointment one-to-many relationship for the team table/entity.
See the user_appointment one-to-many relationship for the systemuser table/entity.
See the recurringappointmentmaster_appointment one-to-many relationship for the recurringappointmentmaster table/entity.
See the processstage_appointments one-to-many relationship for the processstage table/entity.
See the activity_pointer_appointment one-to-many relationship for the activitypointer table/entity.
Added by: Power Pages Runtime Core Solution
See the adx_invitation_Appointments one-to-many relationship for the adx_invitation table/entity.
Added by: Power Pages Apps Solution
See the mspp_adplacement_Appointments one-to-many relationship for the mspp_adplacement table/entity.
Added by: Power Pages Apps Solution
See the mspp_pollplacement_Appointments one-to-many relationship for the mspp_pollplacement table/entity.
Added by: Power Pages Apps Solution
See the mspp_publishingstatetransitionrule_Appointments one-to-many relationship for the mspp_publishingstatetransitionrule table/entity.
Added by: Power Pages Apps Solution
See the mspp_redirect_Appointments one-to-many relationship for the mspp_redirect table/entity.
Added by: Power Pages Apps Solution
See the mspp_shortcut_Appointments one-to-many relationship for the mspp_shortcut table/entity.
Added by: Power Pages Apps Solution
See the mspp_website_Appointments one-to-many relationship for the mspp_website table/entity.