Table: dbo.Employee_Tax_Item
Columns
Name | Type | Constraints | Description
employee_tax_item_KEY | int (4) | NOT NULL | Primary key for this table
employee_KEY | int (4) | NOT NULL | Reference to employee
client_tax_item_KEY | int (4) | NOT NULL | Reference to client tax item
tax_calculation_status_KEY | nvarchar (38) | NOT NULL | Reference to calculation status
liability__gl_account_KEY | int (4) |  | Key to the gl_account table for liability account.
expense__gl_account_KEY | int (4) |  | Key to the gl_account table for expense account.

Primary key
Name | Columns | Description
PK_Employee_Tax_Item | employee_tax_item_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Tax_Item$client_tax_item_KEY$employee_KEY | client_tax_item_KEY, employee_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Tax_Item__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Client_Tax_Item (client_tax_item_KEY) |
FK_Employee_Tax_Item__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Employee_Tax_Item__GL_Account__expense__gl_account_KEY | expense__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Employee_Tax_Item__GL_Account__liability__gl_account_KEY | liability__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Employee_Tax_Item__Tax_Calculation_Status__tax_calculation_status_KEY | tax_calculation_status_KEY | Tax_Calculation_Status (tax_calculation_status_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payroll_Check_Tax_Item__Employee_Tax_Item__employee_tax_item_KEY | employee_tax_item_KEY | Payroll_Check_Tax_Item |
FK_Employee_Tax_Item_Distribution__Employee_Tax_Item__employee_tax_item_KEY | employee_tax_item_KEY | Employee_Tax_Item_Distribution |