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

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

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.
Show: