UFN_LETTERCODE_GETOUTPUTFORMATS

Returns a list of letter codes with their output formats.

Return

Return Type
table

Definition

Copy



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