payroll_check_payroll_item_distribution_KEY | int (4) | NOT NULL | Primary key for the record. |
work_location_KEY | int (4) | NOT NULL | Parent client work location record. |
payroll_department_KEY | int (4) | | Optional associated payroll department. |
payroll_check_payroll_item_KEY | int (4) | NOT NULL | Parent payroll item |
amount_original | decimal (9, 2) | NOT NULL | Amount of item based on calculation rules. |
percentage | decimal (5, 2) | NOT NULL | percentage |
rate_original | decimal (9, 4) | NOT NULL | rate |
salary_hourly_rate | decimal (5, 4) | NOT NULL | salary_hourly_rate |
reg_hours | decimal (5, 4) | NOT NULL | reg_hours |
ot_hours | decimal (5, 4) | NOT NULL | ot_hours |
dt_hours | decimal (5, 4) | NOT NULL | dt_hours |
reg_amount | decimal (9, 2) | NOT NULL | reg_amount |
ot_amount | decimal (9, 2) | NOT NULL | ot_amount |
dt_amount | decimal (9, 2) | NOT NULL | dt_amount |
gl_ledger | nvarchar (16) | NOT NULL | gl_ledger |
is_primary_work_location | bit (1) | NOT NULL | Tells whether or not this particular distribution's work location was marked as primary when the check was created. |
pay_distribution_percent | decimal (5, 2) | NOT NULL | Describes what percentage of pay is allocated to this particular distribution. |
amount_override | decimal (9, 2) | | Overridden amount |
rate_override | decimal (9, 4) | | Overridden rate |
ot_rate | decimal (5, 4) | NOT NULL | rate used when calculating overtime pay related to this pay item distribution. |
dt_rate | decimal (5, 4) | NOT NULL | rate used when calculating double time pay related to this pay item distribution. |
liability__gl_account_KEY | int (4) | | 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. |
amount | decimal (9, 2) | NOT NULL | Display amount that is based on an existing override to this field. Will display the initially calculated amount if no override is present. |
rate | decimal (9, 4) | NOT NULL | Display rate that is based on an existing override to this field. Will display the initially calculated rate if no override is present. |