UFN_CONSTITID_MAPFROM_REVENUETRANSACTIONID

 create function BBDW.[UFN_CONSTITID_MAPFROM_REVENUETRANSACTIONID](@REVENUEID uniqueidentifier)   
  returns uniqueidentifier  
    as  
      begin  

        declare @ID uniqueidentifier;  

        select top 1 @ID = [CONSTITUENTSYSTEMID] from BBDW.[FACT_REVENUE] where [REVENUESYSTEMID] = @REVENUEID;  

        return @ID;  

      end