UFN_RESERVATION_GETPAYMENTCOUNT

Returns the number of sales order payments and security deposit payments for a reservation.

Return

Return Type
tinyint

Parameters

Parameter	Parameter Type	Mode	Description
@RESERVATIONID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_RESERVATION_GETPAYMENTCOUNT(@RESERVATIONID uniqueidentifier)
returns tinyint
with execute as caller
as begin

    return (
            select count([SALESORDERPAYMENT].[ID]) 
            from dbo.[SALESORDERPAYMENT] 
            where [SALESORDERPAYMENT].[SALESORDERID] = @RESERVATIONID
           ) 
                + 
           (
            select count([RESERVATIONSECURITYDEPOSITPAYMENT].[ID]) 
            from dbo.[RESERVATIONSECURITYDEPOSITPAYMENT]
            where [RESERVATIONSECURITYDEPOSITPAYMENT].[RESERVATIONID] = @RESERVATIONID
           )
end