UFN_GIFTINKINDPAYMENTMETHODDETAIL_REMAININGUNITS

Returns the number of gift-in-kind units remaining for a GIFTINKINDPAYMENTMETHODDETAIL record.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@GIFTINKINDPAYMENTMETHODDETAILID	uniqueidentifier	IN
@GIFTINKINDSALETOEXCLUDE	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_GIFTINKINDPAYMENTMETHODDETAIL_REMAININGUNITS
            (
                @GIFTINKINDPAYMENTMETHODDETAILID uniqueidentifier,
                @GIFTINKINDSALETOEXCLUDE uniqueidentifier
            )
            returns integer
            as
            begin
                declare @REMAININGUNITS integer

                select @REMAININGUNITS = GIFTINKINDPAYMENTMETHODDETAIL.NUMBEROFUNITS - coalesce((select sum(NUMBEROFUNITS) from dbo.GIFTINKINDSALE where GIFTINKINDPAYMENTMETHODDETAILID = GIFTINKINDPAYMENTMETHODDETAIL.ID and ID <> @GIFTINKINDSALETOEXCLUDE), 0)
                from dbo.GIFTINKINDPAYMENTMETHODDETAIL where ID = @GIFTINKINDPAYMENTMETHODDETAILID

                return @REMAININGUNITS
            end