UFN_JOURNALENTRY_EXT_PAYMENTMETHODCODE_GETID

/*
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_GETID(@Description nvarchar(35))
RETURNS tinyint WITH EXECUTE AS CALLER
AS
begin

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

end