USP_DATAFORMTEMPLATE_PRELOAD_BATCH

The load procedure used by the edit dataform template "Batch Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DISPLAYTOTALAMOUNT	bit	INOUT
@CANCHANGEBATCHNUMBERS	bit	INOUT	Can change batch numbers
@PROJECTEDTOTALAMOUNTDECIMAL	decimal(19, 4)	INOUT	Projected amount

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_BATCH
(                    
    @CURRENTAPPUSERID uniqueidentifier,
    @DISPLAYTOTALAMOUNT bit = null output,
    @CANCHANGEBATCHNUMBERS bit = null output,
    @PROJECTEDTOTALAMOUNTDECIMAL decimal(19,4) = null output
)
as

    set nocount on;

    set @DISPLAYTOTALAMOUNT=0;

    select top 1
        @DISPLAYTOTALAMOUNT = 1
    from
        dbo.BATCHTEMPLATE
        inner join BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
    where
        (len(BATCHTYPECATALOG.AMOUNTCOLUMN) > 0)
        and (dbo.UFN_SECURITY_APPUSER_GRANTED_BATCHPROCESSOR(@CURRENTAPPUSERID, BATCHTEMPLATE.ID) = 1);

    set @CANCHANGEBATCHNUMBERS = dbo.UFN_SECURITY_APPUSER_GRANTED_CHANGEBATCHNUMBER(@CURRENTAPPUSERID, null);


    return 0;