UFN_ACCOUNTINGELEMENTID_MAPFROM_AC_MEDIALINKID

Maps an account code media link ID to the Accounting Element ID for record security.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@MEDIALINKID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_ACCOUNTINGELEMENTID_MAPFROM_AC_MEDIALINKID
(
  @MEDIALINKID uniqueidentifier
)
returns uniqueidentifier as
begin
    declare @ID uniqueidentifier
  select @ID = GLACCOUNTCODEID from dbo.GLACCOUNTCODEMEDIALINK where ID = @MEDIALINKID
    return @ID
end