v_DIM_LETTER

Stores information about letters

Fields

Field	Field Type	Null	Description
LETTERDIMID	int		BBDW.[DIM_LETTER].[LETTERDIMID]
LETTERSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_LETTER].[LETTERSYSTEMID]
LETTER	nvarchar(100)	yes	BBDW.[DIM_LETTER].[LETTER]
LETTERDESCRIPTION	nvarchar(255)	yes	BBDW.[DIM_LETTER].[LETTERDESCRIPTION]
INCLUDESRECEIPT	bit	yes	BBDW.[DIM_LETTER].[INCLUDESRECEIPT]
SITEDIMID	int	yes	BBDW.[DIM_LETTER].[SITEDIMID]
SITESYSTEMID	uniqueidentifier	yes	BBDW.[DIM_LETTER].[SITESYSTEMID]

Definition

Copy


create view [BBDW].[v_DIM_LETTER] as 
  select 
    [LETTERDIMID],
    [LETTERSYSTEMID],
    [LETTER],
    [LETTERDESCRIPTION],
    [INCLUDESRECEIPT],
    [SITEDIMID],
    [SITESYSTEMID]
  from [BBDW].[DIM_LETTER];