20240801@212744.7852 5fbig74e0ufthumcf4il195q7v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240801@212744.7875 5fbig74e0ufthumcf4il195q7v Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2051 and bo.obrano = 2405169 and bi.ref ='324.5343.00.1' and bi.lordem =1
20240801@212744.8205 5fbig74e0ufthumcf4il195q7v Query : use flama_phc
20240801@212744.8209 5fbig74e0ufthumcf4il195q7v Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240801@212744.8244 5fbig74e0ufthumcf4il195q7v Query : use flama_phc
20240801@212744.8248 5fbig74e0ufthumcf4il195q7v Query : select top 1 1 valor from td where td.ndoc = 39
20240801@212744.8279 5fbig74e0ufthumcf4il195q7v Query : use flama_phc
20240801@212744.8282 5fbig74e0ufthumcf4il195q7v 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')
20240801@212744.8315 5fbig74e0ufthumcf4il195q7v 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
20240801@212744.8353 5fbig74e0ufthumcf4il195q7v Query : use flama_phc
20240801@212744.8356 5fbig74e0ufthumcf4il195q7v Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240801@212744.8388 5fbig74e0ufthumcf4il195q7v Query : use flama_phc
20240801@212744.8391 5fbig74e0ufthumcf4il195q7v Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240801@212744.8423 5fbig74e0ufthumcf4il195q7v Query : use flama_phc
20240801@212744.8426 5fbig74e0ufthumcf4il195q7v Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240801@212744.8466 5fbig74e0ufthumcf4il195q7v Query : use flama_phc
20240801@212744.8469 5fbig74e0ufthumcf4il195q7v Query : select szadrsstamp valor from szadrs where szadrsdesc='joaquim oliveira mendes,lda jom - covilhã'
20240801@212744.8519 5fbig74e0ufthumcf4il195q7v Query : use flama_phc
20240801@212744.8522 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from td where ndoc = 39
20240801@212744.8535 5fbig74e0ufthumcf4il195q7v Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240801@212744.8550 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212744.8566 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212744.8585 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212744.8601 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212744.8629 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212744.8643 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212744.8655 5fbig74e0ufthumcf4il195q7v Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212744.8726 5fbig74e0ufthumcf4il195q7v Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212744.8739 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212744.8760 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212744.8775 5fbig74e0ufthumcf4il195q7v Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66abe5128166abefc0d3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240801@212744.8963 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212744.8979 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212744.9013 5fbig74e0ufthumcf4il195q7v Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240801@212744.9024 5fbig74e0ufthumcf4il195q7v Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240801@212744.9036 5fbig74e0ufthumcf4il195q7v Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240801@212744.9049 5fbig74e0ufthumcf4il195q7v Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240801@212744.9063 5fbig74e0ufthumcf4il195q7v Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240801@212744.9075 5fbig74e0ufthumcf4il195q7v Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240801@212744.9086 5fbig74e0ufthumcf4il195q7v Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66abe5128166abefc0d3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240801@212744.9333 5fbig74e0ufthumcf4il195q7v Query : select top 1 fno valor from wsftdata order by fno desc
20240801@212744.9348 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212744.9364 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212744.9386 5fbig74e0ufthumcf4il195q7v Query : select 'normal' from dummy
20240801@212744.9402 5fbig74e0ufthumcf4il195q7v Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66abe5128166abefc0d3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',160,101621,0,'2024-08-01',39,'euro',0,0,2024 ,?,?)
20240801@212745.2900 5fbig74e0ufthumcf4il195q7v Query : use flama_phc
20240801@212745.7100 5fbig74e0ufthumcf4il195q7v Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240801@212745.2120 5fbig74e0ufthumcf4il195q7v 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.5343.00.1'
20240801@212745.2270 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.2440 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212745.2720 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.2860 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212745.2950 5fbig74e0ufthumcf4il195q7v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212745.3070 5fbig74e0ufthumcf4il195q7v Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240801@212745.3190 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.3340 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212745.3460 5fbig74e0ufthumcf4il195q7v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe5234166abefc107','aut66abe5128166abefc0d3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212745.3500 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.3640 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212745.3930 5fbig74e0ufthumcf4il195q7v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66abe5234166abefc107',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66abe5128166abefc0d3' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240801@212745.9950 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.1485 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212745.1951 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.1968 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212745.1977 5fbig74e0ufthumcf4il195q7v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212745.1991 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.2006 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212745.2017 5fbig74e0ufthumcf4il195q7v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe7070566abefc130','aut66abe5128166abefc0d3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212745.2021 5fbig74e0ufthumcf4il195q7v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.2036 5fbig74e0ufthumcf4il195q7v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212745.2065 5fbig74e0ufthumcf4il195q7v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66abe7070566abefc130',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66abe5128166abefc0d3' ,0,0 ,2,23.00,20000,?,?,?)
20240801@212745.2333 5fbig74e0ufthumcf4il195q7v Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66abe5128166abefc0d3','2405169','wait',39,'adm09112754980.682000002')
20240801@212745.2406 5fbig74e0ufthumcf4il195q7v Query : use flama_phc
20240801@212745.2409 5fbig74e0ufthumcf4il195q7v Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240801@212745.2440 5fbig74e0ufthumcf4il195q7v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1330';
20240801@212745.2467 5fbig74e0ufthumcf4il195q7v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1330';
20240801@212745.2504 5fbig74e0ufthumcf4il195q7v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1330';
20240801@212745.2526 5fbig74e0ufthumcf4il195q7v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1330';
20240801@212745.3010 07ql6jpk5hv6ttp4597hdpk535 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240801@212745.3021 07ql6jpk5hv6ttp4597hdpk535 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240801@212745.3073 07ql6jpk5hv6ttp4597hdpk535 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1331';
20240801@212745.3130 07ql6jpk5hv6ttp4597hdpk535 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1331';
20240801@212745.3181 07ql6jpk5hv6ttp4597hdpk535 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1331';
20240801@212745.3205 07ql6jpk5hv6ttp4597hdpk535 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1331';
20240801@212745.3252 07ql6jpk5hv6ttp4597hdpk535 Query : use flama_phc
20240801@212745.3256 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240801@212745.3316 07ql6jpk5hv6ttp4597hdpk535 Query : use flama_phc
20240801@212745.3319 07ql6jpk5hv6ttp4597hdpk535 Query : select no, estab,szadrsdesc from szadrs where u_coddest=8548
20240801@212745.3400 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240801@212745.3420 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2051 and bo.obrano = 2405170 and bi.ref ='324.5343.00.1' and bi.lordem =1
20240801@212745.3753 07ql6jpk5hv6ttp4597hdpk535 Query : use flama_phc
20240801@212745.3756 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240801@212745.3793 07ql6jpk5hv6ttp4597hdpk535 Query : use flama_phc
20240801@212745.3796 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 1 valor from td where td.ndoc = 39
20240801@212745.3826 07ql6jpk5hv6ttp4597hdpk535 Query : use flama_phc
20240801@212745.3829 07ql6jpk5hv6ttp4597hdpk535 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')
20240801@212745.3859 07ql6jpk5hv6ttp4597hdpk535 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
20240801@212745.3896 07ql6jpk5hv6ttp4597hdpk535 Query : use flama_phc
20240801@212745.3899 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240801@212745.3929 07ql6jpk5hv6ttp4597hdpk535 Query : use flama_phc
20240801@212745.3932 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240801@212745.3962 07ql6jpk5hv6ttp4597hdpk535 Query : use flama_phc
20240801@212745.3965 07ql6jpk5hv6ttp4597hdpk535 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240801@212745.4003 07ql6jpk5hv6ttp4597hdpk535 Query : use flama_phc
20240801@212745.4006 07ql6jpk5hv6ttp4597hdpk535 Query : select szadrsstamp valor from szadrs where szadrsdesc='jom- maia ( nova loja)'
20240801@212745.4051 07ql6jpk5hv6ttp4597hdpk535 Query : use flama_phc
20240801@212745.4054 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from td where ndoc = 39
20240801@212745.4067 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240801@212745.4081 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.4113 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212745.4133 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.4150 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212745.4180 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.4194 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212745.4207 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212745.4277 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212745.4290 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.4308 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212745.4324 07ql6jpk5hv6ttp4597hdpk535 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66abe7270766abefc166' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240801@212745.4527 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.4543 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212745.4576 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240801@212745.4587 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240801@212745.4602 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240801@212745.4615 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240801@212745.4629 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240801@212745.4642 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240801@212745.4654 07ql6jpk5hv6ttp4597hdpk535 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66abe7270766abefc166',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240801@212745.4913 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 fno valor from wsftdata order by fno desc
20240801@212745.4930 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.4949 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212745.4974 07ql6jpk5hv6ttp4597hdpk535 Query : select 'normal' from dummy
20240801@212745.4991 07ql6jpk5hv6ttp4597hdpk535 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66abe7270766abefc166',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',161,101621,0,'2024-08-01',39,'euro',0,0,2024 ,?,?)
20240801@212745.5394 07ql6jpk5hv6ttp4597hdpk535 Query : use flama_phc
20240801@212745.5398 07ql6jpk5hv6ttp4597hdpk535 Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240801@212745.5422 07ql6jpk5hv6ttp4597hdpk535 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.5343.00.1'
20240801@212745.5438 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.5462 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212745.5495 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.5512 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212745.5522 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212745.5535 07ql6jpk5hv6ttp4597hdpk535 Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240801@212745.5551 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.5572 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212745.5588 07ql6jpk5hv6ttp4597hdpk535 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe2098266abefc187','aut66abe7270766abefc166' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212745.5594 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.5613 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212745.5648 07ql6jpk5hv6ttp4597hdpk535 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66abe2098266abefc187',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66abe7270766abefc166' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240801@212745.5945 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.5965 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212745.5992 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.6014 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212745.6024 07ql6jpk5hv6ttp4597hdpk535 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212745.6037 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.6055 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212745.6068 07ql6jpk5hv6ttp4597hdpk535 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe5302966abefc193','aut66abe7270766abefc166' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212745.6073 07ql6jpk5hv6ttp4597hdpk535 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.6089 07ql6jpk5hv6ttp4597hdpk535 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212745.6124 07ql6jpk5hv6ttp4597hdpk535 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66abe5302966abefc193',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66abe7270766abefc166' ,0,0 ,2,23.00,20000,?,?,?)
20240801@212745.6384 07ql6jpk5hv6ttp4597hdpk535 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66abe7270766abefc166','2405170','wait',39,'adm09112754980.682000002')
20240801@212745.6459 07ql6jpk5hv6ttp4597hdpk535 Query : use flama_phc
20240801@212745.6463 07ql6jpk5hv6ttp4597hdpk535 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240801@212745.6736 07ql6jpk5hv6ttp4597hdpk535 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1331';
20240801@212745.6765 07ql6jpk5hv6ttp4597hdpk535 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1331';
20240801@212745.6803 07ql6jpk5hv6ttp4597hdpk535 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1331';
20240801@212745.6828 07ql6jpk5hv6ttp4597hdpk535 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1331';
20240801@212745.7328 5bvu7apgp70of0p1spvh6cb6jf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240801@212745.7342 5bvu7apgp70of0p1spvh6cb6jf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240801@212745.7392 5bvu7apgp70of0p1spvh6cb6jf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1332';
20240801@212745.7442 5bvu7apgp70of0p1spvh6cb6jf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1332';
20240801@212745.7495 5bvu7apgp70of0p1spvh6cb6jf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1332';
20240801@212745.7517 5bvu7apgp70of0p1spvh6cb6jf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1332';
20240801@212745.7565 5bvu7apgp70of0p1spvh6cb6jf Query : use flama_phc
20240801@212745.7568 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240801@212745.7635 5bvu7apgp70of0p1spvh6cb6jf Query : use flama_phc
20240801@212745.7638 5bvu7apgp70of0p1spvh6cb6jf Query : select no, estab,szadrsdesc from szadrs where u_coddest=886
20240801@212745.7719 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240801@212745.7740 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2051 and bo.obrano = 2405171 and bi.ref ='324.5343.00.1' and bi.lordem =1
20240801@212745.8126 5bvu7apgp70of0p1spvh6cb6jf Query : use flama_phc
20240801@212745.8167 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240801@212745.8204 5bvu7apgp70of0p1spvh6cb6jf Query : use flama_phc
20240801@212745.8208 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 1 valor from td where td.ndoc = 39
20240801@212745.8239 5bvu7apgp70of0p1spvh6cb6jf Query : use flama_phc
20240801@212745.8243 5bvu7apgp70of0p1spvh6cb6jf 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')
20240801@212745.8274 5bvu7apgp70of0p1spvh6cb6jf 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
20240801@212745.8313 5bvu7apgp70of0p1spvh6cb6jf Query : use flama_phc
20240801@212745.8317 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240801@212745.8347 5bvu7apgp70of0p1spvh6cb6jf Query : use flama_phc
20240801@212745.8351 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240801@212745.8383 5bvu7apgp70of0p1spvh6cb6jf Query : use flama_phc
20240801@212745.8386 5bvu7apgp70of0p1spvh6cb6jf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240801@212745.8431 5bvu7apgp70of0p1spvh6cb6jf Query : use flama_phc
20240801@212745.8434 5bvu7apgp70of0p1spvh6cb6jf Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda coimbra'
20240801@212745.8483 5bvu7apgp70of0p1spvh6cb6jf Query : use flama_phc
20240801@212745.8486 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from td where ndoc = 39
20240801@212745.8500 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240801@212745.8514 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.8532 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212745.8553 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.8568 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212745.8600 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.8617 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212745.8631 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212745.8703 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212745.8718 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212745.8735 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212745.8753 5bvu7apgp70of0p1spvh6cb6jf Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66abe9930466abefc1d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240801@212745.9025 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.5000 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212746.1310 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240801@212746.1440 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240801@212746.1570 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240801@212746.1920 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240801@212746.2510 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240801@212746.3010 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240801@212746.3140 5bvu7apgp70of0p1spvh6cb6jf Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66abe9930466abefc1d2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240801@212746.5850 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 fno valor from wsftdata order by fno desc
20240801@212746.6090 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.6340 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212746.6580 5bvu7apgp70of0p1spvh6cb6jf Query : select 'normal' from dummy
20240801@212746.6730 5bvu7apgp70of0p1spvh6cb6jf Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66abe9930466abefc1d2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',162,101621,0,'2024-08-01',39,'euro',0,0,2024 ,?,?)
20240801@212746.9760 5bvu7apgp70of0p1spvh6cb6jf Query : use flama_phc
20240801@212746.9790 5bvu7apgp70of0p1spvh6cb6jf Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240801@212746.1002 5bvu7apgp70of0p1spvh6cb6jf 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.5343.00.1'
20240801@212746.1016 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.1032 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212746.1067 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.1082 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212746.1090 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212746.1104 5bvu7apgp70of0p1spvh6cb6jf Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240801@212746.1116 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.1131 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212746.1142 5bvu7apgp70of0p1spvh6cb6jf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe6555866abefc21b','aut66abe9930466abefc1d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212746.1147 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.1161 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212746.1188 5bvu7apgp70of0p1spvh6cb6jf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66abe6555866abefc21b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66abe9930466abefc1d2' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240801@212746.1467 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.1483 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212746.1508 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.1522 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212746.1530 5bvu7apgp70of0p1spvh6cb6jf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212746.1542 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.1556 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212746.1568 5bvu7apgp70of0p1spvh6cb6jf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe0921166abefc225','aut66abe9930466abefc1d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212746.1571 5bvu7apgp70of0p1spvh6cb6jf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.1585 5bvu7apgp70of0p1spvh6cb6jf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212746.1613 5bvu7apgp70of0p1spvh6cb6jf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66abe0921166abefc225',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66abe9930466abefc1d2' ,0,0 ,2,23.00,20000,?,?,?)
20240801@212746.1856 5bvu7apgp70of0p1spvh6cb6jf Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66abe9930466abefc1d2','2405171','wait',39,'adm09112754980.682000002')
20240801@212746.1929 5bvu7apgp70of0p1spvh6cb6jf Query : use flama_phc
20240801@212746.1933 5bvu7apgp70of0p1spvh6cb6jf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240801@212746.1965 5bvu7apgp70of0p1spvh6cb6jf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1332';
20240801@212746.1989 5bvu7apgp70of0p1spvh6cb6jf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1332';
20240801@212746.2024 5bvu7apgp70of0p1spvh6cb6jf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1332';
20240801@212746.2046 5bvu7apgp70of0p1spvh6cb6jf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1332';
20240801@212746.2558 tk6oktl931qf0h6as1bvhj1dbf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240801@212746.2570 tk6oktl931qf0h6as1bvhj1dbf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240801@212746.2622 tk6oktl931qf0h6as1bvhj1dbf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1333';
20240801@212746.2684 tk6oktl931qf0h6as1bvhj1dbf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1333';
20240801@212746.2737 tk6oktl931qf0h6as1bvhj1dbf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1333';
20240801@212746.2759 tk6oktl931qf0h6as1bvhj1dbf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1333';
20240801@212746.2865 tk6oktl931qf0h6as1bvhj1dbf Query : use flama_phc
20240801@212746.2868 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240801@212746.2997 tk6oktl931qf0h6as1bvhj1dbf Query : use flama_phc
20240801@212746.3001 tk6oktl931qf0h6as1bvhj1dbf Query : select no, estab,szadrsdesc from szadrs where u_coddest=2374
20240801@212746.3122 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240801@212746.3218 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2051 and bo.obrano = 2405172 and bi.ref ='324.5343.00.1' and bi.lordem =1
20240801@212746.3783 tk6oktl931qf0h6as1bvhj1dbf Query : use flama_phc
20240801@212746.3787 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240801@212746.3820 tk6oktl931qf0h6as1bvhj1dbf Query : use flama_phc
20240801@212746.3824 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 1 valor from td where td.ndoc = 39
20240801@212746.3854 tk6oktl931qf0h6as1bvhj1dbf Query : use flama_phc
20240801@212746.3857 tk6oktl931qf0h6as1bvhj1dbf 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')
20240801@212746.3887 tk6oktl931qf0h6as1bvhj1dbf 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
20240801@212746.3921 tk6oktl931qf0h6as1bvhj1dbf Query : use flama_phc
20240801@212746.3924 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240801@212746.3953 tk6oktl931qf0h6as1bvhj1dbf Query : use flama_phc
20240801@212746.3955 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240801@212746.3985 tk6oktl931qf0h6as1bvhj1dbf Query : use flama_phc
20240801@212746.3987 tk6oktl931qf0h6as1bvhj1dbf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240801@212746.4028 tk6oktl931qf0h6as1bvhj1dbf Query : use flama_phc
20240801@212746.4031 tk6oktl931qf0h6as1bvhj1dbf Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - vila real'
20240801@212746.5602 tk6oktl931qf0h6as1bvhj1dbf Query : use flama_phc
20240801@212746.5605 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from td where ndoc = 39
20240801@212746.5619 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240801@212746.5633 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.5649 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212746.5667 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.5681 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212746.5709 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.5724 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212746.5738 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212746.5825 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212746.5842 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.5860 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212746.5877 tk6oktl931qf0h6as1bvhj1dbf Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66abe7431366abefc28c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240801@212746.6079 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.6100 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212746.6136 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240801@212746.6150 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240801@212746.6162 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240801@212746.6175 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240801@212746.6187 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240801@212746.6200 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240801@212746.6213 tk6oktl931qf0h6as1bvhj1dbf Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66abe7431366abefc28c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240801@212746.6469 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 fno valor from wsftdata order by fno desc
20240801@212746.6486 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.6503 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212746.6565 tk6oktl931qf0h6as1bvhj1dbf Query : select 'normal' from dummy
20240801@212746.6581 tk6oktl931qf0h6as1bvhj1dbf Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66abe7431366abefc28c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',163,101621,0,'2024-08-01',39,'euro',0,0,2024 ,?,?)
20240801@212746.7107 tk6oktl931qf0h6as1bvhj1dbf Query : use flama_phc
20240801@212746.7111 tk6oktl931qf0h6as1bvhj1dbf Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240801@212746.7133 tk6oktl931qf0h6as1bvhj1dbf 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.5343.00.1'
20240801@212746.7148 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.7164 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212746.7193 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.7212 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212746.7221 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212746.7234 tk6oktl931qf0h6as1bvhj1dbf Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240801@212746.7247 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.7264 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212746.7277 tk6oktl931qf0h6as1bvhj1dbf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe4389566abefc2b0','aut66abe7431366abefc28c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212746.7281 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.7296 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212746.7326 tk6oktl931qf0h6as1bvhj1dbf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66abe4389566abefc2b0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66abe7431366abefc28c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240801@212746.7599 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.7616 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212746.7643 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.7658 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212746.7667 tk6oktl931qf0h6as1bvhj1dbf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212746.7682 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.7697 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212746.7710 tk6oktl931qf0h6as1bvhj1dbf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe9178466abefc2bb','aut66abe7431366abefc28c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212746.7715 tk6oktl931qf0h6as1bvhj1dbf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212746.7731 tk6oktl931qf0h6as1bvhj1dbf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212746.7761 tk6oktl931qf0h6as1bvhj1dbf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66abe9178466abefc2bb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66abe7431366abefc28c' ,0,0 ,2,23.00,20000,?,?,?)
20240801@212746.8020 tk6oktl931qf0h6as1bvhj1dbf Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66abe7431366abefc28c','2405172','wait',39,'adm09112754980.682000002')
20240801@212746.8124 tk6oktl931qf0h6as1bvhj1dbf Query : use flama_phc
20240801@212746.8127 tk6oktl931qf0h6as1bvhj1dbf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240801@212746.8160 tk6oktl931qf0h6as1bvhj1dbf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1333';
20240801@212746.8189 tk6oktl931qf0h6as1bvhj1dbf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1333';
20240801@212746.8228 tk6oktl931qf0h6as1bvhj1dbf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1333';
20240801@212746.8253 tk6oktl931qf0h6as1bvhj1dbf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1333';
20240801@212746.8722 9lii2008qtc5n5h53h4rgoqj7o Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240801@212746.8733 9lii2008qtc5n5h53h4rgoqj7o Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240801@212746.8780 9lii2008qtc5n5h53h4rgoqj7o Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1334';
20240801@212746.8831 9lii2008qtc5n5h53h4rgoqj7o Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1334';
20240801@212746.8876 9lii2008qtc5n5h53h4rgoqj7o Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1334';
20240801@212746.8899 9lii2008qtc5n5h53h4rgoqj7o Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1334';
20240801@212746.8960 9lii2008qtc5n5h53h4rgoqj7o Query : use flama_phc
20240801@212746.8964 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240801@212746.9033 9lii2008qtc5n5h53h4rgoqj7o Query : use flama_phc
20240801@212746.9036 9lii2008qtc5n5h53h4rgoqj7o Query : select no, estab,szadrsdesc from szadrs where u_coddest=2014
20240801@212746.9120 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240801@212746.9142 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2051 and bo.obrano = 2405173 and bi.ref ='324.5343.00.1' and bi.lordem =1
20240801@212746.9670 9lii2008qtc5n5h53h4rgoqj7o Query : use flama_phc
20240801@212746.9715 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240801@212746.9754 9lii2008qtc5n5h53h4rgoqj7o Query : use flama_phc
20240801@212746.9757 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 1 valor from td where td.ndoc = 39
20240801@212746.9787 9lii2008qtc5n5h53h4rgoqj7o Query : use flama_phc
20240801@212746.9790 9lii2008qtc5n5h53h4rgoqj7o 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')
20240801@212746.9822 9lii2008qtc5n5h53h4rgoqj7o 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
20240801@212746.9858 9lii2008qtc5n5h53h4rgoqj7o Query : use flama_phc
20240801@212746.9862 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240801@212746.9892 9lii2008qtc5n5h53h4rgoqj7o Query : use flama_phc
20240801@212746.9895 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240801@212746.9927 9lii2008qtc5n5h53h4rgoqj7o Query : use flama_phc
20240801@212746.9930 9lii2008qtc5n5h53h4rgoqj7o Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240801@212746.9971 9lii2008qtc5n5h53h4rgoqj7o Query : use flama_phc
20240801@212746.9974 9lii2008qtc5n5h53h4rgoqj7o Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - guarda'
20240801@212747.2400 9lii2008qtc5n5h53h4rgoqj7o Query : use flama_phc
20240801@212747.2700 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from td where ndoc = 39
20240801@212747.4000 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240801@212747.5500 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.7200 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212747.9200 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.1820 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212747.2110 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.2280 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212747.2410 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212747.4350 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212747.4480 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.4660 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212747.4820 9lii2008qtc5n5h53h4rgoqj7o Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66abe8890366abefc305' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240801@212747.7530 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.7730 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212747.8070 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240801@212747.8200 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240801@212747.8320 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240801@212747.8440 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240801@212747.9270 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240801@212747.9400 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240801@212747.9550 9lii2008qtc5n5h53h4rgoqj7o Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66abe8890366abefc305',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240801@212747.1217 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 fno valor from wsftdata order by fno desc
20240801@212747.1233 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.1250 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212747.1274 9lii2008qtc5n5h53h4rgoqj7o Query : select 'normal' from dummy
20240801@212747.1289 9lii2008qtc5n5h53h4rgoqj7o Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66abe8890366abefc305',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',164,101621,0,'2024-08-01',39,'euro',0,0,2024 ,?,?)
20240801@212747.1574 9lii2008qtc5n5h53h4rgoqj7o Query : use flama_phc
20240801@212747.1578 9lii2008qtc5n5h53h4rgoqj7o Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240801@212747.1600 9lii2008qtc5n5h53h4rgoqj7o 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.5343.00.1'
20240801@212747.1614 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.1632 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212747.1658 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.1674 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212747.1683 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212747.1696 9lii2008qtc5n5h53h4rgoqj7o Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240801@212747.1709 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.1724 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212747.1737 9lii2008qtc5n5h53h4rgoqj7o Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe0635366abefc329','aut66abe8890366abefc305' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212747.1741 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.1757 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212747.1787 9lii2008qtc5n5h53h4rgoqj7o Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66abe0635366abefc329',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66abe8890366abefc305' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240801@212747.2054 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.2070 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212747.2236 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.2253 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212747.2262 9lii2008qtc5n5h53h4rgoqj7o Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212747.2275 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.2290 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212747.2302 9lii2008qtc5n5h53h4rgoqj7o Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe1789666abefc337','aut66abe8890366abefc305' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212747.2307 9lii2008qtc5n5h53h4rgoqj7o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.2322 9lii2008qtc5n5h53h4rgoqj7o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212747.2352 9lii2008qtc5n5h53h4rgoqj7o Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66abe1789666abefc337',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66abe8890366abefc305' ,0,0 ,2,23.00,20000,?,?,?)
20240801@212747.2612 9lii2008qtc5n5h53h4rgoqj7o Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66abe8890366abefc305','2405173','wait',39,'adm09112754980.682000002')
20240801@212747.2756 9lii2008qtc5n5h53h4rgoqj7o Query : use flama_phc
20240801@212747.2759 9lii2008qtc5n5h53h4rgoqj7o Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240801@212747.2792 9lii2008qtc5n5h53h4rgoqj7o Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1334';
20240801@212747.2818 9lii2008qtc5n5h53h4rgoqj7o Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1334';
20240801@212747.2854 9lii2008qtc5n5h53h4rgoqj7o Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1334';
20240801@212747.2878 9lii2008qtc5n5h53h4rgoqj7o Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1334';
20240801@212747.3350 khurir2a2u1uf9igi8j4g8h97r Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240801@212747.3361 khurir2a2u1uf9igi8j4g8h97r Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240801@212747.3406 khurir2a2u1uf9igi8j4g8h97r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1335';
20240801@212747.3460 khurir2a2u1uf9igi8j4g8h97r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1335';
20240801@212747.3505 khurir2a2u1uf9igi8j4g8h97r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1335';
20240801@212747.3527 khurir2a2u1uf9igi8j4g8h97r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1335';
20240801@212747.3570 khurir2a2u1uf9igi8j4g8h97r Query : use flama_phc
20240801@212747.3573 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240801@212747.3637 khurir2a2u1uf9igi8j4g8h97r Query : use flama_phc
20240801@212747.3640 khurir2a2u1uf9igi8j4g8h97r Query : select no, estab,szadrsdesc from szadrs where u_coddest=2632
20240801@212747.3724 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240801@212747.3746 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2051 and bo.obrano = 2405174 and bi.ref ='324.5343.00.1' and bi.lordem =1
20240801@212747.4076 khurir2a2u1uf9igi8j4g8h97r Query : use flama_phc
20240801@212747.4079 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240801@212747.4118 khurir2a2u1uf9igi8j4g8h97r Query : use flama_phc
20240801@212747.4121 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 1 valor from td where td.ndoc = 39
20240801@212747.4155 khurir2a2u1uf9igi8j4g8h97r Query : use flama_phc
20240801@212747.4158 khurir2a2u1uf9igi8j4g8h97r 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')
20240801@212747.4189 khurir2a2u1uf9igi8j4g8h97r 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
20240801@212747.4227 khurir2a2u1uf9igi8j4g8h97r Query : use flama_phc
20240801@212747.4230 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240801@212747.4262 khurir2a2u1uf9igi8j4g8h97r Query : use flama_phc
20240801@212747.4265 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240801@212747.4297 khurir2a2u1uf9igi8j4g8h97r Query : use flama_phc
20240801@212747.4301 khurir2a2u1uf9igi8j4g8h97r Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240801@212747.4342 khurir2a2u1uf9igi8j4g8h97r Query : use flama_phc
20240801@212747.4346 khurir2a2u1uf9igi8j4g8h97r Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda- braganÇa'
20240801@212747.4395 khurir2a2u1uf9igi8j4g8h97r Query : use flama_phc
20240801@212747.4399 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from td where ndoc = 39
20240801@212747.4416 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240801@212747.4438 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.4460 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212747.4487 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.4507 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212747.4540 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.4558 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212747.4573 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212747.4648 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212747.4663 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.4679 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212747.4695 khurir2a2u1uf9igi8j4g8h97r Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66abe9640166abefc36f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240801@212747.4899 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.4916 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212747.4951 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240801@212747.4965 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240801@212747.4978 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240801@212747.4990 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240801@212747.5004 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240801@212747.5017 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240801@212747.5038 khurir2a2u1uf9igi8j4g8h97r Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66abe9640166abefc36f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240801@212747.5292 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 fno valor from wsftdata order by fno desc
20240801@212747.5308 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.5326 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212747.5351 khurir2a2u1uf9igi8j4g8h97r Query : select 'normal' from dummy
20240801@212747.5371 khurir2a2u1uf9igi8j4g8h97r Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66abe9640166abefc36f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',165,101621,0,'2024-08-01',39,'euro',0,0,2024 ,?,?)
20240801@212747.5692 khurir2a2u1uf9igi8j4g8h97r Query : use flama_phc
20240801@212747.5696 khurir2a2u1uf9igi8j4g8h97r Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240801@212747.5719 khurir2a2u1uf9igi8j4g8h97r 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.5343.00.1'
20240801@212747.5734 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.5751 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212747.5782 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.5797 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212747.5807 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212747.5819 khurir2a2u1uf9igi8j4g8h97r Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240801@212747.5832 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.5847 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212747.5859 khurir2a2u1uf9igi8j4g8h97r Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe7858766abefc38e','aut66abe9640166abefc36f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212747.5863 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.5877 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212747.5906 khurir2a2u1uf9igi8j4g8h97r Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66abe7858766abefc38e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66abe9640166abefc36f' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240801@212747.6189 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.6206 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212747.6233 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.6248 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212747.6256 khurir2a2u1uf9igi8j4g8h97r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212747.6269 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.6285 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212747.6297 khurir2a2u1uf9igi8j4g8h97r Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe3775066abefc399','aut66abe9640166abefc36f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212747.6301 khurir2a2u1uf9igi8j4g8h97r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.6316 khurir2a2u1uf9igi8j4g8h97r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212747.7557 khurir2a2u1uf9igi8j4g8h97r Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66abe3775066abefc399',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66abe9640166abefc36f' ,0,0 ,2,23.00,20000,?,?,?)
20240801@212747.7922 khurir2a2u1uf9igi8j4g8h97r Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66abe9640166abefc36f','2405174','wait',39,'adm09112754980.682000002')
20240801@212747.8001 khurir2a2u1uf9igi8j4g8h97r Query : use flama_phc
20240801@212747.8005 khurir2a2u1uf9igi8j4g8h97r Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240801@212747.8039 khurir2a2u1uf9igi8j4g8h97r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1335';
20240801@212747.8067 khurir2a2u1uf9igi8j4g8h97r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1335';
20240801@212747.8105 khurir2a2u1uf9igi8j4g8h97r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1335';
20240801@212747.8128 khurir2a2u1uf9igi8j4g8h97r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1335';
20240801@212747.8606 gvdv3rukf8or9q0b86d9gtchrh Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240801@212747.8617 gvdv3rukf8or9q0b86d9gtchrh Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240801@212747.8667 gvdv3rukf8or9q0b86d9gtchrh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1336';
20240801@212747.8718 gvdv3rukf8or9q0b86d9gtchrh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1336';
20240801@212747.8770 gvdv3rukf8or9q0b86d9gtchrh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1336';
20240801@212747.8793 gvdv3rukf8or9q0b86d9gtchrh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1336';
20240801@212747.8843 gvdv3rukf8or9q0b86d9gtchrh Query : use flama_phc
20240801@212747.8846 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240801@212747.8915 gvdv3rukf8or9q0b86d9gtchrh Query : use flama_phc
20240801@212747.8918 gvdv3rukf8or9q0b86d9gtchrh Query : select no, estab,szadrsdesc from szadrs where u_coddest=3304
20240801@212747.9068 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240801@212747.9091 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2051 and bo.obrano = 2405175 and bi.ref ='324.5343.00.1' and bi.lordem =1
20240801@212747.9419 gvdv3rukf8or9q0b86d9gtchrh Query : use flama_phc
20240801@212747.9423 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240801@212747.9457 gvdv3rukf8or9q0b86d9gtchrh Query : use flama_phc
20240801@212747.9460 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 1 valor from td where td.ndoc = 39
20240801@212747.9494 gvdv3rukf8or9q0b86d9gtchrh Query : use flama_phc
20240801@212747.9498 gvdv3rukf8or9q0b86d9gtchrh 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')
20240801@212747.9527 gvdv3rukf8or9q0b86d9gtchrh 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
20240801@212747.9565 gvdv3rukf8or9q0b86d9gtchrh Query : use flama_phc
20240801@212747.9569 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240801@212747.9598 gvdv3rukf8or9q0b86d9gtchrh Query : use flama_phc
20240801@212747.9601 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240801@212747.9632 gvdv3rukf8or9q0b86d9gtchrh Query : use flama_phc
20240801@212747.9635 gvdv3rukf8or9q0b86d9gtchrh Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240801@212747.9679 gvdv3rukf8or9q0b86d9gtchrh Query : use flama_phc
20240801@212747.9681 gvdv3rukf8or9q0b86d9gtchrh Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m. - chaves'
20240801@212747.9731 gvdv3rukf8or9q0b86d9gtchrh Query : use flama_phc
20240801@212747.9734 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from td where ndoc = 39
20240801@212747.9746 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240801@212747.9760 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.9776 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212747.9795 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.9809 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212747.9837 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.9851 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212747.9863 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212747.9933 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212747.9945 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212747.9960 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212747.9975 gvdv3rukf8or9q0b86d9gtchrh Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66abe6897666abefc3f0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240801@212748.1550 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.1710 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212748.2030 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240801@212748.2150 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240801@212748.2260 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240801@212748.3100 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240801@212748.3730 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240801@212748.3850 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240801@212748.3990 gvdv3rukf8or9q0b86d9gtchrh Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66abe6897666abefc3f0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240801@212748.6580 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 fno valor from wsftdata order by fno desc
20240801@212748.6740 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.6910 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212748.7140 gvdv3rukf8or9q0b86d9gtchrh Query : select 'normal' from dummy
20240801@212748.7290 gvdv3rukf8or9q0b86d9gtchrh Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66abe6897666abefc3f0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',166,101621,0,'2024-08-01',39,'euro',0,0,2024 ,?,?)
20240801@212748.1109 gvdv3rukf8or9q0b86d9gtchrh Query : use flama_phc
20240801@212748.1113 gvdv3rukf8or9q0b86d9gtchrh Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240801@212748.1134 gvdv3rukf8or9q0b86d9gtchrh 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.5343.00.1'
20240801@212748.1148 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.1164 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212748.1190 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.1205 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212748.1214 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212748.1226 gvdv3rukf8or9q0b86d9gtchrh Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240801@212748.1239 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.1253 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212748.1265 gvdv3rukf8or9q0b86d9gtchrh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe7622566abefc41e','aut66abe6897666abefc3f0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212748.1269 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.1283 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212748.1312 gvdv3rukf8or9q0b86d9gtchrh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66abe7622566abefc41e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66abe6897666abefc3f0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240801@212748.1571 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.1588 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212748.1613 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.1627 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212748.1636 gvdv3rukf8or9q0b86d9gtchrh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212748.1648 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.1663 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212748.1675 gvdv3rukf8or9q0b86d9gtchrh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe7965066abefc428','aut66abe6897666abefc3f0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212748.1679 gvdv3rukf8or9q0b86d9gtchrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.1693 gvdv3rukf8or9q0b86d9gtchrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212748.1722 gvdv3rukf8or9q0b86d9gtchrh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66abe7965066abefc428',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66abe6897666abefc3f0' ,0,0 ,2,23.00,20000,?,?,?)
20240801@212748.1978 gvdv3rukf8or9q0b86d9gtchrh Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66abe6897666abefc3f0','2405175','wait',39,'adm09112754980.682000002')
20240801@212748.2056 gvdv3rukf8or9q0b86d9gtchrh Query : use flama_phc
20240801@212748.2059 gvdv3rukf8or9q0b86d9gtchrh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240801@212748.2090 gvdv3rukf8or9q0b86d9gtchrh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1336';
20240801@212748.2115 gvdv3rukf8or9q0b86d9gtchrh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1336';
20240801@212748.2155 gvdv3rukf8or9q0b86d9gtchrh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1336';
20240801@212748.2176 gvdv3rukf8or9q0b86d9gtchrh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1336';
20240801@212748.3142 0jpqk1mg6mg7amd6f7jlhgk7ki Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240801@212748.3406 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240801@212748.3938 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1337';
20240801@212748.3994 0jpqk1mg6mg7amd6f7jlhgk7ki Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1337';
20240801@212748.4039 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1337';
20240801@212748.4061 0jpqk1mg6mg7amd6f7jlhgk7ki Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1337';
20240801@212748.4104 0jpqk1mg6mg7amd6f7jlhgk7ki Query : use flama_phc
20240801@212748.4107 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240801@212748.4166 0jpqk1mg6mg7amd6f7jlhgk7ki Query : use flama_phc
20240801@212748.4169 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select no, estab,szadrsdesc from szadrs where u_coddest=4500
20240801@212748.4259 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240801@212748.4281 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2051 and bo.obrano = 2405176 and bi.ref ='324.5343.00.1' and bi.lordem =1
20240801@212748.4615 0jpqk1mg6mg7amd6f7jlhgk7ki Query : use flama_phc
20240801@212748.4619 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240801@212748.4650 0jpqk1mg6mg7amd6f7jlhgk7ki Query : use flama_phc
20240801@212748.4654 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 1 valor from td where td.ndoc = 39
20240801@212748.4683 0jpqk1mg6mg7amd6f7jlhgk7ki Query : use flama_phc
20240801@212748.4685 0jpqk1mg6mg7amd6f7jlhgk7ki 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')
20240801@212748.4715 0jpqk1mg6mg7amd6f7jlhgk7ki 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
20240801@212748.4749 0jpqk1mg6mg7amd6f7jlhgk7ki Query : use flama_phc
20240801@212748.4751 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240801@212748.4780 0jpqk1mg6mg7amd6f7jlhgk7ki Query : use flama_phc
20240801@212748.4783 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240801@212748.4812 0jpqk1mg6mg7amd6f7jlhgk7ki Query : use flama_phc
20240801@212748.4815 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240801@212748.4853 0jpqk1mg6mg7amd6f7jlhgk7ki Query : use flama_phc
20240801@212748.4856 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - portimão'
20240801@212748.4900 0jpqk1mg6mg7amd6f7jlhgk7ki Query : use flama_phc
20240801@212748.4902 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from td where ndoc = 39
20240801@212748.4914 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240801@212748.4928 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.4944 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212748.4964 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.4978 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212748.5006 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.5020 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212748.5032 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212748.5102 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212748.5115 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.5129 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212748.5146 0jpqk1mg6mg7amd6f7jlhgk7ki Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66abe6001466abefc47a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240801@212748.5324 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.5339 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212748.5372 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240801@212748.5384 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240801@212748.5395 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240801@212748.5407 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240801@212748.5418 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240801@212748.5430 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240801@212748.5443 0jpqk1mg6mg7amd6f7jlhgk7ki Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66abe6001466abefc47a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240801@212748.5707 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 fno valor from wsftdata order by fno desc
20240801@212748.5726 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.5748 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212748.5774 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 'normal' from dummy
20240801@212748.5791 0jpqk1mg6mg7amd6f7jlhgk7ki Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66abe6001466abefc47a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',167,101621,0,'2024-08-01',39,'euro',0,0,2024 ,?,?)
20240801@212748.6116 0jpqk1mg6mg7amd6f7jlhgk7ki Query : use flama_phc
20240801@212748.6119 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240801@212748.6141 0jpqk1mg6mg7amd6f7jlhgk7ki 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.5343.00.1'
20240801@212748.6155 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.6172 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212748.6197 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.6212 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212748.6221 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212748.6233 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240801@212748.6246 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.6262 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212748.6276 0jpqk1mg6mg7amd6f7jlhgk7ki Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe0357966abefc498','aut66abe6001466abefc47a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212748.6280 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.6296 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212748.6324 0jpqk1mg6mg7amd6f7jlhgk7ki Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66abe0357966abefc498',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66abe6001466abefc47a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240801@212748.6828 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.6856 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212748.6882 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.6896 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212748.6905 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212748.6918 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.6932 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212748.6944 0jpqk1mg6mg7amd6f7jlhgk7ki Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe7683866abefc4a8','aut66abe6001466abefc47a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212748.6948 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.6963 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212748.6990 0jpqk1mg6mg7amd6f7jlhgk7ki Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66abe7683866abefc4a8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66abe6001466abefc47a' ,0,0 ,2,23.00,20000,?,?,?)
20240801@212748.7236 0jpqk1mg6mg7amd6f7jlhgk7ki Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66abe6001466abefc47a','2405176','wait',39,'adm09112754980.682000002')
20240801@212748.7308 0jpqk1mg6mg7amd6f7jlhgk7ki Query : use flama_phc
20240801@212748.7311 0jpqk1mg6mg7amd6f7jlhgk7ki Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240801@212748.7344 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1337';
20240801@212748.7370 0jpqk1mg6mg7amd6f7jlhgk7ki Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1337';
20240801@212748.7407 0jpqk1mg6mg7amd6f7jlhgk7ki Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1337';
20240801@212748.7430 0jpqk1mg6mg7amd6f7jlhgk7ki Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1337';
20240801@212748.7890 9f999ad76fjnvdj7rbnbjuc3n4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240801@212748.7900 9f999ad76fjnvdj7rbnbjuc3n4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240801@212748.7950 9f999ad76fjnvdj7rbnbjuc3n4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1338';
20240801@212748.8000 9f999ad76fjnvdj7rbnbjuc3n4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1338';
20240801@212748.8048 9f999ad76fjnvdj7rbnbjuc3n4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1338';
20240801@212748.8072 9f999ad76fjnvdj7rbnbjuc3n4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1338';
20240801@212748.8120 9f999ad76fjnvdj7rbnbjuc3n4 Query : use flama_phc
20240801@212748.8123 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240801@212748.8194 9f999ad76fjnvdj7rbnbjuc3n4 Query : use flama_phc
20240801@212748.8197 9f999ad76fjnvdj7rbnbjuc3n4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=3145
20240801@212748.8277 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240801@212748.8298 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2051 and bo.obrano = 2405177 and bi.ref ='324.5343.00.1' and bi.lordem =1
20240801@212748.8638 9f999ad76fjnvdj7rbnbjuc3n4 Query : use flama_phc
20240801@212748.8641 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240801@212748.8678 9f999ad76fjnvdj7rbnbjuc3n4 Query : use flama_phc
20240801@212748.8681 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 1 valor from td where td.ndoc = 39
20240801@212748.8714 9f999ad76fjnvdj7rbnbjuc3n4 Query : use flama_phc
20240801@212748.8717 9f999ad76fjnvdj7rbnbjuc3n4 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')
20240801@212748.8748 9f999ad76fjnvdj7rbnbjuc3n4 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
20240801@212748.8787 9f999ad76fjnvdj7rbnbjuc3n4 Query : use flama_phc
20240801@212748.8790 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240801@212748.8821 9f999ad76fjnvdj7rbnbjuc3n4 Query : use flama_phc
20240801@212748.8824 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240801@212748.8854 9f999ad76fjnvdj7rbnbjuc3n4 Query : use flama_phc
20240801@212748.8857 9f999ad76fjnvdj7rbnbjuc3n4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240801@212748.8900 9f999ad76fjnvdj7rbnbjuc3n4 Query : use flama_phc
20240801@212748.8903 9f999ad76fjnvdj7rbnbjuc3n4 Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - caldas da rainha'
20240801@212748.8953 9f999ad76fjnvdj7rbnbjuc3n4 Query : use flama_phc
20240801@212748.8957 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from td where ndoc = 39
20240801@212748.8970 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240801@212748.8984 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.9003 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212748.9024 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.9041 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212748.9072 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.9087 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212748.9115 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212748.9187 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240801@212748.9201 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212748.9217 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240801@212748.9233 9f999ad76fjnvdj7rbnbjuc3n4 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66abe0798866abefc4de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240801@212748.9545 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212749.4870 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240801@212749.5660 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240801@212749.5800 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240801@212749.5930 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240801@212749.6060 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240801@212749.6190 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240801@212749.6320 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240801@212749.6460 9f999ad76fjnvdj7rbnbjuc3n4 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66abe0798866abefc4de',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240801@212749.9100 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 fno valor from wsftdata order by fno desc
20240801@212749.9270 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212749.9450 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240801@212749.9720 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 'normal' from dummy
20240801@212749.9890 9f999ad76fjnvdj7rbnbjuc3n4 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66abe0798866abefc4de',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',168,101621,0,'2024-08-01',39,'euro',0,0,2024 ,?,?)
20240801@212749.1265 9f999ad76fjnvdj7rbnbjuc3n4 Query : use flama_phc
20240801@212749.1269 9f999ad76fjnvdj7rbnbjuc3n4 Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240801@212749.1292 9f999ad76fjnvdj7rbnbjuc3n4 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.5343.00.1'
20240801@212749.1307 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212749.1324 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212749.1352 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212749.1368 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212749.1377 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212749.1391 9f999ad76fjnvdj7rbnbjuc3n4 Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240801@212749.1404 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212749.1420 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212749.1433 9f999ad76fjnvdj7rbnbjuc3n4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe8611266abefc522','aut66abe0798866abefc4de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212749.1437 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212749.1453 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212749.1485 9f999ad76fjnvdj7rbnbjuc3n4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66abe8611266abefc522',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66abe0798866abefc4de' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240801@212749.1739 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212749.1756 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212749.1784 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212749.1801 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212749.1810 9f999ad76fjnvdj7rbnbjuc3n4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240801@212749.1824 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212749.1839 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240801@212749.1852 9f999ad76fjnvdj7rbnbjuc3n4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66abe1253166abefc52c','aut66abe0798866abefc4de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240801@212749.1856 9f999ad76fjnvdj7rbnbjuc3n4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240801@212749.1872 9f999ad76fjnvdj7rbnbjuc3n4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240801@212749.1903 9f999ad76fjnvdj7rbnbjuc3n4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66abe1253166abefc52c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66abe0798866abefc4de' ,0,0 ,2,23.00,20000,?,?,?)
20240801@212749.2136 9f999ad76fjnvdj7rbnbjuc3n4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66abe0798866abefc4de','2405177','wait',39,'adm09112754980.682000002')
20240801@212749.2216 9f999ad76fjnvdj7rbnbjuc3n4 Query : use flama_phc
20240801@212749.2219 9f999ad76fjnvdj7rbnbjuc3n4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240801@212749.2253 9f999ad76fjnvdj7rbnbjuc3n4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1338';
20240801@212749.2282 9f999ad76fjnvdj7rbnbjuc3n4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1338';
20240801@212749.2317 9f999ad76fjnvdj7rbnbjuc3n4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1338';
20240801@212749.2341 9f999ad76fjnvdj7rbnbjuc3n4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1338';
20240801@212749.2826 3vjo7ee5ttna7pbh29vq3som2g Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240801@212749.2839 3vjo7ee5ttna7pbh29vq3som2g Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240801@212749.2887 3vjo7ee5ttna7pbh29vq3som2g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1339';
20240801@212749.2937 3vjo7ee5ttna7pbh29vq3som2g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1339';
20240801@212749.2986 3vjo7ee5ttna7pbh29vq3som2g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1339';
20240801@212749.3008 3vjo7ee5ttna7pbh29vq3som2g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1339';
20240801@212749.3056 3vjo7ee5ttna7pbh29vq3som2g Query : use flama_phc
20240801@212749.3059 3vjo7ee5ttna7pbh29vq3som2g Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240801@212749.3125 3vjo7ee5ttna7pbh29vq3som2g Query : use flama_phc
20240801@212749.3128 3vjo7ee5ttna7pbh29vq3som2g Query : select no, estab,szadrsdesc from szadrs where u_coddest=7254
20240801@212749.3170 3vjo7ee5ttna7pbh29vq3som2g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240801@212749.3190 3vjo7ee5ttna7pbh29vq3som2g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2051 and bo.obrano = 2405179 and bi.ref ='324.5343.00.1' and bi.lordem =1
20240801@212749.3523 3vjo7ee5ttna7pbh29vq3som2g Query : use flama_phc
20240801@212749.3526 3vjo7ee5ttna7pbh29vq3som2g Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240801@212749.3557 3vjo7ee5ttna7pbh29vq3som2g Query : use flama_phc
20240801@212749.3560 3vjo7ee5ttna7pbh29vq3som2g Query : select top 1 1 valor from td where td.ndoc = 39
20240801@212749.3681 3vjo7ee5ttna7pbh29vq3som2g Query : use flama_phc
20240801@212749.3686 3vjo7ee5ttna7pbh29vq3som2g 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')
20240801@212749.3719 3vjo7ee5ttna7pbh29vq3som2g 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
20240801@212749.3754 3vjo7ee5ttna7pbh29vq3som2g Query : use flama_phc
20240801@212749.3758 3vjo7ee5ttna7pbh29vq3som2g Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240801@212749.3787 3vjo7ee5ttna7pbh29vq3som2g Query : use flama_phc
20240801@212749.3790 3vjo7ee5ttna7pbh29vq3som2g Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240801@212749.3819 3vjo7ee5ttna7pbh29vq3som2g Query : use flama_phc
20240801@212749.3822 3vjo7ee5ttna7pbh29vq3som2g Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240801@212749.3861 3vjo7ee5ttna7pbh29vq3som2g Query : use flama_phc
20240801@212749.3864 3vjo7ee5ttna7pbh29vq3som2g Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m alverca'
20240801@212749.3908 3vjo7ee5ttna7pbh29vq3som2g Query : use flama_phc
20240801@212749.3911 3vjo7ee5ttna7pbh29vq3som2g Query : select 1 valor from td where ndoc = 39
