Table: dbo.Tax_Code_N_GL_Account | |||
Connects a tax code to the gl account for a specific year and unit. | |||
Columns | |||
Name | Type | Constraints | Description |
tax_code_n_gl_account_KEY | int (4) | NOT NULL | Primary Key. |
tax_code_KEY | int (4) | NOT NULL | Key to the Tax_Code table |
gl_account_KEY | int (4) | NOT NULL | Key to the GL_Account table |
code_year | int (4) | NOT NULL | Year this tax code is connected to the account |
unit | int (4) | Tax code unit |
Primary key | |||
Name | Columns | Description | |
PK_Tax_Code_N_GL_Account | tax_code_n_gl_account_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Tax_Code_N_GL_Account$gl_account_KEY$code_year | gl_account_KEY, code_year |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Tax_Code_N_GL_Account__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) | |
FK_Tax_Code_N_GL_Account__Tax_Code__tax_code_KEY | tax_code_KEY | Tax_Code (tax_code_KEY) |