20241023@171349.3213 v0kns45g815nc44po1vc2aqsla Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171349.3303 v0kns45g815nc44po1vc2aqsla Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.3319 v0kns45g815nc44po1vc2aqsla Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171349.3328 v0kns45g815nc44po1vc2aqsla Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171349.3339 v0kns45g815nc44po1vc2aqsla Query : select sestamp valor from se where ref ='324.728.00.01' and lote = 'r2400238200a'
20241023@171349.3351 v0kns45g815nc44po1vc2aqsla Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.3366 v0kns45g815nc44po1vc2aqsla Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171349.3377 v0kns45g815nc44po1vc2aqsla Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719230543671920bd51','aut6719217571671920bcc7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171349.3381 v0kns45g815nc44po1vc2aqsla Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.3395 v0kns45g815nc44po1vc2aqsla Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171349.3423 v0kns45g815nc44po1vc2aqsla Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719230543671920bd51',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6719217571671920bcc7' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241023@171349.3670 v0kns45g815nc44po1vc2aqsla Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.3763 v0kns45g815nc44po1vc2aqsla Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171349.3787 v0kns45g815nc44po1vc2aqsla Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.4005 v0kns45g815nc44po1vc2aqsla Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171349.4016 v0kns45g815nc44po1vc2aqsla Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171349.4028 v0kns45g815nc44po1vc2aqsla Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.4064 v0kns45g815nc44po1vc2aqsla Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171349.4084 v0kns45g815nc44po1vc2aqsla Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719223819671920bd62','aut6719217571671920bcc7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171349.4089 v0kns45g815nc44po1vc2aqsla Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.4106 v0kns45g815nc44po1vc2aqsla Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171349.4204 v0kns45g815nc44po1vc2aqsla Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6719223819671920bd62',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6719217571671920bcc7' ,0,0 ,2,23.00,110000,?,?,?)
20241023@171349.4439 v0kns45g815nc44po1vc2aqsla Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6719217571671920bcc7','2406952','wait',39,'adm09112754980.682000002')
20241023@171349.4508 v0kns45g815nc44po1vc2aqsla Query : use flama_phc
20241023@171349.4512 v0kns45g815nc44po1vc2aqsla Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241023@171349.4540 v0kns45g815nc44po1vc2aqsla Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2886';
20241023@171349.4574 v0kns45g815nc44po1vc2aqsla Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2886';
20241023@171349.4616 v0kns45g815nc44po1vc2aqsla Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2886';
20241023@171349.4642 v0kns45g815nc44po1vc2aqsla Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2886';
20241023@171349.5164 jqaec8lcoks8cstvr8u82fb2hs Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241023@171349.5178 jqaec8lcoks8cstvr8u82fb2hs Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241023@171349.5235 jqaec8lcoks8cstvr8u82fb2hs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2887';
20241023@171349.5305 jqaec8lcoks8cstvr8u82fb2hs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2887';
20241023@171349.5358 jqaec8lcoks8cstvr8u82fb2hs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2887';
20241023@171349.5384 jqaec8lcoks8cstvr8u82fb2hs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2887';
20241023@171349.5432 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.5434 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241023@171349.5495 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.5498 jqaec8lcoks8cstvr8u82fb2hs Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241023@171349.5537 jqaec8lcoks8cstvr8u82fb2hs 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'
20241023@171349.5557 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406953 and bi.ref ='324.945.00.01' and bi.lordem =1
20241023@171349.5858 jqaec8lcoks8cstvr8u82fb2hs 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'
20241023@171349.5878 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406953 and bi.ref ='324.945.00.01' and bi.lordem =1
20241023@171349.5895 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.5898 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241023@171349.5930 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.5933 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 1 valor from td where td.ndoc = 39
20241023@171349.5962 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.5965 jqaec8lcoks8cstvr8u82fb2hs 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')
20241023@171349.5992 jqaec8lcoks8cstvr8u82fb2hs 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
20241023@171349.6025 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.6028 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241023@171349.6056 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.6059 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241023@171349.6087 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.6090 jqaec8lcoks8cstvr8u82fb2hs Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241023@171349.6128 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.6131 jqaec8lcoks8cstvr8u82fb2hs Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241023@171349.6174 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.6177 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from td where ndoc = 39
20241023@171349.6189 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241023@171349.6204 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.6220 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171349.6238 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.6252 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171349.6281 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.6295 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171349.6308 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171349.6369 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171349.6381 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.6396 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171349.6411 jqaec8lcoks8cstvr8u82fb2hs Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6719256714671920bd9a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241023@171349.6568 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.6583 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171349.6614 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241023@171349.6625 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241023@171349.6637 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241023@171349.6649 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241023@171349.6683 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241023@171349.6694 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241023@171349.6705 jqaec8lcoks8cstvr8u82fb2hs Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6719256714671920bd9a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241023@171349.7000 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 fno valor from wsftdata order by fno desc
20241023@171349.7192 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.7209 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171349.7331 jqaec8lcoks8cstvr8u82fb2hs Query : select 'normal' from dummy
20241023@171349.7347 jqaec8lcoks8cstvr8u82fb2hs Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6719256714671920bd9a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1473,100810,0,'2024-10-23',39,'euro',0,0,2024 ,?,?)
20241023@171349.7700 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.7743 jqaec8lcoks8cstvr8u82fb2hs Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20241023@171349.7776 jqaec8lcoks8cstvr8u82fb2hs 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'
20241023@171349.7789 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.7806 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171349.7831 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.7854 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171349.7862 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171349.7873 jqaec8lcoks8cstvr8u82fb2hs Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2400091100a'
20241023@171349.7892 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.7967 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171349.8017 jqaec8lcoks8cstvr8u82fb2hs Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719246936671920bdc0','aut6719256714671920bd9a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171349.8022 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.8039 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171349.8136 jqaec8lcoks8cstvr8u82fb2hs Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719246936671920bdc0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',68.000 ,'aut6719256714671920bd9a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241023@171349.8400 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.8403 jqaec8lcoks8cstvr8u82fb2hs Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20241023@171349.8422 jqaec8lcoks8cstvr8u82fb2hs 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'
20241023@171349.8435 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.8450 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171349.8474 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.8488 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171349.8495 jqaec8lcoks8cstvr8u82fb2hs Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171349.8506 jqaec8lcoks8cstvr8u82fb2hs Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2400091100a'
20241023@171349.8547 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.8564 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171349.8575 jqaec8lcoks8cstvr8u82fb2hs Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719281083671920bdd0','aut6719256714671920bd9a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171349.8580 jqaec8lcoks8cstvr8u82fb2hs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171349.8610 jqaec8lcoks8cstvr8u82fb2hs Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171349.8638 jqaec8lcoks8cstvr8u82fb2hs Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719281083671920bdd0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6719256714671920bd9a' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241023@171349.8914 jqaec8lcoks8cstvr8u82fb2hs Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6719256714671920bd9a','2406953','wait',39,'adm09112754980.682000002')
20241023@171349.9027 jqaec8lcoks8cstvr8u82fb2hs Query : use flama_phc
20241023@171349.9031 jqaec8lcoks8cstvr8u82fb2hs Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241023@171349.9059 jqaec8lcoks8cstvr8u82fb2hs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2887';
20241023@171349.9092 jqaec8lcoks8cstvr8u82fb2hs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2887';
20241023@171349.9135 jqaec8lcoks8cstvr8u82fb2hs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2887';
20241023@171349.9163 jqaec8lcoks8cstvr8u82fb2hs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2887';
20241023@171349.9768 q5o9ch93no0cnffkqigbgbmrsm Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241023@171349.9779 q5o9ch93no0cnffkqigbgbmrsm Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241023@171349.9836 q5o9ch93no0cnffkqigbgbmrsm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2888';
20241023@171349.9894 q5o9ch93no0cnffkqigbgbmrsm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2888';
20241023@171349.9946 q5o9ch93no0cnffkqigbgbmrsm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2888';
20241023@171349.9975 q5o9ch93no0cnffkqigbgbmrsm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2888';
20241023@171350.2300 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.2600 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241023@171350.8500 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.8800 q5o9ch93no0cnffkqigbgbmrsm Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241023@171350.1260 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4980.00.1'
20241023@171350.1440 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406954 and bi.ref ='324.4980.00.1' and bi.lordem =1
20241023@171350.4420 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4980.00.1'
20241023@171350.4610 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406954 and bi.ref ='324.4980.00.1' and bi.lordem =1
20241023@171350.4780 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4980.00.1'
20241023@171350.4960 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406954 and bi.ref ='324.4980.00.1' and bi.lordem =1
20241023@171350.5120 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.5150 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241023@171350.1543 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.1625 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 1 valor from td where td.ndoc = 39
20241023@171350.1835 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.1839 q5o9ch93no0cnffkqigbgbmrsm 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')
20241023@171350.1870 q5o9ch93no0cnffkqigbgbmrsm 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
20241023@171350.1906 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.1909 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241023@171350.1939 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.1941 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241023@171350.1971 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.1974 q5o9ch93no0cnffkqigbgbmrsm Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241023@171350.2012 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.2015 q5o9ch93no0cnffkqigbgbmrsm Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241023@171350.2058 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.2061 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from td where ndoc = 39
20241023@171350.2073 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241023@171350.2087 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.2103 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171350.2122 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.2137 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171350.2166 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.2181 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171350.2194 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171350.2255 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171350.2268 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.2283 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171350.2298 q5o9ch93no0cnffkqigbgbmrsm Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6719220554671920be35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241023@171350.2455 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.2472 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171350.2503 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241023@171350.2515 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241023@171350.2528 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241023@171350.2539 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241023@171350.2551 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241023@171350.2563 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241023@171350.2576 q5o9ch93no0cnffkqigbgbmrsm Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6719220554671920be35',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241023@171350.2811 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 fno valor from wsftdata order by fno desc
20241023@171350.2835 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.2851 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171350.2887 q5o9ch93no0cnffkqigbgbmrsm Query : select 'normal' from dummy
20241023@171350.2903 q5o9ch93no0cnffkqigbgbmrsm Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6719220554671920be35',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1474,100810,0,'2024-10-23',39,'euro',0,0,2024 ,?,?)
20241023@171350.3164 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.3167 q5o9ch93no0cnffkqigbgbmrsm Query : select st.usalote valor from st where st.ref = '324.4980.00.1'
20241023@171350.3187 q5o9ch93no0cnffkqigbgbmrsm 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.4980.00.1'
20241023@171350.3201 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.3216 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171350.3240 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.3255 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171350.3264 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171350.3276 q5o9ch93no0cnffkqigbgbmrsm Query : select sestamp valor from se where ref ='324.4980.00.1' and lote = 'r2400145100a'
20241023@171350.3288 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.3302 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171350.3314 q5o9ch93no0cnffkqigbgbmrsm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719248503671920be50','aut6719220554671920be35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171350.3318 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.3332 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171350.3359 q5o9ch93no0cnffkqigbgbmrsm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719248503671920be50',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',40.000 ,'aut6719220554671920be35' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241023@171350.3705 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.3745 q5o9ch93no0cnffkqigbgbmrsm Query : select st.usalote valor from st where st.ref = '324.4980.00.1'
20241023@171350.3841 q5o9ch93no0cnffkqigbgbmrsm 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.4980.00.1'
20241023@171350.3855 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.3870 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171350.3896 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.3911 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171350.3921 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171350.3933 q5o9ch93no0cnffkqigbgbmrsm Query : select sestamp valor from se where ref ='324.4980.00.1' and lote = 'r2400145100a'
20241023@171350.3945 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.3960 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171350.3971 q5o9ch93no0cnffkqigbgbmrsm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719229920671920be60','aut6719220554671920be35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171350.3976 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.3991 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171350.4022 q5o9ch93no0cnffkqigbgbmrsm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719229920671920be60',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',32.000 ,'aut6719220554671920be35' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241023@171350.4259 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.4263 q5o9ch93no0cnffkqigbgbmrsm Query : select st.usalote valor from st where st.ref = '324.4980.00.1'
20241023@171350.4284 q5o9ch93no0cnffkqigbgbmrsm 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.4980.00.1'
20241023@171350.4298 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.4315 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171350.4344 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.4359 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171350.4369 q5o9ch93no0cnffkqigbgbmrsm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171350.4381 q5o9ch93no0cnffkqigbgbmrsm Query : select sestamp valor from se where ref ='324.4980.00.1' and lote = 'r2400145100a'
20241023@171350.4393 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.4409 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171350.4422 q5o9ch93no0cnffkqigbgbmrsm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719239477671920be6b','aut6719220554671920be35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171350.4426 q5o9ch93no0cnffkqigbgbmrsm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.4441 q5o9ch93no0cnffkqigbgbmrsm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171350.4471 q5o9ch93no0cnffkqigbgbmrsm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719239477671920be6b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',80.000 ,'aut6719220554671920be35' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241023@171350.4717 q5o9ch93no0cnffkqigbgbmrsm Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6719220554671920be35','2406954','wait',39,'adm09112754980.682000002')
20241023@171350.4791 q5o9ch93no0cnffkqigbgbmrsm Query : use flama_phc
20241023@171350.4794 q5o9ch93no0cnffkqigbgbmrsm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241023@171350.4826 q5o9ch93no0cnffkqigbgbmrsm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2888';
20241023@171350.4898 q5o9ch93no0cnffkqigbgbmrsm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2888';
20241023@171350.5010 q5o9ch93no0cnffkqigbgbmrsm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2888';
20241023@171350.5044 q5o9ch93no0cnffkqigbgbmrsm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2888';
20241023@171350.5633 7936jgrifh2ij258rio6u82tbb Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241023@171350.5653 7936jgrifh2ij258rio6u82tbb Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241023@171350.5717 7936jgrifh2ij258rio6u82tbb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2889';
20241023@171350.5773 7936jgrifh2ij258rio6u82tbb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2889';
20241023@171350.5853 7936jgrifh2ij258rio6u82tbb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2889';
20241023@171350.5894 7936jgrifh2ij258rio6u82tbb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2889';
20241023@171350.5965 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.5968 7936jgrifh2ij258rio6u82tbb Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241023@171350.6029 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.6033 7936jgrifh2ij258rio6u82tbb Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241023@171350.6075 7936jgrifh2ij258rio6u82tbb Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.946.00.01'
20241023@171350.6094 7936jgrifh2ij258rio6u82tbb Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406956 and bi.ref ='324.946.00.01' and bi.lordem =1
20241023@171350.6481 7936jgrifh2ij258rio6u82tbb Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.946.00.01'
20241023@171350.6508 7936jgrifh2ij258rio6u82tbb Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406956 and bi.ref ='324.946.00.01' and bi.lordem =1
20241023@171350.6524 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.6528 7936jgrifh2ij258rio6u82tbb Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241023@171350.6561 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.6565 7936jgrifh2ij258rio6u82tbb Query : select top 1 1 valor from td where td.ndoc = 39
20241023@171350.6733 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.6737 7936jgrifh2ij258rio6u82tbb 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')
20241023@171350.6766 7936jgrifh2ij258rio6u82tbb 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
20241023@171350.6836 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.6956 7936jgrifh2ij258rio6u82tbb Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241023@171350.7011 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.7015 7936jgrifh2ij258rio6u82tbb Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241023@171350.7047 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.7050 7936jgrifh2ij258rio6u82tbb Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241023@171350.7089 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.7092 7936jgrifh2ij258rio6u82tbb Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241023@171350.7136 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.7139 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from td where ndoc = 39
20241023@171350.7151 7936jgrifh2ij258rio6u82tbb Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241023@171350.7164 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.7225 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171350.7244 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.7260 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171350.7287 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.7343 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171350.7356 7936jgrifh2ij258rio6u82tbb Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171350.7426 7936jgrifh2ij258rio6u82tbb Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171350.7439 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.7458 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171350.7489 7936jgrifh2ij258rio6u82tbb Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6719226556671920beb3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241023@171350.7652 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.7669 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171350.7724 7936jgrifh2ij258rio6u82tbb Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241023@171350.7737 7936jgrifh2ij258rio6u82tbb Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241023@171350.7766 7936jgrifh2ij258rio6u82tbb Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241023@171350.7779 7936jgrifh2ij258rio6u82tbb Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241023@171350.7791 7936jgrifh2ij258rio6u82tbb Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241023@171350.7806 7936jgrifh2ij258rio6u82tbb Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241023@171350.7819 7936jgrifh2ij258rio6u82tbb Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6719226556671920beb3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241023@171350.8047 7936jgrifh2ij258rio6u82tbb Query : select top 1 fno valor from wsftdata order by fno desc
20241023@171350.8072 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.8088 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171350.8114 7936jgrifh2ij258rio6u82tbb Query : select 'normal' from dummy
20241023@171350.8129 7936jgrifh2ij258rio6u82tbb Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6719226556671920beb3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1475,100810,0,'2024-10-23',39,'euro',0,0,2024 ,?,?)
20241023@171350.8393 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.8396 7936jgrifh2ij258rio6u82tbb Query : select st.usalote valor from st where st.ref = '324.946.00.01'
20241023@171350.8417 7936jgrifh2ij258rio6u82tbb Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.946.00.01'
20241023@171350.8430 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.8447 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171350.8472 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.8488 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171350.8496 7936jgrifh2ij258rio6u82tbb Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171350.8507 7936jgrifh2ij258rio6u82tbb Query : select sestamp valor from se where ref ='324.946.00.01' and lote = 'r2300941200a'
20241023@171350.8519 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.8533 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171350.8545 7936jgrifh2ij258rio6u82tbb Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719248208671920bed0','aut6719226556671920beb3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171350.8549 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.8563 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171350.8591 7936jgrifh2ij258rio6u82tbb Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719248208671920bed0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut6719226556671920beb3' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241023@171350.8818 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.8821 7936jgrifh2ij258rio6u82tbb Query : select st.usalote valor from st where st.ref = '324.946.00.01'
20241023@171350.8840 7936jgrifh2ij258rio6u82tbb Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.946.00.01'
20241023@171350.8861 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.8878 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171350.8909 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.8924 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171350.8933 7936jgrifh2ij258rio6u82tbb Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171350.8948 7936jgrifh2ij258rio6u82tbb Query : select sestamp valor from se where ref ='324.946.00.01' and lote = 'r2300941200a'
20241023@171350.8961 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.8976 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171350.8989 7936jgrifh2ij258rio6u82tbb Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719213555671920beda','aut6719226556671920beb3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171350.9003 7936jgrifh2ij258rio6u82tbb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171350.9019 7936jgrifh2ij258rio6u82tbb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171350.9050 7936jgrifh2ij258rio6u82tbb Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719213555671920beda',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut6719226556671920beb3' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241023@171350.9271 7936jgrifh2ij258rio6u82tbb Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6719226556671920beb3','2406956','wait',39,'adm09112754980.682000002')
20241023@171350.9341 7936jgrifh2ij258rio6u82tbb Query : use flama_phc
20241023@171350.9344 7936jgrifh2ij258rio6u82tbb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241023@171350.9373 7936jgrifh2ij258rio6u82tbb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2889';
20241023@171350.9405 7936jgrifh2ij258rio6u82tbb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2889';
20241023@171350.9447 7936jgrifh2ij258rio6u82tbb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2889';
20241023@171350.9476 7936jgrifh2ij258rio6u82tbb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2889';
20241023@171350.9980 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241023@171350.9991 i5umnp6emfjsk4sjq2tjsvu603 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241023@171351.4600 i5umnp6emfjsk4sjq2tjsvu603 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2890';
20241023@171351.1010 i5umnp6emfjsk4sjq2tjsvu603 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2890';
20241023@171351.1560 i5umnp6emfjsk4sjq2tjsvu603 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2890';
20241023@171351.1840 i5umnp6emfjsk4sjq2tjsvu603 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2890';
20241023@171351.2320 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.2350 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241023@171351.2940 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.2960 i5umnp6emfjsk4sjq2tjsvu603 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241023@171351.3350 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5365.00.1'
20241023@171351.4610 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406968 and bi.ref ='324.5365.00.1' and bi.lordem =1
20241023@171351.7470 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5365.00.1'
20241023@171351.7660 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406968 and bi.ref ='324.5365.00.1' and bi.lordem =1
20241023@171351.7830 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.7860 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241023@171351.8160 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.8190 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 1 valor from td where td.ndoc = 39
20241023@171351.8470 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.8500 i5umnp6emfjsk4sjq2tjsvu603 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')
20241023@171351.8770 i5umnp6emfjsk4sjq2tjsvu603 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
20241023@171351.9100 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.9120 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241023@171351.9400 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.9430 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241023@171351.9700 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.9730 i5umnp6emfjsk4sjq2tjsvu603 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241023@171351.1010 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.1013 i5umnp6emfjsk4sjq2tjsvu603 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241023@171351.1054 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.1057 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from td where ndoc = 39
20241023@171351.1071 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241023@171351.1086 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.1116 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171351.1139 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.1156 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171351.1188 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.1206 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171351.1219 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171351.1333 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171351.1345 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.1360 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171351.1379 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6719275390671920bf1d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241023@171351.1544 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.1565 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171351.1599 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241023@171351.1611 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241023@171351.1622 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241023@171351.1634 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241023@171351.1645 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241023@171351.1656 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241023@171351.1667 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6719275390671920bf1d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241023@171351.1889 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 fno valor from wsftdata order by fno desc
20241023@171351.2116 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.2133 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171351.2155 i5umnp6emfjsk4sjq2tjsvu603 Query : select 'normal' from dummy
20241023@171351.2170 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6719275390671920bf1d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1476,100810,0,'2024-10-23',39,'euro',0,0,2024 ,?,?)
20241023@171351.2439 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.2442 i5umnp6emfjsk4sjq2tjsvu603 Query : select st.usalote valor from st where st.ref = '324.5365.00.1'
20241023@171351.2467 i5umnp6emfjsk4sjq2tjsvu603 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.5365.00.1'
20241023@171351.2606 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.2623 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171351.2650 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.2666 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171351.2676 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171351.2689 i5umnp6emfjsk4sjq2tjsvu603 Query : select sestamp valor from se where ref ='324.5365.00.1' and lote = 'r2300840100a'
20241023@171351.2702 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.2716 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171351.2726 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719295856671920bf41','aut6719275390671920bf1d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171351.2730 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.2744 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171351.2770 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719295856671920bf41',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',54.000 ,'aut6719275390671920bf1d' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241023@171351.3089 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.3106 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171351.3146 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.3161 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171351.3169 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171351.3200 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.3215 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171351.3226 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719204964671920bf4e','aut6719275390671920bf1d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171351.3231 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.3246 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171351.3273 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6719204964671920bf4e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6719275390671920bf1d' ,0,0 ,2,23.00,20000,?,?,?)
20241023@171351.3522 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.3525 i5umnp6emfjsk4sjq2tjsvu603 Query : select st.usalote valor from st where st.ref = '324.5365.00.1'
20241023@171351.3563 i5umnp6emfjsk4sjq2tjsvu603 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.5365.00.1'
20241023@171351.3576 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.3599 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171351.3624 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.3638 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171351.3662 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171351.3674 i5umnp6emfjsk4sjq2tjsvu603 Query : select sestamp valor from se where ref ='324.5365.00.1' and lote = 'r2300840100a'
20241023@171351.3686 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.3720 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171351.3732 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719232094671920bf5a','aut6719275390671920bf1d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171351.3737 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.3752 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171351.3950 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719232094671920bf5a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',144.000 ,'aut6719275390671920bf1d' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241023@171351.4205 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.4222 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171351.4248 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.4263 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171351.4271 i5umnp6emfjsk4sjq2tjsvu603 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171351.4283 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.4297 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171351.4308 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719217843671920bf68','aut6719275390671920bf1d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171351.4312 i5umnp6emfjsk4sjq2tjsvu603 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.4327 i5umnp6emfjsk4sjq2tjsvu603 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171351.4355 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6719217843671920bf68',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6719275390671920bf1d' ,0,0 ,2,23.00,50000,?,?,?)
20241023@171351.4661 i5umnp6emfjsk4sjq2tjsvu603 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6719275390671920bf1d','2406968','wait',39,'adm09112754980.682000002')
20241023@171351.4733 i5umnp6emfjsk4sjq2tjsvu603 Query : use flama_phc
20241023@171351.4736 i5umnp6emfjsk4sjq2tjsvu603 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241023@171351.4764 i5umnp6emfjsk4sjq2tjsvu603 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2890';
20241023@171351.4799 i5umnp6emfjsk4sjq2tjsvu603 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2890';
20241023@171351.4843 i5umnp6emfjsk4sjq2tjsvu603 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2890';
20241023@171351.4870 i5umnp6emfjsk4sjq2tjsvu603 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2890';
20241023@171351.5352 drm9r1h0ln9fvjhhgkko10t9id Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241023@171351.5362 drm9r1h0ln9fvjhhgkko10t9id Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241023@171351.5417 drm9r1h0ln9fvjhhgkko10t9id Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2891';
20241023@171351.5470 drm9r1h0ln9fvjhhgkko10t9id Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2891';
20241023@171351.5522 drm9r1h0ln9fvjhhgkko10t9id Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2891';
20241023@171351.5548 drm9r1h0ln9fvjhhgkko10t9id Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2891';
20241023@171351.5596 drm9r1h0ln9fvjhhgkko10t9id Query : use flama_phc
20241023@171351.5599 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241023@171351.5660 drm9r1h0ln9fvjhhgkko10t9id Query : use flama_phc
20241023@171351.5663 drm9r1h0ln9fvjhhgkko10t9id Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241023@171351.5703 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '326.595.00.01'
20241023@171351.5826 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406969 and bi.ref ='326.595.00.01' and bi.lordem =1
20241023@171351.6112 drm9r1h0ln9fvjhhgkko10t9id Query : use flama_phc
20241023@171351.6115 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241023@171351.6147 drm9r1h0ln9fvjhhgkko10t9id Query : use flama_phc
20241023@171351.6150 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 1 valor from td where td.ndoc = 39
20241023@171351.6179 drm9r1h0ln9fvjhhgkko10t9id Query : use flama_phc
20241023@171351.6181 drm9r1h0ln9fvjhhgkko10t9id 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')
20241023@171351.6211 drm9r1h0ln9fvjhhgkko10t9id 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
20241023@171351.6245 drm9r1h0ln9fvjhhgkko10t9id Query : use flama_phc
20241023@171351.6248 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241023@171351.6277 drm9r1h0ln9fvjhhgkko10t9id Query : use flama_phc
20241023@171351.6280 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241023@171351.6309 drm9r1h0ln9fvjhhgkko10t9id Query : use flama_phc
20241023@171351.6322 drm9r1h0ln9fvjhhgkko10t9id Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241023@171351.6362 drm9r1h0ln9fvjhhgkko10t9id Query : use flama_phc
20241023@171351.6365 drm9r1h0ln9fvjhhgkko10t9id Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241023@171351.6409 drm9r1h0ln9fvjhhgkko10t9id Query : use flama_phc
20241023@171351.6411 drm9r1h0ln9fvjhhgkko10t9id Query : select 1 valor from td where ndoc = 39
20241023@171351.6423 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241023@171351.6437 drm9r1h0ln9fvjhhgkko10t9id Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.6455 drm9r1h0ln9fvjhhgkko10t9id Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171351.6473 drm9r1h0ln9fvjhhgkko10t9id Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.6489 drm9r1h0ln9fvjhhgkko10t9id Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171351.6517 drm9r1h0ln9fvjhhgkko10t9id Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.6542 drm9r1h0ln9fvjhhgkko10t9id Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171351.6555 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171351.6617 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171351.6629 drm9r1h0ln9fvjhhgkko10t9id Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.6644 drm9r1h0ln9fvjhhgkko10t9id Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171351.6659 drm9r1h0ln9fvjhhgkko10t9id Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6719240945671920bfa0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241023@171351.6817 drm9r1h0ln9fvjhhgkko10t9id Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.6834 drm9r1h0ln9fvjhhgkko10t9id Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171351.6868 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241023@171351.6880 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241023@171351.6891 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241023@171351.6903 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241023@171351.6915 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241023@171351.6927 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241023@171351.6939 drm9r1h0ln9fvjhhgkko10t9id Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6719240945671920bfa0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241023@171351.7150 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 fno valor from wsftdata order by fno desc
20241023@171351.7175 drm9r1h0ln9fvjhhgkko10t9id Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.7191 drm9r1h0ln9fvjhhgkko10t9id Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171351.7213 drm9r1h0ln9fvjhhgkko10t9id Query : select 'normal' from dummy
20241023@171351.7417 drm9r1h0ln9fvjhhgkko10t9id Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6719240945671920bfa0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1477,100810,0,'2024-10-23',39,'euro',0,0,2024 ,?,?)
20241023@171351.7696 drm9r1h0ln9fvjhhgkko10t9id Query : use flama_phc
20241023@171351.7699 drm9r1h0ln9fvjhhgkko10t9id Query : select st.usalote valor from st where st.ref = '326.595.00.01'
20241023@171351.7724 drm9r1h0ln9fvjhhgkko10t9id 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 = '326.595.00.01'
20241023@171351.7851 drm9r1h0ln9fvjhhgkko10t9id Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.7871 drm9r1h0ln9fvjhhgkko10t9id Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171351.7895 drm9r1h0ln9fvjhhgkko10t9id Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.7910 drm9r1h0ln9fvjhhgkko10t9id Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171351.7919 drm9r1h0ln9fvjhhgkko10t9id Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171351.7931 drm9r1h0ln9fvjhhgkko10t9id Query : select sestamp valor from se where ref ='326.595.00.01' and lote = 'r2400411200a'
20241023@171351.7965 drm9r1h0ln9fvjhhgkko10t9id Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.7981 drm9r1h0ln9fvjhhgkko10t9id Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171351.7992 drm9r1h0ln9fvjhhgkko10t9id Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719229893671920bfc2','aut6719240945671920bfa0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171351.7997 drm9r1h0ln9fvjhhgkko10t9id Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171351.8011 drm9r1h0ln9fvjhhgkko10t9id Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171351.8038 drm9r1h0ln9fvjhhgkko10t9id Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719229893671920bfc2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut6719240945671920bfa0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241023@171351.8269 drm9r1h0ln9fvjhhgkko10t9id Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6719240945671920bfa0','2406969','wait',39,'adm09112754980.682000002')
20241023@171351.8393 drm9r1h0ln9fvjhhgkko10t9id Query : use flama_phc
20241023@171351.8396 drm9r1h0ln9fvjhhgkko10t9id Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241023@171351.8425 drm9r1h0ln9fvjhhgkko10t9id Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2891';
20241023@171351.8472 drm9r1h0ln9fvjhhgkko10t9id Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2891';
20241023@171351.8514 drm9r1h0ln9fvjhhgkko10t9id Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2891';
20241023@171351.8540 drm9r1h0ln9fvjhhgkko10t9id Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2891';
20241023@171351.9075 749r04ij1lc62vid7pqqvc85gn Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241023@171351.9086 749r04ij1lc62vid7pqqvc85gn Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241023@171351.9142 749r04ij1lc62vid7pqqvc85gn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2892';
20241023@171351.9203 749r04ij1lc62vid7pqqvc85gn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2892';
20241023@171352.5730 749r04ij1lc62vid7pqqvc85gn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2892';
20241023@171352.6070 749r04ij1lc62vid7pqqvc85gn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2892';
20241023@171352.6590 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.6630 749r04ij1lc62vid7pqqvc85gn Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241023@171352.7240 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.7270 749r04ij1lc62vid7pqqvc85gn Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20241023@171352.8330 749r04ij1lc62vid7pqqvc85gn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9326.00.1'
20241023@171352.9590 749r04ij1lc62vid7pqqvc85gn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406970 and bi.ref ='328.9326.00.1' and bi.lordem =1
20241023@171352.1249 749r04ij1lc62vid7pqqvc85gn 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'
20241023@171352.1364 749r04ij1lc62vid7pqqvc85gn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406970 and bi.ref ='328.9345.00.1' and bi.lordem =2
20241023@171352.1663 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.1666 749r04ij1lc62vid7pqqvc85gn Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241023@171352.1697 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.1700 749r04ij1lc62vid7pqqvc85gn Query : select top 1 1 valor from td where td.ndoc = 39
20241023@171352.1728 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.1730 749r04ij1lc62vid7pqqvc85gn 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')
20241023@171352.1756 749r04ij1lc62vid7pqqvc85gn 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
20241023@171352.1790 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.1793 749r04ij1lc62vid7pqqvc85gn Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241023@171352.1821 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.1824 749r04ij1lc62vid7pqqvc85gn Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241023@171352.1853 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.1855 749r04ij1lc62vid7pqqvc85gn Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241023@171352.1893 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.1896 749r04ij1lc62vid7pqqvc85gn Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20241023@171352.1939 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.1942 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from td where ndoc = 39
20241023@171352.1954 749r04ij1lc62vid7pqqvc85gn Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241023@171352.1967 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.1983 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171352.2003 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.2017 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171352.2048 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.2062 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171352.2075 749r04ij1lc62vid7pqqvc85gn Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171352.2136 749r04ij1lc62vid7pqqvc85gn Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171352.2149 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.2164 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171352.2179 749r04ij1lc62vid7pqqvc85gn Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6719275110671920c032' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241023@171352.2340 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.2361 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171352.2396 749r04ij1lc62vid7pqqvc85gn Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241023@171352.2409 749r04ij1lc62vid7pqqvc85gn Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241023@171352.2421 749r04ij1lc62vid7pqqvc85gn Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241023@171352.2433 749r04ij1lc62vid7pqqvc85gn Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241023@171352.2444 749r04ij1lc62vid7pqqvc85gn Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241023@171352.2459 749r04ij1lc62vid7pqqvc85gn Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241023@171352.2470 749r04ij1lc62vid7pqqvc85gn Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6719275110671920c032',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241023@171352.2699 749r04ij1lc62vid7pqqvc85gn Query : select top 1 fno valor from wsftdata order by fno desc
20241023@171352.2723 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.2739 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171352.2760 749r04ij1lc62vid7pqqvc85gn Query : select 'normal' from dummy
20241023@171352.2775 749r04ij1lc62vid7pqqvc85gn Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6719275110671920c032',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1478,100810,0,'2024-10-23',39,'euro',0,0,2024 ,?,?)
20241023@171352.3031 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.3035 749r04ij1lc62vid7pqqvc85gn Query : select st.usalote valor from st where st.ref = '328.9326.00.1'
20241023@171352.3056 749r04ij1lc62vid7pqqvc85gn 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.9326.00.1'
20241023@171352.3183 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.3199 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171352.3225 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.3238 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171352.3247 749r04ij1lc62vid7pqqvc85gn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171352.3259 749r04ij1lc62vid7pqqvc85gn Query : select sestamp valor from se where ref ='328.9326.00.1' and lote = 'r2300691100a'
20241023@171352.3283 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.3298 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171352.3311 749r04ij1lc62vid7pqqvc85gn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719210582671920c050','aut6719275110671920c032' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171352.3315 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.3329 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171352.3379 749r04ij1lc62vid7pqqvc85gn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719210582671920c050',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6719275110671920c032' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241023@171352.3794 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.3811 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171352.3835 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.3850 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171352.3858 749r04ij1lc62vid7pqqvc85gn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171352.3872 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.3886 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171352.3898 749r04ij1lc62vid7pqqvc85gn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719271983671920c05e','aut6719275110671920c032' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171352.3902 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.3916 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171352.3943 749r04ij1lc62vid7pqqvc85gn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6719271983671920c05e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6719275110671920c032' ,0,0 ,2,23.00,20000,?,?,?)
20241023@171352.4263 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.4307 749r04ij1lc62vid7pqqvc85gn Query : select st.usalote valor from st where st.ref = '328.9345.00.1'
20241023@171352.4379 749r04ij1lc62vid7pqqvc85gn 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'
20241023@171352.4546 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.4562 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171352.4592 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.4627 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171352.4635 749r04ij1lc62vid7pqqvc85gn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171352.4648 749r04ij1lc62vid7pqqvc85gn Query : select sestamp valor from se where ref ='328.9345.00.1' and lote = 'r2101101300a'
20241023@171352.4681 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.4697 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171352.4708 749r04ij1lc62vid7pqqvc85gn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719255969671920c072','aut6719275110671920c032' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171352.4712 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.4726 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171352.4823 749r04ij1lc62vid7pqqvc85gn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719255969671920c072',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6719275110671920c032' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241023@171352.5070 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.5095 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171352.5119 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.5182 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171352.5191 749r04ij1lc62vid7pqqvc85gn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171352.5203 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.5219 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171352.5234 749r04ij1lc62vid7pqqvc85gn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719232242671920c07f','aut6719275110671920c032' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171352.5238 749r04ij1lc62vid7pqqvc85gn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171352.5253 749r04ij1lc62vid7pqqvc85gn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171352.5281 749r04ij1lc62vid7pqqvc85gn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6719232242671920c07f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6719275110671920c032' ,0,0 ,2,23.00,50000,?,?,?)
20241023@171352.5500 749r04ij1lc62vid7pqqvc85gn Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6719275110671920c032','2406970','wait',39,'adm09112754980.682000002')
20241023@171352.5568 749r04ij1lc62vid7pqqvc85gn Query : use flama_phc
20241023@171352.5571 749r04ij1lc62vid7pqqvc85gn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241023@171352.5599 749r04ij1lc62vid7pqqvc85gn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2892';
20241023@171352.5633 749r04ij1lc62vid7pqqvc85gn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2892';
20241023@171352.5675 749r04ij1lc62vid7pqqvc85gn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2892';
20241023@171352.5702 749r04ij1lc62vid7pqqvc85gn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2892';
20241023@171352.7842 97970bdkmi0n8cecukf9qopcoa Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241023@171352.7853 97970bdkmi0n8cecukf9qopcoa Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241023@171352.7909 97970bdkmi0n8cecukf9qopcoa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2893';
20241023@171352.7985 97970bdkmi0n8cecukf9qopcoa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2893';
20241023@171352.8043 97970bdkmi0n8cecukf9qopcoa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2893';
20241023@171352.8071 97970bdkmi0n8cecukf9qopcoa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2893';
20241023@171352.8120 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171352.8123 97970bdkmi0n8cecukf9qopcoa Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241023@171352.8182 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171352.8185 97970bdkmi0n8cecukf9qopcoa Query : select no, estab,szadrsdesc from szadrs where u_coddest=3155
20241023@171352.8263 97970bdkmi0n8cecukf9qopcoa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4961.00.1'
20241023@171352.8388 97970bdkmi0n8cecukf9qopcoa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406975 and bi.ref ='324.4961.00.1' and bi.lordem =1
20241023@171352.8694 97970bdkmi0n8cecukf9qopcoa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5365.00.1'
20241023@171352.8720 97970bdkmi0n8cecukf9qopcoa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406975 and bi.ref ='324.5365.00.1' and bi.lordem =2
20241023@171352.9027 97970bdkmi0n8cecukf9qopcoa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1685.00.1'
20241023@171352.9049 97970bdkmi0n8cecukf9qopcoa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406975 and bi.ref ='324.1685.00.1' and bi.lordem =3
20241023@171352.9520 97970bdkmi0n8cecukf9qopcoa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1646.00.1'
20241023@171352.9933 97970bdkmi0n8cecukf9qopcoa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406975 and bi.ref ='324.1646.00.1' and bi.lordem =4
20241023@171353.2600 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.2640 97970bdkmi0n8cecukf9qopcoa Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241023@171353.2960 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.2990 97970bdkmi0n8cecukf9qopcoa Query : select top 1 1 valor from td where td.ndoc = 39
20241023@171353.3290 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.3320 97970bdkmi0n8cecukf9qopcoa 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')
20241023@171353.3630 97970bdkmi0n8cecukf9qopcoa 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
20241023@171353.3990 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.4020 97970bdkmi0n8cecukf9qopcoa Query : select top 1 ~inactivo valor from cl where no = '101176' and estab = 0 order by inactivo desc
20241023@171353.5500 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.5530 97970bdkmi0n8cecukf9qopcoa Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241023@171353.5830 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.5860 97970bdkmi0n8cecukf9qopcoa Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241023@171353.6240 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.6280 97970bdkmi0n8cecukf9qopcoa Query : select szadrsstamp valor from szadrs where szadrsdesc='soares & filhos, lda.-entrega'
20241023@171353.6720 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.6750 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from td where ndoc = 39
20241023@171353.6880 97970bdkmi0n8cecukf9qopcoa Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241023@171353.7010 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.7170 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171353.7360 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.7500 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171353.7830 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.7980 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171353.8100 97970bdkmi0n8cecukf9qopcoa Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171353.8770 97970bdkmi0n8cecukf9qopcoa Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241023@171353.8910 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.9050 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241023@171353.9200 97970bdkmi0n8cecukf9qopcoa Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6719260954671920c113' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241023@171353.1094 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.1110 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241023@171353.1144 97970bdkmi0n8cecukf9qopcoa Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241023@171353.1155 97970bdkmi0n8cecukf9qopcoa Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241023@171353.1167 97970bdkmi0n8cecukf9qopcoa Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241023@171353.1180 97970bdkmi0n8cecukf9qopcoa Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241023@171353.1194 97970bdkmi0n8cecukf9qopcoa Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241023@171353.1211 97970bdkmi0n8cecukf9qopcoa Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241023@171353.1224 97970bdkmi0n8cecukf9qopcoa Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6719260954671920c113',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241023@171353.1456 97970bdkmi0n8cecukf9qopcoa Query : select top 1 fno valor from wsftdata order by fno desc
20241023@171353.1481 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.1498 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241023@171353.1520 97970bdkmi0n8cecukf9qopcoa Query : select 'normal' from dummy
20241023@171353.1535 97970bdkmi0n8cecukf9qopcoa Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6719260954671920c113',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1479,101176,0,'2024-10-23',39,'euro',0,0,2024 ,?,?)
20241023@171353.1798 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.1802 97970bdkmi0n8cecukf9qopcoa Query : select st.usalote valor from st where st.ref = '324.4961.00.1'
20241023@171353.1823 97970bdkmi0n8cecukf9qopcoa 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.4961.00.1'
20241023@171353.1942 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.1959 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171353.1988 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.2003 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171353.2013 97970bdkmi0n8cecukf9qopcoa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171353.2026 97970bdkmi0n8cecukf9qopcoa Query : select sestamp valor from se where ref ='324.4961.00.1' and lote = 'r2101092200a'
20241023@171353.2048 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.2064 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171353.2075 97970bdkmi0n8cecukf9qopcoa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719278470671920c132','aut6719260954671920c113' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171353.2090 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.2104 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171353.2134 97970bdkmi0n8cecukf9qopcoa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719278470671920c132',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6719260954671920c113' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241023@171353.2373 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.2377 97970bdkmi0n8cecukf9qopcoa Query : select st.usalote valor from st where st.ref = '324.5365.00.1'
20241023@171353.2399 97970bdkmi0n8cecukf9qopcoa 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.5365.00.1'
20241023@171353.2415 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.2432 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171353.2462 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.2476 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171353.2485 97970bdkmi0n8cecukf9qopcoa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171353.2498 97970bdkmi0n8cecukf9qopcoa Query : select sestamp valor from se where ref ='324.5365.00.1' and lote = 'r2300840100a'
20241023@171353.2512 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.2528 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171353.2542 97970bdkmi0n8cecukf9qopcoa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719236323671920c13d','aut6719260954671920c113' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171353.2546 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.2562 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171353.2593 97970bdkmi0n8cecukf9qopcoa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719236323671920c13d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6719260954671920c113' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241023@171353.2829 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.2846 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171353.2873 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.2887 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171353.2895 97970bdkmi0n8cecukf9qopcoa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171353.2908 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.2922 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171353.2933 97970bdkmi0n8cecukf9qopcoa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719245909671920c147','aut6719260954671920c113' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171353.2936 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.2950 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171353.2976 97970bdkmi0n8cecukf9qopcoa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6719245909671920c147',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6719260954671920c113' ,0,0 ,2,23.00,30000,?,?,?)
20241023@171353.3209 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.3212 97970bdkmi0n8cecukf9qopcoa Query : select st.usalote valor from st where st.ref = '324.1685.00.1'
20241023@171353.3232 97970bdkmi0n8cecukf9qopcoa 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.1685.00.1'
20241023@171353.3245 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.3260 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171353.3284 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.3298 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171353.3306 97970bdkmi0n8cecukf9qopcoa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171353.3318 97970bdkmi0n8cecukf9qopcoa Query : select sestamp valor from se where ref ='324.1685.00.1' and lote = 'r2400173100a'
20241023@171353.3329 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.3343 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171353.3354 97970bdkmi0n8cecukf9qopcoa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719233208671920c151','aut6719260954671920c113' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171353.3358 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.3373 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171353.3404 97970bdkmi0n8cecukf9qopcoa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719233208671920c151',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6719260954671920c113' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241023@171353.3633 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.3636 97970bdkmi0n8cecukf9qopcoa Query : select st.usalote valor from st where st.ref = '324.1646.00.1'
20241023@171353.3655 97970bdkmi0n8cecukf9qopcoa 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.1646.00.1'
20241023@171353.3777 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.3792 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171353.4013 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.4028 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171353.4037 97970bdkmi0n8cecukf9qopcoa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241023@171353.4050 97970bdkmi0n8cecukf9qopcoa Query : select sestamp valor from se where ref ='324.1646.00.1' and lote = 'r2100904100a'
20241023@171353.4074 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.4088 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241023@171353.4098 97970bdkmi0n8cecukf9qopcoa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6719295508671920c163','aut6719260954671920c113' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241023@171353.4102 97970bdkmi0n8cecukf9qopcoa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241023@171353.4116 97970bdkmi0n8cecukf9qopcoa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241023@171353.4145 97970bdkmi0n8cecukf9qopcoa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6719295508671920c163',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6719260954671920c113' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241023@171353.4381 97970bdkmi0n8cecukf9qopcoa Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6719260954671920c113','2406975','wait',39,'adm09112754980.682000002')
20241023@171353.5710 97970bdkmi0n8cecukf9qopcoa Query : use flama_phc
20241023@171353.5714 97970bdkmi0n8cecukf9qopcoa Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241023@171353.5742 97970bdkmi0n8cecukf9qopcoa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2893';
20241023@171353.5777 97970bdkmi0n8cecukf9qopcoa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2893';
20241023@171353.5820 97970bdkmi0n8cecukf9qopcoa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2893';
20241023@171353.5845 97970bdkmi0n8cecukf9qopcoa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2893';
20241023@171353.6359 mkckekcc5ghq2h1kf4lh8ja769 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241023@171353.6371 mkckekcc5ghq2h1kf4lh8ja769 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
