UFN_BATCHBBNCDONATION_GETGIFTAPPLICATIONS

Retrieves the gift applications for a row in a Blackbaud Internet Solutions Donations batch.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHBBNCDONATIONID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BATCHBBNCDONATION_GETGIFTAPPLICATIONS
            (
                @BATCHBBNCDONATIONID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    ID,
                    BATCHBBNCDONATIONID,
          SEQUENCE,
          APPLICATIONID,
                    CONSTITUENTID,
                    APPLIEDAMOUNT,
          OVERPAYMENTTYPECODE,
          APPLICATIONCODE
                from dbo.BATCHBBNCDONATIONGIFTAPPLICATION
                where BATCHBBNCDONATIONID = @BATCHBBNCDONATIONID
            )