UFN_BANKACCOUNTADJUSTMENTCATEGORY_GETNAME

                CREATE function dbo.UFN_BANKACCOUNTADJUSTMENTCATEGORY_GETNAME(@ID uniqueidentifier) returns nvarchar(100) 
                as
                begin
                    declare @ADJUSTMENTCATEGORYNAME nvarchar(100)

                    select @ADJUSTMENTCATEGORYNAME = CATEGORY 
                    from dbo.BANKACCOUNTADJUSTMENTCATEGORY where ID = @ID

                    return @ADJUSTMENTCATEGORYNAME
                end