20241128@164938.4146 4s5rou7catnj8hdorbij52to8i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@164938.4178 4s5rou7catnj8hdorbij52to8i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674893700467489f2263',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut674898500067489f21c5' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241128@164938.4509 4s5rou7catnj8hdorbij52to8i Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut674898500067489f21c5','2407985','wait',39,'adm09112754980.682000002')
20241128@164938.4614 4s5rou7catnj8hdorbij52to8i Query : use flama_phc
20241128@164938.4618 4s5rou7catnj8hdorbij52to8i Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241128@164938.4679 4s5rou7catnj8hdorbij52to8i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3568';
20241128@164938.4724 4s5rou7catnj8hdorbij52to8i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3568';
20241128@164938.4779 4s5rou7catnj8hdorbij52to8i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3568';
20241128@164938.4818 4s5rou7catnj8hdorbij52to8i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3568';
20241128@164938.5457 42boqvdef28612dfd5nbmkm71b Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241128@164938.5469 42boqvdef28612dfd5nbmkm71b Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241128@164938.5569 42boqvdef28612dfd5nbmkm71b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3569';
20241128@164938.5678 42boqvdef28612dfd5nbmkm71b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3569';
20241128@164938.5749 42boqvdef28612dfd5nbmkm71b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3569';
20241128@164938.5797 42boqvdef28612dfd5nbmkm71b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3569';
20241128@164938.5878 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164938.5882 42boqvdef28612dfd5nbmkm71b Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241128@164938.6000 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164938.6005 42boqvdef28612dfd5nbmkm71b Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241128@164938.6487 42boqvdef28612dfd5nbmkm71b Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20241128@164938.6688 42boqvdef28612dfd5nbmkm71b Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407986 and bi.ref ='324.2362.00.1' and bi.lordem =1
20241128@164938.7051 42boqvdef28612dfd5nbmkm71b Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20241128@164938.7074 42boqvdef28612dfd5nbmkm71b Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407986 and bi.ref ='324.2362.00.1' and bi.lordem =1
20241128@164938.7091 42boqvdef28612dfd5nbmkm71b Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20241128@164938.7112 42boqvdef28612dfd5nbmkm71b Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407986 and bi.ref ='324.2362.00.1' and bi.lordem =1
20241128@164938.7132 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164938.7135 42boqvdef28612dfd5nbmkm71b Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241128@164938.7168 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164938.7171 42boqvdef28612dfd5nbmkm71b Query : select top 1 1 valor from td where td.ndoc = 39
20241128@164938.7202 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164938.7205 42boqvdef28612dfd5nbmkm71b 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')
20241128@164938.7234 42boqvdef28612dfd5nbmkm71b 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
20241128@164938.7270 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164938.7273 42boqvdef28612dfd5nbmkm71b Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241128@164938.7303 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164938.7306 42boqvdef28612dfd5nbmkm71b Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241128@164938.7339 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164938.7343 42boqvdef28612dfd5nbmkm71b Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241128@164938.7448 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164938.7452 42boqvdef28612dfd5nbmkm71b Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241128@164938.7498 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164938.7500 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from td where ndoc = 39
20241128@164938.7513 42boqvdef28612dfd5nbmkm71b Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241128@164938.7528 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164938.7549 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241128@164938.7571 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164938.7586 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241128@164938.7637 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164938.7653 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241128@164938.7667 42boqvdef28612dfd5nbmkm71b Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241128@164938.7732 42boqvdef28612dfd5nbmkm71b Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241128@164938.7746 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164938.7762 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241128@164938.7779 42boqvdef28612dfd5nbmkm71b Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut674893874367489f22bb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241128@164938.7972 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164938.7993 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241128@164938.8030 42boqvdef28612dfd5nbmkm71b Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241128@164938.8042 42boqvdef28612dfd5nbmkm71b Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241128@164938.8054 42boqvdef28612dfd5nbmkm71b Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241128@164938.8066 42boqvdef28612dfd5nbmkm71b Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241128@164938.8078 42boqvdef28612dfd5nbmkm71b Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241128@164938.8090 42boqvdef28612dfd5nbmkm71b Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241128@164938.8102 42boqvdef28612dfd5nbmkm71b Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut674893874367489f22bb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241128@164938.8413 42boqvdef28612dfd5nbmkm71b Query : select top 1 fno valor from wsftdata order by fno desc
20241128@164938.8444 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164938.8462 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241128@164938.8488 42boqvdef28612dfd5nbmkm71b Query : select 'normal' from dummy
20241128@164938.8504 42boqvdef28612dfd5nbmkm71b Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut674893874367489f22bb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2099,100810,0,'2024-11-28',39,'euro',0,0,2024 ,?,?)
20241128@164938.9229 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164938.9353 42boqvdef28612dfd5nbmkm71b Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20241128@164939.8500 42boqvdef28612dfd5nbmkm71b 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.2362.00.1'
20241128@164939.5060 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164939.5260 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@164939.5530 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164939.5730 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@164939.5860 42boqvdef28612dfd5nbmkm71b Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@164939.5980 42boqvdef28612dfd5nbmkm71b Query : select sestamp valor from se where ref ='324.2362.00.1' and lote = 'r2400498400a'
20241128@164939.6150 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164939.6440 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@164939.6560 42boqvdef28612dfd5nbmkm71b Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674899288467489f230f','aut674893874367489f22bb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@164939.6610 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164939.6810 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@164939.7110 42boqvdef28612dfd5nbmkm71b Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674899288467489f230f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut674893874367489f22bb' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241128@164939.1060 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164939.1063 42boqvdef28612dfd5nbmkm71b Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20241128@164939.1084 42boqvdef28612dfd5nbmkm71b 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.2362.00.1'
20241128@164939.1098 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164939.1116 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@164939.1142 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164939.1157 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@164939.1170 42boqvdef28612dfd5nbmkm71b Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@164939.1185 42boqvdef28612dfd5nbmkm71b Query : select sestamp valor from se where ref ='324.2362.00.1' and lote = 'r2400498400a'
20241128@164939.1198 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164939.1213 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@164939.1224 42boqvdef28612dfd5nbmkm71b Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674895956967489f231d','aut674893874367489f22bb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@164939.1229 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164939.1244 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@164939.1273 42boqvdef28612dfd5nbmkm71b Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674895956967489f231d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',22.000 ,'aut674893874367489f22bb' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241128@164939.1613 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164939.1617 42boqvdef28612dfd5nbmkm71b Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20241128@164939.1638 42boqvdef28612dfd5nbmkm71b 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.2362.00.1'
20241128@164939.1655 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164939.1672 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@164939.1702 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164939.1719 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@164939.1727 42boqvdef28612dfd5nbmkm71b Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@164939.1768 42boqvdef28612dfd5nbmkm71b Query : select sestamp valor from se where ref ='324.2362.00.1' and lote = 'r2400498400a'
20241128@164939.1782 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164939.1797 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@164939.1808 42boqvdef28612dfd5nbmkm71b Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674895042867489f232b','aut674893874367489f22bb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@164939.1813 42boqvdef28612dfd5nbmkm71b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@164939.1828 42boqvdef28612dfd5nbmkm71b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@164939.1856 42boqvdef28612dfd5nbmkm71b Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674895042867489f232b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',22.000 ,'aut674893874367489f22bb' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241128@164939.2169 42boqvdef28612dfd5nbmkm71b Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut674893874367489f22bb','2407986','wait',39,'adm09112754980.682000002')
20241128@164939.2240 42boqvdef28612dfd5nbmkm71b Query : use flama_phc
20241128@164939.2243 42boqvdef28612dfd5nbmkm71b Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241128@164939.2274 42boqvdef28612dfd5nbmkm71b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3569';
20241128@164939.2314 42boqvdef28612dfd5nbmkm71b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3569';
20241128@164939.2368 42boqvdef28612dfd5nbmkm71b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3569';
20241128@164939.2406 42boqvdef28612dfd5nbmkm71b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3569';

20241128@195603.8021 g5uneuug0rpf0p80coccn4huc5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3570';
20241128@195603.8103 g5uneuug0rpf0p80coccn4huc5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3570';
20241128@195603.8136 g5uneuug0rpf0p80coccn4huc5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3570';
20241128@195603.8192 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195603.8195 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241128@195603.8308 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195603.8311 g5uneuug0rpf0p80coccn4huc5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1549
20241128@195603.8621 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8171.00.1'
20241128@195603.8802 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407990 and bi.ref ='327.8171.00.1' and bi.lordem =1
20241128@195603.9164 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8171.00.1'
20241128@195603.9187 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407990 and bi.ref ='327.8171.00.1' and bi.lordem =1
20241128@195603.9206 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195603.9210 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241128@195603.9431 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195603.9434 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 1 valor from td where td.ndoc = 39
20241128@195603.9533 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195603.9536 g5uneuug0rpf0p80coccn4huc5 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')
20241128@195603.9600 g5uneuug0rpf0p80coccn4huc5 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
20241128@195603.9741 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195603.9745 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 ~inactivo valor from cl where no = '101557' and estab = 0 order by inactivo desc
20241128@195603.9879 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195603.9882 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241128@195603.9980 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195603.9984 g5uneuug0rpf0p80coccn4huc5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241128@195604.5900 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195604.6200 g5uneuug0rpf0p80coccn4huc5 Query : select szadrsstamp valor from szadrs where szadrsdesc='jomafal'
20241128@195604.1090 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195604.1120 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from td where ndoc = 39
20241128@195604.1900 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241128@195604.2580 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.9930 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241128@195604.1047 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.1063 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241128@195604.1096 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.1111 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241128@195604.1125 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241128@195604.1493 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241128@195604.1595 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.1611 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241128@195604.1656 g5uneuug0rpf0p80coccn4huc5 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6748c760316748cad41b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241128@195604.2028 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.2048 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241128@195604.2089 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241128@195604.2191 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241128@195604.2267 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241128@195604.2340 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241128@195604.2411 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241128@195604.2490 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241128@195604.3266 g5uneuug0rpf0p80coccn4huc5 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6748c760316748cad41b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241128@195604.3755 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 fno valor from wsftdata order by fno desc
20241128@195604.3868 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.3886 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241128@195604.3913 g5uneuug0rpf0p80coccn4huc5 Query : select 'normal' from dummy
20241128@195604.3948 g5uneuug0rpf0p80coccn4huc5 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6748c760316748cad41b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2100,101557,0,'2024-11-28',39,'euro',0,0,2024 ,?,?)
20241128@195604.4358 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195604.4362 g5uneuug0rpf0p80coccn4huc5 Query : select st.usalote valor from st where st.ref = '327.8171.00.1'
20241128@195604.4494 g5uneuug0rpf0p80coccn4huc5 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 = '327.8171.00.1'
20241128@195604.4650 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.4667 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195604.4696 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.4711 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195604.4720 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195604.4759 g5uneuug0rpf0p80coccn4huc5 Query : select sestamp valor from se where ref ='327.8171.00.1' and lote = 'r2301073200a'
20241128@195604.4828 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.4846 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195604.4860 g5uneuug0rpf0p80coccn4huc5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c518406748cad475','aut6748c760316748cad41b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195604.4904 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.4921 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195604.4955 g5uneuug0rpf0p80coccn4huc5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6748c518406748cad475',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6748c760316748cad41b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241128@195604.5804 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.5822 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195604.5853 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.6485 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195604.6496 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195604.6510 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.6528 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195604.6540 g5uneuug0rpf0p80coccn4huc5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c194816748cad49e','aut6748c760316748cad41b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195604.6545 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.7383 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195604.7763 g5uneuug0rpf0p80coccn4huc5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6748c194816748cad49e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6748c760316748cad41b' ,0,0 ,2,23.00,20000,?,?,?)
20241128@195604.8044 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195604.8048 g5uneuug0rpf0p80coccn4huc5 Query : select st.usalote valor from st where st.ref = '327.8171.00.1'
20241128@195604.8068 g5uneuug0rpf0p80coccn4huc5 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 = '327.8171.00.1'
20241128@195604.8084 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.8101 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195604.8130 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.8146 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195604.8155 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195604.8168 g5uneuug0rpf0p80coccn4huc5 Query : select sestamp valor from se where ref ='327.8171.00.1' and lote = 'r2301073200a'
20241128@195604.8182 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.8197 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195604.8209 g5uneuug0rpf0p80coccn4huc5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c006616748cad4c7','aut6748c760316748cad41b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195604.8213 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.8230 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195604.8258 g5uneuug0rpf0p80coccn4huc5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6748c006616748cad4c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6748c760316748cad41b' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241128@195604.8542 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.8558 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195604.8583 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.8596 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195604.8605 g5uneuug0rpf0p80coccn4huc5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195604.8618 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.8632 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195604.8643 g5uneuug0rpf0p80coccn4huc5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c854446748cad4d2','aut6748c760316748cad41b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195604.8647 g5uneuug0rpf0p80coccn4huc5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195604.8661 g5uneuug0rpf0p80coccn4huc5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195604.8689 g5uneuug0rpf0p80coccn4huc5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6748c854446748cad4d2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6748c760316748cad41b' ,0,0 ,2,23.00,50000,?,?,?)
20241128@195604.8954 g5uneuug0rpf0p80coccn4huc5 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6748c760316748cad41b','2407990','wait',39,'adm09112754980.682000002')
20241128@195604.9043 g5uneuug0rpf0p80coccn4huc5 Query : use flama_phc
20241128@195604.9047 g5uneuug0rpf0p80coccn4huc5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241128@195604.9079 g5uneuug0rpf0p80coccn4huc5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3570';
20241128@195604.9127 g5uneuug0rpf0p80coccn4huc5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3570';
20241128@195604.9180 g5uneuug0rpf0p80coccn4huc5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3570';
20241128@195604.9227 g5uneuug0rpf0p80coccn4huc5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3570';
20241128@195604.9775 3642pq3mnp2df99rsjj0ot6gli Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241128@195604.9786 3642pq3mnp2df99rsjj0ot6gli Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241128@195604.9859 3642pq3mnp2df99rsjj0ot6gli Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3571';
20241128@195604.9931 3642pq3mnp2df99rsjj0ot6gli Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3571';
20241128@195604.9992 3642pq3mnp2df99rsjj0ot6gli Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3571';
20241128@195605.2600 3642pq3mnp2df99rsjj0ot6gli Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3571';
20241128@195605.8000 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.8300 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241128@195605.1470 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.1500 3642pq3mnp2df99rsjj0ot6gli Query : select no, estab,szadrsdesc from szadrs where u_coddest=210
20241128@195605.2550 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20241128@195605.4260 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407991 and bi.ref ='324.1816.00.1' and bi.lordem =1
20241128@195605.1138 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20241128@195605.1198 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407991 and bi.ref ='324.1816.00.1' and bi.lordem =1
20241128@195605.1216 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20241128@195605.1242 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407991 and bi.ref ='324.1816.00.1' and bi.lordem =2
20241128@195605.1587 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20241128@195605.1777 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407991 and bi.ref ='324.1803.00.1' and bi.lordem =3
20241128@195605.2126 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20241128@195605.2150 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407991 and bi.ref ='324.1803.00.1' and bi.lordem =4
20241128@195605.2491 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20241128@195605.2512 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407991 and bi.ref ='324.1803.00.1' and bi.lordem =5
20241128@195605.2846 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.2850 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241128@195605.2883 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.2886 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 1 valor from td where td.ndoc = 39
20241128@195605.2915 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.2918 3642pq3mnp2df99rsjj0ot6gli 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')
20241128@195605.2949 3642pq3mnp2df99rsjj0ot6gli 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
20241128@195605.2985 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.2988 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 ~inactivo valor from cl where no = '101895' and estab = 0 order by inactivo desc
20241128@195605.3143 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.3146 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241128@195605.3177 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.3180 3642pq3mnp2df99rsjj0ot6gli Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241128@195605.3226 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.3229 3642pq3mnp2df99rsjj0ot6gli Query : select szadrsstamp valor from szadrs where szadrsdesc='quase bom-com.de electrodomÉsticos, lda.-pombal'
20241128@195605.3280 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.3283 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from td where ndoc = 39
20241128@195605.3297 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241128@195605.3314 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.3334 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241128@195605.3357 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.3374 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241128@195605.3403 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.3420 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241128@195605.3434 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241128@195605.3496 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241128@195605.3511 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.3533 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241128@195605.3550 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6748c198366748cad553' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241128@195605.3742 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.3770 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241128@195605.3807 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241128@195605.3821 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241128@195605.3834 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241128@195605.3847 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241128@195605.3859 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241128@195605.3872 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241128@195605.3884 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6748c198366748cad553',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241128@195605.4201 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 fno valor from wsftdata order by fno desc
20241128@195605.4247 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.4296 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241128@195605.4321 3642pq3mnp2df99rsjj0ot6gli Query : select 'normal' from dummy
20241128@195605.4337 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6748c198366748cad553',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2101,101895,0,'2024-11-28',39,'euro',0,0,2024 ,?,?)
20241128@195605.6599 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.6684 3642pq3mnp2df99rsjj0ot6gli Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20241128@195605.6955 3642pq3mnp2df99rsjj0ot6gli 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.1816.00.1'
20241128@195605.7129 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.7148 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195605.7180 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.7199 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195605.7209 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195605.7224 3642pq3mnp2df99rsjj0ot6gli Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400200200a'
20241128@195605.7254 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.7273 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195605.7285 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c133116748cad5b1','aut6748c198366748cad553' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195605.7290 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.7305 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195605.7334 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6748c133116748cad5b1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',9.000 ,'aut6748c198366748cad553' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241128@195605.7629 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.7648 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195605.7678 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.7694 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195605.7704 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195605.7717 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.7733 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195605.7748 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c449706748cad5bc','aut6748c198366748cad553' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195605.7753 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.7770 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195605.7801 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6748c449706748cad5bc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6748c198366748cad553' ,0,0 ,2,23.00,20000,?,?,?)
20241128@195605.8136 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.8178 3642pq3mnp2df99rsjj0ot6gli Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20241128@195605.8288 3642pq3mnp2df99rsjj0ot6gli 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.1816.00.1'
20241128@195605.8304 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.8323 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195605.8352 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.8368 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195605.8378 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195605.8392 3642pq3mnp2df99rsjj0ot6gli Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400200200a'
20241128@195605.8406 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.8422 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195605.8436 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c836596748cad5cd','aut6748c198366748cad553' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195605.8441 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.8457 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195605.8488 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6748c836596748cad5cd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut6748c198366748cad553' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241128@195605.8790 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.8807 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195605.8835 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.8850 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195605.8858 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195605.8872 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.8892 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195605.8906 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c843796748cad5d8','aut6748c198366748cad553' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195605.8923 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.8941 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195605.8974 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6748c843796748cad5d8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6748c198366748cad553' ,0,0 ,2,23.00,50000,?,?,?)
20241128@195605.9279 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195605.9282 3642pq3mnp2df99rsjj0ot6gli Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20241128@195605.9302 3642pq3mnp2df99rsjj0ot6gli 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.1816.00.1'
20241128@195605.9319 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.9368 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195605.9396 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.9414 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195605.9425 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195605.9437 3642pq3mnp2df99rsjj0ot6gli Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400200200a'
20241128@195605.9454 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.9477 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195605.9489 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c532026748cad5e6','aut6748c198366748cad553' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195605.9494 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.9511 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195605.9548 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6748c532026748cad5e6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6748c198366748cad553' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241128@195605.9865 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.9885 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195605.9911 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.9929 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195605.9945 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195605.9963 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195605.9984 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195605.9998 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c703296748cad5f3','aut6748c198366748cad553' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195606.3000 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.2000 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195606.5300 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6748c703296748cad5f3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6748c198366748cad553' ,0,0 ,2,23.00,80000,?,?,?)
20241128@195606.3500 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195606.3530 3642pq3mnp2df99rsjj0ot6gli Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20241128@195606.3760 3642pq3mnp2df99rsjj0ot6gli 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.1803.00.1'
20241128@195606.5400 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.5580 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195606.5860 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.6030 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195606.6120 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195606.6270 3642pq3mnp2df99rsjj0ot6gli Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2301274200a'
20241128@195606.6510 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.6700 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195606.6830 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c785346748cad60f','aut6748c198366748cad553' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195606.6880 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.7040 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195606.7390 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6748c785346748cad60f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut6748c198366748cad553' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241128@195606.1039 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195606.1042 3642pq3mnp2df99rsjj0ot6gli Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20241128@195606.1062 3642pq3mnp2df99rsjj0ot6gli 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.1803.00.1'
20241128@195606.1079 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.1096 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195606.1481 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.1500 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195606.1509 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195606.1525 3642pq3mnp2df99rsjj0ot6gli Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2301274200a'
20241128@195606.1540 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.1557 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195606.1571 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c109206748cad625','aut6748c198366748cad553' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195606.1576 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.1592 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195606.1625 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6748c109206748cad625',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6748c198366748cad553' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20241128@195606.1951 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195606.1954 3642pq3mnp2df99rsjj0ot6gli Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20241128@195606.1984 3642pq3mnp2df99rsjj0ot6gli 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.1803.00.1'
20241128@195606.2000 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.2020 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195606.2057 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.2078 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195606.2088 3642pq3mnp2df99rsjj0ot6gli Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195606.2101 3642pq3mnp2df99rsjj0ot6gli Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2301274200a'
20241128@195606.2114 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.2131 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195606.2145 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c895386748cad633','aut6748c198366748cad553' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195606.2150 3642pq3mnp2df99rsjj0ot6gli Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.2168 3642pq3mnp2df99rsjj0ot6gli Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195606.2203 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6748c895386748cad633',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6748c198366748cad553' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20241128@195606.2673 3642pq3mnp2df99rsjj0ot6gli Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6748c198366748cad553','2407991','wait',39,'adm09112754980.682000002')
20241128@195606.4051 3642pq3mnp2df99rsjj0ot6gli Query : use flama_phc
20241128@195606.4054 3642pq3mnp2df99rsjj0ot6gli Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241128@195606.4084 3642pq3mnp2df99rsjj0ot6gli Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3571';
20241128@195606.4126 3642pq3mnp2df99rsjj0ot6gli Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3571';
20241128@195606.4173 3642pq3mnp2df99rsjj0ot6gli Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3571';
20241128@195606.4202 3642pq3mnp2df99rsjj0ot6gli Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3571';
20241128@195606.4690 85g7uotm976qdhsdve98jtee3l Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241128@195606.4701 85g7uotm976qdhsdve98jtee3l Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241128@195606.4767 85g7uotm976qdhsdve98jtee3l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3572';
20241128@195606.4830 85g7uotm976qdhsdve98jtee3l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3572';
20241128@195606.4893 85g7uotm976qdhsdve98jtee3l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3572';
20241128@195606.4926 85g7uotm976qdhsdve98jtee3l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3572';
20241128@195606.4980 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195606.4984 85g7uotm976qdhsdve98jtee3l Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241128@195606.5049 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195606.5052 85g7uotm976qdhsdve98jtee3l Query : select no, estab,szadrsdesc from szadrs where u_coddest=754
20241128@195606.5155 85g7uotm976qdhsdve98jtee3l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4020.00.1'
20241128@195606.5323 85g7uotm976qdhsdve98jtee3l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2080 and bo.obrano = 2408005 and bi.ref ='304.4020.00.1' and bi.lordem =1
20241128@195606.5669 85g7uotm976qdhsdve98jtee3l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.422.00.07'
20241128@195606.5841 85g7uotm976qdhsdve98jtee3l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2080 and bo.obrano = 2408005 and bi.ref ='304.422.00.07' and bi.lordem =3
20241128@195606.6190 85g7uotm976qdhsdve98jtee3l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20241128@195606.6360 85g7uotm976qdhsdve98jtee3l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2080 and bo.obrano = 2408005 and bi.ref ='324.1676.00.1' and bi.lordem =5
20241128@195606.6699 85g7uotm976qdhsdve98jtee3l 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'
20241128@195606.6882 85g7uotm976qdhsdve98jtee3l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2080 and bo.obrano = 2408005 and bi.ref ='304.4320.00.1' and bi.lordem =7
20241128@195606.7239 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195606.7243 85g7uotm976qdhsdve98jtee3l Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241128@195606.7341 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195606.7345 85g7uotm976qdhsdve98jtee3l Query : select top 1 1 valor from td where td.ndoc = 39
20241128@195606.7378 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195606.7381 85g7uotm976qdhsdve98jtee3l 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')
20241128@195606.7411 85g7uotm976qdhsdve98jtee3l 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
20241128@195606.7446 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195606.7449 85g7uotm976qdhsdve98jtee3l Query : select top 1 ~inactivo valor from cl where no = '101578' and estab = 0 order by inactivo desc
20241128@195606.7585 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195606.7588 85g7uotm976qdhsdve98jtee3l Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241128@195606.7619 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195606.7622 85g7uotm976qdhsdve98jtee3l Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241128@195606.7662 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195606.7705 85g7uotm976qdhsdve98jtee3l Query : select szadrsstamp valor from szadrs where szadrsdesc='amÂndio cruz pessoa,lda tecnisom'
20241128@195606.8090 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195606.8095 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from td where ndoc = 39
20241128@195606.8108 85g7uotm976qdhsdve98jtee3l Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241128@195606.8124 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.8142 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241128@195606.8163 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.8178 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241128@195606.8209 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.8233 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241128@195606.8246 85g7uotm976qdhsdve98jtee3l Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241128@195606.8473 85g7uotm976qdhsdve98jtee3l Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241128@195606.8490 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.8513 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241128@195606.8531 85g7uotm976qdhsdve98jtee3l Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6748c241916748cad6c9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241128@195606.8723 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.8743 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241128@195606.8786 85g7uotm976qdhsdve98jtee3l Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241128@195606.8799 85g7uotm976qdhsdve98jtee3l Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241128@195606.8813 85g7uotm976qdhsdve98jtee3l Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241128@195606.8827 85g7uotm976qdhsdve98jtee3l Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241128@195606.8840 85g7uotm976qdhsdve98jtee3l Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241128@195606.8853 85g7uotm976qdhsdve98jtee3l Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241128@195606.8864 85g7uotm976qdhsdve98jtee3l Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6748c241916748cad6c9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241128@195606.9141 85g7uotm976qdhsdve98jtee3l Query : select top 1 fno valor from wsftdata order by fno desc
20241128@195606.9172 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.9189 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241128@195606.9217 85g7uotm976qdhsdve98jtee3l Query : select 'normal' from dummy
20241128@195606.9236 85g7uotm976qdhsdve98jtee3l Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6748c241916748cad6c9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2102,101578,0,'2024-11-28',39,'euro',0,0,2024 ,?,?)
20241128@195606.9595 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195606.9599 85g7uotm976qdhsdve98jtee3l Query : select st.usalote valor from st where st.ref = '304.4020.00.1'
20241128@195606.9625 85g7uotm976qdhsdve98jtee3l 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.4020.00.1'
20241128@195606.9793 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.9810 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195606.9841 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.9868 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195606.9880 85g7uotm976qdhsdve98jtee3l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195606.9896 85g7uotm976qdhsdve98jtee3l Query : select sestamp valor from se where ref ='304.4020.00.1' and lote = '240409'
20241128@195606.9959 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195606.9977 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195606.9990 85g7uotm976qdhsdve98jtee3l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c166586748cad6f3','aut6748c241916748cad6c9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195606.9995 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.9000 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195607.3800 85g7uotm976qdhsdve98jtee3l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6748c166586748cad6f3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6748c241916748cad6c9' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241128@195607.3760 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195607.3790 85g7uotm976qdhsdve98jtee3l Query : select st.usalote valor from st where st.ref = '304.422.00.07'
20241128@195607.4020 85g7uotm976qdhsdve98jtee3l 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.422.00.07'
20241128@195607.5620 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.5810 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195607.6110 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.6270 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195607.6360 85g7uotm976qdhsdve98jtee3l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195607.6500 85g7uotm976qdhsdve98jtee3l Query : select sestamp valor from se where ref ='304.422.00.07' and lote = '241004'
20241128@195607.6790 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.7010 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195607.7140 85g7uotm976qdhsdve98jtee3l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c709136748cad710','aut6748c241916748cad6c9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195607.7220 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.7370 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195607.7670 85g7uotm976qdhsdve98jtee3l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6748c709136748cad710',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6748c241916748cad6c9' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241128@195607.1053 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195607.1056 85g7uotm976qdhsdve98jtee3l Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20241128@195607.1079 85g7uotm976qdhsdve98jtee3l 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.1676.00.1'
20241128@195607.1239 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.1256 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195607.1285 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.1302 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195607.1311 85g7uotm976qdhsdve98jtee3l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195607.1325 85g7uotm976qdhsdve98jtee3l Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20241128@195607.1346 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.1364 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195607.1376 85g7uotm976qdhsdve98jtee3l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c366936748cad720','aut6748c241916748cad6c9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195607.1381 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.1397 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195607.1435 85g7uotm976qdhsdve98jtee3l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6748c366936748cad720',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6748c241916748cad6c9' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241128@195607.1743 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195607.1746 85g7uotm976qdhsdve98jtee3l Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20241128@195607.1770 85g7uotm976qdhsdve98jtee3l 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'
20241128@195607.1941 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.1962 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195607.1995 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.2010 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195607.2020 85g7uotm976qdhsdve98jtee3l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241128@195607.2033 85g7uotm976qdhsdve98jtee3l Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '241347'
20241128@195607.2059 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.2077 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241128@195607.2089 85g7uotm976qdhsdve98jtee3l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6748c111056748cad732','aut6748c241916748cad6c9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241128@195607.2094 85g7uotm976qdhsdve98jtee3l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241128@195607.2108 85g7uotm976qdhsdve98jtee3l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241128@195607.2142 85g7uotm976qdhsdve98jtee3l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6748c111056748cad732',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6748c241916748cad6c9' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241128@195607.2438 85g7uotm976qdhsdve98jtee3l Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6748c241916748cad6c9','2408005','wait',39,'adm09112754980.682000002')
20241128@195607.2509 85g7uotm976qdhsdve98jtee3l Query : use flama_phc
20241128@195607.2512 85g7uotm976qdhsdve98jtee3l Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241128@195607.2543 85g7uotm976qdhsdve98jtee3l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3572';
20241128@195607.2583 85g7uotm976qdhsdve98jtee3l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3572';
20241128@195607.2632 85g7uotm976qdhsdve98jtee3l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3572';
20241128@195607.2661 85g7uotm976qdhsdve98jtee3l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3572';
