USP_DATALIST_PAYMENTEVENTREVENUEBATCHREGISTRANTBENEFITS
Returns the benefits that a registrant will receive.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REGISTRANTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
| @TRANSACTIONCURRENCYID | uniqueidentifier | IN | Transaction currency ID |
| @BASECURRENCYID | uniqueidentifier | IN | Base currency ID |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_PAYMENTEVENTREVENUEBATCHREGISTRANTBENEFITS
(
@REGISTRANTID uniqueidentifier,
@TRANSACTIONCURRENCYID uniqueidentifier = null,
@BASECURRENCYID uniqueidentifier = null
)
as
set nocount on;
select
BENEFITID,
QUANTITY,
UNITVALUE,
DETAILS,
BENEFITNAME,
TRANSACTIONTOTALVALUE
from
dbo.UFN_REVENUEBATCH_BATCHEVENTREGISTRANT_GETPAYMENTBENEFITS(@REGISTRANTID, @TRANSACTIONCURRENCYID, @BASECURRENCYID);