UFN_REVENUEBATCH_GETSINGLEAPPLICATIONINFO

Returns the values stored in the applicationinfo column for single payment application.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_REVENUEBATCH_GETSINGLEAPPLICATIONINFO(@REVENUEID uniqueidentifier)
returns @RESULT table 
(
    SINGLEAPPLICATIONID uniqueidentifier,
    APPLICATIONTYPECODE int,
    APPLICATIONAMOUNT money
)
as
begin
    declare @APPINFO nvarchar(60);
    declare @SINGLEAPPLICATIONID uniqueidentifier;

    select @APPINFO = APPLICATIONINFO
     from dbo.BATCHREVENUE where ID = @REVENUEID;    

    if @APPINFO is not null and len(@APPINFO) > 3 
    begin
        insert into @RESULT
        select SINGLEAPPLICATIONID,
               APPLICATIONTYPECODE,
                 APPLICATIONAMOUNT
        from dbo.UFN_REVENUEBATCH_PARSEAPPLICATIONINFO(@APPINFO);     
    end

    return;
end