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 |