Tableau Connector for Microsoft Dynamics CRM

Build 24.0.9060

RecurringAppointmentMaster

This is a table representing the RecurringAppointmentMaster entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the recurring appoint.

ActivityId String False

Unique identifier of the recurring appointment series.

ActivityTypeCode String True

Type of activity.

Category String False

Category of the recurring appointment series.

CreatedBy_Id String True

Unique identifier of the user who created the recurring appointment series.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the recurring appointment series was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the recurring appointment series.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

DayOfMonth Integer False

The day of the month on which the recurring appointment occurs.

DaysOfWeekMask Integer False

Bitmask that represents the days of the week on which the recurring appointment occurs.

DeletedExceptionsList String True

List of deleted instances of the recurring appointment series.

Description String False

Description of the recurring appointment series.

Duration Integer False

Duration of the recurring appointment series in minutes.

EffectiveEndDate Datetime False

Actual end date of the recurring appointment series based on the specified end date and recurrence pattern.

EffectiveStartDate Datetime False

Actual start date of the recurring appointment series based on the specified start date and recurrence pattern.

EndTime Datetime False

End time of the associated activity.

ExchangeRate Double True

Exchange rate between the currency associated with the recurring appointment series and the base currency.

ExpansionStateCode String True

State code to indicate whether the recurring appointment series is expanded fully or partially.

FirstDayOfWeek Integer False

First day of week for the recurrence pattern.

GlobalObjectId String False

Unique Outlook identifier to correlate recurring appointment series across Exchange mailboxes.

GroupId_Id String True

Unique identifier of the recurring appointment series for which the recurrence information was updated.

GroupId_LogicalName String True

GroupId_Name String True

ImportSequenceNumber Integer False

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

Instance String False

Specifies the recurring appointment series to occur on every Nth day of a month. Valid for monthly and yearly recurrence patterns only.

InstanceTypeCode String True

Type of instance of a recurring appointment series.

Interval Integer False

Number of units of a given recurrence type between occurrences.

IsAllDayEvent Boolean False

Indicates whether the recurring appointment series is an all day event.

IsBilled Boolean False

Indicates whether the recurring appointment series was billed as part of resolving a case.

IsNthMonthly Boolean False

Indicates whether the recurring appointment series should occur after every N months. Valid for monthly recurrence pattern only.

IsNthYearly Boolean False

Indicates whether the recurring appointment series should occur after every N years. Valid for yearly recurrence pattern only.

IsRegenerate Boolean False

For internal use only.

IsRegularActivity Boolean True

Indicates whether the activity is a regular activity type or event type.

IsWeekDayPattern Boolean False

Indicates whether the weekly recurrence pattern is a daily weekday pattern. Valid for weekly recurrence pattern only.

IsWorkflowCreated Boolean False

Indicates whether the recurring appointment series was created from a workflow rule.

LastExpandedInstanceDate Datetime True

Date of last expanded instance of a recurring appointment series.

Location String False

Location where the recurring appointment series will occur.

ModifiedBy_Id String True

Unique identifier of the user who last modified the recurring appointment series.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the recurring appointment series was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who modified the recurring appointment series.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

MonthOfYear String False

Indicates the month of the year for the recurrence pattern.

NextExpansionInstanceDate Datetime True

Date of the next expanded instance of a recurring appointment series.

Occurrences Integer False

Number of appointment occurrences in a recurring appointment series.

OptionalAttendees_Ids String False

List of optional attendees for the recurring appointment series.

OptionalAttendees_LogicalNames String False

OptionalAttendees_Names String False

Organizer_Ids String False

Person who organized the recurring appointment series.

Organizer_LogicalNames String False

Organizer_Names String False

OutlookOwnerApptId Integer False

Unique identifier of the Microsoft Office Outlook recurring appointment series 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 recurring appointment series.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the recurring appointment series.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the recurring appointment series.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the recurring appointment series.

OwningUser_LogicalName String True

OwningUser_Name String True

PatternEndDate Datetime False

End date of the recurrence range.

PatternEndType String False

End type of the recurrence range.

PatternStartDate Datetime False

Start date of the recurrence range.

PriorityCode String False

Priority of the recurring appointment series.

RecurrencePatternType String False

Type of recurrence pattern.

RegardingObjectId_Id String False

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

RegardingObjectId_LogicalName String False

RegardingObjectId_Name String False

RequiredAttendees_Ids String False

List of required attendees for the recurring appointment series.

RequiredAttendees_LogicalNames String False

RequiredAttendees_Names String False

RuleId_Id String True

Unique identifier of the recurrence rule that is associated with the recurring appointment series.

RuleId_LogicalName String True

RuleId_Name String True

ScheduledEnd Datetime True

Scheduled end time of the recurring appointment series.

ScheduledStart Datetime True

Scheduled start time of the recurring appointment series.

SeriesStatus Boolean False

Indicates whether the recurring appointment series is active or inactive.

ServiceId_Id String False

Unique identifier for an associated service.

ServiceId_LogicalName String False

ServiceId_Name String False

StartTime Datetime False

Start time of the recurring appointment series.

StateCode String False

Status of the recurring appointment series.

StatusCode String False

Reason for the status of the recurring appointment series.

Subcategory String False

Sub-category of the recurring appointment series.

Subject String False

Subject associated with the recurring appointment series.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the recurring appointment series.

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