USP_DATALIST_MKTLISTLAYOUTLISTCONSTITUENTFILEIMPORT_FIELDLIST

CREATE procedure dbo.[USP_DATALIST_MKTLISTLAYOUTLISTCONSTITUENTFILEIMPORT_FIELDLIST]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select
    [MKTLISTLAYOUT].[ID],
    case when [MKTLISTLAYOUTFIELD].[MAPPINGCODE] = 2 then 'RES:check' else 'RES:close' end as [MAPPINGTYPE],
    [MKTLISTLAYOUTFIELD].[IDTYPECODE],
    case when [MKTLISTLAYOUTFIELD].[ISIDFIELD] = 1 
      -- If the ID field is alternate lookup ID, then display the actual alternate lookup ID type used.

      then case when [MKTLISTLAYOUTFIELD].[IDTYPECODE] = 2 
        then (select [DESCRIPTION] from dbo.[ALTERNATELOOKUPIDTYPECODE] where [ID] = [MKTLISTLAYOUTFIELD].[ALTERNATELOOKUPIDTYPECODEID])
        else [MKTLISTLAYOUTFIELD].[IDTYPE] end 
      else '' end as [IDTYPE],
    [MKTLISTLAYOUTFIELD].[FRIENDLYNAME],
    [MKTLISTLAYOUT].[NAME],
    [MKTLISTLAYOUTFIELD].[SOURCENAME],
    [MKTLISTLAYOUTFIELD].[SEQUENCE]
  from dbo.[MKTLISTLAYOUT]
  inner join dbo.[MKTLISTLAYOUTFIELD] on [MKTLISTLAYOUTFIELD].[LISTLAYOUTID] = [MKTLISTLAYOUT].[ID]
  where [MKTLISTLAYOUT].[ID] = @ID
  order by [MKTLISTLAYOUTFIELD].[SEQUENCE];

  return 0;