20240828@182215.8801 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182215.8820 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182215.8829 66gg5je4doorte46crut3afaqe Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182215.8842 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182215.8859 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182215.8873 66gg5je4doorte46crut3afaqe Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf57604166cf5cc7d7','aut66cf52235566cf5cc55c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182215.8878 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182215.8895 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182215.8933 66gg5je4doorte46crut3afaqe Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66cf57604166cf5cc7d7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66cf52235566cf5cc55c' ,0,0 ,2,23.00,530000,?,?,?)
20240828@182215.9216 66gg5je4doorte46crut3afaqe Query : use flama_phc
20240828@182215.9220 66gg5je4doorte46crut3afaqe Query : select st.usalote valor from st where st.ref = '324.649.00.01'
20240828@182215.9248 66gg5je4doorte46crut3afaqe 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.649.00.01'
20240828@182215.9267 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182215.9286 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182215.9316 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182215.9334 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182215.9344 66gg5je4doorte46crut3afaqe Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182215.9360 66gg5je4doorte46crut3afaqe Query : select sestamp valor from se where ref ='324.649.00.01' and lote = 'r2400277200a'
20240828@182215.9377 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182215.9393 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182215.9407 66gg5je4doorte46crut3afaqe Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf53508366cf5cc7e4','aut66cf52235566cf5cc55c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182215.9412 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182215.9429 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182215.9463 66gg5je4doorte46crut3afaqe Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66cf53508366cf5cc7e4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66cf52235566cf5cc55c' ,0,0 ,2,23.00,550000,?,?,?,?,?)
20240828@182215.9752 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182215.9773 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182215.9802 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182215.9821 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182215.9831 66gg5je4doorte46crut3afaqe Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182215.9845 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182215.9864 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182215.9878 66gg5je4doorte46crut3afaqe Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf59429466cf5cc7f0','aut66cf52235566cf5cc55c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182215.9883 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182215.9901 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182215.9934 66gg5je4doorte46crut3afaqe Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66cf59429466cf5cc7f0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66cf52235566cf5cc55c' ,0,0 ,2,23.00,560000,?,?,?)
20240828@182216.2090 66gg5je4doorte46crut3afaqe Query : use flama_phc
20240828@182216.2140 66gg5je4doorte46crut3afaqe Query : select st.usalote valor from st where st.ref = '324.649.00.01'
20240828@182216.2370 66gg5je4doorte46crut3afaqe 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.649.00.01'
20240828@182216.2550 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.2740 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182216.3040 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.3230 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182216.3330 66gg5je4doorte46crut3afaqe Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182216.3480 66gg5je4doorte46crut3afaqe Query : select sestamp valor from se where ref ='324.649.00.01' and lote = 'r2400277200a'
20240828@182216.3620 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.3790 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182216.3930 66gg5je4doorte46crut3afaqe Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf55773066cf5cc808','aut66cf52235566cf5cc55c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182216.3980 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.4150 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182216.4480 66gg5je4doorte46crut3afaqe Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66cf55773066cf5cc808',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66cf52235566cf5cc55c' ,0,0 ,2,23.00,580000,?,?,?,?,?)
20240828@182216.7310 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.7500 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182216.7810 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.7980 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182216.8080 66gg5je4doorte46crut3afaqe Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182216.8230 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.8390 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182216.8530 66gg5je4doorte46crut3afaqe Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf54073566cf5cc814','aut66cf52235566cf5cc55c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182216.8580 66gg5je4doorte46crut3afaqe Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.8760 66gg5je4doorte46crut3afaqe Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182216.9090 66gg5je4doorte46crut3afaqe Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66cf54073566cf5cc814',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66cf52235566cf5cc55c' ,0,0 ,2,23.00,590000,?,?,?)
20240828@182216.1177 66gg5je4doorte46crut3afaqe Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66cf52235566cf5cc55c','2405593','wait',39,'adm09112754980.682000002')
20240828@182216.1270 66gg5je4doorte46crut3afaqe Query : use flama_phc
20240828@182216.1273 66gg5je4doorte46crut3afaqe Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240828@182216.1307 66gg5je4doorte46crut3afaqe Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1712';
20240828@182216.1362 66gg5je4doorte46crut3afaqe Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1712';
20240828@182216.1404 66gg5je4doorte46crut3afaqe Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1712';
20240828@182216.1431 66gg5je4doorte46crut3afaqe Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1712';
20240828@182216.1962 86ns8f4h091eufltnkedj8ogt6 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240828@182216.1976 86ns8f4h091eufltnkedj8ogt6 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240828@182216.2031 86ns8f4h091eufltnkedj8ogt6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1713';
20240828@182216.2087 86ns8f4h091eufltnkedj8ogt6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1713';
20240828@182216.2153 86ns8f4h091eufltnkedj8ogt6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1713';
20240828@182216.2184 86ns8f4h091eufltnkedj8ogt6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1713';
20240828@182216.2233 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.2236 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240828@182216.2307 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.2311 86ns8f4h091eufltnkedj8ogt6 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1474
20240828@182216.2425 86ns8f4h091eufltnkedj8ogt6 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'
20240828@182216.2786 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2055 and bo.obrano = 2405596 and bi.ref ='304.421.00.04' and bi.lordem =1
20240828@182216.3131 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2031.00.1'
20240828@182216.3302 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2055 and bo.obrano = 2405596 and bi.ref ='324.2031.00.1' and bi.lordem =3
20240828@182216.4467 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.4472 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240828@182216.4513 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.4516 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 1 valor from td where td.ndoc = 39
20240828@182216.4551 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.4555 86ns8f4h091eufltnkedj8ogt6 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')
20240828@182216.4591 86ns8f4h091eufltnkedj8ogt6 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
20240828@182216.4631 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.4636 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240828@182216.4798 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.4802 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240828@182216.4839 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.4842 86ns8f4h091eufltnkedj8ogt6 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240828@182216.4884 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.4887 86ns8f4h091eufltnkedj8ogt6 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - corroios'
20240828@182216.4937 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.4941 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from td where ndoc = 39
20240828@182216.4955 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240828@182216.4982 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.5003 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240828@182216.5028 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.5047 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240828@182216.5083 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.5103 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240828@182216.5118 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240828@182216.5191 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240828@182216.5207 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.5225 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240828@182216.5245 86ns8f4h091eufltnkedj8ogt6 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66cf59261666cf5cc87c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240828@182216.5483 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.5504 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240828@182216.5547 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240828@182216.5562 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240828@182216.5587 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240828@182216.5602 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240828@182216.5617 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240828@182216.5633 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240828@182216.5648 86ns8f4h091eufltnkedj8ogt6 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66cf59261666cf5cc87c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240828@182216.5918 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 fno valor from wsftdata order by fno desc
20240828@182216.5943 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.5969 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240828@182216.5997 86ns8f4h091eufltnkedj8ogt6 Query : select 'normal' from dummy
20240828@182216.6018 86ns8f4h091eufltnkedj8ogt6 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66cf59261666cf5cc87c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',509,101621,0,'2024-08-28',39,'euro',0,0,2024 ,?,?)
20240828@182216.6385 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.6388 86ns8f4h091eufltnkedj8ogt6 Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240828@182216.6419 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240828@182216.6578 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.6600 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182216.6635 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.6656 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182216.6669 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182216.6724 86ns8f4h091eufltnkedj8ogt6 Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240896'
20240828@182216.6745 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.6771 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182216.6788 86ns8f4h091eufltnkedj8ogt6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf50519466cf5cc8a4','aut66cf59261666cf5cc87c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182216.6838 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.6857 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182216.6905 86ns8f4h091eufltnkedj8ogt6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66cf50519466cf5cc8a4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66cf59261666cf5cc87c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240828@182216.7191 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.7216 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182216.7249 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.7267 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182216.7278 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182216.7293 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.7321 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182216.7335 86ns8f4h091eufltnkedj8ogt6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf58230466cf5cc8b2','aut66cf59261666cf5cc87c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182216.7340 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.7360 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182216.7394 86ns8f4h091eufltnkedj8ogt6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66cf58230466cf5cc8b2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66cf59261666cf5cc87c' ,0,0 ,2,23.00,20000,?,?,?)
20240828@182216.7701 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.7706 86ns8f4h091eufltnkedj8ogt6 Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20240828@182216.7731 86ns8f4h091eufltnkedj8ogt6 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.2031.00.1'
20240828@182216.7912 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.7931 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182216.7961 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.7983 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182216.7996 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182216.8011 86ns8f4h091eufltnkedj8ogt6 Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20240828@182216.8028 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.8049 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182216.8066 86ns8f4h091eufltnkedj8ogt6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf59136266cf5cc8c4','aut66cf59261666cf5cc87c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182216.8071 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.8091 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182216.8134 86ns8f4h091eufltnkedj8ogt6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66cf59136266cf5cc8c4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66cf59261666cf5cc87c' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240828@182216.8423 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.9048 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182216.9078 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.9116 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182216.9127 86ns8f4h091eufltnkedj8ogt6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182216.9142 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.9160 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182216.9173 86ns8f4h091eufltnkedj8ogt6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf59341166cf5cc8df','aut66cf59261666cf5cc87c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182216.9178 86ns8f4h091eufltnkedj8ogt6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182216.9195 86ns8f4h091eufltnkedj8ogt6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182216.9231 86ns8f4h091eufltnkedj8ogt6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66cf59341166cf5cc8df',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66cf59261666cf5cc87c' ,0,0 ,2,23.00,50000,?,?,?)
20240828@182216.9579 86ns8f4h091eufltnkedj8ogt6 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66cf59261666cf5cc87c','2405596','wait',39,'adm09112754980.682000002')
20240828@182216.9713 86ns8f4h091eufltnkedj8ogt6 Query : use flama_phc
20240828@182216.9716 86ns8f4h091eufltnkedj8ogt6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240828@182216.9748 86ns8f4h091eufltnkedj8ogt6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1713';
20240828@182216.9784 86ns8f4h091eufltnkedj8ogt6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1713';
20240828@182216.9823 86ns8f4h091eufltnkedj8ogt6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1713';
20240828@182216.9847 86ns8f4h091eufltnkedj8ogt6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1713';
20240828@182217.3870 8kfl21bm05v622d5ltamhm4p8d Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240828@182217.3980 8kfl21bm05v622d5ltamhm4p8d Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240828@182217.4540 8kfl21bm05v622d5ltamhm4p8d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1714';
20240828@182217.5090 8kfl21bm05v622d5ltamhm4p8d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1714';
20240828@182217.5720 8kfl21bm05v622d5ltamhm4p8d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1714';
20240828@182217.5980 8kfl21bm05v622d5ltamhm4p8d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1714';
20240828@182217.6470 8kfl21bm05v622d5ltamhm4p8d Query : use flama_phc
20240828@182217.6510 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240828@182217.7220 8kfl21bm05v622d5ltamhm4p8d Query : use flama_phc
20240828@182217.7280 8kfl21bm05v622d5ltamhm4p8d Query : select no, estab,szadrsdesc from szadrs where u_coddest=1328
20240828@182217.8150 8kfl21bm05v622d5ltamhm4p8d 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'
20240828@182217.8380 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2055 and bo.obrano = 2405597 and bi.ref ='304.421.00.04' and bi.lordem =1
20240828@182217.1179 8kfl21bm05v622d5ltamhm4p8d Query : use flama_phc
20240828@182217.1183 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240828@182217.1455 8kfl21bm05v622d5ltamhm4p8d Query : use flama_phc
20240828@182217.1459 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 1 valor from td where td.ndoc = 39
20240828@182217.1574 8kfl21bm05v622d5ltamhm4p8d Query : use flama_phc
20240828@182217.1577 8kfl21bm05v622d5ltamhm4p8d 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')
20240828@182217.1644 8kfl21bm05v622d5ltamhm4p8d 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
20240828@182217.1770 8kfl21bm05v622d5ltamhm4p8d Query : use flama_phc
20240828@182217.1775 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240828@182217.1808 8kfl21bm05v622d5ltamhm4p8d Query : use flama_phc
20240828@182217.1813 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240828@182217.1905 8kfl21bm05v622d5ltamhm4p8d Query : use flama_phc
20240828@182217.1910 8kfl21bm05v622d5ltamhm4p8d Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240828@182217.1956 8kfl21bm05v622d5ltamhm4p8d Query : use flama_phc
20240828@182217.1961 8kfl21bm05v622d5ltamhm4p8d Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - mealhada'
20240828@182217.2013 8kfl21bm05v622d5ltamhm4p8d Query : use flama_phc
20240828@182217.2016 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from td where ndoc = 39
20240828@182217.2092 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240828@182217.2154 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.2172 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240828@182217.2194 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.2209 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240828@182217.2242 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.2259 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240828@182217.2276 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240828@182217.2478 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240828@182217.2562 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.2583 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240828@182217.2603 8kfl21bm05v622d5ltamhm4p8d Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66cf53660066cf5cc937' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240828@182217.2783 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.2802 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240828@182217.2842 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240828@182217.2943 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240828@182217.3036 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240828@182217.3110 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240828@182217.3186 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240828@182217.3309 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240828@182217.3398 8kfl21bm05v622d5ltamhm4p8d Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66cf53660066cf5cc937',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240828@182217.3654 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 fno valor from wsftdata order by fno desc
20240828@182217.3742 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.3765 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240828@182217.3794 8kfl21bm05v622d5ltamhm4p8d Query : select 'normal' from dummy
20240828@182217.3833 8kfl21bm05v622d5ltamhm4p8d Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66cf53660066cf5cc937',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',510,101621,0,'2024-08-28',39,'euro',0,0,2024 ,?,?)
20240828@182217.4142 8kfl21bm05v622d5ltamhm4p8d Query : use flama_phc
20240828@182217.4146 8kfl21bm05v622d5ltamhm4p8d Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240828@182217.4171 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240828@182217.4187 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.4208 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182217.4243 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.4262 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182217.4272 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182217.4288 8kfl21bm05v622d5ltamhm4p8d Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240896'
20240828@182217.4304 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.4321 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182217.4336 8kfl21bm05v622d5ltamhm4p8d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf57683366cf5cc969','aut66cf53660066cf5cc937' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182217.4342 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.4361 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182217.4396 8kfl21bm05v622d5ltamhm4p8d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66cf57683366cf5cc969',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66cf53660066cf5cc937' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240828@182217.4680 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.4698 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182217.4728 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.4744 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182217.4753 8kfl21bm05v622d5ltamhm4p8d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182217.4768 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.4800 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182217.4814 8kfl21bm05v622d5ltamhm4p8d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf54802566cf5cc974','aut66cf53660066cf5cc937' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182217.4825 8kfl21bm05v622d5ltamhm4p8d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182217.4844 8kfl21bm05v622d5ltamhm4p8d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182217.4876 8kfl21bm05v622d5ltamhm4p8d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66cf54802566cf5cc974',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66cf53660066cf5cc937' ,0,0 ,2,23.00,20000,?,?,?)
20240828@182217.5149 8kfl21bm05v622d5ltamhm4p8d Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66cf53660066cf5cc937','2405597','wait',39,'adm09112754980.682000002')
20240828@182217.5268 8kfl21bm05v622d5ltamhm4p8d Query : use flama_phc
20240828@182217.5294 8kfl21bm05v622d5ltamhm4p8d Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240828@182217.5330 8kfl21bm05v622d5ltamhm4p8d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1714';
20240828@182217.5360 8kfl21bm05v622d5ltamhm4p8d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1714';
20240828@182217.5398 8kfl21bm05v622d5ltamhm4p8d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1714';
20240828@182217.5421 8kfl21bm05v622d5ltamhm4p8d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1714';
20240828@182217.6826 gfco33d60hlophchnm8ipb2haq Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240828@182217.6850 gfco33d60hlophchnm8ipb2haq Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240828@182217.6933 gfco33d60hlophchnm8ipb2haq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1715';
20240828@182217.6983 gfco33d60hlophchnm8ipb2haq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1715';
20240828@182217.7036 gfco33d60hlophchnm8ipb2haq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1715';
20240828@182217.7061 gfco33d60hlophchnm8ipb2haq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1715';
20240828@182217.7110 gfco33d60hlophchnm8ipb2haq Query : use flama_phc
20240828@182217.7113 gfco33d60hlophchnm8ipb2haq Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240828@182217.7249 gfco33d60hlophchnm8ipb2haq Query : use flama_phc
20240828@182217.7253 gfco33d60hlophchnm8ipb2haq Query : select no, estab,szadrsdesc from szadrs where u_coddest=1161
20240828@182217.9299 gfco33d60hlophchnm8ipb2haq 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'
20240828@182217.9322 gfco33d60hlophchnm8ipb2haq Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2055 and bo.obrano = 2405598 and bi.ref ='304.421.00.04' and bi.lordem =1
20240828@182217.9668 gfco33d60hlophchnm8ipb2haq Query : use flama_phc
20240828@182217.9672 gfco33d60hlophchnm8ipb2haq Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240828@182217.9715 gfco33d60hlophchnm8ipb2haq Query : use flama_phc
20240828@182217.9719 gfco33d60hlophchnm8ipb2haq Query : select top 1 1 valor from td where td.ndoc = 39
20240828@182217.9754 gfco33d60hlophchnm8ipb2haq Query : use flama_phc
20240828@182217.9757 gfco33d60hlophchnm8ipb2haq 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')
20240828@182217.9790 gfco33d60hlophchnm8ipb2haq 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
20240828@182217.9827 gfco33d60hlophchnm8ipb2haq Query : use flama_phc
20240828@182217.9830 gfco33d60hlophchnm8ipb2haq Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240828@182217.9866 gfco33d60hlophchnm8ipb2haq Query : use flama_phc
20240828@182217.9870 gfco33d60hlophchnm8ipb2haq Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240828@182217.9904 gfco33d60hlophchnm8ipb2haq Query : use flama_phc
20240828@182217.9908 gfco33d60hlophchnm8ipb2haq Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240828@182217.9956 gfco33d60hlophchnm8ipb2haq Query : use flama_phc
20240828@182217.9960 gfco33d60hlophchnm8ipb2haq Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - Évora'
20240828@182218.1200 gfco33d60hlophchnm8ipb2haq Query : use flama_phc
20240828@182218.1600 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from td where ndoc = 39
20240828@182218.2900 gfco33d60hlophchnm8ipb2haq Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240828@182218.4500 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.6400 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240828@182218.8700 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.1050 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240828@182218.1370 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.1540 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240828@182218.1690 gfco33d60hlophchnm8ipb2haq Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240828@182218.2390 gfco33d60hlophchnm8ipb2haq Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240828@182218.2550 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.2770 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240828@182218.2960 gfco33d60hlophchnm8ipb2haq Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66cf56689166cf5cca04' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240828@182218.4780 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.4960 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240828@182218.5330 gfco33d60hlophchnm8ipb2haq Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240828@182218.5460 gfco33d60hlophchnm8ipb2haq Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240828@182218.5600 gfco33d60hlophchnm8ipb2haq Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240828@182218.5750 gfco33d60hlophchnm8ipb2haq Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240828@182218.5910 gfco33d60hlophchnm8ipb2haq Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240828@182218.6040 gfco33d60hlophchnm8ipb2haq Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240828@182218.6170 gfco33d60hlophchnm8ipb2haq Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66cf56689166cf5cca04',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240828@182218.8760 gfco33d60hlophchnm8ipb2haq Query : select top 1 fno valor from wsftdata order by fno desc
20240828@182218.8970 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.9220 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240828@182218.9490 gfco33d60hlophchnm8ipb2haq Query : select 'normal' from dummy
20240828@182218.9690 gfco33d60hlophchnm8ipb2haq Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66cf56689166cf5cca04',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',511,101621,0,'2024-08-28',39,'euro',0,0,2024 ,?,?)
20240828@182218.1276 gfco33d60hlophchnm8ipb2haq Query : use flama_phc
20240828@182218.1280 gfco33d60hlophchnm8ipb2haq Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240828@182218.1305 gfco33d60hlophchnm8ipb2haq Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240828@182218.1320 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.1338 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182218.1373 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.1388 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182218.1403 gfco33d60hlophchnm8ipb2haq Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182218.1425 gfco33d60hlophchnm8ipb2haq Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240896'
20240828@182218.1449 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.1466 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182218.1481 gfco33d60hlophchnm8ipb2haq Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf53127766cf5cca23','aut66cf56689166cf5cca04' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182218.1486 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.1503 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182218.1536 gfco33d60hlophchnm8ipb2haq Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66cf53127766cf5cca23',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66cf56689166cf5cca04' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240828@182218.1814 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.1832 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182218.1867 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.1884 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182218.1894 gfco33d60hlophchnm8ipb2haq Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182218.1909 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.1925 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182218.1939 gfco33d60hlophchnm8ipb2haq Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf50751166cf5cca2e','aut66cf56689166cf5cca04' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182218.1944 gfco33d60hlophchnm8ipb2haq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.1961 gfco33d60hlophchnm8ipb2haq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182218.1995 gfco33d60hlophchnm8ipb2haq Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66cf50751166cf5cca2e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66cf56689166cf5cca04' ,0,0 ,2,23.00,20000,?,?,?)
20240828@182218.2267 gfco33d60hlophchnm8ipb2haq Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66cf56689166cf5cca04','2405598','wait',39,'adm09112754980.682000002')
20240828@182218.2344 gfco33d60hlophchnm8ipb2haq Query : use flama_phc
20240828@182218.2348 gfco33d60hlophchnm8ipb2haq Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240828@182218.2382 gfco33d60hlophchnm8ipb2haq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1715';
20240828@182218.2413 gfco33d60hlophchnm8ipb2haq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1715';
20240828@182218.2455 gfco33d60hlophchnm8ipb2haq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1715';
20240828@182218.2480 gfco33d60hlophchnm8ipb2haq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1715';
20240828@182218.3073 mjq3aaq0i63ill0i6615o4osa2 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240828@182218.3085 mjq3aaq0i63ill0i6615o4osa2 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240828@182218.3160 mjq3aaq0i63ill0i6615o4osa2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1716';
20240828@182218.3226 mjq3aaq0i63ill0i6615o4osa2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1716';
20240828@182218.3276 mjq3aaq0i63ill0i6615o4osa2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1716';
20240828@182218.3302 mjq3aaq0i63ill0i6615o4osa2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1716';
20240828@182218.3384 mjq3aaq0i63ill0i6615o4osa2 Query : use flama_phc
20240828@182218.3388 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240828@182218.3473 mjq3aaq0i63ill0i6615o4osa2 Query : use flama_phc
20240828@182218.3477 mjq3aaq0i63ill0i6615o4osa2 Query : select no, estab,szadrsdesc from szadrs where u_coddest=908
20240828@182218.3568 mjq3aaq0i63ill0i6615o4osa2 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'
20240828@182218.3596 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2055 and bo.obrano = 2405599 and bi.ref ='304.421.00.04' and bi.lordem =1
20240828@182218.3980 mjq3aaq0i63ill0i6615o4osa2 Query : use flama_phc
20240828@182218.3984 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240828@182218.4020 mjq3aaq0i63ill0i6615o4osa2 Query : use flama_phc
20240828@182218.4024 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 1 valor from td where td.ndoc = 39
20240828@182218.4061 mjq3aaq0i63ill0i6615o4osa2 Query : use flama_phc
20240828@182218.4064 mjq3aaq0i63ill0i6615o4osa2 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')
20240828@182218.4095 mjq3aaq0i63ill0i6615o4osa2 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
20240828@182218.4137 mjq3aaq0i63ill0i6615o4osa2 Query : use flama_phc
20240828@182218.4141 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240828@182218.4173 mjq3aaq0i63ill0i6615o4osa2 Query : use flama_phc
20240828@182218.4176 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240828@182218.4215 mjq3aaq0i63ill0i6615o4osa2 Query : use flama_phc
20240828@182218.4218 mjq3aaq0i63ill0i6615o4osa2 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240828@182218.4333 mjq3aaq0i63ill0i6615o4osa2 Query : use flama_phc
20240828@182218.4337 mjq3aaq0i63ill0i6615o4osa2 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda-aveiro'
20240828@182218.4388 mjq3aaq0i63ill0i6615o4osa2 Query : use flama_phc
20240828@182218.4391 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from td where ndoc = 39
20240828@182218.4405 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240828@182218.4421 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.4440 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240828@182218.4466 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.4496 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240828@182218.4531 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.4548 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240828@182218.4567 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240828@182218.4639 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240828@182218.4654 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.4671 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240828@182218.4690 mjq3aaq0i63ill0i6615o4osa2 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66cf50409366cf5cca6f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240828@182218.4877 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.4910 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240828@182218.4952 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240828@182218.4966 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240828@182218.4983 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240828@182218.4998 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240828@182218.5013 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240828@182218.5026 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240828@182218.5040 mjq3aaq0i63ill0i6615o4osa2 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66cf50409366cf5cca6f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240828@182218.5339 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 fno valor from wsftdata order by fno desc
20240828@182218.5358 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.5378 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240828@182218.5403 mjq3aaq0i63ill0i6615o4osa2 Query : select 'normal' from dummy
20240828@182218.5425 mjq3aaq0i63ill0i6615o4osa2 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66cf50409366cf5cca6f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',512,101621,0,'2024-08-28',39,'euro',0,0,2024 ,?,?)
20240828@182218.5763 mjq3aaq0i63ill0i6615o4osa2 Query : use flama_phc
20240828@182218.5766 mjq3aaq0i63ill0i6615o4osa2 Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240828@182218.5793 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240828@182218.5811 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.5844 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182218.5875 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.5891 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182218.5901 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182218.5916 mjq3aaq0i63ill0i6615o4osa2 Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240896'
20240828@182218.5945 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.5964 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182218.5987 mjq3aaq0i63ill0i6615o4osa2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf50474466cf5cca91','aut66cf50409366cf5cca6f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182218.5992 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.6010 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182218.6041 mjq3aaq0i63ill0i6615o4osa2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66cf50474466cf5cca91',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66cf50409366cf5cca6f' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240828@182218.6386 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.6405 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182218.6435 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.6453 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182218.6467 mjq3aaq0i63ill0i6615o4osa2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182218.6481 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.6497 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182218.6511 mjq3aaq0i63ill0i6615o4osa2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf59230366cf5cca9e','aut66cf50409366cf5cca6f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182218.6517 mjq3aaq0i63ill0i6615o4osa2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.6534 mjq3aaq0i63ill0i6615o4osa2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182218.6568 mjq3aaq0i63ill0i6615o4osa2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66cf59230366cf5cca9e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66cf50409366cf5cca6f' ,0,0 ,2,23.00,20000,?,?,?)
20240828@182218.6861 mjq3aaq0i63ill0i6615o4osa2 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66cf50409366cf5cca6f','2405599','wait',39,'adm09112754980.682000002')
20240828@182218.6939 mjq3aaq0i63ill0i6615o4osa2 Query : use flama_phc
20240828@182218.6942 mjq3aaq0i63ill0i6615o4osa2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240828@182218.6978 mjq3aaq0i63ill0i6615o4osa2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1716';
20240828@182218.7009 mjq3aaq0i63ill0i6615o4osa2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1716';
20240828@182218.7050 mjq3aaq0i63ill0i6615o4osa2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1716';
20240828@182218.7077 mjq3aaq0i63ill0i6615o4osa2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1716';
20240828@182218.7627 dgkta93ugnpu5pudp9bq9g5sb4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240828@182218.7638 dgkta93ugnpu5pudp9bq9g5sb4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240828@182218.7741 dgkta93ugnpu5pudp9bq9g5sb4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1717';
20240828@182218.7805 dgkta93ugnpu5pudp9bq9g5sb4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1717';
20240828@182218.7859 dgkta93ugnpu5pudp9bq9g5sb4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1717';
20240828@182218.7938 dgkta93ugnpu5pudp9bq9g5sb4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1717';
20240828@182218.7995 dgkta93ugnpu5pudp9bq9g5sb4 Query : use flama_phc
20240828@182218.7999 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240828@182218.8084 dgkta93ugnpu5pudp9bq9g5sb4 Query : use flama_phc
20240828@182218.8088 dgkta93ugnpu5pudp9bq9g5sb4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1453
20240828@182218.8207 dgkta93ugnpu5pudp9bq9g5sb4 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'
20240828@182218.8229 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2056 and bo.obrano = 2405600 and bi.ref ='304.421.00.04' and bi.lordem =1
20240828@182218.8577 dgkta93ugnpu5pudp9bq9g5sb4 Query : use flama_phc
20240828@182218.8581 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240828@182218.8621 dgkta93ugnpu5pudp9bq9g5sb4 Query : use flama_phc
20240828@182218.8625 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 1 valor from td where td.ndoc = 39
20240828@182218.8657 dgkta93ugnpu5pudp9bq9g5sb4 Query : use flama_phc
20240828@182218.8661 dgkta93ugnpu5pudp9bq9g5sb4 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')
20240828@182218.8693 dgkta93ugnpu5pudp9bq9g5sb4 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
20240828@182218.8733 dgkta93ugnpu5pudp9bq9g5sb4 Query : use flama_phc
20240828@182218.8737 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240828@182218.8769 dgkta93ugnpu5pudp9bq9g5sb4 Query : use flama_phc
20240828@182218.8773 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240828@182218.8805 dgkta93ugnpu5pudp9bq9g5sb4 Query : use flama_phc
20240828@182218.8810 dgkta93ugnpu5pudp9bq9g5sb4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240828@182218.8851 dgkta93ugnpu5pudp9bq9g5sb4 Query : use flama_phc
20240828@182218.8855 dgkta93ugnpu5pudp9bq9g5sb4 Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - batalha'
20240828@182218.8907 dgkta93ugnpu5pudp9bq9g5sb4 Query : use flama_phc
20240828@182218.8911 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from td where ndoc = 39
20240828@182218.8925 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240828@182218.8943 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.8967 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240828@182218.8990 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.9007 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240828@182218.9040 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.9059 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240828@182218.9074 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240828@182218.9158 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240828@182218.9176 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.9195 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240828@182218.9225 dgkta93ugnpu5pudp9bq9g5sb4 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66cf59412866cf5ccadd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240828@182218.9470 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.9493 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240828@182218.9533 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240828@182218.9547 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240828@182218.9561 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240828@182218.9574 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240828@182218.9589 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240828@182218.9603 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240828@182218.9617 dgkta93ugnpu5pudp9bq9g5sb4 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66cf59412866cf5ccadd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240828@182218.9899 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 fno valor from wsftdata order by fno desc
20240828@182218.9923 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182218.9942 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240828@182218.9970 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 'normal' from dummy
20240828@182218.9989 dgkta93ugnpu5pudp9bq9g5sb4 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66cf59412866cf5ccadd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',513,101621,0,'2024-08-28',39,'euro',0,0,2024 ,?,?)
20240828@182219.3030 dgkta93ugnpu5pudp9bq9g5sb4 Query : use flama_phc
20240828@182219.3080 dgkta93ugnpu5pudp9bq9g5sb4 Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240828@182219.3350 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240828@182219.3500 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.3720 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182219.4010 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.4190 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182219.4300 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182219.4450 dgkta93ugnpu5pudp9bq9g5sb4 Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240896'
20240828@182219.4600 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.4780 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182219.4910 dgkta93ugnpu5pudp9bq9g5sb4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf50674066cf5ccb0b','aut66cf59412866cf5ccadd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182219.4950 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.5130 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182219.5470 dgkta93ugnpu5pudp9bq9g5sb4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66cf50674066cf5ccb0b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66cf59412866cf5ccadd' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240828@182219.8710 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.8900 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182219.9210 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.9380 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182219.9470 dgkta93ugnpu5pudp9bq9g5sb4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182219.9630 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.9780 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182219.9930 dgkta93ugnpu5pudp9bq9g5sb4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66cf54743166cf5ccb17','aut66cf59412866cf5ccadd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240828@182219.9970 dgkta93ugnpu5pudp9bq9g5sb4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.1015 dgkta93ugnpu5pudp9bq9g5sb4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182219.1047 dgkta93ugnpu5pudp9bq9g5sb4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66cf54743166cf5ccb17',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66cf59412866cf5ccadd' ,0,0 ,2,23.00,20000,?,?,?)
20240828@182219.1330 dgkta93ugnpu5pudp9bq9g5sb4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66cf59412866cf5ccadd','2405600','wait',39,'adm09112754980.682000002')
20240828@182219.1423 dgkta93ugnpu5pudp9bq9g5sb4 Query : use flama_phc
20240828@182219.1427 dgkta93ugnpu5pudp9bq9g5sb4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240828@182219.1460 dgkta93ugnpu5pudp9bq9g5sb4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1717';
20240828@182219.1491 dgkta93ugnpu5pudp9bq9g5sb4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1717';
20240828@182219.1535 dgkta93ugnpu5pudp9bq9g5sb4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1717';
20240828@182219.1577 dgkta93ugnpu5pudp9bq9g5sb4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1717';
20240828@182219.3668 017ea60vuns1ucq7ap1j21sber Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240828@182219.3681 017ea60vuns1ucq7ap1j21sber Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240828@182219.3744 017ea60vuns1ucq7ap1j21sber Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1718';
20240828@182219.3801 017ea60vuns1ucq7ap1j21sber Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1718';
20240828@182219.3855 017ea60vuns1ucq7ap1j21sber Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1718';
20240828@182219.3881 017ea60vuns1ucq7ap1j21sber Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1718';
20240828@182219.3956 017ea60vuns1ucq7ap1j21sber Query : use flama_phc
20240828@182219.3959 017ea60vuns1ucq7ap1j21sber Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240828@182219.4039 017ea60vuns1ucq7ap1j21sber Query : use flama_phc
20240828@182219.4042 017ea60vuns1ucq7ap1j21sber Query : select no, estab,szadrsdesc from szadrs where u_coddest=886
20240828@182219.4131 017ea60vuns1ucq7ap1j21sber 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'
20240828@182219.4159 017ea60vuns1ucq7ap1j21sber Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2056 and bo.obrano = 2405601 and bi.ref ='304.421.00.04' and bi.lordem =1
20240828@182219.4521 017ea60vuns1ucq7ap1j21sber Query : use flama_phc
20240828@182219.4524 017ea60vuns1ucq7ap1j21sber Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240828@182219.4559 017ea60vuns1ucq7ap1j21sber Query : use flama_phc
20240828@182219.4562 017ea60vuns1ucq7ap1j21sber Query : select top 1 1 valor from td where td.ndoc = 39
20240828@182219.4593 017ea60vuns1ucq7ap1j21sber Query : use flama_phc
20240828@182219.4596 017ea60vuns1ucq7ap1j21sber 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')
20240828@182219.4623 017ea60vuns1ucq7ap1j21sber 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
20240828@182219.4663 017ea60vuns1ucq7ap1j21sber Query : use flama_phc
20240828@182219.4666 017ea60vuns1ucq7ap1j21sber Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240828@182219.4697 017ea60vuns1ucq7ap1j21sber Query : use flama_phc
20240828@182219.4700 017ea60vuns1ucq7ap1j21sber Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240828@182219.4730 017ea60vuns1ucq7ap1j21sber Query : use flama_phc
20240828@182219.4733 017ea60vuns1ucq7ap1j21sber Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240828@182219.4774 017ea60vuns1ucq7ap1j21sber Query : use flama_phc
20240828@182219.4777 017ea60vuns1ucq7ap1j21sber Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda coimbra'
20240828@182219.4826 017ea60vuns1ucq7ap1j21sber Query : use flama_phc
20240828@182219.4829 017ea60vuns1ucq7ap1j21sber Query : select 1 valor from td where ndoc = 39
20240828@182219.4843 017ea60vuns1ucq7ap1j21sber Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240828@182219.4856 017ea60vuns1ucq7ap1j21sber Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.4875 017ea60vuns1ucq7ap1j21sber Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240828@182219.4893 017ea60vuns1ucq7ap1j21sber Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.4908 017ea60vuns1ucq7ap1j21sber Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240828@182219.4936 017ea60vuns1ucq7ap1j21sber Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.4950 017ea60vuns1ucq7ap1j21sber Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240828@182219.4963 017ea60vuns1ucq7ap1j21sber Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240828@182219.5031 017ea60vuns1ucq7ap1j21sber Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240828@182219.5043 017ea60vuns1ucq7ap1j21sber Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.5059 017ea60vuns1ucq7ap1j21sber Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240828@182219.5075 017ea60vuns1ucq7ap1j21sber Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66cf55134266cf5ccb79' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240828@182219.5259 017ea60vuns1ucq7ap1j21sber Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.5274 017ea60vuns1ucq7ap1j21sber Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240828@182219.5307 017ea60vuns1ucq7ap1j21sber Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240828@182219.5318 017ea60vuns1ucq7ap1j21sber Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240828@182219.5330 017ea60vuns1ucq7ap1j21sber Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240828@182219.5341 017ea60vuns1ucq7ap1j21sber Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240828@182219.5352 017ea60vuns1ucq7ap1j21sber Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240828@182219.5364 017ea60vuns1ucq7ap1j21sber Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240828@182219.5375 017ea60vuns1ucq7ap1j21sber Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66cf55134266cf5ccb79',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240828@182219.5612 017ea60vuns1ucq7ap1j21sber Query : select top 1 fno valor from wsftdata order by fno desc
20240828@182219.5631 017ea60vuns1ucq7ap1j21sber Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.5646 017ea60vuns1ucq7ap1j21sber Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240828@182219.5667 017ea60vuns1ucq7ap1j21sber Query : select 'normal' from dummy
20240828@182219.5682 017ea60vuns1ucq7ap1j21sber Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66cf55134266cf5ccb79',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',514,101621,0,'2024-08-28',39,'euro',0,0,2024 ,?,?)
20240828@182219.5972 017ea60vuns1ucq7ap1j21sber Query : use flama_phc
20240828@182219.5975 017ea60vuns1ucq7ap1j21sber Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240828@182219.5995 017ea60vuns1ucq7ap1j21sber Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240828@182219.6008 017ea60vuns1ucq7ap1j21sber Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.6023 017ea60vuns1ucq7ap1j21sber Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240828@182219.6047 017ea60vuns1ucq7ap1j21sber Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240828@182219.6060 017ea60vuns1ucq7ap1j21sber Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240828@182219.6069 017ea60vuns1ucq7ap1j21sber Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240828@182219.6080 017ea60vuns1ucq7ap1j21sber Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240896'
20240828@182219.6091 017ea60vuns1ucq7ap1j21sber Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
