20240808@173853.4124 6ktn7f5tufe62s895vclof51qa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.4141 6ktn7f5tufe62s895vclof51qa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173853.4170 6ktn7f5tufe62s895vclof51qa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.4185 6ktn7f5tufe62s895vclof51qa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173853.4194 6ktn7f5tufe62s895vclof51qa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240808@173853.4206 6ktn7f5tufe62s895vclof51qa Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240808@173853.4220 6ktn7f5tufe62s895vclof51qa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.4235 6ktn7f5tufe62s895vclof51qa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173853.4246 6ktn7f5tufe62s895vclof51qa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b4f3265466b4f49d67','aut66b4f2556166b4f49d1e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240808@173853.4251 6ktn7f5tufe62s895vclof51qa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.4265 6ktn7f5tufe62s895vclof51qa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173853.4293 6ktn7f5tufe62s895vclof51qa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b4f3265466b4f49d67',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66b4f2556166b4f49d1e' ,0,0 ,2,23.00,40000,?,?,?,?)
20240808@173853.4599 6ktn7f5tufe62s895vclof51qa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.4616 6ktn7f5tufe62s895vclof51qa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173853.4642 6ktn7f5tufe62s895vclof51qa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.4658 6ktn7f5tufe62s895vclof51qa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173853.4666 6ktn7f5tufe62s895vclof51qa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240808@173853.4681 6ktn7f5tufe62s895vclof51qa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.4697 6ktn7f5tufe62s895vclof51qa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173853.4709 6ktn7f5tufe62s895vclof51qa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b4f4776766b4f49d72','aut66b4f2556166b4f49d1e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240808@173853.4713 6ktn7f5tufe62s895vclof51qa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.4739 6ktn7f5tufe62s895vclof51qa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173853.4769 6ktn7f5tufe62s895vclof51qa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b4f4776766b4f49d72',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b4f2556166b4f49d1e' ,0,0 ,2,23.00,50000,?,?,?)
20240808@173853.5071 6ktn7f5tufe62s895vclof51qa Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66b4f2556166b4f49d1e','2405294','wait',39,'adm09112754980.682000002')
20240808@173853.5146 6ktn7f5tufe62s895vclof51qa Query : use flama_phc
20240808@173853.5149 6ktn7f5tufe62s895vclof51qa Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240808@173853.5180 6ktn7f5tufe62s895vclof51qa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1443';
20240808@173853.5208 6ktn7f5tufe62s895vclof51qa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1443';
20240808@173853.5246 6ktn7f5tufe62s895vclof51qa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1443';
20240808@173853.5271 6ktn7f5tufe62s895vclof51qa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1443';
20240808@173853.6195 52f0lofajdvd0rcn5sigglldam Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240808@173853.6207 52f0lofajdvd0rcn5sigglldam Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240808@173853.7421 52f0lofajdvd0rcn5sigglldam Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1444';
20240808@173853.7489 52f0lofajdvd0rcn5sigglldam Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1444';
20240808@173853.7540 52f0lofajdvd0rcn5sigglldam Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1444';
20240808@173853.7566 52f0lofajdvd0rcn5sigglldam Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1444';
20240808@173853.7614 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173853.7617 52f0lofajdvd0rcn5sigglldam Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240808@173853.7682 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173853.7685 52f0lofajdvd0rcn5sigglldam Query : select no, estab,szadrsdesc from szadrs where u_coddest=339
20240808@173853.7779 52f0lofajdvd0rcn5sigglldam 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'
20240808@173853.7959 52f0lofajdvd0rcn5sigglldam 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'
20240808@173853.7983 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173853.7987 52f0lofajdvd0rcn5sigglldam Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240808@173853.8021 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173853.8024 52f0lofajdvd0rcn5sigglldam Query : select top 1 1 valor from td where td.ndoc = 39
20240808@173853.8059 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173853.8063 52f0lofajdvd0rcn5sigglldam 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')
20240808@173853.8094 52f0lofajdvd0rcn5sigglldam 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
20240808@173853.8132 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173853.8136 52f0lofajdvd0rcn5sigglldam Query : select top 1 ~inactivo valor from cl where no = '102177' and estab = 0 order by inactivo desc
20240808@173853.8275 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173853.8278 52f0lofajdvd0rcn5sigglldam Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240808@173853.8312 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173853.8316 52f0lofajdvd0rcn5sigglldam Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240808@173853.8358 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173853.8363 52f0lofajdvd0rcn5sigglldam Query : select szadrsstamp valor from szadrs where szadrsdesc='electrÃo, lda.'
20240808@173853.8416 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173853.8419 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from td where ndoc = 39
20240808@173853.8433 52f0lofajdvd0rcn5sigglldam Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240808@173853.8450 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.8469 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240808@173853.8491 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.8508 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240808@173853.8540 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.8556 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240808@173853.8571 52f0lofajdvd0rcn5sigglldam Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240808@173853.8644 52f0lofajdvd0rcn5sigglldam Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240808@173853.8660 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.8687 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240808@173853.8705 52f0lofajdvd0rcn5sigglldam Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66b4f1112566b4f49dd1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240808@173853.8903 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.8924 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240808@173853.8963 52f0lofajdvd0rcn5sigglldam Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240808@173853.8977 52f0lofajdvd0rcn5sigglldam Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240808@173853.8989 52f0lofajdvd0rcn5sigglldam Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240808@173853.9003 52f0lofajdvd0rcn5sigglldam Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240808@173853.9017 52f0lofajdvd0rcn5sigglldam Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240808@173853.9030 52f0lofajdvd0rcn5sigglldam Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240808@173853.9043 52f0lofajdvd0rcn5sigglldam Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66b4f1112566b4f49dd1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240808@173853.9307 52f0lofajdvd0rcn5sigglldam Query : select top 1 fno valor from wsftdata order by fno desc
20240808@173853.9328 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.9346 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240808@173853.9372 52f0lofajdvd0rcn5sigglldam Query : select 'normal' from dummy
20240808@173853.9389 52f0lofajdvd0rcn5sigglldam Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66b4f1112566b4f49dd1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',264,102177,0,'2024-08-08',39,'euro',0,0,2024 ,?,?)
20240808@173853.9733 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173853.9736 52f0lofajdvd0rcn5sigglldam Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240808@173853.9760 52f0lofajdvd0rcn5sigglldam 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'
20240808@173853.9929 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.9945 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173853.9971 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173853.9985 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173853.9993 52f0lofajdvd0rcn5sigglldam Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240808@173854.5000 52f0lofajdvd0rcn5sigglldam Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400198200a'
20240808@173854.1900 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.3400 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173854.5500 52f0lofajdvd0rcn5sigglldam Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b4f4753566b4f49e00','aut66b4f1112566b4f49dd1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240808@173854.5900 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.7400 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173854.1010 52f0lofajdvd0rcn5sigglldam Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b4f4753566b4f49e00',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66b4f1112566b4f49dd1' ,0,0 ,2,23.00,10000,?,?,?,?)
20240808@173854.3760 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.3940 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173854.4200 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.4350 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173854.4440 52f0lofajdvd0rcn5sigglldam Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240808@173854.4670 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.4820 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173854.4940 52f0lofajdvd0rcn5sigglldam Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b4f6513466b4f49e0b','aut66b4f1112566b4f49dd1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240808@173854.4980 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.5140 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173854.5460 52f0lofajdvd0rcn5sigglldam Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b4f6513466b4f49e0b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b4f1112566b4f49dd1' ,0,0 ,2,23.00,20000,?,?,?)
20240808@173854.8450 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173854.8480 52f0lofajdvd0rcn5sigglldam Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240808@173854.8700 52f0lofajdvd0rcn5sigglldam 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'
20240808@173854.8870 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.9060 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173854.9320 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.9480 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173854.9570 52f0lofajdvd0rcn5sigglldam Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240808@173854.9690 52f0lofajdvd0rcn5sigglldam Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400198200a'
20240808@173854.9830 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.9980 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173854.1010 52f0lofajdvd0rcn5sigglldam Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b4f9391766b4f49e18','aut66b4f1112566b4f49dd1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240808@173854.1015 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.1030 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173854.1058 52f0lofajdvd0rcn5sigglldam Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b4f9391766b4f49e18',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66b4f1112566b4f49dd1' ,0,0 ,2,23.00,40000,?,?,?,?)
20240808@173854.1371 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.1389 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173854.1416 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.1431 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173854.1440 52f0lofajdvd0rcn5sigglldam Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240808@173854.1453 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.1471 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173854.1484 52f0lofajdvd0rcn5sigglldam Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b4f1311066b4f49e23','aut66b4f1112566b4f49dd1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240808@173854.1490 52f0lofajdvd0rcn5sigglldam Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.1505 52f0lofajdvd0rcn5sigglldam Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173854.1536 52f0lofajdvd0rcn5sigglldam Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b4f1311066b4f49e23',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b4f1112566b4f49dd1' ,0,0 ,2,23.00,50000,?,?,?)
20240808@173854.1860 52f0lofajdvd0rcn5sigglldam Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66b4f1112566b4f49dd1','2405296','wait',39,'adm09112754980.682000002')
20240808@173854.1937 52f0lofajdvd0rcn5sigglldam Query : use flama_phc
20240808@173854.1940 52f0lofajdvd0rcn5sigglldam Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240808@173854.1971 52f0lofajdvd0rcn5sigglldam Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1444';
20240808@173854.1998 52f0lofajdvd0rcn5sigglldam Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1444';
20240808@173854.2038 52f0lofajdvd0rcn5sigglldam Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1444';
20240808@173854.2061 52f0lofajdvd0rcn5sigglldam Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1444';
20240808@173854.4114 8rcurfnmilf8tjlsi5nonjfj55 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240808@173854.4162 8rcurfnmilf8tjlsi5nonjfj55 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240808@173854.4214 8rcurfnmilf8tjlsi5nonjfj55 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1445';
20240808@173854.4272 8rcurfnmilf8tjlsi5nonjfj55 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1445';
20240808@173854.4321 8rcurfnmilf8tjlsi5nonjfj55 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1445';
20240808@173854.4345 8rcurfnmilf8tjlsi5nonjfj55 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1445';
20240808@173854.4392 8rcurfnmilf8tjlsi5nonjfj55 Query : use flama_phc
20240808@173854.4395 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240808@173854.4469 8rcurfnmilf8tjlsi5nonjfj55 Query : use flama_phc
20240808@173854.4473 8rcurfnmilf8tjlsi5nonjfj55 Query : select no, estab,szadrsdesc from szadrs where u_coddest=416
20240808@173854.4519 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5501.00.1'
20240808@173854.4718 8rcurfnmilf8tjlsi5nonjfj55 Query : use flama_phc
20240808@173854.4722 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240808@173854.4756 8rcurfnmilf8tjlsi5nonjfj55 Query : use flama_phc
20240808@173854.4759 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 1 valor from td where td.ndoc = 39
20240808@173854.4790 8rcurfnmilf8tjlsi5nonjfj55 Query : use flama_phc
20240808@173854.4793 8rcurfnmilf8tjlsi5nonjfj55 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')
20240808@173854.4834 8rcurfnmilf8tjlsi5nonjfj55 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
20240808@173854.4894 8rcurfnmilf8tjlsi5nonjfj55 Query : use flama_phc
20240808@173854.4897 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 ~inactivo valor from cl where no = '102079' and estab = 0 order by inactivo desc
20240808@173854.4930 8rcurfnmilf8tjlsi5nonjfj55 Query : use flama_phc
20240808@173854.4933 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240808@173854.4964 8rcurfnmilf8tjlsi5nonjfj55 Query : use flama_phc
20240808@173854.4967 8rcurfnmilf8tjlsi5nonjfj55 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240808@173854.5009 8rcurfnmilf8tjlsi5nonjfj55 Query : use flama_phc
20240808@173854.5012 8rcurfnmilf8tjlsi5nonjfj55 Query : select szadrsstamp valor from szadrs where szadrsdesc='bragajav, lda.'
20240808@173854.5077 8rcurfnmilf8tjlsi5nonjfj55 Query : use flama_phc
20240808@173854.5080 8rcurfnmilf8tjlsi5nonjfj55 Query : select 1 valor from td where ndoc = 39
20240808@173854.5093 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240808@173854.5108 8rcurfnmilf8tjlsi5nonjfj55 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.5128 8rcurfnmilf8tjlsi5nonjfj55 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240808@173854.5149 8rcurfnmilf8tjlsi5nonjfj55 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.5165 8rcurfnmilf8tjlsi5nonjfj55 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240808@173854.5199 8rcurfnmilf8tjlsi5nonjfj55 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.5216 8rcurfnmilf8tjlsi5nonjfj55 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240808@173854.5229 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240808@173854.5300 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240808@173854.5314 8rcurfnmilf8tjlsi5nonjfj55 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.5330 8rcurfnmilf8tjlsi5nonjfj55 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240808@173854.5348 8rcurfnmilf8tjlsi5nonjfj55 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66b4f3025066b4f49e7f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240808@173854.5545 8rcurfnmilf8tjlsi5nonjfj55 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.5564 8rcurfnmilf8tjlsi5nonjfj55 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240808@173854.5599 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240808@173854.5612 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240808@173854.5624 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240808@173854.5636 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240808@173854.5648 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240808@173854.5661 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240808@173854.5674 8rcurfnmilf8tjlsi5nonjfj55 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66b4f3025066b4f49e7f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240808@173854.5994 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 fno valor from wsftdata order by fno desc
20240808@173854.6014 8rcurfnmilf8tjlsi5nonjfj55 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.6031 8rcurfnmilf8tjlsi5nonjfj55 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240808@173854.6055 8rcurfnmilf8tjlsi5nonjfj55 Query : select 'normal' from dummy
20240808@173854.6072 8rcurfnmilf8tjlsi5nonjfj55 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66b4f3025066b4f49e7f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',265,102079,0,'2024-08-08',39,'euro',0,0,2024 ,?,?)
20240808@173854.6461 8rcurfnmilf8tjlsi5nonjfj55 Query : use flama_phc
20240808@173854.6464 8rcurfnmilf8tjlsi5nonjfj55 Query : select st.usalote valor from st where st.ref = '324.5501.00.1'
20240808@173854.6496 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5501.00.1'
20240808@173854.6670 8rcurfnmilf8tjlsi5nonjfj55 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.6687 8rcurfnmilf8tjlsi5nonjfj55 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173854.6714 8rcurfnmilf8tjlsi5nonjfj55 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.6730 8rcurfnmilf8tjlsi5nonjfj55 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173854.6738 8rcurfnmilf8tjlsi5nonjfj55 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240808@173854.6751 8rcurfnmilf8tjlsi5nonjfj55 Query : select sestamp valor from se where ref ='324.5501.00.1' and lote = 'r2300908100a'
20240808@173854.6769 8rcurfnmilf8tjlsi5nonjfj55 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.6784 8rcurfnmilf8tjlsi5nonjfj55 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173854.6796 8rcurfnmilf8tjlsi5nonjfj55 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b4f8471466b4f49ea5','aut66b4f3025066b4f49e7f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240808@173854.6800 8rcurfnmilf8tjlsi5nonjfj55 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.6815 8rcurfnmilf8tjlsi5nonjfj55 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173854.6854 8rcurfnmilf8tjlsi5nonjfj55 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b4f8471466b4f49ea5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut66b4f3025066b4f49e7f' ,0,0 ,2,23.00,10000,?,?,?,?)
20240808@173854.7142 8rcurfnmilf8tjlsi5nonjfj55 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66b4f3025066b4f49e7f','2405297','wait',39,'adm09112754980.682000002')
20240808@173854.7232 8rcurfnmilf8tjlsi5nonjfj55 Query : use flama_phc
20240808@173854.7237 8rcurfnmilf8tjlsi5nonjfj55 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240808@173854.7268 8rcurfnmilf8tjlsi5nonjfj55 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1445';
20240808@173854.7295 8rcurfnmilf8tjlsi5nonjfj55 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1445';
20240808@173854.7335 8rcurfnmilf8tjlsi5nonjfj55 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1445';
20240808@173854.7358 8rcurfnmilf8tjlsi5nonjfj55 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1445';
20240808@173854.7900 7400u822acfqul96p98tgsci8t Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240808@173854.7911 7400u822acfqul96p98tgsci8t Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240808@173854.7962 7400u822acfqul96p98tgsci8t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1446';
20240808@173854.8018 7400u822acfqul96p98tgsci8t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1446';
20240808@173854.8068 7400u822acfqul96p98tgsci8t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1446';
20240808@173854.8092 7400u822acfqul96p98tgsci8t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1446';
20240808@173854.8135 7400u822acfqul96p98tgsci8t Query : use flama_phc
20240808@173854.8138 7400u822acfqul96p98tgsci8t Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240808@173854.8203 7400u822acfqul96p98tgsci8t Query : use flama_phc
20240808@173854.8206 7400u822acfqul96p98tgsci8t Query : select no, estab,szadrsdesc from szadrs where u_coddest=416
20240808@173854.8247 7400u822acfqul96p98tgsci8t Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.367.09.00'
20240808@173854.8435 7400u822acfqul96p98tgsci8t Query : use flama_phc
20240808@173854.8439 7400u822acfqul96p98tgsci8t Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240808@173854.8471 7400u822acfqul96p98tgsci8t Query : use flama_phc
20240808@173854.8475 7400u822acfqul96p98tgsci8t Query : select top 1 1 valor from td where td.ndoc = 39
20240808@173854.8505 7400u822acfqul96p98tgsci8t Query : use flama_phc
20240808@173854.8507 7400u822acfqul96p98tgsci8t 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')
20240808@173854.8536 7400u822acfqul96p98tgsci8t 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
20240808@173854.8571 7400u822acfqul96p98tgsci8t Query : use flama_phc
20240808@173854.8573 7400u822acfqul96p98tgsci8t Query : select top 1 ~inactivo valor from cl where no = '102079' and estab = 0 order by inactivo desc
20240808@173854.8603 7400u822acfqul96p98tgsci8t Query : use flama_phc
20240808@173854.8606 7400u822acfqul96p98tgsci8t Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240808@173854.8636 7400u822acfqul96p98tgsci8t Query : use flama_phc
20240808@173854.8638 7400u822acfqul96p98tgsci8t Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240808@173854.8677 7400u822acfqul96p98tgsci8t Query : use flama_phc
20240808@173854.8680 7400u822acfqul96p98tgsci8t Query : select szadrsstamp valor from szadrs where szadrsdesc='bragajav, lda.'
20240808@173854.8724 7400u822acfqul96p98tgsci8t Query : use flama_phc
20240808@173854.8727 7400u822acfqul96p98tgsci8t Query : select 1 valor from td where ndoc = 39
20240808@173854.8740 7400u822acfqul96p98tgsci8t Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240808@173854.8754 7400u822acfqul96p98tgsci8t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.8771 7400u822acfqul96p98tgsci8t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240808@173854.8791 7400u822acfqul96p98tgsci8t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.8805 7400u822acfqul96p98tgsci8t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240808@173854.8834 7400u822acfqul96p98tgsci8t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.8849 7400u822acfqul96p98tgsci8t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240808@173854.8862 7400u822acfqul96p98tgsci8t Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240808@173854.8933 7400u822acfqul96p98tgsci8t Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240808@173854.8947 7400u822acfqul96p98tgsci8t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.8982 7400u822acfqul96p98tgsci8t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240808@173854.8997 7400u822acfqul96p98tgsci8t Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66b4f5665466b4f49ed8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240808@173854.9184 7400u822acfqul96p98tgsci8t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.9201 7400u822acfqul96p98tgsci8t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240808@173854.9236 7400u822acfqul96p98tgsci8t Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240808@173854.9249 7400u822acfqul96p98tgsci8t Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240808@173854.9264 7400u822acfqul96p98tgsci8t Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240808@173854.9276 7400u822acfqul96p98tgsci8t Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240808@173854.9287 7400u822acfqul96p98tgsci8t Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240808@173854.9299 7400u822acfqul96p98tgsci8t Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240808@173854.9310 7400u822acfqul96p98tgsci8t Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66b4f5665466b4f49ed8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240808@173854.9575 7400u822acfqul96p98tgsci8t Query : select top 1 fno valor from wsftdata order by fno desc
20240808@173854.9613 7400u822acfqul96p98tgsci8t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173854.9631 7400u822acfqul96p98tgsci8t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240808@173854.9655 7400u822acfqul96p98tgsci8t Query : select 'normal' from dummy
20240808@173854.9670 7400u822acfqul96p98tgsci8t Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66b4f5665466b4f49ed8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',266,102079,0,'2024-08-08',39,'euro',0,0,2024 ,?,?)
20240808@173855.6990 7400u822acfqul96p98tgsci8t Query : use flama_phc
20240808@173855.8330 7400u822acfqul96p98tgsci8t Query : select st.usalote valor from st where st.ref = '323.367.09.00'
20240808@173855.1052 7400u822acfqul96p98tgsci8t Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '323.367.09.00'
20240808@173855.1241 7400u822acfqul96p98tgsci8t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.1261 7400u822acfqul96p98tgsci8t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173855.1292 7400u822acfqul96p98tgsci8t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.1308 7400u822acfqul96p98tgsci8t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173855.1319 7400u822acfqul96p98tgsci8t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240808@173855.1334 7400u822acfqul96p98tgsci8t Query : select sestamp valor from se where ref ='323.367.09.00' and lote = 'r2400053200a'
20240808@173855.1351 7400u822acfqul96p98tgsci8t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.1368 7400u822acfqul96p98tgsci8t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173855.1384 7400u822acfqul96p98tgsci8t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b4f0938366b4f49f21','aut66b4f5665466b4f49ed8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240808@173855.1389 7400u822acfqul96p98tgsci8t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.1406 7400u822acfqul96p98tgsci8t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173855.1439 7400u822acfqul96p98tgsci8t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b4f0938366b4f49f21',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut66b4f5665466b4f49ed8' ,0,0 ,2,23.00,10000,?,?,?,?)
20240808@173855.1738 7400u822acfqul96p98tgsci8t Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66b4f5665466b4f49ed8','2405298','wait',39,'adm09112754980.682000002')
20240808@173855.1830 7400u822acfqul96p98tgsci8t Query : use flama_phc
20240808@173855.1834 7400u822acfqul96p98tgsci8t Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240808@173855.1866 7400u822acfqul96p98tgsci8t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1446';
20240808@173855.1895 7400u822acfqul96p98tgsci8t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1446';
20240808@173855.1935 7400u822acfqul96p98tgsci8t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1446';
20240808@173855.1958 7400u822acfqul96p98tgsci8t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1446';
20240808@173855.2724 vavdep3m2nfdndte7ql1hij2da Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240808@173855.2737 vavdep3m2nfdndte7ql1hij2da Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240808@173855.2787 vavdep3m2nfdndte7ql1hij2da Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1447';
20240808@173855.2845 vavdep3m2nfdndte7ql1hij2da Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1447';
20240808@173855.2893 vavdep3m2nfdndte7ql1hij2da Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1447';
20240808@173855.2919 vavdep3m2nfdndte7ql1hij2da Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1447';
20240808@173855.2966 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.2970 vavdep3m2nfdndte7ql1hij2da Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240808@173855.3039 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.3042 vavdep3m2nfdndte7ql1hij2da Query : select no, estab,szadrsdesc from szadrs where u_coddest=2166
20240808@173855.3135 vavdep3m2nfdndte7ql1hij2da Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.938.00.01'
20240808@173855.3321 vavdep3m2nfdndte7ql1hij2da Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1871.00.1'
20240808@173855.3490 vavdep3m2nfdndte7ql1hij2da Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240808@173855.3654 vavdep3m2nfdndte7ql1hij2da 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'
20240808@173855.3682 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.3685 vavdep3m2nfdndte7ql1hij2da Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240808@173855.3718 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.3721 vavdep3m2nfdndte7ql1hij2da Query : select top 1 1 valor from td where td.ndoc = 39
20240808@173855.3750 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.3753 vavdep3m2nfdndte7ql1hij2da 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')
20240808@173855.3783 vavdep3m2nfdndte7ql1hij2da 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
20240808@173855.3821 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.3824 vavdep3m2nfdndte7ql1hij2da Query : select top 1 ~inactivo valor from cl where no = '102128' and estab = 0 order by inactivo desc
20240808@173855.3976 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.3979 vavdep3m2nfdndte7ql1hij2da Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240808@173855.4010 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.4013 vavdep3m2nfdndte7ql1hij2da Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240808@173855.4053 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.4056 vavdep3m2nfdndte7ql1hij2da Query : select szadrsstamp valor from szadrs where szadrsdesc='n.martins-com.de elect.e electrÓnica, lda.'
20240808@173855.4102 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.4105 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from td where ndoc = 39
20240808@173855.4118 vavdep3m2nfdndte7ql1hij2da Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240808@173855.4135 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.4153 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240808@173855.4172 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.4186 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240808@173855.4216 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.4231 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240808@173855.4244 vavdep3m2nfdndte7ql1hij2da Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240808@173855.4316 vavdep3m2nfdndte7ql1hij2da Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240808@173855.4330 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.4348 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240808@173855.4365 vavdep3m2nfdndte7ql1hij2da Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66b4f1692566b4f49f67' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240808@173855.4554 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.4579 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240808@173855.4617 vavdep3m2nfdndte7ql1hij2da Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240808@173855.4629 vavdep3m2nfdndte7ql1hij2da Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240808@173855.4642 vavdep3m2nfdndte7ql1hij2da Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240808@173855.4654 vavdep3m2nfdndte7ql1hij2da Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240808@173855.4666 vavdep3m2nfdndte7ql1hij2da Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240808@173855.4678 vavdep3m2nfdndte7ql1hij2da Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240808@173855.4690 vavdep3m2nfdndte7ql1hij2da Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66b4f1692566b4f49f67',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240808@173855.4945 vavdep3m2nfdndte7ql1hij2da Query : select top 1 fno valor from wsftdata order by fno desc
20240808@173855.4965 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.4982 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240808@173855.5006 vavdep3m2nfdndte7ql1hij2da Query : select 'normal' from dummy
20240808@173855.5023 vavdep3m2nfdndte7ql1hij2da Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66b4f1692566b4f49f67',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',267,102128,0,'2024-08-08',39,'euro',0,0,2024 ,?,?)
20240808@173855.5352 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.5355 vavdep3m2nfdndte7ql1hij2da Query : select st.usalote valor from st where st.ref = '324.938.00.01'
20240808@173855.5383 vavdep3m2nfdndte7ql1hij2da 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.938.00.01'
20240808@173855.5546 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.5563 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173855.5598 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.5614 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173855.5624 vavdep3m2nfdndte7ql1hij2da Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240808@173855.5637 vavdep3m2nfdndte7ql1hij2da Query : select sestamp valor from se where ref ='324.938.00.01' and lote = 'r2301371100a'
20240808@173855.5652 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.5667 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173855.5680 vavdep3m2nfdndte7ql1hij2da Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b4f4049166b4f49f89','aut66b4f1692566b4f49f67' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240808@173855.5684 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.5699 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173855.5730 vavdep3m2nfdndte7ql1hij2da Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b4f4049166b4f49f89',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66b4f1692566b4f49f67' ,0,0 ,2,23.00,10000,?,?,?,?)
20240808@173855.6146 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.6228 vavdep3m2nfdndte7ql1hij2da Query : select st.usalote valor from st where st.ref = '324.1871.00.1'
20240808@173855.7257 vavdep3m2nfdndte7ql1hij2da 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.1871.00.1'
20240808@173855.7470 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.7489 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173855.7518 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.7534 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173855.7544 vavdep3m2nfdndte7ql1hij2da Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240808@173855.7559 vavdep3m2nfdndte7ql1hij2da Query : select sestamp valor from se where ref ='324.1871.00.1' and lote = 'r2400125200a'
20240808@173855.7577 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.7593 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173855.7605 vavdep3m2nfdndte7ql1hij2da Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b4f7599466b4f49fb9','aut66b4f1692566b4f49f67' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240808@173855.7609 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.7625 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173855.7655 vavdep3m2nfdndte7ql1hij2da Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b4f7599466b4f49fb9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66b4f1692566b4f49f67' ,0,0 ,2,23.00,20000,?,?,?,?)
20240808@173855.7931 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.7934 vavdep3m2nfdndte7ql1hij2da Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240808@173855.7956 vavdep3m2nfdndte7ql1hij2da Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.948.00.01'
20240808@173855.8202 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.8220 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173855.8263 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.8277 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173855.8286 vavdep3m2nfdndte7ql1hij2da Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240808@173855.8298 vavdep3m2nfdndte7ql1hij2da Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240808@173855.8313 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.8328 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173855.8340 vavdep3m2nfdndte7ql1hij2da Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b4f1162466b4f49fca','aut66b4f1692566b4f49f67' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240808@173855.8344 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.8358 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173855.8386 vavdep3m2nfdndte7ql1hij2da Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b4f1162466b4f49fca',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66b4f1692566b4f49f67' ,0,0 ,2,23.00,30000,?,?,?,?)
20240808@173855.8662 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.8665 vavdep3m2nfdndte7ql1hij2da Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240808@173855.8685 vavdep3m2nfdndte7ql1hij2da 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'
20240808@173855.8698 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.8714 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173855.8741 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.8755 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173855.8764 vavdep3m2nfdndte7ql1hij2da Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240808@173855.8776 vavdep3m2nfdndte7ql1hij2da Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240897'
20240808@173855.8790 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.8806 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240808@173855.8819 vavdep3m2nfdndte7ql1hij2da Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b4f0909666b4f49fd6','aut66b4f1692566b4f49f67' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240808@173855.8823 vavdep3m2nfdndte7ql1hij2da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240808@173855.8837 vavdep3m2nfdndte7ql1hij2da Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240808@173855.8868 vavdep3m2nfdndte7ql1hij2da Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b4f0909666b4f49fd6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66b4f1692566b4f49f67' ,0,0 ,2,23.00,40000,?,?,?,?)
20240808@173855.9132 vavdep3m2nfdndte7ql1hij2da Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66b4f1692566b4f49f67','2405299','wait',39,'adm09112754980.682000002')
20240808@173855.9204 vavdep3m2nfdndte7ql1hij2da Query : use flama_phc
20240808@173855.9207 vavdep3m2nfdndte7ql1hij2da Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240808@173855.9236 vavdep3m2nfdndte7ql1hij2da Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1447';
20240808@173855.9264 vavdep3m2nfdndte7ql1hij2da Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1447';
20240808@173855.9299 vavdep3m2nfdndte7ql1hij2da Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1447';
20240808@173855.9322 vavdep3m2nfdndte7ql1hij2da Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1447';

20240809@113737.4006 oe588ibad03hnd4ui2kuehbm9f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1448';
20240809@113737.4074 oe588ibad03hnd4ui2kuehbm9f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1448';
20240809@113737.4102 oe588ibad03hnd4ui2kuehbm9f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1448';
20240809@113737.4157 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113737.4161 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240809@113737.4268 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113737.4272 oe588ibad03hnd4ui2kuehbm9f Query : select no, estab,szadrsdesc from szadrs where u_coddest=2227
20240809@113737.4372 oe588ibad03hnd4ui2kuehbm9f 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'
20240809@113737.4564 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4906.00.1'
20240809@113737.4780 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4906.00.1'
20240809@113737.4811 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113737.4815 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240809@113737.5025 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113737.5028 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 1 valor from td where td.ndoc = 39
20240809@113737.5138 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113737.5142 oe588ibad03hnd4ui2kuehbm9f 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')
20240809@113737.5227 oe588ibad03hnd4ui2kuehbm9f 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
20240809@113737.5382 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113737.5387 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 ~inactivo valor from cl where no = '101428' and estab = 0 order by inactivo desc
20240809@113737.5528 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113737.5531 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240809@113737.5684 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113737.5687 oe588ibad03hnd4ui2kuehbm9f Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240809@113737.5781 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113737.5785 oe588ibad03hnd4ui2kuehbm9f Query : select szadrsstamp valor from szadrs where szadrsdesc='el corte inglês - alcochete'
20240809@113737.5851 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113737.5854 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from td where ndoc = 39
20240809@113737.5950 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240809@113737.6048 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113737.6377 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240809@113737.6503 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113737.6525 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240809@113737.6565 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113737.6583 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240809@113737.6603 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240809@113737.6853 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240809@113737.6995 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113737.7017 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240809@113737.7072 oe588ibad03hnd4ui2kuehbm9f Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66b5f9787366b5f171a1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240809@113737.7482 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113737.7508 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240809@113737.7562 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240809@113737.7685 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240809@113737.7920 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240809@113737.8033 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240809@113737.8119 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240809@113737.8227 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240809@113737.8403 oe588ibad03hnd4ui2kuehbm9f Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66b5f9787366b5f171a1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240809@113737.9878 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 fno valor from wsftdata order by fno desc
20240809@113738.2000 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.4900 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240809@113738.7800 oe588ibad03hnd4ui2kuehbm9f Query : select 'normal' from dummy
20240809@113738.1330 oe588ibad03hnd4ui2kuehbm9f Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66b5f9787366b5f171a1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',268,101428,0,'2024-08-09',39,'euro',0,0,2024 ,?,?)
20240809@113738.6300 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113738.6340 oe588ibad03hnd4ui2kuehbm9f Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240809@113738.7950 oe588ibad03hnd4ui2kuehbm9f 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'
20240809@113738.9580 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.9770 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240809@113738.1011 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.1032 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240809@113738.1042 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240809@113738.1104 oe588ibad03hnd4ui2kuehbm9f Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240897'
20240809@113738.1175 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.1193 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240809@113738.1214 oe588ibad03hnd4ui2kuehbm9f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b5f6312066b5f1721c','aut66b5f9787366b5f171a1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240809@113738.1275 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.1294 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240809@113738.1336 oe588ibad03hnd4ui2kuehbm9f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b5f6312066b5f1721c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66b5f9787366b5f171a1' ,0,0 ,2,23.00,10000,?,?,?,?)
20240809@113738.2277 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113738.2281 oe588ibad03hnd4ui2kuehbm9f Query : select st.usalote valor from st where st.ref = '324.4906.00.1'
20240809@113738.2308 oe588ibad03hnd4ui2kuehbm9f 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.4906.00.1'
20240809@113738.2475 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.2497 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240809@113738.2533 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.2554 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240809@113738.2566 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240809@113738.2585 oe588ibad03hnd4ui2kuehbm9f Query : select sestamp valor from se where ref ='324.4906.00.1' and lote = 'r2300207200a'
20240809@113738.2610 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.2629 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240809@113738.2643 oe588ibad03hnd4ui2kuehbm9f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b5f3197766b5f1723f','aut66b5f9787366b5f171a1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240809@113738.2649 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.2668 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240809@113738.2704 oe588ibad03hnd4ui2kuehbm9f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b5f3197766b5f1723f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66b5f9787366b5f171a1' ,0,0 ,2,23.00,20000,?,?,?,?)
20240809@113738.3038 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.3060 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240809@113738.4334 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.4357 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240809@113738.4369 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240809@113738.4386 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.4406 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240809@113738.4420 oe588ibad03hnd4ui2kuehbm9f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b5f2283666b5f1726b','aut66b5f9787366b5f171a1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240809@113738.4425 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.4447 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240809@113738.4486 oe588ibad03hnd4ui2kuehbm9f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b5f2283666b5f1726b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b5f9787366b5f171a1' ,0,0 ,2,23.00,30000,?,?,?)
20240809@113738.4817 oe588ibad03hnd4ui2kuehbm9f Query : use flama_phc
20240809@113738.4821 oe588ibad03hnd4ui2kuehbm9f Query : select st.usalote valor from st where st.ref = '324.4906.00.1'
20240809@113738.4846 oe588ibad03hnd4ui2kuehbm9f 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.4906.00.1'
20240809@113738.4863 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.4886 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240809@113738.4918 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.4937 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240809@113738.4947 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240809@113738.4962 oe588ibad03hnd4ui2kuehbm9f Query : select sestamp valor from se where ref ='324.4906.00.1' and lote = 'r2300207200a'
20240809@113738.4977 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.4998 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240809@113738.5013 oe588ibad03hnd4ui2kuehbm9f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b5f7610166b5f17279','aut66b5f9787366b5f171a1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240809@113738.5018 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.5061 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240809@113738.5099 oe588ibad03hnd4ui2kuehbm9f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b5f7610166b5f17279',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66b5f9787366b5f171a1' ,0,0 ,2,23.00,50000,?,?,?,?)
20240809@113738.5376 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.5398 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240809@113738.5429 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.5446 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240809@113738.5457 oe588ibad03hnd4ui2kuehbm9f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240809@113738.5471 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240809@113738.5489 oe588ibad03hnd4ui2kuehbm9f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240809@113738.5504 oe588ibad03hnd4ui2kuehbm9f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b5f7033566b5f17285','aut66b5f9787366b5f171a1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240809@113738.5510 oe588ibad03hnd4ui2kuehbm9f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
