UFN_BANKACCOUNTTRANSACTION_TRANSACTIONFLAGCODE_GETID
Return
Return Type |
---|
tinyint |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@Description | nvarchar(18) | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 7/16/2009 11:17:32 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.1.30.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_BANKACCOUNTTRANSACTION_TRANSACTIONFLAGCODE_GETID(@Description nvarchar(18))
RETURNS tinyint WITH EXECUTE AS CALLER
AS
begin
return case @Description
when 'Deposit' then 1
when 'Check/Payment' then 2
when 'Adjustment' then 3
when 'Special Adjustment' then 4
else -1
end
end