Appointment Entity Metadata
[Applies to: Microsoft Dynamics CRM 2011]
The following information is for the appointment entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is Appointment.
To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.
In This Topic
Entity Metadata
Privilege Metadata
Attribute Metadata
One-to-Many Relationships
Many-to-Many Relationships
Many-to-One Relationships
Entity Metadata
The following table shows the metadata for the appointment entity.
Entity metadata property | Value |
---|---|
OTC |
4201 |
EntityLogicalName |
appointment |
DisplayName |
Appointment |
DisplayCollectionName |
Appointments |
IsCustomizable |
True |
OwnershipType |
UserOwned |
AutoRouteToOwnerQueue |
False |
CanBeInManyToMany |
True |
CanBePrimaryEntityInRelationship |
True |
CanBeRelatedEntityInRelationship |
True |
CanCreateAttributes |
True |
CanCreateCharts |
True |
CanCreateForms |
False |
CanCreateViews |
True |
CanModifyAdditionalSettings |
True |
CanTriggerWorkflow |
True |
IsActivity |
True |
IsActivityParty |
False |
IsAuditEnabled |
False |
IsAvailableOffline |
True |
IsChildEntity |
False |
IsConnectionsEnabled |
canmodifyconnectionsettings |
IsCustomEntity |
False |
IsDocumentManagementEnabled |
False |
IsDuplicateDetectionEnabled |
True |
IsEnabledForCharts |
True |
IsImportable |
True |
IsIntersect |
False |
IsMailMergeEnabled |
False |
IsManaged |
True |
IsMappable |
True |
IsReadingPaneEnabled |
True |
IsRenameable |
True |
IsValidForAdvancedFind |
True |
IsValidForQueue |
True |
IsVisibleInMobile |
False |
PrimaryIdAttribute |
activityid |
PrimaryNameAttribute |
subject |
ReportViewName |
FilteredAppointment |
Description |
Commitment representing a time interval with start/end times and duration. |
Privilege Metadata
The following table shows the privilege metadata for the appointment entity.
PrivilegeName | Id | Type | CanBeBasic | CanBeDeep | CanBeGlobal | CanBeLocal |
---|---|---|---|---|---|---|
prvAppendActivity |
78777c10-09ab-4326-b4c8-cf5729702937 |
Append |
True |
True |
True |
True |
prvAppendToActivity |
6ec8e901-d770-44c0-8f12-d07425f638bd |
AppendTo |
True |
True |
True |
True |
prvAssignActivity |
8b99344e-ebbf-4f84-8438-e1e34d194de9 |
Assign |
True |
True |
True |
True |
prvCreateActivity |
091df793-fe5e-44d4-b4ca-7e3f580c4664 |
Create |
True |
True |
True |
True |
prvDeleteActivity |
bb4457f2-9b45-4482-a95a-7adef25f388a |
Delete |
True |
True |
True |
True |
prvReadActivity |
650c14fe-3521-45fe-a000-84138688e45d |
Read |
True |
True |
True |
True |
prvShareActivity |
b5f2ee06-d359-4495-bbda-312aae1c6b1e |
Share |
True |
True |
True |
True |
prvWriteActivity |
0dc8f72c-57d5-4b4d-8892-fe6aac0e4b81 |
Write |
True |
True |
True |
True |
Attribute Metadata
The following table shows the attribute metadata for the appointment entity.
LogicalName | SchemaName | Type | RequiredLevel | IsValidForCreate | IsValidForRead | IsValidForUpdate | CanBeSecuredForCreate | CanBeSecuredForRead | CanBeSecuredForUpdate | IsCustomizable | IsAuditEnabled | IsManaged | IsPrimaryId | IsPrimaryName | IsRenameable | IsSecured | IsValidForAdvancedFind | DisplayName | DeprecatedVersion | Description |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
activityid |
ActivityId |
Uniqueidentifier |
SystemRequired |
True |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
True |
False |
True |
Appointment |
Unique identifier of the appointment. |
|
activitytypecode |
ActivityTypeCode |
EntityName |
SystemRequired |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Activity Type |
Type of activity. |
|
actualdurationminutes |
ActualDurationMinutes |
Integer |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Actual Duration |
Actual duration of the appointment in minutes. |
|
actualend |
ActualEnd |
DateTime |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Actual End |
Actual end time of the appointment. |
|
actualstart |
ActualStart |
DateTime |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Actual Start |
Actual start time of the appointment. |
|
category |
Category |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Category |
Category of the appointment. |
|
createdby |
CreatedBy |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Created By |
Unique identifier of the user who created the appointment. |
|
createdon |
CreatedOn |
DateTime |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Created On |
Date and time when the appointment was created. |
|
createdonbehalfby |
CreatedOnBehalfBy |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Created By (Delegate) |
Unique identifier of the delegate user who created the appointment. |
|
description |
Description |
Memo |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Description |
A description of the appointment. |
|
exchangerate |
ExchangeRate |
Decimal |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Exchange Rate |
Exchange rate for the currency associated with the appointment with respect to the base currency. |
|
globalobjectid |
GlobalObjectId |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
False |
False |
False |
Outlook Appointment |
Unique Outlook identifier to correlate appointments across Exchange mailboxes. |
|
importsequencenumber |
ImportSequenceNumber |
Integer |
None |
True |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Import Sequence Number |
Unique identifier of the data import or data migration that created this record. |
|
instancetypecode |
InstanceTypeCode |
Picklist |
SystemRequired |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Appointment Type |
Type of instance of a recurring series. |
|
isalldayevent |
IsAllDayEvent |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
All Day Event |
Information on whether the appointment is an all day event. |
|
isbilled |
IsBilled |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Is Billed |
Information regarding whether the appointment was billed as part of resolving a case. |
|
isregularactivity |
IsRegularActivity |
Boolean |
SystemRequired |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Is Regular Activity |
Information regarding whether the activity is a regular activity type or event type. |
|
isworkflowcreated |
IsWorkflowCreated |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Is Workflow Created |
Information regarding whether the appointment was created from a workflow rule. |
|
location |
Location |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Location |
Location where the appointment is to occur. |
|
modifiedby |
ModifiedBy |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Modified By |
Unique identifier of the user who last modified the appointment. |
|
modifiedfieldsmask |
ModifiedFieldsMask |
Memo |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
False |
False |
False |
For internal use only. |
||
modifiedon |
ModifiedOn |
DateTime |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Modified On |
Date and time when the appointment was last modified. |
|
modifiedonbehalfby |
ModifiedOnBehalfBy |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Modified By (Delegate) |
Unique identifier of the delegate user who last modified the appointment. |
|
optionalattendees |
OptionalAttendees |
PartyList |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Optional Attendees |
List of optional attendees for the appointment. |
|
organizer |
Organizer |
PartyList |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Organizer |
Person who organized the appointment. |
|
originalstartdate |
OriginalStartDate |
DateTime |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
False |
False |
False |
Original Start Date |
The original start date of the appointment. |
|
outlookownerapptid |
OutlookOwnerApptId |
Integer |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
False |
False |
False |
Outlook Appointment Owner |
Unique identifier of the Microsoft Office Outlook appointment owner that correlates to the PR_OWNER_APPT_ID MAPI property. |
|
overriddencreatedon |
OverriddenCreatedOn |
DateTime |
None |
True |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Record Created On |
Date and time that the record was migrated. |
|
ownerid |
OwnerId |
Owner |
SystemRequired |
True |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Owner |
Unique identifier of the user or team who owns the appointment. |
|
owningbusinessunit |
OwningBusinessUnit |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
False |
False |
False |
Owning Business Unit |
Unique identifier of the business unit that owns the appointment. |
|
owningteam |
OwningTeam |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Owning Team |
Unique identifier of the team that owns the appointment. |
|
owninguser |
OwningUser |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Owning User |
Unique identifier of the user that owns the appointment. |
|
prioritycode |
PriorityCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Priority |
Priority of the appointment. |
|
regardingobjectid |
RegardingObjectId |
Lookup |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Regarding |
Unique identifier of the object with which the appointment is associated. |
|
requiredattendees |
requiredattendees |
PartyList |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Required Attendees |
List of required attendees for the appointment. |
|
scheduleddurationminutes |
ScheduledDurationMinutes |
Integer |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Duration |
Scheduled duration of the appointment, specified in minutes. |
|
scheduledend |
ScheduledEnd |
DateTime |
ApplicationRequired |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
End Time |
Scheduled end time of the appointment. |
|
scheduledstart |
ScheduledStart |
DateTime |
ApplicationRequired |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Start Time |
Scheduled start time of the appointment. |
|
seriesid |
SeriesId |
Uniqueidentifier |
None |
False |
True |
False |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Series Id |
Uniqueidentifier specifying the id of recurring series of an instance. |
|
serviceid |
ServiceId |
Lookup |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
False |
False |
False |
Service |
Unique identifier for an associated service. |
|
statecode |
StateCode |
State |
SystemRequired |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Status |
Status of the appointment. |
|
statuscode |
StatusCode |
Status |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Status Reason |
Reason for the status of the appointment. |
|
subcategory |
Subcategory |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Sub-Category |
Sub-category of the appointment. |
|
subject |
Subject |
String |
ApplicationRequired |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
True |
True |
False |
True |
Subject |
Subject associated with the appointment. |
|
subscriptionid |
SubscriptionId |
Uniqueidentifier |
None |
True |
False |
False |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Subscription |
For internal use only. |
|
timezoneruleversionnumber |
TimeZoneRuleVersionNumber |
Integer |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
False |
False |
False |
False |
False |
Time Zone Rule Version Number |
For internal use only. |
|
transactioncurrencyid |
TransactionCurrencyId |
Lookup |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Currency |
Unique identifier of the currency associated with the appointment. |
|
utcconversiontimezonecode |
UTCConversionTimeZoneCode |
Integer |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
False |
False |
False |
False |
False |
UTC Conversion Time Zone Code |
Time zone code that was in use when the record was created. |
|
versionnumber |
VersionNumber |
BigInt |
None |
False |
True |
False |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Version Number |
Version number of the appointment. |
One-to-Many Relationships
The following table shows the entities that are the referencing entity in a one-to-many relationship for the appointment entity.
Relationship schema name | Referencing entity |
---|---|
appointment_activity_parties |
activityparty |
Appointment_Annotation |
annotation |
Appointment_AsyncOperations |
asyncoperation |
Appointment_BulkDeleteFailures |
bulkdeletefailure |
appointment_campaignresponse |
campaignresponse |
appointment_connections1 |
connection |
appointment_connections2 |
connection |
Appointment_DuplicateMatchingRecord |
duplicaterecord |
Appointment_DuplicateBaseRecord |
duplicaterecord |
appointment_PostFollows |
postfollow |
appointment_PostRegardings |
postregarding |
appointment_PostRoles |
postrole |
appointment_principalobjectattributeaccess |
principalobjectattributeaccess |
Appointment_ProcessSessions |
processsession |
Appointment_QueueItem |
queueitem |
userentityinstancedata_appointment |
userentityinstancedata |
Many-to-Many Relationships
There are no default many-to-many relationships for the appointment entity.
Many-to-One Relationships
The following table shows the entities that are the referenced entity in a many-to-one relationship for the appointment entity.
Relationship schema name | Referenced entity |
---|---|
Account_Appointments |
account |
activity_pointer_appointment |
activitypointer |
BulkOperation_Appointment |
bulkoperation |
business_unit_appointment_activities |
businessunit |
Campaign_Appointments |
campaign |
CampaignActivity_Appointments |
campaignactivity |
Contact_Appointments |
contact |
Contract_Appointments |
contract |
Incident_Appointments |
incident |
Invoice_Appointments |
invoice |
Lead_Appointments |
lead |
msdyn_postalbum_Appointments |
msdyn_postalbum |
Opportunity_Appointments |
opportunity |
Quote_Appointments |
quote |
recurringappointmentmaster_appointment |
recurringappointmentmaster |
SalesOrder_Appointments |
salesorder |
service_appointments |
service |
lk_appointment_modifiedby |
systemuser |
lk_appointment_modifiedonbehalfby |
systemuser |
lk_appointment_createdby |
systemuser |
lk_appointment_createdonbehalfby |
systemuser |
user_appointment |
systemuser |
team_appointment |
team |
TransactionCurrency_Appointment |
transactioncurrency |
See Also
Reference
EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata
Concepts
Appointment Entity Messages and Methods
Appointment Entity OptionSet Attribute Metadata
Other Resources
Schedule and Appointment Entities
Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.