View Name:sfa_pipeline
View Number:5363
Group:Sales Mgr
Description:Displays Opportunity financials. Used by form ___
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidopportunityobjidOpportunity internal record number 3 (UNIQUE)
currency_objidcurrencyobjidCurrency internal record number 
owner_objiduserobjidUser internal record number 
owner_nameuserlogin_nameUser login name 
stagegbst_lsttitleStatus/Stage of opportunity 
opp_cls_amtopportunityfrcst_cls_amountForecasted close amount of the opportunity 
opp_cls_dtopportunityfrcst_cls_dtForecasted close date of the opportunity 
opp_nameopportunitynameName given to the opportunity 
opp_cls_prbopportunityfrcst_cls_prbForcasted close probability of the opportunity 
opp_idopportunityidOpportunity ID number 
currency_namecurrencynameName of the currency the opportunity is denominated in 
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 
lst_objidgbst_lstobjidStatus/Stage gbst_lst internal record number 
lst_elm_objidgbst_elmobjidStatus/Stage gbst_elm internal record number 

Joins:

Join FromJoin To
(opportunity).opp2currency(currency).curr2opportunity
(opportunity).opp_owner2user(user).owner2opportunity
(opportunity).opp_sts2gbst_elm(gbst_elm).status2opportunity
(gbst_elm).gbst_elm2gbst_lst(gbst_lst).gbst_lst2gbst_elm
My Recent Objects
sfa_pipeline