Table: dbo.GL_Period
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_GL_Period | gl_period_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_GL_Period__GL_Fiscal_Year__gl_fiscal_year_KEY | gl_fiscal_year_KEY | GL_Fiscal_Year (gl_fiscal_year_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Non_Posting_Payroll_Transaction_GL_Period__GL_Period__gl_period_KEY | gl_period_KEY | Non_Posting_Payroll_Transaction_GL_Period |
FK_Engagement_Binder__GL_Period__gl_period_KEY | gl_period_KEY | Engagement_Binder |
FK_GL_Period_Key_Old_To_New_Map__GL_Period__new__gl_period_KEY | new__gl_period_KEY | GL_Period_Key_Old_To_New_Map |
FK_Transaction_Template__GL_Period__next_recurrence__gl_period_KEY | next_recurrence__gl_period_KEY | Transaction_Template |
FK_GL_Transaction__GL_Period__gl_period_KEY | gl_period_KEY | GL_Transaction |
FK_Client_Consolidation_Option__GL_Period__consolidation_period_end__gl_period_KEY | consolidation_period_end__gl_period_KEY | Client_Consolidation_Option |
FK_Client_Consolidation_Option__GL_Period__consolidation_period_start__gl_period_KEY | consolidation_period_start__gl_period_KEY | Client_Consolidation_Option |
FK_Import_Template_Column_GL_Account_Data__GL_Period__gl_period_KEY | gl_period_KEY | Import_Template_Column_GL_Account_Data |
FK_GL_Account_Tickmark__GL_Period__gl_period_KEY | gl_period_KEY | GL_Account_Tickmark |
FK_Journal_Entry_Template__GL_Period__first_period__gl_period_KEY | first_period__gl_period_KEY | Journal_Entry_Template |
FK_Client_GL_Setup__GL_Period__accountant__current__gl_period_KEY | accountant__current__gl_period_KEY | Client_GL_Setup |
FK_Client_GL_Setup__GL_Period__accountant__earliest_open__gl_period_KEY | accountant__earliest_open__gl_period_KEY | Client_GL_Setup |
FK_Client_GL_Setup__GL_Period__accountant__latest_selected__gl_period_KEY | accountant__latest_selected__gl_period_KEY | Client_GL_Setup |
FK_Client_GL_Setup__GL_Period__client__current__gl_period_KEY | client__current__gl_period_KEY | Client_GL_Setup |
FK_Client_GL_Setup__GL_Period__client__earliest_open__gl_period_KEY | client__earliest_open__gl_period_KEY | Client_GL_Setup |
FK_Client_GL_Setup__GL_Period__client__latest_selected__gl_period_KEY | client__latest_selected__gl_period_KEY | Client_GL_Setup |
FK_GL_Account_Budget__GL_Period__gl_period_KEY | gl_period_KEY | GL_Account_Budget |
FK_GL_Account_Workpaper_Reference__GL_Period__gl_period_KEY | gl_period_KEY | GL_Account_Workpaper_Reference |
FK_Pending_AP_Payment__GL_Period__gl_period_KEY | gl_period_KEY | Pending_AP_Payment |
FK_Bank_Feeds_Retrieved_Transaction__GL_Period__gl_period_KEY | gl_period_KEY | Bank_Feeds_Retrieved_Transaction |