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
)