20241212@080219.1834 djpq3shu22ipboi1bp925v7urp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080219.1847 djpq3shu22ipboi1bp925v7urp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a932193675a988b2c','aut675a914445675a988a79' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080219.1853 djpq3shu22ipboi1bp925v7urp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.1871 djpq3shu22ipboi1bp925v7urp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080219.1943 djpq3shu22ipboi1bp925v7urp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a932193675a988b2c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut675a914445675a988a79' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20241212@080219.2252 djpq3shu22ipboi1bp925v7urp Query : use flama_phc
20241212@080219.2262 djpq3shu22ipboi1bp925v7urp Query : select st.usalote valor from st where st.ref = '324.1871.00.1'
20241212@080219.2283 djpq3shu22ipboi1bp925v7urp 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'
20241212@080219.2489 djpq3shu22ipboi1bp925v7urp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.2505 djpq3shu22ipboi1bp925v7urp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080219.2530 djpq3shu22ipboi1bp925v7urp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.2545 djpq3shu22ipboi1bp925v7urp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080219.2553 djpq3shu22ipboi1bp925v7urp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080219.2565 djpq3shu22ipboi1bp925v7urp Query : select sestamp valor from se where ref ='324.1871.00.1' and lote = 'r2400437200a'
20241212@080219.2624 djpq3shu22ipboi1bp925v7urp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.2639 djpq3shu22ipboi1bp925v7urp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080219.2650 djpq3shu22ipboi1bp925v7urp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a941549675a988b40','aut675a914445675a988a79' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080219.2655 djpq3shu22ipboi1bp925v7urp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.2670 djpq3shu22ipboi1bp925v7urp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080219.2696 djpq3shu22ipboi1bp925v7urp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a941549675a988b40',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut675a914445675a988a79' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20241212@080219.3015 djpq3shu22ipboi1bp925v7urp Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675a914445675a988a79','2408488','wait',39,'adm09112754980.682000002')
20241212@080219.3086 djpq3shu22ipboi1bp925v7urp Query : use flama_phc
20241212@080219.3089 djpq3shu22ipboi1bp925v7urp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@080219.3171 djpq3shu22ipboi1bp925v7urp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3898';
20241212@080219.3210 djpq3shu22ipboi1bp925v7urp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3898';
20241212@080219.3265 djpq3shu22ipboi1bp925v7urp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3898';
20241212@080219.3355 djpq3shu22ipboi1bp925v7urp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3898';
20241212@080219.3897 ni5nihl5akejqmifgmp7rc8f47 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@080219.3910 ni5nihl5akejqmifgmp7rc8f47 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@080219.3975 ni5nihl5akejqmifgmp7rc8f47 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3899';
20241212@080219.4037 ni5nihl5akejqmifgmp7rc8f47 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3899';
20241212@080219.4150 ni5nihl5akejqmifgmp7rc8f47 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3899';
20241212@080219.4190 ni5nihl5akejqmifgmp7rc8f47 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3899';
20241212@080219.5624 ni5nihl5akejqmifgmp7rc8f47 Query : use flama_phc
20241212@080219.5630 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241212@080219.5695 ni5nihl5akejqmifgmp7rc8f47 Query : use flama_phc
20241212@080219.5699 ni5nihl5akejqmifgmp7rc8f47 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20241212@080219.5785 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8253.00.1'
20241212@080219.5906 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408492 and bi.ref ='327.8253.00.1' and bi.lordem =1
20241212@080219.6279 ni5nihl5akejqmifgmp7rc8f47 Query : use flama_phc
20241212@080219.6283 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241212@080219.6321 ni5nihl5akejqmifgmp7rc8f47 Query : use flama_phc
20241212@080219.6325 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 1 valor from td where td.ndoc = 39
20241212@080219.6356 ni5nihl5akejqmifgmp7rc8f47 Query : use flama_phc
20241212@080219.6359 ni5nihl5akejqmifgmp7rc8f47 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')
20241212@080219.6387 ni5nihl5akejqmifgmp7rc8f47 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
20241212@080219.6420 ni5nihl5akejqmifgmp7rc8f47 Query : use flama_phc
20241212@080219.6423 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241212@080219.6451 ni5nihl5akejqmifgmp7rc8f47 Query : use flama_phc
20241212@080219.6454 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241212@080219.6482 ni5nihl5akejqmifgmp7rc8f47 Query : use flama_phc
20241212@080219.6484 ni5nihl5akejqmifgmp7rc8f47 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241212@080219.6524 ni5nihl5akejqmifgmp7rc8f47 Query : use flama_phc
20241212@080219.6527 ni5nihl5akejqmifgmp7rc8f47 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20241212@080219.6570 ni5nihl5akejqmifgmp7rc8f47 Query : use flama_phc
20241212@080219.6572 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from td where ndoc = 39
20241212@080219.6585 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241212@080219.6598 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.6615 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080219.6635 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.6650 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080219.6679 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.6694 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080219.6707 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080219.6768 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080219.6782 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.6797 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080219.6812 ni5nihl5akejqmifgmp7rc8f47 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675a907942675a988ba3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241212@080219.6972 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.7014 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080219.7049 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241212@080219.7062 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241212@080219.7074 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241212@080219.7086 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241212@080219.7127 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241212@080219.7139 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241212@080219.7150 ni5nihl5akejqmifgmp7rc8f47 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675a907942675a988ba3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241212@080219.7525 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 fno valor from wsftdata order by fno desc
20241212@080219.7593 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.7609 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080219.7631 ni5nihl5akejqmifgmp7rc8f47 Query : select 'normal' from dummy
20241212@080219.7645 ni5nihl5akejqmifgmp7rc8f47 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675a907942675a988ba3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2387,100810,0,'2024-12-12',39,'euro',0,0,2024 ,?,?)
20241212@080219.8008 ni5nihl5akejqmifgmp7rc8f47 Query : use flama_phc
20241212@080219.8050 ni5nihl5akejqmifgmp7rc8f47 Query : select st.usalote valor from st where st.ref = '327.8253.00.1'
20241212@080219.8112 ni5nihl5akejqmifgmp7rc8f47 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.8253.00.1'
20241212@080219.8245 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.8265 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080219.8290 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.8305 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080219.8313 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080219.8325 ni5nihl5akejqmifgmp7rc8f47 Query : select sestamp valor from se where ref ='327.8253.00.1' and lote = 'r2400073100b'
20241212@080219.8346 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.8363 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080219.8379 ni5nihl5akejqmifgmp7rc8f47 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a970172675a988bcb','aut675a907942675a988ba3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080219.8384 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.8400 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080219.8433 ni5nihl5akejqmifgmp7rc8f47 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a970172675a988bcb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut675a907942675a988ba3' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241212@080219.8823 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.9052 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080219.9081 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.9101 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080219.9111 ni5nihl5akejqmifgmp7rc8f47 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080219.9125 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.9142 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080219.9155 ni5nihl5akejqmifgmp7rc8f47 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a936241675a988bde','aut675a907942675a988ba3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080219.9160 ni5nihl5akejqmifgmp7rc8f47 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080219.9177 ni5nihl5akejqmifgmp7rc8f47 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080219.9207 ni5nihl5akejqmifgmp7rc8f47 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675a936241675a988bde',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675a907942675a988ba3' ,0,0 ,2,23.00,20000,?,?,?)
20241212@080219.9442 ni5nihl5akejqmifgmp7rc8f47 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675a907942675a988ba3','2408492','wait',39,'adm09112754980.682000002')
20241212@080219.9551 ni5nihl5akejqmifgmp7rc8f47 Query : use flama_phc
20241212@080219.9555 ni5nihl5akejqmifgmp7rc8f47 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@080219.9597 ni5nihl5akejqmifgmp7rc8f47 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3899';
20241212@080219.9645 ni5nihl5akejqmifgmp7rc8f47 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3899';
20241212@080219.9697 ni5nihl5akejqmifgmp7rc8f47 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3899';
20241212@080219.9735 ni5nihl5akejqmifgmp7rc8f47 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3899';
20241212@080220.7820 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@080220.8650 3fcumvbjn1fm43kcek6hcl4j0t Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@080220.1387 3fcumvbjn1fm43kcek6hcl4j0t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3900';
20241212@080220.1725 3fcumvbjn1fm43kcek6hcl4j0t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3900';
20241212@080220.2080 3fcumvbjn1fm43kcek6hcl4j0t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3900';
20241212@080220.2391 3fcumvbjn1fm43kcek6hcl4j0t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3900';
20241212@080220.2743 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080220.2785 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241212@080220.3369 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080220.3412 3fcumvbjn1fm43kcek6hcl4j0t Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20241212@080220.3585 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9006.00.1'
20241212@080220.3929 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408493 and bi.ref ='328.9006.00.1' and bi.lordem =1
20241212@080220.5068 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9345.00.1'
20241212@080220.5551 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408493 and bi.ref ='328.9345.00.1' and bi.lordem =2
20241212@080220.6363 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080220.6405 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241212@080220.6783 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080220.6824 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 1 valor from td where td.ndoc = 39
20241212@080220.7196 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080220.7237 3fcumvbjn1fm43kcek6hcl4j0t 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')
20241212@080220.7359 3fcumvbjn1fm43kcek6hcl4j0t 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
20241212@080220.7800 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080220.7842 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241212@080220.8104 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080220.8146 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241212@080220.8517 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080220.8559 3fcumvbjn1fm43kcek6hcl4j0t Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241212@080220.9015 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080220.9057 3fcumvbjn1fm43kcek6hcl4j0t Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20241212@080220.9513 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080220.9557 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from td where ndoc = 39
20241212@080220.9599 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241212@080220.9774 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080220.9914 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080221.1820 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080221.4360 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080221.1149 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080221.1402 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080221.1777 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080221.2736 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080221.3023 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080221.3111 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080221.3247 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675a943595675a988d2b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241212@080221.3556 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080221.3776 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080221.4488 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241212@080221.4698 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241212@080221.4907 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241212@080221.5114 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241212@080221.5321 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241212@080221.5420 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241212@080221.5461 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675a943595675a988d2b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241212@080221.5899 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 fno valor from wsftdata order by fno desc
20241212@080221.6008 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080221.6272 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080221.6712 3fcumvbjn1fm43kcek6hcl4j0t Query : select 'normal' from dummy
20241212@080221.7003 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675a943595675a988d2b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2388,100810,0,'2024-12-12',39,'euro',0,0,2024 ,?,?)
20241212@080221.7633 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080221.7674 3fcumvbjn1fm43kcek6hcl4j0t Query : select st.usalote valor from st where st.ref = '328.9006.00.1'
20241212@080221.9032 3fcumvbjn1fm43kcek6hcl4j0t 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 = '328.9006.00.1'
20241212@080221.9358 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080221.9612 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080222.8900 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.3440 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080222.5100 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080222.7590 3fcumvbjn1fm43kcek6hcl4j0t Query : select sestamp valor from se where ref ='328.9006.00.1' and lote = 'r2300691200a'
20241212@080222.1053 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.1286 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080222.1425 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a953127675a988e19','aut675a943595675a988d2b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080222.1469 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.1574 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080222.2060 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a953127675a988e19',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675a943595675a988d2b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241212@080222.2482 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.2509 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080222.2638 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.2890 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080222.3057 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080222.3306 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.3559 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080222.3787 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a948259675a988e50','aut675a943595675a988d2b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080222.3831 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.4088 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080222.4564 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675a948259675a988e50',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675a943595675a988d2b' ,0,0 ,2,23.00,20000,?,?,?)
20241212@080222.5308 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080222.5354 3fcumvbjn1fm43kcek6hcl4j0t Query : select st.usalote valor from st where st.ref = '328.9345.00.1'
20241212@080222.5714 3fcumvbjn1fm43kcek6hcl4j0t 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 = '328.9345.00.1'
20241212@080222.6437 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.6690 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080222.7047 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.7265 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080222.7290 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080222.7312 3fcumvbjn1fm43kcek6hcl4j0t Query : select sestamp valor from se where ref ='328.9345.00.1' and lote = 'r2101101300a'
20241212@080222.7518 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.7544 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080222.7567 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a909382675a988eb7','aut675a943595675a988d2b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080222.7571 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.7596 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080222.7642 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a909382675a988eb7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675a943595675a988d2b' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241212@080222.7959 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.7991 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080222.8047 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.8082 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080222.8100 3fcumvbjn1fm43kcek6hcl4j0t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080222.8115 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.8137 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080222.8160 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a935188675a988ec6','aut675a943595675a988d2b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080222.8184 3fcumvbjn1fm43kcek6hcl4j0t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080222.8435 3fcumvbjn1fm43kcek6hcl4j0t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080222.9057 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675a935188675a988ec6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675a943595675a988d2b' ,0,0 ,2,23.00,50000,?,?,?)
20241212@080222.9613 3fcumvbjn1fm43kcek6hcl4j0t Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675a943595675a988d2b','2408493','wait',39,'adm09112754980.682000002')
20241212@080223.2370 3fcumvbjn1fm43kcek6hcl4j0t Query : use flama_phc
20241212@080223.2790 3fcumvbjn1fm43kcek6hcl4j0t Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@080223.5260 3fcumvbjn1fm43kcek6hcl4j0t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3900';
20241212@080223.8580 3fcumvbjn1fm43kcek6hcl4j0t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3900';
20241212@080223.1128 3fcumvbjn1fm43kcek6hcl4j0t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3900';
20241212@080223.1439 3fcumvbjn1fm43kcek6hcl4j0t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3900';
20241212@080223.2659 hab5obofgvs82mt6nr2dq31cg4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@080223.2702 hab5obofgvs82mt6nr2dq31cg4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@080223.2895 hab5obofgvs82mt6nr2dq31cg4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3901';
20241212@080223.3024 hab5obofgvs82mt6nr2dq31cg4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3901';
20241212@080223.3094 hab5obofgvs82mt6nr2dq31cg4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3901';
20241212@080223.3223 hab5obofgvs82mt6nr2dq31cg4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3901';
20241212@080223.3346 hab5obofgvs82mt6nr2dq31cg4 Query : use flama_phc
20241212@080223.3349 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241212@080223.3681 hab5obofgvs82mt6nr2dq31cg4 Query : use flama_phc
20241212@080223.3693 hab5obofgvs82mt6nr2dq31cg4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1161
20241212@080223.3863 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8253.00.1'
20241212@080223.3920 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408496 and bi.ref ='327.8253.00.1' and bi.lordem =1
20241212@080223.4472 hab5obofgvs82mt6nr2dq31cg4 Query : use flama_phc
20241212@080223.4475 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241212@080223.4520 hab5obofgvs82mt6nr2dq31cg4 Query : use flama_phc
20241212@080223.4523 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 1 valor from td where td.ndoc = 39
20241212@080223.4681 hab5obofgvs82mt6nr2dq31cg4 Query : use flama_phc
20241212@080223.4684 hab5obofgvs82mt6nr2dq31cg4 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')
20241212@080223.4840 hab5obofgvs82mt6nr2dq31cg4 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
20241212@080223.4884 hab5obofgvs82mt6nr2dq31cg4 Query : use flama_phc
20241212@080223.4888 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241212@080223.5327 hab5obofgvs82mt6nr2dq31cg4 Query : use flama_phc
20241212@080223.5333 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241212@080223.5375 hab5obofgvs82mt6nr2dq31cg4 Query : use flama_phc
20241212@080223.5379 hab5obofgvs82mt6nr2dq31cg4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241212@080223.5474 hab5obofgvs82mt6nr2dq31cg4 Query : use flama_phc
20241212@080223.5507 hab5obofgvs82mt6nr2dq31cg4 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - Évora'
20241212@080223.5559 hab5obofgvs82mt6nr2dq31cg4 Query : use flama_phc
20241212@080223.5581 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from td where ndoc = 39
20241212@080223.5596 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241212@080223.5686 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080223.5704 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080223.5858 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080223.5876 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080223.6058 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080223.6080 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080223.6092 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080223.6244 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080223.6262 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080223.6370 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080223.6390 hab5obofgvs82mt6nr2dq31cg4 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675a983037675a988f94' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241212@080223.6633 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080223.6746 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080223.6874 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241212@080223.6887 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241212@080223.6968 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241212@080223.6981 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241212@080223.6995 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241212@080223.7007 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241212@080223.7021 hab5obofgvs82mt6nr2dq31cg4 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675a983037675a988f94',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241212@080223.7406 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 fno valor from wsftdata order by fno desc
20241212@080223.8037 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080223.9751 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080223.9779 hab5obofgvs82mt6nr2dq31cg4 Query : select 'normal' from dummy
20241212@080223.9794 hab5obofgvs82mt6nr2dq31cg4 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675a983037675a988f94',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2389,101621,0,'2024-12-12',39,'euro',0,0,2024 ,?,?)
20241212@080224.1910 hab5obofgvs82mt6nr2dq31cg4 Query : use flama_phc
20241212@080224.1950 hab5obofgvs82mt6nr2dq31cg4 Query : select st.usalote valor from st where st.ref = '327.8253.00.1'
20241212@080224.2160 hab5obofgvs82mt6nr2dq31cg4 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.8253.00.1'
20241212@080224.2310 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.2470 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080224.4080 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.5980 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080224.6070 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080224.6200 hab5obofgvs82mt6nr2dq31cg4 Query : select sestamp valor from se where ref ='327.8253.00.1' and lote = 'r2400073100b'
20241212@080224.6320 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.6480 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080224.6620 hab5obofgvs82mt6nr2dq31cg4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a972772675a98900f','aut675a983037675a988f94' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080224.6680 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.6840 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080224.7900 hab5obofgvs82mt6nr2dq31cg4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a972772675a98900f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675a983037675a988f94' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241212@080224.1194 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.1211 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080224.1238 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.1254 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080224.1264 hab5obofgvs82mt6nr2dq31cg4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080224.1278 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.1346 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080224.1358 hab5obofgvs82mt6nr2dq31cg4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a955984675a98901f','aut675a983037675a988f94' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080224.1363 hab5obofgvs82mt6nr2dq31cg4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.1379 hab5obofgvs82mt6nr2dq31cg4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080224.1410 hab5obofgvs82mt6nr2dq31cg4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675a955984675a98901f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675a983037675a988f94' ,0,0 ,2,23.00,20000,?,?,?)
20241212@080224.1819 hab5obofgvs82mt6nr2dq31cg4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675a983037675a988f94','2408496','wait',39,'adm09112754980.682000002')
20241212@080224.1955 hab5obofgvs82mt6nr2dq31cg4 Query : use flama_phc
20241212@080224.1959 hab5obofgvs82mt6nr2dq31cg4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@080224.1989 hab5obofgvs82mt6nr2dq31cg4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3901';
20241212@080224.2112 hab5obofgvs82mt6nr2dq31cg4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3901';
20241212@080224.2165 hab5obofgvs82mt6nr2dq31cg4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3901';
20241212@080224.2248 hab5obofgvs82mt6nr2dq31cg4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3901';
20241212@080224.2899 f7k5l3aon0a38aoutja66rl0sv Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@080224.2910 f7k5l3aon0a38aoutja66rl0sv Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@080224.3145 f7k5l3aon0a38aoutja66rl0sv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3902';
20241212@080224.3310 f7k5l3aon0a38aoutja66rl0sv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3902';
20241212@080224.3376 f7k5l3aon0a38aoutja66rl0sv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3902';
20241212@080224.3527 f7k5l3aon0a38aoutja66rl0sv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3902';
20241212@080224.3595 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080224.3598 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241212@080224.3735 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080224.3739 f7k5l3aon0a38aoutja66rl0sv Query : select no, estab,szadrsdesc from szadrs where u_coddest=233
20241212@080224.3877 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20241212@080224.3898 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408497 and bi.ref ='324.1831.00.2' and bi.lordem =1
20241212@080224.4494 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20241212@080224.4790 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408497 and bi.ref ='324.1833.00.2' and bi.lordem =2
20241212@080224.5411 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080224.5415 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241212@080224.5492 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080224.5536 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 1 valor from td where td.ndoc = 39
20241212@080224.5594 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080224.5597 f7k5l3aon0a38aoutja66rl0sv 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')
20241212@080224.5628 f7k5l3aon0a38aoutja66rl0sv 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
20241212@080224.5697 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080224.5724 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241212@080224.5758 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080224.5761 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241212@080224.5792 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080224.5795 f7k5l3aon0a38aoutja66rl0sv Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241212@080224.5880 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080224.5883 f7k5l3aon0a38aoutja66rl0sv Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - tudo para o seu lar'
20241212@080224.6061 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080224.6064 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from td where ndoc = 39
20241212@080224.6077 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241212@080224.6091 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.6110 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080224.6182 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.6198 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080224.6226 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.6241 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080224.6253 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080224.6422 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080224.6463 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.6480 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080224.6495 f7k5l3aon0a38aoutja66rl0sv Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675a999309675a989098' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241212@080224.6724 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.6823 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080224.6856 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241212@080224.6868 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241212@080224.6880 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241212@080224.6891 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241212@080224.6903 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241212@080224.6982 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241212@080224.6997 f7k5l3aon0a38aoutja66rl0sv Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675a999309675a989098',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241212@080224.7384 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 fno valor from wsftdata order by fno desc
20241212@080224.7471 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.7487 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080224.7510 f7k5l3aon0a38aoutja66rl0sv Query : select 'normal' from dummy
20241212@080224.7525 f7k5l3aon0a38aoutja66rl0sv Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675a999309675a989098',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2390,101621,0,'2024-12-12',39,'euro',0,0,2024 ,?,?)
20241212@080224.7903 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080224.7907 f7k5l3aon0a38aoutja66rl0sv Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20241212@080224.7931 f7k5l3aon0a38aoutja66rl0sv 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.1831.00.2'
20241212@080224.7947 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.7967 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080224.8085 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.8103 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080224.8149 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080224.8243 f7k5l3aon0a38aoutja66rl0sv Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400922200a'
20241212@080224.8256 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.8276 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080224.8288 f7k5l3aon0a38aoutja66rl0sv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a915823675a9890c9','aut675a999309675a989098' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080224.8293 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.8313 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080224.8551 f7k5l3aon0a38aoutja66rl0sv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a915823675a9890c9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut675a999309675a989098' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241212@080224.8940 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.8972 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080224.9160 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.9220 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080224.9231 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080224.9245 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.9284 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080224.9365 f7k5l3aon0a38aoutja66rl0sv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a954282675a9890e1','aut675a999309675a989098' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080224.9370 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080224.9386 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080224.9490 f7k5l3aon0a38aoutja66rl0sv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675a954282675a9890e1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675a999309675a989098' ,0,0 ,2,23.00,20000,?,?,?)
20241212@080224.9842 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080224.9846 f7k5l3aon0a38aoutja66rl0sv Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20241212@080224.9934 f7k5l3aon0a38aoutja66rl0sv 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.1833.00.2'
20241212@080225.1560 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.1740 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080225.2060 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.2990 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080225.3090 f7k5l3aon0a38aoutja66rl0sv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080225.3240 f7k5l3aon0a38aoutja66rl0sv Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20241212@080225.4360 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.4810 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080225.4930 f7k5l3aon0a38aoutja66rl0sv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a966655675a98910a','aut675a999309675a989098' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080225.4980 f7k5l3aon0a38aoutja66rl0sv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.5140 f7k5l3aon0a38aoutja66rl0sv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080225.5460 f7k5l3aon0a38aoutja66rl0sv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a966655675a98910a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675a999309675a989098' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241212@080225.1356 f7k5l3aon0a38aoutja66rl0sv Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675a999309675a989098','2408497','wait',39,'adm09112754980.682000002')
20241212@080225.1555 f7k5l3aon0a38aoutja66rl0sv Query : use flama_phc
20241212@080225.1559 f7k5l3aon0a38aoutja66rl0sv Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@080225.1589 f7k5l3aon0a38aoutja66rl0sv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3902';
20241212@080225.1756 f7k5l3aon0a38aoutja66rl0sv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3902';
20241212@080225.1810 f7k5l3aon0a38aoutja66rl0sv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3902';
20241212@080225.1948 f7k5l3aon0a38aoutja66rl0sv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3902';
20241212@080225.3111 vatj4b5fttj61bhou2ab9lkvhi Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@080225.3123 vatj4b5fttj61bhou2ab9lkvhi Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@080225.3354 vatj4b5fttj61bhou2ab9lkvhi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3903';
20241212@080225.3521 vatj4b5fttj61bhou2ab9lkvhi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3903';
20241212@080225.3601 vatj4b5fttj61bhou2ab9lkvhi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3903';
20241212@080225.3775 vatj4b5fttj61bhou2ab9lkvhi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3903';
20241212@080225.3913 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080225.3917 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241212@080225.4105 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080225.4111 vatj4b5fttj61bhou2ab9lkvhi Query : select no, estab,szadrsdesc from szadrs where u_coddest=4500
20241212@080225.4271 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.698.00.01'
20241212@080225.4488 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408498 and bi.ref ='324.698.00.01' and bi.lordem =1
20241212@080225.4974 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20241212@080225.5162 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408498 and bi.ref ='324.945.00.01' and bi.lordem =2
20241212@080225.5609 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080225.5612 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241212@080225.5698 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080225.5769 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 1 valor from td where td.ndoc = 39
20241212@080225.6976 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080225.6980 vatj4b5fttj61bhou2ab9lkvhi 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')
20241212@080225.7011 vatj4b5fttj61bhou2ab9lkvhi 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
20241212@080225.7118 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080225.7122 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241212@080225.7151 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080225.7155 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241212@080225.7186 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080225.7221 vatj4b5fttj61bhou2ab9lkvhi Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241212@080225.7334 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080225.7337 vatj4b5fttj61bhou2ab9lkvhi Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - portimão'
20241212@080225.7382 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080225.7385 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from td where ndoc = 39
20241212@080225.7468 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241212@080225.7488 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.7505 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080225.7524 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.7539 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080225.7678 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.7695 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080225.7708 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080225.7873 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080225.7888 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.7906 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080225.7924 vatj4b5fttj61bhou2ab9lkvhi Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675a977678675a9891bc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241212@080225.8128 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.8155 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080225.8264 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241212@080225.8277 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241212@080225.8290 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241212@080225.8303 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241212@080225.8405 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241212@080225.8462 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241212@080225.8477 vatj4b5fttj61bhou2ab9lkvhi Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675a977678675a9891bc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241212@080225.8797 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 fno valor from wsftdata order by fno desc
20241212@080225.8852 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.8870 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080225.8895 vatj4b5fttj61bhou2ab9lkvhi Query : select 'normal' from dummy
20241212@080225.8913 vatj4b5fttj61bhou2ab9lkvhi Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675a977678675a9891bc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2391,101621,0,'2024-12-12',39,'euro',0,0,2024 ,?,?)
20241212@080225.9288 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080225.9291 vatj4b5fttj61bhou2ab9lkvhi Query : select st.usalote valor from st where st.ref = '324.698.00.01'
20241212@080225.9323 vatj4b5fttj61bhou2ab9lkvhi 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.698.00.01'
20241212@080225.9525 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.9654 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080225.9684 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.9745 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080225.9756 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080225.9770 vatj4b5fttj61bhou2ab9lkvhi Query : select sestamp valor from se where ref ='324.698.00.01' and lote = 'r2400061200a'
20241212@080225.9792 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.9810 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080225.9825 vatj4b5fttj61bhou2ab9lkvhi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a975386675a9891ef','aut675a977678675a9891bc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080225.9830 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080225.9915 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080225.9949 vatj4b5fttj61bhou2ab9lkvhi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a975386675a9891ef',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut675a977678675a9891bc' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241212@080226.2880 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.3070 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080226.3380 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.3540 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080226.3650 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080226.4200 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.5340 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080226.6190 vatj4b5fttj61bhou2ab9lkvhi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a950717675a98920a','aut675a977678675a9891bc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080226.6240 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.6430 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080226.6750 vatj4b5fttj61bhou2ab9lkvhi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675a950717675a98920a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675a977678675a9891bc' ,0,0 ,2,23.00,20000,?,?,?)
20241212@080226.1055 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080226.1060 vatj4b5fttj61bhou2ab9lkvhi Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20241212@080226.1089 vatj4b5fttj61bhou2ab9lkvhi 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.945.00.01'
20241212@080226.1598 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.1616 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080226.1731 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.1748 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080226.1758 vatj4b5fttj61bhou2ab9lkvhi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080226.1777 vatj4b5fttj61bhou2ab9lkvhi Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2400091100a'
20241212@080226.1805 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.1908 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080226.1921 vatj4b5fttj61bhou2ab9lkvhi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a952274675a98922c','aut675a977678675a9891bc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080226.1925 vatj4b5fttj61bhou2ab9lkvhi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.1942 vatj4b5fttj61bhou2ab9lkvhi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080226.2063 vatj4b5fttj61bhou2ab9lkvhi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a952274675a98922c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut675a977678675a9891bc' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241212@080226.2379 vatj4b5fttj61bhou2ab9lkvhi Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675a977678675a9891bc','2408498','wait',39,'adm09112754980.682000002')
20241212@080226.2559 vatj4b5fttj61bhou2ab9lkvhi Query : use flama_phc
20241212@080226.2563 vatj4b5fttj61bhou2ab9lkvhi Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@080226.2592 vatj4b5fttj61bhou2ab9lkvhi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3903';
20241212@080226.2632 vatj4b5fttj61bhou2ab9lkvhi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3903';
20241212@080226.2742 vatj4b5fttj61bhou2ab9lkvhi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3903';
20241212@080226.2916 vatj4b5fttj61bhou2ab9lkvhi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3903';
20241212@080226.3460 96nvrbgiso29fnrnbhj4i06l02 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@080226.3471 96nvrbgiso29fnrnbhj4i06l02 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@080226.3652 96nvrbgiso29fnrnbhj4i06l02 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3904';
20241212@080226.3798 96nvrbgiso29fnrnbhj4i06l02 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3904';
20241212@080226.3892 96nvrbgiso29fnrnbhj4i06l02 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3904';
20241212@080226.4108 96nvrbgiso29fnrnbhj4i06l02 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3904';
20241212@080226.4342 96nvrbgiso29fnrnbhj4i06l02 Query : use flama_phc
20241212@080226.4346 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241212@080226.4539 96nvrbgiso29fnrnbhj4i06l02 Query : use flama_phc
20241212@080226.4543 96nvrbgiso29fnrnbhj4i06l02 Query : select no, estab,szadrsdesc from szadrs where u_coddest=3145
20241212@080226.4673 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.698.00.01'
20241212@080226.4694 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408499 and bi.ref ='324.698.00.01' and bi.lordem =1
20241212@080226.5206 96nvrbgiso29fnrnbhj4i06l02 Query : use flama_phc
20241212@080226.5209 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241212@080226.5281 96nvrbgiso29fnrnbhj4i06l02 Query : use flama_phc
20241212@080226.5309 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 1 valor from td where td.ndoc = 39
20241212@080226.5338 96nvrbgiso29fnrnbhj4i06l02 Query : use flama_phc
20241212@080226.5341 96nvrbgiso29fnrnbhj4i06l02 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')
20241212@080226.5368 96nvrbgiso29fnrnbhj4i06l02 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
20241212@080226.5517 96nvrbgiso29fnrnbhj4i06l02 Query : use flama_phc
20241212@080226.5522 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241212@080226.5556 96nvrbgiso29fnrnbhj4i06l02 Query : use flama_phc
20241212@080226.5559 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241212@080226.5829 96nvrbgiso29fnrnbhj4i06l02 Query : use flama_phc
20241212@080226.5833 96nvrbgiso29fnrnbhj4i06l02 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241212@080226.5901 96nvrbgiso29fnrnbhj4i06l02 Query : use flama_phc
20241212@080226.5906 96nvrbgiso29fnrnbhj4i06l02 Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - caldas da rainha'
20241212@080226.6043 96nvrbgiso29fnrnbhj4i06l02 Query : use flama_phc
20241212@080226.6047 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from td where ndoc = 39
20241212@080226.6063 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241212@080226.6166 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.6187 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080226.6207 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.6302 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080226.6371 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.6392 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080226.6522 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080226.6578 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080226.6590 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.6606 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080226.6695 96nvrbgiso29fnrnbhj4i06l02 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675a982728675a98929f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241212@080226.6952 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.6976 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080226.7211 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241212@080226.7331 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241212@080226.7343 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241212@080226.7355 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241212@080226.7369 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241212@080226.7380 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241212@080226.7468 96nvrbgiso29fnrnbhj4i06l02 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675a982728675a98929f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241212@080226.7787 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 fno valor from wsftdata order by fno desc
20241212@080226.7892 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.7909 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080226.7939 96nvrbgiso29fnrnbhj4i06l02 Query : select 'normal' from dummy
20241212@080226.7954 96nvrbgiso29fnrnbhj4i06l02 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675a982728675a98929f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2392,101621,0,'2024-12-12',39,'euro',0,0,2024 ,?,?)
20241212@080226.8411 96nvrbgiso29fnrnbhj4i06l02 Query : use flama_phc
20241212@080226.8415 96nvrbgiso29fnrnbhj4i06l02 Query : select st.usalote valor from st where st.ref = '324.698.00.01'
20241212@080226.8443 96nvrbgiso29fnrnbhj4i06l02 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.698.00.01'
20241212@080226.8457 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.8549 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080226.8589 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.8606 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080226.8616 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080226.8842 96nvrbgiso29fnrnbhj4i06l02 Query : select sestamp valor from se where ref ='324.698.00.01' and lote = 'r2400061200a'
20241212@080226.8862 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.8881 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080226.8892 96nvrbgiso29fnrnbhj4i06l02 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a916459675a9892d8','aut675a982728675a98929f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080226.8897 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.9006 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080226.9035 96nvrbgiso29fnrnbhj4i06l02 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a916459675a9892d8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut675a982728675a98929f' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241212@080226.9443 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.9462 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080226.9493 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.9509 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080226.9519 96nvrbgiso29fnrnbhj4i06l02 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080226.9600 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.9620 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080226.9635 96nvrbgiso29fnrnbhj4i06l02 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a969227675a9892ea','aut675a982728675a98929f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080226.9640 96nvrbgiso29fnrnbhj4i06l02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080226.9656 96nvrbgiso29fnrnbhj4i06l02 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080226.9814 96nvrbgiso29fnrnbhj4i06l02 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675a969227675a9892ea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675a982728675a98929f' ,0,0 ,2,23.00,20000,?,?,?)
20241212@080227.1150 96nvrbgiso29fnrnbhj4i06l02 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675a982728675a98929f','2408499','wait',39,'adm09112754980.682000002')
20241212@080227.2520 96nvrbgiso29fnrnbhj4i06l02 Query : use flama_phc
20241212@080227.2570 96nvrbgiso29fnrnbhj4i06l02 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@080227.3220 96nvrbgiso29fnrnbhj4i06l02 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3904';
20241212@080227.4180 96nvrbgiso29fnrnbhj4i06l02 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3904';
20241212@080227.4760 96nvrbgiso29fnrnbhj4i06l02 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3904';
20241212@080227.5890 96nvrbgiso29fnrnbhj4i06l02 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3904';
20241212@080227.1444 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@080227.1454 9ul9pj5hstrv8cjpqc8fobgnet Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@080227.1591 9ul9pj5hstrv8cjpqc8fobgnet Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3905';
20241212@080227.2033 9ul9pj5hstrv8cjpqc8fobgnet Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3905';
20241212@080227.2165 9ul9pj5hstrv8cjpqc8fobgnet Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3905';
20241212@080227.2219 9ul9pj5hstrv8cjpqc8fobgnet Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3905';
20241212@080227.2343 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080227.2347 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241212@080227.2475 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080227.2479 9ul9pj5hstrv8cjpqc8fobgnet Query : select no, estab,szadrsdesc from szadrs where u_coddest=716
20241212@080227.2707 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241212@080227.2905 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408500 and bi.ref ='324.2330.00.1' and bi.lordem =1
20241212@080227.3541 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1670.00.1'
20241212@080227.3760 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408500 and bi.ref ='324.1670.00.1' and bi.lordem =2
20241212@080227.4219 9ul9pj5hstrv8cjpqc8fobgnet 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'
20241212@080227.4509 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408500 and bi.ref ='324.1676.00.1' and bi.lordem =3
20241212@080227.5026 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1462.00.1'
20241212@080227.5278 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408500 and bi.ref ='324.1462.00.1' and bi.lordem =4
20241212@080227.5853 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1461.00.1'
20241212@080227.6113 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408500 and bi.ref ='324.1461.00.1' and bi.lordem =5
20241212@080227.6536 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2357.00.1'
20241212@080227.6671 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408500 and bi.ref ='324.2357.00.1' and bi.lordem =6
20241212@080227.7106 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080227.7110 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241212@080227.7297 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080227.7302 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 1 valor from td where td.ndoc = 39
20241212@080227.7337 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080227.7340 9ul9pj5hstrv8cjpqc8fobgnet 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')
20241212@080227.7371 9ul9pj5hstrv8cjpqc8fobgnet 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
20241212@080227.7415 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080227.7419 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 ~inactivo valor from cl where no = '102291' and estab = 0 order by inactivo desc
20241212@080227.7573 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080227.7578 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241212@080227.7696 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080227.7700 9ul9pj5hstrv8cjpqc8fobgnet Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241212@080227.7749 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080227.7754 9ul9pj5hstrv8cjpqc8fobgnet Query : select szadrsstamp valor from szadrs where szadrsdesc='vaga d`imagens unipessoal, lda.'
20241212@080227.7923 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080227.7926 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from td where ndoc = 39
20241212@080227.7940 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241212@080227.7957 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080227.7974 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080227.7998 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080227.8016 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080227.8150 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080227.8169 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080227.8183 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080227.8245 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@080227.8258 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080227.8350 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@080227.8368 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675a971712675a9893c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241212@080227.8536 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080227.8559 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@080227.8595 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241212@080227.8607 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241212@080227.8638 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241212@080227.8649 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241212@080227.8662 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241212@080227.8688 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241212@080227.8699 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675a971712675a9893c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241212@080227.8939 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 fno valor from wsftdata order by fno desc
20241212@080227.8971 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080227.8987 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@080227.9010 9ul9pj5hstrv8cjpqc8fobgnet Query : select 'normal' from dummy
20241212@080227.9026 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675a971712675a9893c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2393,102291,0,'2024-12-12',39,'euro',0,0,2024 ,?,?)
20241212@080227.9318 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080227.9322 9ul9pj5hstrv8cjpqc8fobgnet Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241212@080227.9348 9ul9pj5hstrv8cjpqc8fobgnet 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.2330.00.1'
20241212@080227.9523 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080227.9583 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080227.9634 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080227.9651 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080227.9661 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080227.9680 9ul9pj5hstrv8cjpqc8fobgnet Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2200210200a'
20241212@080227.9699 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080227.9715 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080227.9727 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a943711675a9893ec','aut675a971712675a9893c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080227.9731 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080227.9745 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080227.9776 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a943711675a9893ec',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut675a971712675a9893c7' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241212@080228.5400 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080228.6200 9ul9pj5hstrv8cjpqc8fobgnet Query : select st.usalote valor from st where st.ref = '324.1670.00.1'
20241212@080228.8500 9ul9pj5hstrv8cjpqc8fobgnet 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.1670.00.1'
20241212@080228.2150 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.2340 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080228.2650 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.2800 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080228.2880 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080228.3010 9ul9pj5hstrv8cjpqc8fobgnet Query : select sestamp valor from se where ref ='324.1670.00.1' and lote = 'r2301213200a'
20241212@080228.3370 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.3530 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080228.3650 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a937944675a989408','aut675a971712675a9893c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080228.3690 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.3840 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080228.4140 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a937944675a989408',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut675a971712675a9893c7' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241212@080228.6820 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080228.6890 9ul9pj5hstrv8cjpqc8fobgnet Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20241212@080228.7140 9ul9pj5hstrv8cjpqc8fobgnet 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'
20241212@080228.8430 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.8620 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080228.8890 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.9040 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080228.9270 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080228.9420 9ul9pj5hstrv8cjpqc8fobgnet Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20241212@080228.9640 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.9800 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080228.9920 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a960632675a989417','aut675a971712675a9893c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080228.9970 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.1013 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080228.1151 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a960632675a989417',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut675a971712675a9893c7' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241212@080228.1399 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080228.1403 9ul9pj5hstrv8cjpqc8fobgnet Query : select st.usalote valor from st where st.ref = '324.1462.00.1'
20241212@080228.1425 9ul9pj5hstrv8cjpqc8fobgnet 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.1462.00.1'
20241212@080228.1578 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.1595 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080228.1624 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.1663 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080228.1672 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080228.1686 9ul9pj5hstrv8cjpqc8fobgnet Query : select sestamp valor from se where ref ='324.1462.00.1' and lote = 'r2100463100a'
20241212@080228.1752 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.1771 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080228.1794 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a907778675a98942a','aut675a971712675a9893c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080228.1835 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.2010 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080228.2042 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a907778675a98942a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675a971712675a9893c7' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241212@080228.2423 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080228.2426 9ul9pj5hstrv8cjpqc8fobgnet Query : select st.usalote valor from st where st.ref = '324.1461.00.1'
20241212@080228.2448 9ul9pj5hstrv8cjpqc8fobgnet 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.1461.00.1'
20241212@080228.2574 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.2592 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080228.2621 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.2637 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080228.2646 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080228.2659 9ul9pj5hstrv8cjpqc8fobgnet Query : select sestamp valor from se where ref ='324.1461.00.1' and lote = 'r2100463200a'
20241212@080228.2673 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.2689 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080228.2702 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a970146675a989441','aut675a971712675a9893c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080228.2707 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.2722 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080228.2750 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a970146675a989441',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675a971712675a9893c7' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241212@080228.2994 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080228.2997 9ul9pj5hstrv8cjpqc8fobgnet Query : select st.usalote valor from st where st.ref = '324.2357.00.1'
20241212@080228.3018 9ul9pj5hstrv8cjpqc8fobgnet 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.2357.00.1'
20241212@080228.3154 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.3172 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080228.3199 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.3215 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080228.3224 9ul9pj5hstrv8cjpqc8fobgnet Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@080228.3240 9ul9pj5hstrv8cjpqc8fobgnet Query : select sestamp valor from se where ref ='324.2357.00.1' and lote = 'r2200239100a'
20241212@080228.3262 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.3277 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@080228.3289 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675a934007675a98944f','aut675a971712675a9893c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@080228.3294 9ul9pj5hstrv8cjpqc8fobgnet Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@080228.3310 9ul9pj5hstrv8cjpqc8fobgnet Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@080228.3339 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675a934007675a98944f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut675a971712675a9893c7' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241212@080228.3571 9ul9pj5hstrv8cjpqc8fobgnet Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675a971712675a9893c7','2408500','wait',39,'adm09112754980.682000002')
20241212@080228.3647 9ul9pj5hstrv8cjpqc8fobgnet Query : use flama_phc
20241212@080228.3651 9ul9pj5hstrv8cjpqc8fobgnet Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@080228.3693 9ul9pj5hstrv8cjpqc8fobgnet Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3905';
