USP_DATAFORMTEMPLATE_EDITLOAD_GENERATEBATCHPROCESS

The load 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 used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@NAME	nvarchar(100)	INOUT	Name
@IDSETREGISTERID	uniqueidentifier	INOUT	Revenue selection
@BATCHTEMPLATEID	uniqueidentifier	INOUT	Batch template
@BATCHNUMBER	nvarchar(100)	INOUT	Batch number
@OVERRIDEBATCHNUMBER	bit	INOUT	Override
@DESCRIPTION	nvarchar(1000)	INOUT	Description
@OWNERID	uniqueidentifier	INOUT	Owner
@AUTOSAVEONROWCHANGE	bit	INOUT	Enable auto save
@PROJECTEDNUMBEROFRECORDS	int	INOUT	Projected #
@PROJECTEDTOTALAMOUNT	money	INOUT	Projected amount
@INCLUDEPOSTEDTRANSACTIONS	bit	INOUT	Include posted transactions
@ADJUSTMENTDATE	datetime	INOUT	Adjustment date
@ADJUSTMENTPOSTDATE	datetime	INOUT	Adjustment post date
@ADJUSTMENTPOSTSTATUSCODE	tinyint	INOUT	Adjustment post status
@ADJUSTMENTREASONCODEID	uniqueidentifier	INOUT	Adjustment reason
@ADJUSTMENTREASON	nvarchar(300)	INOUT	Adjustment details
@OVERWRITE	bit	INOUT	Filter selection and overwrite with new value
@FILTERBY	nvarchar(255)	INOUT	Filter by
@OLDGUIDVALUE	uniqueidentifier	INOUT	Current value
@NEWGUIDVALUE	uniqueidentifier	INOUT	Overwrite with
@OLDDATEVALUE	datetime	INOUT	Current value
@NEWDATEVALUE	datetime	INOUT	Overwrite with
@CANCHANGEBATCHNUMBERS	bit	INOUT
@REVENUERECORDTYPEID	uniqueidentifier	INOUT
@DISPLAYTOTALAMOUNT	bit	INOUT
@SITEID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GENERATEBATCHPROCESS
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @NAME nvarchar(100) = null output,
    @IDSETREGISTERID uniqueidentifier = null output,
    @BATCHTEMPLATEID uniqueidentifier = null output,
    @BATCHNUMBER nvarchar(100) = null output,
    @OVERRIDEBATCHNUMBER bit = null output,
    @DESCRIPTION nvarchar(1000) = null output,
    @OWNERID uniqueidentifier = null output,
    @AUTOSAVEONROWCHANGE bit = null output,
    @PROJECTEDNUMBEROFRECORDS int = null output,
    @PROJECTEDTOTALAMOUNT money = null output,
    @INCLUDEPOSTEDTRANSACTIONS bit = null output,
    @ADJUSTMENTDATE datetime = null output,
    @ADJUSTMENTPOSTDATE datetime = null output,
    @ADJUSTMENTPOSTSTATUSCODE tinyint = null output,
    @ADJUSTMENTREASONCODEID uniqueidentifier = null output,
    @ADJUSTMENTREASON nvarchar(300) = null output,
    @OVERWRITE bit = null output,
    @FILTERBY nvarchar(255) = null output,
    @OLDGUIDVALUE uniqueidentifier = null output,
    @NEWGUIDVALUE uniqueidentifier = null output,
    @OLDDATEVALUE datetime = null output,
    @NEWDATEVALUE datetime = null output,
    @CANCHANGEBATCHNUMBERS bit = null output,
    @REVENUERECORDTYPEID uniqueidentifier = null output,
    @DISPLAYTOTALAMOUNT bit = null output,
    @SITEID uniqueidentifier = null output
)
as

    set nocount on;

    set @DATALOADED = 0
    set @TSLONG = 0

    select
        @DATALOADED = 1,
        @NAME = GENERATEBATCHPROCESS.NAME,
        @IDSETREGISTERID = GENERATEBATCHPROCESS.IDSETREGISTERID,
        @BATCHTEMPLATEID = GENERATEBATCHPROCESS.BATCHTEMPLATEID,
        @BATCHNUMBER = GENERATEBATCHPROCESS.BATCHNUMBER,
        @OVERRIDEBATCHNUMBER = GENERATEBATCHPROCESS.OVERRIDEBATCHNUMBER,
        @DESCRIPTION = GENERATEBATCHPROCESS.DESCRIPTION,
        @OWNERID = GENERATEBATCHPROCESS.APPUSERID,
        @AUTOSAVEONROWCHANGE = GENERATEBATCHPROCESS.AUTOSAVEONROWCHANGE,
        @PROJECTEDNUMBEROFRECORDS = GENERATEBATCHPROCESS.PROJECTEDNUMBEROFRECORDS,
        @PROJECTEDTOTALAMOUNT = GENERATEBATCHPROCESS.PROJECTEDTOTALAMOUNT,
        @INCLUDEPOSTEDTRANSACTIONS = GENERATEBATCHPROCESS.INCLUDEPOSTEDTRANSACTIONS,
        @ADJUSTMENTDATE = GENERATEBATCHPROCESS.ADJUSTMENTDATE,
        @ADJUSTMENTPOSTDATE = GENERATEBATCHPROCESS.ADJUSTMENTPOSTDATE,
        @ADJUSTMENTPOSTSTATUSCODE = GENERATEBATCHPROCESS.ADJUSTMENTPOSTSTATUSCODE,
        @ADJUSTMENTREASONCODEID = GENERATEBATCHPROCESS.ADJUSTMENTREASONCODEID,
        @ADJUSTMENTREASON = GENERATEBATCHPROCESS.ADJUSTMENTREASON,
        @OVERWRITE = GENERATEBATCHPROCESS.OVERWRITE,
        @FILTERBY = GENERATEBATCHPROCESSOVERWRITE.FIELDNAME,
        @OLDGUIDVALUE = GENERATEBATCHPROCESSOVERWRITE.OLDGUIDVALUE,
        @NEWGUIDVALUE = GENERATEBATCHPROCESSOVERWRITE.NEWGUIDVALUE,
        @OLDDATEVALUE = GENERATEBATCHPROCESSOVERWRITE.OLDDATEVALUE,
        @NEWDATEVALUE = GENERATEBATCHPROCESSOVERWRITE.NEWDATEVALUE,
        @CANCHANGEBATCHNUMBERS = dbo.UFN_SECURITY_APPUSER_GRANTED_CHANGEBATCHNUMBER(@CURRENTAPPUSERID, BATCHTEMPLATEID),
        @DISPLAYTOTALAMOUNT = (
            select case when len(BATCHTYPECATALOG.AMOUNTCOLUMN) > 0 then 1 else 0 end
            from dbo.BATCHTEMPLATE 
            inner join dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
            where BATCHTEMPLATE.ID = GENERATEBATCHPROCESS.BATCHTEMPLATEID),
        @TSLONG = GENERATEBATCHPROCESS.TSLONG,
        @SITEID = BUSINESSPROCESSINSTANCE.SITEID
         from dbo.GENERATEBATCHPROCESS
            left join dbo.BUSINESSPROCESSINSTANCE on  BUSINESSPROCESSINSTANCE.BUSINESSPROCESSPARAMETERSETID = GENERATEBATCHPROCESS.ID
             and BUSINESSPROCESSINSTANCE.BUSINESSPROCESSCATALOGID = 'b226b0a0-043d-47bf-9dc4-6594ba5bbcbd'        
      left outer join dbo.GENERATEBATCHPROCESSOVERWRITE on GENERATEBATCHPROCESS.ID = GENERATEBATCHPROCESSOVERWRITE.GENERATEBATCHPROCESSID
        where GENERATEBATCHPROCESS.ID = @ID;

    select @REVENUERECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'REVENUE';

    return 0;