USP_DATAFORMTEMPLATE_EDIT_GENERATEBATCHPROCESS

The save procedure used by the edit dataform template "Generate Batch Process Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@IDSETREGISTERID	uniqueidentifier	IN	Revenue selection
@BATCHTEMPLATEID	uniqueidentifier	IN	Batch template
@BATCHNUMBER	nvarchar(100)	IN	Batch number
@OVERRIDEBATCHNUMBER	bit	IN	Override
@DESCRIPTION	nvarchar(1000)	IN	Description
@OWNERID	uniqueidentifier	IN	Owner
@AUTOSAVEONROWCHANGE	bit	IN	Enable auto save
@PROJECTEDNUMBEROFRECORDS	int	IN	Projected #
@PROJECTEDTOTALAMOUNT	money	IN	Projected amount
@INCLUDEPOSTEDTRANSACTIONS	bit	IN	Include posted transactions
@ADJUSTMENTDATE	datetime	IN	Adjustment date
@ADJUSTMENTPOSTDATE	datetime	IN	Adjustment post date
@ADJUSTMENTPOSTSTATUSCODE	tinyint	IN	Adjustment post status
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN	Adjustment reason
@ADJUSTMENTREASON	nvarchar(300)	IN	Adjustment details
@OVERWRITE	bit	IN	Filter selection and overwrite with new value
@FILTERBY	nvarchar(255)	IN	Filter by
@OLDGUIDVALUE	uniqueidentifier	IN	Current value
@NEWGUIDVALUE	uniqueidentifier	IN	Overwrite with
@OLDDATEVALUE	datetime	IN	Current value
@NEWDATEVALUE	datetime	IN	Overwrite with

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_GENERATEBATCHPROCESS
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @IDSETREGISTERID uniqueidentifier,
    @BATCHTEMPLATEID uniqueidentifier,
    @BATCHNUMBER nvarchar(100),
    @OVERRIDEBATCHNUMBER bit,
    @DESCRIPTION nvarchar(1000),
    @OWNERID uniqueidentifier,
    @AUTOSAVEONROWCHANGE bit,
    @PROJECTEDNUMBEROFRECORDS int,
    @PROJECTEDTOTALAMOUNT money,
    @INCLUDEPOSTEDTRANSACTIONS bit,
    @ADJUSTMENTDATE datetime,
    @ADJUSTMENTPOSTDATE datetime,
    @ADJUSTMENTPOSTSTATUSCODE tinyint,
    @ADJUSTMENTREASONCODEID uniqueidentifier,
    @ADJUSTMENTREASON nvarchar(300),
    @OVERWRITE bit,
    @FILTERBY nvarchar(255),
    @OLDGUIDVALUE uniqueidentifier,
    @NEWGUIDVALUE uniqueidentifier,
    @OLDDATEVALUE datetime,
    @NEWDATEVALUE datetime
)

as
  set nocount on;

    declare @SITEID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GENERATEBATCHPROCESS
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @SITEID = @SITEID output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_GENERATEBATCHPROCESS_2
        @ID,
        @CURRENTAPPUSERID,
        @CHANGEAGENTID,
        @NAME,
        @IDSETREGISTERID,
        @BATCHTEMPLATEID,
        @BATCHNUMBER,
        @OVERRIDEBATCHNUMBER,
        @DESCRIPTION,
        @OWNERID,
        @AUTOSAVEONROWCHANGE,
        @PROJECTEDNUMBEROFRECORDS,
        @PROJECTEDTOTALAMOUNT,
        @INCLUDEPOSTEDTRANSACTIONS,
        @ADJUSTMENTDATE,
        @ADJUSTMENTPOSTDATE,
        @ADJUSTMENTPOSTSTATUSCODE,
        @ADJUSTMENTREASONCODEID,
        @ADJUSTMENTREASON,
        @OVERWRITE,
        @FILTERBY,
        @OLDGUIDVALUE,
        @NEWGUIDVALUE,
        @OLDDATEVALUE,
        @NEWDATEVALUE,
        @SITEID;

  return 0;