v_DIM_ADJUSTMENTREASON

Contains information about adjustment reasons.

Fields

Field	Field Type	Null	Description
ADJUSTMENTREASONDIMID	int		BBDW.[v_DIM_ADJUSTMENTREASON].[ADJUSTMENTREASONDIMID]
ADJUSTMENTREASONSYSTEMID	uniqueidentifier	yes	BBDW.[v_DIM_ADJUSTMENTREASON].[ADJUSTMENTREASONSYSTEMID]
ADJUSTMENTREASON	nvarchar(50)	yes	BBDW.[v_DIM_ADJUSTMENTREASON].[ADJUSTMENTREASON]
ADJUSTMENTREASONCODE	nvarchar(10)	yes	BBDW.[DIM_ADJUSTMENTREASON].[ADJUSTMENTREASONCODE]

Definition

Copy


      CREATE view [BBDW].[v_DIM_ADJUSTMENTREASON]
      as
          select [DIM_ADJUSTMENTREASON].[ADJUSTMENTREASONDIMID],
              [DIM_ADJUSTMENTREASON].[ADJUSTMENTREASONSYSTEMID],
              [DIM_ADJUSTMENTREASON].[ADJUSTMENTREASON],
              [DIM_ADJUSTMENTREASON].[ADJUSTMENTREASONCODE]
          from [BBDW].[DIM_ADJUSTMENTREASON]