CampaignResponse

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

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the campaign response.
ActivityId	String	False	Unique identifier of the campaign response.
ActivityTypeCode	String	True	Type of activity.
ActualDurationMinutes	Integer	False	Actual duration of the campaign response in minutes.
ActualEnd	Datetime	False	Actual end time of the campaign response.
ActualStart	Datetime	False	Actual start time of the campaign response.
Category	String	False	Category of the campaign response.
ChannelTypeCode	String	False	Channel type code of the campaign response.
CompanyName	String	False	Name of the company with which the campaign response is associated.
CreatedBy_Id	String	True	Unique identifier of the user who created the campaign response.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the campaign response was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the campaignresponse.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Customer_Ids	String	False	Customer with which the campaign response is associated.
Customer_LogicalNames	String	False
Customer_Names	String	False
Description	String	False	Description of the campaign response.
EMailAddress	String	False	email address of the customer from whom this response is received.
ExchangeRate	Double	True	Exchange rate for the currency associated with the campaignresponse with respect to the base currency.
Fax	String	False	Fax number of the customer from whom this response is received.
FirstName	String	False	First name of the customer from whom this response is collected.
from_Ids	String	False	For internal use only.
from_LogicalNames	String	False
from_Names	String	False
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsBilled	Boolean	False	Specifies whether the campaign response 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	Specifies whether the campaign response is created by a workflow rule.
LastName	String	False	Last name of the customer from whom this response is collected.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the campaign response.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the campaign response was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the campaignresponse.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OriginatingActivityId_Id	String	False	Unique identifier of the originating activity for the campaign response.
OriginatingActivityId_LogicalName	String	False
OriginatingActivityId_Name	String	False
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 response.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier for the business unit that owns the campaign response.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the campaign response.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the campaign response.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
Partner_Ids	String	False	Unique identifier of the partner for the campaign response.
Partner_LogicalNames	String	False
Partner_Names	String	False
PriorityCode	String	False	Priority of the campaign response.
PromotionCodeName	String	False	Promote code name associated with this response.
ReceivedOn	Datetime	False	Date on which this campaign response was received.
RegardingObjectId_Id	String	False	Unique identifier of the object with which the campaign response is associated.
RegardingObjectId_LogicalName	String	False
RegardingObjectId_Name	String	False
ResponseCode	String	False	Code of the campaign response.
ScheduledDurationMinutes	Integer	True	Scheduled duration of the campaign response in minutes.
ScheduledEnd	Datetime	False	Scheduled end time of the campaign response.
ScheduledStart	Datetime	False	Scheduled start time of the campaign response.
ServiceId_Id	String	False	Unique identifier for the associated service.
ServiceId_LogicalName	String	False
ServiceId_Name	String	False
StateCode	String	True	Status of the campaign response.
StatusCode	String	False	Reason for the status for the campaign response.
Subcategory	String	False	Subcategory of the campaign response.
Subject	String	False	Subject associated with the campaign response.
Telephone	String	False	Telephone number of customer from whom this response is received.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the campaignresponse.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.
YomiCompanyName	String	False	Pronunciation of the company name, written in phonetic hiragana or katakana characters, with which the campaign response activity is associated.
YomiFirstName	String	False	Pronunciation of the first name of the customer, written in phonetic hiragana or katakana characters, from whom this response is collected.
YomiLastName	String	False	Pronunciation of the last name of the customer, written in phonetic hiragana or katakana characters, from whom this response is collected.

JDBC Driver for Microsoft Dynamics CRM

CampaignResponse

Columns