DIM_REVENUERECOGNITIONTYPE

Contains descriptive information about the revenue recognition type.

Primary Key

Primary Key	Field Type
REVENUERECOGNITIONTYPEDIMID	int

Fields

Field	Field Type	Null	Notes	Description
REVENUERECOGNITIONTYPESYSTEMID	uniqueidentifier	yes		dbo.[REVENUERECOGNITIONTYPECODE].[ID]
REVENUERECOGNITIONTYPE	nvarchar(100)	yes		dbo.[REVENUERECOGNITIONTYPECODE].[DESCRIPTION]
REVENUERECOGNITIONTYPEISACTIVE	bit	yes		dbo.[REVENUERECOGNITIONTYPECODE].[ACTIVE]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
SOURCEDIMID	int	yes		Source system used
ETLCONTROLID	int	yes		ID generated through the ETL process

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DIM_REVENUERECOGNITIONTYPE_REVENUERECOGNITIONTYPESYSTEMID	REVENUERECOGNITIONTYPESYSTEMID
IX_DIM_REVENUERECOGNITIONTYPE_SOURCEDIMID	SOURCEDIMID
PK_DIM_REVENUERECOGNITIONTYPE	REVENUERECOGNITIONTYPEDIMID	yes	yes	yes