UFN_REVENUELIFECYCLEREVENUECRITERIA_GETCRITERIA
Returns all of the revenue types to be used when calculating constituent lifecycle values.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUELIFECYCLECRITERIAID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_REVENUELIFECYCLEREVENUECRITERIA_GETCRITERIA
(
@REVENUELIFECYCLECRITERIAID uniqueidentifier
)
returns table
as
return
(
select
ID,
REVENUETYPECODE,
CONSIDERCLAIMEDAMOUNT
from
dbo.REVENUELIFECYCLEREVENUECRITERIA
where
REVENUELIFECYCLEREVENUECRITERIA.REVENUELIFECYCLECRITERIAID = @REVENUELIFECYCLECRITERIAID
)