UFN_PDACCOUNT_CUSTOMSEGEMENTTABLESUPPORTSREVENUEBATCH

Determines if the given account segment supports revenue batch validation.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@PDACCOUNTTABLESAVAILABLEFORSEGMENTTABLEID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_PDACCOUNT_CUSTOMSEGEMENTTABLESUPPORTSREVENUEBATCH
            (
                @PDACCOUNTTABLESAVAILABLEFORSEGMENTTABLEID uniqueidentifier
            )
            returns bit
            with execute as caller
            as begin
                declare @RETVAL bit = 0;

                -- For a given PDACCOUNTTABLESAVAILABLEFORSEGMENTTABLEID return 1 if it is supported in batch.


                -- The example below is for a segment ID that should never exist

                if (@PDACCOUNTTABLESAVAILABLEFORSEGMENTTABLEID = '00000000-0000-0000-0000-000000000000')
                    set @RETVAL = 1;

                return @RETVAL;
            end