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