USP_DATALIST_COMMITTEDMERCHANDISEINVENTORYBATCH

Parameters

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

Definition

Copy



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


    exec USP_DATALIST_COMMITTEDBATCHES_2
        @CURRENTAPPUSERID,
        @NUMDAYS,
        @BATCHDESIGNID,
        '',                                    --Category

        @INCLUDEDELETED,
        @SITEFILTERMODE,
        @SITESSELECTED,
        @SECURITYFEATUREID,
        @SECURITYFEATURETYPE,
        @SPECIFICBATCHTYPEID;