UFN_MERCHANDISEPRODUCTINSTANCE_GETLASTHISTORYITEM

CREATE function dbo.UFN_MERCHANDISEPRODUCTINSTANCE_GETLASTHISTORYITEM
(
    @MERCHANDISEPRODUCTINSTANCEID uniqueidentifier,
    @ACTIONTYPECODE tinyint = null
)
returns table
    as
        return 
            select top 1
                ID,
                SOURCETYPECODE,
                ACTIONTYPECODE,
                ACTIONDATE,
                QUANTITY,
                ONHANDQUANTITY,
                COST,
                AVERAGECOST,
                SALEPRICE,
                BATCHID,
                VENDORID,
                MERCHANDISEADJUSTMENTREASONCODEID,
                COMMENTS
            from dbo.MERCHANDISEPRODUCTINSTANCEHISTORY
            where MERCHANDISEPRODUCTINSTANCEID = @MERCHANDISEPRODUCTINSTANCEID
                and (@ACTIONTYPECODE is null or ACTIONTYPECODE = @ACTIONTYPECODE)
            order by ACTIONDATE desc;