Table: dbo.GL_Period
Columns
NameTypeConstraintsDescription
gl_period_KEYint (4)NOT NULLPrimary key
gl_fiscal_year_KEYint (4)NOT NULLThe foreign key to the fiscal year
start_datesmalldatetime (4)NOT NULLThe start date of the period
end_datesmalldatetime (4)NOT NULLThe end date of the period
gl_period_numberint (4)NOT NULLThe 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
NameColumnsDescription
PK_GL_Periodgl_period_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Period__GL_Fiscal_Year__gl_fiscal_year_KEYgl_fiscal_year_KEYGL_Fiscal_Year (gl_fiscal_year_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Non_Posting_Payroll_Transaction_GL_Period__GL_Period__gl_period_KEYgl_period_KEYNon_Posting_Payroll_Transaction_GL_Period
FK_Engagement_Binder__GL_Period__gl_period_KEYgl_period_KEYEngagement_Binder
FK_GL_Period_Key_Old_To_New_Map__GL_Period__new__gl_period_KEYnew__gl_period_KEYGL_Period_Key_Old_To_New_Map
FK_Transaction_Template__GL_Period__next_recurrence__gl_period_KEYnext_recurrence__gl_period_KEYTransaction_Template
FK_GL_Transaction__GL_Period__gl_period_KEYgl_period_KEYGL_Transaction
FK_Client_Consolidation_Option__GL_Period__consolidation_period_end__gl_period_KEYconsolidation_period_end__gl_period_KEYClient_Consolidation_Option
FK_Client_Consolidation_Option__GL_Period__consolidation_period_start__gl_period_KEYconsolidation_period_start__gl_period_KEYClient_Consolidation_Option
FK_Import_Template_Column_GL_Account_Data__GL_Period__gl_period_KEYgl_period_KEYImport_Template_Column_GL_Account_Data
FK_GL_Account_Tickmark__GL_Period__gl_period_KEYgl_period_KEYGL_Account_Tickmark
FK_Journal_Entry_Template__GL_Period__first_period__gl_period_KEYfirst_period__gl_period_KEYJournal_Entry_Template
FK_Client_GL_Setup__GL_Period__accountant__current__gl_period_KEYaccountant__current__gl_period_KEYClient_GL_Setup
FK_Client_GL_Setup__GL_Period__accountant__earliest_open__gl_period_KEYaccountant__earliest_open__gl_period_KEYClient_GL_Setup
FK_Client_GL_Setup__GL_Period__accountant__latest_selected__gl_period_KEYaccountant__latest_selected__gl_period_KEYClient_GL_Setup
FK_Client_GL_Setup__GL_Period__client__current__gl_period_KEYclient__current__gl_period_KEYClient_GL_Setup
FK_Client_GL_Setup__GL_Period__client__earliest_open__gl_period_KEYclient__earliest_open__gl_period_KEYClient_GL_Setup
FK_Client_GL_Setup__GL_Period__client__latest_selected__gl_period_KEYclient__latest_selected__gl_period_KEYClient_GL_Setup
FK_GL_Account_Budget__GL_Period__gl_period_KEYgl_period_KEYGL_Account_Budget
FK_GL_Account_Workpaper_Reference__GL_Period__gl_period_KEYgl_period_KEYGL_Account_Workpaper_Reference
FK_Pending_AP_Payment__GL_Period__gl_period_KEYgl_period_KEYPending_AP_Payment
FK_Bank_Feeds_Retrieved_Transaction__GL_Period__gl_period_KEYgl_period_KEYBank_Feeds_Retrieved_Transaction

Schema diagram