View Name:frcstitem_view
View Number:5159
Group:Sales Mgr
Description:Used by forms Forecast Items (9692) and Account (11650)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidfrcst_itmobjidForecast item internal record number 3 (UNIQUE)
idfrcst_itmid_numberForecast item ID 
namefrcst_itmnameName of the forecast target 
close_datefrcst_itmclose_dateClose date of the forecast target 
product_familyfrcst_itmfamilyProduct family of the forecast item 
product_linefrcst_itmlineProduct line of the forecast item 
amountfrcst_itmamountAmount of the forecast item 
probabilityfrcst_itmprobabilityProbability of the forecast item 
commentsfrcst_itmcommentsComments of the forecast item 
statusfrcst_itmstatusStatus of the forecast item 
terr_objidterritoryobjidTerritory internal record number 
terr_nameterritorynameName of the territory 
terr_nodeKeyterritorynode_keyNode Key of the territory 
opp_objidopportunityobjidOpportunity internal record number 
opp_nameopportunitynameName of the opportunity 
opp_idopportunityidId of the opportunity 
currency_objidcurrencyobjidCurrency internal record number 
currency_namecurrencynameName of the currency 
currency_ratecurrencyconv_rateRatio of the currency 
owner_objiduserobjidUser internal record number 
owner_nameuserlogin_nameName of the user 
terr_terr_idterritoryterr_idUser-specified ID number of the territory 
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
(frcst_itm).frcst_itm2territory(territory).terr2frcst_itm
(frcst_itm).originator2user(user).originator2frcst_itm
(frcst_itm).item2opportunityOUTER (opportunity).opp2frcst_itm
(frcst_itm).frcst_itm2currency(currency).curr2frcst_itm
My Recent Objects
frcstitem_view