| Table: dbo.Employee_Tax_Item_Distribution | |||
| Table that supports multiple GL accounts for work location/payroll department combinations (for Employee_Tax_Item). | |||
| Columns | |||
| Name | Type | Constraints | Description |
| employee_tax_item_distribution_KEY | int (4) | NOT NULL | Primary key for this table. |
| employee_tax_item_KEY | int (4) | NOT NULL | |
| employee_work_location_payroll_department_KEY | int (4) | NOT NULL | Foreign key to the Employee_Work_Location_Payroll_Department table. This table houses the a given Employee's work location/payroll departments. |
| liability__gl_account_KEY | int (4) | Optional liability gl account for this work location/payroll department combination | |
| expense__gl_account_KEY | int (4) | Optional expense gl account for this work location/payroll department combination | |
| Primary key | |||
| Name | Columns | Description | |
| PK_Employee_Tax_Item_Distribution | employee_tax_item_distribution_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Employee_Tax_Item_Distribution$employee_tax_item_KEY$employee_work_location_payroll_department_KEY | employee_tax_item_KEY, employee_work_location_payroll_department_KEY | ||