View Name:sfa_camp_v
View Number:5345
Group:Sales Mgr
Description:Used by forms Sales Console (12000)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcampaignobjidCampaign internal record number 3 (UNIQUE)
owner_objiduserobjidUser internal record number 
price_objidprice_progobjidPrice_prog internal record number 
currency_objidcurrencyobjidCurrency internal record number 
namecampaignnameName of the campaign 
cam_typecampaigncam_typeType of the campaign 
statuscampaignstatusStatus of the campaign 
start_datecampaignstart_dateStarting date of the campaign 
end_datecampaignend_dateEnding date of the campaign 
audiencecampaignaudienceTarget audience of the campaign 
descriptioncampaigndescriptiondescription of the campaign 
productscampaignproductsProduct families addressed by the campaign 
objectivecampaignobjectiveWhat the campaign is intended to achieve 
costcampaigncostAmount spent on campaign 
revenue_goalcampaignrevenue_goalGoal in currency of revenue generated from the campaign 
budget_amtcampaignbudget_amtGoal in currency for the cost of the campaign 
opps_goalcampaignopps_goalGoal in number of opportunities generated from the campaign 
won_goalcampaignwon_goalGoal in number of deals won from the campaign 
currency_namecurrencynameCurrency in which campaign is denominated 
owner_nameuserlogin_nameLogin name of the owner of the campaign 
price_nameprice_prognamePrice program used for the campaign 
sub_scalecurrencysub_scaleGives the decimal scale of the sub unit in which the currency will be calculated: e.g., US dollar has a sub unit (cent) whose scale=2; Italian lira has no sub unit, its sub unit scale=0 

Joins:

Join FromJoin To
(campaign).campaign2currencyOUTER (currency).currency2campaign
(campaign).campaign2price_progOUTER (price_prog).price_prog2campaign
(campaign).cam_owner2user(user).curr_owner2campaign
My Recent Objects
sfa_camp_v