UFN_REVENUE_CONSTITUENTREVENUEHISTORYDETAIL
Returns the appropriate value for the Detail column of the Constituent Revenue History List for a given revenue row.
Return
| Return Type |
|---|
| nvarchar(1024) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_REVENUE_CONSTITUENTREVENUEHISTORYDETAIL(
@REVENUEID uniqueidentifier
)
returns nvarchar(1024)
with execute as caller
as begin
declare @DETAIL nvarchar(1024);
select @DETAIL = dbo.UDA_BUILDLIST(distinct dbo.UFN_REVENUESPLIT_CONSTITUENTREVENUEHISTORYDETAIL(REVENUESPLIT.ID,REVENUESPLIT.APPLICATIONCODE,REVENUESPLIT.TYPECODE,REVENUESPLIT.DESIGNATIONID))
from dbo.REVENUE
inner join dbo.REVENUESPLIT on REVENUESPLIT.REVENUEID = REVENUE.ID
where REVENUE.ID = @REVENUEID;
return @DETAIL;
end