UFN_AUCTIONDONATION_GETWRITEOFFINSTALLMENTS

Returns installment information for writing off an auction donation.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_AUCTIONDONATION_GETWRITEOFFINSTALLMENTS(@REVENUEID uniqueidentifier)
            returns table
            as
            return
            (
                select
                    REVENUE.ID as [ID],
                    REVENUE.DATE as [DATE],
                    REVENUE.AMOUNT as [AMOUNT],
                    REVENUE.AMOUNT as [BALANCE],
                    REVENUE.AMOUNT as [WRITEOFFAMOUNT],
                    1 as [SEQUENCE]
                from dbo.REVENUE
                where REVENUE.ID = @REVENUEID
            )