UFN_RECURRINGGIFT_GETPASTDUEAMOUNTIGNOREPAYMENT
Returns the amount due for a recurring gift with installments, ignoring the given payment.
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | |
| @PAYMENTID | uniqueidentifier | IN | |
| @ASOFDATE | date | IN |
Definition
Copy
CREATE function dbo.UFN_RECURRINGGIFT_GETPASTDUEAMOUNTIGNOREPAYMENT(
@REVENUEID uniqueidentifier,
@PAYMENTID uniqueidentifier,
@ASOFDATE date = null
)
returns money
with execute as caller
as begin
return dbo.UFN_RECURRINGGIFT_GETPASTDUEAMOUNTIGNOREPAYMENT_2(@REVENUEID, @PAYMENTID, @ASOFDATE, 1)
end