| Table: dbo.Tax_Code_M3_N_GL_Account | |||
| Connects an M3-A tax code to the gl account for a specific year. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| tax_code_m3_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 M3 tax code is connected to the account |
| Primary key | |||
| Name | Columns | Description | |
| PK_Tax_Code_M3_N_GL_Account | tax_code_m3_n_gl_account_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Tax_Code_M3_N_GL_Account$gl_account_KEY$code_year | gl_account_KEY, code_year | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Tax_Code_M3_N_GL_Account__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) | |
| FK_Tax_Code_M3_N_GL_Account__Tax_Code__tax_code_KEY | tax_code_KEY | Tax_Code (tax_code_KEY) | |