UFN_MEMBERSHIPDUESBATCH_GETPLEDGEINSTALLMENTS

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@BATCHMEMBERSHIPDUESID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_MEMBERSHIPDUESBATCH_GETPLEDGEINSTALLMENTS
(
    @BATCHMEMBERSHIPDUESID uniqueidentifier
)
returns table
as
return (
    select
        ID,
        DATE,
        AMOUNT,
        SEQUENCE,
        TRANSACTIONCURRENCYID,
        RECEIPTAMOUNT
    from dbo.BATCHMEMBERSHIPDUESPLEDGEINSTALLMENT
    where BATCHMEMBERSHIPDUESID = @BATCHMEMBERSHIPDUESID
)