UFN_GLGETCATEGORYFROMACCTCODE

Get the category from the Account Code number.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_GLGETCATEGORYFROMACCTCODE(@ID uniqueidentifier)
returns integer

with execute as caller
as begin
    declare @CATEGORY integer

     Select @CATEGORY = CATEGORYCODE  
            from dbo.ACCOUNTCODE
          where ID = @ID

    return @CATEGORY
end