FACT_REVENUETRIBUTE_STAGE

Contains information about revenue tributes fact relationship.

Fields

Field	Field Type	Null	Notes	Description
REVENUETRIBUTESYSTEMID	uniqueidentifier	yes		dbo.[REVENUETRIBUTE].[ID]
TRIBUTESYSTEMID	uniqueidentifier	yes		dbo.[TRIBUTE].[ID]
REVENUESYSTEMID	uniqueidentifier	yes		[dbo].[REVENUETRIBUTE].[REVENUEID]
AMOUNT	money	yes		[dbo].[REVENUETRIBUTE].[ORGANIZATIONAMOUNT]
BASECURRENCYDIMID	int	yes		Reference key to the currency dimension, derived from dbo.[REVENUETRIBUTE].[BASECURRENCYID]
BASEAMOUNT	money	yes		[dbo].[REVENUETRIBUTE].[AMOUNT]
ISTRIBUTEANONYMOUS	bit	yes		[dbo].[REVENUETRIBUTE].[ISTRIBUTEANONYMOUS]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
ETLCONTROLID	int	yes		ID generated through the ETL process.
SOURCEDIMID	int	yes		Source system used.