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
            )