UFN_MKTSOURCECODEITEMFORMAT_GETDATALIST

Returns a table of source code formats for a given item type.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ITEMTYPECODE	tinyint	IN
@ISACTIVE	bit	IN

Definition

Copy



CREATE function dbo.[UFN_MKTSOURCECODEITEMFORMAT_GETDATALIST]
(
  @ITEMTYPECODE tinyint,
  @ISACTIVE bit = 1
)
returns table
as
  return (
    select 
      [MKTSOURCECODE].[NAME],
      [MKTSOURCECODEPARTDEFINITIONVALUES].[FORMAT],
      [MKTSOURCECODEPARTDEFINITIONVALUES].[SAMPLE],
      [MKTSOURCECODEPARTDEFINITIONVALUES].[DESCRIPTION] as [NOTES],
      [MKTSOURCECODEPARTDEFINITIONVALUES].[REGEX],
      [MKTSOURCECODEPARTDEFINITIONVALUES].[LENGTH]
    from 
      dbo.[MKTSOURCECODE]
      inner join dbo.[MKTSOURCECODEITEM] on [MKTSOURCECODEITEM].[SOURCECODEID] = [MKTSOURCECODE].[ID]
      inner join dbo.[MKTSOURCECODEVALIDPARTVALUES] on [MKTSOURCECODEVALIDPARTVALUES].[MKTSOURCECODEITEMID] = [MKTSOURCECODEITEM].[ID]
      inner join dbo.[MKTSOURCECODEPARTDEFINITIONVALUES] on [MKTSOURCECODEPARTDEFINITIONVALUES].[ID] = [MKTSOURCECODEVALIDPARTVALUES].[MKTSOURCECODEPARTDEFINITIONVALUESID]
      inner join dbo.[MKTSOURCECODEPARTDEFINITION] on [MKTSOURCECODEPARTDEFINITION].[ID] = [MKTSOURCECODEITEM].[MKTSOURCECODEPARTDEFINITIONID]
    where ([MKTSOURCECODEPARTDEFINITION].[ITEMTYPECODE] = @ITEMTYPECODE or @ITEMTYPECODE is null) 
      and ([MKTSOURCECODE].[ISACTIVE] = @ISACTIVE or @ISACTIVE is null)
  );