UFN_CODETABLESECURITY_RECEIVABLEPAYMENTOTHERMETHOD_GETOTHERPAYMENTMETHODCODEID

Returns the OTHERPAYMENTMETHODCODEID for the given RECEIVABLEPAYMENTOTHERMETHOD.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN The ID used to look up the code table entry ID.

Definition

Copy
/*
Generated by Blackbaud AppFx Platform
Date:  8/2/2010 7:06:14 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_CODETABLESECURITY_RECEIVABLEPAYMENTOTHERMETHOD_GETOTHERPAYMENTMETHODCODEID(@ID uniqueidentifier)
RETURNS uniqueidentifier WITH EXECUTE AS CALLER
as
begin
    declare @r uniqueidentifier;
    select @r = OTHERPAYMENTMETHODCODEID from dbo.RECEIVABLEPAYMENTOTHERMETHOD where ID = @ID;
    return @r;
end