UFN_REVENUEBATCH_GETENHANCEDMATCHINGGIFTSPLITS
Returns the splits for a matching gift in an enhanced revenue batch.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHREVENUEENHANCEDMATCHINGGIFTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_REVENUEBATCH_GETENHANCEDMATCHINGGIFTSPLITS
(
@BATCHREVENUEENHANCEDMATCHINGGIFTID uniqueidentifier
)
returns table
as
return
(
select
ID,
DESIGNATIONID,
AMOUNT,
SEQUENCE,
REVENUESPLITID
from dbo.BATCHREVENUEENHANCEDMATCHINGGIFTSPLIT
where BATCHREVENUEENHANCEDMATCHINGGIFTID = @BATCHREVENUEENHANCEDMATCHINGGIFTID
)