UFN_WEALTHPOINT_GETBUILTIN_NONPROFITAFFILIATION_SOURCES
Returns all built-in securities wealth sources.
Return
Return Type |
---|
table |
Definition
Copy
create function dbo.UFN_WEALTHPOINT_GETBUILTIN_NONPROFITAFFILIATION_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='WPNONPROFITAFFILIATION' and
WEALTHSOURCE.ISBUILTIN = 1