UFN_GLFISCALYEAR_PERIODS

Returns a fiscal years's periods.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@GLFISCALYEARID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_GLFISCALYEAR_PERIODS(@GLFISCALYEARID uniqueidentifier)
            returns table
            as return
            SELECT ID, SEQUENCE, STARTDATE, ENDDATE, CLOSED 
            FROM GLFISCALPERIOD
            WHERE GLFISCALYEARID = @GLFISCALYEARID