drop table configuracionabt;

CREATE TABLE IF NOT EXISTS `configuracionabt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hoja` int(11) DEFAULT NULL,
  `nombreConf` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `agrupacion` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `idEntidad` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `distribuidora` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `poliza` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `contratoPS` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `segmentoABC` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `tarifaAcceso` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `domicilio` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `cp` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `distrito` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `cups13` varchar(13) COLLATE utf8_spanish_ci DEFAULT NULL,
  `cups22` varchar(22) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pc1` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pc2` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pc3` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pc4` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pc5` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pc6` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pd1` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pd2` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pd3` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pd4` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pd5` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pd6` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `nContador` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `rContador` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `cPotencia` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `estado` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `numeroFactura` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `fechaEmision` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `numeroFacturaAgrupada` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `fechaEmisionAgrupada` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `periodoFacturacionDesde` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `periodoFacturacionHasta` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoActiva1` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoActiva2` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoActiva3` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoActiva4` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoActiva5` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoActiva6` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoActivaTotal` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoReactiva1` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoReactiva2` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoReactiva3` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoReactiva4` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoReactiva5` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `consumoReactiva6` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `reactivaAFacturarP1` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `reactivaAFacturarP2` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `potenciaMaxRegistrada` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `importeActiva` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `importeReactiva` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `totalSinIVA` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `IVA` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `totalConIva` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `precioMedioPotencia` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ptep1` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ptep2` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ptep3` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ptep4` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ptep5` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ptep6` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ptme` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pter` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `precioPotencia1` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `precioPotencia2` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `precioPotencia3` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `precioPotencia4` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `precioPotencia5` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `precioPotencia6` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `baseImpuestoElectrico` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `cteBaseImpuestoElectrico` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `baseDescuento` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `numeroMeses` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `excesoP1` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `excesoP2` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `excesoP3` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `excesoP4` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `excesoP5` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `excesoP6` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `descuento` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `concepto1` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=1 ;