20241210@185009.8493 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185009.8510 5s98fvuk5jlvl0o7d3vr5jul5t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675882259167588d61ce','aut675886044867588d6194' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185009.8526 5s98fvuk5jlvl0o7d3vr5jul5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185009.8546 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185009.8583 5s98fvuk5jlvl0o7d3vr5jul5t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675882259167588d61ce',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut675886044867588d6194' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241210@185009.9301 5s98fvuk5jlvl0o7d3vr5jul5t Query : use flama_phc
20241210@185009.9330 5s98fvuk5jlvl0o7d3vr5jul5t Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20241210@185009.9356 5s98fvuk5jlvl0o7d3vr5jul5t Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20241210@185009.9505 5s98fvuk5jlvl0o7d3vr5jul5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185009.9526 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185009.9557 5s98fvuk5jlvl0o7d3vr5jul5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185009.9574 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185009.9590 5s98fvuk5jlvl0o7d3vr5jul5t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185009.9605 5s98fvuk5jlvl0o7d3vr5jul5t Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20241210@185009.9635 5s98fvuk5jlvl0o7d3vr5jul5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185009.9652 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185009.9665 5s98fvuk5jlvl0o7d3vr5jul5t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675883969567588d61eb','aut675886044867588d6194' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185009.9669 5s98fvuk5jlvl0o7d3vr5jul5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185009.9685 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185009.9715 5s98fvuk5jlvl0o7d3vr5jul5t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675883969567588d61eb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut675886044867588d6194' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241210@185009.9953 5s98fvuk5jlvl0o7d3vr5jul5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185009.9975 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185010.7000 5s98fvuk5jlvl0o7d3vr5jul5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.2400 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185010.4500 5s98fvuk5jlvl0o7d3vr5jul5t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185010.6000 5s98fvuk5jlvl0o7d3vr5jul5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.7600 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185010.9100 5s98fvuk5jlvl0o7d3vr5jul5t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675887286167588d6201','aut675886044867588d6194' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185010.9700 5s98fvuk5jlvl0o7d3vr5jul5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.1140 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185010.1500 5s98fvuk5jlvl0o7d3vr5jul5t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675887286167588d6201',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675886044867588d6194' ,0,0 ,2,23.00,30000,?,?,?)
20241210@185010.4190 5s98fvuk5jlvl0o7d3vr5jul5t Query : use flama_phc
20241210@185010.4230 5s98fvuk5jlvl0o7d3vr5jul5t Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20241210@185010.4610 5s98fvuk5jlvl0o7d3vr5jul5t 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.691.00.01'
20241210@185010.4860 5s98fvuk5jlvl0o7d3vr5jul5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.5070 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185010.5410 5s98fvuk5jlvl0o7d3vr5jul5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.5680 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185010.5790 5s98fvuk5jlvl0o7d3vr5jul5t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185010.5970 5s98fvuk5jlvl0o7d3vr5jul5t Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2400837300a'
20241210@185010.6150 5s98fvuk5jlvl0o7d3vr5jul5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.6360 5s98fvuk5jlvl0o7d3vr5jul5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185010.6540 5s98fvuk5jlvl0o7d3vr5jul5t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675882285767588d620f','aut675886044867588d6194' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185010.6790 5s98fvuk5jlvl0o7d3vr5jul5t Query : use flama_phc
20241210@185010.6830 5s98fvuk5jlvl0o7d3vr5jul5t Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20241210@185010.7370 5s98fvuk5jlvl0o7d3vr5jul5t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3870';
20241210@185010.7810 5s98fvuk5jlvl0o7d3vr5jul5t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3870';
20241210@185010.1353 pnk6f1v5kgernkob0riroo5b2f Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241210@185010.1366 pnk6f1v5kgernkob0riroo5b2f Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241210@185010.1437 pnk6f1v5kgernkob0riroo5b2f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3871';
20241210@185010.1503 pnk6f1v5kgernkob0riroo5b2f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3871';
20241210@185010.1580 pnk6f1v5kgernkob0riroo5b2f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3871';
20241210@185010.1614 pnk6f1v5kgernkob0riroo5b2f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3871';
20241210@185010.1672 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.1675 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241210@185010.1748 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.1751 pnk6f1v5kgernkob0riroo5b2f Query : select no, estab,szadrsdesc from szadrs where u_coddest=557
20241210@185010.1847 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2340.00.1'
20241210@185010.1988 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408458 and bi.ref ='324.2340.00.1' and bi.lordem =1
20241210@185010.2289 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2340.00.1'
20241210@185010.2313 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408458 and bi.ref ='324.2340.00.1' and bi.lordem =1
20241210@185010.2333 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2300.00.1'
20241210@185010.2355 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408458 and bi.ref ='324.2300.00.1' and bi.lordem =2
20241210@185010.2666 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2317.00.1'
20241210@185010.2695 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408458 and bi.ref ='324.2317.00.1' and bi.lordem =3
20241210@185010.3051 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2318.00.1'
20241210@185010.3183 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408458 and bi.ref ='324.2318.00.1' and bi.lordem =4
20241210@185010.3540 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2334.00.1'
20241210@185010.3667 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408458 and bi.ref ='324.2334.00.1' and bi.lordem =5
20241210@185010.4964 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241210@185010.4994 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408458 and bi.ref ='324.2335.00.1' and bi.lordem =6
20241210@185010.5311 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.5315 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241210@185010.5360 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.5364 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 1 valor from td where td.ndoc = 39
20241210@185010.5562 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.5566 pnk6f1v5kgernkob0riroo5b2f 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')
20241210@185010.5599 pnk6f1v5kgernkob0riroo5b2f 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
20241210@185010.5645 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.5649 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 ~inactivo valor from cl where no = '101732' and estab = 0 order by inactivo desc
20241210@185010.5755 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.5759 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241210@185010.5792 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.5796 pnk6f1v5kgernkob0riroo5b2f Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241210@185010.5849 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.5853 pnk6f1v5kgernkob0riroo5b2f Query : select szadrsstamp valor from szadrs where szadrsdesc='rosalar -r.s.&santos, distr. elect.,lda'
20241210@185010.5909 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.5912 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from td where ndoc = 39
20241210@185010.5940 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241210@185010.5958 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.5976 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241210@185010.5999 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.6015 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241210@185010.6054 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.6071 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241210@185010.6086 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241210@185010.6147 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241210@185010.6162 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.6180 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241210@185010.6200 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675884939367588d6294' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241210@185010.6397 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.6442 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241210@185010.6798 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241210@185010.6812 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241210@185010.6826 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241210@185010.6842 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241210@185010.6859 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241210@185010.6873 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241210@185010.6887 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675884939367588d6294',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241210@185010.7226 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 fno valor from wsftdata order by fno desc
20241210@185010.7449 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.7530 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241210@185010.7558 pnk6f1v5kgernkob0riroo5b2f Query : select 'normal' from dummy
20241210@185010.7593 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675884939367588d6294',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2366,101732,0,'2024-12-10',39,'euro',0,0,2024 ,?,?)
20241210@185010.7858 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.7861 pnk6f1v5kgernkob0riroo5b2f Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20241210@185010.7890 pnk6f1v5kgernkob0riroo5b2f 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.2340.00.1'
20241210@185010.8013 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.8033 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185010.8066 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.8100 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185010.8110 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185010.8125 pnk6f1v5kgernkob0riroo5b2f Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20241210@185010.8149 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.8167 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185010.8186 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675882626467588d62c6','aut675884939367588d6294' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185010.8190 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.8207 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185010.8239 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675882626467588d62c6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675884939367588d6294' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241210@185010.8482 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.8486 pnk6f1v5kgernkob0riroo5b2f Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20241210@185010.8509 pnk6f1v5kgernkob0riroo5b2f 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.2340.00.1'
20241210@185010.8525 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.8558 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185010.8590 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.8608 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185010.8618 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185010.8634 pnk6f1v5kgernkob0riroo5b2f Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20241210@185010.8649 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.8674 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185010.8692 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675882839967588d62d3','aut675884939367588d6294' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185010.8697 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.8729 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185010.8766 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675882839967588d62d3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut675884939367588d6294' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241210@185010.8994 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.8998 pnk6f1v5kgernkob0riroo5b2f Query : select st.usalote valor from st where st.ref = '324.2300.00.1'
20241210@185010.9021 pnk6f1v5kgernkob0riroo5b2f 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.2300.00.1'
20241210@185010.9044 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.9341 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185010.9375 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.9394 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185010.9407 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185010.9439 pnk6f1v5kgernkob0riroo5b2f Query : select sestamp valor from se where ref ='324.2300.00.1' and lote = 'r2400497200a'
20241210@185010.9461 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.9479 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185010.9493 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675884949467588d62e6','aut675884939367588d6294' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185010.9499 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.9517 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185010.9564 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675884949467588d62e6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut675884939367588d6294' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241210@185010.9819 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185010.9823 pnk6f1v5kgernkob0riroo5b2f Query : select st.usalote valor from st where st.ref = '324.2317.00.1'
20241210@185010.9849 pnk6f1v5kgernkob0riroo5b2f 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.2317.00.1'
20241210@185010.9875 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.9895 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185010.9931 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185010.9950 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185010.9961 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185010.9978 pnk6f1v5kgernkob0riroo5b2f Query : select sestamp valor from se where ref ='324.2317.00.1' and lote = 'r2400475100a'
20241210@185011.0000 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.1800 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185011.3300 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675888787267588d6300','aut675884939367588d6294' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185011.3900 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.5800 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185011.9500 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675888787267588d6300',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut675884939367588d6294' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241210@185011.3450 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.3730 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185011.4060 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.4410 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185011.4520 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185011.4670 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.4850 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185011.4990 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675888422167588d630b','aut675884939367588d6294' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185011.5040 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.5210 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185011.5570 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675888422167588d630b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675884939367588d6294' ,0,0 ,2,23.00,50000,?,?,?)
20241210@185011.7920 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185011.7960 pnk6f1v5kgernkob0riroo5b2f Query : select st.usalote valor from st where st.ref = '324.2318.00.1'
20241210@185011.8240 pnk6f1v5kgernkob0riroo5b2f 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.2318.00.1'
20241210@185011.9560 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.9760 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185011.1010 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.1044 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185011.1056 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185011.1071 pnk6f1v5kgernkob0riroo5b2f Query : select sestamp valor from se where ref ='324.2318.00.1' and lote = 'r2100669100a'
20241210@185011.1101 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.1120 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185011.1135 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675884905367588d631a','aut675884939367588d6294' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185011.1144 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.1163 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185011.1211 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675884905367588d631a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut675884939367588d6294' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241210@185011.1482 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.1505 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185011.1540 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.1560 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185011.1570 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185011.1586 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.1605 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185011.1620 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675888028567588d6326','aut675884939367588d6294' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185011.1626 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.1647 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185011.1697 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675888028567588d6326',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675884939367588d6294' ,0,0 ,2,23.00,80000,?,?,?)
20241210@185011.1929 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185011.1933 pnk6f1v5kgernkob0riroo5b2f Query : select st.usalote valor from st where st.ref = '324.2334.00.1'
20241210@185011.1961 pnk6f1v5kgernkob0riroo5b2f 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.2334.00.1'
20241210@185011.2194 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.2213 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185011.2242 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.2261 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185011.2270 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185011.2290 pnk6f1v5kgernkob0riroo5b2f Query : select sestamp valor from se where ref ='324.2334.00.1' and lote = '1'
20241210@185011.2324 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.2368 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185011.3394 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675882577367588d6338','aut675884939367588d6294' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185011.3637 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.4615 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185011.4655 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675882577367588d6338',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut675884939367588d6294' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241210@185011.4894 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185011.4899 pnk6f1v5kgernkob0riroo5b2f Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241210@185011.4929 pnk6f1v5kgernkob0riroo5b2f 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.2335.00.1'
20241210@185011.4946 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.4965 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185011.5009 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.5027 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185011.5039 pnk6f1v5kgernkob0riroo5b2f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185011.5053 pnk6f1v5kgernkob0riroo5b2f Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400467150a'
20241210@185011.5075 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.5098 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185011.5113 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675887721867588d637b','aut675884939367588d6294' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185011.5119 pnk6f1v5kgernkob0riroo5b2f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.5137 pnk6f1v5kgernkob0riroo5b2f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185011.5170 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675887721867588d637b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut675884939367588d6294' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20241210@185011.5654 pnk6f1v5kgernkob0riroo5b2f Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675884939367588d6294','2408458','wait',39,'adm09112754980.682000002')
20241210@185011.6222 pnk6f1v5kgernkob0riroo5b2f Query : use flama_phc
20241210@185011.6237 pnk6f1v5kgernkob0riroo5b2f Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241210@185011.6293 pnk6f1v5kgernkob0riroo5b2f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3871';
20241210@185011.6524 pnk6f1v5kgernkob0riroo5b2f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3871';
20241210@185011.6693 pnk6f1v5kgernkob0riroo5b2f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3871';
20241210@185011.6743 pnk6f1v5kgernkob0riroo5b2f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3871';
20241210@185011.7279 5icgdiqme3plncil1datm6nk8g Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241210@185011.7291 5icgdiqme3plncil1datm6nk8g Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241210@185011.7366 5icgdiqme3plncil1datm6nk8g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3872';
20241210@185011.7439 5icgdiqme3plncil1datm6nk8g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3872';
20241210@185011.7506 5icgdiqme3plncil1datm6nk8g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3872';
20241210@185011.7546 5icgdiqme3plncil1datm6nk8g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3872';
20241210@185011.7609 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185011.7613 5icgdiqme3plncil1datm6nk8g Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241210@185011.7685 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185011.7688 5icgdiqme3plncil1datm6nk8g Query : select no, estab,szadrsdesc from szadrs where u_coddest=2448
20241210@185011.7754 5icgdiqme3plncil1datm6nk8g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20241210@185011.7786 5icgdiqme3plncil1datm6nk8g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408459 and bi.ref ='324.4960.00.1' and bi.lordem =1
20241210@185011.8158 5icgdiqme3plncil1datm6nk8g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4962.00.1'
20241210@185011.8286 5icgdiqme3plncil1datm6nk8g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2084 and bo.obrano = 2408459 and bi.ref ='324.4962.00.1' and bi.lordem =2
20241210@185011.8640 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185011.8645 5icgdiqme3plncil1datm6nk8g Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241210@185011.8688 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185011.8691 5icgdiqme3plncil1datm6nk8g Query : select top 1 1 valor from td where td.ndoc = 39
20241210@185011.8727 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185011.8731 5icgdiqme3plncil1datm6nk8g 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')
20241210@185011.8766 5icgdiqme3plncil1datm6nk8g 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
20241210@185011.8807 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185011.8810 5icgdiqme3plncil1datm6nk8g Query : select top 1 ~inactivo valor from cl where no = '101889' and estab = 0 order by inactivo desc
20241210@185011.8857 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185011.8860 5icgdiqme3plncil1datm6nk8g Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241210@185011.8908 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185011.8912 5icgdiqme3plncil1datm6nk8g Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241210@185011.8956 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185011.8959 5icgdiqme3plncil1datm6nk8g Query : select szadrsstamp valor from szadrs where szadrsdesc='cooplecnorte,crl'
20241210@185011.9013 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185011.9018 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from td where ndoc = 39
20241210@185011.9035 5icgdiqme3plncil1datm6nk8g Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241210@185011.9054 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.9073 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241210@185011.9098 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.9116 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241210@185011.9151 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.9170 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241210@185011.9185 5icgdiqme3plncil1datm6nk8g Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241210@185011.9247 5icgdiqme3plncil1datm6nk8g Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241210@185011.9263 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.9298 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241210@185011.9318 5icgdiqme3plncil1datm6nk8g Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675880397367588d63e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241210@185011.9496 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.9522 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241210@185011.9563 5icgdiqme3plncil1datm6nk8g Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241210@185011.9591 5icgdiqme3plncil1datm6nk8g Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241210@185011.9606 5icgdiqme3plncil1datm6nk8g Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241210@185011.9620 5icgdiqme3plncil1datm6nk8g Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241210@185011.9637 5icgdiqme3plncil1datm6nk8g Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241210@185011.9651 5icgdiqme3plncil1datm6nk8g Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241210@185011.9666 5icgdiqme3plncil1datm6nk8g Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675880397367588d63e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241210@185011.9884 5icgdiqme3plncil1datm6nk8g Query : select top 1 fno valor from wsftdata order by fno desc
20241210@185011.9919 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185011.9940 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241210@185011.9966 5icgdiqme3plncil1datm6nk8g Query : select 'normal' from dummy
20241210@185011.9998 5icgdiqme3plncil1datm6nk8g Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675880397367588d63e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2367,101889,0,'2024-12-10',39,'euro',0,0,2024 ,?,?)
20241210@185012.2570 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185012.2620 5icgdiqme3plncil1datm6nk8g Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20241210@185012.2900 5icgdiqme3plncil1datm6nk8g 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.4960.00.1'
20241210@185012.1460 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.1481 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185012.1513 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.1547 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185012.1557 5icgdiqme3plncil1datm6nk8g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185012.1571 5icgdiqme3plncil1datm6nk8g Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20241210@185012.1598 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.1614 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185012.1627 5icgdiqme3plncil1datm6nk8g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675889100867588d6427','aut675880397367588d63e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185012.1633 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.1654 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185012.1690 5icgdiqme3plncil1datm6nk8g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675889100867588d6427',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut675880397367588d63e0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241210@185012.1978 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185012.1983 5icgdiqme3plncil1datm6nk8g Query : select st.usalote valor from st where st.ref = '324.4962.00.1'
20241210@185012.2024 5icgdiqme3plncil1datm6nk8g 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.4962.00.1'
20241210@185012.2267 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.2291 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185012.2329 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.2349 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185012.2362 5icgdiqme3plncil1datm6nk8g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185012.2378 5icgdiqme3plncil1datm6nk8g Query : select sestamp valor from se where ref ='324.4962.00.1' and lote = 'r2101092100a'
20241210@185012.2411 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.2433 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185012.2450 5icgdiqme3plncil1datm6nk8g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675885466967588d643a','aut675880397367588d63e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185012.2456 5icgdiqme3plncil1datm6nk8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.2482 5icgdiqme3plncil1datm6nk8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185012.2522 5icgdiqme3plncil1datm6nk8g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675885466967588d643a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut675880397367588d63e0' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241210@185012.2777 5icgdiqme3plncil1datm6nk8g Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675880397367588d63e0','2408459','wait',39,'adm09112754980.682000002')
20241210@185012.2864 5icgdiqme3plncil1datm6nk8g Query : use flama_phc
20241210@185012.2906 5icgdiqme3plncil1datm6nk8g Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241210@185012.2956 5icgdiqme3plncil1datm6nk8g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3872';
20241210@185012.3003 5icgdiqme3plncil1datm6nk8g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3872';
20241210@185012.3057 5icgdiqme3plncil1datm6nk8g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3872';
20241210@185012.3091 5icgdiqme3plncil1datm6nk8g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3872';
20241210@185012.3608 jpujorm9dbd30mvgrl0mf12jns Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241210@185012.3618 jpujorm9dbd30mvgrl0mf12jns Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241210@185012.3942 jpujorm9dbd30mvgrl0mf12jns Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3873';
20241210@185012.4020 jpujorm9dbd30mvgrl0mf12jns Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3873';
20241210@185012.4080 jpujorm9dbd30mvgrl0mf12jns Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3873';
20241210@185012.4111 jpujorm9dbd30mvgrl0mf12jns Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3873';
20241210@185012.4167 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.4171 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241210@185012.4236 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.4239 jpujorm9dbd30mvgrl0mf12jns Query : select no, estab,szadrsdesc from szadrs where u_coddest=5808
20241210@185012.4323 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241210@185012.4352 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241210@185012.4371 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.4374 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241210@185012.4408 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.4412 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 1 valor from td where td.ndoc = 39
20241210@185012.4443 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.4446 jpujorm9dbd30mvgrl0mf12jns 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')
20241210@185012.4474 jpujorm9dbd30mvgrl0mf12jns 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
20241210@185012.4506 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.4509 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241210@185012.4541 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.4544 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241210@185012.4574 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.4576 jpujorm9dbd30mvgrl0mf12jns Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241210@185012.4614 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.4617 jpujorm9dbd30mvgrl0mf12jns Query : select szadrsstamp valor from szadrs where szadrsdesc='jom-Évora'
20241210@185012.4669 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.4672 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from td where ndoc = 39
20241210@185012.4692 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241210@185012.4706 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.4724 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241210@185012.4743 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.4757 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241210@185012.4785 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.4799 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241210@185012.4811 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241210@185012.4866 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241210@185012.4879 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.4894 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241210@185012.4909 jpujorm9dbd30mvgrl0mf12jns Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675886437667588d6475' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241210@185012.5063 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.5078 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241210@185012.5115 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241210@185012.5128 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241210@185012.5140 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241210@185012.5151 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241210@185012.5162 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241210@185012.5174 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241210@185012.5187 jpujorm9dbd30mvgrl0mf12jns Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675886437667588d6475',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241210@185012.5387 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 fno valor from wsftdata order by fno desc
20241210@185012.5422 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.5437 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241210@185012.5461 jpujorm9dbd30mvgrl0mf12jns Query : select 'normal' from dummy
20241210@185012.5476 jpujorm9dbd30mvgrl0mf12jns Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675886437667588d6475',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2368,101621,0,'2024-12-10',39,'euro',0,0,2024 ,?,?)
20241210@185012.5710 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.5713 jpujorm9dbd30mvgrl0mf12jns Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241210@185012.5733 jpujorm9dbd30mvgrl0mf12jns 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.2335.00.1'
20241210@185012.5753 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.5769 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185012.5794 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.5808 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185012.5816 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185012.5828 jpujorm9dbd30mvgrl0mf12jns Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400467150a'
20241210@185012.5841 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.5855 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185012.5867 jpujorm9dbd30mvgrl0mf12jns Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675885832867588d648e','aut675886437667588d6475' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185012.5871 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.5888 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185012.5917 jpujorm9dbd30mvgrl0mf12jns Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut675885832867588d648e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut675886437667588d6475' ,0,0 ,2,23.00,10000,?,?,?,?)
20241210@185012.6346 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.6349 jpujorm9dbd30mvgrl0mf12jns Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241210@185012.6369 jpujorm9dbd30mvgrl0mf12jns 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.2335.00.1'
20241210@185012.6382 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.6399 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185012.6432 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.6447 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185012.6456 jpujorm9dbd30mvgrl0mf12jns Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241210@185012.6467 jpujorm9dbd30mvgrl0mf12jns Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400467150a'
20241210@185012.6480 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.6495 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241210@185012.6507 jpujorm9dbd30mvgrl0mf12jns Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675885569867588d649e','aut675886437667588d6475' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241210@185012.6511 jpujorm9dbd30mvgrl0mf12jns Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241210@185012.6525 jpujorm9dbd30mvgrl0mf12jns Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241210@185012.6626 jpujorm9dbd30mvgrl0mf12jns Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut675885569867588d649e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675886437667588d6475' ,0,0 ,2,23.00,20000,?,?,?,?)
20241210@185012.6848 jpujorm9dbd30mvgrl0mf12jns Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675886437667588d6475','2408440','wait',39,'adm09112754980.682000002')
20241210@185012.7207 jpujorm9dbd30mvgrl0mf12jns Query : use flama_phc
20241210@185012.7210 jpujorm9dbd30mvgrl0mf12jns Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241210@185012.7243 jpujorm9dbd30mvgrl0mf12jns Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3873';
20241210@185012.7287 jpujorm9dbd30mvgrl0mf12jns Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3873';
20241210@185012.7341 jpujorm9dbd30mvgrl0mf12jns Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3873';
20241210@185012.7369 jpujorm9dbd30mvgrl0mf12jns Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3873';
20241210@191908.6495 qbq93putl97qldabvmnskt4mm5 Query : use flama_phc
20241210@191908.6499 qbq93putl97qldabvmnskt4mm5 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241210@191908.6620 qbq93putl97qldabvmnskt4mm5 Query : use flama_phc
20241210@191908.6623 qbq93putl97qldabvmnskt4mm5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241210@193608.3274 mqndj1mvsebjqs0afb3fu7impe Query : use flama_phc
20241210@193608.3278 mqndj1mvsebjqs0afb3fu7impe Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241210@193608.3417 mqndj1mvsebjqs0afb3fu7impe Query : use flama_phc
20241210@193608.3420 mqndj1mvsebjqs0afb3fu7impe Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241210@201910.1321 4fifmu1truqb9n37s2191c2r0r Query : use flama_phc
20241210@201910.1325 4fifmu1truqb9n37s2191c2r0r Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241210@201910.1428 4fifmu1truqb9n37s2191c2r0r Query : use flama_phc
20241210@201910.1431 4fifmu1truqb9n37s2191c2r0r Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241210@203610.1702 ikqda2o0sv71dmklt3b6ufgj8i Query : use flama_phc
20241210@203610.1706 ikqda2o0sv71dmklt3b6ufgj8i Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241210@203610.1926 ikqda2o0sv71dmklt3b6ufgj8i Query : use flama_phc
20241210@203610.1929 ikqda2o0sv71dmklt3b6ufgj8i Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241210@211907.7460 b3n2s0991qspid4ovskgnt45lr Query : use flama_phc
20241210@211907.7491 b3n2s0991qspid4ovskgnt45lr Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241210@211907.7595 b3n2s0991qspid4ovskgnt45lr Query : use flama_phc
20241210@211907.7599 b3n2s0991qspid4ovskgnt45lr Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241210@213607.8218 4m9ien19b6snpr887t9rnkpose Query : use flama_phc
20241210@213607.8222 4m9ien19b6snpr887t9rnkpose Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241210@213607.8351 4m9ien19b6snpr887t9rnkpose Query : use flama_phc
20241210@213607.8354 4m9ien19b6snpr887t9rnkpose Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241210@221908.8929 go60l0h808boem08vd95v8dsqp Query : use flama_phc
20241210@221908.8933 go60l0h808boem08vd95v8dsqp Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241210@221908.9206 go60l0h808boem08vd95v8dsqp Query : use flama_phc
20241210@221908.9210 go60l0h808boem08vd95v8dsqp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241210@223608.6086 bdcscnhta12euo5f88lkd4qb8q Query : use flama_phc
20241210@223608.6090 bdcscnhta12euo5f88lkd4qb8q Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241210@223608.6179 bdcscnhta12euo5f88lkd4qb8q Query : use flama_phc
20241210@223608.6183 bdcscnhta12euo5f88lkd4qb8q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241210@231908.7213 kqkmuensola2q92e2f05o75rtl Query : use flama_phc
20241210@231908.7219 kqkmuensola2q92e2f05o75rtl Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241210@231908.7325 kqkmuensola2q92e2f05o75rtl Query : use flama_phc
20241210@231908.7328 kqkmuensola2q92e2f05o75rtl Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241210@233608.6654 4k3crjtaqh658ih2u14s46nbvr Query : use flama_phc
20241210@233608.6660 4k3crjtaqh658ih2u14s46nbvr Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241210@233608.6796 4k3crjtaqh658ih2u14s46nbvr Query : use flama_phc
20241210@233608.6800 4k3crjtaqh658ih2u14s46nbvr Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241211@071909.7828 fke47nkug98c73qr4q7akes9rd Query : use flama_phc
20241211@071909.7833 fke47nkug98c73qr4q7akes9rd Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241211@071909.7995 fke47nkug98c73qr4q7akes9rd Query : use flama_phc
20241211@071909.7998 fke47nkug98c73qr4q7akes9rd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241211@073626.7795 a9f28tb46nj417befr8i9jqlnl Query : use flama_phc
20241211@073626.7799 a9f28tb46nj417befr8i9jqlnl Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241211@073626.7887 a9f28tb46nj417befr8i9jqlnl Query : use flama_phc
20241211@073626.7892 a9f28tb46nj417befr8i9jqlnl Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241211@081908.4005 k4l479lfd1s3hrp26d9o4v796c Query : use flama_phc
20241211@081908.4009 k4l479lfd1s3hrp26d9o4v796c Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241211@081908.4096 k4l479lfd1s3hrp26d9o4v796c Query : use flama_phc
20241211@081908.4099 k4l479lfd1s3hrp26d9o4v796c Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241211@083608.3936 o31a2ma5ohitmu0g3dkem51gc1 Query : use flama_phc
20241211@083608.3941 o31a2ma5ohitmu0g3dkem51gc1 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241211@083608.4025 o31a2ma5ohitmu0g3dkem51gc1 Query : use flama_phc
20241211@083608.4028 o31a2ma5ohitmu0g3dkem51gc1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241211@090546.1128 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241211@090546.1161 ofcq9mmbl99aadvuevhhdcu6gk Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241211@090546.1448 ofcq9mmbl99aadvuevhhdcu6gk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3874';
20241211@090546.1527 ofcq9mmbl99aadvuevhhdcu6gk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3874';
20241211@090546.1599 ofcq9mmbl99aadvuevhhdcu6gk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3874';
20241211@090546.1634 ofcq9mmbl99aadvuevhhdcu6gk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3874';
20241211@090546.1690 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090546.1693 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241211@090546.1799 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090546.1802 ofcq9mmbl99aadvuevhhdcu6gk Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241211@090546.1898 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20241211@090546.2024 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408382 and bi.ref ='324.1816.00.1' and bi.lordem =1
20241211@090546.2381 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20241211@090546.2505 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408382 and bi.ref ='324.1643.00.1' and bi.lordem =2
20241211@090546.2826 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241211@090546.2958 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408382 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241211@090546.3284 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2357.00.1'
20241211@090546.3400 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408382 and bi.ref ='324.2357.00.1' and bi.lordem =4
20241211@090546.3708 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2357.00.1'
20241211@090546.3728 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408382 and bi.ref ='324.2357.00.1' and bi.lordem =4
20241211@090546.3745 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2366.00.1'
20241211@090546.3867 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408382 and bi.ref ='324.2366.00.1' and bi.lordem =5
20241211@090546.4176 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090546.4179 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241211@090546.4344 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090546.4348 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 1 valor from td where td.ndoc = 39
20241211@090546.4416 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090546.4420 ofcq9mmbl99aadvuevhhdcu6gk 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')
20241211@090546.4491 ofcq9mmbl99aadvuevhhdcu6gk 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
20241211@090546.4599 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090546.4602 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241211@090546.4695 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090546.4698 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241211@090546.4769 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090546.4773 ofcq9mmbl99aadvuevhhdcu6gk Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241211@090546.4843 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090546.4846 ofcq9mmbl99aadvuevhhdcu6gk Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241211@090546.4892 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090546.4895 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from td where ndoc = 39
20241211@090546.4949 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241211@090546.4995 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090546.5385 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241211@090546.5489 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090546.5507 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241211@090546.5538 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090546.5554 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241211@090546.5568 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241211@090546.5734 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241211@090546.5851 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090546.5869 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241211@090546.5916 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6759598096675955ea87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241211@090546.6154 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090546.6176 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241211@090546.6270 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241211@090546.6342 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241211@090546.6404 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241211@090546.6469 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241211@090546.6532 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241211@090546.6593 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241211@090546.6695 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6759598096675955ea87',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241211@090546.8453 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 fno valor from wsftdata order by fno desc
20241211@090546.8531 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090546.8548 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241211@090546.8575 ofcq9mmbl99aadvuevhhdcu6gk Query : select 'normal' from dummy
20241211@090546.8628 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6759598096675955ea87',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2369,100810,0,'2024-12-11',39,'euro',0,0,2024 ,?,?)
20241211@090546.9064 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090546.9068 ofcq9mmbl99aadvuevhhdcu6gk Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20241211@090546.9194 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1816.00.1'
20241211@090546.9348 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090546.9365 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090546.9620 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090546.9638 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090546.9650 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241211@090546.9690 ofcq9mmbl99aadvuevhhdcu6gk Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400200200a'
20241211@090546.9756 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090546.9774 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090546.9789 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6759589209675955eaee','aut6759598096675955ea87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241211@090546.9843 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090546.9861 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090546.9894 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6759589209675955eaee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6759598096675955ea87' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241211@090547.2220 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.2400 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090547.2700 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.2860 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090547.2960 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241211@090547.3100 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.3260 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090547.3390 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6759561892675955eb07','aut6759598096675955ea87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241211@090547.3440 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.3600 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090547.3940 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6759561892675955eb07',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6759598096675955ea87' ,0,0 ,2,23.00,20000,?,?,?)
20241211@090547.6230 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090547.6260 ofcq9mmbl99aadvuevhhdcu6gk Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20241211@090547.6500 ofcq9mmbl99aadvuevhhdcu6gk 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.1643.00.1'
20241211@090547.7730 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.7920 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090547.8230 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.8380 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090547.8470 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241211@090547.8590 ofcq9mmbl99aadvuevhhdcu6gk Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20241211@090547.8840 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.8990 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090547.9120 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6759589876675955eb15','aut6759598096675955ea87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241211@090547.9170 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.9310 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090547.9610 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6759589876675955eb15',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6759598096675955ea87' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241211@090547.1180 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090547.1184 ofcq9mmbl99aadvuevhhdcu6gk Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241211@090547.1205 ofcq9mmbl99aadvuevhhdcu6gk 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.2301.00.3'
20241211@090547.1323 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.1340 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090547.1368 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.1383 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090547.1392 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241211@090547.1404 ofcq9mmbl99aadvuevhhdcu6gk Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241211@090547.1425 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.1440 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090547.1452 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6759512622675955eb22','aut6759598096675955ea87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241211@090547.1457 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.1473 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090547.1503 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6759512622675955eb22',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6759598096675955ea87' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241211@090547.1726 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090547.1729 ofcq9mmbl99aadvuevhhdcu6gk Query : select st.usalote valor from st where st.ref = '324.2357.00.1'
20241211@090547.1757 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2357.00.1'
20241211@090547.1875 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.1891 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090547.1918 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.1933 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090547.1941 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241211@090547.1952 ofcq9mmbl99aadvuevhhdcu6gk Query : select sestamp valor from se where ref ='324.2357.00.1' and lote = 'r2200239100a'
20241211@090547.1980 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.1996 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090547.2009 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6759555871675955eb30','aut6759598096675955ea87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241211@090547.2013 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.2029 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090547.2057 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6759555871675955eb30',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6759598096675955ea87' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241211@090547.2283 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090547.2286 ofcq9mmbl99aadvuevhhdcu6gk Query : select st.usalote valor from st where st.ref = '324.2357.00.1'
20241211@090547.2305 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2357.00.1'
20241211@090547.2320 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.2337 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090547.2364 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.2381 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090547.2390 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241211@090547.2402 ofcq9mmbl99aadvuevhhdcu6gk Query : select sestamp valor from se where ref ='324.2357.00.1' and lote = 'r2200239100a'
20241211@090547.2416 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.2431 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090547.2444 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6759503214675955eb3a','aut6759598096675955ea87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241211@090547.2449 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.2464 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090547.2493 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6759503214675955eb3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6759598096675955ea87' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241211@090547.2817 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090547.2820 ofcq9mmbl99aadvuevhhdcu6gk Query : select st.usalote valor from st where st.ref = '324.2366.00.1'
20241211@090547.2841 ofcq9mmbl99aadvuevhhdcu6gk 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.2366.00.1'
20241211@090547.2993 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.3010 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090547.3037 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.3050 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090547.3058 ofcq9mmbl99aadvuevhhdcu6gk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241211@090547.3071 ofcq9mmbl99aadvuevhhdcu6gk Query : select sestamp valor from se where ref ='324.2366.00.1' and lote = 'r2400498100a'
20241211@090547.3093 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.3107 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241211@090547.3119 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6759559473675955eb4b','aut6759598096675955ea87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241211@090547.3123 ofcq9mmbl99aadvuevhhdcu6gk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@090547.3136 ofcq9mmbl99aadvuevhhdcu6gk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241211@090547.3166 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6759559473675955eb4b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6759598096675955ea87' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241211@090547.3492 ofcq9mmbl99aadvuevhhdcu6gk Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6759598096675955ea87','2408382','wait',39,'adm09112754980.682000002')
20241211@090547.3587 ofcq9mmbl99aadvuevhhdcu6gk Query : use flama_phc
20241211@090547.3591 ofcq9mmbl99aadvuevhhdcu6gk Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241211@090547.3621 ofcq9mmbl99aadvuevhhdcu6gk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3874';
20241211@090547.3666 ofcq9mmbl99aadvuevhhdcu6gk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3874';
20241211@090547.3727 ofcq9mmbl99aadvuevhhdcu6gk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3874';
20241211@090547.3775 ofcq9mmbl99aadvuevhhdcu6gk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3874';
20241211@091908.3229 g02rpvvumkli0sk4l7hm48vq6j Query : use flama_phc
20241211@091908.3235 g02rpvvumkli0sk4l7hm48vq6j Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241211@091908.3336 g02rpvvumkli0sk4l7hm48vq6j Query : use flama_phc
20241211@091908.3341 g02rpvvumkli0sk4l7hm48vq6j Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241211@093608.2647 5c88f3pijhbr3itfdncpucb6io Query : use flama_phc
20241211@093608.2651 5c88f3pijhbr3itfdncpucb6io Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241211@093608.2739 5c88f3pijhbr3itfdncpucb6io Query : use flama_phc
20241211@093608.2742 5c88f3pijhbr3itfdncpucb6io Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241211@101908.2400 6oap8trk37htdronhtb0ldauf5 Query : use flama_phc
20241211@101908.2450 6oap8trk37htdronhtb0ldauf5 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241211@101908.3320 6oap8trk37htdronhtb0ldauf5 Query : use flama_phc
20241211@101908.3360 6oap8trk37htdronhtb0ldauf5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241211@103607.9472 vvg4st7ph2d8fm83j6ujaeq791 Query : use flama_phc
20241211@103607.9477 vvg4st7ph2d8fm83j6ujaeq791 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241211@103607.9573 vvg4st7ph2d8fm83j6ujaeq791 Query : use flama_phc
20241211@103607.9576 vvg4st7ph2d8fm83j6ujaeq791 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241211@111908.8131 n1bg07513b4v2snoinht3bor8c Query : use flama_phc
20241211@111908.8190 n1bg07513b4v2snoinht3bor8c Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241211@111908.8694 n1bg07513b4v2snoinht3bor8c Query : use flama_phc
20241211@111908.8714 n1bg07513b4v2snoinht3bor8c Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241211@113608.9948 dk7tjtpe47dcfk3oah4nornqng Query : use flama_phc
20241211@113608.9953 dk7tjtpe47dcfk3oah4nornqng Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241211@113609.4400 dk7tjtpe47dcfk3oah4nornqng Query : use flama_phc
20241211@113609.4700 dk7tjtpe47dcfk3oah4nornqng Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241211@115542.2164 bhoq7lqb0b07sga013cn93vebi Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241211@115542.2188 bhoq7lqb0b07sga013cn93vebi Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241211@115542.2504 bhoq7lqb0b07sga013cn93vebi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3875';
20241211@115542.2591 bhoq7lqb0b07sga013cn93vebi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3875';
20241211@115542.2664 bhoq7lqb0b07sga013cn93vebi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3875';
20241211@115542.2698 bhoq7lqb0b07sga013cn93vebi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3875';
20241211@115542.4231 m3a1pvm93p55bpse6c2f899ufi Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241211@115542.4242 m3a1pvm93p55bpse6c2f899ufi Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241211@115542.4307 m3a1pvm93p55bpse6c2f899ufi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3876';
20241211@115542.4370 m3a1pvm93p55bpse6c2f899ufi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3876';
20241211@115542.4434 m3a1pvm93p55bpse6c2f899ufi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3876';
20241211@115542.5271 m3a1pvm93p55bpse6c2f899ufi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3876';
20241211@115542.6112 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115542.6115 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241211@115542.6215 m3a1pvm93p55bpse6c2f899ufi Query : select no, estab,szadrsdesc from szadrs where u_coddest=2
20241211@115542.6298 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1643.00.1'
20241211@115542.6390 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0003009 and bi.ref ='324.1643.00.1' and bi.lordem =10000
20241211@115542.6725 m3a1pvm93p55bpse6c2f899ufi Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24121139017,582000001 ' 
20241211@115542.7023 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1643.00.1'
20241211@115542.7049 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0003009 and bi.ref ='324.1643.00.1' and bi.lordem =10000
20241211@115542.7079 m3a1pvm93p55bpse6c2f899ufi Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24121139017,582000001 ' 
20241211@115542.7122 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115542.7125 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 1 valor from ts where ts.ndos = 5
20241211@115542.7208 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115542.7218 m3a1pvm93p55bpse6c2f899ufi 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')
20241211@115542.7294 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20241211@115542.7418 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115542.7421 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 ~inactivo valor from fl where no = '100500' and estab = 0 order by inactivo desc
20241211@115542.7805 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115542.7808 m3a1pvm93p55bpse6c2f899ufi Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241211@115542.8109 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115542.8112 m3a1pvm93p55bpse6c2f899ufi Query : select szadrsstamp valor from szadrs where szadrsdesc='n/instalaÇÕes sede'
20241211@115542.8174 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115542.8177 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from ts where ndos = 5
20241211@115542.8234 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115542.8904 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20241211@115542.8998 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115542.9016 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20241211@115542.9026 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115542.9042 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20241211@115542.9051 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 5
20241211@115542.9150 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2024 order by obrano desc
20241211@115542.9231 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2024 order by obrano desc
20241211@115542.9296 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115542.9303 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100500' and estab=0
20241211@115542.9370 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115542.9388 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20241211@115542.9424 m3a1pvm93p55bpse6c2f899ufi Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675978968167597dbee2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20241211@115542.9592 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115542.9611 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20241211@115542.9625 m3a1pvm93p55bpse6c2f899ufi Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut675978968167597dbee2','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20241211','12:25',?,?)
20241211@115543.7100 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115543.9100 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20241211@115543.1170 m3a1pvm93p55bpse6c2f899ufi Query : insert into wsbodata (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,maquina ) values ('aut675978968167597dbee2','trf entre armazéns a','2024-12-11',5,592,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20241211@115543.9510 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115543.9540 m3a1pvm93p55bpse6c2f899ufi Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20241211@115543.1043 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115543.1046 m3a1pvm93p55bpse6c2f899ufi Query : select st.stns valor from st where st.ref = '324.1643.00.1'
20241211@115543.1211 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115543.1214 m3a1pvm93p55bpse6c2f899ufi Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1643.00.1' and sa.armazem = 133 
20241211@115543.1293 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115543.1296 m3a1pvm93p55bpse6c2f899ufi Query : select st.stns valor from st where st.ref = '324.1643.00.1'
20241211@115543.1320 m3a1pvm93p55bpse6c2f899ufi 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.1643.00.1'
20241211@115543.1443 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115543.1460 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20241211@115543.1474 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115543.1491 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20241211@115543.1501 m3a1pvm93p55bpse6c2f899ufi Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20241211@115543.1632 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241211@115543.1670 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115543.1686 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20241211@115543.1699 m3a1pvm93p55bpse6c2f899ufi Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut675970043267597dbf28','aut675978968167597dbee2',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut675978968167597dbee2'
20241211@115543.1925 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115543.1943 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20241211@115543.1960 m3a1pvm93p55bpse6c2f899ufi Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut675970043267597dbf28',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 19.000, 19.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,10000 ,96,96*200.48,96,96*200.48 ,0,0,'un ','' ,bo.marcada,1 ,96*19.000,96*19.000*200.48 ,40.138000,40.138000*200.48 ,40.138000,40.138000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,96,96*200.48,96*19.000,96*19.000*200.48,'az24121139017,582000001 ',96,96*19.000,96,96*19.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut675978968167597dbee2'
20241211@115543.2380 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115543.2385 m3a1pvm93p55bpse6c2f899ufi Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20241211@115543.2400 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115543.2403 m3a1pvm93p55bpse6c2f899ufi Query : select st.stns valor from st where st.ref = '324.1643.00.1'
20241211@115543.2429 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115543.2432 m3a1pvm93p55bpse6c2f899ufi Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1643.00.1' and sa.armazem = 133 
20241211@115543.2457 m3a1pvm93p55bpse6c2f899ufi Query : use flama_phc
20241211@115543.2460 m3a1pvm93p55bpse6c2f899ufi Query : select st.stns valor from st where st.ref = '324.1643.00.1'
20241211@115543.2480 m3a1pvm93p55bpse6c2f899ufi 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.1643.00.1'
20241211@115543.2495 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115543.2513 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20241211@115543.2527 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115543.2543 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20241211@115543.2552 m3a1pvm93p55bpse6c2f899ufi Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20241211@115543.2567 m3a1pvm93p55bpse6c2f899ufi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241211@115543.2580 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241211@115543.2596 m3a1pvm93p55bpse6c2f899ufi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20241211@115543.2610 m3a1pvm93p55bpse6c2f899ufi Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut675971910167597dbf3f','aut675978968167597dbee2',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut675978968167597dbee2'
20241211@115543.2763 m3a1pvm93p55bpse6c2f899ufi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
