Opportunity Detail

This table shows the tables from which fields are retrieved for the dimension:

Table	Description
tcmcs005	Reasons
tcmcs122	Attention
tcmcs124	Sources
tdsmi003	Phases
tdsmi007	Opportunity Types
tdsmi008	Sales Processes
tdsmi110	Opportunities

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Attention	tdsmi110.catt
Attention Desc	tcmcs122.dsca
Closed	1 for status Canceled, Lost, or Won, else 0
Include in Forecast	tdsmi110.incf
Include in Forecast Filter	tdsmi110.incf
Include in Forecast Sort	tdsmi110.incf
Open	1 for status Preliminary, In Process, or Dead, else 0
Opportunity Status	tdsmi110.opst
Opportunity Status Filter	tdsmi110.opst
Opportunity Status Sort	tdsmi110.opst
Opportunity Type	tdsmi110.cptp
Opportunity Type Desc	tdsmi007.dsca
Phase	tdsmi110.cpha
Phase Desc	tdsmi003.dsca
Reason	tdsmi110.cdis
Reason Desc	tcmcs005.dsca
Sales Process	tdsmi110.sapr
Sales Process Desc	tdsmi008.dsca
Source	tdsmi110.csou
Source Desc	tcmcs124.dsca