gl_period_KEY | int (4) | NOT NULL | Primary key |
gl_fiscal_year_KEY | int (4) | NOT NULL | The foreign key to the fiscal year |
start_date | smalldatetime (4) | NOT NULL | The start date of the period |
end_date | smalldatetime (4) | NOT NULL | The end date of the period |
gl_period_number | int (4) | NOT NULL | The GL period number uniquely identifies a period within a given fiscal year. Values start with 1 and continue up to the maximum number of periods defined by the fiscal year's periodicity. For example, a fiscal year with a Monthly periodicity would have GL period numbers from 1 through 12 and one with a Weekly periodicity would have numbers from 1 through 52. |