Please see that I have corrected one of the values for the inserts. (last but one)

Insert into #t1

Values (4,5,'Debit' ,'1/5/16', 40,Null)