Table: dbo.Payroll_Check_Tax_Item_Import
List of imported tax items associated with a template column.
Columns
NameTypeConstraintsDescription
payroll_check_tax_item_import_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4)NOT NULLClient key for this table.
client_pay_schedule_KEYint (4)NOT NULLClient pay schedule key for this table.
client_pay_schedule_detail_KEYint (4)NOT NULLClient pay schedule detail key for this table.
employee_KEYint (4)NOT NULLEmployee key for this table.
employee_work_location_payroll_department_KEYint (4)NOT NULLEmployee work location payroll department key for this table.
amountdecimal (9, 2)NOT NULLTax item amount for this table.
client_tax_item_KEYint (4)NOT NULLThe key of the related client tax item.
provisional_markernvarchar (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
NameColumnsDescription
PK_Payroll_Check_Tax_Item_Importpayroll_check_tax_item_import_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Tax_Item_Import__Client__client_KEYclient_KEYClient (client_KEY)
FK_Payroll_Check_Tax_Item_Import__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYClient_Pay_Schedule (client_pay_schedule_KEY)
FK_Payroll_Check_Tax_Item_Import__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYClient_Pay_Schedule_Detail (client_pay_schedule_detail_KEY)
FK_Payroll_Check_Tax_Item_Import__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Payroll_Check_Tax_Item_Import__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_department_KEYemployee_work_location_payroll_department_KEYEmployee_Work_Location_Payroll_Department (employee_work_location_payroll_department_KEY)
FK_Payroll_Check_Tax_Item_Import__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYClient_Tax_Item (client_tax_item_KEY)

Schema diagram