Table: dbo.Employee_Worker_Compensation_Item_Distribution | |||
Holds the distribution of employee worker compensation items across multiple work locations | |||
Columns | |||
Name | Type | Constraints | Description |
employee_worker_compensation_item_distribution_KEY | int (4) | NOT NULL | Primary key for this table. |
employee_worker_compensation_item_KEY | int (4) | NOT NULL | Key to employee worker compensation item table. |
employee_work_location_payroll_department_KEY | int (4) | NOT NULL | Key to employee work location payroll department table. |
liability__gl_account_KEY | int (4) | Key to the gl_account for liability account to be used on liability checks. If null, the amount will be undistributed. | |
expense__gl_account_KEY | int (4) | Key to the gl_account for expense account to be used on liability checks. If null, the amount will be undistributed. | |
is_active | bit (1) | NOT NULL | Indicator of whether this distribution is marked as active |
Primary key | |||
Name | Columns | Description | |
PK_Employee_Worker_Compensation_Item_Distribution | employee_worker_compensation_item_distribution_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Employee_Worker_Compensation_Item_Distribution$employee_worker_compensation_item_KEY$employee_work_location_payroll_departmen | employee_worker_compensation_item_KEY, employee_work_location_payroll_department_KEY |