v_DIM_DONOTMAILREASON
Contains the do not mail reason used for constituent addresses.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| DONOTMAILREASONDIMID | int | BBDW.[DIM_DONOTMAILREASON].[DONOTMAILREASONDIMID] | |
| DONOTMAILREASONSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_DONOTMAILREASON].[DONOTMAILREASONSYSTEMID] |
| DONOTMAILREASON | nvarchar(100) | yes | BBDW.[DIM_DONOTMAILREASON].[DONOTMAILREASON] |
| ISACTIVE | bit | yes | BBDW.[DIM_DONOTMAILREASON].[ISACTIVE] |
Definition
Copy
create view [BBDW].[v_DIM_DONOTMAILREASON] as
select
d.[DONOTMAILREASONDIMID],
d.[DONOTMAILREASONSYSTEMID],
d.[DONOTMAILREASON],
d.[ISACTIVE]
from BBDW.[DIM_DONOTMAILREASON] d