20241007@171221.9948 85nbmh8rtg96gdpehv4pfes1av Query : use flama_phc
20241007@171221.9950 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241007@171221.9980 85nbmh8rtg96gdpehv4pfes1av Query : use flama_phc
20241007@171221.9983 85nbmh8rtg96gdpehv4pfes1av Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241007@171222.2700 85nbmh8rtg96gdpehv4pfes1av Query : use flama_phc
20241007@171222.3000 85nbmh8rtg96gdpehv4pfes1av Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241007@171222.7900 85nbmh8rtg96gdpehv4pfes1av Query : use flama_phc
20241007@171222.8200 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from td where ndoc = 39
20241007@171222.1230 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241007@171222.1440 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.1750 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241007@171222.1529 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.1547 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241007@171222.1581 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.1598 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241007@171222.1611 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241007@171222.1695 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241007@171222.1707 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.1727 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241007@171222.1754 85nbmh8rtg96gdpehv4pfes1av Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67040823956704086627' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241007@171222.1902 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.1964 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241007@171222.2026 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241007@171222.2039 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241007@171222.2074 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241007@171222.2086 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241007@171222.2107 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241007@171222.2118 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241007@171222.2132 85nbmh8rtg96gdpehv4pfes1av Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67040823956704086627',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241007@171222.2348 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 fno valor from wsftdata order by fno desc
20241007@171222.2391 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.2407 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241007@171222.2453 85nbmh8rtg96gdpehv4pfes1av Query : select 'normal' from dummy
20241007@171222.2496 85nbmh8rtg96gdpehv4pfes1av Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67040823956704086627',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1111,100810,0,'2024-10-07',39,'euro',0,0,2024 ,?,?)
20241007@171222.2749 85nbmh8rtg96gdpehv4pfes1av Query : use flama_phc
20241007@171222.2753 85nbmh8rtg96gdpehv4pfes1av Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20241007@171222.2784 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.966.00.01'
20241007@171222.2942 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.2958 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171222.2986 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.3002 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171222.3012 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171222.3025 85nbmh8rtg96gdpehv4pfes1av Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2400743200a'
20241007@171222.3038 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.3055 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171222.3067 85nbmh8rtg96gdpehv4pfes1av Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6704084541670408664a','aut67040823956704086627' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171222.3071 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.3087 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171222.3116 85nbmh8rtg96gdpehv4pfes1av Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6704084541670408664a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',32.000 ,'aut67040823956704086627' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241007@171222.3350 85nbmh8rtg96gdpehv4pfes1av Query : use flama_phc
20241007@171222.3353 85nbmh8rtg96gdpehv4pfes1av Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20241007@171222.3374 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.966.00.01'
20241007@171222.3388 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.3404 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171222.3429 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.3444 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171222.3453 85nbmh8rtg96gdpehv4pfes1av Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171222.3466 85nbmh8rtg96gdpehv4pfes1av Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2400743200a'
20241007@171222.3478 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.3494 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171222.3506 85nbmh8rtg96gdpehv4pfes1av Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67040228726704086654','aut67040823956704086627' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171222.3510 85nbmh8rtg96gdpehv4pfes1av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.3524 85nbmh8rtg96gdpehv4pfes1av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171222.3552 85nbmh8rtg96gdpehv4pfes1av Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67040228726704086654',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut67040823956704086627' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241007@171222.3762 85nbmh8rtg96gdpehv4pfes1av Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67040823956704086627','2406452','wait',39,'adm09112754980.682000002')
20241007@171222.3831 85nbmh8rtg96gdpehv4pfes1av Query : use flama_phc
20241007@171222.3834 85nbmh8rtg96gdpehv4pfes1av Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241007@171222.3865 85nbmh8rtg96gdpehv4pfes1av Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2458';
20241007@171222.3895 85nbmh8rtg96gdpehv4pfes1av Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2458';
20241007@171222.3939 85nbmh8rtg96gdpehv4pfes1av Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2458';
20241007@171222.3968 85nbmh8rtg96gdpehv4pfes1av Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2458';
20241007@171222.5602 hgd4n8jv3atbohvltrsl9n65hj Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241007@171222.5615 hgd4n8jv3atbohvltrsl9n65hj Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241007@171222.5667 hgd4n8jv3atbohvltrsl9n65hj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2459';
20241007@171222.5725 hgd4n8jv3atbohvltrsl9n65hj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2459';
20241007@171222.5777 hgd4n8jv3atbohvltrsl9n65hj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2459';
20241007@171222.5805 hgd4n8jv3atbohvltrsl9n65hj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2459';
20241007@171222.5857 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.5860 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241007@171222.5927 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.5930 hgd4n8jv3atbohvltrsl9n65hj Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241007@171222.5981 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4988.00.1'
20241007@171222.6139 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2064 and bo.obrano = 2406453 and bi.ref ='324.4988.00.1' and bi.lordem =1
20241007@171222.6477 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4988.00.1'
20241007@171222.6518 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2064 and bo.obrano = 2406453 and bi.ref ='324.4988.00.1' and bi.lordem =1
20241007@171222.6536 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.6540 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241007@171222.6574 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.6577 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 1 valor from td where td.ndoc = 39
20241007@171222.6606 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.6609 hgd4n8jv3atbohvltrsl9n65hj Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241007@171222.6636 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241007@171222.6672 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.6675 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241007@171222.6703 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.6706 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241007@171222.6735 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.6737 hgd4n8jv3atbohvltrsl9n65hj Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241007@171222.6780 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.6783 hgd4n8jv3atbohvltrsl9n65hj Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241007@171222.6833 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.6837 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from td where ndoc = 39
20241007@171222.6849 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241007@171222.6862 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.6877 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241007@171222.6895 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.6938 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241007@171222.6965 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.6980 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241007@171222.6991 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241007@171222.7054 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241007@171222.7066 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.7082 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241007@171222.7098 hgd4n8jv3atbohvltrsl9n65hj Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670407758367040866aa' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241007@171222.7259 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.7279 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241007@171222.7313 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241007@171222.7324 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241007@171222.7336 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241007@171222.7347 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241007@171222.7359 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241007@171222.7370 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241007@171222.7381 hgd4n8jv3atbohvltrsl9n65hj Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670407758367040866aa',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241007@171222.7593 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 fno valor from wsftdata order by fno desc
20241007@171222.7619 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.7635 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241007@171222.7656 hgd4n8jv3atbohvltrsl9n65hj Query : select 'normal' from dummy
20241007@171222.7675 hgd4n8jv3atbohvltrsl9n65hj Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670407758367040866aa',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1112,100810,0,'2024-10-07',39,'euro',0,0,2024 ,?,?)
20241007@171222.7956 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.7960 hgd4n8jv3atbohvltrsl9n65hj Query : select st.usalote valor from st where st.ref = '324.4988.00.1'
20241007@171222.7982 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4988.00.1'
20241007@171222.8138 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.8153 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171222.8178 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.8192 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171222.8200 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171222.8214 hgd4n8jv3atbohvltrsl9n65hj Query : select sestamp valor from se where ref ='324.4988.00.1' and lote = 'r2100754100a'
20241007@171222.8236 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.8253 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171222.8264 hgd4n8jv3atbohvltrsl9n65hj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670400096667040866c9','aut670407758367040866aa' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171222.8269 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.8285 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171222.8314 hgd4n8jv3atbohvltrsl9n65hj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670400096667040866c9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut670407758367040866aa' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241007@171222.8531 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.8535 hgd4n8jv3atbohvltrsl9n65hj Query : select st.usalote valor from st where st.ref = '324.4988.00.1'
20241007@171222.8557 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4988.00.1'
20241007@171222.8572 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.8587 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171222.8614 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.8629 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171222.8638 hgd4n8jv3atbohvltrsl9n65hj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171222.8652 hgd4n8jv3atbohvltrsl9n65hj Query : select sestamp valor from se where ref ='324.4988.00.1' and lote = 'r2100754100a'
20241007@171222.8666 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.8687 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171222.8707 hgd4n8jv3atbohvltrsl9n65hj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670407256967040866d3','aut670407758367040866aa' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171222.8712 hgd4n8jv3atbohvltrsl9n65hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171222.8727 hgd4n8jv3atbohvltrsl9n65hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171222.8756 hgd4n8jv3atbohvltrsl9n65hj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670407256967040866d3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',64.000 ,'aut670407758367040866aa' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241007@171222.8974 hgd4n8jv3atbohvltrsl9n65hj Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670407758367040866aa','2406453','wait',39,'adm09112754980.682000002')
20241007@171222.9043 hgd4n8jv3atbohvltrsl9n65hj Query : use flama_phc
20241007@171222.9047 hgd4n8jv3atbohvltrsl9n65hj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241007@171222.9077 hgd4n8jv3atbohvltrsl9n65hj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2459';
20241007@171222.9111 hgd4n8jv3atbohvltrsl9n65hj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2459';
20241007@171222.9157 hgd4n8jv3atbohvltrsl9n65hj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2459';
20241007@171222.9184 hgd4n8jv3atbohvltrsl9n65hj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2459';
20241007@171222.9878 een7qelskm72sab15kesqjji1l Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241007@171222.9890 een7qelskm72sab15kesqjji1l Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241007@171222.9943 een7qelskm72sab15kesqjji1l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2460';
20241007@171223.7700 een7qelskm72sab15kesqjji1l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2460';
20241007@171223.1310 een7qelskm72sab15kesqjji1l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2460';
20241007@171223.1590 een7qelskm72sab15kesqjji1l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2460';
20241007@171223.2080 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.2110 een7qelskm72sab15kesqjji1l Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241007@171223.2930 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.2960 een7qelskm72sab15kesqjji1l Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241007@171223.3390 een7qelskm72sab15kesqjji1l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20241007@171223.1184 een7qelskm72sab15kesqjji1l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2064 and bo.obrano = 2406454 and bi.ref ='324.988.00.01' and bi.lordem =1
20241007@171223.1900 een7qelskm72sab15kesqjji1l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20241007@171223.1922 een7qelskm72sab15kesqjji1l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2064 and bo.obrano = 2406454 and bi.ref ='324.988.00.01' and bi.lordem =1
20241007@171223.1939 een7qelskm72sab15kesqjji1l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20241007@171223.1957 een7qelskm72sab15kesqjji1l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2064 and bo.obrano = 2406454 and bi.ref ='324.988.00.01' and bi.lordem =1
20241007@171223.1974 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.1977 een7qelskm72sab15kesqjji1l Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241007@171223.2009 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.2012 een7qelskm72sab15kesqjji1l Query : select top 1 1 valor from td where td.ndoc = 39
20241007@171223.2041 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.2043 een7qelskm72sab15kesqjji1l Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241007@171223.2069 een7qelskm72sab15kesqjji1l Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241007@171223.2104 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.2107 een7qelskm72sab15kesqjji1l Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241007@171223.2135 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.2138 een7qelskm72sab15kesqjji1l Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241007@171223.2166 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.2169 een7qelskm72sab15kesqjji1l Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241007@171223.2210 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.2213 een7qelskm72sab15kesqjji1l Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241007@171223.2258 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.2260 een7qelskm72sab15kesqjji1l Query : select 1 valor from td where ndoc = 39
20241007@171223.2272 een7qelskm72sab15kesqjji1l Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241007@171223.2284 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.2299 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241007@171223.2316 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.2331 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241007@171223.2358 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.2373 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241007@171223.2386 een7qelskm72sab15kesqjji1l Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241007@171223.2459 een7qelskm72sab15kesqjji1l Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241007@171223.2474 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.2489 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241007@171223.2504 een7qelskm72sab15kesqjji1l Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6704039926670408673a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241007@171223.2672 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.2693 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241007@171223.2735 een7qelskm72sab15kesqjji1l Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241007@171223.2752 een7qelskm72sab15kesqjji1l Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241007@171223.2766 een7qelskm72sab15kesqjji1l Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241007@171223.2781 een7qelskm72sab15kesqjji1l Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241007@171223.2794 een7qelskm72sab15kesqjji1l Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241007@171223.2808 een7qelskm72sab15kesqjji1l Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241007@171223.2822 een7qelskm72sab15kesqjji1l Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6704039926670408673a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241007@171223.3049 een7qelskm72sab15kesqjji1l Query : select top 1 fno valor from wsftdata order by fno desc
20241007@171223.3075 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.3094 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241007@171223.3120 een7qelskm72sab15kesqjji1l Query : select 'normal' from dummy
20241007@171223.3137 een7qelskm72sab15kesqjji1l Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6704039926670408673a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1113,100810,0,'2024-10-07',39,'euro',0,0,2024 ,?,?)
20241007@171223.3395 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.3398 een7qelskm72sab15kesqjji1l Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20241007@171223.3424 een7qelskm72sab15kesqjji1l Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.988.00.01'
20241007@171223.3578 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.3594 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171223.3618 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.3635 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171223.3644 een7qelskm72sab15kesqjji1l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171223.3658 een7qelskm72sab15kesqjji1l Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2400410200a'
20241007@171223.3685 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.3706 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171223.3720 een7qelskm72sab15kesqjji1l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67040968996704086759','aut6704039926670408673a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171223.3725 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.3743 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171223.3782 een7qelskm72sab15kesqjji1l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67040968996704086759',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6704039926670408673a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241007@171223.4019 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.4022 een7qelskm72sab15kesqjji1l Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20241007@171223.4044 een7qelskm72sab15kesqjji1l Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.988.00.01'
20241007@171223.4057 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.4073 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171223.4102 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.4118 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171223.4128 een7qelskm72sab15kesqjji1l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171223.4141 een7qelskm72sab15kesqjji1l Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2400410200a'
20241007@171223.4157 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.4174 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171223.4185 een7qelskm72sab15kesqjji1l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67040891186704086765','aut6704039926670408673a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171223.4189 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.4205 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171223.4234 een7qelskm72sab15kesqjji1l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67040891186704086765',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut6704039926670408673a' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241007@171223.4481 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.4484 een7qelskm72sab15kesqjji1l Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20241007@171223.4506 een7qelskm72sab15kesqjji1l Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.988.00.01'
20241007@171223.4521 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.4537 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171223.4569 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.4585 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171223.4593 een7qelskm72sab15kesqjji1l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171223.4607 een7qelskm72sab15kesqjji1l Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2400410200a'
20241007@171223.4620 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.4637 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171223.4649 een7qelskm72sab15kesqjji1l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67040355836704086770','aut6704039926670408673a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171223.4653 een7qelskm72sab15kesqjji1l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.4667 een7qelskm72sab15kesqjji1l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171223.4695 een7qelskm72sab15kesqjji1l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67040355836704086770',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut6704039926670408673a' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241007@171223.4951 een7qelskm72sab15kesqjji1l Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6704039926670408673a','2406454','wait',39,'adm09112754980.682000002')
20241007@171223.5111 een7qelskm72sab15kesqjji1l Query : use flama_phc
20241007@171223.5115 een7qelskm72sab15kesqjji1l Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241007@171223.5145 een7qelskm72sab15kesqjji1l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2460';
20241007@171223.5233 een7qelskm72sab15kesqjji1l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2460';
20241007@171223.5277 een7qelskm72sab15kesqjji1l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2460';
20241007@171223.5305 een7qelskm72sab15kesqjji1l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2460';
20241007@171223.5839 spij2hp3omv8aqlgv3prbg0d51 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241007@171223.5850 spij2hp3omv8aqlgv3prbg0d51 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241007@171223.5904 spij2hp3omv8aqlgv3prbg0d51 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2461';
20241007@171223.5962 spij2hp3omv8aqlgv3prbg0d51 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2461';
20241007@171223.6018 spij2hp3omv8aqlgv3prbg0d51 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2461';
20241007@171223.6048 spij2hp3omv8aqlgv3prbg0d51 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2461';
20241007@171223.6154 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.6157 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241007@171223.6224 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.6228 spij2hp3omv8aqlgv3prbg0d51 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241007@171223.6275 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20241007@171223.6482 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2064 and bo.obrano = 2406455 and bi.ref ='304.4320.00.1' and bi.lordem =1
20241007@171223.6829 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20241007@171223.6850 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2064 and bo.obrano = 2406455 and bi.ref ='304.4320.00.1' and bi.lordem =1
20241007@171223.6892 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.6896 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241007@171223.6933 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.6937 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 1 valor from td where td.ndoc = 39
20241007@171223.6969 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.6972 spij2hp3omv8aqlgv3prbg0d51 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241007@171223.7005 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241007@171223.7048 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.7051 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241007@171223.7083 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.7087 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241007@171223.7146 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.7149 spij2hp3omv8aqlgv3prbg0d51 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241007@171223.7196 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.7200 spij2hp3omv8aqlgv3prbg0d51 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241007@171223.7290 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.7293 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from td where ndoc = 39
20241007@171223.7308 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241007@171223.7346 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.7363 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241007@171223.7383 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.7399 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241007@171223.7435 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.7451 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241007@171223.7467 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241007@171223.7547 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241007@171223.7562 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.7579 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241007@171223.7594 spij2hp3omv8aqlgv3prbg0d51 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670407257867040867b6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241007@171223.7778 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.7796 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241007@171223.7846 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241007@171223.7859 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241007@171223.7872 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241007@171223.7884 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241007@171223.7896 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241007@171223.7914 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241007@171223.7925 spij2hp3omv8aqlgv3prbg0d51 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670407257867040867b6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241007@171223.8144 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 fno valor from wsftdata order by fno desc
20241007@171223.8192 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.8207 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241007@171223.8230 spij2hp3omv8aqlgv3prbg0d51 Query : select 'normal' from dummy
20241007@171223.8245 spij2hp3omv8aqlgv3prbg0d51 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670407257867040867b6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1114,100810,0,'2024-10-07',39,'euro',0,0,2024 ,?,?)
20241007@171223.8512 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.8515 spij2hp3omv8aqlgv3prbg0d51 Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20241007@171223.8539 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20241007@171223.8698 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.8716 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171223.8748 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.8765 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171223.8774 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171223.8789 spij2hp3omv8aqlgv3prbg0d51 Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '241005'
20241007@171223.8810 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.8831 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171223.8843 spij2hp3omv8aqlgv3prbg0d51 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670404082367040867d7','aut670407257867040867b6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171223.8847 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.8884 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171223.8914 spij2hp3omv8aqlgv3prbg0d51 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670404082367040867d7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut670407257867040867b6' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241007@171223.9135 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.9138 spij2hp3omv8aqlgv3prbg0d51 Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20241007@171223.9159 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20241007@171223.9172 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.9188 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171223.9229 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.9242 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171223.9251 spij2hp3omv8aqlgv3prbg0d51 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171223.9286 spij2hp3omv8aqlgv3prbg0d51 Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '241005'
20241007@171223.9299 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.9313 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171223.9324 spij2hp3omv8aqlgv3prbg0d51 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670409134867040867e3','aut670407257867040867b6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171223.9329 spij2hp3omv8aqlgv3prbg0d51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171223.9345 spij2hp3omv8aqlgv3prbg0d51 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171223.9375 spij2hp3omv8aqlgv3prbg0d51 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670409134867040867e3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',80.000 ,'aut670407257867040867b6' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241007@171223.9597 spij2hp3omv8aqlgv3prbg0d51 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670407257867040867b6','2406455','wait',39,'adm09112754980.682000002')
20241007@171223.9698 spij2hp3omv8aqlgv3prbg0d51 Query : use flama_phc
20241007@171223.9702 spij2hp3omv8aqlgv3prbg0d51 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241007@171223.9733 spij2hp3omv8aqlgv3prbg0d51 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2461';
20241007@171223.9763 spij2hp3omv8aqlgv3prbg0d51 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2461';
20241007@171223.9805 spij2hp3omv8aqlgv3prbg0d51 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2461';
20241007@171223.9835 spij2hp3omv8aqlgv3prbg0d51 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2461';
20241007@171224.4010 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241007@171224.4140 cpefbn5rhc78p1k1ertcoh2v8l Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241007@171224.4720 cpefbn5rhc78p1k1ertcoh2v8l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2462';
20241007@171224.5300 cpefbn5rhc78p1k1ertcoh2v8l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2462';
20241007@171224.5850 cpefbn5rhc78p1k1ertcoh2v8l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2462';
20241007@171224.6130 cpefbn5rhc78p1k1ertcoh2v8l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2462';
20241007@171224.6670 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.6710 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241007@171224.7330 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.7360 cpefbn5rhc78p1k1ertcoh2v8l Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241007@171224.7780 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2041.00.1'
20241007@171224.9390 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2064 and bo.obrano = 2406456 and bi.ref ='324.2041.00.1' and bi.lordem =1
20241007@171224.1274 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2041.00.1'
20241007@171224.1297 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2064 and bo.obrano = 2406456 and bi.ref ='324.2041.00.1' and bi.lordem =1
20241007@171224.1315 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.1319 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241007@171224.1354 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.1358 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 1 valor from td where td.ndoc = 39
20241007@171224.1389 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.1392 cpefbn5rhc78p1k1ertcoh2v8l Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241007@171224.1422 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241007@171224.1460 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.1464 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241007@171224.1890 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.2088 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241007@171224.2224 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.2228 cpefbn5rhc78p1k1ertcoh2v8l Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241007@171224.2269 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.2272 cpefbn5rhc78p1k1ertcoh2v8l Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241007@171224.2322 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.2325 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from td where ndoc = 39
20241007@171224.2338 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241007@171224.2353 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.2371 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241007@171224.2392 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.2407 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241007@171224.2439 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.2454 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241007@171224.2469 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241007@171224.2538 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241007@171224.2554 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.2573 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241007@171224.2593 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6704077624670408683c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241007@171224.2819 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.2842 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241007@171224.2881 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241007@171224.2893 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241007@171224.2911 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241007@171224.2924 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241007@171224.2937 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241007@171224.2950 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241007@171224.2962 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6704077624670408683c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241007@171224.3172 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 fno valor from wsftdata order by fno desc
20241007@171224.3195 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.3213 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241007@171224.3236 cpefbn5rhc78p1k1ertcoh2v8l Query : select 'normal' from dummy
20241007@171224.3251 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6704077624670408683c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1115,100810,0,'2024-10-07',39,'euro',0,0,2024 ,?,?)
20241007@171224.3536 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.3539 cpefbn5rhc78p1k1ertcoh2v8l Query : select st.usalote valor from st where st.ref = '324.2041.00.1'
20241007@171224.3561 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2041.00.1'
20241007@171224.3715 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.3732 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171224.3757 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.3771 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171224.3779 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171224.3791 cpefbn5rhc78p1k1ertcoh2v8l Query : select sestamp valor from se where ref ='324.2041.00.1' and lote = 'r2100232100a'
20241007@171224.3816 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.3831 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171224.3843 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6704040653670408685d','aut6704077624670408683c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171224.3847 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.3863 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171224.3890 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6704040653670408685d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',36.000 ,'aut6704077624670408683c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241007@171224.4390 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.4763 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171224.5437 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.5455 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171224.5464 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171224.5476 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.5491 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171224.5503 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67040992846704086885','aut6704077624670408683c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171224.5508 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.5522 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171224.5551 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67040992846704086885',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6704077624670408683c' ,0,0 ,2,23.00,20000,?,?,?)
20241007@171224.5773 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.5777 cpefbn5rhc78p1k1ertcoh2v8l Query : select st.usalote valor from st where st.ref = '324.2041.00.1'
20241007@171224.5798 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2041.00.1'
20241007@171224.5813 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.5838 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171224.5890 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.5975 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171224.5985 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171224.5999 cpefbn5rhc78p1k1ertcoh2v8l Query : select sestamp valor from se where ref ='324.2041.00.1' and lote = 'r2100232100a'
20241007@171224.6012 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.6030 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171224.6041 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67040770266704086892','aut6704077624670408683c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171224.6046 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.6063 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171224.6095 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67040770266704086892',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut6704077624670408683c' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241007@171224.6331 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.6350 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171224.6379 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.6396 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171224.6407 cpefbn5rhc78p1k1ertcoh2v8l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241007@171224.6423 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.6442 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241007@171224.6455 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6704037152670408689c','aut6704077624670408683c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241007@171224.6460 cpefbn5rhc78p1k1ertcoh2v8l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.6477 cpefbn5rhc78p1k1ertcoh2v8l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241007@171224.6508 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6704037152670408689c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6704077624670408683c' ,0,0 ,2,23.00,50000,?,?,?)
20241007@171224.6729 cpefbn5rhc78p1k1ertcoh2v8l Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6704077624670408683c','2406456','wait',39,'adm09112754980.682000002')
20241007@171224.6809 cpefbn5rhc78p1k1ertcoh2v8l Query : use flama_phc
20241007@171224.6813 cpefbn5rhc78p1k1ertcoh2v8l Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241007@171224.6931 cpefbn5rhc78p1k1ertcoh2v8l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2462';
20241007@171224.6965 cpefbn5rhc78p1k1ertcoh2v8l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2462';
20241007@171224.7009 cpefbn5rhc78p1k1ertcoh2v8l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2462';
20241007@171224.7039 cpefbn5rhc78p1k1ertcoh2v8l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2462';
20241007@171224.7572 8u43ir2mlgu3tvvd379g4h81n7 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241007@171224.7588 8u43ir2mlgu3tvvd379g4h81n7 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241007@171224.7647 8u43ir2mlgu3tvvd379g4h81n7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2463';
20241007@171224.7706 8u43ir2mlgu3tvvd379g4h81n7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2463';
20241007@171224.7760 8u43ir2mlgu3tvvd379g4h81n7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2463';
20241007@171224.7791 8u43ir2mlgu3tvvd379g4h81n7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2463';
20241007@171224.7845 8u43ir2mlgu3tvvd379g4h81n7 Query : use flama_phc
20241007@171224.7848 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241007@171224.7915 8u43ir2mlgu3tvvd379g4h81n7 Query : use flama_phc
20241007@171224.7919 8u43ir2mlgu3tvvd379g4h81n7 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241007@171224.7962 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4751.00.1'
20241007@171224.8144 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2064 and bo.obrano = 2406457 and bi.ref ='324.4751.00.1' and bi.lordem =1
20241007@171224.8469 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4751.00.1'
20241007@171224.8494 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2064 and bo.obrano = 2406457 and bi.ref ='324.4751.00.1' and bi.lordem =1
20241007@171224.8513 8u43ir2mlgu3tvvd379g4h81n7 Query : use flama_phc
20241007@171224.8516 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241007@171224.8552 8u43ir2mlgu3tvvd379g4h81n7 Query : use flama_phc
20241007@171224.8556 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 1 valor from td where td.ndoc = 39
20241007@171224.8587 8u43ir2mlgu3tvvd379g4h81n7 Query : use flama_phc
20241007@171224.8591 8u43ir2mlgu3tvvd379g4h81n7 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241007@171224.8625 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241007@171224.8664 8u43ir2mlgu3tvvd379g4h81n7 Query : use flama_phc
20241007@171224.8667 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241007@171224.8698 8u43ir2mlgu3tvvd379g4h81n7 Query : use flama_phc
20241007@171224.8701 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241007@171224.8733 8u43ir2mlgu3tvvd379g4h81n7 Query : use flama_phc
20241007@171224.8736 8u43ir2mlgu3tvvd379g4h81n7 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241007@171224.8776 8u43ir2mlgu3tvvd379g4h81n7 Query : use flama_phc
20241007@171224.8779 8u43ir2mlgu3tvvd379g4h81n7 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241007@171224.8829 8u43ir2mlgu3tvvd379g4h81n7 Query : use flama_phc
20241007@171224.8832 8u43ir2mlgu3tvvd379g4h81n7 Query : select 1 valor from td where ndoc = 39
20241007@171224.8846 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241007@171224.8862 8u43ir2mlgu3tvvd379g4h81n7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.8882 8u43ir2mlgu3tvvd379g4h81n7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241007@171224.8902 8u43ir2mlgu3tvvd379g4h81n7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.8918 8u43ir2mlgu3tvvd379g4h81n7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241007@171224.8954 8u43ir2mlgu3tvvd379g4h81n7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.8971 8u43ir2mlgu3tvvd379g4h81n7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241007@171224.8987 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241007@171224.9055 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241007@171224.9070 8u43ir2mlgu3tvvd379g4h81n7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.9089 8u43ir2mlgu3tvvd379g4h81n7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241007@171224.9108 8u43ir2mlgu3tvvd379g4h81n7 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670409253967040868db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241007@171224.9259 8u43ir2mlgu3tvvd379g4h81n7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241007@171224.9281 8u43ir2mlgu3tvvd379g4h81n7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241007@171224.9318 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241007@171224.9331 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241007@171224.9345 8u43ir2mlgu3tvvd379g4h81n7 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
