UFN_MEMBERSHIPDUESBATCH_GETDONATIONRECOGNITIONS

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHMEMBERSHIPDUESID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_MEMBERSHIPDUESBATCH_GETDONATIONRECOGNITIONS
(
    @BATCHMEMBERSHIPDUESID uniqueidentifier
)
returns table
as
return (
    select
        ID,
        CONSTITUENTID,
        REVENUERECOGNITIONTYPECODEID,
        EFFECTIVEDATE,
        AMOUNT
    from dbo.BATCHMEMBERSHIPDUESDONATIONRECOGNITION
    where BATCHMEMBERSHIPDUESID = @BATCHMEMBERSHIPDUESID
)