UFN_PLANNEDGIFTLETTERCODE_GETOUTPUTFORMATS

Returns a list of planned gift letter codes with their output formats.

Return

Return Type
table

Definition

Copy



create function dbo.UFN_PLANNEDGIFTLETTERCODE_GETOUTPUTFORMATS()
returns table
as
    return select ID, QUERYVIEWID from dbo.PLANNEDGIFTLETTERCODE WHERE ISACTIVE = 1
                        and IDSETREGISTERID is not null;