Table: dbo.Payroll_Check_Payroll_Item | |||
Columns | |||
Name | Type | Constraints | Description |
payroll_check_payroll_item_KEY | int (4) | NOT NULL | Key of the payroll check payroll item |
bank_transaction_KEY | int (4) | NOT NULL | Key of parent payroll check |
employee_payroll_item_KEY | int (4) | Key of parent employee payroll item | |
client_payroll_item_KEY | int (4) | NOT NULL | Key of parent client payroll item |
description | nvarchar (60) | NOT NULL | Description of Payroll_Check_Payroll_Item record. |
payroll_item_calculation_type_KEY | int (4) | NOT NULL | Calculation type. |
is_hours_sensitive | bit (1) | Indicates if item is hours-sensitive | |
is_excluded_from_gross_pay_amount | bit (1) | Indicates if item amount is excluded from gross pay | |
is_excluded_net_pay | bit (1) | Indicates if item is excluded from net pay | |
vendor_KEY | int (4) | Associated vendor for payroll payable generation. In the case of Child Support and Creditor Garnishment a null vendor key is used as there may be multiple vendors. | |
liability__gl_account_KEY | int (4) | Key to the gl_account table for liability account. | |
expense__gl_account_KEY | int (4) | Key to the gl_account table for expense account. | |
is_exclude_premium_wages | bit (1) | Indicates that the payroll item should calculate assuming 1.0 as both the OT and DT multipliers when excluding wages. | |
is_excluded_from_gross_pay_hours | bit (1) | NOT NULL | Indicates if item hours are excluded from gross pay |
Primary key | |||
Name | Columns | Description | |
PK_Payroll_Check_Payroll_Item | payroll_check_payroll_item_KEY |