USP_DATALIST_AUCTIONDONATION_WRITEOFF

Returns a list of write-offs for an auction donation transaction.
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@DISPLAYCURRENCYTYPECODE	tinyint	IN	Display currency
Definition

Copy


                CREATE procedure dbo.USP_DATALIST_AUCTIONDONATION_WRITEOFF
                (
                    @ID uniqueidentifier,
                    @DISPLAYCURRENCYTYPECODE tinyint = 0
                )
                as
                set nocount on;

                select 
                    WRITEOFF.ID,
                    WRITEOFF.DATE,
                    case when @DISPLAYCURRENCYTYPECODE = 1 then 
                            (select sum(WRITEOFFSPLIT.AMOUNT) from dbo.WRITEOFFSPLIT where WRITEOFFID = WRITEOFF.ID) 
                         when @DISPLAYCURRENCYTYPECODE = 2 then
                            (select sum(WRITEOFFSPLIT.ORGANIZATIONAMOUNT) from dbo.WRITEOFFSPLIT where WRITEOFFID = WRITEOFF.ID) 
                         else 
                            (select sum(WRITEOFFSPLIT.TRANSACTIONAMOUNT) from dbo.WRITEOFFSPLIT where WRITEOFFID = WRITEOFF.ID) 
                    end as [AMOUNT],
                    WRITEOFF.POSTSTATUS,
                    WRITEOFF.POSTDATE,
                    WRITEOFF.POSTSTATUSCODE,
                    WRITEOFF.REASON,
                    WRITEOFFREASONCODE.CODE as REASONCODE,
                    WRITEOFFREASONCODE.DESCRIPTION as REASONDESCRIPTION,
                    case when @DISPLAYCURRENCYTYPECODE = 1 then 
                            REVENUE.BASECURRENCYID
                         when @DISPLAYCURRENCYTYPECODE = 2 then
                            dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY()
                         else 
                            REVENUE.TRANSACTIONCURRENCYID
                    end as [CURRENCYID]
                from 
                    dbo.WRITEOFF
                inner join 
                    dbo.REVENUE on WRITEOFF.REVENUEID = REVENUE.ID
                left join
                    dbo.WRITEOFFREASONCODE on WRITEOFFREASONCODE.ID = WRITEOFF.REASONCODEID
                where 
                    REVENUE.ID = @ID
                    and REVENUE.TRANSACTIONTYPECODE = 7
                order by 
                    WRITEOFF.DATE;