UFN_CONSTITUENTUNREALIZEDREVENUE

Returns a table of a constituent's unrealized revenue.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@LOADALL	bit	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN

Definition

Copy



CREATE function [dbo].[UFN_CONSTITUENTUNREALIZEDREVENUE]
(
    @CONSTITUENTID uniqueidentifier = null,
    @LOADALL bit = 0,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @SECURITYFEATUREID uniqueidentifier = null,
    @SECURITYFEATURETYPE tinyint = null
)
returns @R table
(
    REVENUEID uniqueidentifier,
    CONSTITUENTID uniqueidentifier,
    CONSTITUENTNAME nvarchar(255),
    APPLIED money,
    BALANCE money,
    AMOUNTDUE money,
    DATEDUE datetime,
    REVENUETYPECODE tinyint,
    DESCRIPTION nvarchar(255),
    SORTORDER int,
    DESIGNATIONLIST nvarchar(500),
    SPONSORSHIPOPPORTUNITY nvarchar(255),
    APPLICATIONCURRENCYID uniqueidentifier,
    PDACCOUNTSYSTEMID uniqueidentifier,
    SPONSORSHIPRGADDITIONALGIFT bit,
    MEMBERSHIPPROGRAMNAME nvarchar(255),
    MEMBERSHIPLEVELNAME nvarchar(255)
)
as
begin     
    -- KevinHi - Consolidated logic of this function into UFN_CONSTITUENTUNREALIZEDREVENUE_BYACCOUNTSYSTEM, which is used below.

    insert into @R
    (    
        REVENUEID,
        CONSTITUENTID,
        CONSTITUENTNAME,
        APPLIED,
        BALANCE,
        AMOUNTDUE,
        DATEDUE,
        REVENUETYPECODE,
        DESCRIPTION,
        SORTORDER,
        DESIGNATIONLIST,
        SPONSORSHIPOPPORTUNITY,
        APPLICATIONCURRENCYID,
        PDACCOUNTSYSTEMID,
        SPONSORSHIPRGADDITIONALGIFT,
    MEMBERSHIPPROGRAMNAME,
    MEMBERSHIPLEVELNAME
    )
    select
        REVENUEID,
        CONSTITUENTID,
        CONSTITUENTNAME,
        APPLIED,
        BALANCE,
        AMOUNTDUE,
        DATEDUE,
        REVENUETYPECODE,
        DESCRIPTION,
        SORTORDER,
        DESIGNATIONLIST,
        SPONSORSHIPOPPORTUNITY,
        APPLICATIONCURRENCYID,
        PDACCOUNTSYSTEMID,
        SPONSORSHIPRGADDITIONALGIFT,
    MEMBERSHIPPROGRAMNAME,
    MEMBERSHIPLEVELNAME
    from dbo.UFN_CONSTITUENTUNREALIZEDREVENUE_BYACCOUNTSYSTEM(@CONSTITUENTID, null, @LOADALL, @CURRENTAPPUSERID, @SECURITYFEATUREID, @SECURITYFEATURETYPE)
    order by SORTORDER desc;

    return;
end