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