20241126@143119.4497 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.4519 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143119.4569 5ebg3d0kcuoduhid25pic5223p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6745d634306745dbb76c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6745d943826745dbb5db' ,0,0 ,2,23.00,170000,?,?,?)
20241126@143119.4862 5ebg3d0kcuoduhid25pic5223p Query : use flama_phc
20241126@143119.4866 5ebg3d0kcuoduhid25pic5223p Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241126@143119.4887 5ebg3d0kcuoduhid25pic5223p 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.1879.00.1'
20241126@143119.4931 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.4951 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143119.4990 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.5011 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143119.5023 5ebg3d0kcuoduhid25pic5223p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143119.5045 5ebg3d0kcuoduhid25pic5223p Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2400283200a'
20241126@143119.5062 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.5081 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143119.5101 5ebg3d0kcuoduhid25pic5223p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d185646745dbb77b','aut6745d943826745dbb5db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143119.5107 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.5126 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143119.5173 5ebg3d0kcuoduhid25pic5223p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d185646745dbb77b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6745d943826745dbb5db' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20241126@143119.5522 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.5542 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143119.5578 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.5596 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143119.5608 5ebg3d0kcuoduhid25pic5223p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143119.5625 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.5644 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143119.5677 5ebg3d0kcuoduhid25pic5223p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d985536745dbb789','aut6745d943826745dbb5db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143119.5682 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.5703 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143119.5739 5ebg3d0kcuoduhid25pic5223p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6745d985536745dbb789',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6745d943826745dbb5db' ,0,0 ,2,23.00,200000,?,?,?)
20241126@143119.6131 5ebg3d0kcuoduhid25pic5223p Query : use flama_phc
20241126@143119.6135 5ebg3d0kcuoduhid25pic5223p Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241126@143119.6173 5ebg3d0kcuoduhid25pic5223p 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.1879.00.1'
20241126@143119.6218 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.6260 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143119.6337 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.6364 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143119.6373 5ebg3d0kcuoduhid25pic5223p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143119.6387 5ebg3d0kcuoduhid25pic5223p Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2400283200a'
20241126@143119.6418 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.6441 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143119.6480 5ebg3d0kcuoduhid25pic5223p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d885536745dbb79c','aut6745d943826745dbb5db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143119.6485 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.6502 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143119.6551 5ebg3d0kcuoduhid25pic5223p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d885536745dbb79c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6745d943826745dbb5db' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20241126@143119.6965 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.7002 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143119.7031 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.7046 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143119.7056 5ebg3d0kcuoduhid25pic5223p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143119.7069 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.7085 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143119.7099 5ebg3d0kcuoduhid25pic5223p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d094916745dbb7ac','aut6745d943826745dbb5db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143119.7132 5ebg3d0kcuoduhid25pic5223p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143119.7180 5ebg3d0kcuoduhid25pic5223p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143119.7223 5ebg3d0kcuoduhid25pic5223p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6745d094916745dbb7ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6745d943826745dbb5db' ,0,0 ,2,23.00,230000,?,?,?)
20241126@143119.7495 5ebg3d0kcuoduhid25pic5223p Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6745d943826745dbb5db','2407883','wait',39,'adm09112754980.682000002')
20241126@143119.7585 5ebg3d0kcuoduhid25pic5223p Query : use flama_phc
20241126@143119.7595 5ebg3d0kcuoduhid25pic5223p Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241126@143119.7626 5ebg3d0kcuoduhid25pic5223p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3526';
20241126@143119.7668 5ebg3d0kcuoduhid25pic5223p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3526';
20241126@143119.7753 5ebg3d0kcuoduhid25pic5223p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3526';
20241126@143119.7789 5ebg3d0kcuoduhid25pic5223p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3526';
20241126@143119.8418 631fradaiej3ulhefe8vgq301v Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241126@143119.8429 631fradaiej3ulhefe8vgq301v Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241126@143119.8514 631fradaiej3ulhefe8vgq301v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3527';
20241126@143119.8591 631fradaiej3ulhefe8vgq301v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3527';
20241126@143119.8666 631fradaiej3ulhefe8vgq301v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3527';
20241126@143119.8712 631fradaiej3ulhefe8vgq301v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3527';
20241126@143119.8783 631fradaiej3ulhefe8vgq301v Query : use flama_phc
20241126@143119.8787 631fradaiej3ulhefe8vgq301v Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241126@143119.8859 631fradaiej3ulhefe8vgq301v Query : use flama_phc
20241126@143119.8864 631fradaiej3ulhefe8vgq301v Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241126@143119.8930 631fradaiej3ulhefe8vgq301v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1332.00.1'
20241126@143119.9153 631fradaiej3ulhefe8vgq301v Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2078 and bo.obrano = 2407884 and bi.ref ='324.1332.00.1' and bi.lordem =1
20241126@143119.9533 631fradaiej3ulhefe8vgq301v Query : use flama_phc
20241126@143119.9537 631fradaiej3ulhefe8vgq301v Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241126@143119.9573 631fradaiej3ulhefe8vgq301v Query : use flama_phc
20241126@143119.9581 631fradaiej3ulhefe8vgq301v Query : select top 1 1 valor from td where td.ndoc = 39
20241126@143119.9624 631fradaiej3ulhefe8vgq301v Query : use flama_phc
20241126@143119.9628 631fradaiej3ulhefe8vgq301v 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')
20241126@143119.9673 631fradaiej3ulhefe8vgq301v 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
20241126@143119.9731 631fradaiej3ulhefe8vgq301v Query : use flama_phc
20241126@143119.9734 631fradaiej3ulhefe8vgq301v Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241126@143119.9775 631fradaiej3ulhefe8vgq301v Query : use flama_phc
20241126@143119.9778 631fradaiej3ulhefe8vgq301v Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241126@143119.9831 631fradaiej3ulhefe8vgq301v Query : use flama_phc
20241126@143119.9841 631fradaiej3ulhefe8vgq301v Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241126@143119.9970 631fradaiej3ulhefe8vgq301v Query : use flama_phc
20241126@143119.9981 631fradaiej3ulhefe8vgq301v Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241126@143120.6400 631fradaiej3ulhefe8vgq301v Query : use flama_phc
20241126@143120.7900 631fradaiej3ulhefe8vgq301v Query : select 1 valor from td where ndoc = 39
20241126@143120.1080 631fradaiej3ulhefe8vgq301v Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241126@143120.1480 631fradaiej3ulhefe8vgq301v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.1750 631fradaiej3ulhefe8vgq301v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241126@143120.2130 631fradaiej3ulhefe8vgq301v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.2620 631fradaiej3ulhefe8vgq301v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241126@143120.3030 631fradaiej3ulhefe8vgq301v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.3360 631fradaiej3ulhefe8vgq301v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241126@143120.3530 631fradaiej3ulhefe8vgq301v Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241126@143120.4630 631fradaiej3ulhefe8vgq301v Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241126@143120.4790 631fradaiej3ulhefe8vgq301v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.4990 631fradaiej3ulhefe8vgq301v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241126@143120.5230 631fradaiej3ulhefe8vgq301v Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6745d815216745dbb808' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241126@143120.7860 631fradaiej3ulhefe8vgq301v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.8260 631fradaiej3ulhefe8vgq301v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241126@143120.2792 631fradaiej3ulhefe8vgq301v Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241126@143120.2809 631fradaiej3ulhefe8vgq301v Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241126@143120.2823 631fradaiej3ulhefe8vgq301v Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241126@143120.2836 631fradaiej3ulhefe8vgq301v Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241126@143120.2849 631fradaiej3ulhefe8vgq301v Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241126@143120.2903 631fradaiej3ulhefe8vgq301v Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241126@143120.2920 631fradaiej3ulhefe8vgq301v Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6745d815216745dbb808',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241126@143120.3217 631fradaiej3ulhefe8vgq301v Query : select top 1 fno valor from wsftdata order by fno desc
20241126@143120.3309 631fradaiej3ulhefe8vgq301v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.3359 631fradaiej3ulhefe8vgq301v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241126@143120.3387 631fradaiej3ulhefe8vgq301v Query : select 'normal' from dummy
20241126@143120.3401 631fradaiej3ulhefe8vgq301v Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6745d815216745dbb808',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2061,100810,0,'2024-11-26',39,'euro',0,0,2024 ,?,?)
20241126@143120.3734 631fradaiej3ulhefe8vgq301v Query : use flama_phc
20241126@143120.3738 631fradaiej3ulhefe8vgq301v Query : select st.usalote valor from st where st.ref = '324.1332.00.1'
20241126@143120.3779 631fradaiej3ulhefe8vgq301v 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.1332.00.1'
20241126@143120.4166 631fradaiej3ulhefe8vgq301v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.4197 631fradaiej3ulhefe8vgq301v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143120.4224 631fradaiej3ulhefe8vgq301v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.4240 631fradaiej3ulhefe8vgq301v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143120.4249 631fradaiej3ulhefe8vgq301v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143120.4281 631fradaiej3ulhefe8vgq301v Query : select sestamp valor from se where ref ='324.1332.00.1' and lote = 'r2400759200a'
20241126@143120.4302 631fradaiej3ulhefe8vgq301v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.4352 631fradaiej3ulhefe8vgq301v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143120.4414 631fradaiej3ulhefe8vgq301v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d839046745dbb869','aut6745d815216745dbb808' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143120.4419 631fradaiej3ulhefe8vgq301v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.4435 631fradaiej3ulhefe8vgq301v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143120.4486 631fradaiej3ulhefe8vgq301v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d839046745dbb869',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',17.000 ,'aut6745d815216745dbb808' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241126@143120.4768 631fradaiej3ulhefe8vgq301v Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6745d815216745dbb808','2407884','wait',39,'adm09112754980.682000002')
20241126@143120.4878 631fradaiej3ulhefe8vgq301v Query : use flama_phc
20241126@143120.4885 631fradaiej3ulhefe8vgq301v Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241126@143120.4956 631fradaiej3ulhefe8vgq301v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3527';
20241126@143120.5011 631fradaiej3ulhefe8vgq301v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3527';
20241126@143120.5074 631fradaiej3ulhefe8vgq301v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3527';
20241126@143120.5118 631fradaiej3ulhefe8vgq301v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3527';
20241126@143120.5658 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241126@143120.5673 qposg2jmt4pkt2s6mh96qjhrgf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241126@143120.5779 qposg2jmt4pkt2s6mh96qjhrgf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3528';
20241126@143120.5883 qposg2jmt4pkt2s6mh96qjhrgf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3528';
20241126@143120.5966 qposg2jmt4pkt2s6mh96qjhrgf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3528';
20241126@143120.6008 qposg2jmt4pkt2s6mh96qjhrgf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3528';
20241126@143120.6065 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143120.6069 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241126@143120.6188 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143120.6191 qposg2jmt4pkt2s6mh96qjhrgf Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241126@143120.6235 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20241126@143120.6464 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2078 and bo.obrano = 2407885 and bi.ref ='324.2388.00.1' and bi.lordem =1
20241126@143120.6817 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20241126@143120.6838 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2078 and bo.obrano = 2407885 and bi.ref ='324.2388.00.1' and bi.lordem =1
20241126@143120.6857 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20241126@143120.6879 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2078 and bo.obrano = 2407885 and bi.ref ='324.2388.00.1' and bi.lordem =1
20241126@143120.6896 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20241126@143120.6920 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2078 and bo.obrano = 2407885 and bi.ref ='324.2388.00.1' and bi.lordem =1
20241126@143120.6937 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20241126@143120.6956 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2078 and bo.obrano = 2407885 and bi.ref ='324.2388.00.1' and bi.lordem =1
20241126@143120.6995 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143120.6999 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241126@143120.7068 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143120.7071 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 1 valor from td where td.ndoc = 39
20241126@143120.7134 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143120.7138 qposg2jmt4pkt2s6mh96qjhrgf 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')
20241126@143120.7189 qposg2jmt4pkt2s6mh96qjhrgf 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
20241126@143120.7241 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143120.7251 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241126@143120.7295 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143120.7298 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241126@143120.7344 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143120.7347 qposg2jmt4pkt2s6mh96qjhrgf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241126@143120.7391 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143120.7393 qposg2jmt4pkt2s6mh96qjhrgf Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241126@143120.7446 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143120.7449 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from td where ndoc = 39
20241126@143120.7466 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241126@143120.7480 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.7496 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241126@143120.7546 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.7565 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241126@143120.7598 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.7621 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241126@143120.7638 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241126@143120.7739 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241126@143120.7784 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.7811 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241126@143120.7827 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6745d239796745dbb8ba' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241126@143120.8164 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143120.9547 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241126@143120.9589 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241126@143120.9603 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241126@143120.9616 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241126@143120.9629 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241126@143120.9640 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241126@143120.9653 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241126@143120.9667 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6745d239796745dbb8ba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241126@143120.9969 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 fno valor from wsftdata order by fno desc
20241126@143121.1367 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.1412 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241126@143121.1438 qposg2jmt4pkt2s6mh96qjhrgf Query : select 'normal' from dummy
20241126@143121.1455 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6745d239796745dbb8ba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2062,100810,0,'2024-11-26',39,'euro',0,0,2024 ,?,?)
20241126@143121.1822 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143121.1851 qposg2jmt4pkt2s6mh96qjhrgf Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20241126@143121.1885 qposg2jmt4pkt2s6mh96qjhrgf 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.2388.00.1'
20241126@143121.2060 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.2077 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143121.2113 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.2157 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143121.2165 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143121.2182 qposg2jmt4pkt2s6mh96qjhrgf Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20241126@143121.2204 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.2238 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143121.2253 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d820786745dbb935','aut6745d239796745dbb8ba' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143121.2258 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.2284 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143121.2347 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d820786745dbb935',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6745d239796745dbb8ba' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241126@143121.2688 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143121.2692 qposg2jmt4pkt2s6mh96qjhrgf Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20241126@143121.2716 qposg2jmt4pkt2s6mh96qjhrgf 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.2388.00.1'
20241126@143121.2731 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.2750 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143121.2796 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.2830 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143121.2838 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143121.2857 qposg2jmt4pkt2s6mh96qjhrgf Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20241126@143121.2898 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.2924 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143121.2960 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d410026745dbb946','aut6745d239796745dbb8ba' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143121.2964 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.2990 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143121.3059 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d410026745dbb946',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6745d239796745dbb8ba' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241126@143121.3337 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143121.3340 qposg2jmt4pkt2s6mh96qjhrgf Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20241126@143121.3361 qposg2jmt4pkt2s6mh96qjhrgf 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.2388.00.1'
20241126@143121.3375 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.3391 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143121.3447 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.3478 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143121.3486 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143121.3510 qposg2jmt4pkt2s6mh96qjhrgf Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20241126@143121.3523 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.3546 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143121.3557 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d009356745dbb956','aut6745d239796745dbb8ba' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143121.3561 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.3580 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143121.3630 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d009356745dbb956',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut6745d239796745dbb8ba' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241126@143121.3911 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143121.3914 qposg2jmt4pkt2s6mh96qjhrgf Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20241126@143121.3934 qposg2jmt4pkt2s6mh96qjhrgf 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.2388.00.1'
20241126@143121.3956 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.3979 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143121.4033 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.4050 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143121.4059 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143121.4106 qposg2jmt4pkt2s6mh96qjhrgf Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20241126@143121.4120 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.4136 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143121.4149 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d256926745dbb964','aut6745d239796745dbb8ba' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143121.4155 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.4170 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143121.4208 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d256926745dbb964',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut6745d239796745dbb8ba' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241126@143121.4511 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143121.4515 qposg2jmt4pkt2s6mh96qjhrgf Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20241126@143121.4549 qposg2jmt4pkt2s6mh96qjhrgf 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.2388.00.1'
20241126@143121.4567 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.4584 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143121.4615 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.4641 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143121.4655 qposg2jmt4pkt2s6mh96qjhrgf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143121.4688 qposg2jmt4pkt2s6mh96qjhrgf Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20241126@143121.4717 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.4733 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143121.4746 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d812316745dbb973','aut6745d239796745dbb8ba' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143121.4751 qposg2jmt4pkt2s6mh96qjhrgf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.4768 qposg2jmt4pkt2s6mh96qjhrgf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143121.4831 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d812316745dbb973',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut6745d239796745dbb8ba' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241126@143121.5136 qposg2jmt4pkt2s6mh96qjhrgf Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6745d239796745dbb8ba','2407885','wait',39,'adm09112754980.682000002')
20241126@143121.5219 qposg2jmt4pkt2s6mh96qjhrgf Query : use flama_phc
20241126@143121.5223 qposg2jmt4pkt2s6mh96qjhrgf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241126@143121.5255 qposg2jmt4pkt2s6mh96qjhrgf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3528';
20241126@143121.5303 qposg2jmt4pkt2s6mh96qjhrgf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3528';
20241126@143121.5357 qposg2jmt4pkt2s6mh96qjhrgf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3528';
20241126@143121.5404 qposg2jmt4pkt2s6mh96qjhrgf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3528';
20241126@143121.6081 qhb3ardk04nsdcm2tdufofhvbc Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241126@143121.6094 qhb3ardk04nsdcm2tdufofhvbc Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241126@143121.6192 qhb3ardk04nsdcm2tdufofhvbc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3529';
20241126@143121.6335 qhb3ardk04nsdcm2tdufofhvbc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3529';
20241126@143121.6398 qhb3ardk04nsdcm2tdufofhvbc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3529';
20241126@143121.6445 qhb3ardk04nsdcm2tdufofhvbc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3529';
20241126@143121.6512 qhb3ardk04nsdcm2tdufofhvbc Query : use flama_phc
20241126@143121.6533 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241126@143121.6608 qhb3ardk04nsdcm2tdufofhvbc Query : use flama_phc
20241126@143121.6612 qhb3ardk04nsdcm2tdufofhvbc Query : select no, estab,szadrsdesc from szadrs where u_coddest=1957
20241126@143121.6722 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.1290.1003'
20241126@143121.6904 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2078 and bo.obrano = 2407886 and bi.ref ='325.1290.1003' and bi.lordem =1
20241126@143121.7456 qhb3ardk04nsdcm2tdufofhvbc Query : use flama_phc
20241126@143121.7465 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241126@143121.7509 qhb3ardk04nsdcm2tdufofhvbc Query : use flama_phc
20241126@143121.7512 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 1 valor from td where td.ndoc = 39
20241126@143121.7542 qhb3ardk04nsdcm2tdufofhvbc Query : use flama_phc
20241126@143121.7545 qhb3ardk04nsdcm2tdufofhvbc 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')
20241126@143121.7595 qhb3ardk04nsdcm2tdufofhvbc 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
20241126@143121.7630 qhb3ardk04nsdcm2tdufofhvbc Query : use flama_phc
20241126@143121.7633 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 ~inactivo valor from cl where no = '199530' and estab = 0 order by inactivo desc
20241126@143121.7785 qhb3ardk04nsdcm2tdufofhvbc Query : use flama_phc
20241126@143121.7791 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241126@143121.7830 qhb3ardk04nsdcm2tdufofhvbc Query : use flama_phc
20241126@143121.7832 qhb3ardk04nsdcm2tdufofhvbc Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241126@143121.7891 qhb3ardk04nsdcm2tdufofhvbc Query : use flama_phc
20241126@143121.7894 qhb3ardk04nsdcm2tdufofhvbc Query : select szadrsstamp valor from szadrs where szadrsdesc='pingo doce-distribuiÇÃo alimentar, s.a.- valongo1'
20241126@143121.7964 qhb3ardk04nsdcm2tdufofhvbc Query : use flama_phc
20241126@143121.7969 qhb3ardk04nsdcm2tdufofhvbc Query : select 1 valor from td where ndoc = 39
20241126@143121.7981 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241126@143121.7994 qhb3ardk04nsdcm2tdufofhvbc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.8023 qhb3ardk04nsdcm2tdufofhvbc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241126@143121.8065 qhb3ardk04nsdcm2tdufofhvbc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.8091 qhb3ardk04nsdcm2tdufofhvbc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241126@143121.8125 qhb3ardk04nsdcm2tdufofhvbc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.8141 qhb3ardk04nsdcm2tdufofhvbc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241126@143121.8154 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241126@143121.8216 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241126@143121.8249 qhb3ardk04nsdcm2tdufofhvbc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143121.8274 qhb3ardk04nsdcm2tdufofhvbc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241126@143121.8288 qhb3ardk04nsdcm2tdufofhvbc Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6745d401336745dbb9c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241126@143122.1960 qhb3ardk04nsdcm2tdufofhvbc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143122.2270 qhb3ardk04nsdcm2tdufofhvbc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241126@143122.2700 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241126@143122.2990 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241126@143122.3190 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241126@143122.3350 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241126@143122.3510 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241126@143122.3640 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241126@143122.3760 qhb3ardk04nsdcm2tdufofhvbc Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6745d401336745dbb9c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241126@143122.6750 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 fno valor from wsftdata order by fno desc
20241126@143122.7130 qhb3ardk04nsdcm2tdufofhvbc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143122.7330 qhb3ardk04nsdcm2tdufofhvbc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241126@143122.7970 qhb3ardk04nsdcm2tdufofhvbc Query : select 'normal' from dummy
20241126@143122.8170 qhb3ardk04nsdcm2tdufofhvbc Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6745d401336745dbb9c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2063,199530,0,'2024-11-26',39,'euro',0,0,2024 ,?,?)
20241126@143122.1164 qhb3ardk04nsdcm2tdufofhvbc Query : use flama_phc
20241126@143122.1168 qhb3ardk04nsdcm2tdufofhvbc Query : select st.usalote valor from st where st.ref = '325.1290.1003'
20241126@143122.1204 qhb3ardk04nsdcm2tdufofhvbc 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 = '325.1290.1003'
20241126@143122.1371 qhb3ardk04nsdcm2tdufofhvbc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143122.1388 qhb3ardk04nsdcm2tdufofhvbc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143122.1471 qhb3ardk04nsdcm2tdufofhvbc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143122.1504 qhb3ardk04nsdcm2tdufofhvbc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143122.1516 qhb3ardk04nsdcm2tdufofhvbc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143122.1529 qhb3ardk04nsdcm2tdufofhvbc Query : select sestamp valor from se where ref ='325.1290.1003' and lote = 'r2400796200a'
20241126@143122.1544 qhb3ardk04nsdcm2tdufofhvbc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143122.1568 qhb3ardk04nsdcm2tdufofhvbc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143122.1580 qhb3ardk04nsdcm2tdufofhvbc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d653176745dbba25','aut6745d401336745dbb9c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143122.1585 qhb3ardk04nsdcm2tdufofhvbc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143122.1600 qhb3ardk04nsdcm2tdufofhvbc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143122.1647 qhb3ardk04nsdcm2tdufofhvbc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d653176745dbba25',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1728.000 ,'aut6745d401336745dbb9c7' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241126@143122.4601 qhb3ardk04nsdcm2tdufofhvbc Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6745d401336745dbb9c7','2407886','wait',39,'adm09112754980.682000002')
20241126@143122.4733 qhb3ardk04nsdcm2tdufofhvbc Query : use flama_phc
20241126@143122.4737 qhb3ardk04nsdcm2tdufofhvbc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241126@143122.4770 qhb3ardk04nsdcm2tdufofhvbc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3529';
20241126@143122.4819 qhb3ardk04nsdcm2tdufofhvbc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3529';
20241126@143122.4879 qhb3ardk04nsdcm2tdufofhvbc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3529';
20241126@143122.4917 qhb3ardk04nsdcm2tdufofhvbc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3529';
20241126@143122.5445 e269rsr0j970i76707eu0gtkq4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241126@143122.5457 e269rsr0j970i76707eu0gtkq4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241126@143122.5572 e269rsr0j970i76707eu0gtkq4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3530';
20241126@143122.5643 e269rsr0j970i76707eu0gtkq4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3530';
20241126@143122.5704 e269rsr0j970i76707eu0gtkq4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3530';
20241126@143122.5748 e269rsr0j970i76707eu0gtkq4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3530';
20241126@143122.5824 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143122.5828 e269rsr0j970i76707eu0gtkq4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241126@143122.5891 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143122.5894 e269rsr0j970i76707eu0gtkq4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6917
20241126@143122.5994 e269rsr0j970i76707eu0gtkq4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.600.94.01'
20241126@143122.6190 e269rsr0j970i76707eu0gtkq4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2078 and bo.obrano = 2407888 and bi.ref ='324.600.94.01' and bi.lordem =1
20241126@143122.6525 e269rsr0j970i76707eu0gtkq4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2000.94.1'
20241126@143122.6700 e269rsr0j970i76707eu0gtkq4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2078 and bo.obrano = 2407888 and bi.ref ='324.2000.94.1' and bi.lordem =2
20241126@143122.7065 e269rsr0j970i76707eu0gtkq4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.900.94.01'
20241126@143122.7249 e269rsr0j970i76707eu0gtkq4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2078 and bo.obrano = 2407888 and bi.ref ='324.900.94.01' and bi.lordem =3
20241126@143122.7586 e269rsr0j970i76707eu0gtkq4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.700.94.01'
20241126@143122.7777 e269rsr0j970i76707eu0gtkq4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2078 and bo.obrano = 2407888 and bi.ref ='324.700.94.01' and bi.lordem =4
20241126@143122.8122 e269rsr0j970i76707eu0gtkq4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2200.94.1'
20241126@143122.8300 e269rsr0j970i76707eu0gtkq4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2078 and bo.obrano = 2407888 and bi.ref ='324.2200.94.1' and bi.lordem =5
20241126@143122.8635 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143122.8639 e269rsr0j970i76707eu0gtkq4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241126@143122.8680 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143122.8683 e269rsr0j970i76707eu0gtkq4 Query : select top 1 1 valor from td where td.ndoc = 39
20241126@143122.8717 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143122.8733 e269rsr0j970i76707eu0gtkq4 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')
20241126@143122.8765 e269rsr0j970i76707eu0gtkq4 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
20241126@143122.8837 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143122.8844 e269rsr0j970i76707eu0gtkq4 Query : select top 1 ~inactivo valor from cl where no = '199800' and estab = 0 order by inactivo desc
20241126@143122.8990 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143122.8993 e269rsr0j970i76707eu0gtkq4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241126@143122.9048 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143122.9052 e269rsr0j970i76707eu0gtkq4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241126@143122.9110 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143122.9113 e269rsr0j970i76707eu0gtkq4 Query : select szadrsstamp valor from szadrs where szadrsdesc='740 ent vnr bligeiro'
20241126@143122.9165 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143122.9168 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from td where ndoc = 39
20241126@143122.9180 e269rsr0j970i76707eu0gtkq4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241126@143122.9198 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143122.9234 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241126@143122.9278 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143122.9316 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241126@143122.9371 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143122.9388 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241126@143122.9404 e269rsr0j970i76707eu0gtkq4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241126@143122.9475 e269rsr0j970i76707eu0gtkq4 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241126@143122.9533 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143122.9555 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241126@143122.9575 e269rsr0j970i76707eu0gtkq4 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6745d929376745dbbae5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241126@143122.9763 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143122.9807 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241126@143122.9846 e269rsr0j970i76707eu0gtkq4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241126@143122.9869 e269rsr0j970i76707eu0gtkq4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241126@143122.9883 e269rsr0j970i76707eu0gtkq4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241126@143122.9897 e269rsr0j970i76707eu0gtkq4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241126@143122.9911 e269rsr0j970i76707eu0gtkq4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241126@143122.9923 e269rsr0j970i76707eu0gtkq4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241126@143122.9936 e269rsr0j970i76707eu0gtkq4 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6745d929376745dbbae5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241126@143123.2090 e269rsr0j970i76707eu0gtkq4 Query : select top 1 fno valor from wsftdata order by fno desc
20241126@143123.2590 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.2940 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241126@143123.3170 e269rsr0j970i76707eu0gtkq4 Query : select 'normal' from dummy
20241126@143123.3360 e269rsr0j970i76707eu0gtkq4 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6745d929376745dbbae5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2064,199800,0,'2024-11-26',39,'euro',0,0,2024 ,?,?)
20241126@143123.6720 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143123.6770 e269rsr0j970i76707eu0gtkq4 Query : select st.usalote valor from st where st.ref = '324.600.94.01'
20241126@143123.7010 e269rsr0j970i76707eu0gtkq4 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.600.94.01'
20241126@143123.8760 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.8950 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143123.9210 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.9470 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143123.9720 e269rsr0j970i76707eu0gtkq4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143123.1000 e269rsr0j970i76707eu0gtkq4 Query : select sestamp valor from se where ref ='324.600.94.01' and lote = 'r2400047200a'
20241126@143123.1021 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.1037 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143123.1049 e269rsr0j970i76707eu0gtkq4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d882136745dbbb18','aut6745d929376745dbbae5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143123.1054 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.1104 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143123.1133 e269rsr0j970i76707eu0gtkq4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d882136745dbbb18',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6745d929376745dbbae5' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241126@143123.1439 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.3150 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143123.3182 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.3201 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143123.3211 e269rsr0j970i76707eu0gtkq4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143123.3264 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.3288 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143123.3305 e269rsr0j970i76707eu0gtkq4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d103036745dbbb4f','aut6745d929376745dbbae5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143123.3310 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.3327 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143123.3356 e269rsr0j970i76707eu0gtkq4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6745d103036745dbbb4f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6745d929376745dbbae5' ,0,0 ,2,23.00,20000,?,?,?)
20241126@143123.3755 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143123.3759 e269rsr0j970i76707eu0gtkq4 Query : select st.usalote valor from st where st.ref = '324.2000.94.1'
20241126@143123.3843 e269rsr0j970i76707eu0gtkq4 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.2000.94.1'
20241126@143123.4035 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.4065 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143123.4093 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.4128 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143123.4137 e269rsr0j970i76707eu0gtkq4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143123.4155 e269rsr0j970i76707eu0gtkq4 Query : select sestamp valor from se where ref ='324.2000.94.1' and lote = 'r2300916200a'
20241126@143123.4169 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.4186 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143123.4208 e269rsr0j970i76707eu0gtkq4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d011546745dbbb65','aut6745d929376745dbbae5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143123.4214 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.4232 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143123.4285 e269rsr0j970i76707eu0gtkq4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d011546745dbbb65',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6745d929376745dbbae5' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241126@143123.4601 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143123.4625 e269rsr0j970i76707eu0gtkq4 Query : select st.usalote valor from st where st.ref = '324.900.94.01'
20241126@143123.4729 e269rsr0j970i76707eu0gtkq4 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.900.94.01'
20241126@143123.4978 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.5062 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143123.5094 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.5367 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143123.5378 e269rsr0j970i76707eu0gtkq4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143123.5392 e269rsr0j970i76707eu0gtkq4 Query : select sestamp valor from se where ref ='324.900.94.01' and lote = 'r2300952200a'
20241126@143123.5495 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.5539 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143123.5553 e269rsr0j970i76707eu0gtkq4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d586076745dbbb86','aut6745d929376745dbbae5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143123.5589 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.5630 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143123.5672 e269rsr0j970i76707eu0gtkq4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d586076745dbbb86',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6745d929376745dbbae5' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241126@143123.6017 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143123.6022 e269rsr0j970i76707eu0gtkq4 Query : select st.usalote valor from st where st.ref = '324.700.94.01'
20241126@143123.6043 e269rsr0j970i76707eu0gtkq4 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.700.94.01'
20241126@143123.6306 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.6331 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143123.6359 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.6374 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143123.6415 e269rsr0j970i76707eu0gtkq4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143123.6454 e269rsr0j970i76707eu0gtkq4 Query : select sestamp valor from se where ref ='324.700.94.01' and lote = 'r2300913100a'
20241126@143123.6475 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.6521 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143123.6533 e269rsr0j970i76707eu0gtkq4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d264546745dbbb9e','aut6745d929376745dbbae5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143123.6545 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.6587 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143123.6672 e269rsr0j970i76707eu0gtkq4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d264546745dbbb9e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6745d929376745dbbae5' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241126@143123.6980 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143123.6984 e269rsr0j970i76707eu0gtkq4 Query : select st.usalote valor from st where st.ref = '324.2200.94.1'
20241126@143123.7006 e269rsr0j970i76707eu0gtkq4 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.2200.94.1'
20241126@143123.7185 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.7204 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143123.7252 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.7268 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143123.7333 e269rsr0j970i76707eu0gtkq4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@143123.7373 e269rsr0j970i76707eu0gtkq4 Query : select sestamp valor from se where ref ='324.2200.94.1' and lote = 'r2400046200a'
20241126@143123.7387 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.7410 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@143123.7496 e269rsr0j970i76707eu0gtkq4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6745d313166745dbbbb4','aut6745d929376745dbbae5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@143123.7501 e269rsr0j970i76707eu0gtkq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@143123.7527 e269rsr0j970i76707eu0gtkq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@143123.7561 e269rsr0j970i76707eu0gtkq4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6745d313166745dbbbb4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6745d929376745dbbae5' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241126@143123.8013 e269rsr0j970i76707eu0gtkq4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6745d929376745dbbae5','2407888','wait',39,'adm09112754980.682000002')
20241126@143123.8221 e269rsr0j970i76707eu0gtkq4 Query : use flama_phc
20241126@143123.8224 e269rsr0j970i76707eu0gtkq4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241126@143123.8260 e269rsr0j970i76707eu0gtkq4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3530';
20241126@143123.8536 e269rsr0j970i76707eu0gtkq4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3530';
20241126@143123.8596 e269rsr0j970i76707eu0gtkq4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3530';
20241126@143123.8634 e269rsr0j970i76707eu0gtkq4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3530';

20241126@154901.9567 otm6tm2f21kt9q45m78mq6cr27 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3531';
20241126@154901.9628 otm6tm2f21kt9q45m78mq6cr27 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3531';
20241126@154901.9680 otm6tm2f21kt9q45m78mq6cr27 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3531';
20241126@154901.9743 otm6tm2f21kt9q45m78mq6cr27 Query : use flama_phc
20241126@154901.9747 otm6tm2f21kt9q45m78mq6cr27 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241126@154901.9822 otm6tm2f21kt9q45m78mq6cr27 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4980.00.1'
20241126@154902.1200 otm6tm2f21kt9q45m78mq6cr27 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =gt2 and bo.boano =2002 and bo.obrano = 024/571 and bi.ref ='324.4980.00.1' and bi.lordem =1
20241126@154902.1850 otm6tm2f21kt9q45m78mq6cr27 Query : use flama_phc
20241126@154902.1890 otm6tm2f21kt9q45m78mq6cr27 Query : select top 1 1 valor from ts where ts.ndos = 61
20241126@154902.3400 otm6tm2f21kt9q45m78mq6cr27 Query : use flama_phc
20241126@154902.3440 otm6tm2f21kt9q45m78mq6cr27 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')
20241126@154902.3970 otm6tm2f21kt9q45m78mq6cr27 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 =61
20241126@154902.8430 otm6tm2f21kt9q45m78mq6cr27 Query : use flama_phc
20241126@154902.8480 otm6tm2f21kt9q45m78mq6cr27 Query : select top 1 ~inactivo valor from fl where no = '1626' and estab = 26 order by inactivo desc
20241126@154902.1079 otm6tm2f21kt9q45m78mq6cr27 Query : use flama_phc
20241126@154902.1090 otm6tm2f21kt9q45m78mq6cr27 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -230
20241126@154902.1423 otm6tm2f21kt9q45m78mq6cr27 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3531';
20241126@154902.1472 otm6tm2f21kt9q45m78mq6cr27 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3531';

20241126@182253.5520 ff3d7vfaqgpsthv03ejuo6hu3h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3532';
20241126@182253.5583 ff3d7vfaqgpsthv03ejuo6hu3h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3532';
20241126@182253.5618 ff3d7vfaqgpsthv03ejuo6hu3h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3532';
20241126@182253.5677 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182253.5681 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241126@182253.6948 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182253.6952 ff3d7vfaqgpsthv03ejuo6hu3h Query : select no, estab,szadrsdesc from szadrs where u_coddest=2117
20241126@182253.7264 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20241126@182253.7467 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407904 and bi.ref ='324.1805.00.1' and bi.lordem =1
20241126@182253.7894 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20241126@182253.7918 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407904 and bi.ref ='324.1805.00.1' and bi.lordem =1
20241126@182253.7935 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182253.7939 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241126@182253.8149 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182253.8153 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 1 valor from td where td.ndoc = 39
20241126@182253.8259 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182253.8262 ff3d7vfaqgpsthv03ejuo6hu3h 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')
20241126@182253.8344 ff3d7vfaqgpsthv03ejuo6hu3h 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
20241126@182253.8581 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182253.8584 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 ~inactivo valor from cl where no = '102420' and estab = 0 order by inactivo desc
20241126@182253.8719 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182253.8723 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241126@182253.9347 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182253.9353 ff3d7vfaqgpsthv03ejuo6hu3h Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241126@182253.9462 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182253.9465 ff3d7vfaqgpsthv03ejuo6hu3h Query : select szadrsstamp valor from szadrs where szadrsdesc='ri - eletrodomesticos lda'
20241126@182253.9515 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182253.9519 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from td where ndoc = 39
20241126@182253.9659 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241126@182253.9744 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.1030 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241126@182254.1830 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.2020 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241126@182254.2380 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.2790 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241126@182254.2940 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241126@182254.4940 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241126@182254.6110 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.6290 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241126@182254.6780 ff3d7vfaqgpsthv03ejuo6hu3h Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6746140327674611fe07' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241126@182254.1034 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.1058 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241126@182254.1099 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241126@182254.1205 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241126@182254.1308 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241126@182254.1426 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241126@182254.1512 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241126@182254.1588 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241126@182254.1665 ff3d7vfaqgpsthv03ejuo6hu3h Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6746140327674611fe07',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241126@182254.2359 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 fno valor from wsftdata order by fno desc
20241126@182254.2708 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.2730 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241126@182254.2759 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 'normal' from dummy
20241126@182254.2826 ff3d7vfaqgpsthv03ejuo6hu3h Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6746140327674611fe07',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2065,102420,0,'2024-11-26',39,'euro',0,0,2024 ,?,?)
20241126@182254.3458 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182254.3462 ff3d7vfaqgpsthv03ejuo6hu3h Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20241126@182254.3605 ff3d7vfaqgpsthv03ejuo6hu3h 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.1805.00.1'
20241126@182254.3773 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.3795 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@182254.3825 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.3840 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@182254.3851 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@182254.3982 ff3d7vfaqgpsthv03ejuo6hu3h Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400291200a'
20241126@182254.4067 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.4086 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@182254.4100 ff3d7vfaqgpsthv03ejuo6hu3h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6746123707674611fe63','aut6746140327674611fe07' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@182254.4160 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.4178 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@182254.4214 ff3d7vfaqgpsthv03ejuo6hu3h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6746123707674611fe63',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6746140327674611fe07' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241126@182254.4877 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182254.4881 ff3d7vfaqgpsthv03ejuo6hu3h Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20241126@182254.4908 ff3d7vfaqgpsthv03ejuo6hu3h 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.1805.00.1'
20241126@182254.4927 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.4948 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@182254.4978 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.4995 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@182254.5079 ff3d7vfaqgpsthv03ejuo6hu3h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241126@182254.5094 ff3d7vfaqgpsthv03ejuo6hu3h Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400291200a'
20241126@182254.5111 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.5129 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241126@182254.5145 ff3d7vfaqgpsthv03ejuo6hu3h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6746161079674611fe7c','aut6746140327674611fe07' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241126@182254.5150 ff3d7vfaqgpsthv03ejuo6hu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241126@182254.5166 ff3d7vfaqgpsthv03ejuo6hu3h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241126@182254.5197 ff3d7vfaqgpsthv03ejuo6hu3h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6746161079674611fe7c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6746140327674611fe07' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241126@182254.5517 ff3d7vfaqgpsthv03ejuo6hu3h Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6746140327674611fe07','2407904','wait',39,'adm09112754980.682000002')
20241126@182254.5609 ff3d7vfaqgpsthv03ejuo6hu3h Query : use flama_phc
20241126@182254.5613 ff3d7vfaqgpsthv03ejuo6hu3h Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241126@182254.5647 ff3d7vfaqgpsthv03ejuo6hu3h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3532';
20241126@182254.5687 ff3d7vfaqgpsthv03ejuo6hu3h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3532';
20241126@182254.5737 ff3d7vfaqgpsthv03ejuo6hu3h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3532';
20241126@182254.5771 ff3d7vfaqgpsthv03ejuo6hu3h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3532';
20241126@182254.6410 mm4e7audr2lv4thdot305u2bo9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241126@182254.6422 mm4e7audr2lv4thdot305u2bo9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241126@182254.6500 mm4e7audr2lv4thdot305u2bo9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3533';
20241126@182254.6566 mm4e7audr2lv4thdot305u2bo9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3533';
20241126@182254.6628 mm4e7audr2lv4thdot305u2bo9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3533';
20241126@182254.6662 mm4e7audr2lv4thdot305u2bo9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3533';
20241126@182254.6725 mm4e7audr2lv4thdot305u2bo9 Query : use flama_phc
20241126@182254.6728 mm4e7audr2lv4thdot305u2bo9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241126@182254.6800 mm4e7audr2lv4thdot305u2bo9 Query : use flama_phc
20241126@182254.6804 mm4e7audr2lv4thdot305u2bo9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4804
20241126@182254.6899 mm4e7audr2lv4thdot305u2bo9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4980.00.1'
20241126@182254.7078 mm4e7audr2lv4thdot305u2bo9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407906 and bi.ref ='324.4980.00.1' and bi.lordem =1
20241126@182254.7527 mm4e7audr2lv4thdot305u2bo9 Query : use flama_phc
20241126@182254.7531 mm4e7audr2lv4thdot305u2bo9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241126@182254.7565 mm4e7audr2lv4thdot305u2bo9 Query : use flama_phc
20241126@182254.7568 mm4e7audr2lv4thdot305u2bo9 Query : select top 1 1 valor from td where td.ndoc = 39
20241126@182254.7624 mm4e7audr2lv4thdot305u2bo9 Query : use flama_phc
20241126@182254.7628 mm4e7audr2lv4thdot305u2bo9 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')
20241126@182254.7656 mm4e7audr2lv4thdot305u2bo9 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
20241126@182254.7693 mm4e7audr2lv4thdot305u2bo9 Query : use flama_phc
20241126@182254.7697 mm4e7audr2lv4thdot305u2bo9 Query : select top 1 ~inactivo valor from cl where no = '101900' and estab = 0 order by inactivo desc
20241126@182254.9174 mm4e7audr2lv4thdot305u2bo9 Query : use flama_phc
20241126@182254.9178 mm4e7audr2lv4thdot305u2bo9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241126@182254.9217 mm4e7audr2lv4thdot305u2bo9 Query : use flama_phc
20241126@182254.9220 mm4e7audr2lv4thdot305u2bo9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241126@182254.9264 mm4e7audr2lv4thdot305u2bo9 Query : use flama_phc
20241126@182254.9268 mm4e7audr2lv4thdot305u2bo9 Query : select szadrsstamp valor from szadrs where szadrsdesc='101900 - pd - alfena n/p'
20241126@182254.9318 mm4e7audr2lv4thdot305u2bo9 Query : use flama_phc
20241126@182254.9321 mm4e7audr2lv4thdot305u2bo9 Query : select 1 valor from td where ndoc = 39
20241126@182254.9336 mm4e7audr2lv4thdot305u2bo9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
