20241106@190448.1938 q00qisi3k9re3k2458b4ooud2e Query : select top 1 fno valor from wsftdata order by fno desc
20241106@190448.1961 q00qisi3k9re3k2458b4ooud2e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.1977 q00qisi3k9re3k2458b4ooud2e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190448.2004 q00qisi3k9re3k2458b4ooud2e Query : select 'normal' from dummy
20241106@190448.2019 q00qisi3k9re3k2458b4ooud2e Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut672bb58595672bbdd000',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1712,101621,0,'2024-11-06',39,'euro',0,0,2024 ,?,?)
20241106@190448.2330 q00qisi3k9re3k2458b4ooud2e Query : use flama_phc
20241106@190448.2358 q00qisi3k9re3k2458b4ooud2e Query : select st.usalote valor from st where st.ref = '324.5501.00.1'
20241106@190448.2379 q00qisi3k9re3k2458b4ooud2e 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.5501.00.1'
20241106@190448.2393 q00qisi3k9re3k2458b4ooud2e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.2409 q00qisi3k9re3k2458b4ooud2e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190448.2432 q00qisi3k9re3k2458b4ooud2e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.2478 q00qisi3k9re3k2458b4ooud2e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190448.2488 q00qisi3k9re3k2458b4ooud2e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190448.2500 q00qisi3k9re3k2458b4ooud2e Query : select sestamp valor from se where ref ='324.5501.00.1' and lote = 'r2300908100a'
20241106@190448.2525 q00qisi3k9re3k2458b4ooud2e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.2541 q00qisi3k9re3k2458b4ooud2e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190448.2553 q00qisi3k9re3k2458b4ooud2e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb11492672bbdd03d','aut672bb58595672bbdd000' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190448.2557 q00qisi3k9re3k2458b4ooud2e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.2602 q00qisi3k9re3k2458b4ooud2e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190448.2636 q00qisi3k9re3k2458b4ooud2e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672bb11492672bbdd03d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut672bb58595672bbdd000' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241106@190448.2912 q00qisi3k9re3k2458b4ooud2e Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut672bb58595672bbdd000','2407316','wait',39,'adm09112754980.682000002')
20241106@190448.2992 q00qisi3k9re3k2458b4ooud2e Query : use flama_phc
20241106@190448.2996 q00qisi3k9re3k2458b4ooud2e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241106@190448.3027 q00qisi3k9re3k2458b4ooud2e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3142';
20241106@190448.3063 q00qisi3k9re3k2458b4ooud2e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3142';
20241106@190448.3105 q00qisi3k9re3k2458b4ooud2e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3142';
20241106@190448.3132 q00qisi3k9re3k2458b4ooud2e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3142';
20241106@190448.3657 eimcl5ru80h40pat0k0daqm36a Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241106@190448.3668 eimcl5ru80h40pat0k0daqm36a Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241106@190448.3764 eimcl5ru80h40pat0k0daqm36a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3143';
20241106@190448.3825 eimcl5ru80h40pat0k0daqm36a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3143';
20241106@190448.3880 eimcl5ru80h40pat0k0daqm36a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3143';
20241106@190448.3917 eimcl5ru80h40pat0k0daqm36a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3143';
20241106@190448.3970 eimcl5ru80h40pat0k0daqm36a Query : use flama_phc
20241106@190448.3973 eimcl5ru80h40pat0k0daqm36a Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241106@190448.4035 eimcl5ru80h40pat0k0daqm36a Query : use flama_phc
20241106@190448.4038 eimcl5ru80h40pat0k0daqm36a Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241106@190448.4085 eimcl5ru80h40pat0k0daqm36a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2366.00.1'
20241106@190448.4419 eimcl5ru80h40pat0k0daqm36a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407317 and bi.ref ='324.2366.00.1' and bi.lordem =1
20241106@190448.4759 eimcl5ru80h40pat0k0daqm36a Query : use flama_phc
20241106@190448.4762 eimcl5ru80h40pat0k0daqm36a Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241106@190448.4794 eimcl5ru80h40pat0k0daqm36a Query : use flama_phc
20241106@190448.4797 eimcl5ru80h40pat0k0daqm36a Query : select top 1 1 valor from td where td.ndoc = 39
20241106@190448.4825 eimcl5ru80h40pat0k0daqm36a Query : use flama_phc
20241106@190448.4831 eimcl5ru80h40pat0k0daqm36a 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')
20241106@190448.4859 eimcl5ru80h40pat0k0daqm36a 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
20241106@190448.4894 eimcl5ru80h40pat0k0daqm36a Query : use flama_phc
20241106@190448.4897 eimcl5ru80h40pat0k0daqm36a Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241106@190448.4926 eimcl5ru80h40pat0k0daqm36a Query : use flama_phc
20241106@190448.4929 eimcl5ru80h40pat0k0daqm36a Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241106@190448.4959 eimcl5ru80h40pat0k0daqm36a Query : use flama_phc
20241106@190448.4962 eimcl5ru80h40pat0k0daqm36a Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241106@190448.5013 eimcl5ru80h40pat0k0daqm36a Query : use flama_phc
20241106@190448.5016 eimcl5ru80h40pat0k0daqm36a Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241106@190448.5059 eimcl5ru80h40pat0k0daqm36a Query : use flama_phc
20241106@190448.5062 eimcl5ru80h40pat0k0daqm36a Query : select 1 valor from td where ndoc = 39
20241106@190448.5073 eimcl5ru80h40pat0k0daqm36a Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241106@190448.5087 eimcl5ru80h40pat0k0daqm36a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.5108 eimcl5ru80h40pat0k0daqm36a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190448.5128 eimcl5ru80h40pat0k0daqm36a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.5145 eimcl5ru80h40pat0k0daqm36a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190448.5180 eimcl5ru80h40pat0k0daqm36a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.5195 eimcl5ru80h40pat0k0daqm36a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190448.5207 eimcl5ru80h40pat0k0daqm36a Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190448.5267 eimcl5ru80h40pat0k0daqm36a Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190448.5280 eimcl5ru80h40pat0k0daqm36a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.5299 eimcl5ru80h40pat0k0daqm36a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190448.5314 eimcl5ru80h40pat0k0daqm36a Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut672bb89533672bbdd07f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241106@190448.5501 eimcl5ru80h40pat0k0daqm36a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.5517 eimcl5ru80h40pat0k0daqm36a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190448.5558 eimcl5ru80h40pat0k0daqm36a Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241106@190448.5570 eimcl5ru80h40pat0k0daqm36a Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241106@190448.5582 eimcl5ru80h40pat0k0daqm36a Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241106@190448.5594 eimcl5ru80h40pat0k0daqm36a Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241106@190448.5606 eimcl5ru80h40pat0k0daqm36a Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241106@190448.5618 eimcl5ru80h40pat0k0daqm36a Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241106@190448.5629 eimcl5ru80h40pat0k0daqm36a Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut672bb89533672bbdd07f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241106@190448.5893 eimcl5ru80h40pat0k0daqm36a Query : select top 1 fno valor from wsftdata order by fno desc
20241106@190448.5916 eimcl5ru80h40pat0k0daqm36a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.5935 eimcl5ru80h40pat0k0daqm36a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190448.5955 eimcl5ru80h40pat0k0daqm36a Query : select 'normal' from dummy
20241106@190448.5970 eimcl5ru80h40pat0k0daqm36a Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut672bb89533672bbdd07f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1713,100810,0,'2024-11-06',39,'euro',0,0,2024 ,?,?)
20241106@190448.6280 eimcl5ru80h40pat0k0daqm36a Query : use flama_phc
20241106@190448.6283 eimcl5ru80h40pat0k0daqm36a Query : select st.usalote valor from st where st.ref = '324.2366.00.1'
20241106@190448.6305 eimcl5ru80h40pat0k0daqm36a 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.2366.00.1'
20241106@190448.6456 eimcl5ru80h40pat0k0daqm36a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.6471 eimcl5ru80h40pat0k0daqm36a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190448.6499 eimcl5ru80h40pat0k0daqm36a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.6520 eimcl5ru80h40pat0k0daqm36a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190448.6529 eimcl5ru80h40pat0k0daqm36a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190448.6541 eimcl5ru80h40pat0k0daqm36a Query : select sestamp valor from se where ref ='324.2366.00.1' and lote = 'r2400498100a'
20241106@190448.6554 eimcl5ru80h40pat0k0daqm36a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.6568 eimcl5ru80h40pat0k0daqm36a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190448.6581 eimcl5ru80h40pat0k0daqm36a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb65272672bbdd0a0','aut672bb89533672bbdd07f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190448.6585 eimcl5ru80h40pat0k0daqm36a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.6599 eimcl5ru80h40pat0k0daqm36a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190448.6631 eimcl5ru80h40pat0k0daqm36a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672bb65272672bbdd0a0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut672bb89533672bbdd07f' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241106@190448.6931 eimcl5ru80h40pat0k0daqm36a Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut672bb89533672bbdd07f','2407317','wait',39,'adm09112754980.682000002')
20241106@190448.6997 eimcl5ru80h40pat0k0daqm36a Query : use flama_phc
20241106@190448.7000 eimcl5ru80h40pat0k0daqm36a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241106@190448.7029 eimcl5ru80h40pat0k0daqm36a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3143';
20241106@190448.7062 eimcl5ru80h40pat0k0daqm36a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3143';
20241106@190448.7107 eimcl5ru80h40pat0k0daqm36a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3143';
20241106@190448.7140 eimcl5ru80h40pat0k0daqm36a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3143';
20241106@190448.7634 6tm1svapguhrtmugo4a9d30p9r Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241106@190448.7645 6tm1svapguhrtmugo4a9d30p9r Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241106@190448.7713 6tm1svapguhrtmugo4a9d30p9r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3144';
20241106@190448.7772 6tm1svapguhrtmugo4a9d30p9r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3144';
20241106@190448.7845 6tm1svapguhrtmugo4a9d30p9r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3144';
20241106@190448.7873 6tm1svapguhrtmugo4a9d30p9r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3144';
20241106@190448.7929 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190448.7932 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241106@190448.7997 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190448.8017 6tm1svapguhrtmugo4a9d30p9r Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241106@190448.8060 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5365.00.1'
20241106@190448.8227 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407323 and bi.ref ='324.5365.00.1' and bi.lordem =1
20241106@190448.8581 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5365.00.1'
20241106@190448.8602 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407323 and bi.ref ='324.5365.00.1' and bi.lordem =1
20241106@190448.8620 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190448.8623 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241106@190448.8659 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190448.8662 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 1 valor from td where td.ndoc = 39
20241106@190448.8691 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190448.8694 6tm1svapguhrtmugo4a9d30p9r 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')
20241106@190448.8721 6tm1svapguhrtmugo4a9d30p9r 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
20241106@190448.8770 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190448.8773 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241106@190448.8803 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190448.8806 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241106@190448.8837 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190448.8840 6tm1svapguhrtmugo4a9d30p9r Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241106@190448.8878 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190448.8881 6tm1svapguhrtmugo4a9d30p9r Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241106@190448.8924 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190448.8927 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from td where ndoc = 39
20241106@190448.8954 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241106@190448.8977 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.8994 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190448.9013 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.9032 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190448.9059 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.9073 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190448.9085 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190448.9144 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190448.9159 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.9173 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190448.9204 6tm1svapguhrtmugo4a9d30p9r Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut672bb64194672bbdd0dd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241106@190448.9392 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.9421 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190448.9460 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241106@190448.9472 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241106@190448.9484 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241106@190448.9496 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241106@190448.9507 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241106@190448.9519 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241106@190448.9530 6tm1svapguhrtmugo4a9d30p9r Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut672bb64194672bbdd0dd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241106@190448.9823 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 fno valor from wsftdata order by fno desc
20241106@190448.9848 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190448.9864 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190448.9886 6tm1svapguhrtmugo4a9d30p9r Query : select 'normal' from dummy
20241106@190448.9906 6tm1svapguhrtmugo4a9d30p9r Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut672bb64194672bbdd0dd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1714,100810,0,'2024-11-06',39,'euro',0,0,2024 ,?,?)
20241106@190449.3010 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190449.3050 6tm1svapguhrtmugo4a9d30p9r Query : select st.usalote valor from st where st.ref = '324.5365.00.1'
20241106@190449.3270 6tm1svapguhrtmugo4a9d30p9r 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.5365.00.1'
20241106@190449.4920 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.5080 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190449.5530 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.5680 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190449.5800 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190449.6040 6tm1svapguhrtmugo4a9d30p9r Query : select sestamp valor from se where ref ='324.5365.00.1' and lote = 'r2300840100a'
20241106@190449.6430 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.6580 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190449.6750 6tm1svapguhrtmugo4a9d30p9r Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb61808672bbdd10f','aut672bb64194672bbdd0dd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190449.6790 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.6940 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190449.7350 6tm1svapguhrtmugo4a9d30p9r Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672bb61808672bbdd10f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',54.000 ,'aut672bb64194672bbdd0dd' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241106@190449.1028 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.1045 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190449.1081 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.1097 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190449.1106 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190449.1127 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.1142 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190449.1154 6tm1svapguhrtmugo4a9d30p9r Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb86761672bbdd11b','aut672bb64194672bbdd0dd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190449.1158 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.1186 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190449.1215 6tm1svapguhrtmugo4a9d30p9r Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut672bb86761672bbdd11b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut672bb64194672bbdd0dd' ,0,0 ,2,23.00,20000,?,?,?)
20241106@190449.1567 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190449.1582 6tm1svapguhrtmugo4a9d30p9r Query : select st.usalote valor from st where st.ref = '324.5365.00.1'
20241106@190449.1603 6tm1svapguhrtmugo4a9d30p9r 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.5365.00.1'
20241106@190449.1616 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.1633 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190449.1657 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.1676 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190449.1684 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190449.1695 6tm1svapguhrtmugo4a9d30p9r Query : select sestamp valor from se where ref ='324.5365.00.1' and lote = 'r2300840100a'
20241106@190449.1707 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.1728 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190449.1742 6tm1svapguhrtmugo4a9d30p9r Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb04977672bbdd129','aut672bb64194672bbdd0dd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190449.1747 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.1760 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190449.1787 6tm1svapguhrtmugo4a9d30p9r Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672bb04977672bbdd129',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',144.000 ,'aut672bb64194672bbdd0dd' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241106@190449.2123 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.2139 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190449.2164 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.2179 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190449.2188 6tm1svapguhrtmugo4a9d30p9r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190449.2201 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.2215 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190449.2251 6tm1svapguhrtmugo4a9d30p9r Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb86149672bbdd135','aut672bb64194672bbdd0dd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190449.2255 6tm1svapguhrtmugo4a9d30p9r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.2269 6tm1svapguhrtmugo4a9d30p9r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190449.2305 6tm1svapguhrtmugo4a9d30p9r Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut672bb86149672bbdd135',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut672bb64194672bbdd0dd' ,0,0 ,2,23.00,50000,?,?,?)
20241106@190449.2584 6tm1svapguhrtmugo4a9d30p9r Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut672bb64194672bbdd0dd','2407323','wait',39,'adm09112754980.682000002')
20241106@190449.2658 6tm1svapguhrtmugo4a9d30p9r Query : use flama_phc
20241106@190449.2661 6tm1svapguhrtmugo4a9d30p9r Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241106@190449.2690 6tm1svapguhrtmugo4a9d30p9r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3144';
20241106@190449.2724 6tm1svapguhrtmugo4a9d30p9r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3144';
20241106@190449.2771 6tm1svapguhrtmugo4a9d30p9r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3144';
20241106@190449.2799 6tm1svapguhrtmugo4a9d30p9r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3144';
20241106@190449.3321 4sdc3lm2ai2rboqte0hrtsfskb Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241106@190449.3332 4sdc3lm2ai2rboqte0hrtsfskb Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241106@190449.3390 4sdc3lm2ai2rboqte0hrtsfskb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3145';
20241106@190449.3483 4sdc3lm2ai2rboqte0hrtsfskb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3145';
20241106@190449.3540 4sdc3lm2ai2rboqte0hrtsfskb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3145';
20241106@190449.3568 4sdc3lm2ai2rboqte0hrtsfskb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3145';
20241106@190449.3635 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.3638 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241106@190449.3699 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.3702 4sdc3lm2ai2rboqte0hrtsfskb Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241106@190449.3745 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5500.00.1'
20241106@190449.3908 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407324 and bi.ref ='324.5500.00.1' and bi.lordem =1
20241106@190449.4232 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5500.00.1'
20241106@190449.4254 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407324 and bi.ref ='324.5500.00.1' and bi.lordem =1
20241106@190449.4270 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.4273 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241106@190449.4315 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.4319 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 1 valor from td where td.ndoc = 39
20241106@190449.4361 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.4364 4sdc3lm2ai2rboqte0hrtsfskb 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')
20241106@190449.4393 4sdc3lm2ai2rboqte0hrtsfskb 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
20241106@190449.4986 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.5229 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241106@190449.5775 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.5778 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241106@190449.5808 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.5811 4sdc3lm2ai2rboqte0hrtsfskb Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241106@190449.5849 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.5853 4sdc3lm2ai2rboqte0hrtsfskb Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241106@190449.5896 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.5899 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from td where ndoc = 39
20241106@190449.5911 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241106@190449.5924 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.5956 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190449.5975 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.5991 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190449.6021 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.6036 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190449.6048 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190449.6108 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190449.6121 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.6155 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190449.6170 4sdc3lm2ai2rboqte0hrtsfskb Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut672bb89426672bbdd193' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241106@190449.6397 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.6414 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190449.6446 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241106@190449.6458 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241106@190449.6471 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241106@190449.6482 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241106@190449.6496 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241106@190449.6508 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241106@190449.6538 4sdc3lm2ai2rboqte0hrtsfskb Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut672bb89426672bbdd193',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241106@190449.6793 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 fno valor from wsftdata order by fno desc
20241106@190449.6817 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.6834 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190449.6855 4sdc3lm2ai2rboqte0hrtsfskb Query : select 'normal' from dummy
20241106@190449.6869 4sdc3lm2ai2rboqte0hrtsfskb Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut672bb89426672bbdd193',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1715,100810,0,'2024-11-06',39,'euro',0,0,2024 ,?,?)
20241106@190449.7165 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.7168 4sdc3lm2ai2rboqte0hrtsfskb Query : select st.usalote valor from st where st.ref = '324.5500.00.1'
20241106@190449.7210 4sdc3lm2ai2rboqte0hrtsfskb 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.5500.00.1'
20241106@190449.7351 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.7367 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190449.7393 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.7407 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190449.7416 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190449.7428 4sdc3lm2ai2rboqte0hrtsfskb Query : select sestamp valor from se where ref ='324.5500.00.1' and lote = 'r2400095600a'
20241106@190449.7443 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.7459 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190449.7472 4sdc3lm2ai2rboqte0hrtsfskb Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb87509672bbdd1b5','aut672bb89426672bbdd193' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190449.7476 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.7491 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190449.7521 4sdc3lm2ai2rboqte0hrtsfskb Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672bb87509672bbdd1b5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut672bb89426672bbdd193' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241106@190449.7810 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.7814 4sdc3lm2ai2rboqte0hrtsfskb Query : select st.usalote valor from st where st.ref = '324.5500.00.1'
20241106@190449.7836 4sdc3lm2ai2rboqte0hrtsfskb 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.5500.00.1'
20241106@190449.7853 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.7873 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190449.7903 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.7922 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190449.7932 4sdc3lm2ai2rboqte0hrtsfskb Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190449.7946 4sdc3lm2ai2rboqte0hrtsfskb Query : select sestamp valor from se where ref ='324.5500.00.1' and lote = 'r2400095600a'
20241106@190449.7958 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.7973 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190449.7988 4sdc3lm2ai2rboqte0hrtsfskb Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb25345672bbdd1c2','aut672bb89426672bbdd193' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190449.7993 4sdc3lm2ai2rboqte0hrtsfskb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190449.8007 4sdc3lm2ai2rboqte0hrtsfskb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190449.8037 4sdc3lm2ai2rboqte0hrtsfskb Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672bb25345672bbdd1c2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',28.000 ,'aut672bb89426672bbdd193' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241106@190449.8326 4sdc3lm2ai2rboqte0hrtsfskb Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut672bb89426672bbdd193','2407324','wait',39,'adm09112754980.682000002')
20241106@190449.8412 4sdc3lm2ai2rboqte0hrtsfskb Query : use flama_phc
20241106@190449.8415 4sdc3lm2ai2rboqte0hrtsfskb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241106@190449.8453 4sdc3lm2ai2rboqte0hrtsfskb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3145';
20241106@190449.8486 4sdc3lm2ai2rboqte0hrtsfskb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3145';
20241106@190449.8529 4sdc3lm2ai2rboqte0hrtsfskb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3145';
20241106@190449.8557 4sdc3lm2ai2rboqte0hrtsfskb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3145';
20241106@190449.9050 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241106@190449.9063 qnq6h20ba6kd4td8fqt5eqj9nf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241106@190449.9124 qnq6h20ba6kd4td8fqt5eqj9nf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3146';
20241106@190449.9181 qnq6h20ba6kd4td8fqt5eqj9nf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3146';
20241106@190449.9236 qnq6h20ba6kd4td8fqt5eqj9nf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3146';
20241106@190449.9286 qnq6h20ba6kd4td8fqt5eqj9nf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3146';
20241106@190449.9339 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190449.9342 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241106@190449.9404 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190449.9407 qnq6h20ba6kd4td8fqt5eqj9nf Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241106@190449.9469 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20241106@190449.9671 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407325 and bi.ref ='324.5342.00.1' and bi.lordem =1
20241106@190450.6000 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20241106@190450.4900 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407325 and bi.ref ='324.5342.00.1' and bi.lordem =1
20241106@190450.6800 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190450.7800 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241106@190450.1140 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190450.1180 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 1 valor from td where td.ndoc = 39
20241106@190450.1510 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190450.1540 qnq6h20ba6kd4td8fqt5eqj9nf 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')
20241106@190450.1820 qnq6h20ba6kd4td8fqt5eqj9nf 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
20241106@190450.4110 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190450.4150 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241106@190450.4480 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190450.4520 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241106@190450.5130 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190450.5170 qnq6h20ba6kd4td8fqt5eqj9nf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241106@190450.5570 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190450.5600 qnq6h20ba6kd4td8fqt5eqj9nf Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241106@190450.6300 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190450.6330 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from td where ndoc = 39
20241106@190450.6460 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241106@190450.6600 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.6780 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190450.7020 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.7190 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190450.7480 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.7630 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190450.7760 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190450.8690 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190450.8840 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.9030 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190450.9240 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut672bb27908672bbdd212' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241106@190450.1147 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.1192 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190450.1235 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241106@190450.1250 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241106@190450.1263 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241106@190450.1277 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241106@190450.1291 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241106@190450.1304 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241106@190450.1316 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut672bb27908672bbdd212',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241106@190450.1606 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 fno valor from wsftdata order by fno desc
20241106@190450.1641 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.1661 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190450.1691 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 'normal' from dummy
20241106@190450.1707 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut672bb27908672bbdd212',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1716,100810,0,'2024-11-06',39,'euro',0,0,2024 ,?,?)
20241106@190450.2041 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190450.2044 qnq6h20ba6kd4td8fqt5eqj9nf Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20241106@190450.2103 qnq6h20ba6kd4td8fqt5eqj9nf 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.5342.00.1'
20241106@190450.2253 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.2269 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190450.2296 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.2310 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190450.2319 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190450.2331 qnq6h20ba6kd4td8fqt5eqj9nf Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2300915100a'
20241106@190450.2350 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.2365 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190450.2377 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb89695672bbdd239','aut672bb27908672bbdd212' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190450.2381 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.2395 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190450.2423 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672bb89695672bbdd239',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',54.000 ,'aut672bb27908672bbdd212' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241106@190450.2766 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.2787 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190450.2818 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.2836 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190450.2850 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190450.2864 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.2883 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190450.2907 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb63285672bbdd245','aut672bb27908672bbdd212' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190450.2911 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.2925 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190450.2963 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut672bb63285672bbdd245',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut672bb27908672bbdd212' ,0,0 ,2,23.00,20000,?,?,?)
20241106@190450.3276 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190450.3279 qnq6h20ba6kd4td8fqt5eqj9nf Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20241106@190450.3301 qnq6h20ba6kd4td8fqt5eqj9nf 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.5342.00.1'
20241106@190450.3315 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.3331 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190450.3380 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.3398 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190450.3407 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190450.3423 qnq6h20ba6kd4td8fqt5eqj9nf Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2300915100a'
20241106@190450.3438 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.3454 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190450.3466 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb85554672bbdd253','aut672bb27908672bbdd212' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190450.3471 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.3487 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190450.3520 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672bb85554672bbdd253',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',144.000 ,'aut672bb27908672bbdd212' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241106@190450.3876 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.3896 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190450.3927 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.3945 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190450.3955 qnq6h20ba6kd4td8fqt5eqj9nf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190450.3970 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.3992 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190450.4005 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb60269672bbdd260','aut672bb27908672bbdd212' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190450.4011 qnq6h20ba6kd4td8fqt5eqj9nf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.4026 qnq6h20ba6kd4td8fqt5eqj9nf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190450.4060 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut672bb60269672bbdd260',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut672bb27908672bbdd212' ,0,0 ,2,23.00,50000,?,?,?)
20241106@190450.4574 qnq6h20ba6kd4td8fqt5eqj9nf Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut672bb27908672bbdd212','2407325','wait',39,'adm09112754980.682000002')
20241106@190450.4647 qnq6h20ba6kd4td8fqt5eqj9nf Query : use flama_phc
20241106@190450.4651 qnq6h20ba6kd4td8fqt5eqj9nf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241106@190450.4788 qnq6h20ba6kd4td8fqt5eqj9nf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3146';
20241106@190450.4868 qnq6h20ba6kd4td8fqt5eqj9nf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3146';
20241106@190450.4943 qnq6h20ba6kd4td8fqt5eqj9nf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3146';
20241106@190450.4973 qnq6h20ba6kd4td8fqt5eqj9nf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3146';
20241106@190450.5517 reqkfu1ccpvobmqlk8omjfhl1p Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241106@190450.5527 reqkfu1ccpvobmqlk8omjfhl1p Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241106@190450.5594 reqkfu1ccpvobmqlk8omjfhl1p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3147';
20241106@190450.5662 reqkfu1ccpvobmqlk8omjfhl1p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3147';
20241106@190450.5721 reqkfu1ccpvobmqlk8omjfhl1p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3147';
20241106@190450.5751 reqkfu1ccpvobmqlk8omjfhl1p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3147';
20241106@190450.5827 reqkfu1ccpvobmqlk8omjfhl1p Query : use flama_phc
20241106@190450.5831 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241106@190450.5893 reqkfu1ccpvobmqlk8omjfhl1p Query : use flama_phc
20241106@190450.5896 reqkfu1ccpvobmqlk8omjfhl1p Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241106@190450.5950 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9005.00.1'
20241106@190450.6130 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407326 and bi.ref ='328.9005.00.1' and bi.lordem =1
20241106@190450.6455 reqkfu1ccpvobmqlk8omjfhl1p Query : use flama_phc
20241106@190450.6459 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241106@190450.6520 reqkfu1ccpvobmqlk8omjfhl1p Query : use flama_phc
20241106@190450.6523 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 1 valor from td where td.ndoc = 39
20241106@190450.6563 reqkfu1ccpvobmqlk8omjfhl1p Query : use flama_phc
20241106@190450.6566 reqkfu1ccpvobmqlk8omjfhl1p 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')
20241106@190450.6595 reqkfu1ccpvobmqlk8omjfhl1p 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
20241106@190450.6630 reqkfu1ccpvobmqlk8omjfhl1p Query : use flama_phc
20241106@190450.6633 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241106@190450.6671 reqkfu1ccpvobmqlk8omjfhl1p Query : use flama_phc
20241106@190450.6674 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241106@190450.6704 reqkfu1ccpvobmqlk8omjfhl1p Query : use flama_phc
20241106@190450.6706 reqkfu1ccpvobmqlk8omjfhl1p Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241106@190450.6747 reqkfu1ccpvobmqlk8omjfhl1p Query : use flama_phc
20241106@190450.6750 reqkfu1ccpvobmqlk8omjfhl1p Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241106@190450.6794 reqkfu1ccpvobmqlk8omjfhl1p Query : use flama_phc
20241106@190450.6796 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from td where ndoc = 39
20241106@190450.6808 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241106@190450.6823 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.6840 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190450.6859 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.6873 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190450.6921 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.6936 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190450.6949 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190450.7013 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190450.7026 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.7041 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190450.7057 reqkfu1ccpvobmqlk8omjfhl1p Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut672bb09110672bbdd2a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241106@190450.7258 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.7304 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190450.7344 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241106@190450.7356 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241106@190450.7368 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241106@190450.7380 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241106@190450.7392 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241106@190450.7403 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241106@190450.7414 reqkfu1ccpvobmqlk8omjfhl1p Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut672bb09110672bbdd2a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241106@190450.7699 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 fno valor from wsftdata order by fno desc
20241106@190450.7726 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.7743 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190450.7764 reqkfu1ccpvobmqlk8omjfhl1p Query : select 'normal' from dummy
20241106@190450.7779 reqkfu1ccpvobmqlk8omjfhl1p Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut672bb09110672bbdd2a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1717,102943,0,'2024-11-06',39,'euro',0,0,2024 ,?,?)
20241106@190450.8118 reqkfu1ccpvobmqlk8omjfhl1p Query : use flama_phc
20241106@190450.8122 reqkfu1ccpvobmqlk8omjfhl1p Query : select st.usalote valor from st where st.ref = '328.9005.00.1'
20241106@190450.8145 reqkfu1ccpvobmqlk8omjfhl1p 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 = '328.9005.00.1'
20241106@190450.8385 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.8569 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190450.8597 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.8614 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190450.8622 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190450.8636 reqkfu1ccpvobmqlk8omjfhl1p Query : select sestamp valor from se where ref ='328.9005.00.1' and lote = 'r2400092600a'
20241106@190450.8651 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.8666 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190450.8678 reqkfu1ccpvobmqlk8omjfhl1p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb14192672bbdd2d3','aut672bb09110672bbdd2a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190450.8683 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.8698 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190450.8726 reqkfu1ccpvobmqlk8omjfhl1p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672bb14192672bbdd2d3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut672bb09110672bbdd2a9' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241106@190450.9024 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.9042 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190450.9098 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.9114 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190450.9122 reqkfu1ccpvobmqlk8omjfhl1p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190450.9134 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.9148 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190450.9159 reqkfu1ccpvobmqlk8omjfhl1p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb31447672bbdd2df','aut672bb09110672bbdd2a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190450.9164 reqkfu1ccpvobmqlk8omjfhl1p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190450.9178 reqkfu1ccpvobmqlk8omjfhl1p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190450.9206 reqkfu1ccpvobmqlk8omjfhl1p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut672bb31447672bbdd2df',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut672bb09110672bbdd2a9' ,0,0 ,2,23.00,20000,?,?,?)
20241106@190450.9510 reqkfu1ccpvobmqlk8omjfhl1p Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut672bb09110672bbdd2a9','2407326','wait',39,'adm09112754980.682000002')
20241106@190450.9579 reqkfu1ccpvobmqlk8omjfhl1p Query : use flama_phc
20241106@190450.9582 reqkfu1ccpvobmqlk8omjfhl1p Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241106@190450.9612 reqkfu1ccpvobmqlk8omjfhl1p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3147';
20241106@190450.9682 reqkfu1ccpvobmqlk8omjfhl1p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3147';
20241106@190450.9730 reqkfu1ccpvobmqlk8omjfhl1p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3147';
20241106@190450.9768 reqkfu1ccpvobmqlk8omjfhl1p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3147';
20241106@190451.1500 oee5adjenuii1mjpei7ijhsljr Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241106@190451.1511 oee5adjenuii1mjpei7ijhsljr Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241106@190451.1577 oee5adjenuii1mjpei7ijhsljr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3148';
20241106@190451.1646 oee5adjenuii1mjpei7ijhsljr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3148';
20241106@190451.1705 oee5adjenuii1mjpei7ijhsljr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3148';
20241106@190451.1737 oee5adjenuii1mjpei7ijhsljr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3148';
20241106@190451.1816 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.1819 oee5adjenuii1mjpei7ijhsljr Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241106@190451.1895 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.1899 oee5adjenuii1mjpei7ijhsljr Query : select no, estab,szadrsdesc from szadrs where u_coddest=435
20241106@190451.1996 oee5adjenuii1mjpei7ijhsljr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.367.09.00'
20241106@190451.2203 oee5adjenuii1mjpei7ijhsljr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407327 and bi.ref ='323.367.09.00' and bi.lordem =1
20241106@190451.2539 oee5adjenuii1mjpei7ijhsljr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.367.09.00'
20241106@190451.2560 oee5adjenuii1mjpei7ijhsljr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407327 and bi.ref ='323.367.09.00' and bi.lordem =1
20241106@190451.2583 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.2587 oee5adjenuii1mjpei7ijhsljr Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241106@190451.2657 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.2662 oee5adjenuii1mjpei7ijhsljr Query : select top 1 1 valor from td where td.ndoc = 39
20241106@190451.2694 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.2698 oee5adjenuii1mjpei7ijhsljr 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')
20241106@190451.2727 oee5adjenuii1mjpei7ijhsljr 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
20241106@190451.2765 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.2769 oee5adjenuii1mjpei7ijhsljr Query : select top 1 ~inactivo valor from cl where no = '101646' and estab = 0 order by inactivo desc
20241106@190451.2916 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.2919 oee5adjenuii1mjpei7ijhsljr Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241106@190451.2949 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.2952 oee5adjenuii1mjpei7ijhsljr Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241106@190451.2994 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.2997 oee5adjenuii1mjpei7ijhsljr Query : select szadrsstamp valor from szadrs where szadrsdesc='normendes-equipamento domesticos,lda'
20241106@190451.3075 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.3078 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from td where ndoc = 39
20241106@190451.3090 oee5adjenuii1mjpei7ijhsljr Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241106@190451.3233 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.3346 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190451.3364 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.3378 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190451.3411 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.3426 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190451.3439 oee5adjenuii1mjpei7ijhsljr Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190451.3504 oee5adjenuii1mjpei7ijhsljr Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190451.3516 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.3531 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190451.3839 oee5adjenuii1mjpei7ijhsljr Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut672bb48176672bbdd353' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241106@190451.4054 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.4075 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190451.4111 oee5adjenuii1mjpei7ijhsljr Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241106@190451.4124 oee5adjenuii1mjpei7ijhsljr Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241106@190451.4137 oee5adjenuii1mjpei7ijhsljr Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241106@190451.4150 oee5adjenuii1mjpei7ijhsljr Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241106@190451.4162 oee5adjenuii1mjpei7ijhsljr Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241106@190451.4209 oee5adjenuii1mjpei7ijhsljr Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241106@190451.4223 oee5adjenuii1mjpei7ijhsljr Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut672bb48176672bbdd353',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241106@190451.4539 oee5adjenuii1mjpei7ijhsljr Query : select top 1 fno valor from wsftdata order by fno desc
20241106@190451.4571 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.4591 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190451.4618 oee5adjenuii1mjpei7ijhsljr Query : select 'normal' from dummy
20241106@190451.4637 oee5adjenuii1mjpei7ijhsljr Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut672bb48176672bbdd353',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1718,101646,0,'2024-11-06',39,'euro',0,0,2024 ,?,?)
20241106@190451.5184 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.5208 oee5adjenuii1mjpei7ijhsljr Query : select st.usalote valor from st where st.ref = '323.367.09.00'
20241106@190451.5240 oee5adjenuii1mjpei7ijhsljr 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 = '323.367.09.00'
20241106@190451.5414 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.5431 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190451.5459 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.5475 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190451.5487 oee5adjenuii1mjpei7ijhsljr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190451.5501 oee5adjenuii1mjpei7ijhsljr Query : select sestamp valor from se where ref ='323.367.09.00' and lote = 'r2400053200a'
20241106@190451.5516 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.5533 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190451.5578 oee5adjenuii1mjpei7ijhsljr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb09029672bbdd386','aut672bb48176672bbdd353' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190451.5583 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.5603 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190451.5643 oee5adjenuii1mjpei7ijhsljr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672bb09029672bbdd386',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut672bb48176672bbdd353' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241106@190451.5975 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.5979 oee5adjenuii1mjpei7ijhsljr Query : select st.usalote valor from st where st.ref = '323.367.09.00'
20241106@190451.6035 oee5adjenuii1mjpei7ijhsljr 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 = '323.367.09.00'
20241106@190451.6052 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.6075 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190451.6104 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.6123 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190451.6133 oee5adjenuii1mjpei7ijhsljr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241106@190451.6147 oee5adjenuii1mjpei7ijhsljr Query : select sestamp valor from se where ref ='323.367.09.00' and lote = 'r2400053200a'
20241106@190451.6161 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.6177 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241106@190451.6190 oee5adjenuii1mjpei7ijhsljr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672bb88160672bbdd396','aut672bb48176672bbdd353' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241106@190451.6194 oee5adjenuii1mjpei7ijhsljr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190451.6209 oee5adjenuii1mjpei7ijhsljr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241106@190451.6237 oee5adjenuii1mjpei7ijhsljr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672bb88160672bbdd396',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut672bb48176672bbdd353' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241106@190451.6557 oee5adjenuii1mjpei7ijhsljr Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut672bb48176672bbdd353','2407327','wait',39,'adm09112754980.682000002')
20241106@190451.6638 oee5adjenuii1mjpei7ijhsljr Query : use flama_phc
20241106@190451.6641 oee5adjenuii1mjpei7ijhsljr Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241106@190451.6671 oee5adjenuii1mjpei7ijhsljr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3148';
20241106@190451.6714 oee5adjenuii1mjpei7ijhsljr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3148';
20241106@190451.6773 oee5adjenuii1mjpei7ijhsljr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3148';
20241106@190451.6802 oee5adjenuii1mjpei7ijhsljr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3148';
20241106@190451.7420 vjgd70tp3ti4l943e548i4lk6o Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241106@190451.7432 vjgd70tp3ti4l943e548i4lk6o Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241106@190451.7501 vjgd70tp3ti4l943e548i4lk6o Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3149';
20241106@190451.7580 vjgd70tp3ti4l943e548i4lk6o Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3149';
20241106@190451.7641 vjgd70tp3ti4l943e548i4lk6o Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3149';
20241106@190451.7672 vjgd70tp3ti4l943e548i4lk6o Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3149';
20241106@190451.7728 vjgd70tp3ti4l943e548i4lk6o Query : use flama_phc
20241106@190451.7731 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241106@190451.7797 vjgd70tp3ti4l943e548i4lk6o Query : use flama_phc
20241106@190451.7800 vjgd70tp3ti4l943e548i4lk6o Query : select no, estab,szadrsdesc from szadrs where u_coddest=1100
20241106@190451.7903 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20241106@190451.8109 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.727.00.01' and bi.lordem =1
20241106@190451.8462 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1646.00.1'
20241106@190451.8647 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.1646.00.1' and bi.lordem =2
20241106@190451.8991 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1608.00.1'
20241106@190451.9191 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.1608.00.1' and bi.lordem =4
20241106@190451.9549 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1317.00.1'
20241106@190451.9759 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.1317.00.1' and bi.lordem =5
20241106@190452.3340 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1321.00.1'
20241106@190452.5310 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.1321.00.1' and bi.lordem =6
20241106@190452.8810 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1329.00.1'
20241106@190452.1098 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.1329.00.1' and bi.lordem =7
20241106@190452.1445 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1462.00.1'
20241106@190452.1671 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.1462.00.1' and bi.lordem =8
20241106@190452.2052 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20241106@190452.2236 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.4990.00.1' and bi.lordem =9
20241106@190452.2615 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.497.00.01'
20241106@190452.2822 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.497.00.01' and bi.lordem =11
20241106@190452.3192 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.422.00.07'
20241106@190452.3374 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='304.422.00.07' and bi.lordem =13
20241106@190452.3722 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20241106@190452.3902 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='304.421.00.04' and bi.lordem =14
20241106@190452.4229 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.946.00.01'
20241106@190452.4257 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.946.00.01' and bi.lordem =15
20241106@190452.4582 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20241106@190452.4763 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.958.00.01' and bi.lordem =16
20241106@190452.5093 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20241106@190452.5114 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.945.00.01' and bi.lordem =17
20241106@190452.5676 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.939.00.01'
20241106@190452.5864 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.939.00.01' and bi.lordem =18
20241106@190452.6445 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.648.00.01'
20241106@190452.6651 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.648.00.01' and bi.lordem =19
20241106@190452.6998 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.691.00.01'
20241106@190452.7250 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.691.00.01' and bi.lordem =20
20241106@190452.7630 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241106@190452.7824 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407328 and bi.ref ='324.692.00.01' and bi.lordem =21
20241106@190452.8168 vjgd70tp3ti4l943e548i4lk6o Query : use flama_phc
20241106@190452.8172 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241106@190452.8205 vjgd70tp3ti4l943e548i4lk6o Query : use flama_phc
20241106@190452.8209 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 1 valor from td where td.ndoc = 39
20241106@190452.8238 vjgd70tp3ti4l943e548i4lk6o Query : use flama_phc
20241106@190452.8241 vjgd70tp3ti4l943e548i4lk6o 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')
20241106@190452.8268 vjgd70tp3ti4l943e548i4lk6o 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
20241106@190452.8308 vjgd70tp3ti4l943e548i4lk6o Query : use flama_phc
20241106@190452.8311 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 ~inactivo valor from cl where no = '101830' and estab = 0 order by inactivo desc
20241106@190452.8456 vjgd70tp3ti4l943e548i4lk6o Query : use flama_phc
20241106@190452.8459 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241106@190452.8490 vjgd70tp3ti4l943e548i4lk6o Query : use flama_phc
20241106@190452.8493 vjgd70tp3ti4l943e548i4lk6o Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241106@190452.8531 vjgd70tp3ti4l943e548i4lk6o Query : use flama_phc
20241106@190452.8535 vjgd70tp3ti4l943e548i4lk6o Query : select szadrsstamp valor from szadrs where szadrsdesc='ribeiro & vilarinho,lda-electro s.mamede'
20241106@190452.8579 vjgd70tp3ti4l943e548i4lk6o Query : use flama_phc
20241106@190452.8583 vjgd70tp3ti4l943e548i4lk6o Query : select 1 valor from td where ndoc = 39
20241106@190452.8596 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241106@190452.8611 vjgd70tp3ti4l943e548i4lk6o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190452.8628 vjgd70tp3ti4l943e548i4lk6o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241106@190452.8648 vjgd70tp3ti4l943e548i4lk6o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190452.8663 vjgd70tp3ti4l943e548i4lk6o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241106@190452.8691 vjgd70tp3ti4l943e548i4lk6o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241106@190452.8706 vjgd70tp3ti4l943e548i4lk6o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241106@190452.8722 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190452.8785 vjgd70tp3ti4l943e548i4lk6o Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241106@190452.8798 vjgd70tp3ti4l943e548i4lk6o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
