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