UFN_AUCTIONITEM_GETRECEIPTAMOUNTS

CREATE function dbo.UFN_AUCTIONITEM_GETRECEIPTAMOUNTS
(
    @AUCTIONITEMID uniqueidentifier
)
returns @PAYMENTS table
(
    AUCTIONITEMID uniqueidentifier,
    REVENUEID uniqueidentifier,
    REVENUESPLITID uniqueidentifier,
    REVENUESPLITAMOUNT money,
    AUCTIONITEMRECEIPTAMOUNT money,
    TRANSACTIONCURRENCYID uniqueidentifier,
    TRANSACTIONCURRENCYDECIMALDIGITS int
)
as 
    begin

        insert into @PAYMENTS
            select 
                AUCTIONITEMID, 
                REVENUEID, 
                REVENUESPLITID, 
                REVENUESPLITAMOUNT, 
                case when AUCTIONITEMGAINLOSSAMOUNT > 0 then AUCTIONITEMGAINLOSSAMOUNT else 0 end,
                TRANSACTIONCURRENCYID, 
                TRANSACTIONCURRENCYDECIMALDIGITS
            from dbo.UFN_AUCTIONITEM_GETGAINLOSS(@AUCTIONITEMID)

        return;
    end