USP_DATALIST_PLANNEDGIFT_ASSETS

A datalist of assets for a given planned gift.

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_PLANNEDGIFT_ASSETS(@PLANNEDGIFTID uniqueidentifier)
                as
                    select 
                        PLANNEDGIFTASSET.ID,
                        ASSETTYPECODE.DESCRIPTION,
                        PLANNEDGIFTASSET.DESCRIPTION,
                        PLANNEDGIFTASSET.TRANSACTIONVALUE as VALUE,
                        PLANNEDGIFTASSET.TRANSACTIONCURRENCYID
                    from
                        dbo.PLANNEDGIFTASSET
                        left outer join dbo.ASSETTYPECODE on ASSETTYPECODE.ID = PLANNEDGIFTASSET.ASSETTYPECODEID
                    where
                        PLANNEDGIFTASSET.PLANNEDGIFTID=@PLANNEDGIFTID
                    order by
                        PLANNEDGIFTASSET.DATEADDED;