USP_DATALIST_PLANNEDGIFTADDITION_ASSETS

A datalist of assets for a given planned gift..

Parameters

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

Definition

Copy



                create procedure dbo.USP_DATALIST_PLANNEDGIFTADDITION_ASSETS(@PLANNEDGIFTADDITIONID uniqueidentifier)
                as
                    select 
                        PLANNEDGIFTADDITIONASSET.ID,
                        dbo.UFN_ASSETTYPECODE_GETDESCRIPTION(PLANNEDGIFTADDITIONASSET.ASSETTYPECODEID),
                        PLANNEDGIFTADDITIONASSET.DESCRIPTION,
                        PLANNEDGIFTADDITIONASSET.TRANSACTIONVALUE as VALUE,
                        PLANNEDGIFTADDITIONASSET.TRANSACTIONCURRENCYID
                    from
                        dbo.PLANNEDGIFTADDITIONASSET
                    where
                        PLANNEDGIFTADDITIONASSET.PLANNEDGIFTADDITIONID=@PLANNEDGIFTADDITIONID
                    order by
                        PLANNEDGIFTADDITIONASSET.DATEADDED;