V_QUERY_BBDW_REVENUEOPPORTUNITY
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| REVENUEOPPORTUNITYFACTID | int | ||
| REVENUEOPPORTUNITYSYSTEMID | uniqueidentifier | yes | |
| OPPORTUNITYFACTID | int | yes | |
| FINANCIALTRANSACTIONFACTID | int | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_REVENUEOPPORTUNITY] as
select
o.[REVENUEOPPORTUNITYFACTID],
o.[REVENUEOPPORTUNITYSYSTEMID],
o.[OPPORTUNITYFACTID],
o.[FINANCIALTRANSACTIONFACTID]
from BBDW.[FACT_REVENUEOPPORTUNITY] o