Table: dbo.Payroll_Check_Tax_Item_Distribution
Columns
Name | Type | Constraints | Description
payroll_check_tax_item_distribution_KEY | int (4) | NOT NULL | Primary key for this table
payroll_check_tax_item_KEY | int (4) | NOT NULL | Reference to payroll check tax item
work_location_KEY | int (4) | NOT NULL | Reference to work location
payroll_department_KEY | int (4) |  | Reference to payroll department
amount_original | decimal (9, 2) | NOT NULL | Distribution amount
gross_subject_wages_original | decimal (9, 2) | NOT NULL | Original gross subject wages amount as it was initially calculated
subject_wages_original | decimal (9, 2) | NOT NULL | Original subject wages amount as it was initially calculated
tax_rate | decimal (5, 6) | NOT NULL | Rate used to calculate tax amount at time of calculation.
tax_limit | decimal (9, 2) | NOT NULL | Limit of tax item at time of calculation.
amount_override | decimal (9, 2) |  | Overridden amount
liability__gl_account_KEY | int (4) | NOT NULL | Key to the gl_account table for the liability account.
expense__gl_account_KEY | int (4) |  | Key to the gl_account table for the expense account.
subject_wages_override | decimal (9, 2) |  | Optional user override of the original subject wages amount
gross_subject_wages_override | decimal (9, 2) |  | Optional user override of the original gross subject wages amount
amount | decimal (9, 2) | NOT NULL | Amount of distribution, either amount_override if not null otherwise amount_original.
gross_subject_wages | decimal (9, 2) | NOT NULL | Display gross subject wages that is based on an existing override to this field. Will display the initially calculated gross subject wages if no override is present.
subject_wages | decimal (9, 2) | NOT NULL | Display subject wages that is based on an existing override to this field. Will display the initially calculated subject wages if no override is present.

Primary key
Name | Columns | Description
PK_Payroll_Check_Tax_Item_Distribution | payroll_check_tax_item_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Tax_Item_Distribution__GL_Account__expense__gl_account_KEY | expense__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Payroll_Check_Tax_Item_Distribution__GL_Account__liability__gl_account_KEY | liability__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Payroll_Check_Tax_Item_Distribution__Payroll_Check_Tax_Item__payroll_check_tax_item_KEY | payroll_check_tax_item_KEY | Payroll_Check_Tax_Item (payroll_check_tax_item_KEY) |
FK_Payroll_Check_Tax_Item_Distribution__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Payroll_Department (payroll_department_KEY) |
FK_Payroll_Check_Tax_Item_Distribution__Work_Location__work_location_KEY | work_location_KEY | Work_Location (work_location_KEY) |