users_catalog =
[
{
"A":"Nombre",
"B":"Tarjetahabiente",
"C":"Correo",
"D":"Estado",
"E":"Tipo de tarjeta",
"F":"Terminación",
"G":"Límite de gastos",
"H":"Usado",
"I":"bp",
"J":"Area",
"K":"CECO",
"L":"Columna1",
"M":"rfc"
},
{
"A":"Adrian García González",
"B":"Adrian García González",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":539,
"G":550,
"H":0,
"I":97032829,
"J":"Instalaciones C&I",
"K":"MX54101006",
"L":"sin",
"M":"GAGA991005QY0"
},
{
"A":"Aidana Velázquez Martinez",
"B":"AIDANA VELÁZQUEZ MARTINEZ",
"C":"[email protected]",
"D":"BLOQUEADA",
"E":"BUSINESS",
"F":2619,
"G":550,
"H":0,
"I":97021093,
"J":"Business Development",
"K":"MX54111062",
"M":"sin RFC"
},
{
"A":"Alan Dominique Baños Enriquez",
"B":"ALAN BAÑOS ENRIQUEZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":6164,
"G":5000,
"H":0,
"I":97032259,
"J":"Instalaciones Storage",
"K":"MX54101019",
"M":"BAEA950804B37"
},
{
"A":"Alejandro Armando Vera Omaña",
"B":"Alejandro Vera Omaña",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9244,
"G":16500,
"H":0.0001,
"I":97024964,
"J":"Seguridad",
"K":"MX54101022",
"M":"VEOA710710LM4"
},
{
"A":"Alexandra Christian Filsinger Anderson",
"B":"ALEXANDRA FILSINGER ANDERSON",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1161,
"G":35000,
"H":0.0007,
"I":97030706,
"J":"Talento",
"K":"MX54105001",
"M":"FIAA861119N13"
},
{
"A":"Alvaro Rosales Totomoch",
"B":"Alvaro Rosales Totomoch",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":7788,
"G":550,
"H":0,
"I":97032830,
"J":"Instalaciones C&I",
"K":"MX54101006",
"L":"sin",
"M":"ROTA970613TXA"
},
{
"A":"Anabel Ruiz De La Cruz",
"B":"ANABEL RUIZ DE LA CRUZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":2914,
"G":16500,
"H":0,
"I":97028048,
"J":"Instalaciones Storage",
"K":"MX54101019",
"M":"RUCA820330IK5"
},
{
"A":"Angel Eduardo Rentería Cazares",
"B":"ANGEL RENTERÍA CAZARES",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":7224,
"G":15000,
"H":0,
"I":97028428,
"J":"Marketing",
"K":"MX54111001",
"M":"RECA930425Q83"
},
{
"A":"Angel Francisco Negrete Romero",
"B":"Angel Negrete Romero",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":7963,
"G":25000,
"H":0,
"I":97032812,
"J":"Instalaciones Storage",
"K":"MX54101019",
"L":"sin",
"M":"NERA9208029Y8"
},
{
"A":"Angel Trinidad Enríquez",
"B":"Angel Trinidad Enriquez",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9610,
"G":550,
"H":0,
"I":97032243,
"J":"Instalaciones Storage",
"K":"MX54101019",
"M":"TIEA840902FI4"
},
{
"A":"Antonio De Jesus Larios Valencia",
"B":"ANTONIO DE JESÚS LARIOS VALENCIA",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1871,
"G":16500,
"H":0,
"I":97020048,
"J":"Vtas C&I",
"K":"MX54111047",
"M":"sin RFC"
},
{
"A":"Bairo Arzaed Sánchez Serrato",
"B":"Bairo Sánchez Serrato",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9414,
"G":550,
"H":0,
"I":97032831,
"J":"Instalaciones C&I",
"K":"MX54101006",
"L":"sin",
"M":"SASB000106RL7"
},
{
"A":"Bernardo Ocampo Martínez",
"B":"Bernardo Ocampo Martínez",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":3028,
"G":16500,
"H":0.0017,
"I":97032244,
"J":"Mantenimiento",
"K":"MX54102001",
"M":"sin RFC"
},
{
"A":"Brandon Alan Leyva Toledo",
"B":"Brandon Leyva Toledo",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":7000,
"G":550,
"H":0.0087,
"I":97032832,
"J":"Mantenimiento",
"K":"MX54102001",
"L":"sin",
"M":"LETB990330HX2"
},
{
"A":"Brayan Gerardo Vite Ramirez",
"B":"BRAYAN VITE RAMIREZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":6619,
"G":16500,
"H":0,
"I":97032245,
"J":"Instalaciones Storage",
"K":"MX54101019",
"M":"VIRB991129HMCTMR0"
},
{
"A":"Brenda Fonseca Violante",
"B":"Brenda Fonseca",
"C":"[email protected]",
"D":"ACTIVA",
"E":"VIRTUAL",
"F":6196,
"I":97033003,
"J":"Finanzas",
"K":"MX54109001",
"M":"FOVB000627FN0"
},
{
"A":"Byron Yoltic Rodriguez Torres",
"B":"Byron Rodriguez Torres",
"C":"[email protected]",
"D":"INACTIVA",
"E":"BUSINESS",
"F":9859,
"G":550,
"H":0,
"I":97030608,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"sin RFC"
},
{
"A":"Cargos De Cambios",
"B":"Hector Lopez Resendiz",
"C":"[email protected]",
"D":"BLOQUEADA",
"E":"VIRTUAL",
"F":7305,
"G":2000,
"H":0,
"I":97020233,
"J":"Viajes",
"M":"sin RFC"
},
{
"A":"Carlos Alberto Bautista Rivero",
"B":"CARLOS BAUTISTA RIVERO",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":6625,
"G":550,
"H":0,
"I":97024714,
"J":"Gestión CFE comercial",
"K":"MX54111064",
"M":"BARC920304AZ0"
},
{
"A":"Carlos Alberto Gonzalez Sanchez",
"B":"Carlos Gonzalez Sanchez",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":6599,
"I":97032828,
"J":"Instalaciones C&I",
"K":"MX54101006",
"L":"sin",
"M":"GOSC751120FC2"
},
{
"A":"Carlos Alberto González Sánchez",
"B":"Carlos Gonzalez Sanchez",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1668,
"G":75000,
"H":0,
"I":97032828,
"J":"Instalaciones C&I",
"K":"MX54101006",
"L":"sin",
"M":"GOSC751120FC2"
},
{
"A":"Carlos Alfonso Vivas Perez",
"B":"Carlos Vivas Perez",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":7594,
"G":550,
"H":0,
"I":97032813,
"J":"Mantenimiento",
"K":"MX54102001",
"L":"sin",
"M":"VIPC900507L38"
},
{
"A":"Carlos Amador de La Rosa",
"B":"Carlos Amador de La Rosa",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1169,
"J":"Instalaciones C&I",
"K":"MX54101006"
},
{
"A":"Carlos Caballero Cruz",
"B":"Carlos Caballero Cruz",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":7711,
"J":"Seguridad",
"K":"MX54101022"
},
{
"A":"Carlos Martinez",
"B":"Carlos Martinez",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9469,
"G":630000,
"H":0.0009,
"I":97032241,
"J":"Innovación Y Desarrollo",
"K":"MX54110001",
"M":"sin RFC"
},
{
"A":"Cintya Jazmín Hernández Nieto",
"B":"Cintya Hernández Nieto",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":6884,
"G":550,
"H":0,
"I":97032814,
"J":"Gestión CFE Residencial",
"K":"MX54111031",
"L":"sin",
"M":"HENC980918EF8"
},
{
"A":"Daina Jani Mejia Taboada",
"B":"Daina Mejia Taboada",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":8900,
"G":16500,
"H":0,
"I":97032573,
"J":"Cuentas Clave",
"K":"MX54111061",
"M":"METD9809309A2"
},
{
"A":"Daniel Galvez Rico",
"B":"DANIEL GÁLVEZ RICO",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":3240,
"G":16500,
"H":0,
"I":97032247,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"sin RFC"
},
{
"A":"Daniel Sanchez Grijalva",
"B":"Daniel Sanchez Grijalva",
"C":"[email protected]",
"D":"INACTIVA",
"E":"BUSINESS",
"F":4236,
"G":550,
"H":0,
"I":97032833,
"J":"Mantenimiento",
"K":"MX54102001",
"L":"sin",
"M":"SAGD750826E63"
},
{
"A":"Daniel Thayen Bustamante Lara",
"B":"Daniel Bustamante Lara",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":803,
"G":550,
"H":0,
"I":97032726,
"J":"Instalaciones Residenciales",
"K":"MX54101020",
"M":"BULD961007MU9"
},
{
"A":"David Aguirre Castro",
"B":"DAVID AGUIRRE CASTRO",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9215,
"G":25000,
"H":0.0001,
"I":97028083,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"AUCD921208"
},
{
"A":"Diego Bernal Ricardi",
"B":"Diego Bernal Ricardi",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9849,
"G":16500,
"H":0.0007,
"I":97032727,
"J":"Mantenimiento",
"K":"MX54102001",
"M":"sin RFC"
},
{
"A":"Diego Manuel Rodriguez Ayala",
"B":"Diego Rodriguez Ayala",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1152,
"G":16500,
"H":0,
"I":97030533,
"J":"Mantenimiento",
"K":"MX54102001",
"M":"ROAD970531S94"
},
{
"A":"Eber Misael Tello Ceron",
"B":"Eber Tello Ceron",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":7737,
"G":750,
"H":0,
"I":97032834,
"J":"Instalaciones C&I",
"K":"MX54101006",
"L":"sin",
"M":"TECE990215CQ1"
},
{
"A":"Edgar Barrera Mendoza",
"B":"EDGAR BARRERA MENDOZA",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":3602,
"G":5500,
"H":0,
"I":97024341,
"J":"Instalaciones Storage",
"K":"MX54101019",
"M":"sin RFC"
},
{
"A":"Eduardo Guízar González",
"B":"EDUARDO GUÍZAR GONZÁLEZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":6090,
"G":16500,
"H":0,
"I":97022934,
"J":"Innovación Y Desarrollo",
"K":"MX54110001",
"M":"GUGE950507RH6"
},
{
"A":"Eduardo Soto",
"B":"EDUARDO SOTO PEREZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":3031,
"I":97013022,
"J":"Finanzas",
"K":"MX54109001"
},
{
"A":"Elohim Rodolfo Martínez Saucedo",
"B":"ELOHIM MARTÍNEZ SAUCEDO",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":6025,
"G":16500,
"H":0.0002,
"I":97031857,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"MASE960816GZ8"
},
{
"A":"Enrique Pérez Lira",
"B":"ENRIQUE PÉREZ LIRA",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":360,
"G":30000,
"H":0.0001,
"I":97026207,
"J":"Mantenimiento",
"K":"MX54102001",
"M":"sin RFC"
},
{
"A":"Eram Stefano Sandoval Mendez",
"B":"ERAM SANDOVAL MENDEZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9550,
"G":16500,
"H":0.0004,
"I":97032662,
"J":"Instalaciones Storage",
"K":"MX54101019",
"M":"SAME870227TJ3"
},
{
"A":"Erick Fermín Rodrigue Omaña",
"B":"Erick Rodriguez Omaña",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":5526,
"I":97032815,
"J":"Mantenimiento",
"K":"MX54102001",
"M":"ROOE911224BLA"
},
{
"A":"Erick Fermín Rodrigue Omaña",
"B":"Erick Rodriguez Omaña",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":7220,
"G":16500,
"H":0.0004,
"I":97032815,
"J":"Mantenimiento",
"K":"MX54102001",
"L":"sin",
"M":"ROOE911224BLA"
},
{
"A":"Ever Gerardo Gutierrez Lopez",
"B":"EVER GUTIERREZ LOPEZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":5144,
"G":16500,
"H":0.0005,
"I":97032719,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"sin RFC"
},
{
"A":"Felipe Antonio Chaparro Pérez",
"B":"FELIPE CHAPARRO PÉREZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":5132,
"G":1000,
"H":0,
"I":97032248,
"J":"Finanzas Chile",
"K":"MX54109002",
"M":"sin RFC"
},
{
"A":"Fernando Tello Ceron",
"B":"Fernando Tello Ceron",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":6428,
"G":1100,
"H":0,
"I":97032816,
"J":"Instalaciones C&I",
"K":"MX54101006",
"L":"sin",
"M":"TECF9906179Z5"
},
{
"A":"Gabriel Tapia Sánchez",
"B":"Gabriel Tapia Sánchez",
"C":"[email protected]",
"D":"INACTIVA",
"E":"BUSINESS",
"F":7915,
"G":550,
"H":0,
"I":97032686,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"TASG8507313A8"
},
{
"A":"Gastos Administrativos",
"B":"Hector Lopez Resendiz",
"C":"[email protected]",
"D":"ACTIVA",
"E":"VIRTUAL",
"F":3212,
"G":140000,
"H":0,
"I":97020233,
"J":"Finanzas",
"K":"MX54109001",
"M":"sin RFC"
},
{
"A":"Gilberto Ramos Banderas",
"B":"GILBERTO RAMOS BANDERAS",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1124,
"G":2300,
"H":0.0003,
"I":97027457,
"J":"Seguridad",
"K":"MX54101022",
"M":"sin RFC"
},
{
"A":"Growth",
"B":"Óscar García Morales",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9780,
"G":120000,
"H":0,
"I":97012957,
"J":"Marketing",
"K":"MX54111001",
"M":"sin RFC"
},
{
"A":"Héctor Gabriel Zapata Valdez",
"B":"HÉCTOR ZAPATA VALDEZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9835,
"G":16500,
"H":0,
"I":97013046,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"ZAVH840301AL1"
},
{
"A":"Hector Lopez Resendiz",
"C":"[email protected]",
"I":97020233,
"J":"Viajes",
"K":"Viaticos",
"M":"sin RFC"
},
{
"A":"Hertz",
"B":"Hector Lopez Resendiz",
"C":"[email protected]",
"D":"ACTIVA",
"E":"VIRTUAL",
"F":936,
"I":97020233,
"J":"Viajes",
"K":"Viaticos"
},
{
"A":"Hospedajes Y Transportación",
"B":"Hector Lopez Resendiz",
"C":"[email protected]",
"D":"ACTIVA",
"E":"VIRTUAL",
"F":270,
"G":700000,
"H":0.0012,
"I":97020233,
"J":"viajes",
"K":"Viaticos",
"M":"sin RFC"
},
{
"A":"Israel Arreguin",
"B":"Israel Arreguin",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":3529,
"G":20000,
"H":0,
"I":97012913,
"J":"Cuentas Clave",
"K":"MX54111061",
"M":"sin RFC"
},
{
"A":"Israel Nava Hernandez",
"B":"ISRAEL NAVA HERNANDEZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":101,
"G":18500,
"H":0,
"I":97023805,
"J":"Mantenimiento",
"K":"MX54102001",
"M":"NAHI910924HP9"
},
{
"A":"Jesús Valdez Bautista",
"B":"Jesús Valdez Bautista",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":133,
"G":16500,
"H":0.0002,
"I":97032818,
"J":"Mantenimiento",
"K":"MX54102001",
"L":"sin",
"M":"VABJ880326VE7"
},
{
"A":"Jorge Quintana Arenazas",
"B":"JORGE QUINTANA ARENAZAS",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":3347,
"G":16500,
"H":0,
"I":97024846,
"J":"Ingeniería",
"K":"MX54101021",
"M":"QUAJ860119HMCNRR07"
},
{
"A":"Jorge Rasciel Trejo Contreras",
"B":"JORGE TREJO CONTRERAS",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":6276,
"G":16500,
"H":0.0002,
"I":97031107,
"J":"Instalaciones Residenciales",
"K":"MX54101020",
"M":"TECJ900207N24"
},
{
"A":"Jose Aldair Hernandez Rojo",
"B":"JOSE HERNANDEZ ROJO",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":560,
"G":16500,
"H":0.0007,
"I":97029312,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"HERA950604939"
},
{
"A":"José Alfredo Ruiz Hernández",
"B":"José Ruiz Hernández",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":3334,
"G":550,
"H":0.0157,
"I":97032835,
"J":"Mantenimiento",
"K":"MX54102001",
"L":"sin",
"M":"RUHA9903194PA"
},
{
"A":"José Ángel Molina Pineda",
"B":"JOSÉ MOLINA PINEDA",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":6292,
"G":20500,
"H":0.0001,
"I":97026900,
"J":"Instalaciones Storage",
"K":"MX54101019",
"M":"MOPA970923AZ0"
},
{
"A":"José Antonio Moctezuma Benavides",
"B":"JOSÉ MOCTEZUMA BENAVIDES",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":8130,
"G":30000,
"H":0,
"I":97023995,
"J":"Mantenimiento",
"K":"MX54102001",
"M":"sin RFC"
},
{
"A":"José Luis Manzano Robleda",
"B":"Jose Manzano Robleda",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":5843,
"G":550,
"H":0,
"I":97032819,
"J":"Direccion General",
"K":"MX54103002",
"L":"sin",
"M":"MARL830919PR5"
},
{
"A":"Jose Miguel Carrillo Hernandez",
"B":"JOSE CARRILLO HERNANDEZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":5109,
"G":550,
"H":0,
"I":97032820,
"J":"Ingeniería",
"K":"MX54101021",
"M":"CAHM990327AE7"
},
{
"A":"Joskua Morales Cedillo",
"B":"Joskua Morales Cedillo",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1699,
"H":0,
"J":"Almacen",
"K":"MX54101023"
},
{
"A":"Jossli Alvaro Solar Castillo",
"B":"JOSSLI SOLAR CASTILLO",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":6588,
"G":6500,
"H":0,
"I":97032249,
"J":"Instalaciones Residenciales",
"K":"MX54101020",
"M":"SOCJ930218T94"
},
{
"A":"Juan Antonio Soto Morales",
"B":"JUAN SOTO MORALES",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1542,
"G":16500,
"H":0,
"I":97022938,
"J":"Instalaciones Storage",
"K":"MX54101019",
"M":"sin RFC"
},
{
"A":"Juan Solórzano Ibáñez",
"B":"JUAN SOLÓRZANO IBÁÑEZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":286,
"G":5000,
"H":0,
"I":97021091,
"J":"Vtas C&I",
"K":"MX54111047",
"M":"SOIJ881127HW6"
},
{
"A":"Julian Willenbrock A",
"B":"Julian Willenbrock Ahumada",
"C":"[email protected]",
"D":"ACTIVA",
"E":"WORLD ELITE",
"F":3133,
"G":150000,
"H":0.0001,
"I":97013025,
"J":"Direccion General",
"K":"MX54103002",
"M":"sin RFC"
},
{
"A":"Julian Willenbrock Ahumada",
"B":"Julian Willenbrock Ahumada",
"C":"[email protected]",
"D":"INACTIVA",
"E":"BUSINESS",
"F":4186,
"G":100000,
"H":0,
"I":97013025,
"J":"Direccion General",
"K":"MX54103002",
"M":"sin RFC"
},
{
"A":"Karen Itzel Hernandez Torres",
"B":"KAREN HERNANDEZ TORRES",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":5964,
"G":4600,
"H":0,
"I":97030408,
"J":"Gestión CFE comercial",
"K":"MX54111064",
"M":"sin RFC"
},
{
"A":"Karla Estefanía Montes Acevedo",
"B":"KARLA MONTES ACEVEDO",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9753,
"G":16500,
"H":0,
"I":97021810,
"J":"Ingeniería",
"K":"MX54101021",
"M":"sin RFC"
},
{
"A":"Kevin Rosales Totomoch",
"B":"Kevin Rosales Totomoch",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":4842,
"G":550,
"H":0.0065,
"I":97032836,
"J":"Mantenimiento",
"K":"MX54102001",
"L":"sin",
"M":"ROTK951204S98"
},
{
"A":"Lesly Mejia Albarran",
"C":"[email protected]",
"D":"ACTIVA",
"E":"VIRTUAL",
"F":641,
"J":"Finanzas",
"K":"MX54109001"
},
{
"A":"Luis Alexis Amezcua Lezama",
"B":"Luis Amezcua Lezama",
"C":"[email protected]",
"D":"INACTIVA",
"E":"BUSINESS",
"F":4331,
"G":550,
"H":0,
"I":97032821,
"J":"Ingeniería",
"K":"MX54101021",
"M":"AELL9504187C2"
},
{
"A":"Luis Angel Corona Olvera",
"B":"Luis Corona Olvera",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":7041,
"G":18000,
"H":0.0001,
"I":97032822,
"J":"Mantenimiento",
"K":"MX54102001",
"L":"sin",
"M":"COOL0008021V3"
},
{
"A":"Luis Antonio Gonzalez Paez",
"B":"LUIS GONZALEZ PAEZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1975,
"G":16500,
"H":0,
"I":97030901,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"sin RFC"
},
{
"A":"Manuel Ahumada Colas",
"C":"[email protected]",
"I":97013076,
"J":"Direccion General",
"K":"MX54103002",
"M":"sin RFC"
},
{
"A":"Marco Antonio Ordoñez Moreno",
"B":"Marco Ordoñez Moreno",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9130,
"G":550,
"H":0,
"I":97032823,
"J":"Finanzas Chile",
"K":"MX54109002",
"L":"sin",
"M":"OOMM750303C16"
},
{
"A":"Marco Antonio Perez Hernández",
"B":"Marco Perez Hernández",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":3265,
"G":16500,
"H":0,
"I":97028941,
"J":"Seguridad",
"K":"MX54101022",
"M":"PEHM790521HDFRRR00"
},
{
"A":"Marcos Hernández Rivera",
"B":"MARCOS HERNÁNDEZ RIVERA",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":5920,
"G":16500,
"H":0,
"I":97032824,
"J":"Mantenimiento",
"K":"MX54102001",
"L":"sin",
"M":"HERM980202GP6"
},
{
"A":"Maritzel Rodriguez Hernandez",
"B":"MARITZEL RODRIGUEZ HERNANDEZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":2100,
"G":16500,
"H":0.0001,
"I":97030837,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"sin RFC"
},
{
"A":"Mauricio Andres Ortuondo Doyharcabal",
"B":"Mauricio Ortuondo Doyharcabal",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1485,
"G":16500,
"H":0,
"I":97032250,
"J":"Direccion General",
"K":"MX54103002",
"M":"10343544-7"
},
{
"A":"Maya Piñeiro Salazar",
"B":"Maya Piñeiro Salazar",
"C":"[email protected]",
"D":"INACTIVA",
"E":"BUSINESS",
"F":342,
"G":20000,
"H":0,
"I":97027894,
"J":"Vtas C&I",
"K":"MX54111047",
"M":"sin RFC"
},
{
"A":"Miguel Angel Garcia Ramirez",
"B":"MIGUEL GARCIA RAMIREZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":204,
"G":10000,
"H":0,
"I":97012931,
"J":"Direccion General",
"K":"MX54103002",
"M":"GARM821125HE1"
},
{
"A":"Miguel Ángel Uriostegui Adame",
"B":"MIGUEL URIOSTEGUI ADAME",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":2910,
"G":5000,
"H":0.0098,
"I":97031858,
"J":"Mantenimiento",
"K":"MX54102001",
"M":"sin RFC"
},
{
"A":"Miguel Ángel Uriostegui Adame",
"B":"MIGUEL URIOSTEGUI ADAME",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":7587,
"I":97031858,
"J":"Mantenimiento",
"K":"MX54102001",
"M":"sin RFC"
},
{
"A":"Miguel Martinez",
"B":"MIGUEL MARTÍNEZ ORTIZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"VIRTUAL",
"F":6617,
"G":550,
"H":0,
"I":97032613,
"J":"Ingeniería",
"K":"MX54101021",
"M":"sin RFC"
},
{
"A":"Miguel Martinez",
"B":"MIGUEL MARTÍNEZ ORTIZ",
"C":"[email protected]",
"D":"INACTIVA",
"E":"BUSINESS",
"F":4760,
"G":550,
"H":0,
"I":97032613,
"J":"Ingeniería",
"K":"MX54101021",
"M":"sin RFC"
},
{
"A":"Miriam Pérez Martínez",
"B":"MIRIAM PÉREZ MARTÍNEZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":734,
"G":16500,
"H":0.0002,
"I":97032252,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"sin RFC"
},
{
"A":"Moisés Eduardo Hernández Santiago",
"B":"MOISÉS HERNÁNDEZ SANTIAGO",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":2682,
"G":16500,
"H":0.0001,
"I":97012990,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"HESM920122HT6"
},
{
"A":"Moreno Alanis Guillermo Antonio",
"B":"Moreno Guillermo Antonio",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9083,
"G":550,
"H":0,
"I":97032687,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"MOAG860412N82"
},
{
"A":"Omar López Callejas",
"B":"Omar López Callejas",
"C":"[email protected]",
"D":"INACTIVA",
"E":"BUSINESS",
"F":269,
"G":550,
"H":0,
"I":97027211,
"J":"Seguridad",
"K":"MX54101022",
"M":"LOCO940321JX7"
},
{
"A":"Óscar García Morales",
"B":"Óscar García Morales",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":4238,
"G":70000,
"H":0,
"I":97012957,
"J":"Marketing",
"K":"MX54111001",
"M":"sin RFC"
},
{
"A":"Oscar González Barraza",
"B":"Oscar González Barraza",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":5063,
"G":550,
"H":0,
"I":97032825,
"J":"Instalaciones C&I",
"K":"MX54101006",
"L":"sin",
"M":"GOBO790505623"
},
{
"A":"Pablo Daniel Juarez Juarez",
"B":"Pablo Juarez Juarez",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":3787,
"G":550,
"H":0,
"I":97032837,
"J":"Instalaciones C&I",
"K":"MX54101006",
"L":"sin",
"M":"JUJP020628S58"
},
{
"A":"Pedro Flores Ramirez",
"B":"PEDRO FLORES RAMIREZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9896,
"G":16500,
"H":0,
"I":97018908,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"FORP8210167X0"
},
{
"A":"Premios Kpi Residencial",
"B":"MIGUEL ANGEL PEÑA FIGUEROA",
"C":"[email protected]",
"D":"ACTIVA",
"E":"VIRTUAL",
"F":9855,
"G":2000,
"H":0,
"I":97032688,
"J":"Cuidado Al Cliente",
"K":"MX54111025",
"M":"PEFM781117615"
},
{
"A":"Rafael Beltrán García",
"B":"RAFAEL BELTRÁN GARCÍA",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":8677,
"G":16500,
"H":0.0003,
"I":97026306,
"J":"Instalaciones Storage",
"K":"MX54101019",
"M":"BEGR951213PD6"
},
{
"A":"Rafael Hernandez Pacheco",
"B":"Rafael Hernandez Pacheco",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1472,
"J":"Instalaciones Storage",
"K":"MX54101019"
},
{
"A":"Ricardo Nava",
"B":"RICARDO NAVA GARIBAY",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":5673,
"G":16500,
"H":0,
"I":97032574,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"sin RFC"
},
{
"A":"Roberto Antonio Godinez Iniestra",
"B":"ROBERTO GODINEZ INIESTRA",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9061,
"G":550,
"H":0,
"I":97032826,
"J":"Ingeniería",
"K":"MX54101021",
"L":"sin",
"M":"GOIR900407I39"
},
{
"A":"Roberto Campoy Walkup",
"B":"ROBERTO CAMPOY WALKUP",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":2270,
"G":16500,
"H":0,
"I":97032253,
"J":"Cuentas Clave",
"K":"MX54111061",
"M":"CAWR880921V88"
},
{
"A":"Roberto Carlos Gonzalez Garcia",
"B":"ROBERTO GONZALEZ GARCIA",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":6593,
"G":16500,
"H":0,
"I":97023021,
"J":"Mantenimiento",
"K":"MX54102001",
"M":"sin RFC"
},
{
"A":"Sebastián Chávez Sánchez",
"B":"SEBASTIAN CHAVEZ SANCHEZ",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":726,
"G":16500,
"H":0.0006,
"I":97023808,
"J":"Instalaciones Storage",
"K":"MX54101019",
"M":"CASS871103B31"
},
{
"A":"Sergio Osvaldo Alvarez Pulido",
"B":"SERGIO ALVAREZ PULIDO",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":7607,
"G":1500,
"H":0.0116,
"I":97013221,
"J":"Vtas C&I",
"K":"MX54111047",
"M":"AAPS840728 5M5"
},
{
"A":"Televia",
"B":"Hector Lopez Resendiz",
"C":"[email protected]",
"D":"ACTIVA",
"E":"VIRTUAL",
"F":5398,
"G":100000,
"H":0,
"I":97020233,
"J":"Instalaciones C&I",
"K":"MX54101006",
"M":"sin RFC"
},
{
"A":"Tomas Alfonso Lonza Pulgar",
"B":"Tomás Lonza Pulgar",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":3568,
"J":"Instalaciones C&I",
"K":"MX54101006"
},
{
"A":"Victor Cruz",
"B":"Victor Cruz",
"C":"[email protected]",
"D":"ACTIVA",
"F":6335,
"I":97029801,
"J":"Finanzas",
"K":"MX54109001",
"M":"sin RFC"
},
{
"A":"Victor Gerardo Garcia Ramos",
"B":"VICTOR GARCIA RAMOS",
"C":"[email protected]",
"D":"INACTIVA",
"E":"BUSINESS",
"F":8850,
"G":550,
"H":0,
"I":97032260,
"J":"Seguridad",
"K":"MX54101022",
"M":"GARV910813JZ4"
},
{
"A":"Víctor Hugo Zuñiga López",
"B":"Víctor Zuñiga López",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":9324,
"G":550,
"H":0,
"I":97032689,
"J":"Mantenimiento",
"K":"MX54102001",
"M":"ZULV93011717A"
},
{
"A":"Víctor Hugo Zuñiga López",
"B":"Víctor Zuñiga López",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":2423,
"I":97032689,
"J":"Mantenimiento",
"K":"MX54102001"
},
{
"A":"Victor Manuel Bautista Rangel",
"B":"VICTOR BAUTISTA RANGEL",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1999,
"G":550,
"H":0,
"I":97025342,
"J":"Seguridad",
"K":"MX54101022",
"M":"BARV920403E36"
},
{
"A":"Víctor Manuel Escalera Gandara",
"B":"Victor Escalera Gandara",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":3544,
"G":25000,
"H":0.0002,
"I":97032827,
"J":"Instalaciones Storage",
"K":"MX54101019",
"L":"sin",
"M":"EAGV9606086J5"
},
{
"A":"Vuelos",
"B":"Hector Lopez Resendiz",
"C":"[email protected]",
"D":"ACTIVA",
"E":"VIRTUAL",
"F":726,
"G":400000,
"H":0,
"I":97020233,
"J":"Viajes",
"K":"Viaticos",
"M":"sin RFC"
},
{
"A":"Vuelos 2",
"B":"Hector Lopez Resendiz",
"C":"[email protected]",
"D":"ACTIVA",
"E":"VIRTUAL",
"F":2551,
"G":400000,
"H":0.0004,
"I":97020233,
"J":"Viajes",
"K":"Viaticos",
"M":"sin RFC"
},
{
"A":"Yair Javier Galarza Castrejón",
"B":"YAIR GALARZA CASTREJÓN",
"C":"[email protected]",
"D":"ACTIVA",
"E":"BUSINESS",
"F":1876,
"G":16500,
"H":0,
"I":97024741,
"J":"Ingeniería",
"K":"MX54101021",
"M":"sin RFC"
}
];
filtered_data =
[
{
"A":"may/02/2023",
"B":"5019",
"C":"CARR COLOMBIA Y PORFI",
"D":"629.01",
"E":"MXN"
},
{
"A":"may/11/2023",
"B":"6903",
"C":"REST CUERNOS LARGOS",
"D":"368.5",
"E":"MXN"
},
{
"A":"may/11/2023",
"B":"6903",
"C":"OXXO NAYARIT PAC",
"D":"67.5",
"E":"MXN"
},
{
"A":"may/11/2023",
"B":"6903",
"C":"OXXOSAN FERNANDO",
"D":"115",
"E":"MXN"
},
{
"A":"may/11/2023",
"B":"7102",
"C":"OXXOBRUJAS CEL QRF",
"D":"138.4",
"E":"MXN"
},
{
"A":"may/11/2023",
"B":"7102",
"C":"CLIP MX*ANTOJITOS DONA",
"D":"148.5",
"E":"MXN"
},
{
"A":"may/11/2023",
"B":"7102",
"C":"MOMENTOS BISQUET OBREG",
"D":"189",
"E":"MXN"
},
{
"A":"may/11/2023",
"B":"4628",
"C":"OXXO NAYARIT PAC",
"D":"44",
"E":"MXN"
},
{
"A":"may/11/2023",
"B":"4628",
"C":"REST CUERNOS LARGOS",
"D":"258.5",
"E":"MXN"
},
{
"A":"may/11/2023",
"B":"4628",
"C":"OXXOSAN FERNANDO",
"D":"53.51",
"E":"MXN"
},
{
"A":"may/12/2023",
"B":"4628",
"C":"VIPS TULANCINGO",
"D":"221.1",
"E":"MXN"
},
{
"A":"may/12/2023",
"B":"4628",
"C":"OXXO TUNAS MEX",
"D":"39.4",
"E":"MXN"
},
{
"A":"may/12/2023",
"B":"6903",
"C":"OXXO TUNAS MEX",
"D":"80",
"E":"MXN"
},
{
"A":"may/12/2023",
"B":"6903",
"C":"VIPS TULANCINGO",
"D":"393.8",
"E":"MXN"
},
{
"A":"may/12/2023",
"B":"7102",
"C":"SUSHITAI PTO INTERIOR",
"D":"319",
"E":"MXN"
},
{
"A":"may/12/2023",
"B":"7102",
"C":"KFC 595 PIN VIA ALTA L",
"D":"145",
"E":"MXN"
},
{
"A":"may/13/2023",
"B":"7102",
"C":"OXXO MACRO PALMILL QRF",
"D":"36",
"E":"MXN"
},
{
"A":"may/13/2023",
"B":"7102",
"C":"TOKS LEON",
"D":"194.7",
"E":"MXN"
},
{
"A":"may/13/2023",
"B":"6903",
"C":"OXXO TERMIGAS PAC",
"D":"217",
"E":"MXN"
},
{
"A":"may/14/2023",
"B":"7102",
"C":"MI BODEGA CANAVERAL",
"D":"374.5",
"E":"MXN"
},
{
"A":"may/15/2023",
"B":"7102",
"C":"CLIP MX*TACOSYROCK",
"D":"550",
"E":"MXN"
},
{
"A":"may/16/2023",
"B":"7102",
"C":"CLIP MX*CHILAQUILIS",
"D":"292",
"E":"MXN"
},
{
"A":"may/16/2023",
"B":"7102",
"C":"MI BODEGA CANAVERAL",
"D":"258.5",
"E":"MXN"
},
{
"A":"may/17/2023",
"B":"7102",
"C":"CLIP MX*TACOSYROCK",
"D":"550",
"E":"MXN"
},
{
"A":"may/17/2023",
"B":"8216",
"C":"DHL MARIANO ESCOBEDO",
"D":"297.06",
"E":"MXN"
},
{
"A":"may/18/2023",
"B":"7102",
"C":"OXXOFERROMEX BJX",
"D":"36",
"E":"MXN"
},
{
"A":"may/18/2023",
"B":"7102",
"C":"MI BODEGA CANAVERAL",
"D":"323.5",
"E":"MXN"
},
{
"A":"may/18/2023",
"B":"7102",
"C":"VITAL JUICE",
"D":"180",
"E":"MXN"
},
{
"A":"may/19/2023",
"B":"1417",
"C":"FARM GUADALAJARA 721",
"D":"50",
"E":"MXN"
},
{
"A":"may/19/2023",
"B":"7102",
"C":"CLIP MX*TACOSYROCK",
"D":"550",
"E":"MXN"
},
{
"A":"may/20/2023",
"B":"7102",
"C":"ANTOJITOS DONA LUCITA",
"D":"379.5",
"E":"MXN"
},
{
"A":"may/20/2023",
"B":"7102",
"C":"CLIP MX*CHILAQUILIS",
"D":"115",
"E":"MXN"
},
{
"A":"may/20/2023",
"B":"2173",
"C":"HEB SAN NICOLAS",
"D":"484.04",
"E":"MXN"
},
{
"A":"may/21/2023",
"B":"5019",
"C":"SORIANA12 SAN NICOLAS",
"D":"488.27",
"E":"MXN"
},
{
"A":"may/21/2023",
"B":"7102",
"C":"BARBACOA EL AMIGO CHON",
"D":"254",
"E":"MXN"
},
{
"A":"may/21/2023",
"B":"7102",
"C":"ANTOJITOS DONA LUCITA",
"D":"170.5",
"E":"MXN"
},
{
"A":"may/21/2023",
"B":"2173",
"C":"HOME DEPOT",
"D":"465",
"E":"MXN"
},
{
"A":"may/22/2023",
"B":"1417",
"C":"PUERT CERO PARKING GDL",
"D":"150",
"E":"MXN"
},
{
"A":"may/22/2023",
"B":"1417",
"C":"PUERT CERO PARKING GDL",
"D":"100",
"E":"MXN"
},
{
"A":"may/22/2023",
"B":"1417",
"C":"OFFICE MAX TLAQUEPAQUE",
"D":"66.2",
"E":"MXN"
},
{
"A":"may/22/2023",
"B":"4628",
"C":"DENNYS",
"D":"342",
"E":"MXN"
},
{
"A":"may/22/2023",
"B":"4628",
"C":"SUPERCENTER BLVD DELT",
"D":"229.22",
"E":"MXN"
},
{
"A":"may/22/2023",
"B":"5019",
"C":"SORIANA12 SAN NICOLAS",
"D":"480.19",
"E":"MXN"
},
{
"A":"may/22/2023",
"B":"7102",
"C":"CLIP MX*TACOSYROCK",
"D":"550",
"E":"MXN"
},
{
"A":"may/22/2023",
"B":"6903",
"C":"SUPERCENTER BLVD DELT",
"D":"255.5",
"E":"MXN"
},
{
"A":"may/22/2023",
"B":"6903",
"C":"DENNYS",
"D":"331",
"E":"MXN"
},
{
"A":"may/23/2023",
"B":"6903",
"C":"OADPRS MU",
"D":"212",
"E":"MXN"
},
{
"A":"may/23/2023",
"B":"6903",
"C":"MI BODEGA CANAVERAL",
"D":"578.04",
"E":"MXN"
},
{
"A":"may/23/2023",
"B":"7102",
"C":"CLIP MX*TACOSYROCK",
"D":"550",
"E":"MXN"
},
{
"A":"may/23/2023",
"B":"4628",
"C":"MI BODEGA CANAVERAL",
"D":"573.63",
"E":"MXN"
},
{
"A":"may/23/2023",
"B":"1417",
"C":"PUERT CERO PARKING GDL",
"D":"100",
"E":"MXN"
},
{
"A":"may/24/2023",
"B":"6903",
"C":"MI BODEGA CANAVERAL",
"D":"496",
"E":"MXN"
},
{
"A":"may/24/2023",
"B":"6903",
"C":"OXXO AEROPUERTO BJX",
"D":"84",
"E":"MXN"
},
{
"A":"may/24/2023",
"B":"7102",
"C":"OXXO MACRO PALMILL QRF",
"D":"120.5",
"E":"MXN"
},
{
"A":"may/24/2023",
"B":"7102",
"C":"NETPAY *CARNITAS ASADO",
"D":"183.7",
"E":"MXN"
},
{
"A":"may/24/2023",
"B":"8216",
"C":"QUALITAS POLIZAS",
"D":"5,430.81",
"E":"MXN"
},
{
"A":"may/24/2023",
"B":"1417",
"C":"GASO SAMARA GUADALUPE",
"D":"450",
"E":"MXN"
},
{
"A":"may/24/2023",
"B":"1417",
"C":"PUERT CERO PARKING GDL",
"D":"50",
"E":"MXN"
},
{
"A":"may/24/2023",
"B":"4628",
"C":"MI BODEGA CANAVERAL",
"D":"503.24",
"E":"MXN"
},
{
"A":"may/24/2023",
"B":"4628",
"C":"OXXO AEROPUERTO BJX",
"D":"33.5",
"E":"MXN"
},
{
"A":"may/24/2023",
"B":"2173",
"C":"HEB SAN NICOLAS",
"D":"489.11",
"E":"MXN"
},
{
"A":"may/25/2023",
"B":"6903",
"C":"MI BODEGA CANAVERAL",
"D":"450",
"E":"MXN"
},
{
"A":"may/25/2023",
"B":"6903",
"C":"OXXO AEROPUERTO BJX",
"D":"104",
"E":"MXN"
},
{
"A":"may/25/2023",
"B":"1417",
"C":"PUERT CERO PARKING GDL",
"D":"50",
"E":"MXN"
},
{
"A":"may/25/2023",
"B":"4628",
"C":"OXXO AEROPUERTO BJX",
"D":"31",
"E":"MXN"
},
{
"A":"may/25/2023",
"B":"4628",
"C":"MI BODEGA CANAVERAL",
"D":"496.5",
"E":"MXN"
},
{
"A":"may/26/2023",
"B":"1417",
"C":"PUERT CERO PARKING GDL",
"D":"50",
"E":"MXN"
},
{
"A":"may/26/2023",
"B":"4628",
"C":"SUPERCENTER BLVD AERO",
"D":"531",
"E":"MXN"
},
{
"A":"may/26/2023",
"B":"6903",
"C":"SUPERCENTER BLVD AERO",
"D":"502",
"E":"MXN"
},
{
"A":"may/27/2023",
"B":"4628",
"C":"SUPERCENTER BLVD DELT",
"D":"477.5",
"E":"MXN"
},
{
"A":"may/27/2023",
"B":"4628",
"C":"OXXOCANAVERAL",
"D":"53",
"E":"MXN"
},
{
"A":"may/27/2023",
"B":"5019",
"C":"OXXOSOCRATES RIZZO",
"D":"164.5",
"E":"MXN"
},
{
"A":"may/27/2023",
"B":"6903",
"C":"SUPERCENTER BLVD DELT",
"D":"556.5",
"E":"MXN"
},
{
"A":"may/28/2023",
"B":"4628",
"C":"WM IRAPUATO NORTE",
"D":"562.72",
"E":"MXN"
},
{
"A":"may/28/2023",
"B":"4628",
"C":"OXXO AEROPUERTO BAJIO",
"D":"26.5",
"E":"MXN"
},
{
"A":"may/28/2023",
"B":"7102",
"C":"REST KARN GARIBAL PLAZ",
"D":"304.7",
"E":"MXN"
},
{
"A":"may/28/2023",
"B":"7102",
"C":"OXXO AUTOP TEPEJI",
"D":"47",
"E":"MXN"
},
{
"A":"may/28/2023",
"B":"6903",
"C":"WM IRAPUATO NORTE",
"D":"565.5",
"E":"MXN"
},
{
"A":"may/28/2023",
"B":"7102",
"C":"D ANGOLO",
"D":"215",
"E":"MXN"
},
{
"A":"may/29/2023",
"B":"1417",
"C":"GASO SAMARA GUADALUPE",
"D":"500",
"E":"MXN"
},
{
"A":"may/29/2023",
"B":"4628",
"C":"OXXO AEROPUERTO BAJIO",
"D":"88",
"E":"MXN"
},
{
"A":"may/29/2023",
"B":"4628",
"C":"MI BODEGA CANAVERAL",
"D":"470",
"E":"MXN"
},
{
"A":"may/29/2023",
"B":"7102",
"C":"CLIP MX*MANGO CAFE",
"D":"222",
"E":"MXN"
},
{
"A":"may/29/2023",
"B":"7102",
"C":"OXXO BARRA MALECON",
"D":"104.5",
"E":"MXN"
},
{
"A":"may/29/2023",
"B":"7102",
"C":"OXXOJALUCO CLA",
"D":"35",
"E":"MXN"
},
{
"A":"may/29/2023",
"B":"7102",
"C":"OXXO BARRA MALECON",
"D":"70.1",
"E":"MXN"
},
{
"A":"may/29/2023",
"B":"6903",
"C":"MI BODEGA CANAVERAL",
"D":"546",
"E":"MXN"
},
{
"A":"may/30/2023",
"B":"5019",
"C":"CARR COLOMBIA Y PORFI",
"D":"500",
"E":"MXN"
},
{
"A":"may/30/2023",
"B":"6903",
"C":"SUPERCENTER BLVD AERO",
"D":"506",
"E":"MXN"
},
{
"A":"may/30/2023",
"B":"6903",
"C":"OXXOCANAVERAL",
"D":"103.4",
"E":"MXN"
},
{
"A":"may/30/2023",
"B":"4628",
"C":"SUPERCENTER BLVD AERO",
"D":"265",
"E":"MXN"
},
{
"A":"may/30/2023",
"B":"4628",
"C":"OXXO AEROPUERTO BAJIO",
"D":"87",
"E":"MXN"
},
{
"A":"may/30/2023",
"B":"4628",
"C":"DQ VIA ALTA",
"D":"186",
"E":"MXN"
}
];
range_to_write = [];
for (var i = 0; i < filtered_data.length; i++)
{
obj = {};
user_card_number = filtered_data[i]["B"].toString().trim();
if(user_card_number.match(/0\d\d\d/gm)!=null)
{
user_card_number = user_card_number.slice(1);
}
user_trans_details = filtered_data[i]["C"].toString().trim();
for (var j = 0; j < users_catalog.length; j++)
{
db_card_number = (users_catalog[j]["F"]!=undefined?users_catalog[j]["F"]:"").toString().trim();
db_trans_details =(users_catalog[j]["A"]!=undefined?users_catalog[j]["A"]:"").toString().trim();
var regex = new RegExp(user_card_number+"$", "gm");
if(db_card_number.match(regex)!=null)
//&& db_trans_details.includes(user_trans_details)
{
obj.A = (filtered_data[i]["A"]!=undefined?filtered_data[i]["A"]:"").toString().trim();//Date
obj.B = user_card_number;//Card Number
obj.C = (filtered_data[i]["C"]!=undefined?filtered_data[i]["C"]:"").toString().trim();//Transaction
obj.D = (filtered_data[i]["D"]!=undefined?filtered_data[i]["D"]:"").toString().trim();//Charges
obj.F = (users_catalog[j]["A"]!=undefined?users_catalog[j]["A"]:"").toString().trim();//Name
obj.G = (users_catalog[j]["I"]!=undefined?users_catalog[j]["I"]:"").toString().trim();//BP
obj.H = (users_catalog[j]["C"]!=undefined?users_catalog[j]["C"]:"").toString().trim();//Email
obj.I = (users_catalog[j]["J"]!=undefined?users_catalog[j]["J"]:"").toString().trim();//Area
//break;
}
else
{
obj.A = (filtered_data[i]["A"]!=undefined?filtered_data[i]["A"]:"").toString().trim();//Date
obj.B = user_card_number;//Card Number
obj.C = (filtered_data[i]["C"]!=undefined?filtered_data[i]["C"]:"").toString().trim();//Transaction
obj.D = (filtered_data[i]["D"]!=undefined?filtered_data[i]["D"]:"").toString().trim();//Charges
obj.AD = "Manual";//Status
}
}
range_to_write.push(obj);
}
range_to_write = range_to_write.sort((a, b) => {
if (a.B < b.B) {
return -1;
}
});
console.log(range_to_write); Write, Run & Share Javascript code online using OneCompiler's JS online compiler for free. It's one of the robust, feature-rich online compilers for Javascript language. Getting started with the OneCompiler's Javascript editor is easy and fast. The editor shows sample boilerplate code when you choose language as Javascript and start coding.
Javascript(JS) is a object-oriented programming language which adhere to ECMA Script Standards. Javascript is required to design the behaviour of the web pages.
var readline = require('readline');
var rl = readline.createInterface({
input: process.stdin,
output: process.stdout,
terminal: false
});
rl.on('line', function(line){
console.log("Hello, " + line);
});
| Keyword | Description | Scope |
|---|---|---|
| var | Var is used to declare variables(old way of declaring variables) | Function or global scope |
| let | let is also used to declare variables(new way) | Global or block Scope |
| const | const is used to declare const values. Once the value is assigned, it can not be modified | Global or block Scope |
let greetings = `Hello ${name}`
const msg = `
hello
world!
`
An array is a collection of items or values.
let arrayName = [value1, value2,..etc];
// or
let arrayName = new Array("value1","value2",..etc);
let mobiles = ["iPhone", "Samsung", "Pixel"];
// accessing an array
console.log(mobiles[0]);
// changing an array element
mobiles[3] = "Nokia";
Arrow Functions helps developers to write code in concise way, it’s introduced in ES6.
Arrow functions can be written in multiple ways. Below are couple of ways to use arrow function but it can be written in many other ways as well.
() => expression
const numbers = [0, 1, 2, 3, 4, 5, 6, 7, 8, 9]
const squaresOfEvenNumbers = numbers.filter(ele => ele % 2 == 0)
.map(ele => ele ** 2);
console.log(squaresOfEvenNumbers);
let [firstName, lastName] = ['Foo', 'Bar']
let {firstName, lastName} = {
firstName: 'Foo',
lastName: 'Bar'
}
const {
title,
firstName,
lastName,
...rest
} = record;
//Object spread
const post = {
...options,
type: "new"
}
//array spread
const users = [
...adminUsers,
...normalUsers
]
function greetings({ name = 'Foo' } = {}) { //Defaulting name to Foo
console.log(`Hello ${name}!`);
}
greet() // Hello Foo
greet({ name: 'Bar' }) // Hi Bar
IF is used to execute a block of code based on a condition.
if(condition){
// code
}
Else part is used to execute the block of code when the condition fails.
if(condition){
// code
} else {
// code
}
Switch is used to replace nested If-Else statements.
switch(condition){
case 'value1' :
//code
[break;]
case 'value2' :
//code
[break;]
.......
default :
//code
[break;]
}
For loop is used to iterate a set of statements based on a condition.
for(Initialization; Condition; Increment/decrement){
//code
}
While is also used to iterate a set of statements based on a condition. Usually while is preferred when number of iterations are not known in advance.
while (condition) {
// code
}
Do-while is also used to iterate a set of statements based on a condition. It is mostly used when you need to execute the statements atleast once.
do {
// code
} while (condition);
ES6 introduced classes along with OOPS concepts in JS. Class is similar to a function which you can think like kind of template which will get called when ever you initialize class.
class className {
constructor() { ... } //Mandatory Class method
method1() { ... }
method2() { ... }
...
}
class Mobile {
constructor(model) {
this.name = model;
}
}
mbl = new Mobile("iPhone");