Table: dbo.GL_Account_Budget_Category_Name_Override | |||
This table records the override name for client budget buckets | |||
Columns | |||
Name | Type | Constraints | Description |
gl_account_budget_category_name_override_KEY | int (4) | NOT NULL | Primary key. |
client_KEY | int (4) | NOT NULL | The associated client. the foreigh key to Client table |
gl_account_budget_category_KEY | int (4) | NOT NULL | The associated budget type. the foreigh key to GL_Account_Budget_Category table |
description_override | nvarchar (60) | NOT NULL | The override name for the budget bucket for the client. |
Primary key | |||
Name | Columns | Description | |
PK_GL_Account_Budget_Category_Name_Override | gl_account_budget_category_name_override_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_GL_Account_Budget_Category_Name_Override$client_KEY$description_override | client_KEY, description_override | ||
UK_GL_Account_Budget_Category_Name_Override$client_KEY$gl_account_budget_category_KEY | client_KEY, gl_account_budget_category_KEY |