USP_DATALIST_COMMITTEDMEMBERSHIPDUES_BATCH
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@CURRENTAPPUSERID | 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_COMMITTEDMEMBERSHIPDUES_BATCH
(
@CURRENTAPPUSERID uniqueidentifier
, @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 = '196a2540-005a-4547-91a7-b301c464e28c' -- Membership Dues Batch
exec USP_DATALIST_COMMITTEDBATCHES_2
@CURRENTAPPUSERID,
@NUMDAYS,
null, --BatchDesign
'', --Category
@INCLUDEDELETED,
@SITEFILTERMODE,
@SITESSELECTED,
@SECURITYFEATUREID,
@SECURITYFEATURETYPE,
@SPECIFICBATCHTYPEID;