UFN_CONSTITID_MAPFROM_REVENUESPLITID

 create function [BBDW].[UFN_CONSTITID_MAPFROM_REVENUESPLITID](@REVENUESPLITID uniqueidentifier)   
  returns uniqueidentifier  
    as  
      begin  

        declare @ID uniqueidentifier;  

        select 
          top 1 @ID = [CONSTITUENTSYSTEMID] 
        from BBDW.[FACT_FINANCIALTRANSACTIONLINEITEM] 
        where [FINANCIALTRANSACTIONLINEITEMSYSTEMID] = @REVENUESPLITID;  

        return @ID;  

      end