Table: dbo.Employee_Tax_Item
Columns
NameTypeConstraintsDescription
employee_tax_item_KEYint (4)NOT NULLPrimary key for this table
employee_KEYint (4)NOT NULLReference to employee
client_tax_item_KEYint (4)NOT NULLReference to client tax item
tax_calculation_status_KEYnvarchar (38)NOT NULLReference to calculation status
liability__gl_account_KEYint (4)Key to the gl_account table for liability account.
expense__gl_account_KEYint (4)Key to the gl_account table for expense account.
Primary key
NameColumnsDescription
PK_Employee_Tax_Itememployee_tax_item_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Tax_Item$client_tax_item_KEY$employee_KEYclient_tax_item_KEY, employee_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Tax_Item__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYClient_Tax_Item (client_tax_item_KEY)
FK_Employee_Tax_Item__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_Tax_Item__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYGL_Account (gl_account_KEY)
FK_Employee_Tax_Item__GL_Account__liability__gl_account_KEYliability__gl_account_KEYGL_Account (gl_account_KEY)
FK_Employee_Tax_Item__Tax_Calculation_Status__tax_calculation_status_KEYtax_calculation_status_KEYTax_Calculation_Status (tax_calculation_status_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Check_Tax_Item__Employee_Tax_Item__employee_tax_item_KEYemployee_tax_item_KEYPayroll_Check_Tax_Item
FK_Employee_Tax_Item_Distribution__Employee_Tax_Item__employee_tax_item_KEYemployee_tax_item_KEYEmployee_Tax_Item_Distribution

Schema diagram