CampaignActivity table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

Task performed, or to be performed, by a user for planning or running a campaign.

Added by: Marketing Solution

Messages

Message	Web API Operation	SDK class or method
AddItemCampaign		AddItemCampaignRequest
AddItemCampaignActivity		AddItemCampaignActivityRequest
Assign	PATCH /campaignactivities(activityid) Update ownerid property.	AssignRequest
Create	POST /campaignactivities See Create	CreateRequest or Create
CreateMultiple	CreateMultiple	CreateMultipleRequest
Delete	DELETE /campaignactivities(activityid) See Delete	DeleteRequest or Delete
DistributeCampaignActivity		DistributeCampaignActivityRequest
GrantAccess	GrantAccess	GrantAccessRequest
ModifyAccess	ModifyAccess	ModifyAccessRequest
RemoveItemCampaign		RemoveItemCampaignRequest
RemoveItemCampaignActivity		RemoveItemCampaignActivityRequest
Retrieve	GET /campaignactivities(activityid) See Retrieve	RetrieveRequest or Retrieve
RetrieveMultiple	GET /campaignactivities See Query Data	RetrieveMultipleRequest or RetrieveMultiple
RetrievePrincipalAccess	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess	RevokeAccess	RevokeAccessRequest
SetState	PATCH /campaignactivities(activityid) Update statecode and statuscode properties.	SetStateRequest
Update	PATCH /campaignactivities(activityid) See Update	UpdateRequest or Update
UpdateMultiple	UpdateMultiple	UpdateMultipleRequest

Properties

Property	Value
CollectionSchemaName	CampaignActivities
DisplayCollectionName	Campaign Activities
DisplayName	Campaign Activity
EntitySetName	campaignactivities
IsBPFEntity	False
LogicalCollectionName	campaignactivities
LogicalName	campaignactivity
OwnershipType	UserOwned
PrimaryIdAttribute	activityid
PrimaryNameAttribute	subject
SchemaName	CampaignActivity

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• ActivityAdditionalParams
• ActivityId
• ActualCost
• ActualDurationMinutes
• ActualEnd
• ActualStart
• BCC
• BudgetedCost
• Category
• CC
• ChannelTypeCode
• Community
• Customers
• DeliveryPriorityCode
• Description
• DoNotSendOnOptOut
• ExchangeItemId
• ExchangeWebLink
• ExcludeIfContactedInXDays
• from
• IgnoreInactiveListMembers
• ImportSequenceNumber
• IsBilled
• IsMapiPrivate
• IsWorkflowCreated
• LastOnHoldTime
• LeftVoiceMail
• OptionalAttendees
• Organizer
• OverriddenCreatedOn
• OwnerId
• OwnerIdType
• Partners
• PriorityCode
• ProcessId
• RegardingObjectId
• RegardingObjectTypeCode
• RequiredAttendees
• Resources
• ScheduledEnd
• ScheduledStart
• ServiceId
• SLAId
• SortDate
• StageId
• StateCode
• StatusCode
• Subcategory
• Subject
• TimeZoneRuleVersionNumber
• To
• TraversedPath
• TypeCode
• UTCConversionTimeZoneCode

ActivityAdditionalParams

Property	Value
Description	Additional information provided by the external application as JSON. For internal use only.
DisplayName	Activity Additional Parameters
Format	TextArea
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	activityadditionalparams
MaxLength	8192
RequiredLevel	None
Type	Memo

ActivityId

Property	Value
Description	Unique identifier of the campaign activity.
DisplayName	Campaign Activity
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	activityid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ActualCost

Property	Value
Description	Type the actual cost of the campaign activity. The value entered is rolled up to the related campaign in the total cost calculations.
DisplayName	Actual Cost
IsValidForForm	True
IsValidForRead	True
LogicalName	actualcost
MaxValue	1000000000000
MinValue	0
Precision	2
PrecisionSource	2
RequiredLevel	None
Type	Money

ActualDurationMinutes

Property	Value
Description	Shows the value selected in the Duration field on the campaign activity. The duration is used to report the time spent on the activity.
DisplayName	Actual Duration
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	actualdurationminutes
MaxValue	2147483647
MinValue	0
RequiredLevel	None
Type	Integer

ActualEnd

Property	Value
DateTimeBehavior	UserLocal
Description	Enter the date when the campaign activity was actually completed.
DisplayName	Actual End
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	actualend
RequiredLevel	None
Type	DateTime

ActualStart

Property	Value
DateTimeBehavior	UserLocal
Description	Enter the actual start date and time for the campaign activity to determine if the campaign activity started on the scheduled time.
DisplayName	Actual Start
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	actualstart
RequiredLevel	None
Type	DateTime

BCC

Property	Value
Description	Blind Carbon-copy (bcc) recipients of the activity.
DisplayName	BCC
IsValidForForm	True
IsValidForRead	True
LogicalName	bcc
RequiredLevel	None
Targets	account,contact,systemuser
Type	PartyList

BudgetedCost

Property	Value
Description	Type the allocated budget of the campaign activity for estimated versus actual cost reporting.
DisplayName	Budget Allocated
IsValidForForm	True
IsValidForRead	True
LogicalName	budgetedcost
MaxValue	1000000000000
MinValue	0
Precision	2
PrecisionSource	2
RequiredLevel	None
Type	Money

Category

Property	Value
Description	Type a category to identify the campaign activity type, such as new business development or customer retention, to tie the campaign activity to a business group or function.
DisplayName	Category
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	category
MaxLength	250
RequiredLevel	None
Type	String

CC

Property	Value
Description	Carbon-copy (cc) recipients of the activity.
DisplayName	CC
IsValidForForm	True
IsValidForRead	True
LogicalName	cc
RequiredLevel	None
Targets	account,contact,systemuser
Type	PartyList

ChannelTypeCode

Property	Value
Description	Select how communications for this activity will be sent, such as phone, letter, fax, or email.
DisplayName	Channel
IsValidForForm	True
IsValidForRead	True
LogicalName	channeltypecode
RequiredLevel	None
Type	Picklist

ChannelTypeCode Choices/Options

Value	Label	Description
1	Phone
2	Appointment
3	Letter
4	Letter via Mail Merge(deprecated)
5	Fax
6	Fax via Mail Merge(deprecated)
7	Email
8	Email via Mail Merge(deprecated)
9	Other

Community

Property	Value
Description	Shows how contact about the social activity originated, such as from Twitter or Facebook. This field is read-only.
DisplayName	Social Channel
IsValidForForm	False
IsValidForRead	True
LogicalName	community
RequiredLevel	None
Type	Picklist

Community Choices/Options

Value	Label	Description
0	Other	Other default
1	Facebook	Facebook item.
2	Twitter	Twitter.
3	Line
4	Wechat
5	Cortana
6	Direct Line
7	Microsoft Teams
8	Direct Line Speech
9	Email
10	GroupMe
11	Kik
12	Telegram
13	Skype
14	Slack
15	WhatsApp
16	Apple Messages For Business
17	Google's Business Messages

Customers

Property	Value
Description	Customer with which the activity is associated.
DisplayName	Customers
IsValidForForm	True
IsValidForRead	True
LogicalName	customers
RequiredLevel	None
Targets	account,contact
Type	PartyList

DeliveryPriorityCode

Property	Value
Description	Priority of delivery of the activity to the email server.
DisplayName	Delivery Priority
IsValidForForm	True
IsValidForRead	True
IsValidForUpdate	False
LogicalName	deliveryprioritycode
RequiredLevel	None
Type	Picklist

DeliveryPriorityCode Choices/Options

Value	Label	Description
0	Low
1	Normal
2	High

Description

Property	Value
Description	Type additional information to describe the campaign activity, such as key talking points, objectives, or details about the target audience.
DisplayName	Description
Format	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	description
MaxLength	2000
RequiredLevel	None
Type	Memo

DoNotSendOnOptOut

Property	Value
Description	Select whether to override the opt-out settings on leads, contacts, and accounts for the members of the target marketing lists of the campaign activity. If No is selected, marketing materials will be sent to members who have opted out.
DisplayName	Exclude Members Who Opt Out
IsValidForForm	True
IsValidForRead	True
LogicalName	donotsendonoptout
RequiredLevel	None
Type	Boolean

DoNotSendOnOptOut Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 1

ExchangeItemId

Property	Value
Description	The message id of activity which is returned from Exchange Server.
DisplayName	Exchange Item ID
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	exchangeitemid
MaxLength	200
RequiredLevel	None
Type	String

ExchangeWebLink

Property	Value
Description	Shows the web link of Activity of type email.
DisplayName	Exchange WebLink
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	exchangeweblink
MaxLength	1250
RequiredLevel	None
Type	String

ExcludeIfContactedInXDays

Property	Value
Description	Limits the frequency (in days) of marketing activities directed at any contact. Contacts that have been contacted more recently than this will be excluded from new campaign activity distributions. Enter a value of zero to disable the limit.
DisplayName	No. of Days
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	excludeifcontactedinxdays
MaxValue	9999
MinValue	0
RequiredLevel	None
Type	Integer

from

Property	Value
Description	For system use only.
DisplayName	From
IsValidForForm	True
IsValidForRead	True
LogicalName	from
RequiredLevel	None
Targets	account,contact,systemuser
Type	PartyList

IgnoreInactiveListMembers

Property	Value
Description	Select whether inactive marketing list members will be excluded from the campaign activity distribution.
DisplayName	Ignore Inactive Marketing List Members
IsValidForForm	True
IsValidForRead	True
LogicalName	ignoreinactivelistmembers
RequiredLevel	None
Type	Boolean

IgnoreInactiveListMembers Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 1

ImportSequenceNumber

Property	Value
Description	Sequence number of the import that created this record.
DisplayName	Import Sequence Number
Format	None
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	importsequencenumber
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

IsBilled

Property	Value
Description	Information regarding whether the campaign activity was billed as part of resolving a case.
DisplayName	Is Billed
IsValidForForm	False
IsValidForRead	True
LogicalName	isbilled
RequiredLevel	None
Type	Boolean

IsBilled Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

IsMapiPrivate

Property	Value
Description	For internal use only.
DisplayName	Is Private
IsValidForForm	False
IsValidForRead	True
LogicalName	ismapiprivate
RequiredLevel	None
Type	Boolean

IsMapiPrivate Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

IsWorkflowCreated

Property	Value
Description	Information about whether the campaign activity is created by a workflow rule.
DisplayName	Is Workflow Created
IsValidForForm	False
IsValidForRead	True
LogicalName	isworkflowcreated
RequiredLevel	None
Type	Boolean

IsWorkflowCreated Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

LastOnHoldTime

Property	Value
DateTimeBehavior	UserLocal
Description	Contains the date and time stamp of the last on hold time.
DisplayName	Last On Hold Time
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	lastonholdtime
RequiredLevel	None
Type	DateTime

LeftVoiceMail

Property	Value
Description	Left the voice mail
DisplayName	Left Voice Mail
IsValidForForm	True
IsValidForRead	True
LogicalName	leftvoicemail
RequiredLevel	None
Type	Boolean

LeftVoiceMail Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

OptionalAttendees

Property	Value
Description	List of optional attendees for the activity.
DisplayName	Optional Attendees
IsValidForForm	True
IsValidForRead	True
LogicalName	optionalattendees
RequiredLevel	None
Targets	account,contact,systemuser
Type	PartyList

Organizer

Property	Value
Description	Person who organized the activity.
DisplayName	Organizer
IsValidForForm	True
IsValidForRead	True
LogicalName	organizer
RequiredLevel	None
Targets	systemuser
Type	PartyList

OverriddenCreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time that the record was migrated.
DisplayName	Record Created On
Format	DateOnly
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	overriddencreatedon
RequiredLevel	None
Type	DateTime

OwnerId

Property	Value
Description	Unique identifier of the user or team who owns the activity.
DisplayName	Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	ownerid
RequiredLevel	SystemRequired
Targets	systemuser,team
Type	Owner

OwnerIdType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridtype
RequiredLevel	SystemRequired
Type	EntityName

Partners

Property	Value
Description	Outsource vendor with which activity is associated.
DisplayName	Outsource Vendors
IsValidForForm	True
IsValidForRead	True
LogicalName	partners
RequiredLevel	None
Targets	account,contact
Type	PartyList

PriorityCode

Property	Value
Description	Select the priority so that preferred customers or critical issues are handled quickly.
DisplayName	Priority
IsValidForForm	True
IsValidForRead	True
LogicalName	prioritycode
RequiredLevel	None
Type	Picklist

PriorityCode Choices/Options

Value	Label	Description
0	Low
1	Normal
2	High

ProcessId

Property	Value
Description	Unique identifier of the Process.
DisplayName	Process
IsValidForForm	False
IsValidForRead	True
LogicalName	processid
RequiredLevel	None
Type	Uniqueidentifier

RegardingObjectId

Property	Value
Description	Choose the parent campaign so that the campaign activity costs reflect in the correct campaign for reporting.
DisplayName	Parent Campaign
IsValidForForm	True
IsValidForRead	True
IsValidForUpdate	False
LogicalName	regardingobjectid
RequiredLevel	ApplicationRequired
Targets	campaign
Type	Lookup

RegardingObjectTypeCode

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	regardingobjecttypecode
RequiredLevel	None
Type	EntityName

RequiredAttendees

Property	Value
Description	List of required attendees for the activity.
DisplayName	Required Attendees
IsValidForForm	True
IsValidForRead	True
LogicalName	requiredattendees
RequiredLevel	None
Targets	account,contact,systemuser
Type	PartyList

Resources

Property	Value
Description	Users or facility/equipment that are required for the activity.
DisplayName	Resources
IsValidForForm	True
IsValidForRead	True
LogicalName	resources
RequiredLevel	None
Targets	systemuser
Type	PartyList

ScheduledEnd

Property	Value
DateTimeBehavior	UserLocal
Description	Enter the expected due date and time for the activity to be completed to provide details about the timing of the campaign activity.
DisplayName	Scheduled End
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	scheduledend
RequiredLevel	None
Type	DateTime

ScheduledStart

Property	Value
DateTimeBehavior	UserLocal
Description	Enter the expected start date and time for the activity to provide details about timing of the campaign activity.
DisplayName	Scheduled Start
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	scheduledstart
RequiredLevel	None
Type	DateTime

ServiceId

Added by: Marketing Service Solution

Property	Value
Description	Unique identifier of the associated service.
DisplayName	Service
IsValidForForm	False
IsValidForRead	True
LogicalName	serviceid
RequiredLevel	None
Targets	service
Type	Lookup

SLAId

Property	Value
Description	Choose the service level agreement (SLA) that you want to apply to the case record.
DisplayName	SLA
IsValidForForm	True
IsValidForRead	True
LogicalName	slaid
RequiredLevel	None
Targets	sla
Type	Lookup

SortDate

Property	Value
DateTimeBehavior	UserLocal
Description	Shows the date and time by which the activities are sorted.
DisplayName	Sort Date
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	sortdate
RequiredLevel	None
Type	DateTime

StageId

Property	Value
Description	Unique identifier of the Stage.
DisplayName	(Deprecated) Process Stage
IsValidForForm	False
IsValidForRead	True
LogicalName	stageid
RequiredLevel	None
Type	Uniqueidentifier

StateCode

Property	Value
Description	Shows whether the campaign activity is open, completed, or canceled. Completed and canceled campaign activities are read-only and can't be edited.
DisplayName	Status
IsValidForCreate	False
IsValidForForm	True
IsValidForRead	True
LogicalName	statecode
RequiredLevel	SystemRequired
Type	State

StateCode Choices/Options

Value	Label	DefaultStatus	InvariantName
0	Open	1	Open
1	Closed	2	Closed
2	Canceled	3	Canceled

StatusCode

Property	Value
Description	Select the campaign activity's status.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	None
Type	Status

StatusCode Choices/Options

Value	Label	State
0	In Progress	0
1	Proposed	0
2	Closed	1
3	Canceled	2
4	Pending	0
5	System Aborted	0
6	Completed	0

Subcategory

Property	Value
Description	Type a subcategory to identify the campaign activity type and relate the activity to a specific product, sales region, business group, or other function.
DisplayName	Sub-Category
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	subcategory
MaxLength	250
RequiredLevel	None
Type	String

Subject

Property	Value
Description	Type a short description about the objective or primary topic of the campaign activity.
DisplayName	Subject
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	subject
MaxLength	200
RequiredLevel	ApplicationRequired
Type	String

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleversionnumber
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

To

Property	Value
Description	Person who is the receiver of the activity.
DisplayName	To
IsValidForForm	True
IsValidForRead	True
LogicalName	to
RequiredLevel	None
Targets	account,contact,systemuser
Type	PartyList

TraversedPath

Property	Value
Description	For internal use only.
DisplayName	(Deprecated) Traversed Path
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	traversedpath
MaxLength	1250
RequiredLevel	None
Type	String

TypeCode

Property	Value
Description	Select the type of campaign activity to indicate the purpose of the activity.
DisplayName	Type
IsValidForForm	True
IsValidForRead	True
LogicalName	typecode
RequiredLevel	None
Type	Picklist

TypeCode Choices/Options

Value	Label	Description
1	Research
2	Content Preparation
3	Target Marketing List Creation
4	Lead Qualification
5	Content Distribution
6	Direct Initial Contact
7	Direct Follow-Up Contact
8	Reminder Distribution

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	utcconversiontimezonecode
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

• ActivityTypeCode
• ActualCost_Base
• BudgetedCost_Base
• CreatedBy
• CreatedByName
• CreatedByYomiName
• CreatedOn
• CreatedOnBehalfBy
• CreatedOnBehalfByName
• CreatedOnBehalfByYomiName
• DeliveryLastAttemptedOn
• ExchangeRate
• InstanceTypeCode
• IsRegularActivity
• ModifiedBy
• ModifiedByName
• ModifiedByYomiName
• ModifiedOn
• ModifiedOnBehalfBy
• ModifiedOnBehalfByName
• ModifiedOnBehalfByYomiName
• OnHoldTime
• OwnerIdName
• OwnerIdYomiName
• OwningBusinessUnit
• OwningBusinessUnitName
• OwningTeam
• OwningUser
• PostponeActivityProcessingUntil
• RegardingObjectIdName
• RegardingObjectIdYomiName
• ScheduledDurationMinutes
• SenderMailboxId
• SenderMailboxIdName
• SentOn
• SeriesId
• SLAInvokedId
• SLAInvokedIdName
• SLAName
• TransactionCurrencyId
• TransactionCurrencyIdName
• VersionNumber

ActivityTypeCode

Property	Value
Description	Type of activity.
DisplayName	Activity Type
IsValidForForm	False
IsValidForRead	True
LogicalName	activitytypecode
RequiredLevel	SystemRequired
Type	EntityName

ActualCost_Base

Property	Value
Description	Value of the Actual Cost in base currency.
DisplayName	Actual Cost (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	actualcost_base
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2
RequiredLevel	None
Type	Money

BudgetedCost_Base

Property	Value
Description	Value of the Budget Allocated in base currency.
DisplayName	Budget Allocated (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	budgetedcost_base
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2
RequiredLevel	None
Type	Money

CreatedBy

Property	Value
Description	Unique identifier of the user who created the activity.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyyominame
MaxLength	100
RequiredLevel	None
Type	String

CreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the activity was created.
DisplayName	Date Created
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the activitypointer.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedOnBehalfByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedOnBehalfByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

DeliveryLastAttemptedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the delivery of the activity was last attempted.
DisplayName	Date Delivery Last Attempted
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	deliverylastattemptedon
RequiredLevel	None
Type	DateTime

ExchangeRate

Property	Value
Description	Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
DisplayName	Exchange Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	exchangerate
MaxValue	100000000000
MinValue	0.000000000001
Precision	12
RequiredLevel	None
Type	Decimal

InstanceTypeCode

Property	Value
Description	Type of instance of a recurring series.
DisplayName	Recurring Instance Type
IsValidForForm	False
IsValidForRead	True
LogicalName	instancetypecode
RequiredLevel	SystemRequired
Type	Picklist

InstanceTypeCode Choices/Options

Value	Label	Description
0	Not Recurring
1	Recurring Master
2	Recurring Instance
3	Recurring Exception
4	Recurring Future Exception

IsRegularActivity

Property	Value
Description	Information regarding whether the activity is a regular activity type or event type.
DisplayName	Is Regular Activity
IsValidForForm	False
IsValidForRead	True
LogicalName	isregularactivity
RequiredLevel	SystemRequired
Type	Boolean

IsRegularActivity Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

ModifiedBy

Property	Value
Description	Unique identifier of user who last modified the activity.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyyominame
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when activity was last modified.
DisplayName	Last Updated
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who last modified the activitypointer.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedOnBehalfByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOnBehalfByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

OnHoldTime

Property	Value
Description	Shows how long, in minutes, that the record was on hold.
DisplayName	On Hold Time (Minutes)
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	onholdtime
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

OwnerIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

OwnerIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridyominame
MaxLength	100
RequiredLevel	SystemRequired
Type	String

OwningBusinessUnit

Property	Value
Description	Unique identifier of the business unit that owns the activity.
DisplayName	Owning Business Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	owningbusinessunit
RequiredLevel	None
Targets	businessunit
Type	Lookup

OwningBusinessUnitName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owningbusinessunitname
MaxLength	160
RequiredLevel	None
Type	String

OwningTeam

Property	Value
Description	Unique identifier of the team that owns the activity.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	owningteam
RequiredLevel	None
Targets	team
Type	Lookup

OwningUser

Property	Value
Description	Unique identifier of the user that owns the activity.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	owninguser
RequiredLevel	None
Targets	systemuser
Type	Lookup

PostponeActivityProcessingUntil

Property	Value
DateTimeBehavior	UserLocal
Description	For internal use only.
DisplayName	Delay activity processing until
Format	DateAndTime
IsValidForForm	False
IsValidForRead	True
LogicalName	postponeactivityprocessinguntil
RequiredLevel	None
Type	DateTime

RegardingObjectIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	regardingobjectidname
MaxLength	100
RequiredLevel	None
Type	String

RegardingObjectIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	regardingobjectidyominame
MaxLength	100
RequiredLevel	None
Type	String

ScheduledDurationMinutes

Property	Value
Description	Scheduled duration, specified in minutes, of the campaign activity.
DisplayName	Scheduled Duration
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	scheduleddurationminutes
MaxValue	2147483647
MinValue	0
RequiredLevel	None
Type	Integer

SenderMailboxId

Property	Value
Description	Unique identifier of the mailbox associated with the sender of the email message.
DisplayName	Sender's Mailbox
IsValidForForm	False
IsValidForRead	True
LogicalName	sendermailboxid
RequiredLevel	None
Targets	mailbox
Type	Lookup

SenderMailboxIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	sendermailboxidname
MaxLength	100
RequiredLevel	None
Type	String

SentOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the activity was sent.
DisplayName	Date Sent
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	senton
RequiredLevel	None
Type	DateTime

SeriesId

Property	Value
Description	Uniqueidentifier specifying the id of recurring series of an instance.
DisplayName	Series Id
IsValidForForm	False
IsValidForRead	True
LogicalName	seriesid
RequiredLevel	None
Type	Uniqueidentifier

SLAInvokedId

Property	Value
Description	Last SLA that was applied to this case. This field is for internal use only.
DisplayName	Last SLA applied
IsValidForForm	False
IsValidForRead	True
LogicalName	slainvokedid
RequiredLevel	None
Targets	sla
Type	Lookup

SLAInvokedIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	slainvokedidname
MaxLength	100
RequiredLevel	None
Type	String

SLAName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	slaname
MaxLength	100
RequiredLevel	None
Type	String

TransactionCurrencyId

Property	Value
Description	Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName	Currency
IsValidForForm	True
IsValidForRead	True
LogicalName	transactioncurrencyid
RequiredLevel	None
Targets	transactioncurrency
Type	Lookup

TransactionCurrencyIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	transactioncurrencyidname
MaxLength	100
RequiredLevel	None
Type	String

VersionNumber

Property	Value
Description	Version number of the activity.
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	versionnumber
MaxValue	9223372036854775807
MinValue	-9223372036854775808
RequiredLevel	None
Type	BigInt

One-To-Many Relationships

Listed by SchemaName.

• campaignactivity_CampaignResponses
• CampaignActivity_BulkOperations
• CampaignActivity_logs
• campaignactivity_OpportunityCloses
• campaignactivity_OrderCloses
• campaignactivity_QuoteCloses

campaignactivity_CampaignResponses

Same as the campaignactivity_CampaignResponses many-to-one relationship for the campaignresponse table/entity.

Property	Value
ReferencingEntity	campaignresponse
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	campaignactivity_CampaignResponses
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade

CampaignActivity_BulkOperations

Same as the CampaignActivity_BulkOperations many-to-one relationship for the bulkoperation table/entity.

Property	Value
ReferencingEntity	bulkoperation
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	False
ReferencedEntityNavigationPropertyName	CampaignActivity_BulkOperations
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

CampaignActivity_logs

Added by: Marketing Patch Solution

Same as the CampaignActivity_logs many-to-one relationship for the bulkoperationlog table/entity.

Property	Value
ReferencingEntity	bulkoperationlog
ReferencingAttribute	campaignactivityid
IsHierarchical	False
IsCustomizable	False
ReferencedEntityNavigationPropertyName	CampaignActivity_logs
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

campaignactivity_OpportunityCloses

Added by: Sales Solution

Same as the campaignactivity_OpportunityCloses many-to-one relationship for the opportunityclose table/entity.

Property	Value
ReferencingEntity	opportunityclose
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	campaignactivity_OpportunityCloses
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade

campaignactivity_OrderCloses

Added by: Sales Solution

Same as the campaignactivity_OrderCloses many-to-one relationship for the orderclose table/entity.

Property	Value
ReferencingEntity	orderclose
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	campaignactivity_OrderCloses
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade

campaignactivity_QuoteCloses

Added by: Sales Solution

Same as the campaignactivity_QuoteCloses many-to-one relationship for the quoteclose table/entity.

Property	Value
ReferencingEntity	quoteclose
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	campaignactivity_QuoteCloses
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

Campaign_CampaignActivities

See the Campaign_CampaignActivities one-to-many relationship for the campaign table/entity.

Many-To-Many Relationships

Relationship details provided where the CampaignActivity table is the first table in the relationship. Listed by SchemaName.

• campaignactivitylist_association
• CampaignActivity_Accounts
• CampaignActivity_Contacts
• CampaignActivity_Leads
• campaignactivitysalesliterature_association

campaignactivitylist_association

IntersectEntityName: campaignactivityitem

Table 1

Property	Value
IntersectAttribute	campaignactivityid
IsCustomizable	False
LogicalName	campaignactivity
NavigationPropertyName	campaignactivitylist_association
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:

Table 2

Property	Value
LogicalName	list
IntersectAttribute	itemid
NavigationPropertyName	campaignactivitylist_association
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:

CampaignActivity_Accounts

IntersectEntityName: bulkoperationlog

Table 1

Property	Value
IntersectAttribute	campaignactivityid
IsCustomizable	False
LogicalName	campaignactivity
NavigationPropertyName	CampaignActivity_Accounts
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:

Table 2

Property	Value
LogicalName	account
IntersectAttribute	regardingobjectid
NavigationPropertyName	CampaignActivity_Logs_Accounts
AssociatedMenuConfiguration	Behavior: UseCollectionName Group: Details Label: Order: 11

CampaignActivity_Contacts

IntersectEntityName: bulkoperationlog

Table 1

Property	Value
IntersectAttribute	campaignactivityid
IsCustomizable	False
LogicalName	campaignactivity
NavigationPropertyName	CampaignActivity_Contacts
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:

Table 2

Property	Value
LogicalName	contact
IntersectAttribute	regardingobjectid
NavigationPropertyName	CampaignActivity_Logs_Contacts
AssociatedMenuConfiguration	Behavior: UseCollectionName Group: Details Label: Order: 12

CampaignActivity_Leads

IntersectEntityName: bulkoperationlog

Table 1

Property	Value
IntersectAttribute	campaignactivityid
IsCustomizable	False
LogicalName	campaignactivity
NavigationPropertyName	CampaignActivity_Leads
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:

Table 2

Property	Value
LogicalName	lead
IntersectAttribute	regardingobjectid
NavigationPropertyName	CampaignActivity_Logs_Leads
AssociatedMenuConfiguration	Behavior: UseCollectionName Group: Details Label: Order: 13

campaignactivitysalesliterature_association

IntersectEntityName: campaignactivityitem

Table 1

Property	Value
IntersectAttribute	campaignactivityid
IsCustomizable	False
LogicalName	campaignactivity
NavigationPropertyName	campaignactivitysalesliterature_association
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:

Table 2

Property	Value
LogicalName	salesliterature
IntersectAttribute	itemid
NavigationPropertyName	campaignactivitysalesliterature_association
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:

Related information

Dataverse table/entity reference
Web API Reference