INSPECCION RESDIS - inventario, movimientos y existencias ====================================================================== ====================================================================== TABLA: fsinventa ====================================================================== Filas: 0 Columnas: Error: Executing query failed [Informix][Informix ODBC Driver][Informix]ORDER BY column (colno) must be in SELECT list. Muestra (3 filas): (vacia) ====================================================================== TABLA: inventario ====================================================================== Filas: 0 Columnas: Error: Executing query failed [Informix][Informix ODBC Driver][Informix]ORDER BY column (colno) must be in SELECT list. Muestra (3 filas): (vacia) ====================================================================== TABLA: fsmovexiste ====================================================================== Filas: 820262 Columnas: Error: Executing query failed [Informix][Informix ODBC Driver][Informix]ORDER BY column (colno) must be in SELECT list. Muestra (3 filas): --- fila 1 --- empresa 1 fecmov 2012-02-14 13:04:42.699 lote C/15170 usuario limbert existencias 126.0000 regularizacion 126.0000 estado E --- fila 2 --- empresa 1 fecmov 2012-02-14 13:04:42.706 lote C/15033 usuario limbert existencias 24.0000 regularizacion 24.0000 estado E --- fila 3 --- empresa 1 fecmov 2012-02-14 13:04:42.712 lote C/14897 usuario limbert existencias 0.0000 regularizacion 0.0000 estado F ====================================================================== TABLA: fsexiste ====================================================================== Filas: 9500 Columnas: Error: Executing query failed [Informix][Informix ODBC Driver][Informix]ORDER BY column (colno) must be in SELECT list. Muestra (3 filas): --- fila 1 --- emp_existe 1 art_existe 000543 alm_existe 1 pro_existe VIL can_existe 0.0000 pre_existe 2.7500 imp_existe 0.00 num_lincom 3621 nli_lincom 1 fec_lincom 26/08/2026 pesmed_bru 4.00 bru_lincom 100.00 tar_lincom 0.00 prio_venda 0 lot_lincom C/500081 num_palet 0 --- fila 2 --- emp_existe 1 art_existe 000492 alm_existe 1 pro_existe VIL can_existe 0.0000 pre_existe 0.8000 imp_existe 0.00 num_lincom 3621 nli_lincom 2 fec_lincom 26/08/2026 pesmed_bru 16.04 bru_lincom 641.50 tar_lincom 0.60 prio_venda 0 lot_lincom C/500082 num_palet 0 --- fila 3 --- emp_existe 1 art_existe 000534 alm_existe 1 pro_existe VIL can_existe 0.0000 pre_existe 2.2500 imp_existe 0.00 num_lincom 3621 nli_lincom 3 fec_lincom 26/08/2026 pesmed_bru 5.83 bru_lincom 122.50 tar_lincom 0.35 prio_venda 0 lot_lincom C/500083 num_palet 0 ====================================================================== TABLA: fsexist2 ====================================================================== Filas: 0 Columnas: Error: Executing query failed [Informix][Informix ODBC Driver][Informix]ORDER BY column (colno) must be in SELECT list. Muestra (3 filas): (vacia) ====================================================================== TABLA: fsstkman ====================================================================== Filas: 144 Columnas: Error: Executing query failed [Informix][Informix ODBC Driver][Informix]ORDER BY column (colno) must be in SELECT list. Muestra (3 filas): --- fila 1 --- emp_stkman 1 art_stkman POM alm_stkman A can_stkman 22.0000 pre_stkman 0.8000 fec_stkman 13/09/2011 cau_stkman FALTA --- fila 2 --- emp_stkman 1 art_stkman ACEL alm_stkman B can_stkman 12.0000 pre_stkman 0.0000 fec_stkman 14/09/2011 cau_stkman NULL --- fila 3 --- emp_stkman 1 art_stkman PLA alm_stkman 1 can_stkman 152.0000 pre_stkman 0.9500 fec_stkman 14/09/2011 cau_stkman inventario FIN. Borra todos los _inspect_*.php cuando acabemos.