UFN_NAMEFORMATPARAMETER_GETORGADDRESSEES

Returns the organization addressee options for the given name format parameter.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@NAMEFORMATPARAMETERID	uniqueidentifier	IN

Definition

Copy




            create function dbo.UFN_NAMEFORMATPARAMETER_GETORGADDRESSEES
            (
                @NAMEFORMATPARAMETERID uniqueidentifier
            )
            returns table
            as
                return(select
                    ID,
                    coalesce(NAMEFORMATTYPECODEID, cast(N'00000000-0000-0000-0000-000000000001' as uniqueidentifier)) NAMEFORMATTYPECODEID,
                    ADDRESSEEFORMATISPRIMARY,
                    SEQUENCE
                from dbo.NAMEFORMATPARAMETERORGADDRESSEE
                where NAMEFORMATPARAMETERID = @NAMEFORMATPARAMETERID)