20241206@150841.8429 qct6dqus4aln1q22kgetr7h3rg Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241206@150841.8475 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.657.00.01'
20241206@150841.8667 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408320 and bi.ref ='324.657.00.01' and bi.lordem =1
20241206@150841.9062 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.657.00.01'
20241206@150841.9152 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408320 and bi.ref ='324.657.00.01' and bi.lordem =1
20241206@150841.9171 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.657.00.01'
20241206@150841.9191 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408320 and bi.ref ='324.657.00.01' and bi.lordem =1
20241206@150841.9221 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.657.00.01'
20241206@150841.9241 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408320 and bi.ref ='324.657.00.01' and bi.lordem =1
20241206@150841.9258 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.657.00.01'
20241206@150841.9277 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408320 and bi.ref ='324.657.00.01' and bi.lordem =1
20241206@150841.9293 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.657.00.01'
20241206@150841.9312 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408320 and bi.ref ='324.657.00.01' and bi.lordem =1
20241206@150841.9329 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.657.00.01'
20241206@150841.9349 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408320 and bi.ref ='324.657.00.01' and bi.lordem =1
20241206@150841.9366 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.657.00.01'
20241206@150841.9393 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408320 and bi.ref ='324.657.00.01' and bi.lordem =1
20241206@150841.9410 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.657.00.01'
20241206@150841.9430 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408320 and bi.ref ='324.657.00.01' and bi.lordem =1
20241206@150841.9446 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.657.00.01'
20241206@150841.9466 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408320 and bi.ref ='324.657.00.01' and bi.lordem =1
20241206@150841.9483 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150841.9486 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241206@150841.9519 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150841.9522 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 1 valor from td where td.ndoc = 39
20241206@150841.9551 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150841.9554 qct6dqus4aln1q22kgetr7h3rg 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')
20241206@150841.9587 qct6dqus4aln1q22kgetr7h3rg 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
20241206@150841.9623 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150841.9626 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241206@150841.9657 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150841.9660 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241206@150841.9692 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150841.9695 qct6dqus4aln1q22kgetr7h3rg Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241206@150841.9741 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150841.9743 qct6dqus4aln1q22kgetr7h3rg Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241206@150841.9788 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150841.9791 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from td where ndoc = 39
20241206@150841.9803 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241206@150841.9818 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150841.9836 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241206@150841.9857 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150841.9872 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241206@150841.9908 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150841.9922 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241206@150841.9934 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241206@150841.9991 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241206@150842.4000 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.2100 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241206@150842.3700 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241206@150842.2080 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.2270 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241206@150842.2710 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241206@150842.2830 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241206@150842.2950 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241206@150842.3070 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241206@150842.3200 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241206@150842.3320 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241206@150842.3450 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675318438767531379f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241206@150842.5730 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 fno valor from wsftdata order by fno desc
20241206@150842.6050 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.6230 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241206@150842.6500 qct6dqus4aln1q22kgetr7h3rg Query : select 'normal' from dummy
20241206@150842.6660 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675318438767531379f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2271,100810,0,'2024-12-06',39,'euro',0,0,2024 ,?,?)
20241206@150842.9510 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150842.9540 qct6dqus4aln1q22kgetr7h3rg Query : select st.usalote valor from st where st.ref = '324.657.00.01'
20241206@150842.9770 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.657.00.01'
20241206@150842.1159 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.1178 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.1205 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.1221 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.1230 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.1252 qct6dqus4aln1q22kgetr7h3rg Query : select sestamp valor from se where ref ='324.657.00.01' and lote = 'r2400226200a'
20241206@150842.1268 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.1283 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.1295 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531338926753137a1e','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.1300 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.1315 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.1343 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531338926753137a1e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut675318438767531379f2' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241206@150842.1586 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.1604 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.1631 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.1646 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.1655 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.1680 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.1696 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.1708 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531464676753137a29','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.1712 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.1727 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.1756 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67531464676753137a29',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675318438767531379f2' ,0,0 ,2,23.00,20000,?,?,?)
20241206@150842.2019 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150842.2022 qct6dqus4aln1q22kgetr7h3rg Query : select st.usalote valor from st where st.ref = '324.657.00.01'
20241206@150842.2043 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.657.00.01'
20241206@150842.2060 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.2080 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.2121 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.2137 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.2147 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.2160 qct6dqus4aln1q22kgetr7h3rg Query : select sestamp valor from se where ref ='324.657.00.01' and lote = 'r2400226200a'
20241206@150842.2175 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.2193 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.2206 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531659946753137a35','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.2211 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.2229 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.2265 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531659946753137a35',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut675318438767531379f2' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241206@150842.2508 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.2525 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.2550 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.2564 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.2575 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.2617 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.2640 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.2655 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531600006753137a3f','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.2659 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.2677 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.2713 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67531600006753137a3f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675318438767531379f2' ,0,0 ,2,23.00,50000,?,?,?)
20241206@150842.2953 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150842.2957 qct6dqus4aln1q22kgetr7h3rg Query : select st.usalote valor from st where st.ref = '324.657.00.01'
20241206@150842.2982 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.657.00.01'
20241206@150842.2999 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.3017 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.3064 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.3082 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.3092 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.3108 qct6dqus4aln1q22kgetr7h3rg Query : select sestamp valor from se where ref ='324.657.00.01' and lote = 'r2400226200a'
20241206@150842.3123 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.3143 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.3158 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531151576753137a4c','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.3163 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.3181 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.3218 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531151576753137a4c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut675318438767531379f2' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241206@150842.3465 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.3485 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.3517 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.3553 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.3564 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.3580 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.3598 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.3612 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531484576753137a57','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.3617 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.3635 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.3671 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67531484576753137a57',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675318438767531379f2' ,0,0 ,2,23.00,80000,?,?,?)
20241206@150842.3993 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150842.4030 qct6dqus4aln1q22kgetr7h3rg Query : select st.usalote valor from st where st.ref = '324.657.00.01'
20241206@150842.4244 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.657.00.01'
20241206@150842.4266 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.4283 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.4320 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.4337 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.4346 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.4511 qct6dqus4aln1q22kgetr7h3rg Query : select sestamp valor from se where ref ='324.657.00.01' and lote = 'r2400226200a'
20241206@150842.4526 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.4542 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.4555 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531063856753137a6e','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.4560 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.4602 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.4630 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531063856753137a6e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut675318438767531379f2' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241206@150842.4877 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.4898 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.4925 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.4940 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.4949 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.4961 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.4975 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.4988 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531389856753137a79','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.4992 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.5007 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.5036 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67531389856753137a79',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675318438767531379f2' ,0,0 ,2,23.00,110000,?,?,?)
20241206@150842.5277 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150842.5281 qct6dqus4aln1q22kgetr7h3rg Query : select st.usalote valor from st where st.ref = '324.657.00.01'
20241206@150842.5301 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.657.00.01'
20241206@150842.5315 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.5331 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.5358 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.5373 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.5382 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.5394 qct6dqus4aln1q22kgetr7h3rg Query : select sestamp valor from se where ref ='324.657.00.01' and lote = 'r2400226200a'
20241206@150842.5427 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.5443 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.5456 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531796886753137a84','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.5461 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.5483 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.5512 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531796886753137a84',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut675318438767531379f2' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241206@150842.5744 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.5761 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.5788 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.5804 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.5813 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.5826 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.5840 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.5852 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531803556753137a8e','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.5857 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.5871 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.5898 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67531803556753137a8e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675318438767531379f2' ,0,0 ,2,23.00,140000,?,?,?)
20241206@150842.6128 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150842.6131 qct6dqus4aln1q22kgetr7h3rg Query : select st.usalote valor from st where st.ref = '324.657.00.01'
20241206@150842.6151 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.657.00.01'
20241206@150842.6164 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.6181 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.6206 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.6222 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.6231 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.6244 qct6dqus4aln1q22kgetr7h3rg Query : select sestamp valor from se where ref ='324.657.00.01' and lote = 'r2400226200a'
20241206@150842.6259 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.6274 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.6286 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531548586753137a98','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.6291 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.6311 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.7549 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531548586753137a98',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut675318438767531379f2' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20241206@150842.7814 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.7831 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.7860 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.7876 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.7885 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.7902 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.7918 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.7933 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531444466753137ac0','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.7938 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.7955 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.7993 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67531444466753137ac0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675318438767531379f2' ,0,0 ,2,23.00,170000,?,?,?)
20241206@150842.8220 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150842.8224 qct6dqus4aln1q22kgetr7h3rg Query : select st.usalote valor from st where st.ref = '324.657.00.01'
20241206@150842.8247 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.657.00.01'
20241206@150842.8262 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.8279 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.8322 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.8338 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.8347 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.8360 qct6dqus4aln1q22kgetr7h3rg Query : select sestamp valor from se where ref ='324.657.00.01' and lote = 'r2400226200a'
20241206@150842.8374 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.8389 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.8402 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531456746753137acc','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.8407 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.8424 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.8506 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531456746753137acc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut675318438767531379f2' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20241206@150842.8820 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.8838 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.8869 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.8884 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.8895 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.8910 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.8926 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.8939 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531759796753137ad9','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.8944 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.8960 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.9000 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67531759796753137ad9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675318438767531379f2' ,0,0 ,2,23.00,200000,?,?,?)
20241206@150842.9237 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150842.9241 qct6dqus4aln1q22kgetr7h3rg Query : select st.usalote valor from st where st.ref = '324.657.00.01'
20241206@150842.9267 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.657.00.01'
20241206@150842.9283 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.9300 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.9340 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.9357 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.9367 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.9389 qct6dqus4aln1q22kgetr7h3rg Query : select sestamp valor from se where ref ='324.657.00.01' and lote = 'r2400226200a'
20241206@150842.9405 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.9424 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.9437 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531390206753137ae5','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.9441 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.9459 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.9497 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531390206753137ae5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut675318438767531379f2' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20241206@150842.9775 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.9798 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.9841 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.9858 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.9867 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150842.9879 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.9893 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150842.9905 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531980346753137af1','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150842.9909 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150842.9927 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150842.9957 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67531980346753137af1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675318438767531379f2' ,0,0 ,2,23.00,230000,?,?,?)
20241206@150843.2360 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150843.2400 qct6dqus4aln1q22kgetr7h3rg Query : select st.usalote valor from st where st.ref = '324.657.00.01'
20241206@150843.2640 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.657.00.01'
20241206@150843.2890 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.3100 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150843.3400 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.3550 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150843.3650 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150843.3780 qct6dqus4aln1q22kgetr7h3rg Query : select sestamp valor from se where ref ='324.657.00.01' and lote = 'r2400226200a'
20241206@150843.3900 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.4050 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150843.4170 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531753826753137b09','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150843.4220 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.4460 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150843.4760 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531753826753137b09',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut675318438767531379f2' ,0,0 ,2,23.00,250000,?,?,?,?,?)
20241206@150843.7250 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.7470 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150843.7760 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.8030 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150843.8130 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150843.8280 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.8430 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150843.8610 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531585706753137b14','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150843.8660 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.8900 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150843.9260 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67531585706753137b14',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675318438767531379f2' ,0,0 ,2,23.00,260000,?,?,?)
20241206@150843.1239 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150843.1257 qct6dqus4aln1q22kgetr7h3rg Query : select st.usalote valor from st where st.ref = '324.657.00.01'
20241206@150843.1362 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.657.00.01'
20241206@150843.1382 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.1408 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150843.1433 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.1448 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150843.1460 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150843.1472 qct6dqus4aln1q22kgetr7h3rg Query : select sestamp valor from se where ref ='324.657.00.01' and lote = 'r2400226200a'
20241206@150843.1485 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.1501 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150843.1513 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531731136753137b24','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150843.1518 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.1533 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150843.1573 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531731136753137b24',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut675318438767531379f2' ,0,0 ,2,23.00,280000,?,?,?,?,?)
20241206@150843.1814 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.1874 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150843.1932 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.1950 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150843.1960 qct6dqus4aln1q22kgetr7h3rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150843.1988 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.2007 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150843.2020 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531023126753137b30','aut675318438767531379f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150843.2025 qct6dqus4aln1q22kgetr7h3rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.2040 qct6dqus4aln1q22kgetr7h3rg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150843.2089 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67531023126753137b30',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675318438767531379f2' ,0,0 ,2,23.00,290000,?,?,?)
20241206@150843.2340 qct6dqus4aln1q22kgetr7h3rg Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675318438767531379f2','2408320','wait',39,'adm09112754980.682000002')
20241206@150843.2453 qct6dqus4aln1q22kgetr7h3rg Query : use flama_phc
20241206@150843.2457 qct6dqus4aln1q22kgetr7h3rg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241206@150843.2498 qct6dqus4aln1q22kgetr7h3rg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3762';
20241206@150843.2544 qct6dqus4aln1q22kgetr7h3rg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3762';
20241206@150843.2596 qct6dqus4aln1q22kgetr7h3rg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3762';
20241206@150843.2634 qct6dqus4aln1q22kgetr7h3rg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3762';
20241206@150843.3277 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241206@150843.3293 fe2eerdui5fp5enoq7j44hqkt9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241206@150843.3366 fe2eerdui5fp5enoq7j44hqkt9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3763';
20241206@150843.3436 fe2eerdui5fp5enoq7j44hqkt9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3763';
20241206@150843.3504 fe2eerdui5fp5enoq7j44hqkt9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3763';
20241206@150843.3541 fe2eerdui5fp5enoq7j44hqkt9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3763';
20241206@150843.3601 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150843.3605 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241206@150843.3688 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150843.3693 fe2eerdui5fp5enoq7j44hqkt9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6917
20241206@150843.3798 fe2eerdui5fp5enoq7j44hqkt9 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'
20241206@150843.3988 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408327 and bi.ref ='324.600.94.01' and bi.lordem =1
20241206@150843.4388 fe2eerdui5fp5enoq7j44hqkt9 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'
20241206@150843.4754 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408327 and bi.ref ='324.2000.94.1' and bi.lordem =2
20241206@150843.5124 fe2eerdui5fp5enoq7j44hqkt9 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'
20241206@150843.5316 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408327 and bi.ref ='324.900.94.01' and bi.lordem =3
20241206@150843.5668 fe2eerdui5fp5enoq7j44hqkt9 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'
20241206@150843.5849 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408327 and bi.ref ='324.700.94.01' and bi.lordem =4
20241206@150843.6297 fe2eerdui5fp5enoq7j44hqkt9 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'
20241206@150843.6549 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408327 and bi.ref ='324.2200.94.1' and bi.lordem =5
20241206@150843.6948 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150843.6952 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241206@150843.6987 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150843.6990 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 1 valor from td where td.ndoc = 39
20241206@150843.7025 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150843.7028 fe2eerdui5fp5enoq7j44hqkt9 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')
20241206@150843.7059 fe2eerdui5fp5enoq7j44hqkt9 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
20241206@150843.7098 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150843.7101 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 ~inactivo valor from cl where no = '199800' and estab = 0 order by inactivo desc
20241206@150843.7252 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150843.7256 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241206@150843.7290 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150843.7293 fe2eerdui5fp5enoq7j44hqkt9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241206@150843.7344 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150843.7347 fe2eerdui5fp5enoq7j44hqkt9 Query : select szadrsstamp valor from szadrs where szadrsdesc='740 ent vnr bligeiro'
20241206@150843.7407 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150843.7410 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from td where ndoc = 39
20241206@150843.7424 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241206@150843.7440 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.7460 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241206@150843.7481 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.7497 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241206@150843.7536 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.7799 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241206@150843.8027 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241206@150843.8090 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241206@150843.8104 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.8121 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241206@150843.8142 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67531082076753137bc3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241206@150843.8359 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.8380 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241206@150843.8419 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241206@150843.8434 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241206@150843.8447 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241206@150843.8461 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241206@150843.8474 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241206@150843.8488 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241206@150843.8503 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67531082076753137bc3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241206@150843.8761 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 fno valor from wsftdata order by fno desc
20241206@150843.8802 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.8823 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241206@150843.8852 fe2eerdui5fp5enoq7j44hqkt9 Query : select 'normal' from dummy
20241206@150843.8871 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67531082076753137bc3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2272,199800,0,'2024-12-06',39,'euro',0,0,2024 ,?,?)
20241206@150843.9169 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150843.9173 fe2eerdui5fp5enoq7j44hqkt9 Query : select st.usalote valor from st where st.ref = '324.600.94.01'
20241206@150843.9201 fe2eerdui5fp5enoq7j44hqkt9 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'
20241206@150843.9392 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.9410 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150843.9439 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.9456 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150843.9465 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150843.9480 fe2eerdui5fp5enoq7j44hqkt9 Query : select sestamp valor from se where ref ='324.600.94.01' and lote = 'r2400047200a'
20241206@150843.9501 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.9516 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150843.9528 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531048886753137be7','aut67531082076753137bc3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150843.9533 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.9566 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150843.9596 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531048886753137be7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut67531082076753137bc3' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241206@150843.9854 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150843.9876 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150843.9905 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.1044 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150844.1057 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150844.1072 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.1089 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150844.1102 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531091056753137c1a','aut67531082076753137bc3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150844.1107 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.1123 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150844.1152 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67531091056753137c1a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67531082076753137bc3' ,0,0 ,2,23.00,20000,?,?,?)
20241206@150844.1385 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150844.1388 fe2eerdui5fp5enoq7j44hqkt9 Query : select st.usalote valor from st where st.ref = '324.2000.94.1'
20241206@150844.1409 fe2eerdui5fp5enoq7j44hqkt9 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'
20241206@150844.1579 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.1606 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150844.1633 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.1648 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150844.1657 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150844.1670 fe2eerdui5fp5enoq7j44hqkt9 Query : select sestamp valor from se where ref ='324.2000.94.1' and lote = 'r2300916200a'
20241206@150844.1691 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.1708 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150844.1720 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531814356753137c29','aut67531082076753137bc3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150844.1725 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.1742 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150844.1770 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531814356753137c29',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut67531082076753137bc3' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241206@150844.2075 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150844.2078 fe2eerdui5fp5enoq7j44hqkt9 Query : select st.usalote valor from st where st.ref = '324.900.94.01'
20241206@150844.2100 fe2eerdui5fp5enoq7j44hqkt9 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'
20241206@150844.2293 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.2312 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150844.2339 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.2357 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150844.2367 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150844.2381 fe2eerdui5fp5enoq7j44hqkt9 Query : select sestamp valor from se where ref ='324.900.94.01' and lote = 'r2300952200a'
20241206@150844.2406 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.2422 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150844.2437 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531124536753137c3a','aut67531082076753137bc3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150844.2442 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.2460 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150844.2489 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531124536753137c3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut67531082076753137bc3' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241206@150844.2757 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150844.2760 fe2eerdui5fp5enoq7j44hqkt9 Query : select st.usalote valor from st where st.ref = '324.700.94.01'
20241206@150844.2783 fe2eerdui5fp5enoq7j44hqkt9 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'
20241206@150844.2961 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.2979 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150844.3006 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.3022 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150844.3031 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150844.3046 fe2eerdui5fp5enoq7j44hqkt9 Query : select sestamp valor from se where ref ='324.700.94.01' and lote = 'r2300913100a'
20241206@150844.3061 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.3079 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150844.3092 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531943766753137c4a','aut67531082076753137bc3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150844.3097 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.3113 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150844.3148 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531943766753137c4a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut67531082076753137bc3' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241206@150844.3453 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150844.3456 fe2eerdui5fp5enoq7j44hqkt9 Query : select st.usalote valor from st where st.ref = '324.2200.94.1'
20241206@150844.3488 fe2eerdui5fp5enoq7j44hqkt9 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'
20241206@150844.3958 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.3983 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150844.4052 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.4096 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150844.4107 fe2eerdui5fp5enoq7j44hqkt9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150844.4150 fe2eerdui5fp5enoq7j44hqkt9 Query : select sestamp valor from se where ref ='324.2200.94.1' and lote = 'r2400046200a'
20241206@150844.4453 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.4585 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150844.4598 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531922206753137c6c','aut67531082076753137bc3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150844.4603 fe2eerdui5fp5enoq7j44hqkt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150844.4620 fe2eerdui5fp5enoq7j44hqkt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150844.4648 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531922206753137c6c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',9.000 ,'aut67531082076753137bc3' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241206@150844.5011 fe2eerdui5fp5enoq7j44hqkt9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67531082076753137bc3','2408327','wait',39,'adm09112754980.682000002')
20241206@150844.5118 fe2eerdui5fp5enoq7j44hqkt9 Query : use flama_phc
20241206@150844.5121 fe2eerdui5fp5enoq7j44hqkt9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241206@150844.5151 fe2eerdui5fp5enoq7j44hqkt9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3763';
20241206@150844.5191 fe2eerdui5fp5enoq7j44hqkt9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3763';
20241206@150844.5240 fe2eerdui5fp5enoq7j44hqkt9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3763';
20241206@150844.5272 fe2eerdui5fp5enoq7j44hqkt9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3763';
20241206@150844.7130 4u6vgk3mckjblekackc2aqcau4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241206@150844.7142 4u6vgk3mckjblekackc2aqcau4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241206@150844.7213 4u6vgk3mckjblekackc2aqcau4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3764';
20241206@150844.7293 4u6vgk3mckjblekackc2aqcau4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3764';
20241206@150844.7359 4u6vgk3mckjblekackc2aqcau4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3764';
20241206@150844.7394 4u6vgk3mckjblekackc2aqcau4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3764';
20241206@150844.7452 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150844.7455 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241206@150844.7521 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150844.7524 4u6vgk3mckjblekackc2aqcau4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=672
20241206@150844.7624 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241206@150844.7874 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408330 and bi.ref ='324.2326.00.1' and bi.lordem =1
20241206@150844.8255 4u6vgk3mckjblekackc2aqcau4 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'
20241206@150844.8430 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408330 and bi.ref ='324.1332.00.1' and bi.lordem =2
20241206@150844.8801 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2340.00.1'
20241206@150844.8980 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408330 and bi.ref ='324.2340.00.1' and bi.lordem =3
20241206@150845.3840 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150845.3900 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241206@150845.4280 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150845.4320 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 1 valor from td where td.ndoc = 39
20241206@150845.4680 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150845.4710 4u6vgk3mckjblekackc2aqcau4 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')
20241206@150845.5010 4u6vgk3mckjblekackc2aqcau4 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
20241206@150845.5390 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150845.5420 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 ~inactivo valor from cl where no = '101826' and estab = 0 order by inactivo desc
20241206@150845.6850 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150845.6880 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241206@150845.7190 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150845.7220 4u6vgk3mckjblekackc2aqcau4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241206@150845.7660 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150845.7690 4u6vgk3mckjblekackc2aqcau4 Query : select szadrsstamp valor from szadrs where szadrsdesc='frigil-gilberto vieira seco, lda'
20241206@150845.8140 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150845.8170 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from td where ndoc = 39
20241206@150845.8300 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241206@150845.8440 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.8610 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241206@150845.8800 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.8940 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241206@150845.9230 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.9380 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241206@150845.9510 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241206@150845.1007 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241206@150845.1020 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.1035 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241206@150845.1060 4u6vgk3mckjblekackc2aqcau4 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67531462446753137d17' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241206@150845.1229 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.1248 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241206@150845.1285 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241206@150845.1298 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241206@150845.1310 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241206@150845.1396 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241206@150845.1410 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241206@150845.1426 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241206@150845.1458 4u6vgk3mckjblekackc2aqcau4 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67531462446753137d17',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241206@150845.1987 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 fno valor from wsftdata order by fno desc
20241206@150845.2026 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.2046 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241206@150845.2075 4u6vgk3mckjblekackc2aqcau4 Query : select 'normal' from dummy
20241206@150845.2102 4u6vgk3mckjblekackc2aqcau4 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67531462446753137d17',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2273,101826,0,'2024-12-06',39,'euro',0,0,2024 ,?,?)
20241206@150845.2403 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150845.2407 4u6vgk3mckjblekackc2aqcau4 Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241206@150845.2430 4u6vgk3mckjblekackc2aqcau4 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.2326.00.1'
20241206@150845.2784 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.2982 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150845.3010 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.3053 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150845.3189 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150845.3318 4u6vgk3mckjblekackc2aqcau4 Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2200247200a'
20241206@150845.3369 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.3404 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150845.3455 4u6vgk3mckjblekackc2aqcau4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531973906753137d52','aut67531462446753137d17' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150845.3503 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.3532 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150845.3562 4u6vgk3mckjblekackc2aqcau4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531973906753137d52',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67531462446753137d17' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241206@150845.3803 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150845.3806 4u6vgk3mckjblekackc2aqcau4 Query : select st.usalote valor from st where st.ref = '324.1332.00.1'
20241206@150845.3829 4u6vgk3mckjblekackc2aqcau4 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'
20241206@150845.3997 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.4013 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150845.4040 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.4065 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150845.4074 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150845.4087 4u6vgk3mckjblekackc2aqcau4 Query : select sestamp valor from se where ref ='324.1332.00.1' and lote = 'r2400759200a'
20241206@150845.4108 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.4124 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150845.4137 4u6vgk3mckjblekackc2aqcau4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531162316753137d64','aut67531462446753137d17' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150845.4142 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.4160 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150845.4192 4u6vgk3mckjblekackc2aqcau4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531162316753137d64',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67531462446753137d17' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241206@150845.4446 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150845.4450 4u6vgk3mckjblekackc2aqcau4 Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20241206@150845.4477 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2340.00.1'
20241206@150845.4651 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.4671 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150845.4700 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.4723 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150845.4733 4u6vgk3mckjblekackc2aqcau4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150845.4746 4u6vgk3mckjblekackc2aqcau4 Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20241206@150845.4768 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.4784 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150845.4797 4u6vgk3mckjblekackc2aqcau4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531451496753137d74','aut67531462446753137d17' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150845.4801 4u6vgk3mckjblekackc2aqcau4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.4817 4u6vgk3mckjblekackc2aqcau4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150845.4847 4u6vgk3mckjblekackc2aqcau4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531451496753137d74',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67531462446753137d17' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241206@150845.5261 4u6vgk3mckjblekackc2aqcau4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67531462446753137d17','2408330','wait',39,'adm09112754980.682000002')
20241206@150845.5371 4u6vgk3mckjblekackc2aqcau4 Query : use flama_phc
20241206@150845.5384 4u6vgk3mckjblekackc2aqcau4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241206@150845.5416 4u6vgk3mckjblekackc2aqcau4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3764';
20241206@150845.5466 4u6vgk3mckjblekackc2aqcau4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3764';
20241206@150845.5518 4u6vgk3mckjblekackc2aqcau4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3764';
20241206@150845.5558 4u6vgk3mckjblekackc2aqcau4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3764';
20241206@150845.6197 bi0aplpsaj45msu81advpphv4k Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241206@150845.6210 bi0aplpsaj45msu81advpphv4k Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241206@150845.6292 bi0aplpsaj45msu81advpphv4k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3765';
20241206@150845.6381 bi0aplpsaj45msu81advpphv4k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3765';
20241206@150845.6448 bi0aplpsaj45msu81advpphv4k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3765';
20241206@150845.6499 bi0aplpsaj45msu81advpphv4k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3765';
20241206@150845.6558 bi0aplpsaj45msu81advpphv4k Query : use flama_phc
20241206@150845.6561 bi0aplpsaj45msu81advpphv4k Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241206@150845.6625 bi0aplpsaj45msu81advpphv4k Query : use flama_phc
20241206@150845.6628 bi0aplpsaj45msu81advpphv4k Query : select no, estab,szadrsdesc from szadrs where u_coddest=832
20241206@150845.6737 bi0aplpsaj45msu81advpphv4k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4901.00.1'
20241206@150845.6936 bi0aplpsaj45msu81advpphv4k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408331 and bi.ref ='324.4901.00.1' and bi.lordem =1
20241206@150845.9063 bi0aplpsaj45msu81advpphv4k Query : use flama_phc
20241206@150845.9070 bi0aplpsaj45msu81advpphv4k Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241206@150845.9112 bi0aplpsaj45msu81advpphv4k Query : use flama_phc
20241206@150845.9117 bi0aplpsaj45msu81advpphv4k Query : select top 1 1 valor from td where td.ndoc = 39
20241206@150845.9154 bi0aplpsaj45msu81advpphv4k Query : use flama_phc
20241206@150845.9158 bi0aplpsaj45msu81advpphv4k 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')
20241206@150845.9194 bi0aplpsaj45msu81advpphv4k 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
20241206@150845.9230 bi0aplpsaj45msu81advpphv4k Query : use flama_phc
20241206@150845.9233 bi0aplpsaj45msu81advpphv4k Query : select top 1 ~inactivo valor from cl where no = '101726' and estab = 0 order by inactivo desc
20241206@150845.9376 bi0aplpsaj45msu81advpphv4k Query : use flama_phc
20241206@150845.9382 bi0aplpsaj45msu81advpphv4k Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241206@150845.9413 bi0aplpsaj45msu81advpphv4k Query : use flama_phc
20241206@150845.9416 bi0aplpsaj45msu81advpphv4k Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241206@150845.9455 bi0aplpsaj45msu81advpphv4k Query : use flama_phc
20241206@150845.9458 bi0aplpsaj45msu81advpphv4k Query : select szadrsstamp valor from szadrs where szadrsdesc='rick & mark - a mobiladora de padronelo,lda'
20241206@150845.9513 bi0aplpsaj45msu81advpphv4k Query : use flama_phc
20241206@150845.9515 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from td where ndoc = 39
20241206@150845.9528 bi0aplpsaj45msu81advpphv4k Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241206@150845.9543 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.9560 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241206@150845.9580 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.9597 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241206@150845.9632 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.9650 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241206@150845.9664 bi0aplpsaj45msu81advpphv4k Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241206@150845.9724 bi0aplpsaj45msu81advpphv4k Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241206@150845.9738 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150845.9813 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241206@150845.9829 bi0aplpsaj45msu81advpphv4k Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67531624726753137deb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241206@150846.2050 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.3090 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241206@150846.4840 bi0aplpsaj45msu81advpphv4k Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241206@150846.4970 bi0aplpsaj45msu81advpphv4k Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241206@150846.5100 bi0aplpsaj45msu81advpphv4k Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241206@150846.5220 bi0aplpsaj45msu81advpphv4k Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241206@150846.5340 bi0aplpsaj45msu81advpphv4k Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241206@150846.5460 bi0aplpsaj45msu81advpphv4k Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241206@150846.5570 bi0aplpsaj45msu81advpphv4k Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67531624726753137deb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241206@150846.7840 bi0aplpsaj45msu81advpphv4k Query : select top 1 fno valor from wsftdata order by fno desc
20241206@150846.8870 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.9080 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241206@150846.9490 bi0aplpsaj45msu81advpphv4k Query : select 'normal' from dummy
20241206@150846.9660 bi0aplpsaj45msu81advpphv4k Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67531624726753137deb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2274,101726,0,'2024-12-06',39,'euro',0,0,2024 ,?,?)
20241206@150846.1242 bi0aplpsaj45msu81advpphv4k Query : use flama_phc
20241206@150846.1246 bi0aplpsaj45msu81advpphv4k Query : select st.usalote valor from st where st.ref = '324.4901.00.1'
20241206@150846.1360 bi0aplpsaj45msu81advpphv4k 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.4901.00.1'
20241206@150846.1825 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.1844 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150846.2062 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.2141 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150846.2159 bi0aplpsaj45msu81advpphv4k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150846.2174 bi0aplpsaj45msu81advpphv4k Query : select sestamp valor from se where ref ='324.4901.00.1' and lote = 'r2300206200a'
20241206@150846.2207 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.2227 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150846.2241 bi0aplpsaj45msu81advpphv4k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531218856753137e35','aut67531624726753137deb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150846.2247 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.2265 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150846.2301 bi0aplpsaj45msu81advpphv4k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67531218856753137e35',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut67531624726753137deb' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241206@150846.2563 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.2585 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150846.2622 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.2641 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150846.2655 bi0aplpsaj45msu81advpphv4k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241206@150846.2671 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.2697 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241206@150846.2711 bi0aplpsaj45msu81advpphv4k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67531523176753137e41','aut67531624726753137deb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241206@150846.2716 bi0aplpsaj45msu81advpphv4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.2745 bi0aplpsaj45msu81advpphv4k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241206@150846.2781 bi0aplpsaj45msu81advpphv4k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67531523176753137e41',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67531624726753137deb' ,0,0 ,2,23.00,20000,?,?,?)
20241206@150846.3082 bi0aplpsaj45msu81advpphv4k Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67531624726753137deb','2408331','wait',39,'adm09112754980.682000002')
20241206@150846.3161 bi0aplpsaj45msu81advpphv4k Query : use flama_phc
20241206@150846.3164 bi0aplpsaj45msu81advpphv4k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241206@150846.3211 bi0aplpsaj45msu81advpphv4k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3765';
20241206@150846.3263 bi0aplpsaj45msu81advpphv4k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3765';
20241206@150846.3326 bi0aplpsaj45msu81advpphv4k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3765';
20241206@150846.3364 bi0aplpsaj45msu81advpphv4k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3765';
20241206@150846.4063 en6s80m260u1g8u5qgec4j6cqn Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241206@150846.4077 en6s80m260u1g8u5qgec4j6cqn Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241206@150846.4167 en6s80m260u1g8u5qgec4j6cqn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3766';
20241206@150846.4251 en6s80m260u1g8u5qgec4j6cqn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3766';
20241206@150846.4331 en6s80m260u1g8u5qgec4j6cqn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3766';
20241206@150846.4395 en6s80m260u1g8u5qgec4j6cqn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3766';
20241206@150846.4457 en6s80m260u1g8u5qgec4j6cqn Query : use flama_phc
20241206@150846.4461 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241206@150846.4530 en6s80m260u1g8u5qgec4j6cqn Query : use flama_phc
20241206@150846.4533 en6s80m260u1g8u5qgec4j6cqn Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20241206@150846.4589 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9006.00.1'
20241206@150846.4611 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408333 and bi.ref ='328.9006.00.1' and bi.lordem =1
20241206@150846.4990 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9006.00.1'
20241206@150846.5013 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408333 and bi.ref ='328.9006.00.1' and bi.lordem =1
20241206@150846.5037 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9345.00.1'
20241206@150846.5204 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2083 and bo.obrano = 2408333 and bi.ref ='328.9345.00.1' and bi.lordem =2
20241206@150846.5723 en6s80m260u1g8u5qgec4j6cqn Query : use flama_phc
20241206@150846.5727 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241206@150846.5766 en6s80m260u1g8u5qgec4j6cqn Query : use flama_phc
20241206@150846.5769 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 1 valor from td where td.ndoc = 39
20241206@150846.5799 en6s80m260u1g8u5qgec4j6cqn Query : use flama_phc
20241206@150846.5802 en6s80m260u1g8u5qgec4j6cqn 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')
20241206@150846.5833 en6s80m260u1g8u5qgec4j6cqn 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
20241206@150846.5869 en6s80m260u1g8u5qgec4j6cqn Query : use flama_phc
20241206@150846.5872 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241206@150846.5904 en6s80m260u1g8u5qgec4j6cqn Query : use flama_phc
20241206@150846.5907 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241206@150846.5939 en6s80m260u1g8u5qgec4j6cqn Query : use flama_phc
20241206@150846.5942 en6s80m260u1g8u5qgec4j6cqn Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241206@150846.5984 en6s80m260u1g8u5qgec4j6cqn Query : use flama_phc
20241206@150846.5987 en6s80m260u1g8u5qgec4j6cqn Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20241206@150846.6100 en6s80m260u1g8u5qgec4j6cqn Query : use flama_phc
20241206@150846.6103 en6s80m260u1g8u5qgec4j6cqn Query : select 1 valor from td where ndoc = 39
20241206@150846.6118 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241206@150846.6184 en6s80m260u1g8u5qgec4j6cqn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.6221 en6s80m260u1g8u5qgec4j6cqn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241206@150846.6243 en6s80m260u1g8u5qgec4j6cqn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.6260 en6s80m260u1g8u5qgec4j6cqn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241206@150846.6290 en6s80m260u1g8u5qgec4j6cqn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.6307 en6s80m260u1g8u5qgec4j6cqn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241206@150846.6321 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241206@150846.6381 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241206@150846.6396 en6s80m260u1g8u5qgec4j6cqn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.6414 en6s80m260u1g8u5qgec4j6cqn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241206@150846.6430 en6s80m260u1g8u5qgec4j6cqn Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67531689846753137e9a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241206@150846.6683 en6s80m260u1g8u5qgec4j6cqn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241206@150846.6710 en6s80m260u1g8u5qgec4j6cqn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241206@150846.6747 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241206@150846.6763 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241206@150846.6776 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241206@150846.6789 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241206@150846.6802 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241206@150846.6924 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241206@150846.6938 en6s80m260u1g8u5qgec4j6cqn Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67531689846753137e9a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241206@150846.7288 en6s80m260u1g8u5qgec4j6cqn Query : select top 1 fno valor from wsftdata order by fno desc
