USP_DATALIST_DESIGNATIONLEVELDISBURSEMENT

Returns a list of all disbursements for a fundraising purpose.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DESIGNATIONLEVELDISBURSEMENT
                (
                    @DESIGNATIONLEVELID uniqueidentifier                                                                          
                )
                as

                select    
                    DESIGNATIONLEVELDISBURSEMENT.ID, 
                    DESIGNATIONLEVELDISBURSEMENT.CONSTITUENTID, 
                    dbo.UFN_CONSTITUENT_BUILDNAME(DESIGNATIONLEVELDISBURSEMENT.CONSTITUENTID) as CONSTITUENT,
                    DESIGNATIONLEVELDISBURSEMENT.AMOUNT,
                    DESIGNATIONLEVELDISBURSEMENT.DATE,
                    DESIGNATIONLEVELDISBURSEMENT.BASECURRENCYID
                from dbo.DESIGNATIONLEVELDISBURSEMENT
                where 
                    DESIGNATIONLEVELDISBURSEMENT.DESIGNATIONLEVELID = @DESIGNATIONLEVELID                     
                order by DESIGNATIONLEVELDISBURSEMENT.DATEADDED