v_FACT_REVENUETRIBUTE

Contains revenue and tribute fact

Fields

Field	Field Type	Null	Description
REVENUETRIBUTEFACTID	int		[BBDW].[FACT_REVENUETRIBUTE].[REVENUETRIBUTEFACTID]
REVENUETRIBUTESYSTEMID	uniqueidentifier	yes	[BBDW].[FACT_REVENUETRIBUTE].[REVENUETRIBUTESYSTEMID]
TRIBUTEDIMID	int	yes	[BBDW].[FACT_REVENUETRIBUTE].[TRIBUTEDIMID]
REVENUEFACTID	int	yes	[BBDW].[FACT_REVENUETRIBUTE].[REVENUEFACTID]
AMOUNT	money	yes	[BBDW].[FACT_REVENUETRIBUTE].[AMOUNT]
BASECURRENCYDIMID	int	yes	[BBDW].[FACT_REVENUETRIBUTE].[BASECURRENCYDIMID]
BASEAMOUNT	money	yes	[BBDW].[FACT_REVENUETRIBUTE].[BASEAMOUNT]
ISTRIBUTEANONYMOUS	bit	yes	[BBDW].[FACT_REVENUETRIBUTE].[ISTRIBUTEANONYMOUS]
FINANCIALTRANSACTIONFACTID	int	yes	BBDW.[FACT_REVENUETRIBUTE].[FINANCIALTRANSACTIONFACTID]
FINANCIALTRANSACTIONLINEITEMFACTID	int	yes	BBDW.[FACT_REVENUETRIBUTE].[FINANCIALTRANSACTIONLINEITEMFACTID]

Definition

Copy


      CREATE view [BBDW].[v_FACT_REVENUETRIBUTE] as
        select
          rt.[REVENUETRIBUTEFACTID],
          rt.[REVENUETRIBUTESYSTEMID],
          rt.[TRIBUTEDIMID],
          rt.[REVENUEFACTID],
          rt.[AMOUNT],
          rt.[BASECURRENCYDIMID],
          rt.[BASEAMOUNT],
          rt.[ISTRIBUTEANONYMOUS],
          rt.[FINANCIALTRANSACTIONFACTID],
          rt.[FINANCIALTRANSACTIONLINEITEMFACTID]
        from BBDW.[FACT_REVENUETRIBUTE] rt;