20240813@174334.9820 7oub0ev5lbqeb5rj7gerlgrded Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1520';
20240813@174334.1032 7oub0ev5lbqeb5rj7gerlgrded Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1520';
20240813@174334.1056 7oub0ev5lbqeb5rj7gerlgrded Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1520';
20240813@174334.1118 7oub0ev5lbqeb5rj7gerlgrded Query : use flama_phc
20240813@174334.1122 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240813@174334.1195 7oub0ev5lbqeb5rj7gerlgrded Query : use flama_phc
20240813@174334.1198 7oub0ev5lbqeb5rj7gerlgrded Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240813@174334.1237 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4723.00.2'
20240813@174334.1400 7oub0ev5lbqeb5rj7gerlgrded Query : use flama_phc
20240813@174334.1404 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240813@174334.1441 7oub0ev5lbqeb5rj7gerlgrded Query : use flama_phc
20240813@174334.1444 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 1 valor from td where td.ndoc = 39
20240813@174334.1473 7oub0ev5lbqeb5rj7gerlgrded Query : use flama_phc
20240813@174334.1476 7oub0ev5lbqeb5rj7gerlgrded 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')
20240813@174334.1510 7oub0ev5lbqeb5rj7gerlgrded 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
20240813@174334.1567 7oub0ev5lbqeb5rj7gerlgrded Query : use flama_phc
20240813@174334.1570 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240813@174334.1620 7oub0ev5lbqeb5rj7gerlgrded Query : use flama_phc
20240813@174334.1623 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240813@174334.1674 7oub0ev5lbqeb5rj7gerlgrded Query : use flama_phc
20240813@174334.1677 7oub0ev5lbqeb5rj7gerlgrded Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240813@174334.1742 7oub0ev5lbqeb5rj7gerlgrded Query : use flama_phc
20240813@174334.1746 7oub0ev5lbqeb5rj7gerlgrded Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240813@174334.1810 7oub0ev5lbqeb5rj7gerlgrded Query : use flama_phc
20240813@174334.1824 7oub0ev5lbqeb5rj7gerlgrded Query : select 1 valor from td where ndoc = 39
20240813@174334.1837 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240813@174334.1851 7oub0ev5lbqeb5rj7gerlgrded Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.1867 7oub0ev5lbqeb5rj7gerlgrded Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174334.1887 7oub0ev5lbqeb5rj7gerlgrded Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.1901 7oub0ev5lbqeb5rj7gerlgrded Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174334.1931 7oub0ev5lbqeb5rj7gerlgrded Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.1947 7oub0ev5lbqeb5rj7gerlgrded Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174334.1959 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174334.2027 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174334.2039 7oub0ev5lbqeb5rj7gerlgrded Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.2053 7oub0ev5lbqeb5rj7gerlgrded Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174334.2069 7oub0ev5lbqeb5rj7gerlgrded Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66bb89493866bb8d362f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240813@174334.2249 7oub0ev5lbqeb5rj7gerlgrded Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.2265 7oub0ev5lbqeb5rj7gerlgrded Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174334.2298 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240813@174334.2310 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240813@174334.2321 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240813@174334.2333 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240813@174334.2344 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240813@174334.2355 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240813@174334.2367 7oub0ev5lbqeb5rj7gerlgrded Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66bb89493866bb8d362f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240813@174334.2620 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 fno valor from wsftdata order by fno desc
20240813@174334.2639 7oub0ev5lbqeb5rj7gerlgrded Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.2657 7oub0ev5lbqeb5rj7gerlgrded Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174334.2679 7oub0ev5lbqeb5rj7gerlgrded Query : select 'normal' from dummy
20240813@174334.2696 7oub0ev5lbqeb5rj7gerlgrded Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66bb89493866bb8d362f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',334,100810,0,'2024-08-13',39,'euro',0,0,2024 ,?,?)
20240813@174334.3474 7oub0ev5lbqeb5rj7gerlgrded Query : use flama_phc
20240813@174334.3517 7oub0ev5lbqeb5rj7gerlgrded Query : select st.usalote valor from st where st.ref = '324.4723.00.2'
20240813@174334.4047 7oub0ev5lbqeb5rj7gerlgrded 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.4723.00.2'
20240813@174334.4195 7oub0ev5lbqeb5rj7gerlgrded Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.4210 7oub0ev5lbqeb5rj7gerlgrded Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174334.4235 7oub0ev5lbqeb5rj7gerlgrded Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.4249 7oub0ev5lbqeb5rj7gerlgrded Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174334.4257 7oub0ev5lbqeb5rj7gerlgrded Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174334.4269 7oub0ev5lbqeb5rj7gerlgrded Query : select sestamp valor from se where ref ='324.4723.00.2' and lote = 'r2200682200a'
20240813@174334.4282 7oub0ev5lbqeb5rj7gerlgrded Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.4296 7oub0ev5lbqeb5rj7gerlgrded Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174334.4308 7oub0ev5lbqeb5rj7gerlgrded Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb87207166bb8d3668','aut66bb89493866bb8d362f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174334.4312 7oub0ev5lbqeb5rj7gerlgrded Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.4325 7oub0ev5lbqeb5rj7gerlgrded Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174334.4353 7oub0ev5lbqeb5rj7gerlgrded Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb87207166bb8d3668',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',21.000 ,'aut66bb89493866bb8d362f' ,0,0 ,2,23.00,10000,?,?,?,?)
20240813@174334.4605 7oub0ev5lbqeb5rj7gerlgrded Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66bb89493866bb8d362f','2405373','wait',39,'adm09112754980.682000002')
20240813@174334.4677 7oub0ev5lbqeb5rj7gerlgrded Query : use flama_phc
20240813@174334.4680 7oub0ev5lbqeb5rj7gerlgrded Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240813@174334.4712 7oub0ev5lbqeb5rj7gerlgrded Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1520';
20240813@174334.4738 7oub0ev5lbqeb5rj7gerlgrded Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1520';
20240813@174334.4780 7oub0ev5lbqeb5rj7gerlgrded Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1520';
20240813@174334.4803 7oub0ev5lbqeb5rj7gerlgrded Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1520';
20240813@174334.5322 t8hqn6a019egojr4m17eje47ft Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240813@174334.5335 t8hqn6a019egojr4m17eje47ft Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240813@174334.5383 t8hqn6a019egojr4m17eje47ft Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1521';
20240813@174334.5436 t8hqn6a019egojr4m17eje47ft Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1521';
20240813@174334.5487 t8hqn6a019egojr4m17eje47ft Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1521';
20240813@174334.5511 t8hqn6a019egojr4m17eje47ft Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1521';
20240813@174334.5559 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.5562 t8hqn6a019egojr4m17eje47ft Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240813@174334.5631 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.5634 t8hqn6a019egojr4m17eje47ft Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240813@174334.5674 t8hqn6a019egojr4m17eje47ft Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4840.00.1'
20240813@174334.5839 t8hqn6a019egojr4m17eje47ft Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4840.00.1'
20240813@174334.5858 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.5861 t8hqn6a019egojr4m17eje47ft Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240813@174334.5892 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.5895 t8hqn6a019egojr4m17eje47ft Query : select top 1 1 valor from td where td.ndoc = 39
20240813@174334.5930 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.5933 t8hqn6a019egojr4m17eje47ft 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')
20240813@174334.5964 t8hqn6a019egojr4m17eje47ft 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
20240813@174334.6004 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.6007 t8hqn6a019egojr4m17eje47ft Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240813@174334.6039 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.6042 t8hqn6a019egojr4m17eje47ft Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240813@174334.6077 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.6081 t8hqn6a019egojr4m17eje47ft Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240813@174334.6120 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.6122 t8hqn6a019egojr4m17eje47ft Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240813@174334.6168 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.6171 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from td where ndoc = 39
20240813@174334.6183 t8hqn6a019egojr4m17eje47ft Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240813@174334.6196 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.6211 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174334.6229 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.6243 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174334.6271 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.6286 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174334.6299 t8hqn6a019egojr4m17eje47ft Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174334.6368 t8hqn6a019egojr4m17eje47ft Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174334.6381 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.6395 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174334.6410 t8hqn6a019egojr4m17eje47ft Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66bb89745166bb8d3699' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240813@174334.6585 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.6601 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174334.6635 t8hqn6a019egojr4m17eje47ft Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240813@174334.6646 t8hqn6a019egojr4m17eje47ft Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240813@174334.6658 t8hqn6a019egojr4m17eje47ft Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240813@174334.6669 t8hqn6a019egojr4m17eje47ft Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240813@174334.6681 t8hqn6a019egojr4m17eje47ft Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240813@174334.6693 t8hqn6a019egojr4m17eje47ft Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240813@174334.6705 t8hqn6a019egojr4m17eje47ft Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66bb89745166bb8d3699',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240813@174334.6948 t8hqn6a019egojr4m17eje47ft Query : select top 1 fno valor from wsftdata order by fno desc
20240813@174334.6964 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.6979 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174334.7000 t8hqn6a019egojr4m17eje47ft Query : select 'normal' from dummy
20240813@174334.7014 t8hqn6a019egojr4m17eje47ft Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66bb89745166bb8d3699',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',335,100810,0,'2024-08-13',39,'euro',0,0,2024 ,?,?)
20240813@174334.7293 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.7296 t8hqn6a019egojr4m17eje47ft Query : select st.usalote valor from st where st.ref = '324.4840.00.1'
20240813@174334.7319 t8hqn6a019egojr4m17eje47ft 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.4840.00.1'
20240813@174334.7459 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.7475 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174334.7503 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.7517 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174334.7526 t8hqn6a019egojr4m17eje47ft Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174334.7539 t8hqn6a019egojr4m17eje47ft Query : select sestamp valor from se where ref ='324.4840.00.1' and lote = 'r2400064200a'
20240813@174334.7552 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.7567 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174334.7579 t8hqn6a019egojr4m17eje47ft Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb82453066bb8d36b8','aut66bb89745166bb8d3699' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174334.7583 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.7597 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174334.7625 t8hqn6a019egojr4m17eje47ft Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb82453066bb8d36b8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut66bb89745166bb8d3699' ,0,0 ,2,23.00,10000,?,?,?,?)
20240813@174334.7874 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.7877 t8hqn6a019egojr4m17eje47ft Query : select st.usalote valor from st where st.ref = '324.4840.00.1'
20240813@174334.7896 t8hqn6a019egojr4m17eje47ft 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.4840.00.1'
20240813@174334.7910 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.7926 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174334.7953 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.7968 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174334.7976 t8hqn6a019egojr4m17eje47ft Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174334.7988 t8hqn6a019egojr4m17eje47ft Query : select sestamp valor from se where ref ='324.4840.00.1' and lote = 'r2400064200a'
20240813@174334.8001 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.8016 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174334.8027 t8hqn6a019egojr4m17eje47ft Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb88732466bb8d36c3','aut66bb89745166bb8d3699' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174334.8031 t8hqn6a019egojr4m17eje47ft Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174334.8045 t8hqn6a019egojr4m17eje47ft Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174334.8073 t8hqn6a019egojr4m17eje47ft Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb88732466bb8d36c3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66bb89745166bb8d3699' ,0,0 ,2,23.00,20000,?,?,?,?)
20240813@174334.8319 t8hqn6a019egojr4m17eje47ft Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66bb89745166bb8d3699','2405374','wait',39,'adm09112754980.682000002')
20240813@174334.8395 t8hqn6a019egojr4m17eje47ft Query : use flama_phc
20240813@174334.8399 t8hqn6a019egojr4m17eje47ft Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240813@174334.8429 t8hqn6a019egojr4m17eje47ft Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1521';
20240813@174334.8454 t8hqn6a019egojr4m17eje47ft Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1521';
20240813@174334.8493 t8hqn6a019egojr4m17eje47ft Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1521';
20240813@174334.8515 t8hqn6a019egojr4m17eje47ft Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1521';
20240813@174334.9037 ni1ctea3r2kmlv4c2flcnjpstm Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240813@174334.9048 ni1ctea3r2kmlv4c2flcnjpstm Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240813@174334.9095 ni1ctea3r2kmlv4c2flcnjpstm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1522';
20240813@174334.9225 ni1ctea3r2kmlv4c2flcnjpstm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1522';
20240813@174334.9276 ni1ctea3r2kmlv4c2flcnjpstm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1522';
20240813@174334.9310 ni1ctea3r2kmlv4c2flcnjpstm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1522';
20240813@174334.9360 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174334.9369 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240813@174334.9433 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174334.9436 ni1ctea3r2kmlv4c2flcnjpstm Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240813@174334.9482 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240813@174334.9643 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240813@174334.9669 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174334.9672 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240813@174334.9705 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174334.9710 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 1 valor from td where td.ndoc = 39
20240813@174334.9744 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174334.9747 ni1ctea3r2kmlv4c2flcnjpstm 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')
20240813@174334.9774 ni1ctea3r2kmlv4c2flcnjpstm 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
20240813@174334.9808 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174334.9811 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240813@174334.9840 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174334.9843 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240813@174334.9888 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174334.9891 ni1ctea3r2kmlv4c2flcnjpstm Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240813@174334.9931 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174334.9934 ni1ctea3r2kmlv4c2flcnjpstm Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240813@174334.9982 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174334.9985 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from td where ndoc = 39
20240813@174334.9997 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240813@174335.2000 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.3600 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174335.5500 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.7000 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174335.9900 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.1130 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174335.1270 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174335.1980 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174335.2110 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.2260 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174335.2420 ni1ctea3r2kmlv4c2flcnjpstm Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66bb82625966bb8d3703' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240813@174335.4200 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.4360 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174335.4700 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240813@174335.4820 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240813@174335.4940 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240813@174335.5090 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240813@174335.5220 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240813@174335.5340 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240813@174335.5460 ni1ctea3r2kmlv4c2flcnjpstm Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66bb82625966bb8d3703',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240813@174335.9290 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 fno valor from wsftdata order by fno desc
20240813@174335.1168 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.1245 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174335.1328 ni1ctea3r2kmlv4c2flcnjpstm Query : select 'normal' from dummy
20240813@174335.1460 ni1ctea3r2kmlv4c2flcnjpstm Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66bb82625966bb8d3703',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',336,100810,0,'2024-08-13',39,'euro',0,0,2024 ,?,?)
20240813@174335.2236 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174335.2239 ni1ctea3r2kmlv4c2flcnjpstm Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240813@174335.2261 ni1ctea3r2kmlv4c2flcnjpstm 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.4970.00.1'
20240813@174335.2407 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.2424 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174335.2449 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.2464 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174335.2474 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174335.2487 ni1ctea3r2kmlv4c2flcnjpstm Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400205200a'
20240813@174335.2502 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.2516 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174335.2528 ni1ctea3r2kmlv4c2flcnjpstm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb85495866bb8d373d','aut66bb82625966bb8d3703' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174335.2532 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.2546 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174335.2573 ni1ctea3r2kmlv4c2flcnjpstm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb85495866bb8d373d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66bb82625966bb8d3703' ,0,0 ,2,23.00,10000,?,?,?,?)
20240813@174335.2820 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174335.2823 ni1ctea3r2kmlv4c2flcnjpstm Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240813@174335.2842 ni1ctea3r2kmlv4c2flcnjpstm 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.4970.00.1'
20240813@174335.2855 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.2871 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174335.2896 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.2911 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174335.2919 ni1ctea3r2kmlv4c2flcnjpstm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174335.2934 ni1ctea3r2kmlv4c2flcnjpstm Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400205200a'
20240813@174335.2947 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.2971 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174335.2983 ni1ctea3r2kmlv4c2flcnjpstm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb89451066bb8d3747','aut66bb82625966bb8d3703' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174335.2987 ni1ctea3r2kmlv4c2flcnjpstm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.3004 ni1ctea3r2kmlv4c2flcnjpstm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174335.3034 ni1ctea3r2kmlv4c2flcnjpstm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb89451066bb8d3747',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut66bb82625966bb8d3703' ,0,0 ,2,23.00,20000,?,?,?,?)
20240813@174335.3273 ni1ctea3r2kmlv4c2flcnjpstm Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66bb82625966bb8d3703','2405375','wait',39,'adm09112754980.682000002')
20240813@174335.3348 ni1ctea3r2kmlv4c2flcnjpstm Query : use flama_phc
20240813@174335.3351 ni1ctea3r2kmlv4c2flcnjpstm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240813@174335.3407 ni1ctea3r2kmlv4c2flcnjpstm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1522';
20240813@174335.3435 ni1ctea3r2kmlv4c2flcnjpstm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1522';
20240813@174335.3474 ni1ctea3r2kmlv4c2flcnjpstm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1522';
20240813@174335.3498 ni1ctea3r2kmlv4c2flcnjpstm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1522';
20240813@174335.4047 c6sk6v1351mb5rd8gb7k1536u8 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240813@174335.4061 c6sk6v1351mb5rd8gb7k1536u8 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240813@174335.4111 c6sk6v1351mb5rd8gb7k1536u8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1523';
20240813@174335.4164 c6sk6v1351mb5rd8gb7k1536u8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1523';
20240813@174335.4218 c6sk6v1351mb5rd8gb7k1536u8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1523';
20240813@174335.4243 c6sk6v1351mb5rd8gb7k1536u8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1523';
20240813@174335.4355 c6sk6v1351mb5rd8gb7k1536u8 Query : use flama_phc
20240813@174335.4359 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240813@174335.4430 c6sk6v1351mb5rd8gb7k1536u8 Query : use flama_phc
20240813@174335.4433 c6sk6v1351mb5rd8gb7k1536u8 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240813@174335.4554 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20240813@174335.4910 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20240813@174335.4933 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20240813@174335.4955 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20240813@174335.4978 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20240813@174335.4997 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20240813@174335.5017 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20240813@174335.5037 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20240813@174335.5081 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20240813@174335.5103 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20240813@174335.5123 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20240813@174335.5144 c6sk6v1351mb5rd8gb7k1536u8 Query : use flama_phc
20240813@174335.5148 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240813@174335.5183 c6sk6v1351mb5rd8gb7k1536u8 Query : use flama_phc
20240813@174335.5187 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 1 valor from td where td.ndoc = 39
20240813@174335.5229 c6sk6v1351mb5rd8gb7k1536u8 Query : use flama_phc
20240813@174335.5232 c6sk6v1351mb5rd8gb7k1536u8 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')
20240813@174335.5261 c6sk6v1351mb5rd8gb7k1536u8 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
20240813@174335.5301 c6sk6v1351mb5rd8gb7k1536u8 Query : use flama_phc
20240813@174335.5304 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240813@174335.5340 c6sk6v1351mb5rd8gb7k1536u8 Query : use flama_phc
20240813@174335.5343 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240813@174335.5382 c6sk6v1351mb5rd8gb7k1536u8 Query : use flama_phc
20240813@174335.5386 c6sk6v1351mb5rd8gb7k1536u8 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240813@174335.5429 c6sk6v1351mb5rd8gb7k1536u8 Query : use flama_phc
20240813@174335.5432 c6sk6v1351mb5rd8gb7k1536u8 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240813@174335.5477 c6sk6v1351mb5rd8gb7k1536u8 Query : use flama_phc
20240813@174335.5480 c6sk6v1351mb5rd8gb7k1536u8 Query : select 1 valor from td where ndoc = 39
20240813@174335.5538 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240813@174335.5555 c6sk6v1351mb5rd8gb7k1536u8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.5578 c6sk6v1351mb5rd8gb7k1536u8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174335.5598 c6sk6v1351mb5rd8gb7k1536u8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.5615 c6sk6v1351mb5rd8gb7k1536u8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174335.5653 c6sk6v1351mb5rd8gb7k1536u8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.5668 c6sk6v1351mb5rd8gb7k1536u8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174335.5681 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174335.5752 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174335.5766 c6sk6v1351mb5rd8gb7k1536u8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.5784 c6sk6v1351mb5rd8gb7k1536u8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174335.5802 c6sk6v1351mb5rd8gb7k1536u8 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66bb83979066bb8d378a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240813@174335.5997 c6sk6v1351mb5rd8gb7k1536u8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.6014 c6sk6v1351mb5rd8gb7k1536u8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174335.6049 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240813@174335.6062 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240813@174335.6081 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240813@174335.6094 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240813@174335.6106 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240813@174335.6118 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240813@174335.6129 c6sk6v1351mb5rd8gb7k1536u8 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66bb83979066bb8d378a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240813@174335.6368 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 fno valor from wsftdata order by fno desc
20240813@174335.6386 c6sk6v1351mb5rd8gb7k1536u8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.6402 c6sk6v1351mb5rd8gb7k1536u8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174335.6426 c6sk6v1351mb5rd8gb7k1536u8 Query : select 'normal' from dummy
20240813@174335.6484 c6sk6v1351mb5rd8gb7k1536u8 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66bb83979066bb8d378a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',337,100810,0,'2024-08-13',39,'euro',0,0,2024 ,?,?)
20240813@174335.6796 c6sk6v1351mb5rd8gb7k1536u8 Query : use flama_phc
20240813@174335.6800 c6sk6v1351mb5rd8gb7k1536u8 Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20240813@174335.6824 c6sk6v1351mb5rd8gb7k1536u8 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.692.00.01'
20240813@174335.7017 c6sk6v1351mb5rd8gb7k1536u8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.7042 c6sk6v1351mb5rd8gb7k1536u8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174335.7070 c6sk6v1351mb5rd8gb7k1536u8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.7084 c6sk6v1351mb5rd8gb7k1536u8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174335.7093 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174335.7107 c6sk6v1351mb5rd8gb7k1536u8 Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400062200a'
20240813@174335.7118 c6sk6v1351mb5rd8gb7k1536u8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174335.7136 c6sk6v1351mb5rd8gb7k1536u8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174335.7149 c6sk6v1351mb5rd8gb7k1536u8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb86577066bb8d37ad','aut66bb83979066bb8d378a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174335.7172 c6sk6v1351mb5rd8gb7k1536u8 Query : use flama_phc
20240813@174335.7191 c6sk6v1351mb5rd8gb7k1536u8 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20240813@174335.8382 c6sk6v1351mb5rd8gb7k1536u8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1523';
20240813@174335.8420 c6sk6v1351mb5rd8gb7k1536u8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1523';
20240813@174335.8961 1ocnak61is9f94mchneta46dd8 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240813@174335.8972 1ocnak61is9f94mchneta46dd8 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240813@174335.9031 1ocnak61is9f94mchneta46dd8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1524';
20240813@174335.9083 1ocnak61is9f94mchneta46dd8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1524';
20240813@174335.9136 1ocnak61is9f94mchneta46dd8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1524';
20240813@174335.9160 1ocnak61is9f94mchneta46dd8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1524';
20240813@174335.9211 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174335.9214 1ocnak61is9f94mchneta46dd8 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240813@174335.9284 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174335.9287 1ocnak61is9f94mchneta46dd8 Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20240813@174335.9416 1ocnak61is9f94mchneta46dd8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1690.00.1'
20240813@174335.9581 1ocnak61is9f94mchneta46dd8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20240813@174335.9762 1ocnak61is9f94mchneta46dd8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4421.00.1'
20240813@174335.9916 1ocnak61is9f94mchneta46dd8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20240813@174336.3500 1ocnak61is9f94mchneta46dd8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1608.00.1'
20240813@174336.1540 1ocnak61is9f94mchneta46dd8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240813@174336.2710 1ocnak61is9f94mchneta46dd8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20240813@174336.1481 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.1486 1ocnak61is9f94mchneta46dd8 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240813@174336.1527 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.1530 1ocnak61is9f94mchneta46dd8 Query : select top 1 1 valor from td where td.ndoc = 39
20240813@174336.1559 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.1562 1ocnak61is9f94mchneta46dd8 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')
20240813@174336.1590 1ocnak61is9f94mchneta46dd8 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
20240813@174336.1624 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.1627 1ocnak61is9f94mchneta46dd8 Query : select top 1 ~inactivo valor from cl where no = '102253' and estab = 0 order by inactivo desc
20240813@174336.1928 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.1931 1ocnak61is9f94mchneta46dd8 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240813@174336.1963 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.1966 1ocnak61is9f94mchneta46dd8 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240813@174336.2006 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.2009 1ocnak61is9f94mchneta46dd8 Query : select szadrsstamp valor from szadrs where szadrsdesc='fnac - entrega'
20240813@174336.2059 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.2062 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from td where ndoc = 39
20240813@174336.2075 1ocnak61is9f94mchneta46dd8 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240813@174336.2090 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.2107 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174336.2127 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.2141 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174336.2172 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.2187 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174336.2200 1ocnak61is9f94mchneta46dd8 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174336.2272 1ocnak61is9f94mchneta46dd8 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174336.2286 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.2301 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174336.2326 1ocnak61is9f94mchneta46dd8 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66bb81421866bb8d3835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240813@174336.2503 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.2521 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174336.2564 1ocnak61is9f94mchneta46dd8 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240813@174336.2577 1ocnak61is9f94mchneta46dd8 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240813@174336.2590 1ocnak61is9f94mchneta46dd8 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240813@174336.2602 1ocnak61is9f94mchneta46dd8 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240813@174336.2616 1ocnak61is9f94mchneta46dd8 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240813@174336.2629 1ocnak61is9f94mchneta46dd8 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240813@174336.2641 1ocnak61is9f94mchneta46dd8 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66bb81421866bb8d3835',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240813@174336.2876 1ocnak61is9f94mchneta46dd8 Query : select top 1 fno valor from wsftdata order by fno desc
20240813@174336.2892 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.2908 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174336.2930 1ocnak61is9f94mchneta46dd8 Query : select 'normal' from dummy
20240813@174336.2945 1ocnak61is9f94mchneta46dd8 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66bb81421866bb8d3835',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',337,102253,0,'2024-08-13',39,'euro',0,0,2024 ,?,?)
20240813@174336.3217 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.3220 1ocnak61is9f94mchneta46dd8 Query : select st.usalote valor from st where st.ref = '324.1690.00.1'
20240813@174336.3241 1ocnak61is9f94mchneta46dd8 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.1690.00.1'
20240813@174336.3440 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.3462 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.3802 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.3819 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.3868 1ocnak61is9f94mchneta46dd8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174336.3898 1ocnak61is9f94mchneta46dd8 Query : select sestamp valor from se where ref ='324.1690.00.1' and lote = 'r2100755200a'
20240813@174336.3921 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.4002 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.4202 1ocnak61is9f94mchneta46dd8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb85988066bb8d385f','aut66bb81421866bb8d3835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174336.4251 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.4271 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.4298 1ocnak61is9f94mchneta46dd8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb85988066bb8d385f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66bb81421866bb8d3835' ,0,0 ,2,23.00,10000,?,?,?,?)
20240813@174336.4561 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.4578 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.4603 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.4617 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.4626 1ocnak61is9f94mchneta46dd8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174336.4638 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.4652 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.4664 1ocnak61is9f94mchneta46dd8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb80751966bb8d3871','aut66bb81421866bb8d3835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174336.4668 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.4682 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.4719 1ocnak61is9f94mchneta46dd8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66bb80751966bb8d3871',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66bb81421866bb8d3835' ,0,0 ,2,23.00,20000,?,?,?)
20240813@174336.4957 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.4967 1ocnak61is9f94mchneta46dd8 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240813@174336.4987 1ocnak61is9f94mchneta46dd8 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.727.00.01'
20240813@174336.5001 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.5016 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.5041 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.5056 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.5064 1ocnak61is9f94mchneta46dd8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174336.5077 1ocnak61is9f94mchneta46dd8 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2300534200a'
20240813@174336.5098 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.5112 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.5123 1ocnak61is9f94mchneta46dd8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb87789166bb8d387c','aut66bb81421866bb8d3835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174336.5127 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.5141 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.5167 1ocnak61is9f94mchneta46dd8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb87789166bb8d387c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66bb81421866bb8d3835' ,0,0 ,2,23.00,40000,?,?,?,?)
20240813@174336.5404 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.5419 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.5445 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.5459 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.5467 1ocnak61is9f94mchneta46dd8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174336.5539 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.5555 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.5567 1ocnak61is9f94mchneta46dd8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb85271566bb8d3887','aut66bb81421866bb8d3835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174336.5571 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.5588 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.5618 1ocnak61is9f94mchneta46dd8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66bb85271566bb8d3887',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66bb81421866bb8d3835' ,0,0 ,2,23.00,50000,?,?,?)
20240813@174336.5996 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.6013 1ocnak61is9f94mchneta46dd8 Query : select st.usalote valor from st where st.ref = '324.4421.00.1'
20240813@174336.6192 1ocnak61is9f94mchneta46dd8 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.4421.00.1'
20240813@174336.6380 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.6398 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.6423 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.6437 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.6446 1ocnak61is9f94mchneta46dd8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174336.6457 1ocnak61is9f94mchneta46dd8 Query : select sestamp valor from se where ref ='324.4421.00.1' and lote = 'r2100324100a'
20240813@174336.6472 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.6489 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.6500 1ocnak61is9f94mchneta46dd8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb89413766bb8d389e','aut66bb81421866bb8d3835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174336.6504 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.6518 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.6546 1ocnak61is9f94mchneta46dd8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb89413766bb8d389e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',9.000 ,'aut66bb81421866bb8d3835' ,0,0 ,2,23.00,70000,?,?,?,?)
20240813@174336.6801 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.6804 1ocnak61is9f94mchneta46dd8 Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20240813@174336.6824 1ocnak61is9f94mchneta46dd8 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.4960.00.1'
20240813@174336.6978 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.6993 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.7066 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.7083 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.7091 1ocnak61is9f94mchneta46dd8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174336.7103 1ocnak61is9f94mchneta46dd8 Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20240813@174336.7117 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.7130 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.7142 1ocnak61is9f94mchneta46dd8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb86937266bb8d38ad','aut66bb81421866bb8d3835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174336.7145 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.7159 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.7206 1ocnak61is9f94mchneta46dd8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb86937266bb8d38ad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66bb81421866bb8d3835' ,0,0 ,2,23.00,80000,?,?,?,?)
20240813@174336.7461 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.7464 1ocnak61is9f94mchneta46dd8 Query : select st.usalote valor from st where st.ref = '324.1608.00.1'
20240813@174336.7483 1ocnak61is9f94mchneta46dd8 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.1608.00.1'
20240813@174336.7682 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.7732 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.7757 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.7771 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.7779 1ocnak61is9f94mchneta46dd8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174336.7790 1ocnak61is9f94mchneta46dd8 Query : select sestamp valor from se where ref ='324.1608.00.1' and lote = 'r2100202100a'
20240813@174336.7814 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.7828 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.7839 1ocnak61is9f94mchneta46dd8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb87285066bb8d38be','aut66bb81421866bb8d3835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174336.7843 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.7857 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.7883 1ocnak61is9f94mchneta46dd8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb87285066bb8d38be',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66bb81421866bb8d3835' ,0,0 ,2,23.00,90000,?,?,?,?)
20240813@174336.8194 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.8197 1ocnak61is9f94mchneta46dd8 Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240813@174336.8217 1ocnak61is9f94mchneta46dd8 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240813@174336.8362 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.8377 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.8411 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.8425 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.8433 1ocnak61is9f94mchneta46dd8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174336.8445 1ocnak61is9f94mchneta46dd8 Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240897'
20240813@174336.8467 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.8482 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.8493 1ocnak61is9f94mchneta46dd8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb82838466bb8d38ce','aut66bb81421866bb8d3835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174336.8497 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.8511 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.8539 1ocnak61is9f94mchneta46dd8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb82838466bb8d38ce',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66bb81421866bb8d3835' ,0,0 ,2,23.00,100000,?,?,?,?)
20240813@174336.8784 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174336.8787 1ocnak61is9f94mchneta46dd8 Query : select st.usalote valor from st where st.ref = '324.4990.00.1'
20240813@174336.8806 1ocnak61is9f94mchneta46dd8 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.4990.00.1'
20240813@174336.8948 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.8963 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174336.8987 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.9001 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.9009 1ocnak61is9f94mchneta46dd8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174336.9021 1ocnak61is9f94mchneta46dd8 Query : select sestamp valor from se where ref ='324.4990.00.1' and lote = 'r2100189200a'
20240813@174336.9034 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.9048 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174336.9059 1ocnak61is9f94mchneta46dd8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb85577266bb8d38dc','aut66bb81421866bb8d3835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174336.9063 1ocnak61is9f94mchneta46dd8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174336.9077 1ocnak61is9f94mchneta46dd8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174337.2590 1ocnak61is9f94mchneta46dd8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb85577266bb8d38dc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66bb81421866bb8d3835' ,0,0 ,2,23.00,110000,?,?,?,?)
20240813@174337.5220 1ocnak61is9f94mchneta46dd8 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66bb81421866bb8d3835','2405377','wait',39,'adm09112754980.682000002')
20240813@174337.6130 1ocnak61is9f94mchneta46dd8 Query : use flama_phc
20240813@174337.6170 1ocnak61is9f94mchneta46dd8 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240813@174337.6570 1ocnak61is9f94mchneta46dd8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1524';
20240813@174337.6860 1ocnak61is9f94mchneta46dd8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1524';
20240813@174337.7320 1ocnak61is9f94mchneta46dd8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1524';
20240813@174337.7580 1ocnak61is9f94mchneta46dd8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1524';
20240813@174337.1873 nghuiubf84g382f5j9bimva33j Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240813@174337.1886 nghuiubf84g382f5j9bimva33j Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240813@174337.1937 nghuiubf84g382f5j9bimva33j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1525';
20240813@174337.1986 nghuiubf84g382f5j9bimva33j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1525';
20240813@174337.2037 nghuiubf84g382f5j9bimva33j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1525';
20240813@174337.2067 nghuiubf84g382f5j9bimva33j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1525';
20240813@174337.2119 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.2122 nghuiubf84g382f5j9bimva33j Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240813@174337.2189 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.2192 nghuiubf84g382f5j9bimva33j Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240813@174337.2245 nghuiubf84g382f5j9bimva33j Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.946.00.01'
20240813@174337.2419 nghuiubf84g382f5j9bimva33j Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.946.00.01'
20240813@174337.2442 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.2445 nghuiubf84g382f5j9bimva33j Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240813@174337.2481 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.2485 nghuiubf84g382f5j9bimva33j Query : select top 1 1 valor from td where td.ndoc = 39
20240813@174337.2515 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.2519 nghuiubf84g382f5j9bimva33j 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')
20240813@174337.2548 nghuiubf84g382f5j9bimva33j 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
20240813@174337.2588 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.2591 nghuiubf84g382f5j9bimva33j Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240813@174337.2623 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.2626 nghuiubf84g382f5j9bimva33j Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240813@174337.2666 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.2669 nghuiubf84g382f5j9bimva33j Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240813@174337.2711 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.2714 nghuiubf84g382f5j9bimva33j Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240813@174337.2777 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.2780 nghuiubf84g382f5j9bimva33j Query : select 1 valor from td where ndoc = 39
20240813@174337.2794 nghuiubf84g382f5j9bimva33j Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240813@174337.2810 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.2827 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174337.2848 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.2863 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174337.2896 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.2912 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174337.2926 nghuiubf84g382f5j9bimva33j Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174337.3019 nghuiubf84g382f5j9bimva33j Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174337.3032 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.3047 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174337.3063 nghuiubf84g382f5j9bimva33j Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66bb88907766bb8d3947' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240813@174337.3239 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.3272 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174337.3306 nghuiubf84g382f5j9bimva33j Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240813@174337.3318 nghuiubf84g382f5j9bimva33j Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240813@174337.3330 nghuiubf84g382f5j9bimva33j Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240813@174337.3342 nghuiubf84g382f5j9bimva33j Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240813@174337.3353 nghuiubf84g382f5j9bimva33j Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240813@174337.3365 nghuiubf84g382f5j9bimva33j Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240813@174337.3376 nghuiubf84g382f5j9bimva33j Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66bb88907766bb8d3947',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240813@174337.3613 nghuiubf84g382f5j9bimva33j Query : select top 1 fno valor from wsftdata order by fno desc
20240813@174337.3629 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.3644 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174337.3667 nghuiubf84g382f5j9bimva33j Query : select 'normal' from dummy
20240813@174337.3683 nghuiubf84g382f5j9bimva33j Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66bb88907766bb8d3947',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',338,100810,0,'2024-08-13',39,'euro',0,0,2024 ,?,?)
20240813@174337.4017 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.4020 nghuiubf84g382f5j9bimva33j Query : select st.usalote valor from st where st.ref = '324.946.00.01'
20240813@174337.4043 nghuiubf84g382f5j9bimva33j 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.946.00.01'
20240813@174337.4195 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.4211 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174337.4237 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.4251 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174337.4260 nghuiubf84g382f5j9bimva33j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174337.4273 nghuiubf84g382f5j9bimva33j Query : select sestamp valor from se where ref ='324.946.00.01' and lote = 'r2300941200a'
20240813@174337.4295 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.4310 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174337.4322 nghuiubf84g382f5j9bimva33j Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb80390466bb8d3968','aut66bb88907766bb8d3947' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174337.4326 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.4340 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174337.4369 nghuiubf84g382f5j9bimva33j Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb80390466bb8d3968',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut66bb88907766bb8d3947' ,0,0 ,2,23.00,10000,?,?,?,?)
20240813@174337.4636 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.4639 nghuiubf84g382f5j9bimva33j Query : select st.usalote valor from st where st.ref = '324.946.00.01'
20240813@174337.4658 nghuiubf84g382f5j9bimva33j 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.946.00.01'
20240813@174337.4672 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.4688 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174337.4715 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.4730 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174337.4738 nghuiubf84g382f5j9bimva33j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174337.4750 nghuiubf84g382f5j9bimva33j Query : select sestamp valor from se where ref ='324.946.00.01' and lote = 'r2300941200a'
20240813@174337.4762 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.4777 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174337.4789 nghuiubf84g382f5j9bimva33j Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb80713266bb8d3974','aut66bb88907766bb8d3947' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174337.4793 nghuiubf84g382f5j9bimva33j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.4808 nghuiubf84g382f5j9bimva33j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174337.4836 nghuiubf84g382f5j9bimva33j Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb80713266bb8d3974',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',32.000 ,'aut66bb88907766bb8d3947' ,0,0 ,2,23.00,20000,?,?,?,?)
20240813@174337.5101 nghuiubf84g382f5j9bimva33j Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66bb88907766bb8d3947','2405378','wait',39,'adm09112754980.682000002')
20240813@174337.5177 nghuiubf84g382f5j9bimva33j Query : use flama_phc
20240813@174337.5180 nghuiubf84g382f5j9bimva33j Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240813@174337.5212 nghuiubf84g382f5j9bimva33j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1525';
20240813@174337.5238 nghuiubf84g382f5j9bimva33j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1525';
20240813@174337.5276 nghuiubf84g382f5j9bimva33j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1525';
20240813@174337.5300 nghuiubf84g382f5j9bimva33j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1525';
20240813@174337.6692 3rt00lf1fpsk469k52435o477l Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240813@174337.6703 3rt00lf1fpsk469k52435o477l Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240813@174337.6751 3rt00lf1fpsk469k52435o477l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1526';
20240813@174337.6800 3rt00lf1fpsk469k52435o477l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1526';
20240813@174337.6861 3rt00lf1fpsk469k52435o477l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1526';
20240813@174337.6886 3rt00lf1fpsk469k52435o477l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1526';
20240813@174337.6938 3rt00lf1fpsk469k52435o477l Query : use flama_phc
20240813@174337.6941 3rt00lf1fpsk469k52435o477l Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240813@174337.7007 3rt00lf1fpsk469k52435o477l Query : use flama_phc
20240813@174337.7011 3rt00lf1fpsk469k52435o477l Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240813@174337.7056 3rt00lf1fpsk469k52435o477l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240813@174337.7230 3rt00lf1fpsk469k52435o477l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240813@174337.7250 3rt00lf1fpsk469k52435o477l Query : use flama_phc
20240813@174337.7253 3rt00lf1fpsk469k52435o477l Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240813@174337.7283 3rt00lf1fpsk469k52435o477l Query : use flama_phc
20240813@174337.7286 3rt00lf1fpsk469k52435o477l Query : select top 1 1 valor from td where td.ndoc = 39
20240813@174337.7314 3rt00lf1fpsk469k52435o477l Query : use flama_phc
20240813@174337.7317 3rt00lf1fpsk469k52435o477l 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')
20240813@174337.7344 3rt00lf1fpsk469k52435o477l 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
20240813@174337.7377 3rt00lf1fpsk469k52435o477l Query : use flama_phc
20240813@174337.7379 3rt00lf1fpsk469k52435o477l Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240813@174337.7408 3rt00lf1fpsk469k52435o477l Query : use flama_phc
20240813@174337.7411 3rt00lf1fpsk469k52435o477l Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240813@174337.7438 3rt00lf1fpsk469k52435o477l Query : use flama_phc
20240813@174337.7441 3rt00lf1fpsk469k52435o477l Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240813@174337.7479 3rt00lf1fpsk469k52435o477l Query : use flama_phc
20240813@174337.7481 3rt00lf1fpsk469k52435o477l Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240813@174337.7526 3rt00lf1fpsk469k52435o477l Query : use flama_phc
20240813@174337.7529 3rt00lf1fpsk469k52435o477l Query : select 1 valor from td where ndoc = 39
20240813@174337.7540 3rt00lf1fpsk469k52435o477l Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240813@174337.7554 3rt00lf1fpsk469k52435o477l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.7570 3rt00lf1fpsk469k52435o477l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174337.7588 3rt00lf1fpsk469k52435o477l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.7602 3rt00lf1fpsk469k52435o477l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174337.7648 3rt00lf1fpsk469k52435o477l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.7664 3rt00lf1fpsk469k52435o477l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174337.7676 3rt00lf1fpsk469k52435o477l Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174337.7756 3rt00lf1fpsk469k52435o477l Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240813@174337.7768 3rt00lf1fpsk469k52435o477l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.7782 3rt00lf1fpsk469k52435o477l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240813@174337.7798 3rt00lf1fpsk469k52435o477l Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66bb84713966bb8d39bb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240813@174337.7977 3rt00lf1fpsk469k52435o477l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.8004 3rt00lf1fpsk469k52435o477l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240813@174337.8037 3rt00lf1fpsk469k52435o477l Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240813@174337.8048 3rt00lf1fpsk469k52435o477l Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240813@174337.8060 3rt00lf1fpsk469k52435o477l Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240813@174337.8071 3rt00lf1fpsk469k52435o477l Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240813@174337.8083 3rt00lf1fpsk469k52435o477l Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240813@174337.8095 3rt00lf1fpsk469k52435o477l Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240813@174337.8106 3rt00lf1fpsk469k52435o477l Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66bb84713966bb8d39bb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240813@174337.8341 3rt00lf1fpsk469k52435o477l Query : select top 1 fno valor from wsftdata order by fno desc
20240813@174337.8357 3rt00lf1fpsk469k52435o477l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.8372 3rt00lf1fpsk469k52435o477l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240813@174337.8394 3rt00lf1fpsk469k52435o477l Query : select 'normal' from dummy
20240813@174337.8409 3rt00lf1fpsk469k52435o477l Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66bb84713966bb8d39bb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',339,100810,0,'2024-08-13',39,'euro',0,0,2024 ,?,?)
20240813@174337.8747 3rt00lf1fpsk469k52435o477l Query : use flama_phc
20240813@174337.8750 3rt00lf1fpsk469k52435o477l Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240813@174337.8773 3rt00lf1fpsk469k52435o477l 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.948.00.01'
20240813@174337.8934 3rt00lf1fpsk469k52435o477l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.8950 3rt00lf1fpsk469k52435o477l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174337.8977 3rt00lf1fpsk469k52435o477l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.8992 3rt00lf1fpsk469k52435o477l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174337.9001 3rt00lf1fpsk469k52435o477l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240813@174337.9014 3rt00lf1fpsk469k52435o477l Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240813@174337.9037 3rt00lf1fpsk469k52435o477l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.9052 3rt00lf1fpsk469k52435o477l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240813@174337.9065 3rt00lf1fpsk469k52435o477l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66bb80672366bb8d39dc','aut66bb84713966bb8d39bb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240813@174337.9070 3rt00lf1fpsk469k52435o477l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240813@174337.9089 3rt00lf1fpsk469k52435o477l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240813@174337.9119 3rt00lf1fpsk469k52435o477l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66bb80672366bb8d39dc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66bb84713966bb8d39bb' ,0,0 ,2,23.00,10000,?,?,?,?)
