UFN_ACCOUNTINGELEMENTID_MAPFROM_AC_ATTACHMENTID

Maps an account code 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_AC_ATTACHMENTID
(
  @ATTACHMENTID uniqueidentifier
)
returns uniqueidentifier as
begin
    declare @ID uniqueidentifier
  select @ID = GLACCOUNTCODEID from dbo.GLACCOUNTCODEATTACHMENT where ID = @ATTACHMENTID
    return @ID
end