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
Name | Type | Constraints | Description
carry_forward_tickmarks | bit (1) | NOT NULL | Whether or not the user would like to carry forward the tickmarcs from one year to another.
carry_forward_workpaper_references | bit (1) | NOT NULL | Whether or not the user would like to carry forward the workpaper references from one year to another.
delete_inactive_accounts | bit (1) | NOT NULL | Whether or not the user would like to delete the inactive accounts from one year to another.
zero_account_balances | bit (1) | NOT NULL | Whether or not the user would like to zero account balances from one year to another.
gl_fiscal_year_KEY | int (4) | NOT NULL | Primary key, it also points to the fiscal year that these options belong to.
year_end_close_budget_amount_treatment_KEY | int (4) | NOT NULL | The foreign key pointing to the treatment of budget amounts within these options.
close_accounts_by_segment | bit (1) | NOT NULL | Whether or not to close year end based on segment.

Primary key
Name | Columns | Description
PK_Year_End_Close_Option$gl_fiscal_year_KEY | gl_fiscal_year_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Year_End_Close_Option__GL_Fiscal_Year__gl_fiscal_year_KEY | gl_fiscal_year_KEY | GL_Fiscal_Year (gl_fiscal_year_KEY) |
FK_Year_End_Close_Option__Year_End_Close_Budget_Amount_Treatment__year_end_close_budget_amount_treatment_KEY | year_end_close_budget_amount_treatment_KEY | Year_End_Close_Budget_Amount_Treatment (year_end_close_budget_amount_treatment_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Year_End_Close_Net_Income_Distribution__Year_End_Close_Option__gl_fiscal_year_KEY | gl_fiscal_year_KEY | Year_End_Close_Net_Income_Distribution |
FK_Year_End_Close_Balance_Sheet_Account_Distribution__Year_End_Close_Option__gl_fiscal_year_KEY | gl_fiscal_year_KEY | Year_End_Close_Balance_Sheet_Account_Distribution |