USP_DATALIST_MKTSOURCECODEPARTDEFINITIONS

Displays a list of the available source code part definitions.

Parameters

Parameter	Parameter Type	Mode	Description
@ITEMTYPECODE	tinyint	IN
@SYSTEMPART	bit	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTSOURCECODEPARTDEFINITIONS]
(
  @ITEMTYPECODE tinyint = null,
  @SYSTEMPART bit
)
as
  set nocount on;

  select 
    [ID],
    [NAME],
    [ITEMTYPECODE],
    [ITEMTYPE],
    [DESCRIPTION],
    [AUTOINCREMENTVALUE]
  from dbo.[MKTSOURCECODEPARTDEFINITION]
  where (@ITEMTYPECODE is null or [ITEMTYPECODE] = @ITEMTYPECODE)
  and (@SYSTEMPART is null or (@SYSTEMPART = 1 and [ITEMTYPECODE] <> 5) or (@SYSTEMPART = 0 and [ITEMTYPECODE] = 5));

  return 0;