-- MySQL dump 10.13  Distrib 5.7.12, for Win32 (AMD64)
--
-- Host: localhost    Database: circle_k
-- ------------------------------------------------------
-- Server version	5.7.10-log

/*!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 `catsat_monedas`
--

DROP TABLE IF EXISTS `catsat_monedas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catsat_monedas` (
  `CATSAT_MonedasID` varchar(50) NOT NULL DEFAULT '0',
  `ClaveMoneda` varchar(50) DEFAULT NULL,
  `Descripcion` varchar(100) DEFAULT NULL,
  `Decimales` int(11) DEFAULT '0',
  `PorcentajeVariacion` decimal(24,6) DEFAULT '0.000000',
  `InternalVersion` int(11) DEFAULT '0',
  `Activo` tinyint(4) DEFAULT '0',
  `Predeterminado` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`CATSAT_MonedasID`),
  UNIQUE KEY `ClaveMoneda` (`ClaveMoneda`),
  KEY `WDIDX_CATSAT_Monedas_Activo` (`Activo`),
  KEY `WDIDX_CATSAT_Monedas_Predeterminado` (`Predeterminado`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `catsat_monedas`
--

LOCK TABLES `catsat_monedas` WRITE;
/*!40000 ALTER TABLE `catsat_monedas` DISABLE KEYS */;
INSERT INTO `catsat_monedas` VALUES ('100006','MXN','Peso Mexicano',2,0.352742,2,1,1),('10006','AZN','Azerbaijanian Manat',2,0.352742,2,0,0),('1006','AED','Dirham de EAU',2,0.352742,2,0,0),('101006','MXV','Mexico Unidad de Inversion UDI',2,0.352742,2,0,0),('102006','MYR','Ringgit malayo',2,0.266974,2,0,0),('103006','MZN','Mozambique Metical',2,0.352742,2,0,0),('104006','NAD','Dolar de Namibia',2,0.352742,2,0,0),('105006','NGN','Naira',2,0.309794,2,0,0),('106006','NIO','Cordoba Oro',2,0.352742,2,0,0),('107006','NOK','Corona noruega',2,0.339457,2,0,0),('108006','NPR','Rupia nepali',2,0.352742,2,0,0),('109006','NZD','Dolar de Nueva Zelanda',2,0.447641,2,0,0),('110006','OMR','Rial omani',3,0.352742,2,0,0),('11006','BAM','Convertibles marca',2,0.352742,2,0,0),('111006','PAB','Balboa',2,0.352742,2,0,0),('112006','PEN','Nuevo Sol',2,0.288885,2,0,0),('113006','PGK','Kina',2,0.352742,2,0,0),('114006','PHP','Peso filipino',2,0.295977,2,0,0),('115006','PKR','Rupia de Pakistan',2,0.352742,2,0,0),('116006','PLN','Zloty',2,0.386493,2,0,0),('117006','PYG','Guarani',0,0.365790,2,0,0),('118006','QAR','Qatar Rial',2,0.352742,2,0,0),('119006','RON','Leu rumano',2,0.358811,2,0,0),('120006','RSD','Dinar serbio',2,0.352742,2,0,0),('12006','BBD','Dolar de Barbados',2,0.352742,2,0,0),('121006','RUB','Rublo ruso',2,0.351896,2,0,0),('122006','RWF','Franco ruandes',0,0.352742,2,0,0),('123006','SAR','Riyal saudi',2,0.351728,2,0,0),('124006','SBD','Dolar de las Islas Salomon',2,0.352742,2,0,0),('125006','SCR','Rupia de Seychelles',2,0.352742,2,0,0),('126006','SDG','Libra sudanesa',2,0.352742,2,0,0),('127006','SEK','Corona sueca',2,0.384312,2,0,0),('128006','SGD','Dolar De Singapur',2,0.353932,2,0,0),('129006','SHP','Libra de Santa Helena',2,0.352742,2,0,0),('130006','SLL','Leona',2,0.352742,2,0,0),('13006','BDT','Taka',2,0.352742,2,0,0),('131006','SOS','Chelin somali',2,0.352742,2,0,0),('132006','SRD','Dolar de Suriname',2,0.352742,2,0,0),('133006','SSP','Libra sudanesa Sur',2,0.352742,2,0,0),('134006','STD','Dobra',2,0.352742,2,0,0),('135006','SVC','Colon El Salvador',2,0.352742,2,0,0),('136006','SYP','Libra Siria',2,0.352742,2,0,0),('137006','SZL','Lilangeni',2,0.352742,2,0,0),('138006','THB','Baht',2,0.371799,2,0,0),('139006','TJS','Somoni',2,0.352742,2,0,0),('140006','TMT','Turkmenistan nuevo manat',2,0.352742,2,0,0),('14006','BGN','Lev bulgaro',2,0.352742,2,0,0),('141006','TND','Dinar tunecino',3,0.352742,2,0,0),('142006','TOP','Pa anga',2,0.352742,2,0,0),('143006','TRY','Lira turca',2,0.353389,2,0,0),('144006','TTD','Dolar de Trinidad y Tobago',2,0.285293,2,0,0),('145006','TWD','Nuevo dolar de Taiwan',2,0.300870,2,0,0),('146006','TZS','Shilling tanzano',2,0.352742,2,0,0),('147006','UAH','Hryvnia',2,0.508387,2,0,0),('148006','UGX','Shilling de Uganda',0,0.352742,2,0,0),('149006','USD','Dolar americano',2,0.352742,2,1,0),('150006','USN','Dolar estadounidense dia siguiente',2,0.352742,2,0,0),('15006','BHD','Dinar de Bahrein',3,0.352742,2,0,0),('151006','UYI','Peso Uruguay en Unidades Indexadas URUIURUI',0,0.352742,2,0,0),('152006','UYU','Peso Uruguayo',2,0.317871,2,0,0),('153006','UZS','Uzbekistan Sum',2,0.352742,2,0,0),('154006','VEF','Bolivar',2,1.527712,2,0,0),('155006','VND','Dong',0,0.300618,2,0,0),('156006','VUV','Vatu',0,0.352742,2,0,0),('157006','WST','Tala',2,0.352742,2,0,0),('158006','XAF','Franco CFA BEAC',0,0.352742,2,0,0),('159006','XAG','Plata',0,0.352742,2,0,0),('160006','XAU','Oro',0,0.352742,2,0,0),('16006','BIF','Burundi Franc',0,0.352742,2,0,0),('161006','XBA','Unidad de Mercados de Bonos Unidad Europea Composite EURCO',0,0.352742,2,0,0),('162006','XBB','Unidad Monetaria de Bonos de Mercados Unidad Europea UEM-6',0,0.352742,2,0,0),('163006','XBC','Mercados de Bonos Unidad Europea unidad de cuenta a 9 UCE-9',0,0.352742,2,0,0),('164006','XBD','Mercados de Bonos Unidad Europea unidad de cuenta a 17 UCE-17',0,0.352742,2,0,0),('165006','XCD','Dolar del Caribe Oriental',2,0.352742,2,0,0),('166006','XDR','DEG Derechos Especiales de Giro',0,0.368134,2,0,0),('167006','XOF','Franco CFA BCEAO',0,0.352742,2,0,0),('168006','XPD','Paladio',0,0.352742,2,0,0),('169006','XPF','Franco CFP',0,0.352742,2,0,0),('170006','XPT','Platino',0,0.352742,2,0,0),('17006','BMD','Dolar de Bermudas',2,0.352742,2,0,0),('171006','XSU','Sucre',0,0.352742,2,0,0),('172006','XTS','Codigos reservados especificamente para propositos de prueba',0,0.000000,2,0,0),('173006','XUA','Unidad ADB de Cuenta',0,0.352742,2,0,0),('174006','XXX','Los codigos asignados para las transacciones en que intervenga ninguna moneda',0,0.000000,2,0,0),('175006','YER','Rial yemeni',2,0.352742,2,0,0),('176006','ZAR','Rand',2,0.540141,2,0,0),('177006','ZMW','Kwacha zambiano',2,0.352742,2,0,0),('178006','ZWL','Zimbabwe Dolar',2,0.352742,2,0,0),('18006','BND','Dolar de Brunei',2,0.352742,2,0,0),('19006','BOB','Boliviano',2,0.353625,2,0,0),('20006','BOV','Mvdol',2,0.352742,2,0,0),('2006','AFN','Afghani',2,0.352742,2,0,0),('21006','BRL','Real brasileno',2,0.509556,2,0,0),('22006','BSD','Dolar de las Bahamas',2,0.352742,2,0,0),('23006','BTN','Ngultrum',2,0.352742,2,0,0),('24006','BWP','Pula',2,0.352742,2,0,0),('25006','BYR','Rublo bielorruso',0,0.352742,2,0,0),('26006','BZD','Dolar de Belice',2,0.362980,2,0,0),('27006','CAD','Dolar Canadiense',2,0.314944,2,0,0),('28006','CDF','Franco congoleno',2,0.352742,2,0,0),('29006','CHE','WIR Euro',2,0.352742,2,0,0),('30006','CHF','Franco Suizo',2,0.494670,2,0,0),('3006','ALL','Lek',2,0.352742,2,0,0),('31006','CHW','Franc WIR',2,0.352742,2,0,0),('32006','CLF','Unidad de Fomento',4,0.352742,2,0,0),('33006','CLP','Peso chileno',0,0.446787,2,0,0),('34006','CNY','Yuan Renminbi',2,0.277565,2,0,0),('35006','COP','Peso Colombiano',2,0.332249,2,0,0),('36006','COU','Unidad de Valor real',2,0.352742,2,0,0),('37006','CRC','Colon costarricense',2,0.311959,2,0,0),('38006','CUC','Peso Convertible',2,0.352742,2,0,0),('39006','CUP','Peso Cubano',2,0.362980,2,0,0),('40006','CVE','Cabo Verde Escudo',2,0.352742,2,0,0),('4006','AMD','Dram armenio',2,0.352742,2,0,0),('41006','CZK','Corona checa',2,0.416334,2,0,0),('42006','DJF','Franco de Djibouti',0,0.352742,2,0,0),('43006','DKK','Corona danesa',2,0.398751,2,0,0),('44006','DOP','Peso Dominicano',2,0.508079,2,0,0),('45006','DZD','Dinar argelino',2,0.303263,2,0,0),('46006','EGP','Libra egipcia',2,0.340492,2,0,0),('47006','ERN','Nakfa',2,0.352742,2,0,0),('48006','ETB','Birr etiope',2,0.352742,2,0,0),('49006','EUR','Euro',2,0.396721,2,0,0),('50006','FJD','Dolar de Fiji',2,0.354644,2,0,0),('5006','ANG','Florin antillano neerlandes',2,0.352742,2,0,0),('51006','FKP','Libra malvinense',2,0.352742,2,0,0),('52006','GBP','Libra Esterlina',2,0.287970,2,0,0),('53006','GEL','Lari',2,0.352742,2,0,0),('54006','GHS','Cedi de Ghana',2,0.352742,2,0,0),('55006','GIP','Libra de Gibraltar',2,0.352742,2,0,0),('56006','GMD','Dalasi',2,0.352742,2,0,0),('57006','GNF','Franco guineano',0,0.352742,2,0,0),('58006','GTQ','Quetzal',2,0.356532,2,0,0),('59006','GYD','Dolar guyanes',2,0.351785,2,0,0),('60006','HKD','Dolar De Hong Kong',2,0.353162,2,0,0),('6006','AOA','Kwanza',2,0.352742,2,0,0),('61006','HNL','Lempira',2,0.276419,2,0,0),('62006','HRK','Kuna',2,0.352742,2,0,0),('63006','HTG','Gourde',2,0.352742,2,0,0),('64006','HUF','Florin',2,0.375906,2,0,0),('65006','IDR','Rupia',2,0.347786,2,0,0),('66006','ILS','Nuevo Shekel Israeli',2,0.330582,2,0,0),('67006','INR','Rupia india',2,0.295398,2,0,0),('68006','IQD','Dinar iraqui',3,0.586089,2,0,0),('69006','IRR','Rial irani',2,0.352742,2,0,0),('70006','ISK','Corona islandesa',0,0.352742,2,0,0),('7006','ARS','Peso Argentino',2,0.629722,2,0,0),('71006','JMD','Dolar Jamaiquino',2,0.281002,2,0,0),('72006','JOD','Dinar jordano',3,0.352742,2,0,0),('73006','JPY','Yen',0,0.572682,2,0,0),('74006','KES','Chelin keniano',2,0.302136,2,0,0),('75006','KGS','Som',2,0.352742,2,0,0),('76006','KHR','Riel',2,0.352742,2,0,0),('77006','KMF','Franco Comoro',0,0.352742,2,0,0),('78006','KPW','Corea del Norte gano',2,0.352742,2,0,0),('79006','KRW','Won',0,0.353768,2,0,0),('80006','KWD','Dinar kuwaiti',3,0.327061,2,0,0),('8006','AUD','Dolar Australiano',2,0.436901,2,0,0),('81006','KYD','Dolar de las Islas Caiman',2,0.352742,2,0,0),('82006','KZT','Tenge',2,0.352742,2,0,0),('83006','LAK','Kip',2,0.352742,2,0,0),('84006','LBP','Libra libanesa',2,0.352742,2,0,0),('85006','LKR','Rupia de Sri Lanka',2,0.352742,2,0,0),('86006','LRD','Dolar liberiano',2,0.352742,2,0,0),('87006','LSL','Loti',2,0.352742,2,0,0),('88006','LYD','Dinar libio',3,0.352742,2,0,0),('89006','MAD','Dirham marroqui',2,0.358811,2,0,0),('90006','MDL','Leu moldavo',2,0.352742,2,0,0),('9006','AWG','Aruba Florin',2,0.352742,2,0,0),('91006','MGA','Ariary malgache',2,0.352742,2,0,0),('92006','MKD','Denar',2,0.352742,2,0,0),('93006','MMK','Kyat',2,0.352742,2,0,0),('94006','MNT','Tugrik',2,0.352742,2,0,0),('95006','MOP','Pataca',2,0.352742,2,0,0),('96006','MRO','Ouguiya',2,0.352742,2,0,0),('97006','MUR','Rupia de Mauricio',2,0.352742,2,0,0),('98006','MVR','Rupia',2,0.352742,2,0,0),('99006','MWK','Kwacha',2,0.352742,2,0,0);
/*!40000 ALTER TABLE `catsat_monedas` 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 2026-05-30  9:24:16