v_FACT_REVENUEOPPORTUNITY

Relates opportunities to revenue applications.

Fields

Field	Field Type	Null	Description
REVENUEOPPORTUNITYFACTID	int		BBDW.[FACT_REVENUEOPPORTUNITY].[REVENUEOPPORTUNITYFACTID]
REVENUEOPPORTUNITYSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_REVENUEOPPORTUNITY].[REVENUEOPPORTUNITYSYSTEMID]
REVENUEFACTID	int	yes	BBDW.[FACT_REVENUEOPPORTUNITY].[REVENUEFACTID]
OPPORTUNITYFACTID	int	yes	BBDW.[FACT_REVENUEOPPORTUNITY].[OPPORTUNITYFACTID]
FINANCIALTRANSACTIONFACTID	int	yes	BBDW.[FACT_REVENUEOPPORTUNITY].[FINANCIALTRANSACTIONFACTID]
FINANCIALTRANSACTIONLINEITEMFACTID	int	yes	BBDW.[FACT_REVENUEOPPORTUNITY].[FINANCIALTRANSACTIONLINEITEMFACTID]

Definition

Copy


create view [BBDW].[v_FACT_REVENUEOPPORTUNITY] as 
  select 
    [REVENUEOPPORTUNITYFACTID],
    [REVENUEOPPORTUNITYSYSTEMID],
    [REVENUEFACTID],
    [OPPORTUNITYFACTID],
    [FINANCIALTRANSACTIONFACTID],
    [FINANCIALTRANSACTIONLINEITEMFACTID]
  from [BBDW].[FACT_REVENUEOPPORTUNITY];