Tables

Following are the tables structures:

TABLE INDICES
------------------

CREATE TABLE `indices` (
  `DocumentID` int(11) NOT NULL default '0',
  `Id_base_datos` int(11) NOT NULL default '0',
  `Numero_Documento` char(20) character set latin1 collate latin1_spanish_ci default NULL,
  `Fecha_Contabilidad` char(10) character set latin1 collate latin1_spanish_ci default NULL,
  `Numero_Anulacion` decimal(18,0) default NULL,
  `Fecha_Anulacion` char(10) character set latin1 collate latin1_spanish_ci default NULL,
  `Archivo` decimal(18,0) default NULL,
  `Modulo` char(2) character set latin1 collate latin1_spanish_ci default NULL,
  `Entrepano` char(2) character set latin1 collate latin1_spanish_ci default NULL,
  `Fecha_digitalizado` char(10) character set latin1 collate latin1_spanish_ci default NULL,
  `Digitalizado_por` char(50) character set latin1 collate latin1_spanish_ci default NULL,
  `Numero_de_Caja` int(11) default NULL,
  `Anio` int(11) default NULL,
  `estatus` char(1) character set latin1 collate latin1_spanish_ci NOT NULL default '',
  KEY `index_1` (`DocumentID`,`Id_base_datos`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




Table SAP:
----------------

CREATE TABLE `sap` (
  `no_Doc` varchar(20) collate utf8_spanish_ci default NULL,
  `fecha` varchar(20) collate utf8_spanish_ci default NULL,
  KEY `no_Doc` (`no_Doc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;