UFN_PAPERLESSMANDATES_DAYSADVANCEDNOTICE_FORREVENUE

Returns the number of days of advance notice if paperless mandates are enabled for a given revenue.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PAPERLESSMANDATES_DAYSADVANCEDNOTICE_FORREVENUE(@REVENUEID uniqueidentifier = null)
            returns integer
            with execute as caller
            as begin
                declare @DAYSADVANCEDNOTICE integer;

                select distinct 
                    @DAYSADVANCEDNOTICE = dbo.UFN_PAPERLESSMANDATES_DAYSADVANCEDNOTICE_FORSITE(SITEID)
                from
                    dbo.UFN_SITEID_MAPFROM_REVENUEID(@REVENUEID)

                -- Something is really wrong. Set enabled to error state.

                if @@ROWCOUNT > 1
                    set @DAYSADVANCEDNOTICE = -1;

                return @DAYSADVANCEDNOTICE
            end