UFN_PLANNEDGIFT_RELATIONSHIPS

Returns the relationships for a planned gift.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PLANNEDGIFT_RELATIONSHIPS(@PLANNEDGIFTID uniqueidentifier)
            returns table
            as return
                select 
                    ID,
                    RELATIONSHIPID,
                    SEQUENCE
                from
                    dbo.PLANNEDGIFTRELATIONSHIP
                where
                    PLANNEDGIFTID=@PLANNEDGIFTID