USP_MKTLISTLAYOUT_GETFIELDS

CREATE procedure dbo.[USP_MKTLISTLAYOUT_GETFIELDS]
(
  @LISTLAYOUTID uniqueidentifier
)
as
  set nocount on;

  select
    [ID],
    [FIELDNAME],
    [OBJECTNAME],
    [SOURCENAME],
    [FRIENDLYNAME],
    [MAPPINGCODE],
    [DATATYPE],
    [SEQUENCE],
    [ISIDFIELD],
    [IDTYPECODE],
    [ALTERNATELOOKUPIDTYPECODEID]
  from dbo.[MKTLISTLAYOUTFIELD]
  where [LISTLAYOUTID] = @LISTLAYOUTID
  order by [SEQUENCE];

  return 0;