v_FACT_OPPORTUNITYCAMPAIGN
Relates campaigns to opportunities.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| OPPORTUNITYCAMPAIGNFACTID | int | BBDW.[FACT_OPPORTUNITYCAMPAIGN].[OPPORTUNITYCAMPAIGNFACTID] | |
| OPPORTUNITYCAMPAIGNSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_OPPORTUNITYCAMPAIGN].[OPPORTUNITYCAMPAIGNSYSTEMID] |
| OPPORTUNITYFACTID | int | yes | BBDW.[FACT_OPPORTUNITYCAMPAIGN].[OPPORTUNITYFACTID] |
| CAMPAIGNDIMID | int | yes | BBDW.[FACT_OPPORTUNITYCAMPAIGN].[CAMPAIGNDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_OPPORTUNITYCAMPAIGN] as
select
[OPPORTUNITYCAMPAIGNFACTID],
[OPPORTUNITYCAMPAIGNSYSTEMID],
[OPPORTUNITYFACTID],
[CAMPAIGNDIMID]
from [BBDW].[FACT_OPPORTUNITYCAMPAIGN];