UFN_GETCATEGORYBALANCEFROMID

Get the category balance from ID.

Return

Return Type
tinyint

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_GETCATEGORYBALANCEFROMID(@ID uniqueidentifier)
returns tinyint
with execute as caller
as begin
    declare @CATEGORYBALANCECODE tinyint 
  declare @ACCTCODE nvarchar(100)
  declare @CONTRA bit

  SET @CATEGORYBALANCECODE = NULL

  select @ACCTCODE = SHORTDESCRIPTION from dbo.PDACCOUNTSEGMENTVALUE where ID= @ID
  select @CONTRA = CONTRAACCOUNT, @CATEGORYBALANCECODE = NORMALBALANCECODE from dbo.ACCOUNTCODE where ID= @ID

  if @CONTRA = 1 
    begin
                return case @CATEGORYBALANCECODE
                    when 1 then  2
                    when 2 then  1
                end
    end 

    return @CATEGORYBALANCECODE

end