| 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 | ||