SELECT  * FROM DESFOR where codif=5330
SELECT  * FROM despes where codif=5330
SELECT  * FROM condia_Tce where ie=4 and ug=2 and datae >= '01.02.2022'
delete FROM condia_Tce where ie=4 and ug=2 and datae >= '01.02.2022'
SELECT * FROM PT_CADPAT         where codigo_pat=395672 
SELECT  * FROM PT_CADPAT     where balco_pat like '1232106%' 
SELECT  * FROM PT_CADPAT    where chapa_pat='008461' 
SELECT  * FROM PT_CADPAT     where codigo_cpl_pat like '1232106%' 
SELECT  * FROM desdis 
SELECT  * FROM desdis where ficha =639 
SELECT  * FROM desdis where ficha =616 
SELECT  * FROM desdis where ficha =617 
SELECT  * FROM desdis where ficha =618 
SELECT  * FROM desdis where ficha =616 
SELECT  * FROM desdis where ficha =617 
SELECT  * FROM desdis where ficha =619 
SELECT  * FROM condia_tce where ie=4 and datae >= '01.03.2022' 
SELECT  * FROM condia_tce where ie=4 and datae >= '01.03.2022'    and ug=2 
delete FROM condia_tce where ie=4 and datae >= '01.03.2022'    and ug=2 
SELECT  * FROM TABPROJATIV 
SELECT  * FROM TABPROJATIV            where projativ=2109 
SELECT  * FROM TABPROJATIV            where projativ=2110 
SELECT  * FROM TABPROJATIV 
SELECT  * FROM fonro 
SELECT  * FROM descon detalhe 
SELECT  * FROM descon detalhe  where conta ='6' 
SELECT  * FROM descon detalhe  where conta ='20' 
SELECT  * FROM descon_detalhe 
SELECT  * FROM descon_detalhe       where conta='20' 
SELECT  * FROM tabempresa 
SELECT  * FROM descon_detalhe       where conta='20' 
SELECT  * FROM descon_detalhe       where conta='3' 
select * from despes where nempg = '5189' 
select * from despes where nempg = '4992' 
select * from despes where nempg = '3537' 
select * from despes where nempg = '3288' 
SELECT  * FROM descon_detalhe       where conta='91' 
select * from despes where nempg = '5163' 
select * from desdis 
select * from desdis where ficha = '612' 
select * from desdis where ficha = '613' 
select * from desdis where ficha = '666' 
select * from modelo_rtf 
select * from modelo_rtf    where TRANSP_RTF='S' 
update modelo_rtf        set  PAR41='0', PAR42='0', PAR43='0', PAR44='0', PAR45='0', PAR46='0', PAR47='0', PAR48='0', PAR49='0', PAR50='0', PAR51='0',             PAR52='0', PAR53='0', PAR54='0', PAR55='0', PAR56='0', PAR57='0', PAR58='0', PAR59='0', PAR60='0', TRANSP_RTF='N', PUB_PEF_RTF='N',             PUB_PEF_ARQDIGITAL='N'           where TRANSP_RTF='S' 
select * from modelo_rtf    where TRANSP_RTF='S' 
select * from modelo_rtf 
select *from recdis 
select *from recdis  where ficha = '219' 
SELECT  * FROM descon_detalhe       where conta='7' 
SELECT * FROM TABEMPRESA 
SELECT * FROM condia_tce where ie in (0,1) and ndoc='5189' 
SELECT * FROM condia_tce where ie in (0,1) and ndoc='3288' 
SELECT * FROM condia_tce where ie in (0,1) and ndoc='4992' 
SELECT * FROM condia_tce where ie=4 and datae >= '01.02.2022'  and ug=2 
delete FROM condia_tce where ie=4 and datae >= '01.02.2022'  and ug=2 
SELECT * FROM receit 
SELECT * FROM receit      where conta='43' 
SELECT * FROM receit      where conta='43'             and dtrec >='01.04.2022' 
SELECT * FROM ordcre      where conta='43'             and dtlan >='01.04.2022' 
SELECT * FROM ordcai      where conta='43'             and dtlan >='01.04.2022' 
SELECT * FROM receit      where conta='43'             and dtlan between '29.04.2022'     and '30.04.2022' 
SELECT * FROM dessub where pkemp='3170' 
SELECT * FROM descsub where pkemp='3170' 
SELECT * FROM dessub where pkemp='3170' 
SELECT * FROM descsub where pkemp='3170' 
SELECT  * FROM desdis where ficha =683 
SELECT  * FROM despes 
SELECT  * FROM despes WHERE NEMPG = '3017' 
SELECT  * FROM desdis where ficha =683 
select* from cadpro where numlic in (select numlic from cadlic where proclic ='000034/21') AND TPCONTROLE_SALDO ='X' 
UPDATE cadpro SET TPCONTROLE_SALDO='Q' where numlic in (select numlic from cadlic where proclic ='000034/21') AND TPCONTROLE_SALDO ='X' 
update tabempresa set trava= null, travadiario=null, travafinal= null 
SELECT  * FROM despes WHERE NEMPG = '3202' 
SELECT  * FROM ORDPAG        where ordpg=15015 
SELECT  * FROM cheqord        where ordpg=15015 
SELECT  * FROM ORDPAG        where ordpg=15015 
SELECT  * FROM DESFOR 
SELECT  * FROM DESFOR       where insmf='7226' 
SELECT  * FROM DESFOR       where codif='7226' 
SELECT * FROM CADLIC 
SELECT * FROM CADLIC WHERE ANO = '2021' 
SELECT * FROM CADLIC WHERE ANO = '2021' and PROCLIC = '000001/21' 
SELECT * FROM CADLIC WHERE ANO = '2021' and PROCLIC = '000020/21' 
SELECT * FROM CADLIC WHERE ANO = '2021' 
SELECT * FROM CADLIC WHERE ANO = '2021' and PROCLIC = '000020/21' 
SELECT * FROM cheqord 
SELECT * FROM cheqord         where ordpg=15017 
SELECT * FROM ordpag        where ordpg=15017 
SELECT * FROM dessub       where  pkemp=2945 
SELECT * FROM descsub       where  pkemp=2945 
SELECT * FROM dessub_retencao       where  pkemp=2945 
SELECT * FROM dessub       where  pkemp=2945 
SELECT * FROM descsub       where  pkemp=2945 
SELECT * FROM dessub_retencao       where  pkemp=2945 
SELECT * FROM dessub      where  pkemp=2945 
SELECT * FROM dessub_retencao       where  pkemp=2945 
SELECT * FROM dessub      where  pkemp=2945 
SELECT * FROM viewliq      where  pkemp=2945 
SELECT * FROM despes      where  pkemp=2945 
SELECT * FROM dessub      where  pkemp=2945 
SELECT * FROM dessub_retencao       where  pkemp=2945 
SELECT * FROM dessub      where  pkemp=2945 
SELECT * FROM viewliq     where  pkemp=2945 
SELECT * FROM despes where nempg=2300 
SELECT * FROM viewliq where pkemp=3170 
SELECT * FROM dessub  where pkemp=3170 
SELECT * FROM descsub  where pkemp=3170 
SELECT * FROM dessub  where pkemp=3170 
SELECT * FROM descsub  where pkemp=3170 
SELECT * FROM dessub  where pkemp=3170 
SELECT * FROM viewliq  where pkemp=3170 
SELECT * FROM viewliq  where pkemp=4769 
SELECT * FROM dessub  where pkemp=4769 
select * from despes where nempg = '3492' 
select * from cheqord 
select * from cheqord      where ordpg=16019 
select * from cheqord      where ordpg=16020 
select * from cheqord      where ordpg=16019 
select * from ordpag      where ordpg=16019 
select * from ordpag      where ordpg=16020 
select * from dessub      where pkemp=3170 
select * from descsub      where pkemp=3170 
select * from dessub      where pkemp=3170 
select * from dessub      where pkemp=2945 
select * from dessub      where pkemp=3170 
select * from cheqord      where ordpg=16020 
select * from cheqord      where ordpg=16019 
select * from ordpag      where ordpg=16019 
select * from ordpag      where ordpg=16020 
select * from dessub      where pkemp=2945 
select * from dessub      where pkemp=3170 
select * from viewliq      where pkemp=3170 
select * from dessub where pkemp= 3170 
select * from viewliq where pkemp= 3170 
select * from despes where pkemp= 3170 
select * from despes where nempg=2300 
select * from ordcai 
select * from ordcai         where conta='107' and dtlan='16.05.2022' 
select * from ordcai         where conta='107' and dtlan='25.05.2022' 
select * from ordcre where conta=  '107'      and dtlan='16.05.2022' 
select * from ordcre where conta=  '8'      and dtlan='16.05.2022' 
select * from receit where conta=  '107'      and dtlan='16.05.2022' 
select * from ordcai where conta=  '8'      and dtlan='25.05.2022' 
select * from ordcai where conta=  '107'      and dtlan='20.06.2022' 
select * from cheqord where ordpg=6945 
select * from cheqord where ordpg=6957 
select * from ordpag where ordpg=6957 
select * from ordpag where ordpg=6945 
select * from ordcai where conta=  '107'      and dtlan='20.06.2022' 
select * from ordcre where conta=  '107'      and dtlan='20.06.2022' 
select * from receit where conta=  '107'      and dtlan='20.06.2022' 
select * from cheqord where conta=  '107'      and dtlan='20.06.2022' 
select * from receit where conta=  '107'      and dtlan='20.06.2022' 
select * from ordcre where conta=  '107'      and dtlan='20.06.2022' 
select * from cheqord where ordpg=16057 
select * from ordpag where ordpg=16057 
select * from ordcre where conta=  '107' 
select * from ordcre where conta=  '107'    and dtlan='07.07.2022' 
select * from receit where conta=  '107'    and dtlan='07.07.2022' 
select * from ordcai where conta=  '107'    and dtlan='07.07.2022' 
select * from ordcai where conta=  '107'    and dtlan='20.06.2022' 
select * from ordcai where conta=  '107' 
select * from ordcre where conta=  '107' 
select * from receit where conta=  '107' 
select * from ordpag 
select * from ordpag       where datae='07.07.2022' 
select * from ordpag       where datae='20.06.2022' 
select * from ordcai       where dtlan='20.06.2022' 
select * from ordcai       where nome='MC TERRAPLANAGEM,TRANSPORTES E SERVICOS LTDA' 
select * from despes where nempg=2300 
select * from viewliq where pkemp=3170 
select * from descsub where pkemp=3170 
select * from dessub where pkemp=3170 
select * from despes where nempg=2300 
select * from viewliq where pkemp=3170 
select * from descsub where pkemp=3170 
select * from dessub where pkemp=3170 
select * from ordcre where conta='107' 
select * from receit where conta='107' 
select * from ordcre where conta='107' 
select * from desorc 
updat desorc set dotac ='1' 
update desorc set dotac ='1' 
select empresa, nome, trava, travadiario from tabempresa 
SELECT * FROM TABPROJATIV 
SELECT * FROM  TCEMT_LEI 
SELECT * FROM  despes where nempg=3909 
SELECT * FROM  despes where nempg=3910 
SELECT * FROM  RECORC 
update RECORC set TOTOR ='1' 
SELECT * FROM DESDIS 
SELECT * FROM DESDIS WHERE FICHA = '157' 
SELECT FONRO FROM DESDIS WHERE FICHA = '157' 
SELECT * FROM DESDIS WHERE FICHA = '157' 
update tabempresa set trava= null, travadiario=null, travafinal= null 
SELECT  * FROM TABEMPRESA 
SELECT * FROM TCEMT_LEI 
select empresa, nome, trava, travadiario from tabempresa 
SELECT * FROM TCEMT_LEI 
SELECT * FROM TCEMT_LEI 
SELECT  * FROM TABEMPRESA 
SELECT  * FROM condia_tce where debit='586.90' or     credi='586.90' 
SELECT  * FROM condia_tce where debit='586.90' or     credi='586.90'      and balco like '89%' 
SELECT  * FROM condia_tce where debit='586.90'     and balco like '89%' 
SELECT  * FROM condia_tce where debit='586.90'  or     credi='586.90' 
SELECT  * FROM condia_tce where debit='586.90'  or     credi='586.90'       and datae='20.06.2022' 
SELECT  * FROM dessub where pkemp='2945' 
SELECT  * FROM viewliq where pkemp='2945' 
SELECT  * FROM dessub where pkemp='2945' 
SELECT  * FROM descsub where pkemp='2945' 
SELECT  * FROM dessub where pkemp='4583' 
SELECT max(codigo) FROM tcemt_lei 
SELECT max(PK_TCEMT_LEI) FROM tcemt_lei 
SELECT max(codigo) FROM tcemt_lei 
SELECT max(PK_TCEMT_LEI) FROM tcemt_lei 
SET GENERATOR GEN_TCEMT_LEI TO 155 
SELECT  * FROM desdis where ficha =728 
SELECT  * FROM desdis where ficha =729 
SELECT * FROM CONDIA_TCE            where balco='1135108020100' 
SELECT * FROM CONDIA_TCE            where balco='11351080201' 
SELECT * FROM pt_cadpat 
SELECT * FROM pt_cadpat          where codigo_pat=292059 
SELECT * FROM pt_cadpat          where codigo_pat='292059' 
SELECT * FROM pt_cadpat          where codigo_pat='397220' 
SELECT * FROM pt_movbem         where codigo_pat_mov='397220' 
select * from desdis 
select * from desdis   where ficha=711 
SELECT  * FROM PT_CADPAT 
SELECT  * FROM PT_CADPAT      where datae_pat >= '01.07.2022' 
update PT_CADPAT  set dt_contabil=datae_pat     where datae_pat >= '01.07.2022' 
update PT_movbem  set dt_contabil=data_mov     where data_mov >= '01.07.2022' 
SELECT  * FROM despes 
SELECT  * FROM desdis 
SELECT  * FROM condia_tce where seq_sagres='7030651' 
SELECT  * FROM condia_tce where seq_sagres='7030652' 
SELECT  * FROM condia_tce where seq_sagres='7030651' 
SELECT  * FROM desdis where ficha =749 
SELECT  * FROM desdis where ficha =750 
SELECT  * FROM desdis where ficha =749 
SELECT  * FROM desdis where ficha =750 
SELECT * FROM despes where nempg=5015 
SELECT * FROM despes where nempg=4919 
SELECT * FROM tabempresa 
update desdis set desdis.balco_tce = (select first 1 z.balco_tce from extra z where z.extra = desdis.ficha_extra and z.empresa = desdis.empresa) where desdis.extra = 'S'; 
update recdis set recdis.balco_tce = (select first 1 z.balco_tce from extra z where z.extra = recdis.ficha_extra and z.empresa = recdis.empresa) where recdis.extra = 'S'; 
SELECT * FROM receit 
SELECT * FROM receit          where nlanc in (15354, 15353, 15340, 15348, 15347, 15344, 15343, 15339) 
SELECT * FROM ordcre          where ordcre in (11548, 11549, 11552, 11553, 11556, 11557, 11562, 11563) 
SELECT * FROM ordcre          where conta='7' and  dtlan='31.10.2022' 
SELECT * FROM receit       where conta='7' and  dtlan='31.10.2022' 
SELECT * FROM ordcre          where conta='7' and  dtlan='31.10.2022' 
SELECT * FROM receit       where conta='7' and  dtlan='31.10.2022' 
SELECT * FROM ordcre          where conta='7' and  dtlan='31.10.2022' 
SELECT * FROM receit       where conta='7' and  dtlan='31.10.2022' 
SELECT * FROM PT_CADPAT       where codigo_pat=295128 
SELECT * FROM PT_movbem      where codigo_pat_mov=295128 
SELECT * FROM PT_movbem      where codigo_pat_mov=397220 
SELECT * FROM TABPROGRAMA 
select * from despes where nempg='5610' 
update despes set vincodigo='003' where nempg='5610' 
SELECT  * FROM EXTRA 
SELECT  * FROM recdis where ficha=132 
SELECT  * FROM recorc where ficha=132 
SELECT  * FROM ordcai 
SELECT  * FROM ordcai           where conta='3' and dtlan='02.12.2022' 
SELECT  * FROM ordcre 
SELECT  * FROM ordcre       where conta='3' and dtlan='02.12.2022' 
SELECT  * FROM receit 
SELECT  * FROM receit              where conta='3' and dtlan='02.12.2022' 
SELECT  * FROM receit 
SELECT  * FROM receit              where conta='3' and dtlan='02.12.2022' 
SELECT  * FROM TABPROJATIV 
SELECT  * FROM DESCON_DETALHE 
SELECT  * FROM DESCON_DETALHE      where conta='73' 
select * from cadlic 
select * from cadlic where proclic='000052/21' 
SELECT * FROM ORDCRE 
SELECT * FROM ORDCRE WHERE DB = 3 
SELECT * FROM ORDCRE 
SELECT * FROM desdis 
SELECT * FROM desorc 
SELECT * FROM recorc 
SELECT * FROM recdis 
SELECT  * FROM despes    WHERE PKEMP='125' 
SELECT * FROM CADLIC 
SELECT * FROM CADLIC  WHERE PROCLIC ='000007/22' 
SELECT * FROM CADLIC WHERE NUMLIC='499' 
SELECT * FROM REGPRECO WHERE NUMLIC='499' 
SELECT * FROM REGPRECO WHERE NUMLIC='499'AND CODIF='3799' 
SELECT * FROM REGPRECO WHERE NUMLIC='499'AND CODIF='3799' AND CADPRO ='089.020.111' 
SELECT * FROM REGPRECOHIS WHERE NUMLIC='499'AND CODIF='3799' AND CADPRO ='089.020.111' 
SELECT * FROM CADPRO WHERE NUMLIC='499'AND CODIF='3799' AND CADPRO ='089.020.111' 
SELECT * FROM REGPRECO WHERE NUMLIC='499'AND CODIF='3799' AND CADPRO ='089.020.111' 
SELECT * FROM CADPRO WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') 
SELECT * FROM CADPRO WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM CADPROLIC_DETALHE_FIC WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM REGPRECO WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM CADPRO WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM REGPRECOHIS WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM REGPRECOHIS WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 AND CODIF = 5198 
SELECT * FROM CADPRO WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 AND CODIF = 5198 
SELECT * FROM REGPRECO WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 AND CODIF = 5198 
SELECT * FROM REGPRECOHIS WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 AND CODIF = 5198 
SELECT * FROM REGPRECO WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 AND CODIF = 5198 
SELECT * FROM CADPROLIC_DETALHE_FIC WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM CADPROLIC_DETALHE WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM CADPRO_FINAL WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') 
SELECT * FROM CADPRO WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM CADPRO_SALDO_ANT WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM REGPRECO_SALDO_ANT WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM CADPRO WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM REGPRECO WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM CADPRO WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
DELETE FROM CADPROLIC_DETALHE_FIC WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') 
SELECT * FROM CADPRO WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 
SELECT * FROM REGPRECOHIS WHERE NUMLIC IN(SELECT NUMLIC FROM CADLIC WHERE PROCLIC = '000007/22') AND ITEM = 15 AND CODIF = 5198 
SELECT * FROM CONDIA_TCE    where datae >= '01.12.2022' 
SELECT * FROM CONDIA_TCE    where datae >= '01.12.2022'    and balco like '1125%' 
SELECT * FROM CONDIA_TCE    where datae >= '01.12.2022'    and balco like '12111%' 
SELECT * FROM CONDIA_TCE    where datae >= '01.12.2022'    and balco like '832%' 
SELECT * FROM CONDIA_TCE    where datae >= '01.12.2022'    and balco like '732%' 
SELECT * FROM CONDIA_TCE    where datae >= '01.12.2022'    and codre='19999923000000' 
SELECT * FROM CONDIA_TCE    where datae >= '01.12.2022'    and balco like '2188%' 
SELECT * FROM CONDIA_TCE    where datae >= '01.12.2022'    and balco like '31111012200%' 
SELECT * FROM CONDIA_TCE    where datae >= '01.12.2022'    and balco like '31111012200%'       and ie=34 
select * from desdis 
select * from despes where nempg='495' 
select * from despes where nempg='969' 
select * from despes where nempg='731' 
select * from extra 
select * from recdis 
select * from recdis where ficha > 9000 
update recdis set fonro = '0' where ficha > 9000
select * from despes where ficha in ('615','616','617','618','619','620','596') 
select * from desdis where ficha in ('615','616','617','618','619','620','596') 
select * from extra 
select * from desdis where ficha in ('615','616','617','618','619','620','596') 
select * from desdis where ficha=608 
select * from desdis where ficha=618 
select * from desdis where ficha=872 
select * from despes where nempg=872 
select * from despes where nempg=1213 
select * from extra 
select * from recdis 
select * from recdis      where ficha >= '9000' 
select * from receit where fonro='802' 
select * from receit 
select * from condia_tce where ug=2 and ie=4 
delete from condia_tce where ug=2 and ie=4 
SELECT  * FROM TABEMPRESA 
select * from dessub where pkemp=1897 
select * from despes where pkemp = '1897' 
select * from despes where pkemp = '2029' 
select * from pt_cadpat    where codigo_pat=310136 
select * from pt_cadpat 
select * from pt_cadpat             where codigo_pat=310136 
select * from pt_cadpat             where codigo_pat=397220 
SELECT  * FROM PT_MOVBEM       where codigo_mov=310136 
select * from caddecreto 
select * from pt_cadpat 
select * from pt_cadpat    where codigo_pat=397337 
update pt_cadpat set datae_pat = dt_contabil   where dt_contabil > '01/03/2023' 
SELECT  * FROM PT_MOVBEM       where codigo_mov=310136 
update PT_MOVBEM set data_mov =  dt_contabil   where dt_contabil > '01/03/2023' 
update PT_MOVBEM set dtdocum_mov =  dt_contabil   where dt_contabil > '01/03/2023' 
select * from despes where nempg='2410' 
update despes set vingrupo='110', vincodigo='000' where nempg='2410' 
select * from despes where nempg='2410' 
select * from DESFOR WHERE CODIF=4672 
select * from CONDIA_TCE WHERE IE=4 AND UG=2 AND DATAE >= '01.06.2023' 
DELETE from CONDIA_TCE WHERE IE=4 AND UG=2 AND DATAE >= '01.06.2023' 
update PT_CADPAT    set     dt_contabil=datae_pat where datae_pat >= '06.06.2023' 
update PT_CADPAT    set     dt_contabil=datae_pat where datae_pat >= '01.06.2023' 
update PT_movbem   set     dt_contabil=data_mov where data_mov >= '01.06.2023' 
SELECT * FROM DESFOR         where codif=8369 
SELECT * FROM Pt_movbem 
SELECT * FROM Pt_movbem where dt_contabil > data_mov 
SELECT * FROM Pt_movbem where dt_contabil < data_mov 
SELECT * FROM despes 
SELECT * FROM desdis 
SELECT * FROM desdis    where ficha = '705' 
SELECT * FROM desdis    where ficha = '701' 
SELECT * FROM despes    where ficha = '701' 
SELECT * FROM desdis 
SELECT * FROM desdis       where ficha = '681' 
SELECT  * FROM DESCON_DETALHE where conta='6' 
SELECT FIRST 1 * FROM TABEMPRESA 
SELECT  * FROM DESCON_DETALHE where conta='6' 
select * from despes where nempg = '4840'  
SELECT  * FROM ORDPAG        where ordpg=6
SELECT  * FROM ORDPAG        where ordpg=7426
SELECT  * FROM ORDPAG        where codif=2020 
select * from descon
select * from descon where conta='6998-1'
select * from descon where conta='6.998-1'
select * from descon 
select * from descon where dtlan='01.12.2023'
select * from descon where dtlan= '01.12.2023'
select * from ordcai 
select * from ordcai where dtconcilia='01.12.2023' 
select * from despes
select * from desdis
select * from desdis where ficha = '737'
select * from despes where nempg = '4987' 
SELECT * FROM despes where nempg=4987 
select * from despes where nempg = '4987' 
select * from despes where nempg = '148' 
update tabempresa set trava= null, travadiario=null, travafinal= null 
SELECT FIRST 1 * FROM EXTRA
update EXTRA set saldo_inicial=0
SELECT FIRST 1 * FROM TABEMPRESA
SELECT * FROM TABEMPRESA
select * from despes where nempg = '261' 
update  extra set fonro=0
SELECT * FROM TABEMPRESA
SELECT * FROM  despes where nempg=24 
SELECT * FROM  despes where pkemp=151
SELECT * FROM  viewliq where pkemp=151
SELECT * FROM  dessub where pkemp=151
delete FROM condia_tce where ie in (33,34)
delete FROM condia_tce where ie in (4) and ug=2 and datae >= '01.12.2023'
delete FROM condia_tce where ie in (33,34)
delete FROM condia_tce where ie in (4) and ug=2 and datae >= '01.12.2023'
SELECT FIRST 1 * FROM CONDIA_TCE where datae='01.12.2023'
SELECT FIRST 1 * FROM CONDIA_TCE where datae='01.12.2023' and discri like '%114%'
SELECT * FROM CONDIA_TCE where datae='01.12.2023' and discri like '%114%'
SELECT * FROM CONDIA_TCE where datae='01.12.2023' and discri like '%Suplementação - Decreto No. 114 de 01/12/2023%'
SELECT * FROM CONDIA_TCE where datae='01.12.2023' and discri like '%Suplementação - Decreto No. 114 de 01/12/2023%' and balco like '5%'
SELECT FIRST 1 * FROM DESDIS where ficha=685
SELECT FIRST 1 * FROM DESCON
SELECT  * FROM DESCON where conta='1'
SELECT FIRST 1 * FROM desdis 
SELECT * FROM desdis 
SELECT * FROM extra 
SELECT * FROM extra where empresa = 1 
delete FROM condia_tce where ie in (33,34) and ug=2
SELECT * FROM extra 
SELECT * FROM extra where empresa=1 
SELECT * FROM desdis where ficha=9236
SELECT * FROM desdis where ficha=9235
SELECT * FROM extra 
SELECT * FROM extra where empresa=1
SELECT * FROM desdis where ficha=9235
SELECT * FROM recdis where ficha=9235
SELECT * FROM recdis where ficha=9236
SELECT * FROM desdis where ficha=9238
SELECT * FROM desdis where ficha=9237
SELECT * FROM desdis where ficha=9239
SELECT * FROM desdis where ficha=9241
SELECT * FROM desdis where ficha=9243
SELECT * FROM desdis where ficha=9245
SELECT * FROM pt_cadpat where datae_pat >= '01.12.2023'
update pt_cadpat set dt_contabil=datae_pat where datae_pat >= '01.12.2023'
update condia_tce set balco=72111000000 where balco=72112000000 and foncodigo=502
delete FROM DESCON where data_encerra is not null
UPDATE condia_tce SET seq_sagres = 0 WHERE ie < 4 AND seq_sagres IS NULL;
SELECT  * FROM desdis 
SELECT  * FROM desdis where ficha =557  
SELECT  * FROM desdis where ficha =535  
select * from descon
select * from descon where data_encerra is not null
SELECT FIRST 1 * FROM TABEMPRESA
SELECT  * FROM TABEMPRESA
SELECT  * FROM condia_tce where ndoc='368'
update condia_tce set fonro='0' where ndoc='368'
SELECT FIRST 1 * FROM TABPROJATIV
SELECT FIRST 1 * FROM TABPROJATIV where projativ=2050
SELECT FIRST 1 * FROM TABPROJATIV where projativ=2131
SELECT * FROM condia_tce where ug=3
SELECT  * FROM TABEMPRESA
update condia_tce set fongrupo=1 where ug=3 and fongrupo is null 
update condia_tce set foncodigo=800 where ug=3 and foncodigo is null 
SELECT * FROM condia_tce where ug=3
SELECT FIRST 1 * FROM TABEMPRESA
SELECT * FROM TABEMPRESA
update condia_tce set foninduso=1 where ug=3 and foninduso is null 
select * from condia_msc
update condia_tce set foninduso=1 where ug=3 and foninduso is null 
select * from condia_msc
select * from condia_msc where balco in (521110000,621100000,621200000)
select * from condia_msc where balco in (521110000,621100000,621200000) order by nr
update condia_msc set nr ='11125001' where balco in (521110000,621100000,621200000) and nr = null
select * from condia_msc where balco in (521110000,621100000,621200000) order by nr
select * from condia_msc where balco in (521110000,621100000,621200000) 
select * from condia_msc where balco in (521110000,621100000,621200000) order by nr
select trava,travadiario,empresa,nome from tabempresa
select * from condia_msc where balco in (521110000,621100000,621200000) 
select * from condia_msc where balco in (521110000,621100000,621200000) order by nr
select * from condia_msc where balco in (521110000,621100000,621200000) 
select * from condia_msc where balco in (521110000,621100000,621200000) order by nr
select * from condia_msc where balco in (521110000) order by nr
select * from condia_msc where balco in (521110000,621100000,621200000) order by nr
select * from condia_msc where balco in (621100000,621200000) order by nr
SELECT FIRST 1 * FROM TABPROJATIV
SELECT FIRST 1 * FROM TABPROJATIV where projativ=1138
select * from despes
select * from desdis
select * from desdis where ficha = '559'
update tabempresa set trava= null, travadiario=null, travafinal= null 
select * from desdis where ficha = '559'
select * from viewliq where pkemp=(select pkemp from despes where nempg='2315')
select first 1 * from ordpag 
select first 1 * from ordpag where ordpgseq=2774
select * from ordpag where ordpgseq=2774
SELECT * FROM RECEIT WHERE FICHA=7002
SELECT TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM RECEIT WHERE FICHA=7002
SELECT * FROM RECEIT 
SELECT * FROM RECEIT WHERE FICHA=7002 
SELECT * FROM RECEIT WHERE FICHA=7002 AND DTREC > '01.06.2024' 
DELETE FROM RECEIT WHERE FICHA=7002 AND DTREC > '01.06.2024' 
SELECT EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM DESFOR WHERE CODIF=4657
SELECT * FROM CONDIA_TCE WHERE NDOC='2581' AND DATAE >= '01.06.2024'
SELECT FIRST 1 * FROM DESPES
SELECT * FROM tabprojativ
SELECT * FROM tabprojativ where projativ=1200
SELECT * FROM desfor where codif=4816
delete FROM condia_tce where ie=4 and ug=1 and datae >= '01.09.2024'
delete FROM condia_tce where ie=4 and ug=2 and datae >= '01.09.2024'
select * from despes where pkemp=5558
select * from VIEWLIQ_ITEM where pkemp=5558
SELECT * FROM VIEWLIQ WHERE PKEMP=5558
SELECT * from VIEWLIQ_ITEM where pkemp=5558
SELECT * from VIEWLIQ_ITEM where pkemp=5558 AND NUMLIQ=10
DELETE from VIEWLIQ_ITEM where pkemp=5558 AND NUMLIQ=10
SELECT * from tabempresa
select * from despes where pkemp ='5559'
select * from viewliq_item 
select * from viewliq_item where pkemp = 5559
select pk_viewLiQ from viewliq where pkemp = 5559
select * from viewliq where pkemp = 5559
select * from viewliq_item where pkemp = 5559
seleCt * from viewliq where pkemp = 5559
select * from viewliq_item where pkemp = 5559
seleCt * from viewliq_item where pkemp = 5559 and  numliq = 10
dElete from viewliq_item where pkemp = 5559 and  numliq = 10
seLecT *  from viewliq_item where pkemp = 5559 and  numliq = 10
seLecT *  from viewliq_item where pkemp = 5643 
select * from viewliq_item where pkemp = 5643
seLecT *  from viewliq_item where pkemp = 5643
select * from viewliq_item where pkemp = 5643
select * from viewliq where pkemp = 5643
seLecT *  from viewliq_item where pkemp = 5643 and  numliq = 8
delete from viewliq_item where pkemp = 5643 and  numliq = 8
select * from viewliq_item where pkemp = 5643 and  numliq = 8
select * from viewliq_item where pkemp = 5644 and  numliq = 8
select * from viewliq where pkemp = 5644
seleCt * From viewliq_item where fk_viewlIq is null
select * from viewliq where pkEmp iN (seleCt pkemp From viewliq_item where fk_viewlIq is null)
select * from viewliq where pkEmp iN (seleCt pkemp From viewliq_item where fk_viewlIq is null) OrDeR by numsub
seleCt * From viewliq_item where fk_viewlIq is null
select * from viewliq where pkEmp iN (seleCt pkemp From viewliq_item where fk_viewlIq is null) OrDeR by numsub
dElete From viewliq_item where fk_viewlIq is null
select * from ordpag
select * from ordpag where empresa=3
select * from ordcai
select * from ordcai where db=3
select * from ordcai where db <>'2'
select * from extra
select * from tabempresa
SELECT * FROM CADDECRETO 
SELECT * FROM CADDECRETO WHERE DECRETO = 114
ALTER TRIGGER TD_DESALD INACTIVE; COMMIT WORK;
ALTER TRIGGER TD_CADDECRETO INACTIVE; COMMIT WORK;
SELECT * FROM CADDECRETO WHERE DECRETO = 114
ALTER TRIGGER TD_DESALD INACTIVE; COMMIT WORK;
ALTER TRIGGER TD_CADDECRETO INACTIVE; COMMIT WORK;
SELECT TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT NOME, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM pt_movbem         where codigo_pat_mov='397220' 
SELECT * FROM pt_movbem   where DATA_MOV > DT_CONTABIL
SELECT * FROM pt_movbem   where DATA_MOV <DT_CONTABIL
SELECT * FROM pt_movbem   where DATA_MOV <DT_CONTABIL AND DT_CONTABIL > '01/01/2024' 
select empresa, nome, trava, travadiario from tabempresa
SELECT * FROM receit where dtlan='02.12.2024'
SELECT * FROM receit where dtlan='02.12.2024' and ficha=157
SELECT * FROM ordcre where dtlan='02.12.2024' 
SELECT * FROM receit where dtlan='02.12.2024' and ficha=157
update receit set varec='0' where dtlan='02.12.2024' and ficha=157
SELECT * FROM receit where dtlan='02.12.2024' and ficha=157
SELECT * FROM ordcre where dtlan='02.12.2024' 
SELECT * FROM ordcre where dtlan='02.12.2024' and nome='Transf. FUNDEB 70%'
update ordcre  set valor='0' where dtlan='02.12.2024' and nome='Transf. FUNDEB 70%'
SELECT * FROM ordcai where dtlan='02.12.2024' 
SELECT * FROM ordcai where dtlan='02.12.2024'  and nome='Transf. FUNDEB 70%'
SELECT * FROM recdis
SELECT * FROM recorc
SELECT * FROM recdis
SELECT * FROM receit 
SELECT * FROM receit where ficha = '157'
SELECT * FROM ordcre
SELECT * FROM ordcre where conta = '163'
SELECT * FROM ordcre 
update extra set fonro=0
SELECT * FROM despes where nempg=883
UPDATE PARAMPATRI SET EXER_ENC = NULL
SELECT * FROM condia_tce where debit='39943.82' and credi='39943.82'
SELECT * FROM condia_tce where debit='39943.82' or credi='39943.82'
delete  FROM condia_tce where ie=34 and ug=2
delete  FROM condia_tce where ie=33 and ug=2
delete  FROM condia_tce where ie=4 and ug=2 and datae >= '01.12.2024'
select * from despes where nempg=20
select * from desald
select * from desald where decreto=123
select * from desald 
select * from desald where decreto=101
delete from condia_tce where ie=13 and datae >= '01.12.2024' and ug=2
select * from CONDIA_TCE WHERE DEBIT='2204.94' OR CREDI='2204.94'
DELETE from CONDIA_TCE WHERE DEBIT='2204.94' OR CREDI='2204.94' AND IE=32
DELETE from CONDIA_TCE WHERE DEBIT='2204.94' OR CREDI='2204.94' AND IE=10
select * from CONDIA_TCE WHERE IE=32
DELETE from CONDIA_TCE WHERE IE=32
select * from descon_detalhe where conta='6'
select * from tabempresa
select * from condia_tce where ndoc='4883' and datae >= '01.12.2024'
select * from condia_tce where ndoc='4883' and datae >= '01.12.2024' and fonro='804'
update condia_tce set fonro='0' where ndoc='4883' and datae >= '01.12.2024' and fonro='804'
update condia_tce set fonro='0' where ndoc='4884' and datae >= '01.12.2024' and fonro='804'
update condia_tce set fonro='0' where ndoc='5368' and datae >= '01.12.2024' and fonro='804'
delete from condia_tce where ie=13 and datae >= '01.12.2024' and ug=2
update condia_tce set fonro='804' where ndoc='5368' and datae >= '01.12.2024' and fonro='0'
update condia_tce set fonro='804' where ndoc='4884' and datae >= '01.12.2024' and fonro='0'
update condia_tce set fonro='804' where ndoc='4883' and datae >= '01.12.2024' and fonro='0'
delete from condia_tce where ie=13 and datae >= '01.12.2024' and ug=2
select * from tabempresa
select * from condia_Tce where ie=32
SELECT * FROM DESDIS WHERE FICHA=567
SELECT FONRO FROM DESDIS WHERE FICHA=567
SELECT FONRO FROM DESDIS WHERE FICHA <>0
SELECT FONRO FROM DESDIS WHERE FICHA <>'0'
UPDATE DESDIS SET FONRO='1002000' WHERE FICHA=567
UPDATE receit set contad=1034 where contad=1053
UPDATE ordcre set contad=1034 where contad=1053
UPDATE cheqord set contad=1034 where contad=1053
UPDATE extra set fonro=0
SELECT * FROM CADPRO WHERE NUMLIC IN (SELECT NUMLIC FROM CADLIC WHERE PROCLIC='000089/23')
UPDATE CADPRO SET TPCONTROLE_SALDO='Q' WHERE NUMLIC IN (SELECT NUMLIC FROM CADLIC WHERE PROCLIC='000089/23')
UPDATE extra set fonro=0
UPDATE receit set contad=27 where contad=1054
UPDATE ordcre set contad=27 where contad=1054
UPDATE ordcai set contad=27 where contad=1054
UPDATE ordcai set contad=54 where contad=1059
UPDATE ordcre set contad=54 where contad=1059
UPDATE receit set contad=54 where contad=1059
UPDATE cheqord set contad=54 where contad=1059
UPDATE cheqord set contad=264 where contad=1055
UPDATE ordcre set contad=264 where contad=1055
UPDATE receit set contad=264 where contad=1055
UPDATE cheqord set contad=264 where contad=1055
UPDATE ordcai set contad=264 where contad=1055
delete from condia_tce where ie=1 and ug=2
select * from descon_detalhe where conta='83'
select * from descon_detalhe where conta='17'
select * from descon_detalhe where conta='18507-8'
select * from descon_detalhe where conta='2'
select * from descon_detalhe where foncodigo=700
update tabempresa set trava= null, travadiario=null, travafinal= null 
select * from receit where contad=1055
update receit set contad=276 where contad=1055
update ordcre set contad=276 where contad=1055
update ordcai set contad=276 where contad=1055
update cheqord set contad=276 where contad=1055
update cheqord set contad=276 where contad=1094
update ordcai set contad=276 where contad=1094
update ordcre set contad=276 where contad=1094
update receit set contad=276 where contad=1094
update extra set fonro=0
select * from receit where fonro is null
select * from receit where fonro is null and contad=1094
update receit set fonro=0 where fonro is null and contad=1094
select * from receit where contad=1094
update receit set contad=276 where contad=1094
update ordcre set contad=276 where contad=1094
select * from recdis where fonro is null
update recdis set fonro=0 where fonro is null
update desdis set fonro=0 where fonro is null
SELECT TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
select * from receit where conta=185 and dtlan='27.03.2025'
select * from ordcre where conta=185 and dtlan='27.03.2025'
select * from ordcre where conta=185 and dtlan='27.03.2025' and nome like '%1002%'
select * from ordcre where conta=185 and dtlan='27.03.2025' 
select * from ordcre where conta=185 and dtlan='27.03.2025'  and nome like '%990%'
select * from receit  where conta=185 and dtlan='27.03.2025'  
select * from receit  where conta=185 and dtlan='27.03.2025'   and histo like '%990%'
select * from receit  where conta=185 and dtlan='27.03.2025'  and contad=1047
select * from ordcre  where conta=185 and dtlan='27.03.2025'  and contad=1047
select * from receit  where conta=185 and dtlan='27.03.2025'  and contad=1047
select * from desdis
select * from desdis where ficha= '563'
update tabempresa set trava= null, travadiario=null, travafinal= null 
elect * from desdis where ficha= '563'
select * from desdis where ficha= '563'
select * from despes
select * from despes where nempg = '1223'
select * from tabempresa
update cadconv set numconv='2048' where numconv='2048-2024'
select * from despes where nempg = '2850'
select first 1 * from dessub 
select  * from dessub  where venci like '%2026'
select  * from viewliq  where venci like '%2026'
select  first 1 * from viewliq  
select  first 1 * from viewliq  where folha_id_liq=870
select  * from viewliq  where folha_id_liq=870
update viewliq set venci='23.07.2025'  where folha_id_liq=870
select  * from viewliq  where folha_id_liq=870
select  * from dessub  
select first 1 * from dessub  
select  * from dessub  where  venci='22.07.2026'
update dessub  set venci='23.07.2025' where  venci='22.07.2026'
select * from despes 
select * from despes where nempg=2954
SELECT * FROM ORDCRE
SELECT * FROM ORDCRE 
SELECT * FROM DESPES WHERE ORDCRE=840 
SELECT * FROM DESPES WHERE ORDCRE=8480 
SELECT * FROM  ORDCRE
SELECT * FROM  RECEIT
SELECT * FROM  RECEIT WHERE ORDCRE=8480
SELECT * FROM  RECEIT 
SELECT * FROM  RECEIT WHERE CONTA='43' AND DTLAN='29.07.2025'
SELECT * FROM  ORDCRE WHERE CONTA='43' AND DTLAN='29.07.2025'
DELET FROM  ORDCRE WHERE CONTA='43' AND DTLAN='29.07.2025'
DELETE FROM  ORDCRE WHERE CONTA='43' AND DTLAN='29.07.2025'
SELECT * FROM pt_cadpat where chapa_pat='9484'
SELECT * FROM pt_movbem where codigo_mov=352161
SELECT * FROM tabempresa
SELECT * FROM pt_movbem where codigo_mov=352161
SELECT * FROM desdis where ficha=670
SELECT * FROM desorc where ficha=670
SELECT * FROM tabempresa
SELECT * FROM condia_tce where ie=13 and ug=2 and datae >= '01.07.2025'
delete FROM condia_tce where ie=13 and ug=2 and datae >= '01.07.2025'
delete FROM condia_tce where ie=13 and ug=2 and datae >= '01.08.2025'
update tabempresa set trava= null, travadiario=null, travafinal= null 
SELECT TRAVA, TRAVADIARIO, TRAVAFINAL, NOME FROM TABEMPRESA
SELECT * FROM DESDIS 
SELECT * FROM VIEWLIQ
SELECT * FROM VIEWLIQ
SELECT * FROM NOTA
SELECT * FROM NOTA WHERE NATREND = 17599
SELECT * FROM NOTA WHERE NATREND = 17099
SELECT * FROM DESPES WHERE PKEMP=1228
SELECT * FROM NOTA WHERE NATREND = 17099
SELECT * FROM DESCSUB WHERE NATREND = 17599
SELECT NEMPG FROM DESPES WHERE PKEMP IN (SELECT PKEMP FROM DESCSUB WHERE NATREND = 17599)
SELECT * FROM DESCSUB WHERE NATREND = 17599
SELECT NEMPG FROM DESPES WHERE PKEMP IN (SELECT PKEMP FROM DESCSUB WHERE NATREND = 17599)
SELECT * FROM NOTA WHERE NATREND = 17599 
SELECT * FROM descsub WHERE NATREND = 17599 
SELECT NEMPG FROM DESPES WHERE PKEMP IN (SELECT PKEMP FROM DESCSUB WHERE NATREND = 17599)
SELECT PKEMP FROM DESCSUB WHERE NATREND = 17599
SELECT NEMPG FROM DESPES WHERE PKEMP IN (SELECT PKEMP FROM DESCSUB WHERE NATREND = 17599)
SELECT * FROM descsub WHERE NATREND = 17599 
SELECT PKEMP FROM DESCSUB WHERE NATREND = 17599
SELECT NEMPG FROM DESPES WHERE PKEMP IN (SELECT PKEMP FROM DESCSUB WHERE NATREND = 17599)
SELECT * FROM tabempresa
SELECT * FROM condia_tce where balco like '1231104%'
SELECT * FROM condia_tce where balco like '1231105%'
SELECT * FROM condia_tce where balco like '1238101%'
SELECT * FROM tabempresa
select empresa, nome, trava, travadiario from tabempresa 
select * from viewliq where pkemp =6065
select * from dessub where pkemp =6065
select * from viewliq where pkemp =6065
select * from dessub where pkemp =6065
select * from viewliq where pkemp =6065
select * from tabempresa
select * from dessub where pkemp =6065
select * from tabempresa
select * from dessub where pkemp =6065
select * from tabempresa
select * from dessub where pkemp =6065
select * from viewliq where pkemp =6065
select * from receit
select * from receit where dtlan='30.12.2025'
select * from receit where dtlan='30.12.2025' and ficha=92
select * from receit where nlanc=22778
select * from ordcre
select * from ordcre where ordcre=15989
select * from receit
select * from receit where nlanc = 9305
update tabempresa set trava= null, travadiario=null, travafinal= null
SELECT NOME, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
update tabempresa set trava= null, travadiario=null, travafinal= null
SELECT NOME, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
select * from receit where nlanc=9305
select * from receit where nlanc in (9305, 9306)
select * from ordcre 
select * from ordcre where valor= '6186.00'
select * from receit where varec='6186'
 select * from ordcre
select * from ordcre where ordcre in (7798, 6588)
select * from receit where varec='6186'
select * from receit where varec='-6186'
select empresa, nome, trava, travadiario from tabempresa