CampaignActivity table/entity reference

  • Article

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

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
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

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

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

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:

Dataverse table/entity reference
Web API Reference