UFN_DEFAULTDESCRIPTION

      CREATE function dbo.UFN_DEFAULTDESCRIPTION(@ACCOUNTSYSTEMID uniqueidentifier = null)
      returns table
      as return
        select top 30 ID, DEFAULTDESCRIPTIONLENGTH, DEFAULTDESCRIPTIONSEQUENCE
        from dbo.PDACCOUNTSTRUCTURE
        where DEFAULTDESCRIPTIONSEQUENCE > 0
        and PDACCOUNTSYSTEMID = isnull(@ACCOUNTSYSTEMID, '4B121C2C-CCE6-440D-894C-EA0DEF80D50B') and
        ISBASICGL = 0
        order by DEFAULTDESCRIPTIONSEQUENCE