SELECT * FROM NOTA
SELECT * FROM NOTA WHERE PKEMP = 2097
select * from desorc
select * from desdis
select * from desdis where ficha = 715 
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
select * from desORC where ficha = 715 
select * from desDIS where ficha = 715 
select * from desORC where ficha = 715 
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM DESSUB WHERE PKEMP = 2981
SELECT * FROM VIEWLIQ WHERE PKEMP = 2981
SELECT * FROM VIEWLIQ_ATESTADORES WHERE PKEMP = 2981
SELECT * FROM VIEWLIQ WHERE PKEMP = 2981
SELECT * FROM NOTA WHERE PKEMP = 2981
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM desdis where ficha = 1111
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM desdis where ficha = 1111
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM DESSUB WHERE PKEMP = 2969
SELECT * FROM VIEWLIQ WHERE PKEMP = 2969
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM RECORC
SELECT * FROM RECDIS
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM RECDIS
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM NOTA
SELECT * FROM NOTA WHERE PKEMP = 3117
SELECT * FROM DESSUB WHERE PKEMP = 3117
SELECT * FROM VIEWLIQ_ATESTADORES WHERE PKEMP = 3117
DELETE FROM VIEWLIQ_ATESTADORES WHERE PKEMP = 3117
SELECT * FROM VIEWLIQ WHERE PKEMP = 3117
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM RECEIT WHERE DTLAN = '02.07.2025'
SELECT * FROM RECEIT WHERE DTLAN = '02.07.2025' AND CONTA = '1003-2'
SELECT * FROM RECEIT WHERE DTLAN BETWEEN '02.07.2025' AND '31.07.2025' AND CONTA = '1003-2'
select * from autorcam;
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM RECEIT WHERE DTLAN BETWEEN '02.07.2025' AND '31.07.2025' AND CONTA = '1003-2'
SELECT * FROM ORDCRE WHERE CONTA = '1003-2'
SELECT * FROM ORDCRE WHERE DTLAN BETWEEN '02.07.2025' AND '31.07.2025' AND CONTA = '1003-2'
DELETE FROM ORDCRE WHERE DTLAN BETWEEN '02.07.2025' AND '31.07.2025' AND CONTA = '1003-2'
SELECT * FROM ORDCRE WHERE DTLAN BETWEEN '02.07.2025' AND '31.07.2025' AND CONTA = '1003-2'
SELECT * FROM RECEIT WHERE DTLAN BETWEEN '02.07.2025' AND '31.07.2025' AND CONTA = '1003-2'
DELETE FROM RECEIT WHERE DTLAN BETWEEN '02.07.2025' AND '31.07.2025' AND CONTA = '1003-2'
DELETE FROM RECEIT WHERE DTLAN = '02.07.2025' AND CONTA = '1003-2'
SELECT * FROM RECEIT WHERE DTLAN = '02.07.2025' AND CONTA = '1003-2'
SELECT * FROM RECEIT WHERE DTLAN = '01.07.2025' AND CONTA = '1003-2'
SELECT * FROM ORDCRE WHERE DTLAN = '01.07.2025' AND CONTA = '1003-2'
SELECT * FROM ORDCRE WHERE DTLAN = '01.07.2025' AND CONTA = '1003-2' AND SISTEMA = 'SIA'
SELECT * FROM ORDCRE WHERE DTLAN = '01.07.2025' AND CONTA = '1003-2' 
SELECT * FROM ORDCRE WHERE DTLAN = '01.07.2025' AND CONTA = '1003-2' AND SISTEMA = 'SIA'
DELETE FROM ORDCRE WHERE DTLAN = '01.07.2025' AND CONTA = '1003-2' AND SISTEMA = 'SIA'
DELETE FROM ORDCRE WHERE DTLAN = '01.07.2025' AND CONTA = '1003-2' 
SELECT * FROM ORDCRE WHERE DTLAN = '01.07.2025' AND CONTA = '1003-2' 
SELECT * FROM RECORC WHERE FICHA IN (272, 251, 252, 253, 267, 268, 269, 250, 249, 120, 130, 169)
SELECT * FROM RECORC WHERE FICHA = 274
SELECT * FROM RECORC WHERE FICHA = 202
SELECT * FROM RECORC WHERE FICHA = 55
SELECT * FROM RECORC WHERE FICHA = 50
SELECT * FROM RECORC WHERE FICHA = 53
SELECT * FROM RECORC WHERE FICHA = 279
SELECT * FROM RECORC WHERE FICHA = 54
SELECT * FROM RECORC WHERE FICHA = 189
SELECT * FROM RECORC WHERE FICHA = 188
SELECT * FROM RECORC WHERE FICHA = 189
SELECT * FROM RECORC WHERE FICHA = 276
SELECT * FROM RECORC WHERE FICHA = 190
SELECT * FROM RECORC WHERE FICHA = 191
SELECT * FROM RECORC WHERE FICHA = 192
SELECT * FROM RECORC WHERE FICHA = 290
SELECT * FROM RECORC WHERE FICHA = 187
SELECT * FROM RECORC WHERE FICHA = 203
SELECT * FROM RECORC WHERE FICHA = 186
SELECT * FROM RECORC WHERE FICHA = 277
SELECT * FROM RECORC WHERE FICHA = 262
SELECT * FROM RECORC WHERE FICHA = 56
SELECT * FROM RECORC WHERE FICHA = 260
SELECT * FROM RECORC WHERE FICHA = 264
SELECT * FROM RECORC WHERE FICHA = 261
SELECT * FROM RECORC WHERE FICHA = 263
SELECT * FROM RECORC WHERE FICHA = 258
SELECT * FROM RECORC WHERE FICHA = 259
SELECT * FROM RECORC WHERE FICHA = 270
SELECT * FROM RECORC WHERE FICHA = 266
SELECT * FROM RECORC WHERE FICHA = 271
SELECT * FROM RECORC WHERE FICHA = 265
SELECT * FROM RECORC WHERE FICHA = 206
SELECT * FROM RECORC WHERE FICHA = 204
SELECT * FROM RECORC WHERE FICHA = 205
SELECT * FROM RECORC WHERE FICHA = 283
SELECT * FROM RECORC WHERE FICHA = 280
SELECT * FROM RECORC WHERE FICHA = 281
SELECT * FROM RECORC WHERE FICHA = 275
SELECT * FROM RECORC WHERE FICHA = 193 
SELECT * FROM RECORC WHERE FICHA = 194 
SELECT * FROM RECORC WHERE FICHA = 278 
SELECT * FROM RECORC WHERE FICHA = 185 
SELECT * FROM RECORC WHERE FICHA = 49 
SELECT * FROM RECORC WHERE FICHA = 50
SELECT * FROM TABACAO
SELECT * FROM DESORC
SELECT * FROM TABPROGRAMAACAO
SELECT * FROM DESORC
SELECT * FROM DESORC WHERE ACAO = 2176
SELECT * FROM DESORC
SELECT * FROM DESORC WHERE ACAO = 2049
SELECT * FROM DESORC WHERE ACAO = 2028
SELECT * FROM DESORC WHERE ACAO = 2027
SELECT * FROM DESORC WHERE ACAO = 2029
SELECT * FROM DESORC WHERE ACAO = 1093
SELECT * FROM DESORC WHERE ACAO = 2173
SELECT * FROM DESORC WHERE ACAO = 1099
SELECT * FROM DESORC WHERE ACAO = 1100
SELECT * FROM DESORC WHERE ACAO = 1062
SELECT * FROM DESORC WHERE ACAO = 1070 
SELECT * FROM DESORC WHERE ACAO = 2091 
SELECT * FROM DESORC WHERE ACAO = 1101 
SELECT * FROM DESORC WHERE ACAO = 2238 
SELECT * FROM DESORC WHERE ACAO = 1070 
SELECT * FROM DESORC WHERE ACAO = 1062 
SELECT * FROM DESORC WHERE ACAO = 2238 
SELECT * FROM DESORC WHERE ACAO = 1097 
SELECT * FROM DESORC WHERE ACAO = 2239 
SELECT * FROM DESORC WHERE ACAO = 2299 
SELECT * FROM DESORC WHERE ACAO = 2099 
SELECT * FROM DESORC WHERE ACAO = 2244 
SELECT * FROM DESORC WHERE ACAO = 2160 
SELECT * FROM DESORC WHERE ACAO = 1102 
SELECT * FROM DESORC WHERE ACAO = 1096 
SELECT * FROM DESORC WHERE ACAO = 2111 
SELECT * FROM DESORC WHERE ACAO = 2132 
SELECT * FROM DESORC WHERE ACAO = 2132 and programa = 0052 
SELECT * FROM DESORC WHERE ACAO = 2135 
SELECT * FROM DESORC WHERE ACAO = 1068 
SELECT * FROM DESORC WHERE ACAO = 2007 
SELECT * FROM DESORC WHERE ACAO = 2243 
SELECT * FROM DESORC WHERE ACAO = 2007 
SELECT * FROM DESORC WHERE ACAO = 2008 
SELECT * FROM DESORC WHERE ACAO = 2032 
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM DESORC WHERE ACAO = 2032 
SELECT * FROM DESORC WHERE ACAO = 1010
SELECT * FROM DESORC WHERE ACAO = 2010
SELECT * FROM DESPES WHERE PKEMP IN (4337, 4815)
SELECT * FROM VINGRUPO
SELECT * FROM VINCODIGO
SELECT * FROM VINCODIGO WHERE VINCODIGO LIKE '%EMENDA%'
SELECT * FROM VINCODIGO 
SELECT * FROM VINCODIGO WHERE VINCODIGONOME LIKE '%EMENDA%'
SELECT * FROM VINCODIGO WHERE VINCODIGONOME LIKE '%EMENDAS%'
SELECT * FROM VINCODIGO WHERE VINCODIGONOME LIKE '%EMENDA%'
SELECT * FROM VINCODIGO WHERE VINCODIGONOME LIKE '%EMENDAS%'
SELECT * FROM VINCODIGO WHERE VINCODIGONOME LIKE '%EMENDA%'
SELECT * FROM VINCODIGO WHERE VINCODIGONOME LIKE '%EMENDAS%'
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
select * from desorc
select * from desorc where fonte_stn = 1.753
select * from recorc where fonte_stn = 1.753
select * from recorc where fonte_stn = 1.500
select * from recorc where fonte_stn = 1.753
select * from recorc where fonte_stn = 1.500
select * from desorc where fonte_stn = 1.500
select * from desorc where fonte_stn = 1.753
select * from desorc where fonte_stn = 1.500
select * from desorc where fonte_stn = 1.753
select * from desorc where fonte_stn = 1.749
select * from recorc where fonte_stn = 1.749
SELECT * FROM DESORC WHERE FONTE_STN = 1.720
SELECT * FROM DESORC 
SELECT * FROM DESORC WHERE FONTE_STN = 2.660
SELECT * FROM DESORC WHERE FONTE_STN = 2.661
SELECT * FROM DESORC WHERE FONTE_STN = 2.662
SELECT * FROM DESORC WHERE FONTE_STN = 2.669
select * from pla_ppaacoesmov
SELECT * FROM DESORC WHERE FUNCAO = 12
SELECT * FROM RECORC WHERE FONTE_STN = 1.540
SELECT * FROM DESORC WHERE FUNCAO = 12
SELECT * FROM DESORC WHERE EMPRESA = 1 AND CODLO = 020501
SELECT * FROM DESORC WHERE EMPRESA = 1 AND CODLO = 020501 AND FUNCAO = 12
SELECT * FROM DESORC WHERE EMPRESA = 1 AND CODLO = 020501 
SELECT * FROM RECEIT WHERE NLANC IN (19949, 19961)
SELECT * FROM ORDCRE WHERE ORDCRE IN (18258, 18270)
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM DESDIS WHERE FICHA = 1190
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM VINGRUPO
SELECT * FROM RECORC
SELECT * FROM RECORC WHERE FONTE_STN = 1.500
SELECT * FROM RECORC WHERE FONTE_STN = 1.501
SELECT * FROM DESORC WHERE FONTE_STN = 1.500
UPDATE DESORC SET VINGRUPO = '500', FONCODIGO = '500' WHERE FONTE_STN = 1.500
SELECT * FROM DESORC WHERE FONTE_STN = 1.501
SELECT * FROM DESORC WHERE FONTE_STN = 1.500
SELECT * FROM DESORC WHERE FONTE_STN = 1.501
SELECT * FROM RECORC WHERE FONTE_STN = 1.550
SELECT * FROM RECORC WHERE FONTE_STN = 1.552
SELECT * FROM RECORC WHERE FONTE_STN = 1.600
SELECT * FROM RECORC WHERE FONTE_STN = 1.621
SELECT * FROM DESORC WHERE FONTE_STN = 1.573
UPDATE DESORC SET VINGRUPO = '573', VINCODIGO = '001', FONCODIGO = '573' WHERE FONTE_STN = 1.573
SELECT * FROM DESORC WHERE FONTE_STN = 1.635
UPDATE DESORC SET VINGRUPO = '635', VINCODIGO = '001', FONCODIGO = '635' WHERE FONTE_STN = 1.635
SELECT * FROM DESORC WHERE FONTE_STN = 1.704
UPDATE DESORC SET VINGRUPO = '704', FONCODIGO = '704' WHERE FONTE_STN = 1.704
SELECT * FROM DESORC WHERE FONTE_STN = 1.705
UPDATE DESORC SET VINGRUPO = '705', VINCODIGO = '001', FONCODIGO = '705' WHERE FONTE_STN = 1.705
SELECT * FROM DESORC WHERE FONTE_STN = 1.550
UPDATE DESORC SET VINGRUPO = '550', VINCODIGO = '001', FONCODIGO = '550' WHERE FONTE_STN = 1.550
SELECT * FROM DESORC WHERE FONTE_STN = 1.553
UPDATE DESORC SET VINGRUPO = '553', VINCODIGO = '001', FONCODIGO = '553' WHERE FONTE_STN = 1.553
SELECT * FROM DESORC WHERE FONTE_STN = 1.660
UPDATE DESORC SET VINGRUPO = '660', VINCODIGO = '001', FONCODIGO = '660' WHERE FONTE_STN = 1.660
SELECT * FROM DESORC WHERE FONTE_STN = 1.661
UPDATE DESORC SET VINGRUPO = '661', VINCODIGO = '001', FONCODIGO = '661' WHERE FONTE_STN = 1.661
SELECT * FROM DESORC WHERE FONTE_STN = 1.540
SELECT * FROM DESORC WHERE FONTE_STN = 1.700
UPDATE DESORC SET VINGRUPO = '700', VINCODIGO = '001', FONCODIGO = '700' WHERE FONTE_STN = 1.700
SELECT * FROM DESORC WHERE FONTE_STN = 1.552
UPDATE DESORC SET VINGRUPO = '552', VINCODIGO = '001', FONCODIGO = '552' WHERE FONTE_STN = 1.552
SELECT * FROM DESORC WHERE FONTE_STN = 1.701
UPDATE DESORC SET VINGRUPO = '701', VINCODIGO = '001', FONCODIGO = '701' WHERE FONTE_STN = 1.701
SELECT * FROM DESORC WHERE FONTE_STN = 1.541
SELECT * FROM DESORC WHERE FONTE_STN = 1.600
UPDATE DESORC SET VINGRUPO = '600', VINCODIGO = '001', FONCODIGO = '600' WHERE FONTE_STN = 1.600
SELECT * FROM DESORC WHERE FONTE_STN = 1.621
UPDATE DESORC SET VINGRUPO = '621', VINCODIGO = '001', FONCODIGO = '621' WHERE FONTE_STN = 1.621
SELECT * FROM DESSUB WHERE PKEMP = 6458
SELECT * FROM VIEWLIQ_ATESTADORES WHERE PKEMP = 6458
SELECT * FROM VIEWLIQ WHERE PKEMP = 6458
SELECT * FROM FONGRUPO
SELECT * FROM VINGRUPO
SELECT * FROM DESORC WHERE UNIDADE = 25
SELECT * FROM DESORC WHERE EMPRESA = 12
SELECT * FROM DESDIS WHERE EMPRESA = 12
SELECT * FROM DESORC WHERE EMPRESA = 12
SELECT * FROM DESORC WHERE FICHA IN (545,546,547,548)
SELECT * FROM DESDIS WHERE FICHA IN (545,546,547,548)
SELECT * FROM DESCON
SELECT * FROM DESCON where data_encerra is not null
SELECT * FROM DESCON WHERE DATA_ENCERRA IS NOT NULL
DELETE FROM DESCON WHERE DATA_ENCERRA IS NOT NULL
SELECT * FROM DESCON WHERE DATA_ENCERRA IS NOT NULL
SELECT * FROM DESCON_DETALHE WHERE DATA_ENCERRA IS NOT NULL
DELETE FROM DESCON_DETALHE WHERE DATA_ENCERRA IS NOT NULL
SELECT * FROM DESORC WHERE FONTE_STN = 1600
SELECT * FROM DESORC WHERE FONTE_STN = 1.600
SELECT * FROM DESORC WHERE FONTE_STN = 1.600 AND PROGRAMA = 0051
SELECT * FROM DESORC WHERE FONTE_STN = 1.600 AND PROGRAMA = 0052
SELECT * FROM DESDIS WHERE FONTE_STN = 1.600 AND PROGRAMA = 0052
SELECT * FROM DESORC WHERE FONTE_STN = 1.600 AND PROGRAMA = 0053
SELECT * FROM DESDIS WHERE FONTE_STN = 1.600 AND PROGRAMA = 0053
SELECT * FROM DESORC WHERE FONTE_STN = 1.600 AND PROGRAMA = 0055
SELECT * FROM DESDIS WHERE FONTE_STN = 1.600 AND PROGRAMA = 0055
SELECT * FROM DESORC WHERE FONTE_STN = 1.600 AND PROGRAMA = 0055
SELECT * FROM DESORC WHERE FONTE_STN = 1.600 AND PROGRAMA = 0054
SELECT * FROM DESDIS WHERE FONTE_STN = 1.600 AND PROGRAMA = 0054
SELECT * FROM RECORC WHERE FICHA = 68
SELECT * FROM RECDIS WHERE FICHA = 68
SELECT * FROM RECORC WHERE FICHA = 69
SELECT * FROM RECDIS WHERE FICHA = 69
SELECT * FROM RECORC WHERE FICHA = 69
SELECT * FROM RECORC WHERE FICHA = 70
SELECT * FROM RECDIS WHERE FICHA = 70
SELECT * FROM RECORC WHERE FICHA = 71
SELECT * FROM RECDIS WHERE FICHA = 71
SELECT * FROM RECORC WHERE FICHA = 104
SELECT * FROM RECDIS WHERE FICHA = 104 
SELECT * FROM DESORC WHERE FICHA = 497
SELECT * FROM DESDIS WHERE FICHA = 497
SELECT * FROM DESORC WHERE FICHA = 497
SELECT * FROM DESORC WHERE FICHA = 597
SELECT * FROM DESDIS WHERE FICHA = 597
SELECT * FROM EXTRA
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM dessub where pkemp = 2685
SELECT * FROM viewliq where pkemp = 2685
SELECT * FROM viewliq_atestadores where pkemp = 2685
SELECT * FROM viewliq where pkemp = 2685
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM DESCON_DETALHE
select * from despes where pkemp = 1222
select * from dessub where pkemp = 1222
delete from dessub where pkemp = 1222
select * from viewliq where pkemp = 1222
select * from viewliq_atestadores where pkemp = 1222
select * from viewliq where pkemp = 1222
delete from viewliq where pkemp = 1222
select * from despes where pkemp = 1222
delete from despes where pkemp = 1222
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
select * from descon where conta = '11483-9'
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT PODER   ,ORGAO   ,UNIDADE   ,FUNCAO   ,SUBFUNCAO   ,PROGRAMA   ,PROJATIV   ,ACAO   ,CATEGORIA   ,GRUPO   ,MODALIDADE   ,ELEMENTO   ,DESDOBRO   ,VINGRUPO   ,VINCODIGO   ,FONINDUSO   ,FONGRUPO   ,FONCODIGO   ,FONRO   ,FONTE_STN   ,COMPFR_STN   ,DOTAC FROM DESORC WHERE FONCODIGO LIKE '% ';
UPDATE DESORC SET FONCODIGO = TRIM(FONCODIGO) WHERE FONCODIGO LIKE '% '    OR FONCODIGO LIKE ' %'; 
UPDATE DESDIS SET FONCODIGO = TRIM(FONCODIGO) WHERE FONCODIGO LIKE '% '    OR FONCODIGO LIKE ' %';  
SELECT PODER   ,ORGAO   ,UNIDADE   ,FUNCAO   ,SUBFUNCAO   ,PROGRAMA   ,PROJATIV   ,ACAO   ,CATEGORIA   ,GRUPO   ,MODALIDADE   ,ELEMENTO   ,DESDOBRO   ,VINGRUPO   ,VINCODIGO   ,FONINDUSO   ,FONGRUPO   ,FONCODIGO   ,FONRO   ,FONTE_STN   ,COMPFR_STN   ,DOTAC FROM DESORC WHERE FONCODIGO LIKE '% ';
UPDATE DESORC SET FONCODIGO = TRIM(FONCODIGO) WHERE FONCODIGO LIKE '% '    OR FONCODIGO LIKE ' %';  
UPDATE DESDIS SET FONCODIGO = TRIM(FONCODIGO) WHERE FONCODIGO LIKE '% '    OR FONCODIGO LIKE ' %';
UPDATE DESORC SET FONCODIGO = '500' WHERE FONCODIGO = '500 '
SELECT PODER   ,ORGAO   ,UNIDADE   ,FUNCAO   ,SUBFUNCAO   ,PROGRAMA   ,PROJATIV   ,ACAO   ,CATEGORIA   ,GRUPO   ,MODALIDADE   ,ELEMENTO   ,DESDOBRO   ,VINGRUPO   ,VINCODIGO   ,FONINDUSO   ,FONGRUPO   ,FONCODIGO   ,FONRO   ,FONTE_STN   ,COMPFR_STN   ,DOTAC FROM DESORC WHERE FONCODIGO LIKE '% ';
UPDATE DESORC SET FONCODIGO = '704' WHERE FONCODIGO = '704 '
SELECT PODER   ,ORGAO   ,UNIDADE   ,FUNCAO   ,SUBFUNCAO   ,PROGRAMA   ,PROJATIV   ,ACAO   ,CATEGORIA   ,GRUPO   ,MODALIDADE   ,ELEMENTO   ,DESDOBRO   ,VINGRUPO   ,VINCODIGO   ,FONINDUSO   ,FONGRUPO   ,FONCODIGO   ,FONRO   ,FONTE_STN   ,COMPFR_STN   ,DOTAC FROM DESORC WHERE FONCODIGO LIKE '% ';
SELECT PODER   ,ORGAO   ,UNIDADE   ,FUNCAO   ,SUBFUNCAO   ,PROGRAMA   ,PROJATIV   ,ACAO   ,CATEGORIA   ,GRUPO   ,MODALIDADE   ,ELEMENTO   ,DESDOBRO   ,VINGRUPO   ,VINCODIGO   ,FONINDUSO   ,FONGRUPO   ,FONCODIGO   ,FONRO   ,FONTE_STN   ,COMPFR_STN   ,DOTAC FROM DESDIS WHERE FONCODIGO LIKE '% ';
SELECT PODER   ,ORGAO   ,UNIDADE   ,FUNCAO   ,SUBFUNCAO   ,PROGRAMA   ,PROJATIV   ,ACAO   ,CATEGORIA   ,GRUPO   ,MODALIDADE   ,ELEMENTO   ,DESDOBRO   ,VINGRUPO   ,VINCODIGO   ,FONINDUSO   ,FONGRUPO   ,FONCODIGO   ,FONRO   ,FONTE_STN   ,COMPFR_STN   ,DOTAC FROM DESORC WHERE FONCODIGO LIKE '% ';
SELECT * FROM DESORC
SELECT * FROM DESDIS
SELECT * FROM DESCON WHERE EMPRESA = 6
SELECT * FROM DESCON WHERE CONTA IN ('575240217-0', '8647-9')
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM RECDIS WHERE FICHA = 144 
SELECT * FROM RECORC WHERE FICHA = 172
SELECT * FROM RECDIS WHERE FICHA = 172
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM DESSUB WHERE PKEMP = 1219 
SELECT * FROM VIEWLIQ_ATESTADORES WHERE PKEMP = 1219 
SELECT * FROM VIEWLIQ WHERE PKEMP = 1219 
SELECT * FROM DESPES WHERE PKEMP = 1219 
SELECT * FROM DESPES WHERE PKEMP = 1192 
SELECT * FROM DESSUB WHERE PKEMP = 1192 
SELECT * FROM VIEWLIQ_ATESTADORES WHERE PKEMP = 1192 
SELECT * FROM VIEWLIQ WHERE PKEMP = 1192 
SELECT * FROM DESPES WHERE PKEMP = 1192 
SELECT * FROM DESCON_DETALHE WHERE CONTA = '11'
SELECT * FROM DESCON WHERE CONTA = '11'
SELECT * FROM RECEIT WHERE CONTA = '15250-4' AND DTLAN = '28.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '21523-6' AND DTLAN = '28.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '4500-4' AND DTLAN = '28.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '575240217-0' AND DTLAN = '28.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '933-6' AND DTLAN = '28.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '9033-6' AND DTLAN = '28.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '15250-4' AND DTLAN = '29.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '148289-0' AND DTLAN = '29.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '21523-6' AND DTLAN = '29.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '4500-4' AND DTLAN = '29.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '9033-6' AND DTLAN = '29.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '15250-4' AND DTLAN = '29.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '575240217-0' AND DTLAN = '29.01.2026'
SELECT * FROM RECEIT WHERE CONTA = '4500-4' AND DTLAN = '29.01.2026'
SELECT *  FROM TABEMPRESA
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM DESDIS WHERE FICHA = 1050
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM DESDIS WHERE FICHA = 1050
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM DESDIS WHERE FICHA IN ( 1053, 1054, 1055)
select * from rectab
select * from rectab where codre = '1321%'
select * from rectab
select * from RECDIS
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
select * from RECDIS
select * from RECORC
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
SELECT * FROM DESCON WHERE CONTA = '8647-9P'
SELECT * FROM DESCON WHERE CONTA = '8647-9 P'
SELECT NOME, EMPRESA, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA