{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"CIDRELAC01","type":"number","width":11,"decimals":0},{"name":"CIDSISTEMA","type":"number","width":6,"decimals":0},{"name":"CIDIDIOMA","type":"number","width":11,"decimals":0},{"name":"CNOMBREN01","type":"character","width":9},{"name":"CNOMBREN02","type":"character","width":9},{"name":"CNOMBRER01","type":"character","width":51},{"name":"CSENTENC01","type":"character","width":127},{"name":"CCAMPONA01","type":"character","width":51},{"name":"CFILTRO","type":"character","width":254},{"name":"CTABLAREL1","type":"character","width":9},{"name":"CTABLAREL2","type":"character","width":9},{"name":"CFILTROAUX","type":"character","width":53}],"n_rows":192,"rows_kept":192,"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,"MGW10002","MGW10011","Clientes-Proveedores / Direcciones","MGW10002.cIdClienteProveedor = MGW10011.cIdCatalogo","cIdClienteProveedor","( MGW10011.cTipoCatalogo = 1 and MGW10011.cTipoDireccion = 0 )",null,null,null]
[2,5,1,"MGW10002","MGW10001","Clientes-Proveedores / AgentesVentaCobro","( MGW10002.cIdAgenteVenta = MGW10001.cIdAgente or MGW10002.cIdAgenteCobro = MGW10001.cIdAgente )","cIdAgenteVenta",null,null,null,null]
[3,5,1,"MGW10002","MGW10003","Clientes-Proveedores / Almacenes","MGW10002.cIdAlmacen = MGW10003.cIdAlmacen","cIdAlmacen",null,null,null,null]
[5,5,1,"MGW10001","MGW10002","Agentes / Clientes","( MGW10001.cIdCliente = MGW10002.cIdClienteProveedor or MGW10001.cIdProveedor = MGW10002.cIdClienteProveedor )","cIdCliente",null,null,null,null]
[6,5,1,"MGW10008","MGW10002","Documentos / Clientes-Proveedores","MGW10008.cIdClienteProveedor = MGW10002.cIdClienteProveedor","cIdClienteProveedor",null,null,null,null]
[7,5,1,"MGW10008","MGW10011","Documentos / Direcciones","MGW10008.cIdDocumento = MGW10011.cIdCatalogo","cIdDocumento","( MGW10011.cTipoCatalogo = 3 )",null,null,null]
[8,5,1,"MGW10008","MGW10006","Documentos / Conceptos","MGW10008.cIdConceptoDocumento = MGW10006.cIdConceptoDocumento","cIdConceptoDocumento",null,null,null,null]
[9,5,1,"MGW10008","MGW10007","Documentos / DocumentosModelo","MGW10008.cIdDocumentoDe = MGW10007.cIdDocumentoDe","cIdDocumentoDe",null,null,null,null]
[10,5,1,"MGW10008","MGW10034","Documentos / Monedas","MGW10008.cIdMoneda = MGW10034.cIdMoneda","cIdMoneda",null,null,null,null]
[4,5,1,"MGW10002","MGW10034","Clientes-Proveedores / Monedas","MGW10002.cIdMoneda = MGW10034.cIdMoneda","cIdMoneda",null,null,null,null]
[11,5,1,"MGW10002","1","Clientes",null,null,"( MGW10002.cTipoCliente = 1 or MGW10002.cTipoCliente = 2 )",null,null,null]
[12,5,1,"MGW10002","2","Proveedores",null,null,"( MGW10002.cTipoCliente = 2 or MGW10002.cTipoCliente = 3 )",null,null,null]
[13,5,1,"MGW10011","MGW10002","Direcciones / Clientes-Proveedores","MGW10002.cIdClienteProveedor = MGW10011.cIdCatalogo","cIdClienteProveedor","( MGW10011.cTipoCatalogo = 1 and MGW10011.cTipoDireccion = 0 )",null,null,null]
[14,5,1,"MGW10003","MGW10002","Almacenes / Clientes-Proveedores","MGW10002.cIdAlmacen = MGW10003.cIdAlmacen","cIdAlmacen",null,null,null,null]
[15,5,1,"MGW10034","MGW10002","Monedas / Clientes-Proveedores","MGW10002.cIdMoneda = MGW10034.cIdMoneda","cIdMoneda",null,null,null,null]
[16,5,1,"MGW10002","MGW10008","Clientes-Proveedores / Documentos","MGW10002.cIdClienteProveedor = MGW10008.cIdClienteProveedor","cIdClienteProveedor",null,null,null,null]
[17,5,1,"MGW10011","MGW10008","Direcciones / Documentos","MGW10008.cIdDocumento = MGW10011.cIdCatalogo","cIdDocumento","( MGW10011.cTipoCatalogo = 3 )",null,null,null]
[18,5,1,"MGW10006","MGW10008","Conceptos / Documentos","MGW10006.cIdConceptoDocumento = MGW10008.cIdConceptoDocumento","cIdConceptoDocumento",null,null,null,null]
[19,5,1,"MGW10007","MGW10008","DcoumentosModelo / Documentos","MGW10007.cIdDocumentoDe = MGW10008.cIdDocumentoDe","cIdDocumentoDe",null,null,null,null]
[20,5,1,"MGW10034","MGW10008","Monedas / Documentos","MGW10034.cIdMoneda = MGW10008.cIdMoneda","cIdMoneda",null,null,null,null]
[21,5,1,"MGW10005","5","Productos",null,null,"( MGW10005.cTipoProducto = 1 )",null,null,null]
[22,5,1,"MGW10005","6","Servicios",null,null,"( MGW10005.cTipoProducto = 3 )",null,null,null]
[23,5,1,"MGW10005","7","Paquetes",null,null,"( MGW10005.cTipoProducto = 2 )",null,null,null]
[24,5,1,"MGW10008","19","Cargos al Cliente",null,null,"( MGW10008.cIdDocumentoDe >= 8 and MGW10008.cIdDocumentoDe <=16 ) and ( MGW10008.cIdDocumentoDe <> 9 ) and ( MGW10008.cIdDocumentoDe <> 10 ) and ( MGW10008.cIdDocumentoDe <> 11 ) and ( MGW10008.cIdDocumentoDe <> 12 ) and (MGW10008.cIdDocumentoDe <> 14)","MGW10007","MGW10006","( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[25,5,1,"MGW10008","20","Abonos del Cliente",null,null,"( MGW10008.cIdDocumentoDe >= 7 and MGW10008.cIdDocumentoDe <=14 ) and ( MGW10008.cIdDocumentoDe <> 8 ) and ( MGW10008.cIdDocumentoDe <> 13 )","MGW10007","MGW10006","( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[26,5,1,"MGW10008","21","Cargos del Proveedor",null,null,"( MGW10008.cIdDocumentoDe >= 25 and MGW10008.cIdDocumentoDe <= 27 ) and ( MGW10008.cIdDocumentoDe <> 26 )","MGW10007","MGW10006","( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[27,5,1,"MGW10008","22","Abonos del Proveedor",null,null,"( MGW10008.cIdDocumentoDe >= 22 and MGW10008.cIdDocumentoDe <= 26 ) and ( MGW10008.cIdDocumentoDe <> 25 )","MGW10007","MGW10006","( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[28,5,1,"MGW10008","23","Entradas de Inventario",null,null,"( MGW10008.cIdDocumentoDe = 32 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[29,5,1,"MGW10008","24","Salidas de Inventario",null,null,"( MGW10008.cIdDocumentoDe = 33 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[30,5,1,"MGW10008","25","Traspasos entre Inventarios",null,null,"( MGW10008.cIdDocumentoDe = 34 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[31,5,1,"MGW10008","27","Ajustes al Costo",null,null,"( MGW10008.cIdDocumentoDe = 37 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[32,5,1,"MGW10008","8","Facturas",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[33,5,1,"MGW10008","9","Pedidos",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[34,5,1,"MGW10008","10","Cotizaciones",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[35,5,1,"MGW10008","11","Remisiones",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[36,5,1,"MGW10008","12","Devoluciones sobre Venta",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[37,5,1,"MGW10008","13","Devoluciones de Remision",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[38,5,1,"MGW10008","14","Compras",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[39,5,1,"MGW10008","15","Ordenes de Compra",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[40,5,1,"MGW10008","16","Consignaciones",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[41,5,1,"MGW10008","17","Devoluciones sobre Compra",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[42,5,1,"MGW10008","18","Devoluciones de Consignacion",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[43,5,1,"MGW10006","MGW10007","Conceptos / DocumentosModelo","MGW10006.cIdDocumentoDe = MGW10007.cIdDocumentoDe","cIdDocumentoDe",null,null,null,null]
[44,5,1,"MGW10002","MGW10012","Clientes-Proveedores / Clasificaciones","MGW10002",null,null,null,null,null]
[45,5,1,"MGW10008","MGW10001","Documentos / Agentes","MGW10008.cIdAgente = MGW10001.cIdAgente","cIdAgente",null,null,null,null]
[46,5,1,"MGW10007","MGW10006","DocumentosModelo / Conceptos","MGW10007.cIdDocumentoDe = MGW10006.cIdDocumentoDe","cIdDocumentoDe",null,null,null,null]
[47,5,1,"MGW10001","3","Agentes",null,null,"( MGW10001.cIdAgente > 0 )",null,null,null]
[48,5,1,"MGW10003","4","Almacenes",null,null,"( MGW10003.cIdAlmacen > 0 )",null,null,null]
[49,5,1,"MGW10008","50","TODAS Facturas",null,null,"( MGW10008.cIdDocumentoDe = 4 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[50,5,1,"MGW10008","51","TODOS Pedidos",null,null,"( MGW10008.cIdDocumentoDe = 2 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[51,5,1,"MGW10008","52","TODAS Cotizaciones",null,null,"( MGW10008.cIdDocumentoDe = 1 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[52,5,1,"MGW10008","53","TODAS Remisiones",null,null,"( MGW10008.cIdDocumentoDe = 3 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[53,5,1,"MGW10008","54","TODAS Dev Ventas",null,null,"( MGW10008.cIdDocumentoDe = 5 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[54,5,1,"MGW10008","55","TODAS Dev Remisiones",null,null,"( MGW10008.cIdDocumentoDe = 6 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[55,5,1,"MGW10008","56","TODAS Compras",null,null,"( MGW10008.cIdDocumentoDe = 19 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[56,5,1,"MGW10008","57","TODAS Ordenes",null,null,"( MGW10008.cIdDocumentoDe = 17 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[58,5,1,"MGW10008","59","TODAS Dev Compra",null,null,"( MGW10008.cIdDocumentoDe = 20 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[57,5,1,"MGW10008","58","TODAS Consignaciones",null,null,"( MGW10008.cIdDocumentoDe = 18 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[59,5,1,"MGW10008","60","TODAS Dev Consignaciones",null,null,"( MGW10008.cIdDocumentoDe = 21 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[60,5,1,"MGW10008","61","Cargos ClienteConcepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[61,5,1,"MGW10008","62","Abonos Cliente Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[62,5,1,"MGW10008","63","Cargos Proveedor Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[63,5,1,"MGW10008","64","Abonos Proveedor Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[64,5,1,"MGW10008","65","Cargos Proveedor Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[65,5,1,"MGW10008","66","Entradas Inventario Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[66,5,1,"MGW10008","67","Salidas Inventario Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[67,5,1,"MGW10008","68","Ajustes Inventario Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[68,5,1,"MGW10008","30","Saldos de Clientes",null,null,"( MGW10008.cIdClienteProveedor = %i and MGW10008.cUsaCliente = 1 and  MGW10008.cNaturaleza < 2 and MGW10008.cAfectado = 1 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[69,5,1,"MGW10008","31","Saldos de Proveedores",null,null,"( MGW10008.cIdClienteProveedor = %i and MGW10008.cUsaProveedor = 1 and  MGW10008.cNaturaleza < 2 and MGW10008.cAfectado = 1 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[70,5,1,"MGW10045","MGW10007","Folios SAT / DocumentosModelo","MGW10045.cIdDoctoDe = MGW10007.cIdDocumentoDe","cIdDocumentoDe",null,null,null,null]
[71,5,1,"MGW10045","MGW10006","Folios SAT / Conceptos","MGW10045.cIdCptoDoc = MGW10006.cIdConceptoDocumento","cIdConceptoDocumento",null,null,null,null]
[72,5,1,"MGW10045","69","Folios SAT",null,null,null,null,null,null]
[73,5,1,"MGW10017","MGW10005","Costos Historicos / Productos","MGW10017.cIdProducto = MGW10005.cIdProducto","cIdProducto",null,null,null,null]
[74,5,1,"MGW10017","MGW10003","Costos Historicos / Almacenes","MGW10017.cIdAlmacen = MGW10003.cIdAlmacen","cIdAlmacen",null,null,null,null]
[75,5,1,"MGW10017","74","Costos Historicos",null,null,"( MGW10017.cIdProducto = %i and MGW10017.cIdAlmacen = %i )",null,null,null]
[76,5,1,"MGW10030","MGW10003","CostosExistencia / Almacenes","MGW10030.cIdAlmacen = MGW10003.cIdAlmacen","cIdAlmacen",null,null,null,null]
[77,5,1,"MGW10030","MGW10005","CostosExistencia / Productos","MGW10030.cIdProducto = MGW10005.cIdProducto","cIdProducto",null,null,null,null]
[78,5,1,"MGW10030","75","Costos Existencia",null,null,"( MGW10030.cIdProducto = %i and MGW10030.cIdAlmacen = %i )",null,null,null]
[79,5,1,"MGW10030","MGW10031","CostosExistencia / Ejercicio","MGW10030.cIdEjercicio = MGW10031.cIdEjercicio",null,null,null,null,null]
[80,5,1,"MGW10014","76","Lista de Precios de Compra",null,null,"( MGW10014.cIdProducto = %i and MGW10014.cIdProveedor = %i )",null,null,null]
[81,5,1,"MGW10014","MGW10002","PreciosCompra / Proveedores","MGW10014.cIdProveedor = MGW10002.cIdClienteProveedor","cIdProveedor",null,null,null,null]
[82,5,1,"MGW10014","MGW10005","PreciosCompra / Productos","MGW10014.cIdProducto = MGW10005.cIdProducto","cIdProducto",null,null,null,null]
[83,5,1,"MGW10014","MGW10026","PreciosCompra / Unidades","MGW10014.cIdUnidad = MGW10026.cIdUnidad","cIdUnidad",null,null,null,null]
[84,5,1,"MGW10014","MGW10034","PreciosCompra / Monedas","MGW10014.cIdMoneda = MGW10034.cIdMoneda","cIdMoneda",null,null,null,null]
[85,5,1,"MGW10018","MGW10012","Acumulados / Tipos de Acumulados","MGW10018.cIdTipoAcumulado = MGW10012.cIdTipoAcumulado","cIdTipoAcumulado",null,null,null,null]
[86,5,1,"MGW10018","MGW10034","Acumulados / Monedas","MGW10018.cIdMoneda = MGW10034.cIdMoneda","cIdMoneda",null,null,null,null]
[87,5,1,"MGW10018","77","Acumulados Estado Sistema",null,null,"( MGW10018.cIdOwner1 = 0 and MGW10018.cIdOwner2 = 0  and MGW10018.cImporteModelo <> 1 )",null,null,null]
[88,5,1,"MGW10018","MGW10031","Acumulados / Ejercicios","MGW10018.cIdEjercicio = MGW10031.cIdEjercicio","cIdEjercicio",null,null,null,null]
[89,5,1,"MGW10009","70","Asociación Pago","MGW10009.cIdDocumentoCargo = MGW10008.cIdDocumento",null,null,null,null,null]
[90,5,1,"MGW10009","71","Asociación Pago","MGW10009.cIdDocumentoAbono = MGW10008.cIdDocumento",null,null,null,null,null]
[91,5,1,"MGW10009","72","Asociación Pago","MGW10009.cIdDocumentoAbono = MGW10008.cIdDocumento",null,null,null,null,null]
[92,5,1,"MGW10009","73","Asociación Pago","MGW10009.cIdDocumentoCargo = MGW10008.cIdDocumento",null,null,null,null,null]
[95,5,1,"CAC60000","100","Bitácora de operaciones",null,null,"( CAC60000.Fecha = @Hoy and CAC60000.IdSistema = %i )",null,null,null]
[98,101,1,"MGW10001","3","Agentes",null,null,"( MGW10001.cIdAgente > 0 )",null,null,null]
[99,101,1,"MGW10001","MGW10002","Agentes / Clientes","( MGW10001.cIdCliente = MGW10002.cIdClienteProveedor or MGW10001.cIdProveedor = MGW10002.cIdClienteProveedor )","cIdCliente",null,null,null,null]
[100,101,1,"MGW10002","1","Clientes",null,null,"( MGW10002.cTipoCliente < 3 )",null,null,null]
[101,101,1,"MGW10002","2","Proveedores",null,null,"( MGW10002.cTipoCliente > 1 )",null,null,null]
[102,101,1,"MGW10002","MGW10001","Clientes-Proveedores / AgentesVentaCobro","( MGW10002.cIdAgenteVenta = MGW10001.cIdAgente or MGW10002.cIdAgenteCobro = MGW10001.cIdAgente )","cIdAgenteVenta",null,null,null,null]
[103,101,1,"MGW10002","MGW10003","Clientes-Proveedores / Almacenes","MGW10002.cIdAlmacen = MGW10003.cIdAlmacen","cIdAlmacen",null,null,null,null]
[104,101,1,"MGW10002","MGW10008","Clientes-Proveedores / Documentos","MGW10002.cIdClienteProveedor = MGW10008.cIdClienteProveedor","cIdClienteProveedor",null,null,null,null]
[105,101,1,"MGW10002","MGW10011","Clientes-Proveedores / Direcciones","MGW10002.cIdClienteProveedor = MGW10011.cIdCatalogo","cIdClienteProveedor","( MGW10011.cTipoCatalogo = 1 and MGW10011.cTipoDireccion = 0 )",null,null,null]
[106,101,1,"MGW10002","MGW10012","Clientes-Proveedores / Clasificaciones","MGW10002",null,null,null,null,null]
[107,101,1,"MGW10002","MGW10034","Clientes-Proveedores / Monedas","MGW10002.cIdMoneda = MGW10034.cIdMoneda","cIdMoneda",null,null,null,null]
[108,101,1,"MGW10003","4","Almacenes",null,null,"( MGW10003.cIdAlmacen > 0 )",null,null,null]
[109,101,1,"MGW10003","MGW10002","Almacenes / Clientes-Proveedores","MGW10002.cIdAlmacen = MGW10003.cIdAlmacen","cIdAlmacen",null,null,null,null]
[110,101,1,"MGW10005","5","Productos",null,null,"( MGW10005.cTipoProducto = 1 and MGW10005.cSubTipo = 0 )",null,null,null]
[111,101,1,"MGW10005","6","Servicios",null,null,"( MGW10005.cTipoProducto = 3 and MGW10005.cSubTipo = 0 )",null,null,null]
[112,101,1,"MGW10005","7","Paquetes",null,null,"( MGW10005.cTipoProducto = 1 and MGW10005.cSubTipo = 2 )",null,null,null]
[113,101,1,"MGW10005","MGW10034","Productos / Monedas","MGW10005.cIdMoneda = MGW10034.cIdMoneda","cIdMoneda",null,null,null,null]
[114,101,1,"MGW10006","MGW10007","Conceptos / DocumentosModelo","MGW10006.cIdDocumentoDe = MGW10007.cIdDocumentoDe","cIdDocumentoDe",null,null,null,null]
[115,101,1,"MGW10006","MGW10008","Conceptos / Documentos","MGW10006.cIdConceptoDocumento = MGW10008.cIdConceptoDocumento","cIdConceptoDocumento",null,null,null,null]
[116,101,1,"MGW10007","MGW10006","DocumentosModelo / Conceptos","MGW10007.cIdDocumentoDe = MGW10006.cIdDocumentoDe","cIdDocumentoDe",null,null,null,null]
[117,101,1,"MGW10007","MGW10008","DcoumentosModelo / Documentos","MGW10007.cIdDocumentoDe = MGW10008.cIdDocumentoDe","cIdDocumentoDe",null,null,null,null]
[118,101,1,"MGW10008","10","Cotizaciones",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[119,101,1,"MGW10008","11","Remisiones",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[120,101,1,"MGW10008","12","Devoluciones sobre Venta",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[121,101,1,"MGW10008","13","Devoluciones de Remision",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[122,101,1,"MGW10008","14","Compras",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[123,101,1,"MGW10008","15","Ordenes de Compra",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[124,101,1,"MGW10008","16","Consignaciones",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[125,101,1,"MGW10008","17","Devoluciones sobre Compra",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[126,101,1,"MGW10008","18","Devoluciones de Consignacion",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[127,101,1,"MGW10008","19","Cargos al Cliente",null,null,"( MGW10008.cIdDocumentoDe >= 8 and MGW10008.cIdDocumentoDe <=16 ) and ( MGW10008.cIdDocumentoDe <> 9 ) and ( MGW10008.cIdDocumentoDe <> 10 ) and ( MGW10008.cIdDocumentoDe <> 11 ) and ( MGW10008.cIdDocumentoDe <> 12 ) and (MGW10008.cIdDocumentoDe <> 14)","MGW10007","MGW10006",null]
[128,101,1,"MGW10008","20","Abonos del Cliente",null,null,"( MGW10008.cIdDocumentoDe >= 7 and MGW10008.cIdDocumentoDe <=14 ) and ( MGW10008.cIdDocumentoDe <> 8 ) and ( MGW10008.cIdDocumentoDe <> 13 )","MGW10007","MGW10006",null]
[129,101,1,"MGW10008","21","Cargos del Proveedor",null,null,"( MGW10008.cIdDocumentoDe >= 25 and MGW10008.cIdDocumentoDe <= 27 ) and ( MGW10008.cIdDocumentoDe <> 26 )","MGW10007","MGW10006",null]
[130,101,1,"MGW10008","22","Abonos del Proveedor",null,null,"( MGW10008.cIdDocumentoDe >= 22 and MGW10008.cIdDocumentoDe <= 26 ) and ( MGW10008.cIdDocumentoDe <> 25 )","MGW10007","MGW10006",null]
[131,101,1,"MGW10008","23","Entradas de Inventario",null,null,"( MGW10008.cIdDocumentoDe = 32 )",null,null,null]
[132,101,1,"MGW10008","24","Salidas de Inventario",null,null,"( MGW10008.cIdDocumentoDe = 33 )",null,null,null]
[133,101,1,"MGW10008","25","Traspasos entre Inventarios",null,null,"( MGW10008.cIdDocumentoDe = 34 )",null,null,null]
[134,101,1,"MGW10008","27","Ajustes al Costo",null,null,"( MGW10008.cIdDocumentoDe = 37 )",null,null,null]
[135,101,1,"MGW10008","30","Saldos de Clientes",null,null,"( MGW10008.cIdClienteProveedor = %i and MGW10008.cUsaCliente = 1 and  MGW10008.cNaturaleza < 2 and MGW10008.cAfectado = 1 )",null,null,null]
[136,101,1,"MGW10008","31","Saldos de Proveedores",null,null,"( MGW10008.cIdClienteProveedor = %i and MGW10008.cUsaProveedor = 1 and  MGW10008.cNaturaleza < 2 and MGW10008.cAfectado = 1 )",null,null,null]
[137,101,1,"MGW10008","50","TODAS Facturas",null,null,"( MGW10008.cIdDocumentoDe = 4 )",null,null,null]
[138,101,1,"MGW10008","51","TODOS Pedidos",null,null,"( MGW10008.cIdDocumentoDe = 2 )",null,null,null]
[139,101,1,"MGW10008","52","TODAS Cotizaciones",null,null,"( MGW10008.cIdDocumentoDe = 1 )",null,null,null]
[140,101,1,"MGW10008","53","TODAS Remisiones",null,null,"( MGW10008.cIdDocumentoDe = 3 )",null,null,null]
[141,101,1,"MGW10008","54","TODAS Dev Ventas",null,null,"( MGW10008.cIdDocumentoDe = 5 )",null,null,null]
[142,101,1,"MGW10008","55","TODAS Dev Remisiones",null,null,"( MGW10008.cIdDocumentoDe = 6 )",null,null,null]
[143,101,1,"MGW10008","56","TODAS Compras",null,null,"( MGW10008.cIdDocumentoDe = 19 )",null,null,null]
[144,101,1,"MGW10008","57","TODAS Ordenes",null,null,"( MGW10008.cIdDocumentoDe = 17 )",null,null,null]
[145,101,1,"MGW10008","58","TODAS Consignaciones",null,null,"( MGW10008.cIdDocumentoDe = 18 )",null,null,null]
[146,101,1,"MGW10008","59","TODAS Dev Compra",null,null,"( MGW10008.cIdDocumentoDe = 20 )",null,null,null]
[147,101,1,"MGW10008","60","TODAS Dev Consignaciones",null,null,"( MGW10008.cIdDocumentoDe = 21 )",null,null,null]
[148,101,1,"MGW10008","61","Cargos ClienteConcepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[149,101,1,"MGW10008","62","Abonos Cliente Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[150,101,1,"MGW10008","63","Cargos Proveedor Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[151,101,1,"MGW10008","64","Abonos Proveedor Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[152,101,1,"MGW10008","65","Cargos Proveedor Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[153,101,1,"MGW10008","66","Entradas Inventario Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[154,101,1,"MGW10008","67","Salidas Inventario Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[155,101,1,"MGW10008","68","Ajustes Inventario Concepto",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[156,101,1,"MGW10008","8","Facturas",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[157,101,1,"MGW10008","9","Pedidos",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,null]
[158,101,1,"MGW10008","MGW10001","Documentos / Agentes","MGW10008.cIdAgente = MGW10001.cIdAgente","cIdAgente",null,null,null,null]
[159,101,1,"MGW10008","MGW10002","Documentos / Clientes-Proveedores","MGW10008.cIdClienteProveedor = MGW10002.cIdClienteProveedor","cIdClienteProveedor",null,null,null,null]
[160,101,1,"MGW10008","MGW10006","Documentos / Conceptos","MGW10008.cIdConceptoDocumento = MGW10006.cIdConceptoDocumento","cIdConceptoDocumento",null,null,null,null]
[161,101,1,"MGW10008","MGW10007","Documentos / DocumentosModelo","MGW10008.cIdDocumentoDe = MGW10007.cIdDocumentoDe","cIdDocumentoDe",null,null,null,null]
[162,101,1,"MGW10008","MGW10011","Documentos / Direcciones","MGW10008.cIdDocumento = MGW10011.cIdCatalogo","cIdDocumento","( MGW10011.cTipoCatalogo = 3 )",null,null,null]
[163,101,1,"MGW10008","MGW10034","Documentos / Monedas","MGW10008.cIdMoneda = MGW10034.cIdMoneda","cIdMoneda",null,null,null,null]
[164,101,1,"MGW10009","70","Asociación Pago","MGW10009.cIdDocumentoCargo = MGW10008.cIdDocumento",null,null,null,null,null]
[165,101,1,"MGW10009","71","Asociación Pago","MGW10009.cIdDocumentoAbono = MGW10008.cIdDocumento",null,null,null,null,null]
[166,101,1,"MGW10009","72","Asociación Pago","MGW10009.cIdDocumentoAbono = MGW10008.cIdDocumento",null,null,null,null,null]
[167,101,1,"MGW10009","73","Asociación Pago","MGW10009.cIdDocumentoCargo = MGW10008.cIdDocumento",null,null,null,null,null]
[168,101,1,"MGW10011","MGW10002","Direcciones / Clientes-Proveedores","MGW10002.cIdClienteProveedor = MGW10011.cIdCatalogo","cIdClienteProveedor","( MGW10011.cTipoCatalogo = 1 and MGW10011.cTipoDireccion = 0 )",null,null,null]
[169,101,1,"MGW10011","MGW10008","Direcciones / Documentos","MGW10008.cIdDocumento = MGW10011.cIdCatalogo","cIdDocumento","( MGW10011.cTipoCatalogo = 3 )",null,null,null]
[170,101,1,"MGW10014","76","Lista de Precios de Compra",null,null,"( MGW10014.cIdProducto = %i and MGW10014.cIdProveedor = %i )",null,null,null]
[171,101,1,"MGW10014","MGW10002","PreciosCompra / Proveedores","MGW10014.cIdProveedor = MGW10002.cIdClienteProveedor","cIdProveedor",null,null,null,null]
[172,101,1,"MGW10014","MGW10005","PreciosCompra / Productos","MGW10014.cIdProducto = MGW10005.cIdProducto","cIdProducto",null,null,null,null]
[173,101,1,"MGW10014","MGW10026","PreciosCompra / Unidades","MGW10014.cIdUnidad = MGW10026.cIdUnidad","cIdUnidad",null,null,null,null]
[174,101,1,"MGW10014","MGW10034","PreciosCompra / Monedas","MGW10014.cIdMoneda = MGW10034.cIdMoneda","cIdMoneda",null,null,null,null]
[175,101,1,"MGW10017","74","Costos Historicos",null,null,"( MGW10017.cIdProducto = %i and MGW10017.cIdAlmacen = %i )",null,null,null]
[176,101,1,"MGW10017","MGW10003","Costos Historicos / Almacenes","MGW10017.cIdAlmacen = MGW10003.cIdAlmacen","cIdAlmacen",null,null,null,null]
[177,101,1,"MGW10017","MGW10005","Costos Historicos / Productos","MGW10017.cIdProducto = MGW10005.cIdProducto","cIdProducto",null,null,null,null]
[178,101,1,"MGW10018","77","Acumulados Estado Sistema",null,null,"( MGW10018.cIdOwner1 = 0 and MGW10018.cIdOwner2 = 0  and MGW10018.cImporteModelo <> 1 )",null,null,null]
[179,101,1,"MGW10018","MGW10012","Acumulados / Tipos de Acumulados","MGW10018.cIdTipoAcumulado = MGW10012.cIdTipoAcumulado","cIdTipoAcumulado",null,null,null,null]
[180,101,1,"MGW10018","MGW10031","Acumulados / Ejercicios","MGW10018.cIdEjercicio = MGW10031.cIdEjercicio","cIdEjercicio",null,null,null,null]
[181,101,1,"MGW10018","MGW10034","Acumulados / Monedas","MGW10018.cIdMoneda = MGW10034.cIdMoneda","cIdMoneda",null,null,null,null]
[182,101,1,"MGW10030","75","Costos Existencia",null,null,"( MGW10030.cIdProducto = %i and MGW10030.cIdAlmacen = %i )",null,null,null]
[183,101,1,"MGW10030","MGW10003","CostosExistencia / Almacenes","MGW10030.cIdAlmacen = MGW10003.cIdAlmacen","cIdAlmacen",null,null,null,null]
[184,101,1,"MGW10030","MGW10005","CostosExistencia / Productos","MGW10030.cIdProducto = MGW10005.cIdProducto","cIdProducto",null,null,null,null]
[185,101,1,"MGW10030","MGW10031","CostosExistencia / Ejercicio","MGW10030.cIdEjercicio = MGW10031.cIdEjercicio",null,null,null,null,null]
[186,101,1,"MGW10034","MGW10002","Monedas / Clientes-Proveedores","MGW10002.cIdMoneda = MGW10034.cIdMoneda","cIdMoneda",null,null,null,null]
[187,101,1,"MGW10034","MGW10008","Monedas / Documentos","MGW10034.cIdMoneda = MGW10008.cIdMoneda","cIdMoneda",null,null,null,null]
[188,101,1,"MGW10045","69","Folios SAT",null,null,null,null,null,null]
[189,101,1,"MGW10045","MGW10006","Folios SAT / Conceptos","MGW10045.cIdCptoDoc = MGW10006.cIdConceptoDocumento","cIdConceptoDocumento",null,null,null,null]
[190,101,1,"MGW10045","MGW10007","Folios SAT / DocumentosModelo","MGW10045.cIdDoctoDe = MGW10007.cIdDocumentoDe","cIdDocumentoDe",null,null,null,null]
[191,5,1,"MGW10008","90","Cotizaciones Proveedor",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[192,5,1,"MGW10008","91","TODAS Cotizaciones Proveedor",null,null,"( MGW10008.cIdDocumentoDe = 38 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[193,5,1,"MGW10008","102","Ajustes al IVA",null,null,"( MGW10008.cIdConceptoDocumento = %i and MGW10008.cIdDocumentoOrigen > 0 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[194,5,1,"MGW10008","136","Documentos Periódicos",null,null,"( MGW10008.cIdConceptoDocumento = %i )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[195,5,1,"MGW10008","150","Documentos Clientes",null,null,"( MGW10008.cIdDocumentoDe <> 5 and MGW10008.cIdDocumentoDe <> 6 and MGW10008.cIdDocumentoDe <> 28 and MGW10008.cIdDocumentoDe <> 29 and MGW10008.cIdDocumentoDe <> 35 and MGW10008.cIdDocumentoDe <> 36 and MGW10008.cIdDocumentoDe <> 39 )",null,null,"( MGW10008.cFecha >= %s and MGW10008.cFecha <= %s )"]
[196,5,1,"MGW10045","MGW10008","Folios SAT / Documentos","MGW10045.cIdDocto = MGW10008.cIdDocumento","cIdDocumento",null,null,null,null]