USP_DATALIST_PLEDGEWRITEOFFS

This datalist returns a list of write-offs for a pledge.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_PLEDGEWRITEOFFS
                (
                    @ID uniqueidentifier
                )
                as

                set nocount on;

                select 
                    WRITEOFF.ID,
                    WRITEOFF.DATE,
                    (select sum(INSTALLMENTWRITEOFF.AMOUNT) from dbo.INSTALLMENTWRITEOFF where WRITEOFFID = WRITEOFF.ID) as AMOUNT,
                    WRITEOFF.POSTSTATUS,
                    WRITEOFF.POSTDATE,
                    WRITEOFF.POSTSTATUSCODE,
                    WRITEOFF.REASON
                from 
                    dbo.WRITEOFF
                inner join 
                    dbo.REVENUE on WRITEOFF.REVENUEID = REVENUE.ID
                where 
                    REVENUE.ID = @ID
                order by 
                    WRITEOFF.DATE, WRITEOFF.DATEADDED;