Table: dbo.GL_Fiscal_Year
Columns
NameTypeConstraintsDescription
gl_fiscal_year_KEYint (4)NOT NULLPrimary key
client_KEYint (4)NOT NULLThe foreign key to the client table
start_datesmalldatetime (4)NOT NULLThe start date of the fiscal year
end_datesmalldatetime (4)NOT NULLThe end date of the fiscal year
gl_period_countint (4)NOT NULLThe number of periods in the fiscal year.
gl_period_type_KEYint (4)NOT NULLThe General Ledger period frequency type of the fiscal year.
Primary key
NameColumnsDescription
PK_GL_Fiscal_Yeargl_fiscal_year_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Fiscal_Year__Client__client_KEYclient_KEYClient (client_KEY)
FK_GL_Fiscal_Year__GL_Period_Type__gl_period_type_KEYgl_period_type_KEYGL_Period_Type (gl_period_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_GL_Period__GL_Fiscal_Year__gl_fiscal_year_KEYgl_fiscal_year_KEYGL_Period
FK_Year_End_Close_Option__GL_Fiscal_Year__gl_fiscal_year_KEYgl_fiscal_year_KEYYear_End_Close_Option

Schema diagram