-- MySQL dump 10.14  Distrib 5.5.60-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: cuccprep_planprepago33
-- ------------------------------------------------------
-- Server version	5.5.60-MariaDB-1~trusty

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `impuestos_federales`
--

DROP TABLE IF EXISTS `impuestos_federales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `impuestos_federales` (
  `id_impuesto_federal` tinyint(3) unsigned NOT NULL,
  `impuesto` varchar(50) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `tasa` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL,
  `tasa_cfdi` varchar(10) COLLATE utf8_spanish_ci DEFAULT NULL,
  `clave_impuesto` enum('001','002','003') COLLATE utf8_spanish_ci NOT NULL DEFAULT '001',
  `tipo` enum('retencion','traslado') COLLATE utf8_spanish_ci DEFAULT NULL,
  `factor` enum('Tasa','Cuota','Exento') COLLATE utf8_spanish_ci NOT NULL DEFAULT 'Tasa'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `impuestos_federales`
--

LOCK TABLES `impuestos_federales` WRITE;
/*!40000 ALTER TABLE `impuestos_federales` DISABLE KEYS */;
INSERT INTO `impuestos_federales` VALUES (2,'IVA 16%','16.00','0.160000','002','traslado','Tasa'),(3,'IVA EXENTO','0','0.000000','002','traslado','Exento'),(4,'IEPS 3%','3.00','0.300000','003','traslado','Tasa'),(5,'IEPS 7%','7.00','0.070000','003','traslado','Tasa'),(6,'IEPS 8%','8.00','0.080000','003','traslado','Tasa'),(7,'IEPS 9%','9.00','0.090000','003','traslado','Tasa'),(8,'RET IVA 4%','4.00','0.040000','002','retencion','Tasa'),(9,'RET IVA 10.66667%','10.6667','0.106667','002','retencion','Tasa'),(10,'RET ISR 10%','10.00','0.100000','001','retencion','Tasa'),(13,'IVA 0%','0','0.000000','002','traslado','Tasa'),(14,'IEPS 2.65%','2.65','0.265000','003','traslado','Tasa'),(15,'IEPS 5.3%','5.3','0.530000','003','traslado','Tasa'),(16,'IEPS 5%','5.00','0.500000','003','traslado','Tasa'),(17,'IEPS 3.04%','3.04','0.304000 ','003','traslado','Tasa'),(18,'IEPS 160%','1.60','1.600000','003','traslado','Tasa'),(19,'IEPS CUOTA 0.35',NULL,'0.350000','003','traslado','Cuota'),(20,'IEPS CUOTA 0.059100',NULL,'0.059100','003','traslado','Cuota'),(21,'IEPS CUOTA 3.00',NULL,'3.000000','003','traslado','Cuota'),(22,'IEPS CUOTA 0.2988',NULL,'0.298800','003','traslado','Cuota'),(23,'ISR',NULL,NULL,'003','retencion','Tasa'),(24,'RET IVA 16%','16.00','0.160000','002','retencion','Tasa'),(25,'RET IVA 6%','6.00','0.060000','002','retencion','Tasa'),(26,'RET IVA 5%','5.00','0.050000','002','retencion','Tasa'),(27,'IVA 8%','8.00','0.080000','002','traslado','Tasa'),(28,'RET ISR 1.25%','1.25','0.012500','001','retencion','Tasa');
/*!40000 ALTER TABLE `impuestos_federales` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-01-03 21:25:34
