v_DIM_MARKETINGSOURCECODEPART
The Marketing Source Code Part dimension contains information about source code parts used in marketing source codes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| MARKETINGSOURCECODEPARTDIMID | int | BBDW.[DIM_MARKETINGSOURCECODEPART].[MARKETINGSOURCECODEPARTDIMID] | |
| MARKETINGSOURCECODEPARTSYSTEMID | uniqueidentifier | BBDW.[DIM_MARKETINGSOURCECODEPART].[MARKETINGSOURCECODEPARTSYSTEMID] | |
| MARKETINGSOURCECODEDIMID | int | BBDW.[DIM_MARKETINGSOURCECODEPART].[MARKETINGSOURCECODEDIMID] | |
| PARTNAME | nvarchar(50) | BBDW.[DIM_MARKETINGSOURCECODEPART].[PARTNAME] | |
| PARTCODE | nvarchar(11) | yes | BBDW.[DIM_MARKETINGSOURCECODEPART].[PARTCODE] |
| DESCRIPTION | nvarchar(255) | yes | BBDW.[DIM_MARKETINGSOURCECODEPART].[DESCRIPTION] |
Definition
Copy
create view [BBDW].[v_DIM_MARKETINGSOURCECODEPART] as
select
[MARKETINGSOURCECODEPARTDIMID],
[MARKETINGSOURCECODEPARTSYSTEMID],
[MARKETINGSOURCECODEDIMID],
[PARTNAME],
[PARTCODE],
[DESCRIPTION]
from [BBDW].[DIM_MARKETINGSOURCECODEPART];