UFN_REVENUEBATCH_GETUNAPPLIEDMATCHINGGIFTSPLITS
Fetch revenue batch unapplied matching gift splits
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHREVENUEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_REVENUEBATCH_GETUNAPPLIEDMATCHINGGIFTSPLITS
(
@BATCHREVENUEID uniqueidentifier
)
returns table
as
return
(
select
ID,
DESIGNATIONID,
AMOUNT,
SEQUENCE
from dbo.BATCHREVENUEUNAPPLIEDMATCHINGGIFTSPLIT
where BATCHREVENUEID = @BATCHREVENUEID
)