QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-01_21:00:07 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-01_21:00:10 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-01_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-01_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-01_21:00:11 EMPEZO ->> 2024-12-01_21:00:01 TERMINO ->> 2024-12-01_21:00:11 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-02_21:00:07 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-02_21:00:10 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-02_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-02_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-02_21:00:10 EMPEZO ->> 2024-12-02_21:00:01 TERMINO ->> 2024-12-02_21:00:10 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-03_21:00:07 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-03_21:00:10 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-03_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-03_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-03_21:00:10 EMPEZO ->> 2024-12-03_21:00:02 TERMINO ->> 2024-12-03_21:00:10 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-04_21:00:07 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-04_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-04_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-04_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-04_21:00:10 EMPEZO ->> 2024-12-04_21:00:01 TERMINO ->> 2024-12-04_21:00:10 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-05_21:00:20 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-05_21:00:27 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-05_21:00:28 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-05_21:00:28 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-05_21:00:28 EMPEZO ->> 2024-12-05_21:00:01 TERMINO ->> 2024-12-05_21:00:28 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-06_21:00:49 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-06_21:00:55 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-06_21:00:55 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-06_21:00:56 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-06_21:00:56 EMPEZO ->> 2024-12-06_21:00:30 TERMINO ->> 2024-12-06_21:00:56 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-07_21:00:35 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-07_21:00:37 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-07_21:00:37 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-07_21:00:37 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-07_21:00:38 EMPEZO ->> 2024-12-07_21:00:29 TERMINO ->> 2024-12-07_21:00:38 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-08_21:00:35 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-08_21:00:37 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-08_21:00:37 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-08_21:00:38 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-08_21:00:38 EMPEZO ->> 2024-12-08_21:00:29 TERMINO ->> 2024-12-08_21:00:38 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-09_21:00:35 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-09_21:00:38 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-09_21:00:38 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-09_21:00:38 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-09_21:00:38 EMPEZO ->> 2024-12-09_21:00:29 TERMINO ->> 2024-12-09_21:00:38 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-10_21:00:48 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-10_21:00:56 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-10_21:00:56 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-10_21:00:56 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-10_21:00:57 EMPEZO ->> 2024-12-10_21:00:29 TERMINO ->> 2024-12-10_21:00:57 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-11_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-11_21:00:13 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-11_21:00:13 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-11_21:00:13 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-11_21:00:13 EMPEZO ->> 2024-12-11_21:00:01 TERMINO ->> 2024-12-11_21:00:13 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-12_21:00:08 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-12_21:00:10 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-12_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-12_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-12_21:00:10 EMPEZO ->> 2024-12-12_21:00:02 TERMINO ->> 2024-12-12_21:00:10 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-13_21:00:07 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-13_21:00:10 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-13_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-13_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-13_21:00:10 EMPEZO ->> 2024-12-13_21:00:02 TERMINO ->> 2024-12-13_21:00:10 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-14_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-14_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-14_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-14_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-14_21:00:09 EMPEZO ->> 2024-12-14_21:00:01 TERMINO ->> 2024-12-14_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-15_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-15_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-15_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-15_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-15_21:00:09 EMPEZO ->> 2024-12-15_21:00:01 TERMINO ->> 2024-12-15_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-16_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-16_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-16_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-16_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-16_21:00:09 EMPEZO ->> 2024-12-16_21:00:01 TERMINO ->> 2024-12-16_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-17_21:00:07 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-17_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-17_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-17_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-17_21:00:09 EMPEZO ->> 2024-12-17_21:00:02 TERMINO ->> 2024-12-17_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-18_21:00:07 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-18_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-18_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-18_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-18_21:00:09 EMPEZO ->> 2024-12-18_21:00:02 TERMINO ->> 2024-12-18_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-19_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-19_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-19_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-19_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-19_21:00:09 EMPEZO ->> 2024-12-19_21:00:01 TERMINO ->> 2024-12-19_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-20_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-20_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-20_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-20_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-20_21:00:09 EMPEZO ->> 2024-12-20_21:00:01 TERMINO ->> 2024-12-20_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-21_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-21_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-21_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-21_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-21_21:00:09 EMPEZO ->> 2024-12-21_21:00:01 TERMINO ->> 2024-12-21_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-22_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-22_21:00:08 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-22_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-22_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-22_21:00:08 EMPEZO ->> 2024-12-22_21:00:01 TERMINO ->> 2024-12-22_21:00:08 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-23_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-23_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-23_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-23_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-23_21:00:09 EMPEZO ->> 2024-12-23_21:00:01 TERMINO ->> 2024-12-23_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-24_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-24_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-24_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-24_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-24_21:00:09 EMPEZO ->> 2024-12-24_21:00:02 TERMINO ->> 2024-12-24_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-25_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-25_21:00:08 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-25_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-25_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-25_21:00:08 EMPEZO ->> 2024-12-25_21:00:01 TERMINO ->> 2024-12-25_21:00:08 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-26_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-26_21:00:08 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-26_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-26_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-26_21:00:09 EMPEZO ->> 2024-12-26_21:00:01 TERMINO ->> 2024-12-26_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-27_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-27_21:00:08 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-27_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-27_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-27_21:00:09 EMPEZO ->> 2024-12-27_21:00:01 TERMINO ->> 2024-12-27_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-28_21:00:07 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-28_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-28_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-28_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-28_21:00:09 EMPEZO ->> 2024-12-28_21:00:02 TERMINO ->> 2024-12-28_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-29_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-29_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-29_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-29_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-29_21:00:09 EMPEZO ->> 2024-12-29_21:00:01 TERMINO ->> 2024-12-29_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-30_21:00:07 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-30_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-30_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-30_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-30_21:00:09 EMPEZO ->> 2024-12-30_21:00:02 TERMINO ->> 2024-12-30_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-31_21:00:08 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-31_21:00:10 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-31_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'ANULADO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2024-12-31_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2, CDPFC2=4, SRI_FAEFEA=99 WHERE YEAR(FEMFCE)=2024 AND MONTH(FEMFCE)>=7 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2024-12-31_21:00:11 EMPEZO ->> 2024-12-31_21:00:03 TERMINO ->> 2024-12-31_21:00:11