UFN_ADJUSTMENTCATEGORY_GETNAME

            CREATE function dbo.UFN_ADJUSTMENTCATEGORY_GETNAME(@ID uniqueidentifier) returns nvarchar(20) with execute as caller
            as
            begin
                declare @CATEGORY nvarchar(20)
                select @CATEGORY = CATEGORY from dbo.BANKACCOUNTADJUSTMENTCATEGORY where ID = @ID
                return @CATEGORY
            end