UFN_BATCH_ENFORCETOTALMATCHING

Returns true if a batch must enforce totals before committing.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_BATCH_ENFORCETOTALMATCHING
            (
                @BATCHID uniqueidentifier
            )
            returns bit
            as
            begin
                declare @R bit;
                select @R = coalesce(BATCHWORKFLOWSTATE.ENFORCETOTALMATCHING, 0)
                from dbo.BATCH 
                inner join dbo.BATCHWORKFLOWSTATE on BATCHWORKFLOWSTATE.ID = BATCH.BATCHWORKFLOWSTATEID 
                where BATCH.ID=@BATCHID;

                return @R;
            end