UFN_WEALTHPOINT_GETBUILTIN_INCOMECOMPENSATION_SOURCES
Returns all built-in income/compensation wealth sources.
Return
Return Type |
---|
table |
Definition
Copy
create function dbo.UFN_WEALTHPOINT_GETBUILTIN_INCOMECOMPENSATION_SOURCES(
)
returns table
as return
select
null as ID,
WEALTHSOURCE.SOURCE
from
dbo.WEALTHSOURCE
left join dbo.WEALTHSOURCEMAPPING on
WEALTHSOURCE.ID = WEALTHSOURCEMAPPING.WEALTHSOURCEID
where
WEALTHSOURCEMAPPING.WEALTHTABLE='WPINCOMECOMPENSATION' and
WEALTHSOURCE.ISBUILTIN = 1