UFN_STOCKDETAIL_REMAININGUNITS

Returns the number of stock units remaining for a STOCKDETAIL record.

Return

Return Type
decimal(20, 3)

Parameters

Parameter	Parameter Type	Mode	Description
@STOCKDETAILID	uniqueidentifier	IN
@STOCKSALETOEXCLUDE	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_STOCKDETAIL_REMAININGUNITS
            (
                @STOCKDETAILID uniqueidentifier,
                @STOCKSALETOEXCLUDE uniqueidentifier
            )
            returns decimal(20,3)
            as
            begin
                declare @REMAININGUNITS decimal(20,3)

                select @REMAININGUNITS = STOCKDETAIL.NUMBEROFUNITS - coalesce((select sum(NUMBEROFUNITS) from dbo.STOCKSALE where STOCKDETAILID = STOCKDETAIL.ID and ID <> @STOCKSALETOEXCLUDE), 0)
                from dbo.STOCKDETAIL where ID = @STOCKDETAILID

                return @REMAININGUNITS
            end