UFN_BATCHMEMBERSHIP_GETTRANSACTIONS

Returns all transactions for a given batch membership record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHMEMBERSHIPID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_BATCHMEMBERSHIP_GETTRANSACTIONS
        (
            @BATCHMEMBERSHIPID uniqueidentifier
        ) 
        returns table
        as return
        (
            select
                [BATCHMEMBERSHIPTRANSACTION].[ID],
                [BATCHMEMBERSHIPTRANSACTION].[MEMBERSHIPLEVELID],
                [BATCHMEMBERSHIPTRANSACTION].[MEMBERSHIPLEVELTERMID],
                [BATCHMEMBERSHIPTRANSACTION].[MEMBERSHIPLEVELTYPECODEID],
                [BATCHMEMBERSHIPTRANSACTION].[NUMBEROFCHILDREN],
                [BATCHMEMBERSHIPTRANSACTION].[COMMENTS],
                [BATCHMEMBERSHIPTRANSACTION].[ISGIFT],
                [BATCHMEMBERSHIPTRANSACTION].[DONORID],
                [BATCHMEMBERSHIPTRANSACTION].[TRANSACTIONDATE],
                [BATCHMEMBERSHIPTRANSACTION].[EXPIRATIONDATE],
                [BATCHMEMBERSHIPTRANSACTION].[CANCELMEMBERSHIP],
                [BATCHMEMBERSHIPTRANSACTION].[SEQUENCE]
            from
                dbo.[BATCHMEMBERSHIPTRANSACTION]
            where
                [BATCHMEMBERSHIPTRANSACTION].[BATCHMEMBERSHIPID] = @BATCHMEMBERSHIPID
        );