UFN_AUCTIONDONATION_GETWRITEOFFINSTALLMENTS_2

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_2(@REVENUEID uniqueidentifier)
            returns table
            as
            return
            (
                select
                    REVENUE.ID as [ID],
                    REVENUE.DATE as [DATE],
                    REVENUE.AMOUNT as [AMOUNT],
                    REVENUE.TRANSACTIONAMOUNT as [BALANCE],
                    REVENUE.TRANSACTIONAMOUNT as [WRITEOFFAMOUNT],
                    1 as [SEQUENCE],
                    REVENUE.BASECURRENCYID,
                    REVENUE.ORGANIZATIONAMOUNT,
                    REVENUE.ORGANIZATIONEXCHANGERATEID,
                    REVENUE.TRANSACTIONAMOUNT as [TRANSACTIONAMOUNT],
                    REVENUE.TRANSACTIONCURRENCYID,
                    REVENUE.BASEEXCHANGERATEID
                from dbo.REVENUE
                where REVENUE.ID = @REVENUEID
            )