UFN_AUCTIONITEM_GETPOSTABLEPURCHASEAMOUNT

            CREATE function dbo.UFN_AUCTIONITEM_GETPOSTABLEPURCHASEAMOUNT
            (
                @AUCTIONITEMID uniqueidentifier,
                @IGNOREREVENUEID uniqueidentifier
            )
            returns @ITEMS table
            (
                ID uniqueidentifier,
                AMOUNT money,
                TRANSACTIONAMOUNT money,
                ORGANIZATIONAMOUNT money
            )
            as begin
                declare @PURCHASEPRICE money = 0;

                insert into @ITEMS
                (
                    ID,
                    AMOUNT,
                    TRANSACTIONAMOUNT,
                    ORGANIZATIONAMOUNT
                )
                select
                    @AUCTIONITEMID,
                    sum(REVENUESPLIT.AMOUNT),
                    sum(REVENUESPLIT.TRANSACTIONAMOUNT),
                    sum(REVENUESPLIT.ORGANIZATIONAMOUNT)
                from
                    dbo.AUCTIONITEM
                    left join dbo.AUCTIONITEMPURCHASE on AUCTIONITEM.ID = AUCTIONITEMPURCHASE.AUCTIONITEMID
                    left join dbo.REVENUESPLIT on AUCTIONITEMPURCHASE.PURCHASEID = REVENUESPLIT.ID
                    left join dbo.REVENUE on REVENUESPLIT.REVENUEID = REVENUE.ID
                where
                    (
                        (AUCTIONITEM.TYPECODE = 0 and AUCTIONITEM.ID = @AUCTIONITEMID)
                        or
                        (AUCTIONITEM.TYPECODE = 1 and AUCTIONITEM.PACKAGEID = @AUCTIONITEMID)
                    )
                    and
                    REVENUE.DONOTPOST <> 1
                    and
                    (@IGNOREREVENUEID is null or (REVENUE.ID <> @IGNOREREVENUEID))
                return
            end