SSIS Components for Microsoft Dynamics CRM

Build 24.0.9060

CampaignActivity

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the campaign activity.

ActivityId String False

Unique identifier of the campaign activity.

ActivityTypeCode String True

Type of activity.

ActualCost Double False

Actual cost of the campaign activity.

ActualCost_Base Double True

Base currency equivalent of the actual cost of the campaign activity.

ActualDurationMinutes Integer False

Actual duration of the activity in minutes.

ActualEnd Datetime False

Actual end time of the campaign activity.

ActualStart Datetime False

Actual start time of the campaign activity.

BudgetedCost Double False

Budgeted cost for the campaign activity.

BudgetedCost_Base Double True

Base currency equivalent of the budgeted cost for the campaign activity.

Category String False

Category of the campaign activity.

ChannelTypeCode String False

Channel type code for the campaign activity.

CreatedBy_Id String True

Unique identifier of the user who created the campaign activity.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the campaign activity was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the campaignactivity.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

Description String False

Description of the campaign activity.

DoNotSendOnOptOut Boolean False

Information about whether to send marketing material to list members that prohibit sending of marketing material.

ExchangeRate Double True

Exchange rate for the currency associated with the campaign activity with respect to the base currency.

ExcludeIfContactedInXDays Integer False

Ignore if the campaign ran in the last X days.

from_Ids String False

For internal use only.

from_LogicalNames String False

from_Names String False

IgnoreInactiveListMembers Boolean False

Information regarding whether to ignore inactive lists during propagation/execution.

ImportSequenceNumber Integer False

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

IsBilled Boolean False

Information regarding whether the campaign activity 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 about whether the campaign activity is created by a workflow rule.

ModifiedBy_Id String True

Unique identifier of the user who last modified the campaign activity.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the campaign activity was last modified.

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

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 campaign activity.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the campaign activity.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the campaign activity.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the campaign activity.

OwningUser_LogicalName String True

OwningUser_Name String True

Partners_Ids String False

Unique identifier of the partner of the campaign activity.

Partners_LogicalNames String False

Partners_Names String False

PriorityCode String False

Priority code for the campaign activity.

RegardingObjectId_Id String False

Unique identifier of the object with which the campaign activity is associated.

RegardingObjectId_LogicalName String False

RegardingObjectId_Name String False

ScheduledDurationMinutes Integer True

Scheduled duration, specified in minutes, of the campaign activity.

ScheduledEnd Datetime False

Scheduled end time of the campaign activity.

ScheduledStart Datetime False

Scheduled start time of the campaign activity.

ServiceId_Id String False

Unique identifier of the associated service.

ServiceId_LogicalName String False

ServiceId_Name String False

StateCode String True

Status of the campaign activity.

StatusCode String False

Reason for the status reason for the campaign activity.

Subcategory String False

Subcategory of the campaign activity.

Subject String False

Subject associated with the campaign activity.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String True

Unique identifier of the currency associated with the campaign activity.

TransactionCurrencyId_LogicalName String True

TransactionCurrencyId_Name String True

TypeCode String False

Type of the campaign activity.

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