V_QUERY_BBDW_REVENUE_SITE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FINANCIALTRANSACTIONLINEITEMFACTID | int | yes | |
| SITESYSTEMID | uniqueidentifier | yes | |
| SITENAME | nvarchar(250) | yes | |
| SITEDESCRIPTION | nvarchar(500) | yes | |
| SHORTNAME | nvarchar(100) | yes | |
| ACRONYM | nvarchar(100) | yes | |
| SITETYPE | nvarchar(100) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_REVENUE_SITE] as
select
fs.[FINANCIALTRANSACTIONLINEITEMFACTID],
s.[SITESYSTEMID],
s.[SITENAME],
s.[SITEDESCRIPTION],
s.[SHORTNAME],
s.[ACRONYM],
s.[SITETYPE]
from bbdw.[FACT_FINANCIALTRANSACTIONLINEITEMSITE] fs
inner join bbdw.[DIM_SITE] s on fs.[SITEDIMID] = s.[SITEDIMID] and s.[SITEDIMID] <> 0