UFN_REVENUEUPDATEBATCH_GETLETTERS

Returns a list of letters or tribute letters associated with a certain revenue batch ID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_REVENUEUPDATEBATCH_GETLETTERS(
    @BATCHREVENUEID uniqueidentifier
) returns table
as
return
(
    select
        L.ID,
        L.LETTERTYPECODE,
        L.TRIBUTEID,
        L.LETTERCODEID,        
        L.ACKNOWLEDGEEID,        
        L.ACKNOWLEDGEDATE,
        L.REVENUELETTERID,
        L.PROCESSDATE,
        L.OUTOFDATE,
        L.CLEARDATES
    from
        dbo.BATCHREVENUELETTER L
    where
        L.BATCHREVENUEID = @BATCHREVENUEID
);