USP_DATALIST_UNCOMMITTEDMEMBERSHIPDUES_BATCH

Parameters

Parameter	Parameter Type	Mode
@CURRENTAPPUSERID	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_UNCOMMITTEDMEMBERSHIPDUES_BATCH
(
  @CURRENTAPPUSERID uniqueidentifier,
  @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 = '196A2540-005A-4547-91A7-B301C464E28C' -- Membership Dues Batch


    exec USP_DATALIST_OPENBATCHES_2
        @CURRENTAPPUSERID,
        null, --BATCHDESIGN (template)

        '', --CATEGORY

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