UFN_ACCOUNTINGELEMENTID_MAPFROM_UDE_ATTACHMENTID

Maps a user-defined element attachment ID to the Accounting Element ID for record security.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@ATTACHMENTID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_ACCOUNTINGELEMENTID_MAPFROM_UDE_ATTACHMENTID
(
  @ATTACHMENTID uniqueidentifier
)
returns uniqueidentifier as
begin
    declare @ID uniqueidentifier
  select @ID = USERDEFINEDELEMENTID from dbo.USERDEFINEDELEMENTATTACHMENT where ID = @ATTACHMENTID
    return @ID
end