Table: dbo.Tax_Code_M3_N_GL_Account
Connects an M3-A tax code to the gl account for a specific year.
Columns
NameTypeConstraintsDescription
tax_code_m3_n_gl_account_KEYint (4)NOT NULLPrimary Key.
tax_code_KEYint (4)NOT NULLKey to the Tax_Code table
gl_account_KEYint (4)NOT NULLKey to the GL_Account table
code_yearint (4)NOT NULLYear this M3 tax code is connected to the account
Primary key
NameColumnsDescription
PK_Tax_Code_M3_N_GL_Accounttax_code_m3_n_gl_account_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Code_M3_N_GL_Account$gl_account_KEY$code_yeargl_account_KEY, code_year
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Code_M3_N_GL_Account__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_Tax_Code_M3_N_GL_Account__Tax_Code__tax_code_KEYtax_code_KEYTax_Code (tax_code_KEY)

Schema diagram