USP_DATALIST_GLPERIODS

Returns a list of fiscal periods for a fiscal year.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



      CREATE procedure dbo.USP_DATALIST_GLPERIODS
        ( @ID uniqueidentifier )
        as
        set nocount on;

          select
            ID,
            SEQUENCE [SEQUENCE],
            STARTDATE [STARTDATE],
            ENDDATE [ENDDATE],
            CLOSED [CLOSED]
          from dbo.GLFISCALPERIOD 
          where
          GLFISCALYEARID = @ID
          Order by [SEQUENCE];