v_DIM_ADDON
Contains information about membership program add-ons.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ADDONDIMID | int | BBDW.[DIM_ADDON].[ADDONDIMID] | |
| ADDONSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_ADDON].[ADDONSYSTEMID] |
| ADDONNAME | nvarchar(100) | yes | BBDW.[DIM_ADDON].[ADDONNAME] |
| ADDONTYPECODE | tinyint | yes | BBDW.[DIM_ADDON].[ADDONTYPECODE] |
| ADDONTYPE | nvarchar(50) | yes | BBDW.[DIM_ADDON].[ADDONTYPE] |
Definition
Copy
create view [BBDW].[v_DIM_ADDON] as
select
a.[ADDONDIMID],
a.[ADDONSYSTEMID],
a.[ADDONNAME],
a.[ADDONTYPECODE],
a.[ADDONTYPE]
from BBDW.[DIM_ADDON] a