Table CustomPickJob

DDL

create sequence seqCustomPickJob as bigint start with 1;
create sequence seqCustomPickJobJobID as bigint start with 1;

create table CustomPickJob (
   cpjID pointer not null default next value for seqCustomPickJob,
   cpjCreatedOn datetime not null default sysdatetime(),
   cpjCreatedByFK pointer not null,
   cpjChangedOn datetime not null default sysdatetime(),
   cpjChangedByFK pointer not NULL,
   cpjJobID bigint not NULL,
   cpjLocationFK pointer Not null,
   cpjStockCode varchar(2) not null,
   cpjExpiryDate datetime,
   cpjLotNo dbo.Name not null default '',
   CONSTRAINT pkCustomPickJob PRIMARY key (cpjID)
 );

Index on cpjJOBID

No conversion needed, temp table.