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
)