Campaign

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

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the campaign.
ActualEnd	Datetime	False	Actual end date for the campaign.
ActualStart	Datetime	False	Actual start date for the campaign.
BudgetedCost	Double	False	Budgeted cost for the campaign.
BudgetedCost_Base	Double	True	Base currency equivalent of the budgeted cost for the campaign.
CampaignId	String	False	Unique identifier of the campaign.
CodeName	String	False	Unique code name that identifies the campaign.
CreatedBy_Id	String	True	Unique identifier of the user who created the campaign.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the campaign was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the campaign.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the campaign.
ExchangeRate	Double	True	Exchange rate for the currency associated with the campaign with respect to the base currency.
ExpectedResponse	Integer	False	Percent expected response for the campaign.
ExpectedRevenue	Double	False	Expected revenue from the campaign.
ExpectedRevenue_Base	Double	True	Base currency equivalent of the expected revenue from the campaign.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsTemplate	Boolean	False	Indication of whether the campaign is a template.
Message	String	False	Promotional message for the campaign.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the campaign.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the campaign was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the campaign.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the campaign.
Objective	String	False	Objective of the campaign.
OtherCost	Double	False	Other miscellaneous costs of the campaign.
OtherCost_Base	Double	True	Base currency equivalent of the other miscellaneous costs of the campaign.
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.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the campaign.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the campaign.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the campaign.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
PriceListId_Id	String	False	Unique identifier of the price list for the campaign.
PriceListId_LogicalName	String	False
PriceListId_Name	String	False
PromotionCodeName	String	False	Promotion code for the campaign.
ProposedEnd	Datetime	False	Proposed end date for the campaign.
ProposedStart	Datetime	False	Proposed start date for the campaign.
StateCode	String	True	Status of the campaign.
StatusCode	String	False	Reason for the status of the campaign.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TotalActualCost	Double	True	Total actual cost of the campaign.
TotalActualCost_Base	Double	True	Base currency equivalent of the total actual cost of the campaign.
TotalCampaignActivityActualCost	Double	True	Sum of all the actual costs of the campaign activities for this campaign.
TotalCampaignActivityActualCost_Base	Double	True	Base currency equivalent of the sum of all the actual costs of the campaign activities for this campaign.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the campaign.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
TypeCode	String	False	Type of the campaign.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

JDBC Driver for Microsoft Dynamics CRM

Campaign

Columns