Table: dbo.Year_End_Close_Option
The table contains the options a client has used to perform the year end close process for a fiscal year.
Columns
NameTypeConstraintsDescription
carry_forward_tickmarksbit (1)NOT NULLWhether or not the user would like to carry forward the tickmarcs from one year to another.
carry_forward_workpaper_referencesbit (1)NOT NULLWhether or not the user would like to carry forward the workpaper references from one year to another.
delete_inactive_accountsbit (1)NOT NULLWhether or not the user would like to delete the inactive accounts from one year to another.
zero_account_balancesbit (1)NOT NULLWhether or not the user would like to zero account balances from one year to another.
gl_fiscal_year_KEYint (4)NOT NULLPrimary key, it also points to the fiscal year that these options belong to.
year_end_close_budget_amount_treatment_KEYint (4)NOT NULLThe foreign key pointing to the treatment of budget amounts within these options.
close_accounts_by_segmentbit (1)NOT NULLWhether or not to close year end based on segment.
Primary key
NameColumnsDescription
PK_Year_End_Close_Option$gl_fiscal_year_KEYgl_fiscal_year_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Year_End_Close_Option__GL_Fiscal_Year__gl_fiscal_year_KEYgl_fiscal_year_KEYGL_Fiscal_Year (gl_fiscal_year_KEY)
FK_Year_End_Close_Option__Year_End_Close_Budget_Amount_Treatment__year_end_close_budget_amount_treatment_KEYyear_end_close_budget_amount_treatment_KEYYear_End_Close_Budget_Amount_Treatment (year_end_close_budget_amount_treatment_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Year_End_Close_Net_Income_Distribution__Year_End_Close_Option__gl_fiscal_year_KEYgl_fiscal_year_KEYYear_End_Close_Net_Income_Distribution
FK_Year_End_Close_Balance_Sheet_Account_Distribution__Year_End_Close_Option__gl_fiscal_year_KEYgl_fiscal_year_KEYYear_End_Close_Balance_Sheet_Account_Distribution

Schema diagram