UFN_REMINDER_PAYMENTDUE
Returns the amount due for a reminder process (pledges or recurring gifts)
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | |
| @ASOFDATE | datetime | IN |
Definition
Copy
CREATE function dbo.UFN_REMINDER_PAYMENTDUE(
@REVENUEID uniqueidentifier,
@ASOFDATE datetime
)
returns money
with execute as caller
as begin
declare @TRANSACTIONTYPECODE tinyint;
select @TRANSACTIONTYPECODE = TYPECODE from dbo.FINANCIALTRANSACTION where FINANCIALTRANSACTION.ID = @REVENUEID
if @TRANSACTIONTYPECODE in (1,15)
return dbo.UFN_PLEDGE_PAYMENTDUE(@REVENUEID,@ASOFDATE)
if @TRANSACTIONTYPECODE = 2
return dbo.UFN_RECURRINGGIFT_PAYMENTDUE(@REVENUEID,@ASOFDATE)
return null
end