Table: dbo.GL_Account_Budget_Category_Name_Override
This table records the override name for client budget buckets
Columns
NameTypeConstraintsDescription
gl_account_budget_category_name_override_KEYint (4)NOT NULLPrimary key.
client_KEYint (4)NOT NULLThe associated client. the foreigh key to Client table
gl_account_budget_category_KEYint (4)NOT NULLThe associated budget type. the foreigh key to GL_Account_Budget_Category table
description_overridenvarchar (60)NOT NULLThe override name for the budget bucket for the client.
Primary key
NameColumnsDescription
PK_GL_Account_Budget_Category_Name_Overridegl_account_budget_category_name_override_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Budget_Category_Name_Override$client_KEY$description_overrideclient_KEY, description_override
UK_GL_Account_Budget_Category_Name_Override$client_KEY$gl_account_budget_category_KEYclient_KEY, gl_account_budget_category_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Budget_Category_Name_Override__Client__client_KEYclient_KEYClient (client_KEY)
FK_GL_Account_Budget_Category_Name_Override__GL_Account_Budget_Category__gl_account_budget_category_KEYgl_account_budget_category_KEYGL_Account_Budget_Category (gl_account_budget_category_KEY)

Schema diagram