UFN_RECURRINGGIFT_GETPASTDUEAMOUNTINCURRENCY
Returns the amount due for a recurring gift with installments in currency.
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | |
| @ASOFDATE | date | IN | |
| @CURRENCYID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_RECURRINGGIFT_GETPASTDUEAMOUNTINCURRENCY(
@REVENUEID uniqueidentifier,
@ASOFDATE date = null,
@CURRENCYID uniqueidentifier
)
returns money
with execute as caller
as begin
return dbo.UFN_RECURRINGGIFT_GETPASTDUEAMOUNTINCURRENCY_2(@REVENUEID, @ASOFDATE, @CURRENCYID, 1);
end