UFN_MKTLISTLAYOUT_GETLAYOUTFIELDS

CREATE function dbo.[UFN_MKTLISTLAYOUT_GETLAYOUTFIELDS]
(
  @LISTLAYOUTID uniqueidentifier
)
/*
Returns a table of all list layout fields for a corresponding list layout.
*/
returns table
as
  return
  (
    select
      [MKTLISTLAYOUTFIELD].[ID],
      [MKTLISTLAYOUTFIELD].[FIELDNAME],
      [MKTLISTLAYOUTFIELD].[SOURCENAME],
      [MKTLISTLAYOUTFIELD].[OBJECTNAME],
      [MKTLISTLAYOUTFIELD].[FRIENDLYNAME],
      [MKTLISTLAYOUTFIELD].[MAPPINGCODE],
      [MKTLISTLAYOUTFIELD].[DATATYPE],
      [MKTLISTLAYOUTFIELD].[SEQUENCE]
    from
      dbo.[MKTLISTLAYOUTFIELD]
    where
      [MKTLISTLAYOUTFIELD].[LISTLAYOUTID] = @LISTLAYOUTID
  );