UFN_RECURRINGGIFT_GETPASTDUEAMOUNT_2
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | |
| @ASOFDATE | date | IN | |
| @IGNORESTATUS | bit | IN |
Definition
Copy
create function dbo.UFN_RECURRINGGIFT_GETPASTDUEAMOUNT_2(
@REVENUEID uniqueidentifier,
@ASOFDATE date = null,
@IGNORESTATUS bit = 0
)
returns money
with execute as caller
as begin
declare @PASTDUE money;
if @ASOFDATE is null
set @ASOFDATE = getdate();
select @PASTDUE = AMOUNT
from dbo.UFN_RECURRINGGIFT_GETPASTDUEAMOUNT_BULK_2(@ASOFDATE,@IGNORESTATUS)
where ID = @REVENUEID;
set @PASTDUE = coalesce(@PASTDUE, 0);
return @PASTDUE;
end