FACT_REVENUEOPPORTUNITY

Relates opportunities to revenue applications.

Primary Key

Primary Key	Field Type
REVENUEOPPORTUNITYFACTID	int

Fields

Field	Field Type	Null	Notes	Description
REVENUEOPPORTUNITYSYSTEMID	uniqueidentifier	yes		dbo.[REVENUEOPPORTUNITY].[ID]
REVENUEFACTID	int	yes		Reference key to the revenue fact, derived from dbo.[REVENUEOPPORTUNITY].[ID]
OPPORTUNITYFACTID	int	yes		Reference key to the opportunity fact, derived from dbo.[REVENUEOPPORTUNITY].[OPPORTUNITYID]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
ETLCONTROLID	int	yes		ID generated through the ETL process
SOURCEDIMID	int	yes		Source system used.
FINANCIALTRANSACTIONFACTID	int	yes		Reference key to financial transaction fact table, derived from [dbo].[FINANCIALTRANSACTION].[ID]
FINANCIALTRANSACTIONLINEITEMFACTID	int	yes		Reference key to financial transaction line item fact table, derived from [dbo].[FINANCIALTRANSACTIONLINEITEM].[ID]

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_FACT_REVENUEOPPORTUNITY_FINANCIALTRANSACTIONFACTID	FINANCIALTRANSACTIONFACTID
IX_FACT_REVENUEOPPORTUNITY_FINANCIALTRANSACTIONLINEITEMFACTID	FINANCIALTRANSACTIONLINEITEMFACTID
IX_FACT_REVENUEOPPORTUNITY_OPPORTUNITYFACTID	OPPORTUNITYFACTID
IX_FACT_REVENUEOPPORTUNITY_REVENUEFACTID	REVENUEFACTID
IX_FACT_REVENUEOPPORTUNITY_REVENUEOPPORTUNITYSYSTEMID	REVENUEOPPORTUNITYSYSTEMID
PK_FACT_REVENUEOPPORTUNITY	REVENUEOPPORTUNITYFACTID	yes	yes	yes