v_FACT_ACCOUNTSYSTEMSITE
Contains information about sites associated with account systems.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ACCOUNTSYSTEMSITEFACTID | int | BBDW.[FACT_ACCOUNTSYSTEMSITE].[ACCOUNTSYSTEMSITEFACTID] | |
| ACCOUNTSYSTEMSITESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_ACCOUNTSYSTEMSITE].[ACCOUNTSYSTEMSITESYSTEMID] |
| SITEDIMID | int | yes | BBDW.[FACT_ACCOUNTSYSTEMSITE].[SITEDIMID] |
| ACCOUNTSYSTEMDIMID | int | yes | BBDW.[FACT_ACCOUNTSYSTEMSITE].[ACCOUNTSYSTEMDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_ACCOUNTSYSTEMSITE] as
select
a.[ACCOUNTSYSTEMSITEFACTID],
a.[ACCOUNTSYSTEMSITESYSTEMID],
a.[SITEDIMID],
a.[ACCOUNTSYSTEMDIMID]
from BBDW.[FACT_ACCOUNTSYSTEMSITE] a