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
NameTypeConstraintsDescription
payroll_check_number_import_KEYint (4)NOT NULLPrimary key for this table.
check_numbernvarchar (32)NOT NULLCheck number for this table. This is the check number to be used on the imported check.
employee_idnvarchar (22)NOT NULLEmployee id for this table. Used to look up the check number for the appropriate check being created.
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_Number_Importpayroll_check_number_import_KEY

Schema diagram