CREATE TABLE `tmpnegreport` (
  `id_tmp` int(20) NOT NULL auto_increment,
  `manufCateg` char(3) collate latin1_general_ci NOT NULL,
  `mnf_name` varchar(50) collate latin1_general_ci NOT NULL,
  `OfficeName` varchar(50) collate latin1_general_ci NOT NULL,
  `negStartDate` datetime NOT NULL,
  `difStartDate` int(10) NOT NULL,
  `maximo00` datetime NOT NULL,
  `difStatusDate` int(10) NOT NULL,
  `LANOTAMAXIMA` text collate latin1_general_ci NOT NULL,
  `ngtStatus` char(3) collate latin1_general_ci NOT NULL,
  `ngtBuyer` varchar(50) collate latin1_general_ci NOT NULL,
  `ngtCode` int(20) NOT NULL,
  `procurCode` varchar(50) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id_tmp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;