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