V_QUERY_BBDW_OPPORTUNITY
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| OPPORTUNITYSYSTEMID | uniqueidentifier | yes | |
| OPPORTUNITYFACTID | int | ||
| PROSPECTPLANDIMID | int | yes | |
| OPPORTUNITYAMOUNT | money | yes | |
| ASKAMOUNT | money | yes | |
| ASKDATEDIMID | int | yes | |
| ASKDATE | datetime | yes | |
| OPPORTUNITYTYPE | nvarchar(100) | yes | |
| OPPORTUNITYLIKELIHOODTYPE | nvarchar(100) | yes | |
| EXPECTEDASKAMOUNT | money | yes | |
| EXPECTEDASKDATEDIMID | int | yes | |
| EXPECTEDASKDATE | datetime | yes | |
| RESPONSEDATEDIMID | int | yes | |
| RESPONSEDATE | datetime | yes | |
| OPPORTUNITYSTATUS | nvarchar(100) | yes | |
| CURRENCYSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_OPPORTUNITY] as
select
o.[OPPORTUNITYSYSTEMID],
o.[OPPORTUNITYFACTID],
o.[PROSPECTPLANDIMID],
o.[OPPORTUNITYAMOUNT],
o.[ASKAMOUNT],
o.[ASKDATEDIMID],
o.[ASKDATE],
o.[OPPORTUNITYTYPE],
o.[OPPORTUNITYLIKELIHOODTYPE],
o.[EXPECTEDASKAMOUNT],
o.[EXPECTEDASKDATEDIMID],
o.[EXPECTEDASKDATE],
o.[RESPONSEDATEDIMID],
o.[RESPONSEDATE],
o.[OPPORTUNITYSTATUS],
c.[CURRENCYSYSTEMID]
from BBDW.[FACT_OPPORTUNITY] o
outer apply BBDW.[DIM_CURRENCY] c
where c.[ISORGANIZATIONCURRENCY] = 1