| 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) | |