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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Tax_Item_Import__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Payroll_Check_Tax_Item_Import__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Client_Pay_Schedule (client_pay_schedule_KEY) |
FK_Payroll_Check_Tax_Item_Import__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Client_Pay_Schedule_Detail (client_pay_schedule_detail_KEY) |
FK_Payroll_Check_Tax_Item_Import__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Payroll_Check_Tax_Item_Import__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_department_KEY | employee_work_location_payroll_department_KEY | Employee_Work_Location_Payroll_Department (employee_work_location_payroll_department_KEY) |
FK_Payroll_Check_Tax_Item_Import__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Client_Tax_Item (client_tax_item_KEY) |