Table: dbo.Year_End_Close_Budget_Amount_Treatment
The table enumerates the different treatments available to the year end close process for initializing the budget amounts in the new fiscal year.
Columns
NameTypeConstraintsDescription
year_end_close_budget_amount_treatment_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (60)NOT NULLDescription of the year end close budget treatments.
Primary key
NameColumnsDescription
PK_Year_End_Close_Budget_Amount_Treatmentyear_end_close_budget_amount_treatment_KEY
Unique constraints
NameColumnsDescription
UK_Year_End_Close_Budget_Amount_Treatment$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
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_Option

Schema diagram