UFN_REVENUEBATCH_GETBATCHID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_REVENUEBATCH_GETBATCHID (
        @ID uniqueidentifier
      ) returns uniqueidentifier as
      begin
        declare @BATCHID uniqueidentifier

        select @BATCHID = BATCHID
        from dbo.BATCHREVENUE
        where ID = @ID;

        return @BATCHID;
      end