USP_DATALIST_MKTSOURCECODEITEMFORMAT

Displays a list of source code formats for a given item type.

Parameters

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

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTSOURCECODEITEMFORMAT]
(
  @ITEMTYPECODE tinyint,
  @ISACTIVE bit = 1
)
as
  set nocount on;

  select 
    [NAME]   as [Source Code],
    [FORMAT] as [Format],
    [SAMPLE] as [Sample],
    [NOTES]  as [Notes],
    [REGEX]  as [RegEx],
    [LENGTH] as [Length]
  from dbo.[UFN_MKTSOURCECODEITEMFORMAT_GETDATALIST](@ITEMTYPECODE, @ISACTIVE);

  return 0;