Table: dbo.Payroll_Check_Tax_Item_Import | |||
List of imported tax items associated with a template column. | |||
Columns | |||
Name | Type | Constraints | Description |
payroll_check_tax_item_import_KEY | int (4) | NOT NULL | Primary key for this table. |
client_KEY | int (4) | NOT NULL | Client key for this table. |
client_pay_schedule_KEY | int (4) | NOT NULL | Client pay schedule key for this table. |
client_pay_schedule_detail_KEY | int (4) | NOT NULL | Client pay schedule detail key for this table. |
employee_KEY | int (4) | NOT NULL | Employee key for this table. |
employee_work_location_payroll_department_KEY | int (4) | NOT NULL | Employee work location payroll department key for this table. |
amount | decimal (9, 2) | NOT NULL | Tax item amount for this table. |
client_tax_item_KEY | int (4) | NOT NULL | The key of the related client tax item. |
provisional_marker | nvarchar (200) | If set, indicates the record is not ready for processing into a check. Records with the same value belong to the same batch of provisional items. |
Primary key | |||
Name | Columns | Description | |
PK_Payroll_Check_Tax_Item_Import | payroll_check_tax_item_import_KEY |