UFN_WEALTHPOINT_GETBUILTIN_PHILANTHROPICGIFT_SOURCES
Return
Return Type |
---|
table |
Definition
Copy
create function dbo.UFN_WEALTHPOINT_GETBUILTIN_PHILANTHROPICGIFT_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='WPPHILANTROPICGIFT' and
WEALTHSOURCE.ISBUILTIN = 1
)