UFN_REVENUEBATCH_GETBENEFITSPCT
Returns all percentage benefits for a given batch row.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHREVENUEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_REVENUEBATCH_GETBENEFITSPCT
(
@BATCHREVENUEID uniqueidentifier
)
returns table
as
return
(
select
[ID],
[BENEFITID],
[PERCENTAPPLICABLEAMOUNT],
[VALUEPERCENT],
PERCENTAPPLICABLEAMOUNT * VALUEPERCENT /100 as [TOTALVALUE],
[DETAILS],
[SEQUENCE],
[REVENUEBENEFITID]
from dbo.BATCHREVENUEBENEFITPCT
where BATCHREVENUEID = @BATCHREVENUEID
)