USP_SIMPLEDATALIST_STANDINGORDERSBATCHTEMPLATEBYUSER

A list of revenue batch templates available for the current user.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_STANDINGORDERSBATCHTEMPLATEBYUSER
                (
                    @CURRENTAPPUSERID uniqueidentifier
                ) 
                as
                    select distinct 
                        BATCHTEMPLATE.ID as VALUE, 
                        BATCHTEMPLATE.NAME as LABEL 
                    from 
                        dbo.BATCHTEMPLATE
                        left join dbo.BATCHTYPECATALOG
                            on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
                    where 
                        dbo.UFN_SECURITY_APPUSER_GRANTED_BATCHPROCESSOR(@CURRENTAPPUSERID, BATCHTEMPLATE.ID) = 1 
                        and BATCHTEMPLATE.CUSTOM = 0 
                        and ACTIVE = 1
                        and BATCHTYPECATALOG.CATEGORY = 'REVENUE'
                        and (dbo.UFN_CONDITIONSETTING_EVALUATEEXISTSCONDITION('Multicurrency') = 0 or BATCHTYPECATALOG.NAME != 'Revenue Batch')
                    order by LABEL;