UFN_MEMBERSHIPDUESBATCH_GETMEMBERSHIPRECOGNITIONS

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