20240731@214932.8405 hg1hlt89oo69f2ktf7744vu64i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214932.8436 hg1hlt89oo69f2ktf7744vu64i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214932.8453 hg1hlt89oo69f2ktf7744vu64i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214932.8462 hg1hlt89oo69f2ktf7744vu64i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214932.8476 hg1hlt89oo69f2ktf7744vu64i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214932.8497 hg1hlt89oo69f2ktf7744vu64i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214932.8521 hg1hlt89oo69f2ktf7744vu64i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa5837266aaa35cce','aut66aaa2957866aaa35c9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214932.8525 hg1hlt89oo69f2ktf7744vu64i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214932.8540 hg1hlt89oo69f2ktf7744vu64i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214932.8573 hg1hlt89oo69f2ktf7744vu64i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66aaa5837266aaa35cce',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66aaa2957866aaa35c9f' ,0,0 ,2,23.00,20000,?,?,?)
20240731@214932.8826 hg1hlt89oo69f2ktf7744vu64i Query : use flama_phc
20240731@214932.8830 hg1hlt89oo69f2ktf7744vu64i Query : select st.usalote valor from st where st.ref = '324.657.00.01'
20240731@214932.8850 hg1hlt89oo69f2ktf7744vu64i 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.657.00.01'
20240731@214932.8865 hg1hlt89oo69f2ktf7744vu64i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214932.8882 hg1hlt89oo69f2ktf7744vu64i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214932.8910 hg1hlt89oo69f2ktf7744vu64i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214932.8927 hg1hlt89oo69f2ktf7744vu64i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214932.8936 hg1hlt89oo69f2ktf7744vu64i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214932.8949 hg1hlt89oo69f2ktf7744vu64i Query : select sestamp valor from se where ref ='324.657.00.01' and lote = 'r230117610'
20240731@214932.8960 hg1hlt89oo69f2ktf7744vu64i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214932.8979 hg1hlt89oo69f2ktf7744vu64i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214932.8991 hg1hlt89oo69f2ktf7744vu64i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa1456366aaa35cda','aut66aaa2957866aaa35c9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214932.9009 hg1hlt89oo69f2ktf7744vu64i Query : use flama_phc
20240731@214932.9013 hg1hlt89oo69f2ktf7744vu64i Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20240731@214932.9047 hg1hlt89oo69f2ktf7744vu64i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1297';
20240731@214932.9074 hg1hlt89oo69f2ktf7744vu64i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1297';
20240731@214932.9969 qinr00vr1c643503mg60b7r4r1 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240731@214933.1420 qinr00vr1c643503mg60b7r4r1 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240731@214933.2250 qinr00vr1c643503mg60b7r4r1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1298';
20240731@214933.5340 qinr00vr1c643503mg60b7r4r1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1298';
20240731@214933.6610 qinr00vr1c643503mg60b7r4r1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1298';
20240731@214933.6870 qinr00vr1c643503mg60b7r4r1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1298';
20240731@214933.1862 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.1868 qinr00vr1c643503mg60b7r4r1 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240731@214933.1933 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.1937 qinr00vr1c643503mg60b7r4r1 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240731@214933.1979 qinr00vr1c643503mg60b7r4r1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20240731@214933.2155 qinr00vr1c643503mg60b7r4r1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405090 and bi.ref ='324.727.00.01' and bi.lordem =1
20240731@214933.2500 qinr00vr1c643503mg60b7r4r1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20240731@214933.2522 qinr00vr1c643503mg60b7r4r1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405090 and bi.ref ='324.727.00.01' and bi.lordem =1
20240731@214933.2539 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.2543 qinr00vr1c643503mg60b7r4r1 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240731@214933.2581 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.2584 qinr00vr1c643503mg60b7r4r1 Query : select top 1 1 valor from td where td.ndoc = 39
20240731@214933.2618 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.2621 qinr00vr1c643503mg60b7r4r1 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')
20240731@214933.2651 qinr00vr1c643503mg60b7r4r1 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
20240731@214933.2688 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.2691 qinr00vr1c643503mg60b7r4r1 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240731@214933.2723 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.2727 qinr00vr1c643503mg60b7r4r1 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240731@214933.2758 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.2761 qinr00vr1c643503mg60b7r4r1 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240731@214933.2798 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.2801 qinr00vr1c643503mg60b7r4r1 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240731@214933.2844 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.2847 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from td where ndoc = 39
20240731@214933.2858 qinr00vr1c643503mg60b7r4r1 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240731@214933.2872 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.2888 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@214933.2907 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.2921 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@214933.2950 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.2966 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@214933.2984 qinr00vr1c643503mg60b7r4r1 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@214933.3097 qinr00vr1c643503mg60b7r4r1 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@214933.3111 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.3129 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@214933.3147 qinr00vr1c643503mg60b7r4r1 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66aaa8576766aaa35d48' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240731@214933.3363 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.3384 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@214933.3420 qinr00vr1c643503mg60b7r4r1 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240731@214933.3434 qinr00vr1c643503mg60b7r4r1 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240731@214933.3447 qinr00vr1c643503mg60b7r4r1 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240731@214933.3460 qinr00vr1c643503mg60b7r4r1 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240731@214933.3472 qinr00vr1c643503mg60b7r4r1 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240731@214933.3484 qinr00vr1c643503mg60b7r4r1 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240731@214933.3495 qinr00vr1c643503mg60b7r4r1 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66aaa8576766aaa35d48',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240731@214933.3753 qinr00vr1c643503mg60b7r4r1 Query : select top 1 fno valor from wsftdata order by fno desc
20240731@214933.3770 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.3786 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@214933.3809 qinr00vr1c643503mg60b7r4r1 Query : select 'normal' from dummy
20240731@214933.3825 qinr00vr1c643503mg60b7r4r1 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66aaa8576766aaa35d48',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',131,100810,0,'2024-07-31',39,'euro',0,0,2024 ,?,?)
20240731@214933.4211 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.4215 qinr00vr1c643503mg60b7r4r1 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240731@214933.4238 qinr00vr1c643503mg60b7r4r1 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240731@214933.4413 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.4429 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214933.4464 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.4479 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214933.4487 qinr00vr1c643503mg60b7r4r1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214933.4499 qinr00vr1c643503mg60b7r4r1 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2300534200a'
20240731@214933.4527 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.4542 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214933.4554 qinr00vr1c643503mg60b7r4r1 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa8666266aaa35d6e','aut66aaa8576766aaa35d48' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214933.4558 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.4572 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214933.4599 qinr00vr1c643503mg60b7r4r1 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa8666266aaa35d6e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',40.000 ,'aut66aaa8576766aaa35d48' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240731@214933.4919 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.4944 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214933.4993 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.5144 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214933.5154 qinr00vr1c643503mg60b7r4r1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214933.5166 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.5183 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214933.5195 qinr00vr1c643503mg60b7r4r1 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa6473166aaa35d7e','aut66aaa8576766aaa35d48' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214933.5199 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.5215 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214933.5242 qinr00vr1c643503mg60b7r4r1 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66aaa6473166aaa35d7e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66aaa8576766aaa35d48' ,0,0 ,2,23.00,20000,?,?,?)
20240731@214933.5555 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.5558 qinr00vr1c643503mg60b7r4r1 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240731@214933.5577 qinr00vr1c643503mg60b7r4r1 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240731@214933.5592 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.5609 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214933.5635 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.5649 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214933.5659 qinr00vr1c643503mg60b7r4r1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214933.5671 qinr00vr1c643503mg60b7r4r1 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2300534200a'
20240731@214933.5683 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.5698 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214933.5709 qinr00vr1c643503mg60b7r4r1 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa4128666aaa35d8a','aut66aaa8576766aaa35d48' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214933.5714 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.5729 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214933.5758 qinr00vr1c643503mg60b7r4r1 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa4128666aaa35d8a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',120.000 ,'aut66aaa8576766aaa35d48' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240731@214933.6054 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.6072 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214933.6097 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.6113 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214933.6122 qinr00vr1c643503mg60b7r4r1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214933.6134 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.6151 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214933.6164 qinr00vr1c643503mg60b7r4r1 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa7158366aaa35d95','aut66aaa8576766aaa35d48' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214933.6168 qinr00vr1c643503mg60b7r4r1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214933.6183 qinr00vr1c643503mg60b7r4r1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214933.6212 qinr00vr1c643503mg60b7r4r1 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66aaa7158366aaa35d95',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66aaa8576766aaa35d48' ,0,0 ,2,23.00,50000,?,?,?)
20240731@214933.6523 qinr00vr1c643503mg60b7r4r1 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66aaa8576766aaa35d48','2405090','wait',39,'adm09112754980.682000002')
20240731@214933.6595 qinr00vr1c643503mg60b7r4r1 Query : use flama_phc
20240731@214933.6598 qinr00vr1c643503mg60b7r4r1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240731@214933.6628 qinr00vr1c643503mg60b7r4r1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1298';
20240731@214933.6652 qinr00vr1c643503mg60b7r4r1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1298';
20240731@214933.6688 qinr00vr1c643503mg60b7r4r1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1298';
20240731@214933.6711 qinr00vr1c643503mg60b7r4r1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1298';
20240731@214933.7365 pv637igrcpglcdvuuno4rjspor Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240731@214933.7418 pv637igrcpglcdvuuno4rjspor Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240731@214933.7671 pv637igrcpglcdvuuno4rjspor Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1299';
20240731@214933.7726 pv637igrcpglcdvuuno4rjspor Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1299';
20240731@214933.7774 pv637igrcpglcdvuuno4rjspor Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1299';
20240731@214933.7796 pv637igrcpglcdvuuno4rjspor Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1299';
20240731@214933.7844 pv637igrcpglcdvuuno4rjspor Query : use flama_phc
20240731@214933.7847 pv637igrcpglcdvuuno4rjspor Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240731@214933.7914 pv637igrcpglcdvuuno4rjspor Query : use flama_phc
20240731@214933.7917 pv637igrcpglcdvuuno4rjspor Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240731@214933.7990 pv637igrcpglcdvuuno4rjspor Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4723.00.2'
20240731@214933.9178 pv637igrcpglcdvuuno4rjspor Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405091 and bi.ref ='324.4723.00.2' and bi.lordem =1
20240731@214933.9688 pv637igrcpglcdvuuno4rjspor Query : use flama_phc
20240731@214933.9692 pv637igrcpglcdvuuno4rjspor Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240731@214933.9728 pv637igrcpglcdvuuno4rjspor Query : use flama_phc
20240731@214933.9732 pv637igrcpglcdvuuno4rjspor Query : select top 1 1 valor from td where td.ndoc = 39
20240731@214933.9788 pv637igrcpglcdvuuno4rjspor Query : use flama_phc
20240731@214933.9792 pv637igrcpglcdvuuno4rjspor 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')
20240731@214933.9825 pv637igrcpglcdvuuno4rjspor 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
20240731@214933.9860 pv637igrcpglcdvuuno4rjspor Query : use flama_phc
20240731@214933.9863 pv637igrcpglcdvuuno4rjspor Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240731@214933.9894 pv637igrcpglcdvuuno4rjspor Query : use flama_phc
20240731@214933.9898 pv637igrcpglcdvuuno4rjspor Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240731@214933.9928 pv637igrcpglcdvuuno4rjspor Query : use flama_phc
20240731@214933.9931 pv637igrcpglcdvuuno4rjspor Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240731@214933.9971 pv637igrcpglcdvuuno4rjspor Query : use flama_phc
20240731@214933.9974 pv637igrcpglcdvuuno4rjspor Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240731@214934.1800 pv637igrcpglcdvuuno4rjspor Query : use flama_phc
20240731@214934.2100 pv637igrcpglcdvuuno4rjspor Query : select 1 valor from td where ndoc = 39
20240731@214934.3300 pv637igrcpglcdvuuno4rjspor Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240731@214934.4700 pv637igrcpglcdvuuno4rjspor Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.6400 pv637igrcpglcdvuuno4rjspor Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@214934.8300 pv637igrcpglcdvuuno4rjspor Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.9800 pv637igrcpglcdvuuno4rjspor Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@214934.1300 pv637igrcpglcdvuuno4rjspor Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.1440 pv637igrcpglcdvuuno4rjspor Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@214934.1560 pv637igrcpglcdvuuno4rjspor Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@214934.2310 pv637igrcpglcdvuuno4rjspor Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@214934.2440 pv637igrcpglcdvuuno4rjspor Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.2580 pv637igrcpglcdvuuno4rjspor Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@214934.2740 pv637igrcpglcdvuuno4rjspor Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66aaa9640966aaa35e03' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240731@214934.4710 pv637igrcpglcdvuuno4rjspor Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.4890 pv637igrcpglcdvuuno4rjspor Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@214934.5250 pv637igrcpglcdvuuno4rjspor Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240731@214934.5390 pv637igrcpglcdvuuno4rjspor Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240731@214934.5500 pv637igrcpglcdvuuno4rjspor Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240731@214934.5620 pv637igrcpglcdvuuno4rjspor Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240731@214934.5730 pv637igrcpglcdvuuno4rjspor Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240731@214934.5850 pv637igrcpglcdvuuno4rjspor Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240731@214934.5970 pv637igrcpglcdvuuno4rjspor Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66aaa9640966aaa35e03',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240731@214934.8680 pv637igrcpglcdvuuno4rjspor Query : select top 1 fno valor from wsftdata order by fno desc
20240731@214934.8860 pv637igrcpglcdvuuno4rjspor Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.9030 pv637igrcpglcdvuuno4rjspor Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@214934.9360 pv637igrcpglcdvuuno4rjspor Query : select 'normal' from dummy
20240731@214934.9520 pv637igrcpglcdvuuno4rjspor Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66aaa9640966aaa35e03',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',132,100810,0,'2024-07-31',39,'euro',0,0,2024 ,?,?)
20240731@214934.1288 pv637igrcpglcdvuuno4rjspor Query : use flama_phc
20240731@214934.1291 pv637igrcpglcdvuuno4rjspor Query : select st.usalote valor from st where st.ref = '324.4723.00.2'
20240731@214934.1316 pv637igrcpglcdvuuno4rjspor Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4723.00.2'
20240731@214934.1478 pv637igrcpglcdvuuno4rjspor Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.1496 pv637igrcpglcdvuuno4rjspor Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214934.1524 pv637igrcpglcdvuuno4rjspor Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.1542 pv637igrcpglcdvuuno4rjspor Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214934.1551 pv637igrcpglcdvuuno4rjspor Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214934.1564 pv637igrcpglcdvuuno4rjspor Query : select sestamp valor from se where ref ='324.4723.00.2' and lote = 'r2200682200a'
20240731@214934.1599 pv637igrcpglcdvuuno4rjspor Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.1616 pv637igrcpglcdvuuno4rjspor Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214934.1629 pv637igrcpglcdvuuno4rjspor Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa0055566aaa35e27','aut66aaa9640966aaa35e03' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214934.1634 pv637igrcpglcdvuuno4rjspor Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.1650 pv637igrcpglcdvuuno4rjspor Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214934.1682 pv637igrcpglcdvuuno4rjspor Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa0055566aaa35e27',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',39.000 ,'aut66aaa9640966aaa35e03' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240731@214934.1991 pv637igrcpglcdvuuno4rjspor Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66aaa9640966aaa35e03','2405091','wait',39,'adm09112754980.682000002')
20240731@214934.2175 pv637igrcpglcdvuuno4rjspor Query : use flama_phc
20240731@214934.2179 pv637igrcpglcdvuuno4rjspor Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240731@214934.2272 pv637igrcpglcdvuuno4rjspor Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1299';
20240731@214934.2311 pv637igrcpglcdvuuno4rjspor Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1299';
20240731@214934.2360 pv637igrcpglcdvuuno4rjspor Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1299';
20240731@214934.2388 pv637igrcpglcdvuuno4rjspor Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1299';
20240731@214934.2969 28svhlhbgkgbbhfmmvv0n3bmri Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240731@214934.2981 28svhlhbgkgbbhfmmvv0n3bmri Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240731@214934.3038 28svhlhbgkgbbhfmmvv0n3bmri Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1300';
20240731@214934.3106 28svhlhbgkgbbhfmmvv0n3bmri Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1300';
20240731@214934.3160 28svhlhbgkgbbhfmmvv0n3bmri Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1300';
20240731@214934.3185 28svhlhbgkgbbhfmmvv0n3bmri Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1300';
20240731@214934.3236 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214934.3240 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240731@214934.3312 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214934.3315 28svhlhbgkgbbhfmmvv0n3bmri Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240731@214934.3360 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4965.00.1'
20240731@214934.3619 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405093 and bi.ref ='324.4965.00.1' and bi.lordem =1
20240731@214934.3997 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4965.00.1'
20240731@214934.4019 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405093 and bi.ref ='324.4965.00.1' and bi.lordem =1
20240731@214934.4037 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214934.4040 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240731@214934.4431 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214934.4435 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 1 valor from td where td.ndoc = 39
20240731@214934.4646 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214934.4675 28svhlhbgkgbbhfmmvv0n3bmri 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')
20240731@214934.4719 28svhlhbgkgbbhfmmvv0n3bmri 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
20240731@214934.4855 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214934.4863 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240731@214934.4895 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214934.4898 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240731@214934.5006 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214934.5013 28svhlhbgkgbbhfmmvv0n3bmri Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240731@214934.5106 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214934.5110 28svhlhbgkgbbhfmmvv0n3bmri Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240731@214934.5213 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214934.5300 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from td where ndoc = 39
20240731@214934.5342 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240731@214934.5358 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.5497 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@214934.5575 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.5664 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@214934.5791 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.5991 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@214934.6068 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@214934.6214 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@214934.6347 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.6424 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@214934.6509 28svhlhbgkgbbhfmmvv0n3bmri Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66aaa0058866aaa35e94' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240731@214934.6694 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214934.6904 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@214934.7981 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240731@214934.8019 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240731@214934.8036 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240731@214934.8227 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240731@214934.8240 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240731@214934.8253 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240731@214934.8265 28svhlhbgkgbbhfmmvv0n3bmri Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66aaa0058866aaa35e94',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240731@214934.9563 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 fno valor from wsftdata order by fno desc
20240731@214935.1925 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.1957 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@214935.1983 28svhlhbgkgbbhfmmvv0n3bmri Query : select 'normal' from dummy
20240731@214935.1998 28svhlhbgkgbbhfmmvv0n3bmri Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66aaa0058866aaa35e94',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',133,100810,0,'2024-07-31',39,'euro',0,0,2024 ,?,?)
20240731@214935.2437 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214935.2441 28svhlhbgkgbbhfmmvv0n3bmri Query : select st.usalote valor from st where st.ref = '324.4965.00.1'
20240731@214935.2465 28svhlhbgkgbbhfmmvv0n3bmri 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.4965.00.1'
20240731@214935.2637 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.2654 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.2684 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.2700 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.2709 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214935.2722 28svhlhbgkgbbhfmmvv0n3bmri Query : select sestamp valor from se where ref ='324.4965.00.1' and lote = 'r2301277100a'
20240731@214935.2736 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.2750 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.2762 28svhlhbgkgbbhfmmvv0n3bmri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa7320766aaa35f42','aut66aaa0058866aaa35e94' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214935.2766 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.2782 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.2810 28svhlhbgkgbbhfmmvv0n3bmri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa7320766aaa35f42',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut66aaa0058866aaa35e94' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240731@214935.3128 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214935.3131 28svhlhbgkgbbhfmmvv0n3bmri Query : select st.usalote valor from st where st.ref = '324.4965.00.1'
20240731@214935.3154 28svhlhbgkgbbhfmmvv0n3bmri 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.4965.00.1'
20240731@214935.3169 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.3185 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.3210 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.3226 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.3234 28svhlhbgkgbbhfmmvv0n3bmri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214935.3247 28svhlhbgkgbbhfmmvv0n3bmri Query : select sestamp valor from se where ref ='324.4965.00.1' and lote = 'r2301277100a'
20240731@214935.3261 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.3275 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.3287 28svhlhbgkgbbhfmmvv0n3bmri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa1952866aaa35f4f','aut66aaa0058866aaa35e94' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214935.3291 28svhlhbgkgbbhfmmvv0n3bmri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.3305 28svhlhbgkgbbhfmmvv0n3bmri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.3334 28svhlhbgkgbbhfmmvv0n3bmri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa1952866aaa35f4f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',80.000 ,'aut66aaa0058866aaa35e94' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240731@214935.3622 28svhlhbgkgbbhfmmvv0n3bmri Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66aaa0058866aaa35e94','2405093','wait',39,'adm09112754980.682000002')
20240731@214935.3696 28svhlhbgkgbbhfmmvv0n3bmri Query : use flama_phc
20240731@214935.3700 28svhlhbgkgbbhfmmvv0n3bmri Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240731@214935.3732 28svhlhbgkgbbhfmmvv0n3bmri Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1300';
20240731@214935.3759 28svhlhbgkgbbhfmmvv0n3bmri Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1300';
20240731@214935.3797 28svhlhbgkgbbhfmmvv0n3bmri Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1300';
20240731@214935.3824 28svhlhbgkgbbhfmmvv0n3bmri Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1300';
20240731@214935.4406 oh0le8625f95nv26ho42pgi4nm Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240731@214935.4420 oh0le8625f95nv26ho42pgi4nm Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240731@214935.4472 oh0le8625f95nv26ho42pgi4nm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1301';
20240731@214935.4524 oh0le8625f95nv26ho42pgi4nm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1301';
20240731@214935.4572 oh0le8625f95nv26ho42pgi4nm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1301';
20240731@214935.4597 oh0le8625f95nv26ho42pgi4nm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1301';
20240731@214935.4649 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.4653 oh0le8625f95nv26ho42pgi4nm Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240731@214935.4723 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.4726 oh0le8625f95nv26ho42pgi4nm Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240731@214935.4764 oh0le8625f95nv26ho42pgi4nm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240731@214935.4932 oh0le8625f95nv26ho42pgi4nm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405094 and bi.ref ='324.4970.00.1' and bi.lordem =1
20240731@214935.5428 oh0le8625f95nv26ho42pgi4nm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240731@214935.5452 oh0le8625f95nv26ho42pgi4nm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405094 and bi.ref ='324.4970.00.1' and bi.lordem =1
20240731@214935.5475 oh0le8625f95nv26ho42pgi4nm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240731@214935.5502 oh0le8625f95nv26ho42pgi4nm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405094 and bi.ref ='324.4970.00.1' and bi.lordem =1
20240731@214935.5523 oh0le8625f95nv26ho42pgi4nm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240731@214935.5545 oh0le8625f95nv26ho42pgi4nm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405094 and bi.ref ='324.4970.00.1' and bi.lordem =1
20240731@214935.5564 oh0le8625f95nv26ho42pgi4nm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240731@214935.5590 oh0le8625f95nv26ho42pgi4nm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405094 and bi.ref ='324.4970.00.1' and bi.lordem =1
20240731@214935.5612 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.5616 oh0le8625f95nv26ho42pgi4nm Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240731@214935.5657 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.5660 oh0le8625f95nv26ho42pgi4nm Query : select top 1 1 valor from td where td.ndoc = 39
20240731@214935.5701 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.5704 oh0le8625f95nv26ho42pgi4nm 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')
20240731@214935.5739 oh0le8625f95nv26ho42pgi4nm 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
20240731@214935.5780 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.5783 oh0le8625f95nv26ho42pgi4nm Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240731@214935.5826 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.5829 oh0le8625f95nv26ho42pgi4nm Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240731@214935.5865 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.5869 oh0le8625f95nv26ho42pgi4nm Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240731@214935.5925 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.5929 oh0le8625f95nv26ho42pgi4nm Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240731@214935.5984 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.5987 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from td where ndoc = 39
20240731@214935.6000 oh0le8625f95nv26ho42pgi4nm Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240731@214935.6016 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.6032 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@214935.6051 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.6068 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@214935.6101 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.6120 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@214935.6135 oh0le8625f95nv26ho42pgi4nm Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@214935.6284 oh0le8625f95nv26ho42pgi4nm Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@214935.6299 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.6320 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@214935.6338 oh0le8625f95nv26ho42pgi4nm Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66aaa1849866aaa35f95' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240731@214935.6545 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.6567 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@214935.6604 oh0le8625f95nv26ho42pgi4nm Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240731@214935.6618 oh0le8625f95nv26ho42pgi4nm Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240731@214935.6630 oh0le8625f95nv26ho42pgi4nm Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240731@214935.6642 oh0le8625f95nv26ho42pgi4nm Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240731@214935.6655 oh0le8625f95nv26ho42pgi4nm Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240731@214935.6668 oh0le8625f95nv26ho42pgi4nm Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240731@214935.6680 oh0le8625f95nv26ho42pgi4nm Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66aaa1849866aaa35f95',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240731@214935.6941 oh0le8625f95nv26ho42pgi4nm Query : select top 1 fno valor from wsftdata order by fno desc
20240731@214935.6959 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.6977 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@214935.7000 oh0le8625f95nv26ho42pgi4nm Query : select 'normal' from dummy
20240731@214935.7016 oh0le8625f95nv26ho42pgi4nm Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66aaa1849866aaa35f95',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',134,100810,0,'2024-07-31',39,'euro',0,0,2024 ,?,?)
20240731@214935.7328 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.7331 oh0le8625f95nv26ho42pgi4nm Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240731@214935.7356 oh0le8625f95nv26ho42pgi4nm Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240731@214935.7505 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.7522 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.7547 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.7561 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.7569 oh0le8625f95nv26ho42pgi4nm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214935.7584 oh0le8625f95nv26ho42pgi4nm Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400205200a'
20240731@214935.7600 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.7616 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.7629 oh0le8625f95nv26ho42pgi4nm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa3695966aaa35fb9','aut66aaa1849866aaa35f95' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214935.7634 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.7650 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.7684 oh0le8625f95nv26ho42pgi4nm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa3695966aaa35fb9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut66aaa1849866aaa35f95' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240731@214935.7950 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.7953 oh0le8625f95nv26ho42pgi4nm Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240731@214935.7977 oh0le8625f95nv26ho42pgi4nm Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240731@214935.7994 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.8011 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.8039 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.8054 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.8063 oh0le8625f95nv26ho42pgi4nm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214935.8077 oh0le8625f95nv26ho42pgi4nm Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400205200a'
20240731@214935.8091 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.8106 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.8119 oh0le8625f95nv26ho42pgi4nm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa7888566aaa35fc5','aut66aaa1849866aaa35f95' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214935.8125 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.8143 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.8176 oh0le8625f95nv26ho42pgi4nm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa7888566aaa35fc5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut66aaa1849866aaa35f95' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240731@214935.8444 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.8448 oh0le8625f95nv26ho42pgi4nm Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240731@214935.8470 oh0le8625f95nv26ho42pgi4nm Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240731@214935.8486 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.8503 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.8530 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.8545 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.8553 oh0le8625f95nv26ho42pgi4nm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214935.8566 oh0le8625f95nv26ho42pgi4nm Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400205200a'
20240731@214935.8579 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.8593 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.8606 oh0le8625f95nv26ho42pgi4nm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa2755466aaa35fd1','aut66aaa1849866aaa35f95' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214935.8611 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.8626 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.8659 oh0le8625f95nv26ho42pgi4nm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa2755466aaa35fd1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut66aaa1849866aaa35f95' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240731@214935.8934 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.8938 oh0le8625f95nv26ho42pgi4nm Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240731@214935.8961 oh0le8625f95nv26ho42pgi4nm Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240731@214935.8976 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.8995 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.9023 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.9039 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.9047 oh0le8625f95nv26ho42pgi4nm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214935.9059 oh0le8625f95nv26ho42pgi4nm Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400205200a'
20240731@214935.9072 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.9087 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.9099 oh0le8625f95nv26ho42pgi4nm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa3060166aaa35fdd','aut66aaa1849866aaa35f95' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214935.9103 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.9118 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.9147 oh0le8625f95nv26ho42pgi4nm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa3060166aaa35fdd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut66aaa1849866aaa35f95' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240731@214935.9416 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214935.9419 oh0le8625f95nv26ho42pgi4nm Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240731@214935.9439 oh0le8625f95nv26ho42pgi4nm Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240731@214935.9453 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.9468 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.9493 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.9509 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.9518 oh0le8625f95nv26ho42pgi4nm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214935.9531 oh0le8625f95nv26ho42pgi4nm Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400205200a'
20240731@214935.9547 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.9564 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214935.9577 oh0le8625f95nv26ho42pgi4nm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa5692866aaa35fe9','aut66aaa1849866aaa35f95' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214935.9581 oh0le8625f95nv26ho42pgi4nm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214935.9596 oh0le8625f95nv26ho42pgi4nm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214935.9627 oh0le8625f95nv26ho42pgi4nm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa5692866aaa35fe9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut66aaa1849866aaa35f95' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240731@214936.3100 oh0le8625f95nv26ho42pgi4nm Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66aaa1849866aaa35f95','2405094','wait',39,'adm09112754980.682000002')
20240731@214936.4610 oh0le8625f95nv26ho42pgi4nm Query : use flama_phc
20240731@214936.4650 oh0le8625f95nv26ho42pgi4nm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240731@214936.4960 oh0le8625f95nv26ho42pgi4nm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1301';
20240731@214936.5210 oh0le8625f95nv26ho42pgi4nm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1301';
20240731@214936.5550 oh0le8625f95nv26ho42pgi4nm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1301';
20240731@214936.5780 oh0le8625f95nv26ho42pgi4nm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1301';
20240731@214936.2260 73k0l063mlk8af2u72c29s88hk Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240731@214936.2273 73k0l063mlk8af2u72c29s88hk Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240731@214936.2337 73k0l063mlk8af2u72c29s88hk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1302';
20240731@214936.2396 73k0l063mlk8af2u72c29s88hk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1302';
20240731@214936.2509 73k0l063mlk8af2u72c29s88hk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1302';
20240731@214936.2542 73k0l063mlk8af2u72c29s88hk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1302';
20240731@214936.2592 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.2596 73k0l063mlk8af2u72c29s88hk Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240731@214936.2676 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.2721 73k0l063mlk8af2u72c29s88hk Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240731@214936.2929 73k0l063mlk8af2u72c29s88hk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240731@214936.3126 73k0l063mlk8af2u72c29s88hk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405095 and bi.ref ='324.948.00.01' and bi.lordem =1
20240731@214936.3703 73k0l063mlk8af2u72c29s88hk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240731@214936.3729 73k0l063mlk8af2u72c29s88hk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405095 and bi.ref ='324.948.00.01' and bi.lordem =1
20240731@214936.3748 73k0l063mlk8af2u72c29s88hk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240731@214936.3797 73k0l063mlk8af2u72c29s88hk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405095 and bi.ref ='324.948.00.01' and bi.lordem =1
20240731@214936.3823 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.3827 73k0l063mlk8af2u72c29s88hk Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240731@214936.3863 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.3868 73k0l063mlk8af2u72c29s88hk Query : select top 1 1 valor from td where td.ndoc = 39
20240731@214936.3918 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.3922 73k0l063mlk8af2u72c29s88hk 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')
20240731@214936.3957 73k0l063mlk8af2u72c29s88hk 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
20240731@214936.3994 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.3998 73k0l063mlk8af2u72c29s88hk Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240731@214936.4032 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.4035 73k0l063mlk8af2u72c29s88hk Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240731@214936.4069 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.4072 73k0l063mlk8af2u72c29s88hk Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240731@214936.4112 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.4115 73k0l063mlk8af2u72c29s88hk Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240731@214936.4161 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.4165 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from td where ndoc = 39
20240731@214936.4179 73k0l063mlk8af2u72c29s88hk Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240731@214936.4208 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.4235 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@214936.4254 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.4275 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@214936.4312 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.4328 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@214936.4341 73k0l063mlk8af2u72c29s88hk Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@214936.4417 73k0l063mlk8af2u72c29s88hk Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@214936.4439 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.4454 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@214936.4470 73k0l063mlk8af2u72c29s88hk Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66aaa5739466aaa36069' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240731@214936.4663 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.4691 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@214936.4728 73k0l063mlk8af2u72c29s88hk Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240731@214936.4740 73k0l063mlk8af2u72c29s88hk Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240731@214936.4751 73k0l063mlk8af2u72c29s88hk Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240731@214936.4771 73k0l063mlk8af2u72c29s88hk Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240731@214936.4782 73k0l063mlk8af2u72c29s88hk Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240731@214936.4795 73k0l063mlk8af2u72c29s88hk Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240731@214936.4806 73k0l063mlk8af2u72c29s88hk Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66aaa5739466aaa36069',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240731@214936.5148 73k0l063mlk8af2u72c29s88hk Query : select top 1 fno valor from wsftdata order by fno desc
20240731@214936.5168 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.5186 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@214936.5212 73k0l063mlk8af2u72c29s88hk Query : select 'normal' from dummy
20240731@214936.5229 73k0l063mlk8af2u72c29s88hk Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66aaa5739466aaa36069',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',135,100810,0,'2024-07-31',39,'euro',0,0,2024 ,?,?)
20240731@214936.5753 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.5757 73k0l063mlk8af2u72c29s88hk Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240731@214936.5782 73k0l063mlk8af2u72c29s88hk Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.948.00.01'
20240731@214936.5965 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.5983 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214936.6012 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.6027 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214936.6037 73k0l063mlk8af2u72c29s88hk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214936.6050 73k0l063mlk8af2u72c29s88hk Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240731@214936.6065 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.6160 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214936.6284 73k0l063mlk8af2u72c29s88hk Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa7946466aaa36094','aut66aaa5739466aaa36069' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214936.6289 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.6306 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214936.6339 73k0l063mlk8af2u72c29s88hk Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa7946466aaa36094',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66aaa5739466aaa36069' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240731@214936.6611 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.6614 73k0l063mlk8af2u72c29s88hk Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240731@214936.6637 73k0l063mlk8af2u72c29s88hk Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.948.00.01'
20240731@214936.6664 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.6682 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214936.6711 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.6730 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214936.6739 73k0l063mlk8af2u72c29s88hk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214936.6753 73k0l063mlk8af2u72c29s88hk Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240731@214936.6768 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.6784 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214936.6798 73k0l063mlk8af2u72c29s88hk Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa4449166aaa360a5','aut66aaa5739466aaa36069' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214936.6803 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.6818 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214936.6850 73k0l063mlk8af2u72c29s88hk Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa4449166aaa360a5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut66aaa5739466aaa36069' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240731@214936.7124 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.7128 73k0l063mlk8af2u72c29s88hk Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240731@214936.7149 73k0l063mlk8af2u72c29s88hk Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.948.00.01'
20240731@214936.7165 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.7182 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214936.7211 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.7234 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214936.7243 73k0l063mlk8af2u72c29s88hk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214936.7256 73k0l063mlk8af2u72c29s88hk Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240731@214936.7269 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.7284 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214936.7297 73k0l063mlk8af2u72c29s88hk Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa0885666aaa360b1','aut66aaa5739466aaa36069' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214936.7301 73k0l063mlk8af2u72c29s88hk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214936.7316 73k0l063mlk8af2u72c29s88hk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214936.7348 73k0l063mlk8af2u72c29s88hk Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa0885666aaa360b1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut66aaa5739466aaa36069' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240731@214936.7733 73k0l063mlk8af2u72c29s88hk Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66aaa5739466aaa36069','2405095','wait',39,'adm09112754980.682000002')
20240731@214936.7814 73k0l063mlk8af2u72c29s88hk Query : use flama_phc
20240731@214936.7818 73k0l063mlk8af2u72c29s88hk Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240731@214936.7888 73k0l063mlk8af2u72c29s88hk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1302';
20240731@214936.8074 73k0l063mlk8af2u72c29s88hk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1302';
20240731@214936.8124 73k0l063mlk8af2u72c29s88hk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1302';
20240731@214936.8148 73k0l063mlk8af2u72c29s88hk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1302';
20240731@214936.8715 pm8l815cuiufuo2t3vdrv05k40 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240731@214936.8726 pm8l815cuiufuo2t3vdrv05k40 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240731@214936.8774 pm8l815cuiufuo2t3vdrv05k40 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1303';
20240731@214936.8832 pm8l815cuiufuo2t3vdrv05k40 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1303';
20240731@214936.8877 pm8l815cuiufuo2t3vdrv05k40 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1303';
20240731@214936.8899 pm8l815cuiufuo2t3vdrv05k40 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1303';
20240731@214936.8942 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214936.8945 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240731@214936.9007 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214936.9010 pm8l815cuiufuo2t3vdrv05k40 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20240731@214936.9101 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8152.00.1'
20240731@214936.9275 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405096 and bi.ref ='327.8152.00.1' and bi.lordem =1
20240731@214937.8630 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8410.00.1'
20240731@214937.1058 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405096 and bi.ref ='327.8410.00.1' and bi.lordem =2
20240731@214937.1474 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8410.00.1'
20240731@214937.1494 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405096 and bi.ref ='327.8410.00.1' and bi.lordem =2
20240731@214937.1512 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214937.1556 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240731@214937.1773 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214937.1777 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 1 valor from td where td.ndoc = 39
20240731@214937.1821 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214937.1824 pm8l815cuiufuo2t3vdrv05k40 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')
20240731@214937.1860 pm8l815cuiufuo2t3vdrv05k40 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
20240731@214937.1903 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214937.1906 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240731@214937.1937 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214937.1940 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240731@214937.1970 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214937.1973 pm8l815cuiufuo2t3vdrv05k40 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240731@214937.2013 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214937.2016 pm8l815cuiufuo2t3vdrv05k40 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20240731@214937.2069 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214937.2072 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from td where ndoc = 39
20240731@214937.2085 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240731@214937.2098 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.2116 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@214937.2136 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.2231 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@214937.2378 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.2398 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@214937.2412 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@214937.2483 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@214937.2497 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.2513 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@214937.2531 pm8l815cuiufuo2t3vdrv05k40 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66aaa8367766aaa3613a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240731@214937.2722 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.2741 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@214937.2776 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240731@214937.2788 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240731@214937.2800 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240731@214937.2812 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240731@214937.2825 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240731@214937.2838 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240731@214937.2850 pm8l815cuiufuo2t3vdrv05k40 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66aaa8367766aaa3613a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240731@214937.3156 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 fno valor from wsftdata order by fno desc
20240731@214937.3176 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.3204 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@214937.3228 pm8l815cuiufuo2t3vdrv05k40 Query : select 'normal' from dummy
20240731@214937.3244 pm8l815cuiufuo2t3vdrv05k40 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66aaa8367766aaa3613a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',136,100810,0,'2024-07-31',39,'euro',0,0,2024 ,?,?)
20240731@214937.3567 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214937.3570 pm8l815cuiufuo2t3vdrv05k40 Query : select st.usalote valor from st where st.ref = '327.8152.00.1'
20240731@214937.3639 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '327.8152.00.1'
20240731@214937.3838 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.3855 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214937.3886 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.3901 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214937.3910 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214937.3923 pm8l815cuiufuo2t3vdrv05k40 Query : select sestamp valor from se where ref ='327.8152.00.1' and lote = 'r2400077200a'
20240731@214937.3937 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.3953 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214937.3965 pm8l815cuiufuo2t3vdrv05k40 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa5039766aaa36160','aut66aaa8367766aaa3613a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214937.3971 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.3985 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214937.4015 pm8l815cuiufuo2t3vdrv05k40 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa5039766aaa36160',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66aaa8367766aaa3613a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240731@214937.4449 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.4510 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214937.4542 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.4567 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214937.4576 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214937.4589 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.4605 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214937.4621 pm8l815cuiufuo2t3vdrv05k40 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa5626266aaa36170','aut66aaa8367766aaa3613a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214937.4626 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.4642 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214937.4675 pm8l815cuiufuo2t3vdrv05k40 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66aaa5626266aaa36170',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66aaa8367766aaa3613a' ,0,0 ,2,23.00,20000,?,?,?)
20240731@214937.5067 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214937.5110 pm8l815cuiufuo2t3vdrv05k40 Query : select st.usalote valor from st where st.ref = '327.8410.00.1'
20240731@214937.5164 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '327.8410.00.1'
20240731@214937.5337 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.5357 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214937.5388 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.5405 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214937.5416 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214937.5430 pm8l815cuiufuo2t3vdrv05k40 Query : select sestamp valor from se where ref ='327.8410.00.1' and lote = 'r2301152200a'
20240731@214937.5459 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.5476 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214937.5489 pm8l815cuiufuo2t3vdrv05k40 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa4102266aaa36185','aut66aaa8367766aaa3613a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214937.5495 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.5512 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214937.5543 pm8l815cuiufuo2t3vdrv05k40 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66aaa4102266aaa36185',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66aaa8367766aaa3613a' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240731@214937.5826 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.5844 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214937.5870 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.7025 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214937.7035 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214937.7052 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.7070 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214937.7086 pm8l815cuiufuo2t3vdrv05k40 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66aaa7278566aaa361ac','aut66aaa8367766aaa3613a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@214937.7091 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.7107 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214937.7141 pm8l815cuiufuo2t3vdrv05k40 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66aaa7278566aaa361ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66aaa8367766aaa3613a' ,0,0 ,2,23.00,50000,?,?,?)
20240731@214937.7582 pm8l815cuiufuo2t3vdrv05k40 Query : use flama_phc
20240731@214937.7586 pm8l815cuiufuo2t3vdrv05k40 Query : select st.usalote valor from st where st.ref = '327.8410.00.1'
20240731@214937.7633 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '327.8410.00.1'
20240731@214937.7648 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.7667 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@214937.7695 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@214937.7712 pm8l815cuiufuo2t3vdrv05k40 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@214937.7722 pm8l815cuiufuo2t3vdrv05k40 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@214937.7735 pm8l815cuiufuo2t3vdrv05k40 Query : select sestamp valor from se where ref ='327.8410.00.1' and lote = 'r2301152200a'
20240731@214937.7749 pm8l815cuiufuo2t3vdrv05k40 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
