Table Name:opportunity
Table Number:5000
Group:Sales Mgr
Description:Contains information about a potential business transaction with a prospect or customer
Flags:CACHEOBJIDS 
Baseline/Custom:Baseline
select * from table_opportunity
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
arch_indLONGint   DIRECT, ALLOW_NULL When set to 1, indicates the object is ready for purge/archive  
comm_amtFLOATreal   CURRENCY Amount of the commission. Reserved; obsolete  
comm_pctFLOATreal    Commission percentage  
comm_statusLONGtinyint   DIRECT Status of the commission; i.e., 0=unpaid, 1=partial, 2=paid  
commissionDECIMALdecimal (19,4)   CURRENCY Commission amount for the opportunity. Reserved; future  
comp_psnCHARvarchar 40  How we rank in the opportunity as compared to our competitor. This is a user-defined pop up  
cust_needCHARvarchar 255  What the customer actually needs  
date_identCLK_TIMEdatetime    Date the opportunity was identified. Reserved; not used  
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
frcst_cls_amountDECIMALdecimal (19,4)   CURRENCY Forecasted close amount Search (9)
frcst_cls_cfdCHARvarchar 50  Forecast close confidence-the degree of confidence in the forecasts  
frcst_cls_cmtCHARvarchar 255  Forecast close comments  
frcst_cls_dtCLK_TIMEdatetime    Forecasted close date Search (9)
frcst_cls_prbFLOATreal    Forecasted close probability Search (9)
idCHARvarchar432  Opportunity ID number Search (19)
nameCHARvarchar280  Name given to the opportunity Search (25)
next_stepsCHARvarchar 255  What needs to happen next  
objectiveCHARvarchar 255  Sales objective for this opportunity Search (1)
objidLONGint3  DIRECT Internal record number Search (32)
proj_nameCHARvarchar 50  Customer's project name for the opportunity Search (1)
purch_dateCLK_TIMEdatetime    When the opportunity is expected to close Search (6)
quantityCHARvarchar 25  Statement of the quantities involved with the opportunity  
rtng_cmntCHARvarchar 255  Comments about the various ratings  
rtng_fldsLONGtinyint   DIRECT The field sales rating  
rtng_telemLONGtinyint   DIRECT The telemarketing rating  
rtng_telesLONGtinyint   DIRECT The telesales rating  
strengthsCHARvarchar 255  Company strengths within the opportunity  
update_stampCLK_TIMEdatetime46  ALLOW_NULL Date/time of last update to the opportunity Search (2)
weaknessesCHARvarchar 255  Company vulnerabilities within the opportunity  
win_resultLONGtinyint  0 DIRECT For closed opportunities, the win/loss result; i.e., 0=unknown/open, 1=won, 2=lost  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in ViewsSet NameType ID Stored inObjid Stored In
 Exclusive Set Relations
opp2act_entryOTMact_entryact_entry2opportunityRelated activity log entries       
opp2alertOTMalertalert2opportunityAlerts (flashes) on the opportunity       
opp2bus_opp_roleOTMbus_opp_roleopp_role2opportunityBusiness organization involved with the opportunity       
opp2caseOTMcasetask2opportunityReserved; future       
opp_cmit2commit_logOTMcommit_logopp_commit2opportunityCommitments for the opportunity. Reserved       
opp2con_opp_roleOTMcon_opp_rolecon_role2opportunityContact roles for the opportunity       
opp_state2conditionOTOPconditionopp_condition2opportunityThe condition of the opportunity   Search (5)   
opp_quote2contractOTMcontractcontr_quote2opportunityRelated contracts or quotes       
opp2currencyMTOcurrencycurr2opportunityCurrency in which the opportunity is denominated   Search (7)   
opp2cycle_stageMTOcycle_stagestage2opportunityStage of the sales cycle   Search (8)   
opp2doc_instOTMdoc_instdoc_inst2opportunityAttachments to the opportunity       
opp_email2email_logOTMemail_logopp_email2opportunityOpportunity for the email log entry       
opp2frcst_itmOTMfrcst_itmitem2opportunityForecast detail for the opportunity       
opp_sts2gbst_elmMTOgbst_elmstatus2opportunityStatus of the opportunity object   Search (6)   
opp2interactOTMinteractinteract2opportunityInteractions referencing the opportunity       
opp2lead_sourceMTOlead_sourcesource2opportunityRelated lead source   Search (4)   
opp2life_cycleMTOlife_cyclecycle2opportunityLife cycle to which the opportunity belongs   Search (2)   
opp2lit_ship_reqOTMlit_ship_reqlit_ship2opportunityRelated sales literature shipments       
opp_notes2notes_logOTMnotes_logopp_notes2opportunityReserved; not used       
opp2opp_analysisOTMopp_analysisanalysis2opportunityScript roles for the opportunity       
opp2opp_dataOTMopp_dataopp_data2opportunityAdditional information about the opportunity       
opp2opp_qstnOTMopp_qstnopp_qstn2opportunityRelated call script questions       
parent2opp_rol_itmOTMopp_rol_itmparent2opportunityRelated parent rollup items       
child2opp_rol_itmOTMopp_rol_itmchild2opportunityRelated child rollup items       
opp2opp_scr_roleOTMopp_scr_rolescr_role2opportunityScript roles for the opportunity. Reserved; obsolete       
opp2part_numMTMpart_numpart_num2opportunityRelated products. Reserved; obsolete. Replaced by relation bus_opp_role2mod_level  mtm_part_num4_
opportunity18		    
opp2per_opp_roleOTMper_opp_roleper_role2opportunityPersons involved with the opportunity       
opp_phone2phone_logOTMphone_logopp_phone2opportunityOpportunity phone logs       
opp_currq2queueMTOqueuequeue2opportunityQueue to which the opportunity has been dispatched   Search (2)   
opp_prevq2queueMTOqueueprevq2opportunityQueue to which the opportunity was previously dispatched       
opp2quick_quoteOTMquick_quoteq_quote2opportunityTasks for the opportunity       
opp2r_rqstOTMr_rqstr_rqst2opportunityRouting requests for the opportunity    route_for source_type source_lowid 
opp_rej_rsn2reject_msgOTMreject_msgreject_msg2opportunityReject messages for an opportunity that has been rejected       
opp2scr_runOTMscr_runscr_run2opportunityCall scripts initiated by the opportunity       
opp2status_chgOTMstatus_chgstatus_chg2opportunityStatus changes for the opportunity       
opp_task2taskOTMtasksm_task2opportunityTasks for the opportunity       
opp2territoryMTOterritoryterr2opportunityTerritory to which the opportunity is assigned   Search (3)   
opp2topicOTMtopictopic2opportunityOpportunity related to this topic    interaction_for focus_type focus_lowid 
opp_viewer2userMTMuserviewer2opportunityUsers who have viewed the opportunity  mtm_user97_
opportunity38		Search (1)   
opp_originator2userMTOuseroriginator2opportunityUser that created the opportunity       
opp_owner2userMTOuserowner2opportunityUser that currently owns the opportunity   Search (10)   
opp2user_touchOTMuser_touchuser_touch2opportunityLast user touches for the lead    touched_by source_type source_lowid 
opp2usr_opp_roleOTMusr_opp_roleusr_role2opportunityUsers involved with the opportunity       
opp_wip2wipbinMTOwipbinwipbin2opportunityWIPbin into which the opportunity has been accepted   Search (2)   
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
opp_indidUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
ind_namenamenonclustered located on PRIMARY
ind_opp_currq2queueopp_currq2queue, objidnonclustered, unique located on PRIMARY
ind_opp_owner2useropp_owner2user, opp_wip2wipbinnonclustered located on PRIMARY
ind_opp2lead_sourceopp2lead_sourcenonclustered located on PRIMARY
o2cs5000opp2cycle_stagenonclustered located on PRIMARY
o2t5000opp2territory, opp2life_cycle, opp2cycle_stagenonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
opp_indidnonclustered, unique located on PRIMARY
os2c5000opp_state2condition, opp_sts2gbst_elmnonclustered located on PRIMARY
Referenced in Views:
View IDView NameTables
4622fc_acct_opp_view bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
5039wipelm_opp condition, gbst_elm, opportunity, wipbin
5044queelm_opp condition, gbst_elm, opportunity, queue
5045opp_alst act_entry, gbst_elm, opportunity, user
5071cmp_lsc_opp campaign, gbst_lst, lead_source, opportunity, user
5072opp_stage gbst_lst, lead_source, opportunity, user
5073opp_view condition, cycle_stage, opportunity, user
5077task_con bus_org, condition, contact, gbst_elm, opportunity, task, user
5093busopprl_view bus_opp_role, bus_org, opportunity
5095con_opp_view con_opp_role, contact, currency, cycle_stage, opportunity, user
5103bus_opp_view bus_opp_role, bus_org, opportunity
5159frcstitem_view currency, frcst_itm, opportunity, territory, user
5167oppscr_v call_script, opp_scr_role, opportunity
5168oppanly_v bus_org, opp_analysis, opportunity
5189v_frcstitem currency, frcst_itm, opportunity, territory, user
5217ccc_rundsply bug, bus_org, campaign, case, contact, contr_itm, contract, demand_dtl, employee, lead_source, opportunity, probdesc, scr_run, site, site_part, subcase, task
5230oppempl_view cycle_stage, employee, opportunity, territory, user
5231taskempl_view employee, gbst_elm, opportunity, task, user
5341sfa_opp_v bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
5344sfa_frcst_v bus_org, currency, frcst_itm, opportunity, territory, user
5350sfa_opp_tm contact, employee, opportunity, user, usr_opp_role
5356sfa_opp_wk_v condition, gbst_elm, opportunity, queue, user, wipbin
5357sfa_opp_mto_v currency, cycle_stage, lead_source, life_cycle, opportunity, territory
5359sfa_tsk_mto_v bus_org, contact, lead, lit_req, opportunity, task
5363sfa_pipeline currency, gbst_elm, gbst_lst, opportunity, user
5446sfa_opp_seen opportunity, user
5478sales_quote_v bus_org, condition, contact, contract, currency, gbst_elm, opportunity, user
5480opp_part_view bus_opp_role, mod_level, opportunity, part_num
5486sfa_busopp_v bus_opp_role, bus_org, opportunity
5597iclient_opp_view condition, currency, cycle_stage, opportunity, user
5742opp_summary_v currency, cycle_stage, lead_source, life_cycle, opportunity, territory
5864call_center_interact case, contact, interact, interact_txt, opportunity, user
My Recent Objects
opportunity      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user