{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"CIDCONSU01","type":"number","width":11,"decimals":0},{"name":"CIDSISTEMA","type":"number","width":11,"decimals":0},{"name":"CIDIDIOMA","type":"number","width":11,"decimals":0},{"name":"CIDMODULO","type":"number","width":11,"decimals":0},{"name":"CTIPO","type":"number","width":6,"decimals":0},{"name":"CCOLUMNA01","type":"number","width":6,"decimals":0},{"name":"CNOMBREC01","type":"character","width":51},{"name":"CSENTENC01","type":"memo","width":4,"read":false},{"name":"CIDEMPRESA","type":"number","width":11,"decimals":0},{"name":"CINDICE","type":"character","width":26},{"name":"CESDESIS01","type":"number","width":6,"decimals":0},{"name":"CFILTROS","type":"character","width":128},{"name":"CINICIOARG","type":"number","width":6,"decimals":0},{"name":"CLIMITEARG","type":"number","width":6,"decimals":0},{"name":"CORDEN","type":"number","width":6,"decimals":0}],"n_rows":157,"rows_kept":157,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"visual_foxpro","encoding_class":"enc_single_byte","reader":"statdb_count/9"}
[1,5,1,1,0,1,"Todos los Clientes",null,0,"iCodigoTipo",0,null,0,0,2]
[2,5,1,1,1,1,"Clientes Activos",null,0,"iCodigoTipo",0,null,0,0,2]
[3,5,1,1,1,1,"Clientes Inactivos",null,0,"iCodigoTipo",0,null,0,0,2]
[4,5,1,1,1,1,"Directorio Telefónico",null,0,"iCodigoTipo",0,null,0,0,2]
[5,5,1,2,0,1,"Todos los Proveedores",null,0,"iCodigoTipo",0,null,0,0,2]
[6,5,1,2,1,1,"Proveedores Activos",null,0,"iCodigoTipo",0,null,0,0,2]
[7,5,1,2,1,1,"Proveedores Inactivos",null,0,"iCodigoTipo",0,null,0,0,2]
[8,5,1,2,1,1,"Directorio Telefónico",null,0,"iCodigoTipo",0,null,0,0,2]
[9,5,1,3,0,1,"Todos los Agentes",null,0,"iCodigoTipo",0,null,0,0,2]
[10,5,1,3,1,1,"Agentes de Venta",null,0,"iCodigoTipo",0,null,0,0,2]
[11,5,1,3,1,1,"Agentes de Cobro",null,0,"iCodigoTipo",0,null,0,0,2]
[12,5,1,4,0,1,"Todos los Almacenes",null,0,"cCodigoAlmacen",0,null,0,0,2]
[13,5,1,5,0,1,"Todos los Productos",null,0,"iCodigoTipo",0,null,0,0,2]
[14,5,1,5,1,1,"Productos Activos",null,0,"iCodigoTipo",0,null,0,0,2]
[15,5,1,5,1,1,"Productos Inactivos",null,0,"iCodigoTipo",0,null,0,0,2]
[16,5,1,5,1,1,"Lista de Precios",null,0,"iCodigoTipo",0,null,0,0,2]
[17,5,1,6,0,1,"Todos los Servicios",null,0,"iCodigoTipo",0,null,0,0,2]
[18,5,1,6,1,1,"Servicios Activos",null,0,"iCodigoTipo",0,null,0,0,2]
[19,5,1,6,1,1,"Servicios Inactivos",null,0,"iCodigoTipo",0,null,0,0,2]
[20,5,1,6,1,1,"Lista de Precios",null,0,"iCodigoTipo",0,null,0,0,2]
[21,5,1,7,0,1,"Todos los Paquetes",null,0,"iCodigoTipo",0,null,0,0,2]
[22,5,1,7,1,1,"Paquetes Activos",null,0,"iCodigoTipo",0,null,0,0,2]
[23,5,1,7,1,1,"Paquetes Inactivos",null,0,"iCodigoTipo",0,null,0,0,2]
[24,5,1,7,1,1,"Lista de Precios",null,0,"iCodigoTipo",0,null,0,0,2]
[25,5,1,8,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[26,5,1,8,1,1,"Documentos con Saldo Pendiente",null,0,"iConceptoFecha",0,null,0,0,1]
[27,5,1,8,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[28,5,1,9,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[29,5,1,9,1,1,"Documentos Pendientes por Surtir",null,0,"iConceptoFecha",0,null,0,0,1]
[30,5,1,9,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[31,5,1,10,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[32,5,1,10,1,1,"Documentos Pendientes por Surtir",null,0,"iConceptoFecha",0,null,0,0,1]
[33,5,1,10,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[34,5,1,11,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[35,5,1,11,1,1,"Documentos Pendientes por Surtir",null,0,"iConceptoFecha",0,null,0,0,1]
[36,5,1,11,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[37,5,1,12,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[38,5,1,12,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[39,5,1,13,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[40,5,1,13,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[41,5,1,14,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[42,5,1,14,1,1,"Documentos con Saldo Pendiente",null,0,"iConceptoFecha",0,null,0,0,1]
[43,5,1,14,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[44,5,1,15,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[45,5,1,15,1,1,"Documentos Pendientes por Surtir",null,0,"iConceptoFecha",0,null,0,0,1]
[46,5,1,15,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[47,5,1,16,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[48,5,1,16,1,1,"Documentos Pendientes por Surtir",null,0,"iConceptoFecha",0,null,0,0,1]
[49,5,1,16,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[50,5,1,17,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[51,5,1,17,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[52,5,1,18,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[53,5,1,18,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[54,5,1,19,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[55,5,1,19,1,1,"Documentos con Saldo Pendiente",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[56,5,1,19,1,1,"Documentos Cancelados",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[57,5,1,20,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[58,5,1,20,1,1,"Documentos con Saldo Pendiente",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[59,5,1,20,1,1,"Documentos Cancelados",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[60,5,1,21,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[61,5,1,21,1,1,"Documentos con Saldo Pendiente",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[62,5,1,21,1,1,"Documentos Cancelados",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[63,5,1,22,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[64,5,1,22,1,1,"Documentos con Saldo Pendiente",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[65,5,1,22,1,1,"Documentos Cancelados",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[66,5,1,23,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[67,5,1,24,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[68,5,1,25,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,2]
[69,5,1,27,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[70,5,1,30,0,1,"Saldos del Cliente",null,0,"iClienteProveedorFecha",0,null,0,0,2]
[71,5,1,31,0,1,"Saldos del Proveedor",null,0,"iClienteProveedorFecha",0,null,0,0,2]
[72,5,1,50,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[73,5,1,51,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[74,5,1,52,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[75,5,1,53,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[76,5,1,54,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[77,5,1,55,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[78,5,1,56,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[79,5,1,57,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[80,5,1,58,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[81,5,1,59,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[82,5,1,60,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[83,5,1,61,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[84,5,1,61,1,1,"Documentos con Saldo Pendiente",null,0,"iConceptoFecha",0,null,0,0,1]
[85,5,1,61,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[86,5,1,62,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[87,5,1,62,1,1,"Documentos con Saldo Pendiente",null,0,"iConceptoFecha",0,null,0,0,1]
[88,5,1,62,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[89,5,1,63,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[90,5,1,63,1,1,"Documentos con Saldo Pendiente",null,0,"iConceptoFecha",0,null,0,0,1]
[91,5,1,63,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[92,5,1,64,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[93,5,1,64,1,1,"Documentos con Saldo Pendiente",null,0,"iConceptoFecha",0,null,0,0,1]
[94,5,1,64,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[95,5,1,65,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[96,5,1,66,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[97,5,1,67,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[98,5,1,68,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,2]
[100,5,1,69,0,1,"Folios Disponibles de los Autorizados por el SAT",null,0,null,1,"( MGW10045.cEstado = 0 ) and ( MGW10045.cIdDoctoDe = %i ) and ( MGW10045.cIdCptoDoc = %i )",0,0,2]
[101,5,1,69,1,1,"Folios Ocupados",null,0,null,1,"( MGW10045.cEstado <> 0 ) and ( MGW10045.cIdDoctoDe = %i ) and ( MGW10045.cIdCptoDoc = %i )",0,0,2]
[102,5,1,69,1,1,"Todos los Folios",null,0,null,1,null,0,0,2]
[118,5,1,70,0,1,"Asociaciones Abono - Cargos",null,0,"PrimaryKey",0,null,0,0,2]
[119,5,1,71,0,1,"Asociaciones Cargo - Abonos",null,0,"iDoctoCargoAbono",0,null,0,0,2]
[120,5,1,72,0,1,"Asociaciones Abono - Cargos",null,0,"iDoctoCargoAbono",0,null,0,0,2]
[121,5,1,73,0,1,"Asociaciones Cargo - Abonos",null,0,"PrimaryKey",0,null,0,0,2]
[122,5,1,69,1,1,"Folios Cancelados",null,0,null,0,"( MGW10045.cEstado = 3 ) and ( MGW10045.cIdDoctoDe = %i ) and ( MGW10045.cIdCptoDoc = %i )",0,0,2]
[123,5,1,74,0,1,"Globales",null,0,"iProdAlmacenFecha",0,"( MGW10017.cIdAlmacen = 0 )",0,0,2]
[124,5,1,74,1,1,"Por Almacén",null,0,"iProdAlmacenFecha",0,"( MGW10017.cIdAlmacen <> 0 )",0,0,2]
[125,5,1,75,0,1,"Existencia por Almacén",null,0,"iProdEjerAlmacenTipo",0,null,0,0,2]
[126,5,1,75,1,1,"Costos por Almacén",null,0,"iProdEjerAlmacenTipo",0,null,0,0,2]
[127,5,1,76,0,1,"Lista de Precios de Compra",null,0,"PrimaryKey",0,null,0,0,2]
[128,5,1,77,0,1,"Estado del Sistema Actual",null,0,"iAcumImpteOwnerEjerMoneda",0,"( MGW10018.cIdEjercicio = %i )",0,0,2]
[129,5,1,77,1,1,"Estado del Sistema Histórico",null,0,"iAcumImpteOwnerEjerMoneda",0,null,0,0,2]
[130,5,1,90,0,1,"Todos los Documentos",null,0,"iConceptoFecha",0,null,0,0,1]
[131,5,1,90,1,1,"Documentos Pendientes por Surtir",null,0,"iConceptoFecha",0,null,0,0,1]
[132,5,1,90,1,1,"Documentos Cancelados",null,0,"iConceptoFecha",0,null,0,0,1]
[133,5,1,91,0,1,"Todos los Documentos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]
[134,5,1,100,0,1,"Operaciones del día",null,0,"FechaHora",0,null,0,0,2]
[135,5,1,102,0,1,"Clientes",null,null,"iConceptoFecha",null,null,0,1,1]
[136,5,1,102,1,1,"Proveedores",null,null,"iConceptoFecha",null,null,1,1,1]
[137,5,1,114,1,1,"b) Válidos",null,0,"IERRFECHA",1,"( MGW10048.cError = 0 )",0,0,1]
[138,5,1,114,1,1,"d) Sin certificado incluido",null,0,"IERRFECHA",1,"( MGW10048.cError = 4 )",0,0,1]
[139,5,1,114,1,1,"c) R.F.C. no corresponde",null,0,"IERRFECHA",1,"( MGW10048.cError = 1 )",0,0,1]
[140,5,1,114,0,1,"a) Todos",null,0,"IERRFECHA",1,null,0,0,1]
[141,5,1,114,1,1,"f) XML no es CFD/CFDI",null,0,"IERRFECHA",1,"( MGW10048.cError = 2 )",0,0,1]
[142,5,1,115,0,1,"a) Todos",null,0,"IESTFECHA",1,"( MGW10045.cEstado = 11 )",0,0,1]
[143,5,1,116,0,1,"a) Emitidos",null,0,"IESTFECHA",1,"( MGW10045.cEstado = 2 ) and ( MGW10045.cEsTrad = 0 or MGW10045.cEsTrad = 3 )",0,0,1]
[144,5,1,116,1,1,"b) Cancelados",null,0,"IESTFECHA",1,"( MGW10045.cEstado = 3 ) and ( MGW10045.cEsTrad = 0 or MGW10045.cEsTrad = 3 )",0,0,1]
[145,5,1,116,1,1,"c) Disponibles",null,0,"IESTFECHA",1,"( MGW10045.cEstado = 0 ) and ( MGW10045.cEsTrad = 0 or MGW10045.cEsTrad = 3 )",0,0,1]
[146,5,1,116,1,1,"d) Sin emitir",null,0,"IESTFECHA",1,"( MGW10045.cEstado = 1 ) and ( MGW10045.cEsTrad = 0 or MGW10045.cEsTrad = 3 )",0,0,1]
[147,5,1,117,1,1,"b) COMERCIAL",null,0,"IESTFECHA",1,"( MGW10045.cEstado = 13 )",0,0,1]
[148,5,1,117,1,1,"c) COMERCIAL Cancelados",null,0,"IESTFECHA",1,"( MGW10045.cEstado = 12 )",0,0,1]
[149,5,1,117,1,1,"d) CONTABILIDAD",null,0,"IESTFECHA",1,"( MGW10045.cEstado = 14 )",0,0,1]
[150,5,1,114,1,1,"e) XML errores varios",null,0,"IERRFECHA",1,"( MGW10048.cError = 5 )",0,0,1]
[151,5,1,118,0,1,"Asociados",null,null,"IEJPETINOP",1,"( MGW10045.cEstado = 13 or MGW10045.cEstado = 14 )",null,null,1]
[152,5,1,117,0,1,"a) Todos",null,0,"IESTFECHA",1,"( MGW10045.cEstado >= 12  )",0,0,1]
[153,5,1,119,0,1,"Asociados",null,null,"IEJPETINOP",1,null,null,null,1]
[154,5,1,117,1,1,"e) BANCOS - COMERCIAL",null,null,"IESTFECHA",1,"( MGW10045.cEstado = 13 ) and  ( MGW10045.cPagadoBan >= 1 )",null,null,1]
[155,5,1,117,1,1,"f) BANCOS - CONTABILIDAD",null,null,"IESTFECHA",1,"( MGW10045.cEstado = 14 ) and  ( MGW10045.cPagadoBan >= 1 )",null,null,1]
[156,5,1,115,1,1,"b) BANCOS",null,null,"IESTFECHA",1,"( MGW10045.cEstado = 11 ) and  ( MGW10045.cPagadoBan >= 1 )",null,null,1]
[157,5,1,120,0,1,"Asociados",null,0,"IESTFECHA",1,"( MGW10045.cEstado >= 11 ) and ( MGW10045.cPagadoBan = 0 )",0,0,1]
[158,5,1,121,0,1,"Seleccionados",null,0,"IESTFECHA",1,"( MGW10045.cEstado >= 11 ) and ( MGW10045.cPagadoBan <= 1 )",0,0,1]
[159,5,1,122,0,1,"Asociados",null,0,"IDOCTOBAN",1,"( MGW10045.cEstado >= 11 ) and ( MGW10045.cPagadoBan >= 1 )",0,0,1]
[160,5,1,130,0,1,"Movtos CEPs",null,0,"IEDOFECHA",1,null,null,null,null]
[162,5,1,116,1,1,"b.1) Sin aceptación",null,null,"IESTFECHA",1,"( MGW10045.cEstado = 3 and MGW10045.cAutUsba01 = 2 )",null,null,1]
[163,5,1,116,1,1,"b.2) Plazo vencido",null,null,"IESTFECHA",1,"( MGW10045.cEstado = 3 and MGW10045.cAutUsba01 = 3 )",null,null,1]
[164,5,1,116,1,1,"b.3) Con aceptación",null,null,"IESTFECHA",1,"( MGW10045.cEstado = 3 and MGW10045.cAutUsba01 = 4 )",null,null,1]
[165,5,1,132,0,1,"Pendientes",null,null,"IESTFECHA",1,"( MGW10045.cEstado = 5 )",null,null,1]
[166,5,1,133,0,1,"Pendientes",null,null,"IESTFECHA",1,"( MGW10045.cAutUsba01 = 5 and ( (MGW10045.cEstado = 6) or (MGW10045.cEstado = 13) or (MGW10045.cEstado = 11) ) )",null,null,1]
[167,5,1,133,1,1,"Rechazados",null,null,"IESTFECHA",1,"( MGW10045.cAutUsba01 = 1 and ( (MGW10045.cEstado = 6) or (MGW10045.cEstado = 13) or (MGW10045.cEstado = 11) ) )",null,null,1]
[168,5,1,133,1,1,"Aceptados",null,null,"IESTFECHA",1,"( MGW10045.cAutUsba01 = 4 and ( (MGW10045.cEstado = 6) or (MGW10045.cEstado = 13) or (MGW10045.cEstado = 11) ) )",null,null,1]
[169,5,1,116,1,1,"a.1) Cancelación rechazada",null,0,"IESTFECHA",1,"( MGW10045.cEstado = 2 and MGW10045.cAutUsba01 = 1 )",null,null,1]
[170,5,1,132,1,1,"Con solicitud previa",null,0,"IESTFECHA",1,"( MGW10045.cEstado = 5 and MGW10045.cAutUsBa01 = 1 )",null,null,1]
[171,5,1,116,1,1,"a.2) Cancelación en proceso",null,null,"IESTFECHA",1,"( MGW10045.cEstado = 2 and MGW10045.cAutUsba01 = 5 )",null,null,1]
[172,5,1,132,1,1,"Con cancelación en proceso",null,null,"IESTFECHA",1,"( MGW10045.cEstado = 2 and MGW10045.cAutUsba01 = 5 )",null,null,1]
[173,5,1,134,1,1,"REPs con Error",null,null,null,1,null,0,0,1]
[174,5,1,135,0,1,"Plantillas Documentos Periódicos",null,0,"iDocumentoDeFechaSerieFol",0,null,0,0,1]