Table: dbo.GL_Account_Budget
This table records the budget and its amount for a gl_account in a gl_period
Columns
NameTypeConstraintsDescription
gl_account_budget_KEYint (4)NOT NULLPrimary key.
gl_account_KEYint (4)NOT NULLThe associated gl_account. the foreigh key to GL_Account table
gl_period_KEYint (4)NOT NULLThe associated gl_period. the foreigh key to GL_Period table
gl_account_budget_category_KEYint (4)NOT NULLThe type of GL Account Budget Category for this budget. the foreigh key to GL_Account_Budget_Category table
amountdecimal (9, 2)NOT NULLBudget Amountfor this budget record
Primary key
NameColumnsDescription
PK_GL_Account_Budgetgl_account_budget_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Budget$gl_account_KEY$gl_account_budget_category_KEY$gl_period_KEYgl_account_KEY, gl_account_budget_category_KEY, gl_period_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Budget__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_GL_Account_Budget__GL_Account_Budget_Category__gl_account_budget_category_KEYgl_account_budget_category_KEYGL_Account_Budget_Category (gl_account_budget_category_KEY)
FK_GL_Account_Budget__GL_Period__gl_period_KEYgl_period_KEYGL_Period (gl_period_KEY)

Schema diagram