V_REVENUE_WITHNULLCONSTITUENTSECURITY

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier	yes

Definition

Copy


create view BBDW.[V_REVENUE_WITHNULLCONSTITUENTSECURITY]
as
    select
        [FACT_FINANCIALTRANSACTION].[FINANCIALTRANSACTIONSYSTEMID] as [ID]
    from BBDW.[FACT_FINANCIALTRANSACTION] 
  left join BBDW.[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT]    on [FACT_FINANCIALTRANSACTION].[CONSTITUENTDIMID] = [FACT_CONSTITUENTSECURITYGROUPASSIGNMENT].[CONSTITUENTDIMID]
    where    [FACT_CONSTITUENTSECURITYGROUPASSIGNMENT].[CONSTITUENTDIMID] is null;