Table: dbo.Payroll_Check_Number_Import
List of check numbers associated with a template column. This table will hold check numbers for imported payroll checks prior to check creation
Columns
Name | Type | Constraints | Description
payroll_check_number_import_KEY | int (4) | NOT NULL | Primary key for this table.
check_number | nvarchar (32) | NOT NULL | Check number for this table. This is the check number to be used on the imported check.
employee_id | nvarchar (22) | NOT NULL | Employee id for this table. Used to look up the check number for the appropriate check being created.
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_Number_Import | payroll_check_number_import_KEY |