20240909@174156.7669 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174156.7692 vdvu9ef0euuhnl81v511ma37js Query : select 'normal' from dummy
20240909@174156.7708 vdvu9ef0euuhnl81v511ma37js Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66df25848066df25548e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',666,100810,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@174156.8042 vdvu9ef0euuhnl81v511ma37js Query : use flama_phc
20240909@174156.8046 vdvu9ef0euuhnl81v511ma37js Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240909@174156.8068 vdvu9ef0euuhnl81v511ma37js 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'
20240909@174156.8225 vdvu9ef0euuhnl81v511ma37js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174156.8243 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174156.8268 vdvu9ef0euuhnl81v511ma37js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174156.8281 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174156.8289 vdvu9ef0euuhnl81v511ma37js Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174156.8301 vdvu9ef0euuhnl81v511ma37js Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240909@174156.8314 vdvu9ef0euuhnl81v511ma37js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174156.8328 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174156.8340 vdvu9ef0euuhnl81v511ma37js Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df25098666df2554ca','aut66df25848066df25548e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174156.8344 vdvu9ef0euuhnl81v511ma37js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174156.8357 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174156.8385 vdvu9ef0euuhnl81v511ma37js Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df25098666df2554ca',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66df25848066df25548e' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@174156.8911 vdvu9ef0euuhnl81v511ma37js Query : use flama_phc
20240909@174156.8915 vdvu9ef0euuhnl81v511ma37js Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240909@174156.8935 vdvu9ef0euuhnl81v511ma37js 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'
20240909@174156.8949 vdvu9ef0euuhnl81v511ma37js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174156.8965 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174156.8989 vdvu9ef0euuhnl81v511ma37js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174156.9003 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174156.9011 vdvu9ef0euuhnl81v511ma37js Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174156.9023 vdvu9ef0euuhnl81v511ma37js Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240909@174156.9036 vdvu9ef0euuhnl81v511ma37js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174156.9049 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174156.9061 vdvu9ef0euuhnl81v511ma37js Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df20913666df2554dc','aut66df25848066df25548e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174156.9065 vdvu9ef0euuhnl81v511ma37js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174156.9079 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174156.9106 vdvu9ef0euuhnl81v511ma37js Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df20913666df2554dc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66df25848066df25548e' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240909@174156.9371 vdvu9ef0euuhnl81v511ma37js Query : use flama_phc
20240909@174156.9374 vdvu9ef0euuhnl81v511ma37js Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240909@174156.9394 vdvu9ef0euuhnl81v511ma37js 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'
20240909@174156.9407 vdvu9ef0euuhnl81v511ma37js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174156.9422 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174156.9447 vdvu9ef0euuhnl81v511ma37js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174156.9461 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174156.9470 vdvu9ef0euuhnl81v511ma37js Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174156.9481 vdvu9ef0euuhnl81v511ma37js Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240909@174156.9493 vdvu9ef0euuhnl81v511ma37js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174156.9507 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174156.9518 vdvu9ef0euuhnl81v511ma37js Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df23492866df2554e7','aut66df25848066df25548e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174156.9522 vdvu9ef0euuhnl81v511ma37js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174156.9536 vdvu9ef0euuhnl81v511ma37js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174156.9563 vdvu9ef0euuhnl81v511ma37js Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df23492866df2554e7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut66df25848066df25548e' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240909@174156.9993 vdvu9ef0euuhnl81v511ma37js Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66df25848066df25548e','2405826','wait',39,'adm09112754980.682000002')
20240909@174157.2410 vdvu9ef0euuhnl81v511ma37js Query : use flama_phc
20240909@174157.2450 vdvu9ef0euuhnl81v511ma37js Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240909@174157.2730 vdvu9ef0euuhnl81v511ma37js Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1906';
20240909@174157.3030 vdvu9ef0euuhnl81v511ma37js Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1906';
20240909@174157.3460 vdvu9ef0euuhnl81v511ma37js Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1906';
20240909@174157.3700 vdvu9ef0euuhnl81v511ma37js Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1906';
20240909@174157.1073 tq6keifnfssp3061cbd3kkouh4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240909@174157.1084 tq6keifnfssp3061cbd3kkouh4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240909@174157.1143 tq6keifnfssp3061cbd3kkouh4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1907';
20240909@174157.1196 tq6keifnfssp3061cbd3kkouh4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1907';
20240909@174157.1249 tq6keifnfssp3061cbd3kkouh4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1907';
20240909@174157.1272 tq6keifnfssp3061cbd3kkouh4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1907';
20240909@174157.1321 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.1324 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240909@174157.1388 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.1391 tq6keifnfssp3061cbd3kkouh4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240909@174157.1453 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20240909@174157.1473 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405827 and bi.ref ='324.945.00.01' and bi.lordem =1
20240909@174157.1975 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20240909@174157.2000 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405827 and bi.ref ='324.945.00.01' and bi.lordem =1
20240909@174157.2017 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.2020 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240909@174157.2074 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.2077 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 1 valor from td where td.ndoc = 39
20240909@174157.2107 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.2110 tq6keifnfssp3061cbd3kkouh4 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')
20240909@174157.2139 tq6keifnfssp3061cbd3kkouh4 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
20240909@174157.2179 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.2183 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240909@174157.2216 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.2218 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240909@174157.2251 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.2254 tq6keifnfssp3061cbd3kkouh4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240909@174157.2311 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.2314 tq6keifnfssp3061cbd3kkouh4 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240909@174157.2359 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.2362 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from td where ndoc = 39
20240909@174157.2374 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240909@174157.2388 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.2412 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174157.2431 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.2446 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174157.2486 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.2502 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174157.2514 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174157.2602 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174157.2619 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.2636 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174157.2653 tq6keifnfssp3061cbd3kkouh4 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66df20775966df25553d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240909@174157.2840 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.2868 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174157.2905 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240909@174157.2918 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240909@174157.2930 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240909@174157.2960 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240909@174157.2973 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240909@174157.2986 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240909@174157.2998 tq6keifnfssp3061cbd3kkouh4 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66df20775966df25553d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240909@174157.3265 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 fno valor from wsftdata order by fno desc
20240909@174157.3298 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.3316 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174157.3340 tq6keifnfssp3061cbd3kkouh4 Query : select 'normal' from dummy
20240909@174157.3355 tq6keifnfssp3061cbd3kkouh4 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66df20775966df25553d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',667,100810,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@174157.3689 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.3693 tq6keifnfssp3061cbd3kkouh4 Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20240909@174157.3715 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.945.00.01'
20240909@174157.3729 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.3764 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174157.3792 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.3808 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174157.3818 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174157.3834 tq6keifnfssp3061cbd3kkouh4 Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2200799100a'
20240909@174157.3846 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.3871 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174157.3883 tq6keifnfssp3061cbd3kkouh4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df26965466df25555d','aut66df20775966df25553d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174157.3888 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.3928 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174157.3956 tq6keifnfssp3061cbd3kkouh4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df26965466df25555d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',52.000 ,'aut66df20775966df25553d' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@174157.4403 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.4446 tq6keifnfssp3061cbd3kkouh4 Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20240909@174157.4594 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.945.00.01'
20240909@174157.4609 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.4635 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174157.4959 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.4977 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174157.4987 tq6keifnfssp3061cbd3kkouh4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174157.4999 tq6keifnfssp3061cbd3kkouh4 Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2200799100a'
20240909@174157.5013 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.5028 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174157.5040 tq6keifnfssp3061cbd3kkouh4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df24119066df25557a','aut66df20775966df25553d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174157.5044 tq6keifnfssp3061cbd3kkouh4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.5059 tq6keifnfssp3061cbd3kkouh4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174157.5111 tq6keifnfssp3061cbd3kkouh4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df24119066df25557a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut66df20775966df25553d' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240909@174157.5384 tq6keifnfssp3061cbd3kkouh4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66df20775966df25553d','2405827','wait',39,'adm09112754980.682000002')
20240909@174157.5472 tq6keifnfssp3061cbd3kkouh4 Query : use flama_phc
20240909@174157.5475 tq6keifnfssp3061cbd3kkouh4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240909@174157.5545 tq6keifnfssp3061cbd3kkouh4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1907';
20240909@174157.5857 tq6keifnfssp3061cbd3kkouh4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1907';
20240909@174157.5929 tq6keifnfssp3061cbd3kkouh4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1907';
20240909@174157.5958 tq6keifnfssp3061cbd3kkouh4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1907';
20240909@174157.6504 i8te8ujhdjqrlpn162c3p9tp45 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240909@174157.6514 i8te8ujhdjqrlpn162c3p9tp45 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240909@174157.6569 i8te8ujhdjqrlpn162c3p9tp45 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1908';
20240909@174157.6625 i8te8ujhdjqrlpn162c3p9tp45 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1908';
20240909@174157.6679 i8te8ujhdjqrlpn162c3p9tp45 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1908';
20240909@174157.6705 i8te8ujhdjqrlpn162c3p9tp45 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1908';
20240909@174157.6755 i8te8ujhdjqrlpn162c3p9tp45 Query : use flama_phc
20240909@174157.6758 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240909@174157.6824 i8te8ujhdjqrlpn162c3p9tp45 Query : use flama_phc
20240909@174157.6827 i8te8ujhdjqrlpn162c3p9tp45 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240909@174157.6880 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.711.00.01'
20240909@174157.7058 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405828 and bi.ref ='324.711.00.01' and bi.lordem =1
20240909@174157.7419 i8te8ujhdjqrlpn162c3p9tp45 Query : use flama_phc
20240909@174157.7422 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240909@174157.7456 i8te8ujhdjqrlpn162c3p9tp45 Query : use flama_phc
20240909@174157.7459 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 1 valor from td where td.ndoc = 39
20240909@174157.7488 i8te8ujhdjqrlpn162c3p9tp45 Query : use flama_phc
20240909@174157.7491 i8te8ujhdjqrlpn162c3p9tp45 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')
20240909@174157.7519 i8te8ujhdjqrlpn162c3p9tp45 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
20240909@174157.7553 i8te8ujhdjqrlpn162c3p9tp45 Query : use flama_phc
20240909@174157.7556 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240909@174157.7587 i8te8ujhdjqrlpn162c3p9tp45 Query : use flama_phc
20240909@174157.7590 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240909@174157.7619 i8te8ujhdjqrlpn162c3p9tp45 Query : use flama_phc
20240909@174157.7621 i8te8ujhdjqrlpn162c3p9tp45 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240909@174157.7667 i8te8ujhdjqrlpn162c3p9tp45 Query : use flama_phc
20240909@174157.7670 i8te8ujhdjqrlpn162c3p9tp45 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240909@174157.7727 i8te8ujhdjqrlpn162c3p9tp45 Query : use flama_phc
20240909@174157.7730 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from td where ndoc = 39
20240909@174157.7744 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240909@174157.7759 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.7776 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174157.7796 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.7825 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174157.7856 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.7869 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174157.7882 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174157.7949 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174157.7962 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.7976 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174157.7991 i8te8ujhdjqrlpn162c3p9tp45 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66df27653166df2555c0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240909@174157.8226 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.9284 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174157.9320 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240909@174157.9334 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240909@174157.9345 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240909@174157.9358 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240909@174157.9369 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240909@174157.9382 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240909@174157.9410 i8te8ujhdjqrlpn162c3p9tp45 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66df27653166df2555c0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240909@174157.9667 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 fno valor from wsftdata order by fno desc
20240909@174157.9700 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174157.9718 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174157.9741 i8te8ujhdjqrlpn162c3p9tp45 Query : select 'normal' from dummy
20240909@174157.9757 i8te8ujhdjqrlpn162c3p9tp45 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66df27653166df2555c0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',668,100810,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@174158.5100 i8te8ujhdjqrlpn162c3p9tp45 Query : use flama_phc
20240909@174158.5400 i8te8ujhdjqrlpn162c3p9tp45 Query : select st.usalote valor from st where st.ref = '324.711.00.01'
20240909@174158.7800 i8te8ujhdjqrlpn162c3p9tp45 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.711.00.01'
20240909@174158.2430 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.2590 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174158.3530 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.3700 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174158.3790 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174158.3910 i8te8ujhdjqrlpn162c3p9tp45 Query : select sestamp valor from se where ref ='324.711.00.01' and lote = 'r2301222100a'
20240909@174158.4060 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.4200 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174158.4320 i8te8ujhdjqrlpn162c3p9tp45 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df21749466df255609','aut66df27653166df2555c0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174158.4360 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.4510 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174158.4780 i8te8ujhdjqrlpn162c3p9tp45 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df21749466df255609',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',100.000 ,'aut66df27653166df2555c0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@174158.7590 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.7750 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174158.7990 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.8130 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174158.8210 i8te8ujhdjqrlpn162c3p9tp45 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174158.8330 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.8470 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174158.8590 i8te8ujhdjqrlpn162c3p9tp45 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df25056566df255614','aut66df27653166df2555c0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174158.8630 i8te8ujhdjqrlpn162c3p9tp45 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.8760 i8te8ujhdjqrlpn162c3p9tp45 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174158.9160 i8te8ujhdjqrlpn162c3p9tp45 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66df25056566df255614',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66df27653166df2555c0' ,0,0 ,2,23.00,20000,?,?,?)
20240909@174158.1239 i8te8ujhdjqrlpn162c3p9tp45 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66df27653166df2555c0','2405828','wait',39,'adm09112754980.682000002')
20240909@174158.1315 i8te8ujhdjqrlpn162c3p9tp45 Query : use flama_phc
20240909@174158.1317 i8te8ujhdjqrlpn162c3p9tp45 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240909@174158.1348 i8te8ujhdjqrlpn162c3p9tp45 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1908';
20240909@174158.1381 i8te8ujhdjqrlpn162c3p9tp45 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1908';
20240909@174158.1419 i8te8ujhdjqrlpn162c3p9tp45 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1908';
20240909@174158.1442 i8te8ujhdjqrlpn162c3p9tp45 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1908';
20240909@174158.2149 0gsfighi114hprk49bqdb2teov Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240909@174158.2272 0gsfighi114hprk49bqdb2teov Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240909@174158.2376 0gsfighi114hprk49bqdb2teov Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1909';
20240909@174158.2445 0gsfighi114hprk49bqdb2teov Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1909';
20240909@174158.2499 0gsfighi114hprk49bqdb2teov Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1909';
20240909@174158.2521 0gsfighi114hprk49bqdb2teov Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1909';
20240909@174158.2575 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.2580 0gsfighi114hprk49bqdb2teov Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240909@174158.2648 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.2651 0gsfighi114hprk49bqdb2teov Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240909@174158.2694 0gsfighi114hprk49bqdb2teov Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4988.00.1'
20240909@174158.2877 0gsfighi114hprk49bqdb2teov Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405829 and bi.ref ='324.4988.00.1' and bi.lordem =1
20240909@174158.3263 0gsfighi114hprk49bqdb2teov Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4988.00.1'
20240909@174158.3282 0gsfighi114hprk49bqdb2teov Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405829 and bi.ref ='324.4988.00.1' and bi.lordem =1
20240909@174158.3301 0gsfighi114hprk49bqdb2teov Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4988.00.1'
20240909@174158.3321 0gsfighi114hprk49bqdb2teov Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405829 and bi.ref ='324.4988.00.1' and bi.lordem =1
20240909@174158.3338 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.3341 0gsfighi114hprk49bqdb2teov Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240909@174158.3377 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.3379 0gsfighi114hprk49bqdb2teov Query : select top 1 1 valor from td where td.ndoc = 39
20240909@174158.3411 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.3414 0gsfighi114hprk49bqdb2teov 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')
20240909@174158.3443 0gsfighi114hprk49bqdb2teov 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
20240909@174158.3478 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.3481 0gsfighi114hprk49bqdb2teov Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240909@174158.3515 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.3517 0gsfighi114hprk49bqdb2teov Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240909@174158.3548 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.3550 0gsfighi114hprk49bqdb2teov Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240909@174158.3595 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.3598 0gsfighi114hprk49bqdb2teov Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240909@174158.3653 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.3655 0gsfighi114hprk49bqdb2teov Query : select 1 valor from td where ndoc = 39
20240909@174158.3667 0gsfighi114hprk49bqdb2teov Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240909@174158.3680 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.3696 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174158.3714 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.3727 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174158.3763 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.3777 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174158.3789 0gsfighi114hprk49bqdb2teov Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174158.3860 0gsfighi114hprk49bqdb2teov Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174158.3872 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.3886 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174158.3905 0gsfighi114hprk49bqdb2teov Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66df24365566df25565c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240909@174158.4086 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.4100 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174158.4142 0gsfighi114hprk49bqdb2teov Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240909@174158.4153 0gsfighi114hprk49bqdb2teov Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240909@174158.4165 0gsfighi114hprk49bqdb2teov Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240909@174158.4176 0gsfighi114hprk49bqdb2teov Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240909@174158.4199 0gsfighi114hprk49bqdb2teov Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240909@174158.4210 0gsfighi114hprk49bqdb2teov Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240909@174158.4221 0gsfighi114hprk49bqdb2teov Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66df24365566df25565c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240909@174158.4485 0gsfighi114hprk49bqdb2teov Query : select top 1 fno valor from wsftdata order by fno desc
20240909@174158.4506 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.4523 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174158.4561 0gsfighi114hprk49bqdb2teov Query : select 'normal' from dummy
20240909@174158.4577 0gsfighi114hprk49bqdb2teov Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66df24365566df25565c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',669,100810,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@174158.4884 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.4888 0gsfighi114hprk49bqdb2teov Query : select st.usalote valor from st where st.ref = '324.4988.00.1'
20240909@174158.4910 0gsfighi114hprk49bqdb2teov 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.4988.00.1'
20240909@174158.5074 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.5093 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174158.5121 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.5136 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174158.5145 0gsfighi114hprk49bqdb2teov Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174158.5158 0gsfighi114hprk49bqdb2teov Query : select sestamp valor from se where ref ='324.4988.00.1' and lote = 'r2100754100a'
20240909@174158.5182 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.5197 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174158.5209 0gsfighi114hprk49bqdb2teov Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df20760066df25567e','aut66df24365566df25565c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174158.5213 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.5227 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174158.5256 0gsfighi114hprk49bqdb2teov Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df20760066df25567e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66df24365566df25565c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@174158.5542 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.5545 0gsfighi114hprk49bqdb2teov Query : select st.usalote valor from st where st.ref = '324.4988.00.1'
20240909@174158.5565 0gsfighi114hprk49bqdb2teov 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.4988.00.1'
20240909@174158.5580 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.5596 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174158.5622 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.5642 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174158.5650 0gsfighi114hprk49bqdb2teov Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174158.5662 0gsfighi114hprk49bqdb2teov Query : select sestamp valor from se where ref ='324.4988.00.1' and lote = 'r2100754100a'
20240909@174158.5676 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.5690 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174158.5702 0gsfighi114hprk49bqdb2teov Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df22278466df25568a','aut66df24365566df25565c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174158.5706 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.5721 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174158.5750 0gsfighi114hprk49bqdb2teov Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df22278466df25568a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66df24365566df25565c' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240909@174158.6021 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.6024 0gsfighi114hprk49bqdb2teov Query : select st.usalote valor from st where st.ref = '324.4988.00.1'
20240909@174158.6044 0gsfighi114hprk49bqdb2teov 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.4988.00.1'
20240909@174158.6059 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.6074 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174158.6100 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.6125 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174158.6134 0gsfighi114hprk49bqdb2teov Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174158.6146 0gsfighi114hprk49bqdb2teov Query : select sestamp valor from se where ref ='324.4988.00.1' and lote = 'r2100754100a'
20240909@174158.6159 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.6173 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174158.6185 0gsfighi114hprk49bqdb2teov Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df21123966df255696','aut66df24365566df25565c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174158.6189 0gsfighi114hprk49bqdb2teov Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.6203 0gsfighi114hprk49bqdb2teov Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174158.6231 0gsfighi114hprk49bqdb2teov Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df21123966df255696',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',64.000 ,'aut66df24365566df25565c' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240909@174158.6483 0gsfighi114hprk49bqdb2teov Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66df24365566df25565c','2405829','wait',39,'adm09112754980.682000002')
20240909@174158.6557 0gsfighi114hprk49bqdb2teov Query : use flama_phc
20240909@174158.6560 0gsfighi114hprk49bqdb2teov Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240909@174158.6592 0gsfighi114hprk49bqdb2teov Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1909';
20240909@174158.6623 0gsfighi114hprk49bqdb2teov Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1909';
20240909@174158.6667 0gsfighi114hprk49bqdb2teov Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1909';
20240909@174158.6691 0gsfighi114hprk49bqdb2teov Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1909';
20240909@174158.7340 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240909@174158.7359 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240909@174158.7425 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1910';
20240909@174158.7480 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1910';
20240909@174158.7534 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1910';
20240909@174158.7558 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1910';
20240909@174158.7615 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174158.7618 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240909@174158.7705 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174158.7709 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240909@174158.7754 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240909@174158.7942 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405830 and bi.ref ='324.988.00.01' and bi.lordem =1
20240909@174158.8288 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240909@174158.8308 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405830 and bi.ref ='324.988.00.01' and bi.lordem =1
20240909@174158.8330 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240909@174158.8349 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405830 and bi.ref ='324.988.00.01' and bi.lordem =1
20240909@174158.8367 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174158.8370 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240909@174158.8405 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174158.8408 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 1 valor from td where td.ndoc = 39
20240909@174158.8440 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174158.8443 rm2e8gd1oqdkuiqpr3jfn7m6f6 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')
20240909@174158.8482 rm2e8gd1oqdkuiqpr3jfn7m6f6 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
20240909@174158.8521 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174158.8523 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240909@174158.8555 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174158.8558 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240909@174158.8600 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174158.8603 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240909@174158.8654 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174158.8656 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240909@174158.8898 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174158.8901 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from td where ndoc = 39
20240909@174158.8914 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240909@174158.8951 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.8968 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174158.9026 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.9054 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174158.9084 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.9099 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174158.9112 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174158.9187 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174158.9200 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.9215 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174158.9230 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66df22533466df2556de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240909@174158.9429 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174158.9461 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174158.9494 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240909@174158.9506 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240909@174158.9517 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240909@174158.9529 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240909@174158.9541 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240909@174158.9553 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240909@174158.9564 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66df22533466df2556de',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240909@174159.5400 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 fno valor from wsftdata order by fno desc
20240909@174159.7500 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.9300 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174159.1160 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 'normal' from dummy
20240909@174159.1450 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66df22533466df2556de',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',670,100810,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@174159.4500 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174159.4530 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20240909@174159.4750 rm2e8gd1oqdkuiqpr3jfn7m6f6 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.988.00.01'
20240909@174159.6360 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.6520 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174159.6780 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.6940 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174159.7020 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174159.7140 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2400410200a'
20240909@174159.7270 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.7420 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174159.7540 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df23704366df255711','aut66df22533466df2556de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174159.7580 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.7730 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174159.8120 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df23704366df255711',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut66df22533466df2556de' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@174159.1100 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174159.1103 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20240909@174159.1122 rm2e8gd1oqdkuiqpr3jfn7m6f6 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.988.00.01'
20240909@174159.1138 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.1153 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174159.1189 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.1203 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174159.1211 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174159.1222 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2400410200a'
20240909@174159.1235 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.1249 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174159.1260 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df27068366df25571e','aut66df22533466df2556de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174159.1265 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.1288 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174159.1320 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df27068366df25571e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut66df22533466df2556de' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240909@174159.1591 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174159.1594 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20240909@174159.1612 rm2e8gd1oqdkuiqpr3jfn7m6f6 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.988.00.01'
20240909@174159.1636 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.1651 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174159.1683 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.1853 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174159.2554 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174159.3074 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2400410200a'
20240909@174159.3086 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.3107 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174159.3117 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df25101566df25574b','aut66df22533466df2556de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174159.3122 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.3138 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174159.3177 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df25101566df25574b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut66df22533466df2556de' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240909@174159.3471 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66df22533466df2556de','2405830','wait',39,'adm09112754980.682000002')
20240909@174159.3595 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : use flama_phc
20240909@174159.3598 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240909@174159.3629 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1910';
20240909@174159.3657 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1910';
20240909@174159.3699 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1910';
20240909@174159.3720 rm2e8gd1oqdkuiqpr3jfn7m6f6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1910';
20240909@174159.4222 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240909@174159.4235 eb02ut0gn3mthtvas6eu1lhu4d Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240909@174159.4292 eb02ut0gn3mthtvas6eu1lhu4d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1911';
20240909@174159.4345 eb02ut0gn3mthtvas6eu1lhu4d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1911';
20240909@174159.4401 eb02ut0gn3mthtvas6eu1lhu4d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1911';
20240909@174159.4423 eb02ut0gn3mthtvas6eu1lhu4d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1911';
20240909@174159.4471 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.4475 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240909@174159.4541 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.4544 eb02ut0gn3mthtvas6eu1lhu4d Query : select no, estab,szadrsdesc from szadrs where u_coddest=5546
20240909@174159.4628 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4930.00.1'
20240909@174159.4809 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405831 and bi.ref ='324.4930.00.1' and bi.lordem =1
20240909@174159.5210 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240909@174159.5229 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405831 and bi.ref ='304.4320.00.1' and bi.lordem =2
20240909@174159.5578 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240909@174159.5599 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405831 and bi.ref ='324.5343.00.1' and bi.lordem =3
20240909@174159.5936 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.939.00.01'
20240909@174159.6094 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405831 and bi.ref ='324.939.00.01' and bi.lordem =4
20240909@174159.6498 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.6501 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240909@174159.6537 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.6540 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 1 valor from td where td.ndoc = 39
20240909@174159.6571 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.6574 eb02ut0gn3mthtvas6eu1lhu4d 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')
20240909@174159.6603 eb02ut0gn3mthtvas6eu1lhu4d 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
20240909@174159.6637 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.6640 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 ~inactivo valor from cl where no = '199506' and estab = 0 order by inactivo desc
20240909@174159.6794 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.6797 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240909@174159.6826 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.6829 eb02ut0gn3mthtvas6eu1lhu4d Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240909@174159.6875 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.6878 eb02ut0gn3mthtvas6eu1lhu4d Query : select szadrsstamp valor from szadrs where szadrsdesc='199506 - itmp alimentar, s.a.'
20240909@174159.6925 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.6928 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from td where ndoc = 39
20240909@174159.6948 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240909@174159.6962 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.6979 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174159.6998 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.7012 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174159.7041 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.7056 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174159.7069 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174159.7352 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174159.7366 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.7383 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174159.7400 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66df24660366df2557ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240909@174159.7580 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.7596 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174159.7632 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240909@174159.7647 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240909@174159.7659 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240909@174159.7670 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240909@174159.7682 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240909@174159.7693 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240909@174159.7704 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66df24660366df2557ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240909@174159.7986 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 fno valor from wsftdata order by fno desc
20240909@174159.8006 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.8022 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174159.8045 eb02ut0gn3mthtvas6eu1lhu4d Query : select 'normal' from dummy
20240909@174159.8060 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66df24660366df2557ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',671,199506,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@174159.8390 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.8393 eb02ut0gn3mthtvas6eu1lhu4d Query : select st.usalote valor from st where st.ref = '324.4930.00.1'
20240909@174159.8415 eb02ut0gn3mthtvas6eu1lhu4d 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.4930.00.1'
20240909@174159.8565 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.8580 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174159.8605 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.8619 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174159.8641 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174159.8654 eb02ut0gn3mthtvas6eu1lhu4d Query : select sestamp valor from se where ref ='324.4930.00.1' and lote = 'r2400066200a'
20240909@174159.8914 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.8940 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174159.8952 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df29656666df2557d9','aut66df24660366df2557ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174159.8956 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.8970 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174159.8997 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df29656666df2557d9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66df24660366df2557ac' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@174159.9279 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.9282 eb02ut0gn3mthtvas6eu1lhu4d Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240909@174159.9301 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240909@174159.9314 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.9331 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174159.9368 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.9382 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174159.9390 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174159.9401 eb02ut0gn3mthtvas6eu1lhu4d Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240180'
20240909@174159.9413 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.9428 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174159.9439 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df27525566df2557e5','aut66df24660366df2557ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174159.9443 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.9458 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174159.9486 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df27525566df2557e5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66df24660366df2557ac' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240909@174159.9756 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174159.9759 eb02ut0gn3mthtvas6eu1lhu4d Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240909@174159.9777 eb02ut0gn3mthtvas6eu1lhu4d 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.5343.00.1'
20240909@174159.9790 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.9805 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174159.9841 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.9856 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174159.9865 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174159.9877 eb02ut0gn3mthtvas6eu1lhu4d Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240909@174159.9889 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.9903 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174159.9914 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df22457566df2557f1','aut66df24660366df2557ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174159.9918 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174159.9932 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174159.9959 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df22457566df2557f1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut66df24660366df2557ac' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240909@174200.2190 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.2340 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174200.2580 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.2720 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174200.2810 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174200.3040 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.3180 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174200.3300 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df21686166df255807','aut66df24660366df2557ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174200.3340 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.3480 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174200.3750 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66df21686166df255807',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66df24660366df2557ac' ,0,0 ,2,23.00,40000,?,?,?)
20240909@174200.6210 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174200.6240 eb02ut0gn3mthtvas6eu1lhu4d Query : select st.usalote valor from st where st.ref = '324.939.00.01'
20240909@174200.6430 eb02ut0gn3mthtvas6eu1lhu4d 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.939.00.01'
20240909@174200.8060 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.8210 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174200.8470 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.8610 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174200.8690 eb02ut0gn3mthtvas6eu1lhu4d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174200.8820 eb02ut0gn3mthtvas6eu1lhu4d Query : select sestamp valor from se where ref ='324.939.00.01' and lote = 'r2301371200a'
20240909@174200.9020 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.9170 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174200.9290 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df26213066df255816','aut66df24660366df2557ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174200.9330 eb02ut0gn3mthtvas6eu1lhu4d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.9480 eb02ut0gn3mthtvas6eu1lhu4d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174200.9770 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df26213066df255816',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66df24660366df2557ac' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240909@174200.1248 eb02ut0gn3mthtvas6eu1lhu4d Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66df24660366df2557ac','2405831','wait',39,'adm09112754980.682000002')
20240909@174200.1345 eb02ut0gn3mthtvas6eu1lhu4d Query : use flama_phc
20240909@174200.1348 eb02ut0gn3mthtvas6eu1lhu4d Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240909@174200.1380 eb02ut0gn3mthtvas6eu1lhu4d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1911';
20240909@174200.1409 eb02ut0gn3mthtvas6eu1lhu4d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1911';
20240909@174200.1451 eb02ut0gn3mthtvas6eu1lhu4d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1911';
20240909@174200.1475 eb02ut0gn3mthtvas6eu1lhu4d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1911';
20240909@174200.1994 t8oihk4tpft96a71mvrg6lso8e Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240909@174200.2005 t8oihk4tpft96a71mvrg6lso8e Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240909@174200.2059 t8oihk4tpft96a71mvrg6lso8e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1912';
20240909@174200.2268 t8oihk4tpft96a71mvrg6lso8e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1912';
20240909@174200.2369 t8oihk4tpft96a71mvrg6lso8e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1912';
20240909@174200.2395 t8oihk4tpft96a71mvrg6lso8e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1912';
20240909@174200.2457 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.2461 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240909@174200.2527 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.2530 t8oihk4tpft96a71mvrg6lso8e Query : select no, estab,szadrsdesc from szadrs where u_coddest=2014
20240909@174200.2631 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4743.00.1'
20240909@174200.2966 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405834 and bi.ref ='324.4743.00.1' and bi.lordem =1
20240909@174200.3327 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2031.00.1'
20240909@174200.3491 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405834 and bi.ref ='324.2031.00.1' and bi.lordem =2
20240909@174200.3823 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.3829 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240909@174200.3863 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.3866 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 1 valor from td where td.ndoc = 39
20240909@174200.3899 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.3902 t8oihk4tpft96a71mvrg6lso8e 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')
20240909@174200.3931 t8oihk4tpft96a71mvrg6lso8e 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
20240909@174200.3971 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.3973 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240909@174200.4106 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.4108 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240909@174200.4137 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.4140 t8oihk4tpft96a71mvrg6lso8e Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240909@174200.4185 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.4188 t8oihk4tpft96a71mvrg6lso8e Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - guarda'
20240909@174200.4241 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.4244 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from td where ndoc = 39
20240909@174200.4256 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240909@174200.4269 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.4285 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174200.4303 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.4317 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174200.4344 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.4358 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174200.4370 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174200.4450 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174200.4463 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.4477 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174200.4491 t8oihk4tpft96a71mvrg6lso8e Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66df27316666df25586a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240909@174200.4671 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.4686 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174200.4717 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240909@174200.4728 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240909@174200.4740 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240909@174200.4757 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240909@174200.4769 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240909@174200.4800 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240909@174200.4830 t8oihk4tpft96a71mvrg6lso8e Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66df27316666df25586a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240909@174200.5224 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 fno valor from wsftdata order by fno desc
20240909@174200.6178 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.6199 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174200.6221 t8oihk4tpft96a71mvrg6lso8e Query : select 'normal' from dummy
20240909@174200.6236 t8oihk4tpft96a71mvrg6lso8e Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66df27316666df25586a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',672,101621,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@174200.6546 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.6549 t8oihk4tpft96a71mvrg6lso8e Query : select st.usalote valor from st where st.ref = '324.4743.00.1'
20240909@174200.6570 t8oihk4tpft96a71mvrg6lso8e 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.4743.00.1'
20240909@174200.6719 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.6734 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174200.6758 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.6772 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174200.6780 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174200.6792 t8oihk4tpft96a71mvrg6lso8e Query : select sestamp valor from se where ref ='324.4743.00.1' and lote = 'r2200085100a'
20240909@174200.6814 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.6828 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174200.6839 t8oihk4tpft96a71mvrg6lso8e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df26245566df2558a6','aut66df27316666df25586a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174200.6844 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.6858 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174200.6883 t8oihk4tpft96a71mvrg6lso8e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df26245566df2558a6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66df27316666df25586a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@174200.7160 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.7163 t8oihk4tpft96a71mvrg6lso8e Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20240909@174200.7185 t8oihk4tpft96a71mvrg6lso8e 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.2031.00.1'
20240909@174200.7333 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.7348 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174200.7372 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.7385 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174200.7394 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174200.7405 t8oihk4tpft96a71mvrg6lso8e Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20240909@174200.7418 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.7432 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174200.7443 t8oihk4tpft96a71mvrg6lso8e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df29616366df2558b5','aut66df27316666df25586a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174200.7447 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.7461 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174200.7487 t8oihk4tpft96a71mvrg6lso8e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df29616366df2558b5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66df27316666df25586a' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240909@174200.7763 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.7780 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174200.7808 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.7822 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174200.7831 t8oihk4tpft96a71mvrg6lso8e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174200.7843 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.7858 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174200.7870 t8oihk4tpft96a71mvrg6lso8e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df27583766df2558bf','aut66df27316666df25586a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174200.7876 t8oihk4tpft96a71mvrg6lso8e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174200.7891 t8oihk4tpft96a71mvrg6lso8e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174200.7919 t8oihk4tpft96a71mvrg6lso8e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66df27583766df2558bf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66df27316666df25586a' ,0,0 ,2,23.00,30000,?,?,?)
20240909@174200.8193 t8oihk4tpft96a71mvrg6lso8e Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66df27316666df25586a','2405834','wait',39,'adm09112754980.682000002')
20240909@174200.8275 t8oihk4tpft96a71mvrg6lso8e Query : use flama_phc
20240909@174200.8279 t8oihk4tpft96a71mvrg6lso8e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240909@174200.8312 t8oihk4tpft96a71mvrg6lso8e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1912';
20240909@174200.8345 t8oihk4tpft96a71mvrg6lso8e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1912';
20240909@174200.8385 t8oihk4tpft96a71mvrg6lso8e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1912';
20240909@174200.8411 t8oihk4tpft96a71mvrg6lso8e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1912';
20240909@174200.9042 1jflm0tr78jj4mcuroqapa33ro Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240909@174200.9053 1jflm0tr78jj4mcuroqapa33ro Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240909@174200.9106 1jflm0tr78jj4mcuroqapa33ro Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1913';
20240909@174200.9163 1jflm0tr78jj4mcuroqapa33ro Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1913';
20240909@174200.9231 1jflm0tr78jj4mcuroqapa33ro Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1913';
20240909@174200.9256 1jflm0tr78jj4mcuroqapa33ro Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1913';
20240909@174200.9305 1jflm0tr78jj4mcuroqapa33ro Query : use flama_phc
20240909@174200.9309 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240909@174200.9379 1jflm0tr78jj4mcuroqapa33ro Query : use flama_phc
20240909@174200.9382 1jflm0tr78jj4mcuroqapa33ro Query : select no, estab,szadrsdesc from szadrs where u_coddest=233
20240909@174200.9473 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2031.00.1'
20240909@174200.9494 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405835 and bi.ref ='324.2031.00.1' and bi.lordem =1
20240909@174200.9829 1jflm0tr78jj4mcuroqapa33ro Query : use flama_phc
20240909@174200.9832 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240909@174200.9883 1jflm0tr78jj4mcuroqapa33ro Query : use flama_phc
20240909@174200.9886 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 1 valor from td where td.ndoc = 39
20240909@174200.9917 1jflm0tr78jj4mcuroqapa33ro Query : use flama_phc
20240909@174200.9920 1jflm0tr78jj4mcuroqapa33ro 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')
20240909@174200.9948 1jflm0tr78jj4mcuroqapa33ro 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
20240909@174200.9987 1jflm0tr78jj4mcuroqapa33ro Query : use flama_phc
20240909@174200.9991 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240909@174201.2400 1jflm0tr78jj4mcuroqapa33ro Query : use flama_phc
20240909@174201.2600 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240909@174201.5800 1jflm0tr78jj4mcuroqapa33ro Query : use flama_phc
20240909@174201.6100 1jflm0tr78jj4mcuroqapa33ro Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240909@174201.1180 1jflm0tr78jj4mcuroqapa33ro Query : use flama_phc
20240909@174201.1210 1jflm0tr78jj4mcuroqapa33ro Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - tudo para o seu lar'
20240909@174201.1690 1jflm0tr78jj4mcuroqapa33ro Query : use flama_phc
20240909@174201.1710 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from td where ndoc = 39
20240909@174201.1830 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240909@174201.1970 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174201.2210 1jflm0tr78jj4mcuroqapa33ro Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174201.2400 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174201.2590 1jflm0tr78jj4mcuroqapa33ro Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174201.2880 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174201.3030 1jflm0tr78jj4mcuroqapa33ro Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174201.3300 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174201.3980 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@174201.4110 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174201.4250 1jflm0tr78jj4mcuroqapa33ro Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@174201.4400 1jflm0tr78jj4mcuroqapa33ro Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66df28537766df255908' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240909@174201.6250 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174201.6510 1jflm0tr78jj4mcuroqapa33ro Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@174201.6840 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240909@174201.6970 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240909@174201.7090 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240909@174201.7210 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240909@174201.7330 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240909@174201.7450 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240909@174201.7690 1jflm0tr78jj4mcuroqapa33ro Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66df28537766df255908',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240909@174201.1026 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 fno valor from wsftdata order by fno desc
20240909@174201.1045 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174201.1061 1jflm0tr78jj4mcuroqapa33ro Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@174201.1082 1jflm0tr78jj4mcuroqapa33ro Query : select 'normal' from dummy
20240909@174201.1098 1jflm0tr78jj4mcuroqapa33ro Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66df28537766df255908',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',673,101621,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@174201.1408 1jflm0tr78jj4mcuroqapa33ro Query : use flama_phc
20240909@174201.1411 1jflm0tr78jj4mcuroqapa33ro Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20240909@174201.1432 1jflm0tr78jj4mcuroqapa33ro 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.2031.00.1'
20240909@174201.1447 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174201.1463 1jflm0tr78jj4mcuroqapa33ro Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174201.1487 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174201.1501 1jflm0tr78jj4mcuroqapa33ro Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174201.1510 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174201.1521 1jflm0tr78jj4mcuroqapa33ro Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20240909@174201.1534 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174201.1548 1jflm0tr78jj4mcuroqapa33ro Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174201.1560 1jflm0tr78jj4mcuroqapa33ro Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66df25265066df255925','aut66df28537766df255908' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@174201.1564 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174201.1577 1jflm0tr78jj4mcuroqapa33ro Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174201.1605 1jflm0tr78jj4mcuroqapa33ro Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66df25265066df255925',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66df28537766df255908' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@174201.1872 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174201.1887 1jflm0tr78jj4mcuroqapa33ro Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@174201.1929 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@174201.1944 1jflm0tr78jj4mcuroqapa33ro Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@174201.1952 1jflm0tr78jj4mcuroqapa33ro Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@174201.1963 1jflm0tr78jj4mcuroqapa33ro Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
