v_DIM_REVENUECHANNEL
The revenue channel dimension contains information about a revenue's channel.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| REVENUECHANNELDIMID | int | BBDW.[DIM_REVENUECHANNEL].[REVENUECHANNELDIMID] | |
| REVENUECHANNELSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_REVENUECHANNEL].[REVENUECHANNELSYSTEMID] |
| REVENUECHANNELDESCRIPTION | nvarchar(100) | yes | BBDW.[DIM_REVENUECHANNEL].[REVENUECHANNELDESCRIPTION] |
| REVENUECHANNELISACTIVE | bit | yes | BBDW.[DIM_REVENUECHANNEL].[REVENUECHANNELISACTIVE] |
Definition
Copy
create view [BBDW].[v_DIM_REVENUECHANNEL] as
select
[REVENUECHANNELDIMID],
[REVENUECHANNELSYSTEMID],
[REVENUECHANNELDESCRIPTION],
[REVENUECHANNELISACTIVE]
from BBDW.[DIM_REVENUECHANNEL]