Tableau Connector for Microsoft Dynamics CRM

Build 24.0.9060

Appointment

Create, update, delete, and query Appointment entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the appointment.

ActivityId String False

Unique identifier of the appointment.

ActivityTypeCode String True

Type of activity.

ActualDurationMinutes Integer False

Actual duration of the appointment in minutes.

ActualEnd Datetime False

Actual end time of the appointment.

ActualStart Datetime False

Actual start time of the appointment.

Category String False

Category of the appointment.

CreatedBy_Id String True

Unique identifier of the user who created the appointment.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the appointment was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the appointment.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

Description String False

A description of the appointment.

ExchangeRate Double True

Exchange rate for the currency associated with the appointment with respect to the base currency.

GlobalObjectId String False

Unique Outlook identifier to correlate appointments across Exchange mailboxes.

ImportSequenceNumber Integer False

Unique identifier of the data import or data migration that created this record.

InstanceTypeCode String True

Type of instance of a recurring series.

IsAllDayEvent Boolean False

Information on whether the appointment is an all day event.

IsBilled Boolean False

Information regarding whether the appointment was billed as part of resolving a case.

IsRegularActivity Boolean True

Information regarding whether the activity is a regular activity type or event type.

IsWorkflowCreated Boolean False

Information regarding whether the appointment was created from a workflow rule.

Location String False

Location where the appointment is to occur.

ModifiedBy_Id String True

Unique identifier of the user who last modified the appointment.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedFieldsMask String True

For internal use only.

ModifiedOn Datetime True

Date and time when the appointment was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who last modified the appointment.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

OptionalAttendees_Ids String False

List of optional attendees for the appointment.

OptionalAttendees_LogicalNames String False

OptionalAttendees_Names String False

Organizer_Ids String False

Person who organized the appointment.

Organizer_LogicalNames String False

Organizer_Names String False

OriginalStartDate Datetime True

The original start date of the appointment.

OutlookOwnerApptId Integer False

Unique identifier of the Microsoft Office Outlook appointment owner that correlates to the PR_OWNER_APPT_ID MAPI property.

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

OwnerId_Id String False

Unique identifier of the user or team who owns the appointment.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the appointment.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the appointment.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the appointment.

OwningUser_LogicalName String True

OwningUser_Name String True

PriorityCode String False

Priority of the appointment.

RegardingObjectId_Id String False

Unique identifier of the object with which the appointment is associated.

RegardingObjectId_LogicalName String False

RegardingObjectId_Name String False

requiredattendees_Ids String False

List of required attendees for the appointment.

requiredattendees_LogicalNames String False

requiredattendees_Names String False

ScheduledDurationMinutes Integer False

Scheduled duration of the appointment, specified in minutes.

ScheduledEnd Datetime False

Scheduled end time of the appointment.

ScheduledStart Datetime False

Scheduled start time of the appointment.

SeriesId String True

Unique identifier specifying the Id of a recurring series of an instance.

ServiceId_Id String False

Unique identifier for an associated service.

ServiceId_LogicalName String False

ServiceId_Name String False

StateCode String True

Status of the appointment.

StatusCode String False

Reason for the status of the appointment.

Subcategory String False

Subcategory of the appointment.

Subject String False

Subject associated with the appointment.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the appointment.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UTCConversionTimeZoneCode Integer False

Time zone code that was in use when the record was created.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060