UFN_JOURNALENTRY_EXT_PAYMENTMETHODCODE_GETDESCRIPTION

/*
Generated by Blackbaud AppFx Platform
Date:  5/3/2024 2:16:45 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3700.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_JOURNALENTRY_EXT_PAYMENTMETHODCODE_GETDESCRIPTION(@ID tinyint)
RETURNS nvarchar(35) WITH EXECUTE AS CALLER
AS
begin

    return case @ID
        when 0 then 'Cash'
        when 1 then 'Check'
        when 2 then 'Credit card'
        when 3 then 'Direct debit'
        when 4 then 'Stock'
        when 5 then 'Property'
        when 6 then 'Gift-in-kind'
        when 7 then 'Sold stock'
        when 8 then 'Sold property'
        when 9 then 'None'
        when 10 then 'Other'
        when 11 then 'Standing order'
        when 12 then 'Sold gift-in-kind'
        when 101 then 'PayPal'
        when 102 then 'Venmo'
        when 200 then 'Sold stock gain'
        when 201 then 'Sold property gain'
        when 202 then 'Sold stock loss'
        when 203 then 'Sold property loss'
        when 204 then 'Fees'
        when 205 then 'Write off'
        when 206 then 'All'
        when 207 then 'Sold gift-in-kind revenue addition'
        when 208 then 'Sold gift-in-kind revenue reduction'    
    end

end