The job_num field should match the datatype in the source table. ie, it should be an int, and it should not be null, correct.
for your audit table you want another field to be the primary key.. ie. audit_ID int identity(1,1)
That way you have an incremental record but can still put the audit information into your table.