USP_DATALIST_UNCOMMITTEDMERCHANDISEINVENTORYBATCH

Parameters

Parameter	Parameter Type	Mode
@CURRENTAPPUSERID	uniqueidentifier	IN
@BATCHDESIGNID	uniqueidentifier	IN
@OWNER	uniqueidentifier	IN
@SITEFILTERMODE	tinyint	IN
@SITESSELECTED	xml	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN
@NUMDAYS	int	IN
@ONLYEXCEPTIONBATCHES	bit	IN

Definition

Copy



CREATE procedure dbo.USP_DATALIST_UNCOMMITTEDMERCHANDISEINVENTORYBATCH
(
  @CURRENTAPPUSERID uniqueidentifier,
  @BATCHDESIGNID uniqueidentifier = null,
  @OWNER uniqueidentifier = null,
  @SITEFILTERMODE tinyint = 0,
  @SITESSELECTED xml = null,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null,
  @NUMDAYS int = 7,
  @ONLYEXCEPTIONBATCHES bit = 0
)
with execute as owner
as
    declare @SPECIFICBATCHTYPEID uniqueidentifier = '54955e1c-ab7b-485b-bdd9-aa36d26a9821' -- Merchandise Inventory Batch


    exec dbo.USP_DATALIST_OPENBATCHES_2
        @CURRENTAPPUSERID,
        @BATCHDESIGNID, 
        '', --CATEGORY

        @OWNER,
        @SITEFILTERMODE,
        @SITESSELECTED,
        @SECURITYFEATUREID,
        @SECURITYFEATURETYPE,
        @SPECIFICBATCHTYPEID,
        @NUMDAYS,
        @ONLYEXCEPTIONBATCHES;